Expanded Plug-And-Play 3 Statement Operating 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 is an expansion from my model titled "Simple Plug-and-Play 3 Statement Operating Excel Model"

This model includes everything from my previous model, including:
Income Statement
Balance Sheet
Cash Flow Statement
Working Capital Schedule
Cash Flow Sweep to calculate cash available for mandatory and/or option debt repayments
Debt Waterfall structure with up to 4 tranches of debt plus preferred equity
Interest Expense calculation
Depreciation Schedule using capital expenditures and current fixed assets
Returns & Ratios

This model also comes with:
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