Debt schedule with existing bonds

i'm working on a model where the company has an existing $400 bond due 2022. It's not currently traded at par and was recorded in the balance sheet as ~$388 as of FYE2018.

Initially my debt schedule was simple - opening balance for 2019F was ~$388, no repayments in that year yet (bullet maturity only in 2022). When i reached 2022F, i simply deducted the ~$388. it's a simple model, where my cashflow from financing activities was calculated using the difference in debt between 2022F and 2021F - an outflow of $388 in this case. However, this technically isn't correct as the actual cash that goes out is actually $400 when the bond reaches maturity.

Should my debt schedule reflect the amortisation of the bond discount until the book value reached $400? i will then need to adjust the linkages to my cash flow statements to capture only the actual cash impact rather than simply change in debt. i guess what i'm really asking is whether there's an example of a good design of a debt schedule to account for bond discount/premium amortisations. Looked at some of the financial modelling video courses online and many seem to skim through debt schedules.

1 Comments
 

Non vel et et et dolor. Odit laborum facere aut aut dicta maiores. Minus asperiores quibusdam alias cum voluptas.

Cum et omnis quo perferendis sint. Placeat omnis soluta maiores.

Career Advancement Opportunities

October 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

October 2026 Investment Banking

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

Professional Growth Opportunities

October 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

October 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
DrApeman's picture
DrApeman
98.9
10
numi's picture
numi
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...”