Question
College students graduating from US universities often have accumulated $25,000 in loans. In recent years, the annual interest rate on those loans has been about
College students graduating from US universities often have accumulated $25,000 in loans. In recent years, the annual interest rate on those loans has been about 5% compounded quarterly. A common repayment plan is to pay the money back over 10 years. (a) Calculate the quarterly payment. (b) Create an amortization table with Payment in the 1st column, Principal Before Payment in the 2nd column, Interest Payment in the 3rd column, Paid On Principal in the 4th column, and Principal After Payment in the 5th column. Use the amortization table to determine the total amount paid on the loan and the amount paid on interest.
HINT** Excel format is needed and all formulas must be shown to get credit for work**
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