• InterestRate – C2 (annual rate of interest)
• LoanTerm – C3 (loan term in years)
• PaymentsPerYear – C4 (level of repayments annually)
• LoanAmount – C5 (complete loan amount)
• ExtraPayment – C6 (a lot more percentage each several months)

2. Estimate an arranged fee

Apart from the type in structure, an extra predefined cell will become necessary for the further data – the fresh new scheduled payment number, i.e. the quantity are repaid towards that loan in the event the no extra repayments are manufactured. That it count is actually calculated toward following algorithm:

Please pay attention that people set a minus indication until the PMT function to get the effects because a confident amount. (suite…)