Answered step by step
Verified Expert Solution
Question
1 Approved Answer
amount of principal still 2. A loan amortization table shows the effect of each payment on the amount of prin owed. A worksheet for constructing
amount of principal still 2. A loan amortization table shows the effect of each payment on the amount of prin owed. A worksheet for constructing loan amortization tables for 48-month loans i below. The worksheet has two input cells: (1) the principal of the loan (the originala borrowed) and (2) the annual interest rate. All other numbers in the worksheet are calculator Changing either or both of these input numbers will create a new amortization table. Note that in the table, the amount of interest owed each month is the monthly interest rate times the amount of the principal still owed at the beginning of the month. The amount of the payment that goes to reducing the principal is the amount of the payment that is left over. If all of the calculations are correct, then the principal owed at the end of the forty-eighth month should be 0. $1 rate a) Duplicate the worksheet. Try it on the loan shown in the worksheet and then on a $53,000 loan at 12% and on a $4,000 loan at 2.9%. b) Construct a similar worksheet for 36-month loans. Try the worksheet on the same three sets of data. 5: Loan Amortization - Excel Home Insert Page Layout Formulas Data Review File View Tell me... Sign in 2. Share C D E F Loan Amortization Table for 48 Month Loans Principal: Annual Interest rate: $16,353.00 6.90% Resulting Monthly Interest Rate: Resulting Monthly Payment: 0.575% $390.83 Month Principal at Beginning $16,353.00 $16,056.20 $15,757.68 $1,159.15 $774.98 $388 60 Monthly Payment $390.83 $390.83 $390.83 $390.83 $390.83 $390.83 Interest Payment $94.03 $92.32 $90.61 $6.67 $4.46 $2.23 Principal Payment $296.80 $298.51 $300.23 $384.17 $386.38 $388.60 Principal at End of Period $16,056.20 $15,757.68 $15.457.46 $774.98 $388.60 50.00 46 48 48 month Ready S
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