Formula

[najib74]

Dear Sirs

Good afternoon , i m working on term loan sheet with moratorium period only the interest will be paid first and after couple of months will start paying Principal and Interest

Kindly advise how can i use the excel to prepare a formula for that .

Thanks & Regards

Najib ABboud

 

[oldbrewer]

loan	int rate	month1	month2	month3	month4	month5	month6	month7	month8	month9	month10	month11	month12
10000	5%	10500	11025	10148.45	9228.073	8261.676	7246.96	6181.508	5062.783	3888.122	2654.729	1359.665	-0.1517
repay
1427.8
		so essentially the loan is loan multiplied by (1 + int rate)^2
		and is to be repaid in 10 months (in this example)
		so the borrower repayments are 142.78 per 1000 borrowed

<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>
</tbody>