Assignment:
1. CALCULATING PROJECT INCREMENTAL CASH FLOWS AND NPV: Atlantic Manufacturing is considering a new investment project that will last for four years. The delivered and installed cost of the machine needed for the project is $22936 and it will be depreciated according to the three-year MACRS schedule. The project also requires an initial increase in net working capital of $297. Financial projections for sales and costs are in the table below. In addition, since sales are expected to fluctuate, NWC requirements will also fluctuate. The end-of-year NWC requirements are included below (hint: these NWC capital requirements DO NOT represent the change in NWC for the period, they represent the end-of-year balance. You must calculate the change in NWC for each period). The $0 requirement for NWC at the end of year 4 means that all NWC is recovered by the end of the project The corporate tax rate is 35% and the intermediate calculations to 5 decimal places.
When using previous answers, use the rounded answer as it was given in the answer box:
|
Year
|
1
|
2
|
3
|
4
|
|
Sales
|
$11793
|
$12052
|
$13959
|
$10522
|
|
Costs
|
2196
|
2642
|
3216
|
1074
|
|
NWC Requirements
|
333
|
355
|
201
|
0
|
1. What is the project's NPV?
- Net Income Year 1
- Net Income Year 2
- Net Income Year 3
- Net Income Year 4
- Cash Flow Year 0
- Cash Flow Year 1
- Cash Flow Year 2
- Cash Flow Year 3
- Cash Flow Year 4
- NPV
2. CALCULATING EAC: You are evaluating two different milling machines to replace your current aging machine. Machine A costs $270000, has a three-year life, and has pretax operating costs of $69476 per year. Machine B costs $435000, has a five-year life, and has pretax operating costs of $34531 per year. For both milling machines, use straight-line depreciation to zero over the project's life and assume a salvage value of $35202. Your tax rate is 34 % and your discount rate is 10 %.
1. What is the EAC for Machine A?
2. What is the EAC for Machine B?
- EAC Project A
- EAC Project B
3. CALCULATING AND COMPARING NPV AND EAC: Renegade Industries is considering the purchase of a new machine for the production of latex. Machine A costs $3.1 million and will last for six years. Variable costs are 30 % of sales, and fixed costs are $1900000 per year. Machine B costs $4.94 million and will last for nine years. Variable costs for this machine are 25 % of sales and fixed costs are $1400000 per year. The sales for each machine will be $10.1 million per year. The required return is 10 %, and the tax rate is 38%. Both machines will be depreciated on a straight-line basis. The company plans to replace the machine when it wears out on a perpetual basis.
1. Calculate the NPV for each machine.
2. Calculate the EAC for each machine.
- NPV for Machine A
- NPV for Machine B
- EAC for Machine A
- EAC for Machine B
4. INCREMENTAL CASH FLOWS: Your firm is looking at setting up a new manufacturing plant in South Park to produce garden tools. The company bought some land six years ago for $5 million in anticipation of using it as a warehouse and distribution site, but the company has since decided to rent these facilities from a competitor instead. If the land were sold today, the company would net $4.8 million. The company wants to build its new manufacturing plant on this land; the plan t will cost $10.6 million to build, and the site requires $730000 worth of grading before it is suitable for construction. What is the proper cash flow amount to use as the initial investment in fixed assets when evaluating this project?
Initial Investment
5. INCREMENTAL CASH FLOWS: Winnebagel Corp. currently sells 25000 motor homes per year at $68000 each and 11000 luxury motor coaches per year at $103000 each. The company wants to introduce a new portable camper to fill out its product line; it hopes to sell 20000 of these campers per year at $13500 each. An independent consultant has determined that if Winnebagel introduces the new campers, it should boost the sales of its existing motor homes by 2,400 units per year and reduce the sales of its motor coaches by 1,100 units per year. What is the amount to use as the annual sales figure when evaluating this project?