LBO Short Form Model
xlsx
keyboard_arrow_up
School
University of Massachusetts, Amherst *
*We aren’t endorsed by this school
Course
403
Subject
Finance
Date
Jan 9, 2024
Type
xlsx
Pages
8
Uploaded by JusticeBook8498
Updated 3/13/2021
1
Transaction Assumptions
Purchase Year
1-Jan-16
EBITDA Purchase Multiple
8.0 Purchase Year EBITDA
409.0 Purchase EV
3,272.0 Less Existing Debt
- Add Cash on Balance Sheet
- Transaction Equity Value
3,272.0 Sponsor Equity Contribution
1,113.8 Sponson Equity as % of Sources of Cash
32.33%
2
Sources of Financing
Debt
Cap
xEBITDA
Amount
Revolver (Floating)
500.0 - - 2.0%
0.0%
Term Loan A (Floating)
3.2 1,308.8 2.3%
38.0%
Term Loan B (Floating)
- - 2.5%
0.0%
Senior Notes (Fixed)
1.5 613.5 5.5%
17.8%
Junior Notes (Fixed)
1.0 409.0 6.2%
11.9%
Other Debt
- - 8.0%
0.0%
Total Debt
5.7 2,331.3 2.6%
67.7%
Equity
Management Equity
2.7 1,113.8 32.3%
Sponsor Equity
Excess Cash
Excess Cash
- Total Sources
8.4 3,445.1 100.0%
3
Income Statement & Free Cash Flow Forescast
2010
2011
2012
2013
2014
2015
Revenue
2,672.3 3,216.0 3,612.7 3,941.0 EBITDA
327.3 284.0 298.5 283.5 Capex
(193.8) 254.9 (327.9) (297.7)
Interest Rate (Spread)
% of Sources
Net WC Change
(6.7) (64.3) (22.0) (41.0)
Interest Expenses
Taxes
2010
2011
2012
2013
2014
2015
Tax Details
D&A Charges
(85.1) (104.8) (127.8) (151.6)
Pretax Profit (Loss)
Cash Flow Drivers
Revenue Growth (YOY%)
20.3%
12.3%
9.1%
EBITDA Margin
12.2%
8.8%
8.3%
7.2%
D&A as % of Sales
-3.2%
-3.3%
-3.5%
-3.8%
Capex as % of Sales
-7.3%
7.9%
-9.1%
-7.6%
NWC as % of Sales Change
-0.3%
-11.8%
-5.5%
-12.5%
Taxes
2010
2011
2012
2013
2014
2015
Cash Flow Before Debt RePayments
EBITDA
Less Interest Expenses
Less Taxes
Less Changes in NWC
Less CapEx
Less Mandatory Debt Repatments
Net Cash Flow
Less Non-Mandatory Debt Repatments
Net Cash Flow
Cash Contributions/Withdrawls
Cash Balance
121.0 4
Financing Payments
2010
2011
2012
2013
2014
2015
Benchmark Interest Rate
5.30%
Debt Balances after Repayments
Term Loan A (Floating)
1,308.8 Term Loan B (Floating)
- Senior Notes (Fixed)
613.5 Junior Notes (Fixed)
409.0 Other Debt
Total
2,331.3 Revolver (Floating)
-
2010
2011
2012
2013
2014
2015
Mandatory Payments
Revolver
Amount
- Interest Rate
7.30%
Ending Balance
- Interest Payments
Term Loan A (Floating)
Amount of Loan
1,308.8 Term
5
Interest Rate
Ending Balance
1,308.8 Principal Payments
Interest Payments
Total Payments
Term Loan B (Floating)
Amount of Loan
- Term
5
Interest Rate
Ending Balance
- Principal Payments
Interest Payments
Total Payments
Senior Notes (Fixed)
Amount
613.5 Term
5
Interest Rate
Ending Balance
613.5 Principal Payments
Interest Payments
Total Payments
Junior Notes (Fixed)
Amount
409.0 Term
5
Interest Rate
Ending Balance
409.0 Principal Payments
Interest Payments
Total Payments
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
2010
2011
2012
2013
2014
2015
Non-Mandatory Payments
Revolver
Term Loan A (Floating)
Term Loan B (Floating)
Senior Notes (Fixed)
Junior Notes (Fixed)
Total
5
Credit Statistics
Net Debt to EBITDA
EBITDA to Interest Expenses
6
IRR Calculations
2015
Cash Flow
(1,113.8)
IRR
21%
Cash on Cash Mulitple 2.64 7
Sensitivity Analysis
IRR EBITDA Margin
Exit Multiple
9%
10%
11%
12%
7.50
7%
21%
8.00
10%
8.50
12%
17%
9.00
12%
28%
Average
15%
Median
12%
Sale Year
21-Dec-21
EBITDA Sale Multiple
8.5 Sale Year EBITDA
445.9 Sale EV
3,789.7 Less Sale Year Debt
1,022.5 Plus Sale Year Cash
169.7 Implied Equity Value
2,937.0 Less Management Equity Share
- Sponsor Equity at Exist
2,937.0 Results
Sponsor IRR
21%
Sponsor Cash-on-Cash Return
2.64 Uses of Financing
Purchase Price
3,272.0 Refinance Existing Debt
- Transaction Fees
52.1 Cash for Operations
121.0 Other
- Total
3,445.1 2016
2017
2018
2019
2020
4,166.8 4,083.7 4,083.7 4,206.2 4,458.5 416.7 408.4 408.4 420.6 445.9 (125.0) (102.1) (102.1) (105.2) (111.5)
(11.3) 4.2 - (6.1) (12.6)
(161.8) (133.9) (107.1) (96.9) (89.1)
(33.1) (44.6) (54.0) (60.3) (68.7)
2016
2017
2018
2019
2020
(160.3) (147.0) (147.0) (151.4) (160.5)
94.6 127.5 154.3 172.3 196.2 5.7%
-2.0%
0.0%
3.0%
6.0%
10.0%
10.0%
10.0%
10.0%
10.0%
-3.8%
-3.6%
-3.6%
-3.6%
-3.6%
-3.0%
-2.5%
-2.5%
-2.5%
-2.5%
-5.0%
-5.0%
-5.0%
-5.0%
-5.0%
-35.0%
-35.0%
-35.0%
-35.0%
-35.0%
2016
2017
2018
2019
2020
416.7 408.4 408.4 420.6 445.9 (161.8) (133.9) (107.1) (96.9) (89.1)
(33.1) (44.6) (54.0) (60.3) (68.7)
(11.3) 4.2 - (6.1) (12.6)
(125.0) (102.1) (102.1) (105.2) (111.5)
85.5 131.9 145.2 152.1 164.0 (229.9) (149.2) (267.6) (276.7) (385.3)
(58.9) 114.7 22.8 27.5 (57.4)
- 100.0 - - (100.0)
(58.9) 214.7 22.8 27.5 (157.4)
- - - - - 62.1 276.8 299.6 327.1 169.7 2016
2017
2018
2019
2020
4.20%
3%
1%
0.80%
1%
1,078.9 829.7 562.1 285.3 - - - - - - 613.5 613.5 613.5 613.5 613.5 409.0 409.0 409.0 409.0 409.0 2,101.4 1,852.2 1,584.6 1,307.8 1,022.5 - 100.0 100.0 100.0 -
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
2016
2017
2018
2019
2020
6.20%
5.00%
3.00%
2.80%
3.00%
- 100.0 100.0 100.0 - - - (3.0) (2.8) (3.0)
6.50%
5.30%
3.30%
3.10%
3.30%
1,078.9 829.7 562.1 285.3 - (229.9) (249.2) (267.6) (276.7) (285.3)
(85.1) (57.2) (27.4) (17.4) (9.4)
(314.9) (306.4) (295.0) (294.2) (294.7)
6.70%
5.50%
3.50%
3.30%
3.50%
- - - - - - - - - - - - - - - - - - - - 9.70%
9.70%
9.70%
9.70%
9.70%
613.5 613.5 613.5 613.5 613.5 - - - - - (59.5) (59.5) (59.5) (59.5) (59.5)
(59.5) (59.5) (59.5) (59.5) (59.5)
4.20%
4.20%
4.20%
4.20%
4.20%
409.0 409.0 409.0 409.0 409.0 - - - - - (17.2) (17.2) (17.2) (17.2) (17.2)
(17.2) (17.2) (17.2) (17.2) (17.2)
2016
2017
2018
2019
2020
- 100.000 - - (100.0)
- - - - - - - - - - - - - - - - - - - - - 100.000 - - (100.0)
2016
2017
2018
2019
2020
5.0 4.5 3.9 3.1 2.3 2.6 3.1 3.8 4.3 5.0 2016
2017
2018
2019
2020
- - - - 2,937.0 Margin
Multiple
10%
8.5
Related Documents
Related Questions
me
* CengageNowv2 | Online teach x
keAssignment/takeAssignmentMain.do?invoker-D&takeAssignmentSessionLocator=&inprogress%-false
Updar
Discount Amortization
On the first day of the fiscal year, a company issues a $1,700,000, 9%, 10-year bond that pays semiannual interest of $76,500 ($1,700,000 x 9% x ½), receiving cash
of $1,407,515.
Journalize the first interest payment and the amortization of the related bond discount. Round to the nearest dollar. If an amount box does not require an entry, leave it
blank.
Interest Expense
1,407,515
Discount on Bonds Payable
Cash
arrow_forward
Types of accounts answer choices:
Asset
Equity
Expense
Liability
Revenue
Normal balance answer choices:
Credit
Debt
Increase (Dr. or Cr.)
Credit
Debt
arrow_forward
None
arrow_forward
Question #5 please!
arrow_forward
What are two kinds of paid-in capital accounts?
arrow_forward
Given the following information from an amortization table for December 31, prepare the journal entry to record the payment of interest.
6% Cash
Interest
$42,000
4% Effective
Interest
Premium
Amortization
$35,953
$6,047
Carrying
Value
$507,567
OA.
Account
December 31
Interest Expense
Discount on Bonds Payable
Cash
Debit
Credit
35,953
6,047
42.000
O B.
Account
Debit
Credit
December 31
Interest Expense
35,953
Premium on Bonds Payable
6,047
Cash
42,000
Account
December 31
Interest Expense
Discount on Bonds Payable
Bonds Payable
O D.
Account
December 31
Interest Payable
Premium on Bonds Payable
Interest Expense
Debit
Credit
35,953
6,047
42,000
Debit
Credit
42,000
6,047
35,953
arrow_forward
Reassignment takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false
eBook
Discount Amortization
Show Me How
My Work
0
$1,178,910.
On the first day of the fiscal year, a company issues a $1,300,000, 9%, 4-year bond that pays semiannual interest of $58,500 ($1,300,000 x 9% x 12), receiving cash of
blank.
Journalize the first interest payment and the amortization of the related bond discount. Round to the nearest dollar. If an amount box does not require an entry, leave it
000
+
< Previous Next
Up
arrow_forward
Subject:
arrow_forward
Corporation
Partlal Starternent of Finandal Position
20-וו
at Decamber 31, 2020
2020
2019
21-24
Bulldings and equipment
Accumulated deprecation-bulldings and equlpmet
Intanglble assets
Accumulated amortizatlon
Investment, non-trading
€60 000
62 000
Inventory
48 100
37 000
Prepald expenses
Accounts recelvable (net)
4 300
2 500
49 800
22 000
Divldend recelvable
Cash
9 100
10 000
192 000
181 000
Total assets
Share capital-ordinary
Retained earnings
Other comprehensive income
Bond payable-lang-term
Notes payable-bank, long-term
Notes payable-bank, short-term
€103 000
147 000
74 000
74 000
4 800
16 000
Unearned revenue
11 700
10 500
81 900
5 500
24 900
Accounts payable
Interest payable
Dividend payable
9 400
31 700
27 000
Total llabilities and shareholders' equlty
Additlonal Information from the footnotes to the financlal statements reveals that
- Net Income for 2020 amounts to C162 800:
For the year 2020, the company recognlzed depreclation of €22 000, amortization of €4 200, and galn on…
arrow_forward
Metlock Inc.
Comparative Balance Sheet
As of December 31, 2025 and 2024
12/31/25
12/31/24
Cash
$6,000
$7,000
Accounts receivable
61,800
50,700
Short-term debt investments (available-for-sale)
35,300
17,900
Inventory
39,800
59,400
Prepaid rent
4,900
4,000
Equipment
153,100
130,500
Accumulated depreciation-equipment
(35,000)
(24,700)
Copyrights
45,900
50,500
Total assets
$311,800 $295,300
Accounts payable
$46,000
$39,700
Income taxes payable
4,000
5,900
Salaries and wages payable
8,100
4,100
arrow_forward
Calculating Enterprise Value Given only the above information, what is the Enterprise Value at the end of Year 0? Assume end-of-year discounting. $193,501 $175,514 $155, 290 $151,854
arrow_forward
Use Figure 23.7. Suppose the LIBOR rate when the first listed Eurodollar contract matures in December 2019 is 3%. What will be the
profit or loss to each side of the Eurodollar contract? (Do not round intermediate calculations and round final answer to 2 decimal
places. Enter the amount as positive value.)
arrow_forward
Consider the following amortization schedule: Payment # Payment 1 966.45 2 966.45 3 966.45 Interest Debt Payment 750.00 748.92 X 216.45 217.53 Y Balance 149, 783.55 149,566.02 2 With the exception of column one, all amounts are in dollars. Calculate . Give your answer in dollars to the nearest dollar. Do not includo ar or the dollar sign in your answor
arrow_forward
Subject:
arrow_forward
Indicate the tramsaction prie for this situation and when revenue will be recognized
Groupo sels goods to Magnus for $500,000 payment due in two installments first installment payable in 18 months and the second
paymend due 6 months later. The present value of the future payments is $464,000
O $500.000 recognized at the point of sale
O $464.000 reciognized at the point of sale and recognized interest revenue over the payment period
O $500.000 recognize $250,000 in 18 months and $250,000 recognized 6 months later
$500.000 recognize $464 000 revenue and $36.000 of interest revenue
arrow_forward
Perform February 2023, journal entries and balance sheet.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning

Related Questions
- me * CengageNowv2 | Online teach x keAssignment/takeAssignmentMain.do?invoker-D&takeAssignmentSessionLocator=&inprogress%-false Updar Discount Amortization On the first day of the fiscal year, a company issues a $1,700,000, 9%, 10-year bond that pays semiannual interest of $76,500 ($1,700,000 x 9% x ½), receiving cash of $1,407,515. Journalize the first interest payment and the amortization of the related bond discount. Round to the nearest dollar. If an amount box does not require an entry, leave it blank. Interest Expense 1,407,515 Discount on Bonds Payable Casharrow_forwardTypes of accounts answer choices: Asset Equity Expense Liability Revenue Normal balance answer choices: Credit Debt Increase (Dr. or Cr.) Credit Debtarrow_forwardNonearrow_forward
- Question #5 please!arrow_forwardWhat are two kinds of paid-in capital accounts?arrow_forwardGiven the following information from an amortization table for December 31, prepare the journal entry to record the payment of interest. 6% Cash Interest $42,000 4% Effective Interest Premium Amortization $35,953 $6,047 Carrying Value $507,567 OA. Account December 31 Interest Expense Discount on Bonds Payable Cash Debit Credit 35,953 6,047 42.000 O B. Account Debit Credit December 31 Interest Expense 35,953 Premium on Bonds Payable 6,047 Cash 42,000 Account December 31 Interest Expense Discount on Bonds Payable Bonds Payable O D. Account December 31 Interest Payable Premium on Bonds Payable Interest Expense Debit Credit 35,953 6,047 42,000 Debit Credit 42,000 6,047 35,953arrow_forward
- Reassignment takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false eBook Discount Amortization Show Me How My Work 0 $1,178,910. On the first day of the fiscal year, a company issues a $1,300,000, 9%, 4-year bond that pays semiannual interest of $58,500 ($1,300,000 x 9% x 12), receiving cash of blank. Journalize the first interest payment and the amortization of the related bond discount. Round to the nearest dollar. If an amount box does not require an entry, leave it 000 + < Previous Next Uparrow_forwardSubject:arrow_forwardCorporation Partlal Starternent of Finandal Position 20-וו at Decamber 31, 2020 2020 2019 21-24 Bulldings and equipment Accumulated deprecation-bulldings and equlpmet Intanglble assets Accumulated amortizatlon Investment, non-trading €60 000 62 000 Inventory 48 100 37 000 Prepald expenses Accounts recelvable (net) 4 300 2 500 49 800 22 000 Divldend recelvable Cash 9 100 10 000 192 000 181 000 Total assets Share capital-ordinary Retained earnings Other comprehensive income Bond payable-lang-term Notes payable-bank, long-term Notes payable-bank, short-term €103 000 147 000 74 000 74 000 4 800 16 000 Unearned revenue 11 700 10 500 81 900 5 500 24 900 Accounts payable Interest payable Dividend payable 9 400 31 700 27 000 Total llabilities and shareholders' equlty Additlonal Information from the footnotes to the financlal statements reveals that - Net Income for 2020 amounts to C162 800: For the year 2020, the company recognlzed depreclation of €22 000, amortization of €4 200, and galn on…arrow_forward
- Metlock Inc. Comparative Balance Sheet As of December 31, 2025 and 2024 12/31/25 12/31/24 Cash $6,000 $7,000 Accounts receivable 61,800 50,700 Short-term debt investments (available-for-sale) 35,300 17,900 Inventory 39,800 59,400 Prepaid rent 4,900 4,000 Equipment 153,100 130,500 Accumulated depreciation-equipment (35,000) (24,700) Copyrights 45,900 50,500 Total assets $311,800 $295,300 Accounts payable $46,000 $39,700 Income taxes payable 4,000 5,900 Salaries and wages payable 8,100 4,100arrow_forwardCalculating Enterprise Value Given only the above information, what is the Enterprise Value at the end of Year 0? Assume end-of-year discounting. $193,501 $175,514 $155, 290 $151,854arrow_forwardUse Figure 23.7. Suppose the LIBOR rate when the first listed Eurodollar contract matures in December 2019 is 3%. What will be the profit or loss to each side of the Eurodollar contract? (Do not round intermediate calculations and round final answer to 2 decimal places. Enter the amount as positive value.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
