Question: please help using exacl 5. Each payment in a mortgage includes payment towards the principal and payment towards the interest (plus mortgage insurance, an escrow

please help using exacl please help using exacl 5. Each payment in a mortgage includes payment

5. Each payment in a mortgage includes payment towards the principal and payment towards the interest (plus mortgage insurance, an escrow payment for the property tax, and, possibly, some other things). The interest in each payment is the current payoff times the periodic rate. The principal in each payment is the payment minus the interest. The next payoff is the last payoff minus the principal from the current payment. An amortization schedule is a table in which the rows represent the payments, the columns represent: the interest for this payment, the principal for this payment, and the current payoff. Prepare an ExCel (or similar software) file that will allow a user to enter the proceeds of a loan and the annual interest rate which is compounded monthly, and output the amortization schedule for a 15-, 20-, and 30- year mortgage (three separate ExCel sheets)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!