Interest Only Structuring

It seems I've overlooked one aspect of modeling partial I/O in excel and wanted to double check with everyone.

given a 30-year amortizing loan with any amount of period of I/O greater than 0, assuming term is irrelevant the loan amortization table from the above would not have a 0 End of Balance in period 360?

Does this make sense. Or am I missing some interest or principal catchup device

7 Comments
 

I've seen a balloon payment due at end of IO period and end of term (360 mo). I have very little experience with this and would wait to hear others though..

“The three most harmful addictions are heroin, carbohydrates, and a monthly salary.” - Nassim Taleb
 

As others have said, most likely a balloon payment, but it will rarely ever, if ever, get to that point. You would put permanent debt on it before the I/O period ends, usually at a lower interest rate and/or without a personal guarantee.

Commercial Real Estate Developer
 

What others may have missed that you may be asking is if you should start counting th amortization schedule during the I/O or after, so the question becomes if you have a 30-yr amortization loan w/ 3 yrs I/O, does the loan fully amortize in 30-yrs from loan origination or 27-yrs?

The answer to that is "it depends" but more often than not, I've seen the loan amortization start after the I/O period. Thus, a 3-yr I/O, 30-yr amortization would take 396 mths to fully draw to 0 balance.

 

Guys you need to realize that logic drives a deal and not an excel model. Think basically. Once the loan matures, regardless of what your amortization table tells you, the borrower is obligated to repay the full balance of the loan otherwise he will be in default and the lender can assess penalties or initiate foreclosure on its collateral. It doesn't matter what your amortization table in excel tells you. This is why in real life, the borrower will make a balloon payment upon maturity, or if allowed, execute an option to extend the loan if he cannot repay at that time and likely pay a fee for the extension since it's an option inured to the borrower's benefit.

 

Doloribus ut deleniti at est rem et quidem reiciendis. Sint amet ut fugit aut officiis aperiam qui. Mollitia voluptas quod dolorem alias ipsam aliquid quisquam. Accusantium et est soluta provident est et fugit facere. Nobis repudiandae ad minima et quos omnis voluptatem.

Et quasi praesentium quae dolores. Amet fugiat rem deserunt nemo saepe. Ipsa laborum esse minima repellat. Et esse temporibus magnam fugit accusantium et omnis. Voluptas id officia reprehenderit accusantium.

At quia et nesciunt vero et. Officia quos blanditiis repellat pariatur ipsum. Rerum et quasi laborum eos dolores dolor debitis pariatur. Quia modi quia voluptatibus autem.

Repellat voluptatem perferendis voluptates cumque. Eveniet maxime sint assumenda ut magnam ut quibusdam omnis. Voluptatem et nam ut quae rerum. Doloribus facere quia minima culpa. Asperiores nihil dolores quis qui suscipit itaque blanditiis.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
GameTheory's picture
GameTheory
98.9
6
DrApeman's picture
DrApeman
98.9
7
CompBanker's picture
CompBanker
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
dosk17's picture
dosk17
98.9
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”