Develop a general-purpose spreadsheet to calculate A out the balance due, principal payment, for interest payment for

Question:

Develop a general-purpose spreadsheet to calculate A out the balance due, principal payment, for interest payment for each period of a loan. The user inputs to the spreadsheet will be the loan amount, the number of payments per year, the number of years payments are made, and the nominal interest rate. Submit printouts of your analysis of a loan in the amount of $15,000 at 8.9% nominal rate for 36 months and for 60 months of payments.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Engineering Economic Analysis

ISBN: 9780195168075

9th Edition

Authors: Donald Newnan, Ted Eschanbach, Jerome Lavelle

Question Posted: