Guiding Principles of Financial Modelling

All Industries, Financial Model, General Excel Financial Models

10-year Financial Projections, 5-year Financial Projections, Amortization, Break-Even, Budget, Budgeting, Cap Rate (Capitalization Rate), Cap Table, Cash Flow Analysis, Cash Flow Projections, Cash on Cash Yield, Cash-on-Cash Multiple, Cost Projections, DCF Model, Debt Amortization, Debt Schedule, Discount Rate, Dividends, eBook, Excel, Financial Analysis, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financial Statements, Forecast, Forecasting, Free Financial Model Templates, Income Statement, Investment Multiple, Investor Cash Flows, Investors, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), NPV (Net Present Value), Payback Period, PDF, Private Equity, Profitability Analysis, Scenario Analysis, Sensitivity Analysis, Startup Financial Models, Stress Test, Terminal Value, Three Statement Model | Three Financial Statements, Venture Capital

This is an attempt to list and explain the key concepts of developing financial models (also applicable to any other kinds of reports, budgets, or forecasts). I hope that after studying this guide and the accompanying Excel examples you will be able to start modelling on your own.

The publication serves two purposes:

1. Explain the general principles and demonstrate how to structure a model, set up the timeline, format cells by their purpose, make scenarios, create checks and controls, use flags.

The underlying Excel file contains a comprehensive demo model showing the most common working sheets (capital expenditure, funding, working capital, economic assumptions) and explaining how the income statement, balance sheet, and cash flow statement are built and tied together.

2. Give specific examples which cause complexities to many analysts. Such examples include circular calculations, proper demonstration of variances, calculating IRR and NPV with a few zero cashflow periods in the beginning, etc.

You will also find references to other publications I have posted. These publications dig deeper into various aspects of financial modelling and Excel and provide additional examples.

This publication is a work-in-constant-progress. Help me make it better – send me to word what else you think I should add.

Reviews

Excellent tool

By Luis on March 5, 2023 at 18:41

Excellent tool as a guide. From the Excel perspective it explain the general principles and demonstrate how to structure a model. Thumbs up

Thank you for your feedback.

192 of 412 people found this review helpful.

Excellent customer service

By Mike Bryan on March 5, 2023 at 16:43 (Verified Purchase)

I left a review for this product a few days ago thinking it was just the guide with no model. I thought no-one would read the review but customer services got back to me very quickly and pointed me in the right direction of what I had to do to download the complete product. Very helpful and efficient after-sales service. Thank you very much.

233 of 437 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

Just the Guide

By Mike Bryan on March 2, 2023 at 18:06 (Verified Purchase)

The guide looks helpful but surely it’s supposed to come with an underlying excel file as indicated in the description. I only see the pdf guide to download, not the model and the guide is not so helpful when you don’t have the underlying model.

207 of 410 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

By Lovenna on March 3, 2023 at 12:55

Dear Bryan, After checking your purchase history, you only downloaded the Free Guide; hence, you were only able to get the PDF guide. If you also downloaded the Free Materials, you will get the Excel file as mentioned in the description. Please feel free to download the Free Materials so that you can fully enjoy this Free Tool.

202 of 402 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

You must log in to submit a review.