Question

Purpose of Assignment The purpose of this assignment is for students to employ capital budgeting techniques using time value of money concepts to determine the acceptability of large dollar value assets. Assignment Steps Scenario: A firm has projected free cash flows of $575,000 for Year 1, $625,000 for Year 2, and 650,000 for Year 3, $725,000 for Year 4, and 850,000 for Year 5. The projected terminal value at the end of Year 5 is $6,000,000. The firm's Weighted Average cost of Capital (WACC) is 12.5%. Create a Microsoft® Excel® document to determine the Discounted Cash Flow (DCF) value of the firm based on the information provided above. Recommend acceptance of this project using net present value criteria using a Microsoft® Word® document. Include up to what level of initial investment you would accept the project? Why? Give a complete explanation of up to 350 words. Display your calculations. Coursehero

Answer 1

Answer:

Present Value 5,715,331.32

We are going to accept the project only if the initial investment is at 5,715,331 or below in order to achieve the return to support the cost of capital structure of the company

Accepting a project with a higher cost will not generate enought cashflow to sustain the patyment of debt and the return expected from the stockholders therefore, will generate a economic result and investor will leave the company for other which can sustain their desired return.

Explanation:

We are going to discount the yearly cash-flow at the given rate of 12.50%

then, the terminal value which is the present value of the future period will also be discounted at this rate.

The sum of all this will be the present value of the firm.

$\left[\begin{array}{ccc} Year& Cash Flow& Discounted\\1&575000&511111.11\\2&625000&493827.16\\3&650000&456515.77\\4&725000&452613.93\\5&850000&471689.61\\ terminal&6000000&3329573.74\\Present&Value&5715331.32\\\end{array}\right]$

The formula we use the present value of a lump sum:

$\frac{Maturity}{(1 + rate)^{time} } = PV$

We are going to accept the project only if the initial investment is at 5,715,331 or below in order to achieve the return to support the cost of capital estructure of the company