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>
