Question: Amortization Schedule Consider a $ 4 0 , 0 0 0 loan to be repaid in equal installments at the end of each of the

Amortization Schedule
Consider a $40,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 7%.
a. Set up an amortization schedule for the loan. Do not round intermediate calculations. Round your answers to the nearest cent. If your answer is zero, enter "0".
\table[[Year,,Payment,,rest,ReF,ncipal,,Balance],[1,$,3,$,3,$,3,$,],[2,$,3,$,3,$,3,$,],[3,$,3,$,3,$,,$,],[4,$,3,$,3,$,,$,],[5,$,3,$,3,$,3,$,],[Total,$,3,$,3,$,,,]]
b. How large must each annual payment be if the loan is for $80,000? Assume that the interest rate remains at 7% and that the loan is still paid off over 5 years. Do not round intermediate calculations. Round your answer to the nearest cent.
$
c. How large must eath payment be if the loan is for $80,000, the interest rate is 7%, and the loan is paid off in equal installments at the end of 10 years? This loan is for the same amount as the loan in part b, but the payments are spread out over twice as many periods. Do not round intermediate calculations. Round your answer to the nearest cent.
$
 Amortization Schedule Consider a $40,000 loan to be repaid in equal

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!