Question

In: Finance

A firm has projected the following financials for a possible project: YEAR 0 1 2 3...

A firm has projected the following financials for a possible project:

YEAR 0 1 2 3 4 5
Sales 123,422.00 123,422.00 123,422.00 123,422.00 123,422.00
Cost of Goods 69,079.00 69,079.00 69,079.00 69,079.00 69,079.00
S&A 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00
Depreciation 22,072.20 22,072.20 22,072.20 22,072.20 22,072.20
Investment in NWC 1,152.00 540.00 540.00 540.00 540.00 540.00
Investment in Gross PPE 110,361.00


The firm has a capital structure of 48.00% debt and 52.00% equity. The cost of debt is 9.00%, while the cost of equity is estimated at 13.00%. The tax rate facing the firm is 37.00%. (Assume that you can't recover the final NWC position in year 5. i.e. only consider the change in NWC for each year)

What is the cash flow for year 1?

What is the NPV of the project? (Hint: Be careful about rounding the WACC here!)

Solutions

Expert Solution

Weighted Average Cost of Capital of the Firm,

WACC = Re * We  + Rd* (1-t) * Wd

We = Weight of Equity in Capital =  52.00% = 0.52

Wd = Weight of Debt = 48.00% = 0.48

Re = Cost of Equity =   13.00% = 0.13

Rd = Cost of Debt = 9.00% = 0.09

t =tax rate =  37.00% = 0.37

WACC = Re * We + Rd* (1-t) * Wd = 0.13 * 0.52 +  0.09 * ( 1 - 0.37) * 0.48 = 0.094816

Now we will Calculate NPV of the Project :

Step 01 :

Row 10 : Here for Year 0 we have calculate total Investment in Year 01 =  Investment in NWC + Investment in Gross PPE = 1152 + 110361 = 111, 513 (- Ve Sign Indiate Net cash Outflow)

EBIT From Year 01 onwards : Sales - ( Cost of Goods + S&A + Depreciation +  Investment in NWC )

Step 02 :

Row 11 : Tax Payble = Tax Rate * EBIT

Step 03 :

Row 12 : Net Operating Cash Flow = EBIT - Tax + Depreciaton

Step 04 :

Row 13 : PV Factor = 01 / (01 + WACC)^Year

Step 05 :

Row 14 :  PV of Cash Flow = PV Factor * Net Operating Cash Flow

Step 06 :

Row 15 :  NPV = Sum of All PV of Cash Flow

NPV of the Project is = - 22,533 . 1985 (ANS)


Related Solutions

A firm has projected the following financials for a possible project: YEAR 0 1 2 3...
A firm has projected the following financials for a possible project: YEAR 0 1 2 3 4 5 Sales 136,856.00 136,856.00 136,856.00 136,856.00 136,856.00 Cost of Goods 62,752.00 62,752.00 62,752.00 62,752.00 62,752.00 S&A 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 Depreciation 20,519.20 20,519.20 20,519.20 20,519.20 20,519.20 Investment in NWC 1,171.00 542.00 542.00 542.00 542.00 542.00 Investment in Gross PPE 102,596.00 The firm has a capital structure of 33.00% debt and 67.00% equity. The cost of debt is 8.00%, while the cost of...
A firm has projected the following financials for a possible project: Year 0 1 2 3...
A firm has projected the following financials for a possible project: Year 0 1 2 3 4 5 Sales 128,086 128,086 128,086 128,086 128,086 COGS 60,876 60,876 60,876 60,876 60,876 S&A 30,000 30,000 30,000 30,000 30,000 Depreciation 22,696.80 22,696.80 22,696.80 22,696.80 22,696.80 Investment in NWC 1,126.00 598 598 598 598 598 Investment in Gross PPE 113,484.00 The firm has a capital structure of 36.00% debt and 64.00% equity. The cost of debt is 10.00%, while the cost of equity is...
A firm has projected the following financials for a possible project: YEAR 0 1 2 3...
A firm has projected the following financials for a possible project: YEAR 0 1 2 3 4 5 Sales 123,751.00 123,751.00 123,751.00 123,751.00 123,751.00 Cost of Goods 69,125.00 69,125.00 69,125.00 69,125.00 69,125.00 S&A 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 Depreciation 20,811.80 20,811.80 20,811.80 20,811.80 20,811.80 Investment in NWC 1,108.00 576.00 576.00 576.00 576.00 576.00 Investment in Gross PPE 104,059.00 The firm has a capital structure of 43.00% debt and 57.00% equity. The cost of debt is 10.00%, while the cost of...
A firm has projected the following financials for a possible project: YEAR 0 1 2 3...
A firm has projected the following financials for a possible project: YEAR 0 1 2 3 4 5 Sales 124,757.00 124,757.00 124,757.00 124,757.00 124,757.00 Cost of Goods 65,261.00 65,261.00 65,261.00 65,261.00 65,261.00 S&A 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 Depreciation 20,786.40 20,786.40 20,786.40 20,786.40 20,786.40 Investment in NWC 1,197.00 559.00 559.00 559.00 559.00 559.00 Investment in Gross PPE 103,932.00 The firm has a capital structure of 34.00% debt and 66.00% equity. The cost of debt is 10.00%, while the cost of...
Suppose for a project X, it is estimated to have the following financials in Year 0...
Suppose for a project X, it is estimated to have the following financials in Year 0 and Year 1. Suppose the project requires to buy a new piece of equipment which costs $9,000. It has a useful life of three years and a salvage value of $0 at the end of 3rd year. The changes in NWC (NOT the cash effect of change in NWC) at Year 0 and Year 1 are $5,000 and $2,000 respectively. The free cash flow...
3. AICC is considering the following two projects: (2 pts) Project Year 0 1 2 3...
3. AICC is considering the following two projects: (2 pts) Project Year 0 1 2 3 A Cash flows -$50 $15 $25 $25 B Cash flows -$50 $20 $25 $30 a. If these projects are mutually exclusive, which project should the company invest in based on the NPV and IRR if the WACC = 10%? b. Calculate MIRR, payback period, and discounted payback period for the project you chose to invest in from part A only.
Glasgow company has the following financial data for project X (3-year project): Year 0 Year 1...
Glasgow company has the following financial data for project X (3-year project): Year 0 Year 1 Year 2 Year 3 CF -10,000 5,000 4,000 4,000 The company’s capital structure is distributed equally between debt, preferred stock and common stock. It has also the following information: 1- After tax cost of debt: 5.8%. Tax rate: 40% 2- Preferred stocks are selling at $65 per share and pay a dividend of $8 per share 3- Common stocks are selling at $40 per...
The projected net cash flows for a project are (in $thousands): Year Year 0 Year 1...
The projected net cash flows for a project are (in $thousands): Year Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 $(350) $40 $100 $210 $260 $160 Assuming the initial investment is depreciated over the life of the project, the accounting rate of return for the project is Select one: a. 40% b. 25% c. 48% d. 33%
Project Wind Power Year 0 Year 1 Year 2 Year 3 Costs $6,000,000 $4,000,000 $0 $0...
Project Wind Power Year 0 Year 1 Year 2 Year 3 Costs $6,000,000 $4,000,000 $0 $0 Benefits $18,000,000 $15,000,000 $12,000,000 $12,000,000 Project Hydroelectric power Year 0 Year 1 Year 2 Year 3 Costs $4,000,000 $2,000,000 $1,000,000 $0 Benefits $10,000,000 $14,000,000 $15,000,000 $16,000,000 If the interest rate is 3%, which project would you choose and why? Show your work using excel (15 points) If the interest rate is 15%, which project would you choose and why? Show your work using excel...
1) A project has the following cash flows: Year 0 -$22,500, Year 1 $12,650, Year 2...
1) A project has the following cash flows: Year 0 -$22,500, Year 1 $12,650, Year 2 $10,900, and Year 3 $6,500. What is the IRR of the project? Please round your answer to two decimal places. 2) Following question 1, suppose the cost of capital is 15%. Would you accept or reject the project according to the IRR criterion? Accept or Reject 3) Following questions 1 and 2, which of the following statements about the IRR rule is false? -...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT