Problem:
There are seven years remaining on a ten year car loan. The interest rate is 10.25%. The monthly payments are $450.00. The credit union is willing to accept the present value of the loan as a pay off. Develop an amortization schedule Using excel that shows how much will need to be paid at the end of each of the ten years. design and create a worksheet that contains both the beginning and ending balance, the amount paid on the principal, and the interest paid for years 4-10 because the first three years have already been paid. Determine only the ending value for year three.