Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help through 18-23 18 You are ready to start completing the loan amortization table. In cell C8, type a reference formula to cell B1.

please help through 18-23 image text in transcribed
image text in transcribed
18 You are ready to start completing the loan amortization table. In cell C8, type a reference formula to cell B1. The balance before the first payment is identical to the loan amount. Do not type the value; use the cell reference instead. In cell c9, subtract the principal from the beginning balance on the previous row. Copy the formula to the range C10:C19. 19 Now, you will calculate the interest for the first payment. In cell D8, calculate the interest for the first payment using the IPMT function. Copy the function to the range D9:D19. 20 Next, you will calculate the principal paid. In cell E8, calculate the principal paid for the first payment using the PPMT function. Copy the function to the range E9:E19. 21 The range D2:E3 contain a summary section for cumulative totals after the first year. 21 The range D2:E3 contain a summary section for cumulative totals after the first year. In cell E2, insert the CUMIPMT function that calculates the cumulative interest after the first year. Use references to cells B8 and B19 for the period arguments. 22 The next summary statistic will calculate the principal paid after the first year. In cell E3, insert the CUMPRINC function that calculates the cumulative principal paid after the first year. Use references to cells B8 and B19 for the period arguments. 23 Rows 22-24 contain a section for what-if analysis. In cell B23, use the RATE financial function to calculate the periodic rate using $1,400 as the monthly payment (cell B22), the NPER, and loan amount in the original input

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions