Simple Plug-and-Play 3 Statement Operating Excel Model

Description
Three statement projections models can often be overly complex, with too many inputs and too many tabs. As the head of the Financial Modeling Group at S&P Global Market Intelligence, my team has built over 15,000 models for our clients, and simplicity is the key to client satisfaction. I have built this model to be as simple as possible when it comes to formulas and calculations, but powerful in its analysis. This model can run monthly or yearly projections and can easily be expanded to include more periods. All inputs are in blue font, and everything is on one tab.

This model includes:
Income Statement
Balance Sheet
Cash Flow Statement
Working Capital Schedule
Cash Flow Sweep to calculate cash available for mandatory and/or option debt repayments

You may choose how much available free cash flow you dedicate to debt repayment
Debt Waterfall structure with up to 4 tranches of debt
Interest Expense calculation
Depreciation Schedule using capital expenditures and current fixed assets
Returns & Ratios

For an expanded version, please download my “Expanded Plug-And-Play 3 Statement Operating Model”, which includes all of the above as well as:
Cash vs Book Taxes
Preferred Equity/Dividends
Paid-In-Kind Interest
Deferred Taxes
Modified Accelerated Depreciation Schedule
Equity Investment Income
Doubtful Accounts
Intangible Asset Amortization
Stock Based Compensation