Discounted Cash Flow Model (DCF) Excel Model

A simple DCF (Discounted Cash Flow Model) in Microsoft Excel.

by mahmoud al khateeb
Financial and Banking Expert . Ex . CFO .Ex. AuditorFollow

1,303 views|Start the discussion!|Bookmark Add to cart - $5.00

Description
This is a simple discounted cash flow model, key features of this model are:
- No need to recalculate any figure or indicators as all have been linked with formulas directly
- Can increase\ decrease factors and discount rates with spin button which has been linked automatically with the tables and all figures
- Chart is linked to the table, and dynamically connected with the factors and discount rate.
- Calculate multiple key factors automatically such like ( Pay Back Period, Net Present value (NRV) , Gross Profit and Net Profit Ratios, Discounts cash flow, Accumulated Cash Flow)
- Can work if there is additional fund in the following years
- Calculate depreciation automatically in case if you need to determine the accounting net income,
- Will show negative figures with red color (no need to do anything)
- Simple design and easy to understand and work on
- One page design, so its easy to present.

Should you have any questions on the model you're welcome to Private Message me via my Eloquens Channel or use the discussion feed below.

Feel free to leave a review and a rating if you have appreciated the model!

Mahmoud i al Khateeb
Financial and Banking Expert
ex CFO

This Best Practice includes
1 Excel File