Make a spreadsheet that should be able to do various calculations using automated formulas.

• Fully amortizing, partially amortizing (balloon), partial interest only or Interest only (bullet).
• there should be no balance or payment of interest past the term or error messages
• Yield with or with out closing costs.
• Interest Only periods.
• should be fully formula driven
• Able to change loan amount, amortization period, term length, interest rate.

An important step in this is getting the payment right. I will give you two assists. the formula for the payment is =IF(current period>term,"",IF(current period<=interest only period, io payment,IF(current priod=term, balloon payment,cpm)))