
Last version published: 02/01/2019 16:45
Publication number: ELQ-73079-6
View all versions & Certificate

Simple three statement Excel cash flow model
Simple three statement (cash flow, Balance Sheet and Income statement) forecasting model & valuation
Further information
To generate a simple forecast set of financial statements for a business and produce a valuation. The model also has the ability to enter historic balances if there are any
The user has some basic understanding of discounted cash flow valuations
The user has enough understanding of the business to enter sales, costs, working capital, and capex assumptions
The user has a basic understanding of accounting
The user requires flexibility in the tax calculations to correctly reflect their own tax jurisdiction
If the user requires more than one type of depreciation rate for assets
When the user wishes to model intangibles or the Investments balance in a flexible way (ie not held constant)
If the user requires more than one type of working capital assumptions for each of debtors, creditors and stock
Reviews
Write a review
People using this Best Practice also downloaded
More Best Practices from ModellingGuy
Personal budget Excel Model
Personal budget tool for tracking spending, setting budgets and analysing spending habits1,1651add_shopping_cart$25.00by ModellingGuy
WACC (Weighted Average Cost of Capital) Excel Calculator
WACC calculation template to help the user think about all of the components of their WACC calculation888Discussadd_shopping_cart$15.00by ModellingGuy
Solar Farm Investment Excel Model Template
Solar farm investment assessment model in Excel442Discussadd_shopping_cart$40.00by ModellingGuy
Wind Farm Investment Excel Model
Wind farm investment assessment model in Excel424Discussadd_shopping_cart$45.00by ModellingGuy
Acquisition Planning Excel Model Template
Acquisition planning model for up to 10 bolt on acquisitions (assumes that you already own the platform asset)3712add_shopping_cart$90.00by ModellingGuy
Anaerobic Digestion Plant Excel Model
Anaerobic digestion plant investment assessment model358Discussadd_shopping_cart$40.00by ModellingGuy
Platform & Bolt on Acquisition Planning Excel Model Template
Acquisition planning model including the initial purchase of a platform asset and up to 10 bolt on acquisitions310Discussadd_shopping_cart$100.00by ModellingGuy
Generic forecast financial Excel Model Template
Generic forecasting model including valuation calculations288Discussadd_shopping_cart$45.00by ModellingGuy
Basic CRM system Excel Model
Simple CRM system for tracking your team/sales contacts and leads329Discussadd_shopping_cart$25.00by ModellingGuy
The Complete Valuation Templates Bundle
This bundle of valuation templates offers a variety of corporate caluculations.291Discussadd_shopping_cart$85.00by ModellingGuy
Valuation - Best Practice Template
Valuation is both an art and a science. This template guides the user to consider multiple ways to value their company46Discussadd_shopping_cart$50.00by ModellingGuy
Mortgage payment Excel Calculator
Flexible, simple mortgage calculator in Excel/Spreadsheet188Discussadd_shopping_cart$25.00by ModellingGuy
Any questions on Simple Three Statement Excel Cash Flow Model?
The user community and author are here to help. Go ahead!