Question
In: Finance
Dr. Chan is considering a four year project. The project requires an initial investment of $10,000,000...
Dr. Chan is considering a four year project. The project requires an initial investment of $10,000,000 to buy new equipment. The equipment will be depreciated straight line to zero over the project’s life. The company believes it can generate $5,000,000 in pretax revenues in year 1. Revenues will increase at 20% per year. Total pretax operating cost would be 40% of the pretax revenues. Net working capital will be 20% of the pretax revenue for the year. Net working capital will be fully recovered at the end of the project. Revenues and operating costs will occur at the end of the year and investment in net working capital will be made at the beginning of the year. The tax rate is 40% and the discount rate is 12%.
a.What is the NPV of the project?
b.Now compute the project’s NPV assuming the project is abandoned after one year. The equipment will be salvaged for $8,000,000. Any gain or loss due to selling the equipment for other than the book value will create taxable gain/loss.
Solutions
Expert Solution
| Year | 0 | 1 | 2 | 3 | 4 |
| 1. Initial investment | -10000000 | ||||
| 2.NWC reqd. | 1000000 | 1200000 | 1440000 | 1728000 | 0 |
| 3.Change in NWC | -1000000 | -200000 | -240000 | -288000 | 1728000 |
| 4.Pretax revenues | 5000000 | 6000000 | 7200000 | 8640000 | |
| 5.Pretax costs | -2000000 | -2400000 | -2880000 | -3456000 | |
| 6.Depn.(10000000/4) | -2500000 | -2500000 | -2500000 | -2500000 | |
| 7.EBIT (sum 4 to 6) | 500000 | 1100000 | 1820000 | 2684000 | |
| 8.Tax at 40%(7*40%) | -200000 | -440000 | -728000 | -1073600 | |
| 9.NOPAT(7+8) | 300000 | 660000 | 1092000 | 1610400 | |
| 10.Add Back :depn.(row 6) | 2500000 | 2500000 | 2500000 | 2500000 | |
| 11.Opg. Cash flow(9+10) | 2800000 | 3160000 | 3592000 | 4110400 | |
| 12. Annual FCFs(1+3+11) | -11000000 | 2600000 | 2920000 | 3304000 | 5838400 |
| 13. PV F at 12%(1/1.12^yr.n) | 1 | 0.89286 | 0.79719 | 0.71178 | 0.63552 |
| 14. PV at 12%(12*13) | -11000000 | 2321429 | 2327806 | 2351722 | 3710409 |
| 15. NPV at 12%(sum of row 14) | -288634.62 | ||||
| (ANSWER) |
| Project abandoned after 1 year | ||
| Year | 0 | 1 |
| 1. Initial investment | -10000000 | |
| 2.NWC reqd. | 1000000 | 0 |
| 3.Change in NWC | -1000000 | 1000000 |
| a.ATCF on salvage | 7800000 | |
| 4.Pretax revenues | 5000000 | |
| 5.Pretax costs | -2000000 | |
| 6.Depn.(10000000/4) | -2500000 | |
| 7.EBIT (sum 4 to 6) | 500000 | |
| 8.Tax at 40%(7*40%) | -200000 | |
| 9.NOPAT(7+8) | 300000 | |
| 10.Add Back :depn.(row 6) | 2500000 | |
| 11.Opg. Cash flow(9+10) | 2800000 | |
| 12. Annual FCFs(1+3+a+11) | -11000000 | 11600000 |
| 13. PV F at 12%(1/1.12^yr.n) | 1 | 0.89286 |
| 14. PV at 12%(12*13) | -11000000 | 10357143 |
| 15. NPV at 12%(sum of row 14) | -642857.14 | |
| (ANSWER) | ||
| Workings: | ||
| Cost | 10000000 | |
| Less:Acc. Depn. | 2500000 | |
| Carrying value | 7500000 | |
| Salvage | 8000000 | |
| Gain on salvage | 500000 | |
| Tax on gain (500000*40%) | 200000 | |
| ATCF on sale (8000000-200000) | 7800000 |
jeff jeffy answered 1 year agoRelated Solutions
Wilson, Inc., is considering a new four-year expansion project that requires an initial fixed asset investment...
Wilson, Inc., is considering a new four-year expansion project
that requires an initial fixed asset investment of $1,950,000. The
fixed asset will be depreciated straight-line to zero over its
four-year tax life, after which time it will be worthless. The
project is estimated to generate $2,145,000 in annual sales, with
costs of $1,205,000. If the tax rate is 35%, what is the Operating
Cash Flow (OCF) for this project ?
1.
$327,430.28
2.
$374,921.15
3.
$2,277,430.38
4.
$2,324.921.15
5.
$781,625.00
A firm is considering a project that requires an initial investment of $55,000. The project is...
A firm is considering a project that requires an initial
investment of $55,000. The project is expected to generate revenues
of $80,000 per year for three years. Operating expenses will be 65%
of revenues. The equipment will be depreciated on a straight-line
basis to a zero net salvage value. The equipment will have a life
of 3 years. The project feasibility study, which was just
completed, cost $35,000. The project requires an initial investment
in working capital of $5,000. Further...
• A project to replace Dr. Robert Doback’s boat requires an initial investment of $250,000 and...
• A project to replace Dr. Robert Doback’s boat requires an
initial investment of $250,000 and is expected to produce operating
earnings (before depreciation and tax (EBITDA)) of $60,000 per year
for 5 years
• Prestige Worldwide pays corporate taxes at a rate of 22% and
can depreciate the initial investment for tax purposes at 25% in
each of the first four years
• Their public debt trades at 4% and they estimate their cost of
equity at 14%, the...
A four-year project requires an initial investment of $165,000 in fixed assets and $25,000 in net...
A four-year project requires an initial investment of $165,000
in fixed assets and $25,000 in net working capital. The project has
annual year-end costs of $14,501 after taxes. The fixed assets
belong in a 20% CCA class and will have no salvage value. Any
investment in working capital is returned at the end. What is the
project's equivalent annual cost if the required return is 14% and
the firm's tax rate is 34%
Company XYZ is considering project A. Project A requires an initial investment of $75,000.
Company XYZ is considering project A. Project A requires an initial investment of $75,000. It generates $35,000 each year for the coming 3 years. What is the discounted payback period for this project if the proper discount rate is 18%?
Your company is considering a new 3-year project that requires an initial investment in equipment of...
Your company is considering a new 3-year project that requires
an initial investment in equipment of $3 million. Prior to this,
you had engaged a consultant to study the feasibility of the new
project and after an extensive market survey, the consultant
confirmed your belief that the project would be viable. Your
company is charged $100,000 for the feasibility study.
The equipment will be depreciated straight line to zero over the 3
years of its useful life. In addition, you...
Your company is considering a new 3-year project that requires an initial investment in equipment of...
Your company is considering a new 3-year project that requires
an initial investment in equipment of $3 million. Prior to this,
you had engaged a consultant to study the feasibility of the new
project and after an extensive market survey, the consultant
confirmed your belief that the project would be viable. Your
company is charged $100,000 for the feasibility study. The
equipment will be depreciated straight line to zero over the 3
years of its useful life. In addition, you...
Herman Co. is considering a four-year project that will require an initial investment of $15,000.
Herman Co. is considering a four-year project that will
require an initial investment of $15,000. The base-case cash flows
for this project are projected to be $12,000 per year. The
best-case cash flows are projected to be $20,000 per year, and the
worst-case cash flows are projected to be –$1,000 per year. The
company’s analysts have estimated that there is a 50% probability
that the project will generate the base-case cash flows. The
analysts also think that there is a...
Albert Co. is considering a four-year project that will require an initial investment of $7,000. The...
Albert Co. is considering a four-year project that will require
an initial investment of $7,000. The base-case cash flows for this
project are projected to be $15,000 per year. The best-case cash
flows are projected to be $22,000 per year, and the worst-case cash
flows are projected to be –$1,500 per year. The company’s analysts
have estimated that there is a 50% probability that the project
will generate the base-case cash flows. The analysts also think
that there is a...
Herman Co. is considering a four-year project that will require an initial investment of $12,000. The...
Herman Co. is considering a four-year project that will require
an initial investment of $12,000. The base-case cash flows for this
project are projected to be $14,000 per year. The best-case cash
flows are projected to be $26,000 per year, and the worst-case cash
flows are projected to be –$4,500 per year. The company’s analysts
have estimated that there is a 50% probability that the project
will generate the base-case cash flows. The analysts also think
that there is a...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A solar cell generates a potential difference of 0.320 V when a 445.0 ? resistor is...
- A ceiling fan consists of a small cylindrical disk with 5 thin rods coming from the...
- You measure the following quantities as A = 1.0 m ± 0.2 m, B = 2.0...
- Froya Fabrikker A/S of Bergen, Norway, is a small company that manufactures specialty heavy equipment for...
- When the electricity goes out on your campus, a backup source powers the servers that handle...
- I am having trouble with my assignment and getting compile errors on the following code. The...
- Can someone show me how to write a Haskell function using snd on a list of...
ADVERTISEMENT