All Industries, Financial Model, General Excel Financial Models

10-year Financial Projections, 5-year Financial Projections, Break-Even, Budgeting, Cap Rate (Capitalization Rate), Cap Table, Cash Flow Projections, CFO, Chart, Cost Projections, Dashboard, DCF Model, Debt Schedule, Discount Rate, Excel, Financial Analysis, Financial Due Diligence, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financial Reporting, Financing, Forecast, Forecasting, Income Statement, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), NPV (Net Present Value), Payback Period, Private Equity, Private Equity Waterfall Distribution Models, Profitability Analysis, Revenue Projections, Scenario Analysis, Sensitivity Analysis, Uses and Sources of Funds, Variance Analysis, WACC (Weighted Average Cost of Capital)

The model allows the end user to toggle assumptions and visualize the deployment of a new vehicle up to a 10-year life cycle.

The user can toggle timeframes for fundraising, investment period, and fund paydown/amortization. There are inputs for the manager’s revenue (e.g., GP contribution percentage, Asset Management Fee, Servicing Fee, Promote, Hurdle Rate, Distribution/Reinvestment percentage, etc.).

In addition to these overarching assumptions laid out on the ‘Input and Output’ tab, there is a more granular employee-level cost and ramp schedule outlined in the ‘Expense Budget’ tab. There are also deal-level and leverage assumptions.

The current format allows for up to 3 different bucketed deal types. Tenor differentiates the starting buckets, but this can be adjusted per the user’s preference (i.e. geography, industry, LTV/equity cushion, etc.)

You must log in to submit a review.