RTBS Rypin – Rypińskie Towarzystwo Budownictwa Społecznego

• InterestRate – C2 (yearly interest rate)
• LoanTerm – C3 (loan name in many years)
• PaymentsPerYear – C4 (amount of costs per year)
• LoanAmount – C5 (full loan amount)
• ExtraPayment – C6 (a lot more fee for each several months)

dos. Calculate a booked fee

Aside from the type in structure, yet another predefined telephone is necessary in regards to our further calculations – new planned commission number, i.age. the amount becoming paid back into the financing when the no extra costs are made. It count was determined towards following the algorithm:

Please listen up we place a minus sign until the PMT means to obtain the results because the a confident amount. To quit errors but if some of the enter in cells is empty, i enclose new PMT formula during the IFERROR mode.

step three. Put up the newest amortization desk

Create financing amortization table into headers revealed about screenshot less than. In the period line get into a series of amounts you start with zero (you can cover up the period 0 line later when needed).

For many who try to do a recyclable amortization schedule, enter the restrict you are able to amount of payment symptoms (0 so you can 360 inside analogy).

To possess Period 0 (row 9 inside our instance), pull the balance worth, that’s comparable to the original loan amount. Any other muscle within this row will continue to be empty:

That is a key part of the work. Since the Excel’s dependent-inside functions don’t allow for a lot more payments, we will see doing all of the mathematics into our very own. Czytaj więcej →