New Perspectives Excel 365 | Module 9: SAM Project B | StarPower Transportation

Описание: New Perspectives Excel 365 | Module 9: SAM Project B | StarPower Transportation #newperspectives

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6NMKKBK...

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
[email protected]

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.

PROJECT STEPS
1. Paloma Calvo is a financial analyst for StarPower Transportation, an electric vehicle company in Philadelphia, Pennsylvania. She is using an Excel workbook to analyze the financial data for a proposed line of electric buses. She asks for your help in correcting errors and making financial calculations for the new product line.
Go to the Loan Analysis worksheet. The company needs a loan to fund prototypes for the new models of electric buses. Before calculating the principal and interest payments on the loan, Paloma asks you to correct the errors in the worksheet. Correct the first error as follows:
a. In cell H13, use the Error Checking command to identify the error in the cell.
b. Correct the error to total the values in the range C13:G13.
2. Correct the #VALUE! errors in the worksheet as follows:
a. Use Trace Precedents arrows to find the source of the #VALUE! error in cell C16.
b. Correct the formula in cell C16, which should divide the remaining principal (cell C15) by the loan amount (cell B7) to find the percentage of remaining principal.
c. Fill the range D16:G16 with the formula in cell C16 to correct the remaining #VALUE! errors.
d. Remove any remaining trace arrows.
3. Paloma asks you to determine the quarterly payment based on the loan details in the range B7:G7. Calculate the quarterly payment as follows:
a. In cell H7, enter a formula using the PMT function using the rate (cell E7), the nper (cell G7), and the pv (cell B7) provided in the Loan Details section.
b. Insert a negative sign before the PMT function to display a positive result.
4. Paloma also asks you to calculate the annual principal and interest payments for the prototypes and then complete the amortization schedule. Start by calculating the cumulative interest payments as follows:
a. In cell C13, enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan for Year 1 (payment 1 in cell C11 through payment 4 in cell C12). Use 0 as the type argument in your formula because payments are made at the end of the period.
b. Use absolute references for the rate, nper, and pv arguments, which are listed in the range B7:G7.
c. Use relative references for the start and end arguments.
d. Fill the range D13:G13 with the formula in cell C13 to calculate the interest paid in Years 2–5 and the total interest.
5. Calculate the cumulative principal payments as follows:
a. In cell C14, enter a formula using the CUMPRINC function to calculate the cumulative principal paid for Year 1 (payment 1 in cell C11 through payment 4 in cell C12). Use 0 as the type argument in your formula because payments are made at the end of the period.
b. Use absolute references for the rate, nper, and pv arguments, which are listed in the range B7:G7.
c. Use relative references for the start and end arguments.
d. Use a negative sign before CUMPRINC to display the values as positive.
e. Fill the range D14:G14 with the formula in cell C14 to calculate the principal paid in Years 2–5 and the total principal.
6. Complete the amortization schedule as follows:
a. In cell E20, enter a formula using the IPMT function to calculate the interest payment for the first period (Period 1 in cell C20).
b. Use absolute references for the rate, nper, and pv arguments, which are listed in the range B7:G7. Use a relative reference for the per argument.
c. In cell F20, enter a formula using the PPMT function to calculate the principal payment for the first period (Period 1 in cell C20).
d. Use absolute references for the rate, nper, and pv arguments, which are listed in the range B7:G7. Use a relative reference to the per argument.
e. Fill the range E21:F39 with the formulas in the range E20:F20, filling without formatting, to calculate the interest and principal payments paid in Periods 2–20.
7. Go to the Depreciation worksheet. Paloma asks you to correct the errors on this worksheet before performing the depreciation calculations. Correct the errors as follows: