Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell F6. In cell 15 , calculate the total number of quarterly payments required to pay off Loan Option 3 payments are made at the end of the period. Format the cell as Numberwith 0 decimal place In cell I6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell 15 for the end period argument. Be sure that the result of the function is positive, and then format the cell as Currency. In cell 17 , calculate the total cost of the loan by adding the loan amount in cell 12 to the cumulative interest amount in cell 16 . You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments ar end-of-the-period payments. Be sure that all formulas and functions result in a positive value. To begin, in cell C12, enter a formula that refers to the Loan Amount for Loan Option 3. Format the cell as currency with 0 decimal places. In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started