Question: Example 2: Construct an amortization table for the following 10 -year loan that pays semi-annually. What will be the outstanding balance on the loan after

Example 2: Construct an amortization table for the following 10 -year loan that pays semi-annually. What will be the outstanding balance on the loan after year 7 ? Inputs Loan Life Interest Rate Loan Amount Semi-Annual Payment Steps to Complete the Amortization Table "Calculate the payment first. Then add it to the table as the "Total Payment" ** Set the Beginning Balance in Period 1 equal to the Loan Amount Interest Paid in each period is the Beginning Balance times the Interest Rate (adjust for compounding) Beginning Balance for the rest of the table is the Ending Balance from the prior period Loan Balance After YR7
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
