Question

In: Finance

A project requires an initial investment of $20,000,000. The life of the project is 3 years....

A project requires an initial investment of $20,000,000. The life of the project is 3 years. The $20,000,000 investment will be depreciated using the three-year modified accelerated cost recovery system (MACRS) class (see the table below). The firm estimates that, in the first year, the revenues and total production costs will be $60,000,000 and $45,000,000, respectively, in nominal terms. After that the sales and production costs are expected to increase at the inflation rate of 4 percent per year over the life of the project. In addition, it has a before-tax salvage value (or resale value) at the end of the project of $9,000,000. The mine will require a net working capital (NWC) investment of 7 percent of sales. The NWC will be built up in the year prior to the sales (e.g., the net working capital requirement for year 0 is 7% of sales in year 1 and the additional net working capital cash flow for year 1 is 7% of the difference in sales between year 2 and year 1). All net working capital cash flows are fully recoverable when the project ends. The tax rate is 25 percent. The project only depreciates the $20,000,000 initial cost. The salvage value is excluded from depreciation. a) Find the operating cash flow (OCF) of this project for each year. b) If the real discount rate (or required rate of return) of the project is 14 percent, what is its net present value (NPV)? Year MACRS Depreciation Allowances for 3-year Recovery Period Class 1 33.33% 2 44.44% 3 14.82% 4 7.41%

Solutions

Expert Solution

Year 1 2 3
cost of machine 20000000 20000000 20000000
MACRS rate 33.33% 44.44% 14.82%
Annual depreciation 6666000 8888000 2964000
Accumulated depreciaton 18518000
Book value of equipment at the end of year 3 20000000-18518000 1482000
gain on on sale of equipment 9000000-1482000- 7518000
tax on gain on sale of equipment 7518000*25% 1879500
after tax sale proceeds 9000000-1879500 7120500
Year 0 1 2 3
sales 60000000 62400000 64896000
required working capital-7% of next year sales -4200000 -4368000 -4542720 0
Investment in working capital -4200000 -168000 -174720 4542720
Year 0 1 2 3
cost of equipment -20000000
annual revenue = revenue in year 1*(1+inflation rate)^n 60000000 62400000 64896000
annual cost = cost in year 1*(1+inflation rate)^n 45000000 46800000 48672000
annual depreciation 6666000 8888000 2964000
operating profit 8334000 6712000 13260000
less tax-25% 2083500 1678000 3315000
after tax profit 6250500 5034000 9945000
add depreciation 6666000 8888000 2964000
after tax sale proceeds 7120500
Investment in working capital -4200000 -168000 -174720 4542720
net operating cash flow -4200000 12748500 13747280 24572220
present value factor at 14% =1/(1+r)^n r =14% 1 0.877192982 0.769467528 0.674971516
present value of net operating cash flow = net operating cash flow*present value factor -24200000 11182894.74 10578085.56 16585548.59
Net present value =sum of present value of net operating cash flow 14146528.89

Related Solutions

Project A: This project requires an initial investment of $20,000,000 in equipment which will cost an...
Project A: This project requires an initial investment of $20,000,000 in equipment which will cost an additional $3,000,000 to install. The firm will use the attached MACRS depreciation schedule to expense this equipment. Once the equipment is installed, the company will need to increase raw goods inventory by $5,000,000, but it will also see an increase in accounts payable for $1,500,000. With this investment, the project will last 6 years at which time the market value for the equipment will...
Project B: This project requires an initial investment of $20,000,000 in equipment which will require additional...
Project B: This project requires an initial investment of $20,000,000 in equipment which will require additional expense of $1,000,000 to install in the current facility. Consistent with other projects, the equipment will be depreciated using the MACRS Investment Class schedule. Once installed, the firm will need to increase inventory by $6,000,000. The project will last 6 years, but at the end of that period, the equipment will have no salvage value. During the operational period of this project, the product...
A firm is considering a project that requires an initial investment of $420,000. The life of...
A firm is considering a project that requires an initial investment of $420,000. The life of this project is five years. Cash flows for each year are estimated as follows: Year 1 Year 2 Year 3 Year 4 Year 5 $180,000 $220,000 $160,000 -$20,000 -$80,000 If the cost of capital of this project is 8%, what is the payback period of this project?
A firm is considering a project that requires an initial investment of $250,000. The life of...
A firm is considering a project that requires an initial investment of $250,000. The life of this project is five years. Cash flows for each year are estimated as follows: Year 1 Year 2 Year 3 Year 4 Year 5 $80,000 $120,000 $160,000 $40,000 -$90,000 The cost of capital of this project is 8%. Calculate the profitability index and make a decision.
A firm is considering a project that requires an initial investment of $180,000. The life of...
A firm is considering a project that requires an initial investment of $180,000. The life of this project is five years. Cash flows for each year are estimated as follows: Year 1 Year 2 Year 3 Year 4 Year 5 $105,000 $190,000 $50,000 -$60,000 -$110,000 The cost of capital of this project is 8%. Calculate the internal rate of return of the project and make a decision. Accept since the IRR is 5.04%, which is less than the required rate....
Project K requires an initial investment of $450,000, is expected to last for 7 years, and...
Project K requires an initial investment of $450,000, is expected to last for 7 years, and is expected to produce after-tax net cash flows of $92,000 per year. Project L requires $3000 initial investment and produces a net cash flow of $800 per year. The discount rate for both projects is 8%. a) What is the NPV of each project? b) What is the Profitability Index of each project? c) Which one will you choose?
A suggested project requires initial fixed assets of $227,000, has a life of 4 years, and...
A suggested project requires initial fixed assets of $227,000, has a life of 4 years, and has no salvage value. Assume depreciation is straight-line to zero over the life of the project. Sales are projected at 31,000 units per year, the price per unit is $47, variable cost per unit is $23, and fixed costs are $842,900 per year. The tax rate is 23 percent and the required return is 11.5 percent. Suppose the projections given for price and quantity...
A project with a life of 10 years has an initial fixed asset investment of $50000,...
A project with a life of 10 years has an initial fixed asset investment of $50000, an initial NWC investment of $10000 and an annual OCF of -$705000. the fixed asset is fully depreciated over the life of the project and has no salvage. If the required return is 12% what is the projects EAC?
You are investing in a project that requires an initial investment of $500,000. The project will...
You are investing in a project that requires an initial investment of $500,000. The project will last for 10 years with the following additional cash flows (CF) at the end of each year: If the discount rate is 10%, calculate the payback periods in Excel for both the methods below; Years 1 2 3 4 5 6 7 8 9 10 CF -500,000 80,000 100,000 100,000 120,000 140,000 150,000 150,000 150,000 150,000 a) Payback Method [10] b) Discounted Payback Method...
Q1) A project requires an initial investment of $5,000. It is expected that the project will...
Q1) A project requires an initial investment of $5,000. It is expected that the project will last 3 years and generate net cash flows of $3,500 for each of these years. If the discount rate for the project is 10%, the discounted payback period for the project.is: Select one: a. 1.63 years b. 2.55 years c. 1 year d. More than 3 years Q2) Capital rationing refers to the limiting of capital resources to under-performing divisions. Select one: True False...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT