Operating Model
Operating Model
Table of Contents
Model
DISCLAIMER
This model represents a hypothetical DCF of a hypothetical company. Any similarity between the financial metrics of this company and actual companies
is purely coincidental. Macabacus does not provide investment, accounting or tax advice. Additionally, tax and accounting rules used in the model are
illustrative and may not reflect current tax or accounting rules and standards.
DISCLAIMER
Except as otherwise expressly stated, including but not limited to in a license or other agreement governing the use of specific content, all content in this
model is provided "as is," and Macabacus makes no representations or warranties, express or implied, including but not limited to warranties
of merchantability, fitness for a particular purpose, title or non-infringement of proprietary rights. Without limiting the foregoing, Macabacus
makes no representation or warranty that content in this model is free from error or suitable for any purpose; nor that the use of such
content will not infringe any third-party copyrights, trademarks or other intellectual property rights. You understand and agree that you
download or otherwise obtain content through Macabacus' websites at your own discretion and risk, and that Macabacus will have no
liability or responsibility for any damage to your computer system or data that results from the download or use of such content. Some
jurisdictions may not allow the exclusion of implied warranties, so some of the above limitations may not apply to you.
This Excel model is for educational purposes only and should not be used for any other reason. All content is Copyright material of CFI Education Inc.
All rights reserved. The contents of this publication, including but not limited to all written material, content layout, images, formulas, and code, are protected
under international copyright and trademark laws. No part of this publication may be modified, manipulated, reproduced, distributed, or transmitted in any
form by any means, including photocopying, recording, or other electronic or mechanical methods, without prior written permission of the publisher,
except in the case of certain noncommercial uses permitted by copyright law.
https://www.macabacus.com/
feedback@macabacus.com
Model
Fractional years per period 1.00 1.00 1.00 1.00 1.00 1.00
x Income Statement
MRY Fiscal Years Ending December 31,
($ in millions) 2022 2023 2024 2025 2026 2027
Total revenue $440.8 $462.8 $486.0 $510.3 $535.8 $562.6
COGS 234.4 246.1 258.4 271.3 284.9 299.2
Gross profit 206.4 216.7 227.6 238.9 250.9 263.4
SG&A 79.6 83.6 87.8 92.1 96.8 101.6
EBITDA 126.8 133.1 139.8 146.8 154.1 161.8
Depreciation 14.0 14.7 15.4 16.2 17.0 17.9
Amortization 11.6 11.6 11.6 11.6 2.7 –
Stock-based comp 10.8 11.3 11.9 12.5 13.1 13.8
EBIT 90.4 95.5 100.9 106.5 121.3 130.2
EBITA 112.8 118.4 124.4 130.6 137.1 144.0
Interest (income) / expense
Cash NA (0.4) (0.6) (0.8) (1.0) (1.2)
Revolver – interest NA 1.2 – – – –
Revolver – undrawn commitment fee NA 0.4 0.5 0.5 0.5 0.5
Senior credit facility NA – – – – –
Subordinated note NA 3.8 3.8 3.8 3.8 3.8
Convertible bond NA 18.1 18.9 19.8 20.7 20.7
Interest (income) / expense 19.0 23.0 22.6 23.3 24.0 23.8
Equity income in affiliates – – – – – –
Other (income) / expense – – – – – –
Income before taxes 71.4 72.5 78.3 83.2 97.3 106.3
Provision for tax 28.4 29.0 31.3 33.3 38.9 42.5
GAAP net income 43.0 43.5 47.0 49.9 58.4 63.8
Net income attributable to noncontrolling interests – – – – – –
Preferred dividends – – – – – –
GAAP net income available to common $43.0 $43.5 $47.0 $49.9 $58.4 $63.8
x Balance Sheet
MRY Fiscal Years Ending December 31,
($ in millions) 2022 2023 2024 2025 2026 2027
Assets
Check – – – – – –
Investing Activities
Cash flow from investing activities ($16.0) ($16.8) ($17.6) ($18.5) ($19.4)
Financing Activities
Revolver ($15.0) – – – –
Senior credit facility – – – – –
Subordinated note – – – – –
Convertible bond – – – – –
Preferred stock – – – – –
Common dividend (0.4) (0.4) (0.4) (0.4) (0.4)
Cash flow from financing activities ($15.4) ($0.4) ($0.4) ($0.4) ($0.4)
x Working Capital
MRY Fiscal Years Ending December 31,
($ in millions) 2022 2023 2024 2025 2026 2027
Net Working Capital
x Debt Schedule
MRY Fiscal Years Ending December 31,
($ in millions) 2022 2023 2024 2025 2026 2027
Beginning cash balance $157.1 $238.7 $313.9 $392.9 $461.9
( – ) Minimum cash balance (100.0) (100.0) (100.0) (100.0) (100.0)
Excess cash / (cash deficit) 57.1 138.7 213.9 292.9 361.9
( + ) Cash flow available for debt service 96.9 75.5 79.3 69.3 72.5
Total cash available for debt service 154.1 214.3 293.2 362.2 434.4
Senior credit facility – – – – –
Subordinated note – – – – –
Convertible bond – – – – –
( – ) Scheduled debt repayment – – – – –
Cash available for sweep / (revolver draw-down) $154.1 $214.3 $293.2 $362.2 $434.4
Debt Schedule
Revolver
Beginning balance $15.0 – – – –
( + ) Revolver draw-down – – – – –
( – ) Revolver pay-down (15.0) – – – –
Ending balance $15.0 – – – – –
Subordinated note
Beginning balance $45.5 $45.5 $45.5 $45.5 $45.5
( – ) Scheduled maturity – – – – –
( – ) Optional repayment – – – – –
Ending balance $45.5 $45.5 $45.5 $45.5 $45.5 $45.5
Convertible bond
Beginning balance $190.0 $199.0 $208.5 $218.4 $218.4
( + ) PIK accretion 9.0 9.5 9.9 – –
( – ) Scheduled maturity – – – – –
Ending balance $190.0 $199.0 $208.5 $218.4 $218.4 $218.4
Preferred stock
Beginning balance – – – – –
( + ) PIK accretion – – – – –
( – ) Retirement – – – – –
Ending balance – – – – – –
Interest Rates
Revolver $1.2 – – – –
Senior credit facility – – – – –
Subordinated note $3.8 $3.8 $3.8 $3.8 $3.8
Convertible bond $18.1 $18.1 $18.9 $19.8 $20.7 $20.7
Preferred stock – – – – – –
Revolver – – – – –
Senior credit facility – – – – –
Subordinated note – – – – –
Convertible bond 50.0% 50.0% 50.0% – –
Preferred stock – – – – –
Debt Triggers
Average interest? No
x Equity Investments
MRY Fiscal Years Ending December 31,
($ in millions) 2022 2023 2024 2025 2026 2027
Equity income in affiliates – – – – –
( – ) Cash dividends received from equity investments – – – – –
Undistributed earnings – – – – –
x Depreciation Schedule
MRY Fiscal Years Ending December 31,
($ in millions) 2022 2023 2024 2025 2026 2027
Capital expenditures $16.0 $16.8 $17.6 $18.5 $19.4
Tax Depreciation
Page 2 of 3
Model
x Tax Schedule
MRY Fiscal Years Ending December 31,
($ in millions) 2022 2023 2024 2025 2026 2027
Federal tax rate 38.1% 38.1% 38.1% 38.1% 38.1%
State and local tax rate 3.0% 3.0% 3.0% 3.0% 3.0%
Blended tax rate 39.8% 40.0% 40.0% 40.0% 40.0% 40.0%
Unencumbered NOL
Remaining NOL life (yrs) 15.00 14.00 13.00 12.00 11.00 10.00
*** SOME OR ALL OF THIS SECTION MAY NOT APPLY OUTSIDE THE UNITED STATES ***
Federal tax at statutory rate (post-NOL) $3.1 $29.0 $30.8 $36.0 $39.3
Alternative minimum tax (before credits) 1.4 1.5 1.6 1.9 2.1
Tax payable before AMT credit used $3.1 $29.0 $30.8 $36.0 $39.3
( – ) AMT tax credit used – – – – –
Federal cash taxes $3.1 $29.0 $30.8 $36.0 $39.3
Effective federal cash tax rate 4.2% 38.1% 38.1% 38.1% 38.1%
x Shares Outstanding
MRY Fiscal Years Ending December 31,
($ in millions) 2022 2023 2024 2025 2026 2027
Stock Options
Convertible Securities
Face value
Convertible bond $190.0 $199.0 $208.5 $218.4 $218.4 $218.4
Preferred stock – – – – – –
Conversion price
Convertible bond $26.77 $26.77 $26.77 $26.77 $26.77 $26.77
Preferred stock – – – – – –
Convertible shares
Convertible bond 7.097 7.435 7.788 8.158 8.158 8.158
Preferred stock – – – – – –
EPS if converted
Convertible bond $1.27 $1.27 $1.35 $1.42 $1.63 $1.75
Preferred stock $1.22 $1.23 $1.33 $1.41 $1.65 $1.81
Is conversion dilutive?
Convertible bond No No No No Yes Yes
Preferred stock No No No No No No
Basic shares outstanding (BSO) 35.340 35.340 35.340 35.340 35.340 35.340
( + ) In-the-money Treasury Method option shares 0.003 0.003 0.003 0.003 0.003 0.003
( + ) Shares from Convertible bond – – – – 8.158 8.158
( + ) Shares from Preferred stock – – – – – –
Fully diluted shares outstanding (FDSO) 35.343 35.343 35.343 35.343 43.500 43.500
Interest Expense
Coverage
Leverage
Page 3 of 3