How to Build an After-Tax Discounted Cash Flow Model from Scratch

Last Updated on 28-Mar-2023 by Charles Maxwell

This video shows how to build a discounted cash flow spreadsheet.  It starts with a blank Excel workbook and constructs an after-tax, discounted cash flow model for a project lasting 20 years.  If you want to follow along, download the workbook at: www.toweringskills.com/docs/FA001.xlsx.

Links to Important Concepts and Procedures in the Video

• Excel Styles
• Cash Flow Assumptions
• Revenue and Operating Cost
• Income Tax
• Capital
• Cash Flow
• Depreciation
• Maximum Capital at Risk (MCR)
• Net Present Value (NPV)
• Benefit Cost Ratio (BCR)
• Internal Rate of Return (IRR)
• Payback
• Modifying and Using the Spreadsheet