Financial Projection Three Statements Model - IB & PE Standards
Originally published: 13/04/2020 07:28
Publication number: ELQ-62476-1
View all versions & Certificate
certified

Financial Projection Three Statements Model - IB & PE Standards

Three Statements Financial Model - IB & PE Standards in Microsoft Excel.

Description
Easy-to-use and update Excel model designed for the preparation of a 3 statements (Income Statement, Balance Sheet and Cash flow Statement) financial projection for an existing business. This model was built using best practices financial modelling learned in investment banking and private equity. It includes step-by-step instructions, alternative scenarios, operational outputs, checks and accurate modelling input formats.

KEY SHEETS
- Cover page: Legend, financial model architecture and introduction
- Instructions Page: Step-by-Step guide with a visual reference to the model architecture
- Dashboard: Key business summary of P&L, CF, balance sheet and automatic pre-formatted graphs
- Financials: Three statements forecast using best modelling practices
- Working Capital Schedule: Breakdown of key working capital items and forecast using two scenarios
- Capital Expenditures Schedule: Breakdown of CapEx by key fiscal categories with depreciation & amortization schedules
- Cash & Debt Schedules: Term loan and revolver schedules based on flexible debt pricing structures. Cash waterfall calculation to determine required equity injections and dividend payout.
- Actuals Financials: Centralized easy-to-update sheet for historical financials

MODEL STRUCTURE
The model is based on a logical structure aimed for simplicity and easily shareable with third parties.

MODIFICATIONS
If you require any modifications to the tool, I will be happy to assist with this. Please send me a message through the Eloquens site. I will regularly post updates as necessary.

This Best Practice includes
One Excel Model

Acquire business license for $10.00

Add to cart

Add to bookmarks

Discuss

Further information

Provide users with an effective tool to forecast the three statements of a simple company. This model uses the example of a fast-food restaurant and may be adapted to any industrial, manufacturing and consumer company

Business operating on a going-concern and evolving in the Industrial, manufacturing and consumer sectors

Business in financial distress; holding company; business operating in specialized sectors (i.e. mining, oil & gas, utilities)

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Financial Projection Three Statements Model - IB & PE Standards?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...