Cash Flow Model Excel Template with Monthly Cash Flows, Scenarios, DCF, Capital Structure and Debt Model

An extended Excel version of a Cash Flow financial model with a free video tutorial.

Original Tool:  Simple Cash Flow Model Excel Template  by Jacek Polewski

Description
The model consists of the following sections:

1. Content - lists all the sheets with links for easy navigation.

2. Assumptions/Scenarios - lists the main drivers behind market, revenue and costs growth. The scenario selection allows you to create a quick sensitivity analysis and see how a change in assumptions affect your returns and other outputs of the model.

3. Cash Flow model - a monthly model which calculates the projections for market growth, revenues and costs based on the inputs from the 'Assumptions' sheet.

4. Summary and Returns - aggregates the output from the 'Cash Flow model' sheet. The 'Returns' section provides a simple calculations for IRRs, NPVs and projected cash requirement.

5. Graphs - presents output of the model in a visual form. Important sheet if you need to use the model for PowerPoint or other means of presentation.

6. DCF and Capital Structure - calculates the Discounted Cash Flows (DCF) based on the supplied discount rates. The 'Capital Structure' breaks the required investment into tranches of equity and calculates returns for each of them separately.

7. Debt Model - provides a simple model for a loan injections with amortisation table, payment, principal and interest calculations.

8. P&L, Cash Flow and Balance Sheet statements - presents the output of the 'Cash Flow model' in a more structured form (something that accountants will especially enjoy!:)

If you have any questions leave a comment below or go to http://www.challengejp.com/contact to reach me directly or send me a private message via Eloquens.com (on my Channel).

- Jacek

This business tool includes
1 Excel template file

Jacek Polewski offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

The main objective of the tool is to give the reader an example of how to project their cash flows whether it is for external fund raising purposes or internally for budgeting.

Internal budgeting, cash flow planning, fund raising, investment presentations

It is a generic template so the user will need to tailor the assumptions and main drivers to their own needs

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Cash Flow Model Excel Template With Monthly Cash Flows, Scenarios, DCF, Capital Structure And Debt Model?

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

please wait...