Loan Amortisation using a floating rate

Hi,

I need to amortise a loan and charge a fixed spread over a 3 month LIBOR rate to account for the credit risk. Total charge will be 3 Month + fixed Spread- does anyone I have an example I could take a look at?

Thanks,

Paul

See attached. There can be issues like max/min rates, payment caps, max Neg Am, recast periods etc...to contend with, but this has the basics .

Hope this helps

SAE