- InterestRate – C2 (annual interest rate)
- LoanTerm – C3 (mortgage identity in many years)
- PaymentsPerYear – C4 (amount of payments annually)
- LoanAmount – C5 (full loan amount)
- ExtraPayment – C6 (extra fee per period)
2. Calculate a planned percentage
Besides the type in tissues, yet another predetermined phone will become necessary in regards to our subsequent data – the brand new arranged fee number, i.age. the amount become paid to your a loan if the no extra money are created. This number is actually computed towards after the algorithm:
Delight pay attention we put a without signal before the PMT setting to have the result given that an optimistic count. To cease problems in case a few of the input muscle is actually empty, we enclose this new PMT algorithm for the IFERROR function. [weiter…]