I am currently building an amortisation schedule for a property mortgage and am having difficulty filling the time series according to the length of year (Number of Payments). Any help would be greatly appreciated.
I would like the period to update automatically based on a monthly payment spread over 30 years, but everything I see uses the fill function, Below is the Calculator Lay Out:
<tbody>
</tbody>
I would like the period to update automatically based on a monthly payment spread over 30 years, but everything I see uses the fill function, Below is the Calculator Lay Out:
Loan Amortization Schedule | Period | Date | Beginning Balance | Payment | Interest | Principal | Ending Balance | |
Input | 1 | Aug-17 | £376,000.00 | £1,366.16 | £587.13 | £779.03 | £375,220.97 | |
Purchase Price | £470,000.00 | |||||||
Deposit | 20.00% | |||||||
Loan Amount | £376,000.00 | |||||||
Annual Interest Rate (Bank set interest rate) | 1.89% | |||||||
Length of Loan (Years, 30 max) | 30 | |||||||
Calculated Output | ||||||||
Monthly Interest Rate | 0.156% | |||||||
Monthly Payment | £1,366.16 | |||||||
Number of Payments/Year | 12 | |||||||
Number of Payments | 360 | |||||||
Total Cost of Loan | £491,819.36 | |||||||
Total Interest | £115,819.36 |
<tbody>
</tbody>