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,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 equity is estimated at 12.00%. The tax rate facing the firm is 35.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 WACC for the project?

What is the cash flow for year 0? (express answer as a negative...)

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

Calculation of WACC for the project

Weight of Debt = Wd = 43%

Weight of Equity = We = 57%

Cost of Debt = rd = 10%

Cost of Equity = re = 12%

t = tax rate = 35%

WACC = [Wd * rd * (1-t)] + [We * re]

= [43% * 10% * 91-35%)] + [57% * 12%}

= 2.795% + 6.84%

= 9.635%

Therefore, WACC for the Project is 9.635%

> Cash Flow for Year 0 is -$105,167

> Cash Flow for Year 1 is $23,823.03

> NPV of the Project is -$15,197.30

Calculation of NPV of the Project
Particulars 0 1 2 3 4 5
Sales (A) 123751 123751 123751 123751 123751
Cost of Goods (B) 69125 69125 69125 69125 69125
S&A (C ) 30000 30000 30000 30000 30000
Depreciation (D) 20811.8 20811.8 20811.8 20811.8 20811.8
Profit Before Tax (E = A-B-C-D) 3814.2 3814.2 3814.2 3814.2 3814.2
Tax @35% (F = E*35%) 1334.97 1334.97 1334.97 1334.97 1334.97
Profit After Tax (G = E-F) 2479.23 2479.23 2479.23 2479.23 2479.23
Add back Depreciation (H = D) 20811.8 20811.8 20811.8 20811.8 20811.8
Investment NWC (I) -1108 532 0 0 0 576
Investment in Gross PPE (J) -104059
Free Cash Flows (K = G+H+I+J) -105167 23823.03 23291.03 23291.03 23291.03 23867.03
Discount Factor @9.635% (L)
1/(1+9.635%)^n n=0,1,2,3,4,5
1 0.912117481 0.831958299 0.758843707 0.692154611 0.63132632
Discounted Cash Flows (M = K*L) -105167 21729.40211 19377.16569 17674.25156 16120.9938 15067.88421
NPV of the Project -15197.30263

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 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...
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 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