Repayment Calculator and Loan Application Form

Calculating the amount of principle you’ve paid on a loan lets you determine the amount of equity you have in your purchase your equity is simply your down payment plus any loan principal paid plus appreciation of the asset calculating the interest paid on the loan lets you find the amount of interest you paid in the year which you can often write off in your tax return.

I have set this workbook up so that we can calculate the principal component and interest component of an individual payment the P PMT function as you probably guessed lets you calculate the principal and I PMT the interest so let’s go through the arguments the rate is exactly what you would expect the annual interest rate and period

$10000     $100000
1 years     10 years
Your repayments are every years at
Total you will Pay: