Hi,

Can anyone help on this problem:

Trying to build a spreadsheet for repayment of a loan, would like 3 variables:

1) No of yrs for repayment
2) Possibility of a grace period/interest payments only for X yrs
3) Interest rate

For example:
Loan $100,000/serial loan
Interest rate: 4%
Repayment 10 yrs
Grace period 2 yrs (that means 2 first years only pay interest and then
subsequently you start to pay the loan down from yr 3)

Is there some formulas that can do this? I have been trying to use some of
the loan calculators that excel have as templates but they do not allow you
to have a grace period and it is an annuity loand and not serial.

Can anyone help on this?

In advance thanks.