Hi everyone,
I have a doubt with a model I need to built. So far I have been able to make amortizations in a way that they adjust to the number of periods but based on a first period 0, I just need to change the number of months and it will update automatically, this was easy because it always starts in period 0. I would choose the starting date and number of periods (50,60,70) and the table would update to that.
Now I need to make the same, but the cashflows doesn't start with the beginning of the amortization but with the first prepayments (which vary between transactions and happen before the starting of amortization). Lets say that between the mortgage signing date and the money transfer one year goes by and there need to be a series of prepayments (this are variable between loans, so I need the model to update automatically.
For example:
In one case there is only 1 prepayment right when the contract is signed.
In other the prepayment is in month 11
In other takes 2 years from signature to money transfer but if I have 4 prepayments between every six months.
Is it possible to make the model so it automatically adapts to these inputs?
Thanks, hope I explained myself
Bookmarks