Financial Model, Financial Services

10-year Financial Projections, 5-year Financial Projections, Accounting, Amortization, Break-Even, Budgeting, Business Valuation, Cash Flow Analysis, Cash Flow Projections, Cost Projections, DCF Model, Debt Amortization, Debt Schedule, Debt Service Coverage, Discount Rate, Excel, Financial Feasibility, Financial Model, Financial Planning, Financial Projections, Forecast, Forecasting, Income Statement, Investment Multiple, Investor Cash Flows, IRR (Internal Rate of Return), NPV (Net Present Value), Pro-Forma, Profitability Analysis, Return on Investment (ROI), Revenue Projections, Scenario Analysis, Startup Financial Models, Terminal Value, Three Statement Model | Three Financial Statements, Valuation, Venture Capital

 

Video Instructions:

Recent Updates: Added monthly and annual financial statements (IS, BS, CF) and a detailed capitalization table as well as a dynamic capital expenditure schedule for the ATMs with connected depreciation logic.

The dynamic nature of this model is that you can plan for over 20 tranches of purchases of ATM machines in your forecasting scale-up of this type of business. Each traunch allows the user to enter deal-specific variables such as the amount of ATMs purchased, the cost per ATM, the average transactions per day, the fee per transaction, and the merchant fee.

There is also dynamic depreciation based on when machines are purchased and the variable input for useful life. This is used in the tax calculation in order to get a more accurate free cash flow figure per month and year.

There are assumptions for the length you plan to run the business for (up to 10 years) as well as the exit month if applicable, and the exit valuation (based on a revenue multiple in the exit month).

You have assumptions for debt and equity and the equity is broken down into investor / owner equity if applicable.

The cash requirement populates based on the expected monthly cash flows and looks at the minimum cash position after debt / startup costs / ATM purchases over time / revenues per month in order to default into the total upfront investment needed in order to stay cash positive.

Summaries for monthly/annual P&L and cash flow detail are available as well as a distribution summary that shows cash flow to owner and investor per %’s defined for the investor/owner. An equity multiple, IRR, ROI, total cash returned, and DCF analysis are also shown for each pool as well as at the project level.

A high-level executive summary is used to convert the annual P&L / cash flow detail into a standard revenue/COGS/expenses/EBITDA format as well as cash flow items so you can see the free cash flow per year.

The dynamic nature of this model is really useful for strategic planning and the timing assumptions for everything that affects free cash flow and equity returns.