Adding an 'Interest Only' Period to an Amortization Schedule, 1 of 2

Ever want to add an Interest-only period to an amortization schedule? This video shows you how to simply add one in and make your financial models more flexible.

---
Like this? Want more?

Sign up for our live Excel modeling training class here:
Sign up for our self-paced Case Study course here:

[Vargaskevin]

This was very useful for an exercise I'm working on, thank you for sharing!

[petejuneaux]

Nice tip!! I have been messing with a simple way to do this all day!!
Thanks for the help!!

[abbytaj]

Im so glad I found this! It has helped me a lot. Thank you so much. I really appreciate it!

[thebeebz]

I would love to see how this would work with an option to add a fixed additional payment.

[adowak]

Thank you, this was very helpful! Just created my amortization schedule.

[abbashaider]

Thank you so much, Really helpfull Video.

[danahyoon]

Thank you very much for this video! It was very helpful!  
I tried the same way you made the table, but the ending balance does not become zero at the end. I wonder whether we have to subtract the interest-only period from the Nper of PMT function; like "IF(AND($H$7, C13<=$H$8), F13, PMT($C$8/$D$8, ($C$9-($H$8*12)), $C$7).

[MichaelRosen]

The way you do it, if we have 6 months of IO payments, we need 306 payments of discharge the loan. What we're generally looking for is a loan that discharges in 300 payments, the first 12 of which are IO, right?

[nurrabihah]

Hi Joshua, appreciate if you could make Interest only period by changing in their loan term :)

[desmondtorruella]

How would you do this if the lending institution offers interest only in the middle of the amortization term like many lenders have under the CARES ACT?

[dr.jackkhorram]

Some one owes me 20, 000 since January 31 2005 interest only at %6 but he never mad any payment today Janet 2020 how urchin dose he owe me because interest on top of interest at %6 I have no ideas how to calculate it please help me .