Question

In: Finance

You have the following cost and revenue information on a project that invests in the conversion...

  1. You have the following cost and revenue information on a project that invests in the conversion of a coal-fired electricity generating plan into a gas-fired unit.

Cost of new equipment: $200 million.

The equipment will be depreciated over 8 years on a straight-line basis to zero book value.

Proceeds from the sale of old equipment which has a book value of $15 m is 40 million,

Expensible installation cost: 0.50 million.

Estimated Revenue from the sale of electricity in the first year: $65 million and it remains the same for all 5 years;

Cost of gas: $25 million;

Operating and other expenses: $4 million;

Initial working capital expenses: $1 million;

Project’s assets estimated resale value: $65 million.

The project is subject to a tax rate of 30%,

Anticipated clean-up expense: $1.0 million.

The investment is eligible for $1.0 million investment tax credit.

The weighted average cost of capital (WACC) of the project is 5%.

Using these data,

  1. calculate the following cash flows associated with the project: (i) Net initial investment outlay; (ii) Net operating cash flows (NOCF) also known as CFAT and (iii) net salvage value, and

assuming that the net operating cash flows will remain the same for all five years, calculate the NPV and the IRR of the project.

Please show all work

Solutions

Expert Solution

(i) Net initial investment outlay
A Cot of equipment ($200,000,000)
B Proceeds from sale of equipment $40,000,000
C Book value of old equipment $15,000,000
D=B-C Gain on sale of old equipment $25,000,000
E Tax rate 30%
F=D*E Tax on gain onsale of old equipment $7,500,000
G=B-F Net cash flow from sale of old equipment $32,500,000
H Expensible installation cost ($500,000)
I Initial Working capital expenses ($1,000,000)
J Investment Tax Credit $1,000,000
K=A+G+H+I+J Net initial investment outlay ($168,000,000)
(ii) Net Operating Cash Flow
L Depreciable Assets $200,500,000 (200000000+500000)
M=L/8 Annual Depreciation $25,062,500
N Annual Revenue $65,000,000
P Cost of gas ($25,000,000)
Q Operating and other expenses ($4,000,000)
R Depreciation expenses ($25,062,500)
S=N+P+Q+R Income before taxes $10,937,500
T=S*30% Taxe expenses -$3,281,250
U=S+T Operating Income $7,656,250
V Depreciation expenses(Non cash) $25,062,500
W=U+V Net Operating Cash Flow $32,718,750
(iii) Net salvage value
X=5*V Accumulated Depreciation at end of year5 $125,312,500
Y=L-X BookValue at end of 5 years $75,187,500
RV Resale value at end of year 5 $65,000,000
LR=Y-RV Loss on Resale $10,187,500
TS=LR*0.3 Tax saving on loss $3,056,250
Z=RV+TS Net salvage value $68,056,250
CALCULATION OF NPV and IRR
Present Value (PV) of Cash Flow:
(Cash Flow)/((1+i)^N)
i=Discount Rate=WACC=5%=0.05
N=Year of Cash Flow
N Year 0 1 2 3 4 5
a Net Initial Investment Outlay ($168,000,000)
b Net Operating Cash Flow $32,718,750 $32,718,750 $32,718,750 $32,718,750 $32,718,750
c Net salvage value $68,056,250
d Release of initial working capital $1,000,000
e Clean up expenses ($1,000,000)
f=a+b+c+d+e Net Cash Flow ($168,000,000) $32,718,750 $32,718,750 $32,718,750 $32,718,750 $100,775,000 SUM
PV=f/(1.05^N) Present Value of Net Cash Flow ($168,000,000) $31,160,714 $29,676,871 $28,263,686 $26,917,797 $78,959,849 $26,978,917
NPV=Sumof PV Net Present Value (NPV) $26,978,917
Internal Rate of Return (IRR) 9.67% (Using IRR function of excel   over Net CashFlow)

Related Solutions

You have the following cost and revenue information on a project that invests in the conversion...
You have the following cost and revenue information on a project that invests in the conversion of a coal-fired electricity generating plan into a gas-fired unit. Cost of new equipment: $200 million. The equipment will be depreciated over 8 years on a straight-line basis to zero book value. Proceeds from the sale of old equipment which has a book value of $15 m is 40 million, Expensable installation cost: 0.50 million. Estimated Revenue from the sale of electricity in the...
you have calculated the following , fixed cost = $6000/month , variable cost = $3/unit, revenue...
you have calculated the following , fixed cost = $6000/month , variable cost = $3/unit, revenue = $8/ unit. 1. what is the break even point of the process. 2. quantity to produce for profit of $2000 per year
You are analyzing the following two projects and have developed the following information. Project A |...
You are analyzing the following two projects and have developed the following information. Project A | Project B Year | Cash flow | Cash flow 0 | -$50,000 | -$50,000 1 | $31,000 | $42,000 2 | $26,000 | $21,000 3 | $27,000 | $18,000 5. What is the crossover rate of the two projects? 6. Project A and B are mutually exclusive. Which project(s) should be chosen if the required return is 8%? Why? 7. Project A and B...
Measuring Economic Exposure. Assume you live in the U.S. Using the following cost and revenue information...
Measuring Economic Exposure. Assume you live in the U.S. Using the following cost and revenue information shown for DeKalb, Inc., a) determine how the costs, revenue, and net cash flow would be affected by three possible exchange rate scenarios for the New Zealand dollar (NZ$):             1) NZ$ = $0.55,             2) NZ$ = $0.60, and             3) NZ$ = $0.65.             b) What is your conclusion?             15 Marks     Note: PCFt is the percentage change in inflation-adjusted cash flows...
Using the following cost and revenue information for Prestige Worldwide (PWW), determine how the costs, revenue,...
Using the following cost and revenue information for Prestige Worldwide (PWW), determine how the costs, revenue, and cash flow items would be affected by the possible exchange rate scenarios for the pound: (1) £ = $1.20, (2) £= $1.25, and (3) £= $1.30. Would Prestige Worldwide be favorably or unfavorably affected by a weakening pound? Why? Explain. Assume that U.S. sales will be unaffected by the exchange rate. Also, assume that £ earnings will be remitted to the U.S. parent...
Uber is considering a new project. You have the following information: • Estimate life of the...
Uber is considering a new project. You have the following information: • Estimate life of the project is 3 years. • Expect sales of $15,000,000 for the first year of the forecast with sales to grow by 25% and 10%, respectively, for years 2 & 3. • Variable costs (COGS) are 60% of sales. Fixed costs (SG&A) are $2,000,000 per year. • They require a machine that costs $11,000,000 and will be depreciated using MACRS under a 3-year convention (.3333/.4445/.1481/.0741)...
You have the following information for a Croatian company Revenue (Croatian Kuna) CDS spread Standard Dev...
You have the following information for a Croatian company Revenue (Croatian Kuna) CDS spread Standard Dev of gov't bond Standard Deviation of Stock Market EU (excluding Croatia) 120 0.5% 4% 8% South-easter Europe 180 3% 9% 14% Croatia 250 2% 7% 12% German Euro bond rate = 0.50%. Croatian Gov't Bond, in local currency Kuna has a rate of 4%. Kuna's credit rating is 2%, the same as implied by the CDS spread. Estimate the cost of equity for this...
1: given the following information: Costs: direct Total cost materials Conversion Beginning Inventory $ 9,400 $...
1: given the following information: Costs: direct Total cost materials Conversion Beginning Inventory $ 9,400 $ 9,000 $ 400 Costs added: 20,000 15,000 5,000 Total cost $ 29,400 $24,000 $ 5,400 Percent Complete Materials Conversion Units transferred out: 1,000 units Ending inventory 200 units 100% 40% 1,200 units • Calculate the equivalent units with respect to direct materials and with respect to conversion costs under weighted average process costing. • Calculate the total cost assigned to the 1,000 units transferred...
You have the following information on a project's cash flows. The cost of capital is 8.0%
  You have the following information on a project's cash flows. The cost of capital is 8.0% Year Cash flows 0 -$101,000 1 23,000 2 23,000 3 25,000 4 32,000 5 61,000 The NPV of the project is $____. Round to two decimal places.
1. You have the following information on a project's cash flows. The cost of capital is...
1. You have the following information on a project's cash flows. The cost of capital is 16.1%. Year Cash Flows 0 -$105,000 1 47,000 2 13,000 3 31,000 4 39,000 5 -24,000 The NPV of the project is $____. Round to two decimal places. 2. Given a face value of $1,000 and 19 years to maturity, what is the price of a zero coupon bond if rates are at 6.7 percent (assume semi-annual compounding)? (Round your answer to 2 decimal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT