Question: Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters. In cell


Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters. In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number. In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed. In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15. In cell B12, insert a function to enter the payment date for the next month. Copy the function to the range B13:B15. In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value. In cell Ell, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value. In cell F11, subtract the principal payment in cell Ell from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15. Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file as directed
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
