Scenario: A firm has projected free cash flows of $75,000 for Year 1, $100,000 for Year 2, and 125,000 for Year 3, $150,000 for Year 4, and 200,000 for Year 5. The projected terminal value at the end of Year 5 is $400,000. The firm's Weighted Average cost of Capital (WACC) is 12.0%.
Create a Microsoft® Excel® document to determine the Discounted Cash Flow (DCF) value of the firm based on the information provided above. Show calculations.
Display your calculations.