Question

In: Finance

Shultz Business Systems is analyzing an average-risk project, and the following data have been developed. Unit...

Shultz Business Systems is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years, it will be depreciated on a straight-line basis, and there will be no salvage value. This is just one of many projects for the firm, so any losses can be used to offset gains on other firm projects.

What is the project's expected NPV? Project cost of capital (r) 10.0% Net investment cost (depreciable basis) $200,000 Units sold 50,000 Average price per unit, Year 1 $25.00 Fixed op. cost excl. deprec. (constant) $150,000 Variable op. cost/unit, Year 1 $20.20 Annual depreciation rate 33.333% Expected inflation rate per year 5.00% Tax rate 25.0%

Solutions

Expert Solution

0 1 2 3
Sales revenue [$25.00/Unit] $      1,250,000 $     1,312,500 $   1,378,125
[5% inflation considered for years 2 &3]
Variable costs [$20.20/Unit] $      1,010,000 $     1,060,500 $   1,113,525
[5% inflation considered for years 2 &3]
Fixed operating costs $          150,000 $        150,000 $       150,000
[No inflation as it is given as constant]
Depreciation [200000*33.333%] $            66,667 $           66,667 $         66,666
NOI $            23,333 $           35,333 $         47,934
Tax at 25% $              5,833 $             8,833 $         11,984
NOPAT $            17,500 $           26,500 $         35,951
Add: Depreciation $            66,667 $           66,667 $         66,666
OCF $            84,167 $           93,167 $       102,617
Capital expenditure $          200,000
FCF $       (200,000) $            84,167 $           93,167 $       102,617
PVIF at 10% 1 0.90909 0.82645 0.75131
PV at 10% $       (200,000) $            76,515 $           76,997 $         77,097
NPV $            30,610

Related Solutions

Shultz Business Systems is analyzing an average-risk project, and the following data have been developed. Unit...
Shultz Business Systems is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years, it will be depreciated on a straight-line basis, and there will be no salvage value. This is just one of many projects for the firm, so any losses can be used to...
Desai Industries is analyzing an average risk project, and the following data have been developed Unit...
Desai Industries is analyzing an average risk project, and the following data have been developed Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also beconstant, but variable costs should rise with inflation. The project should last for 3 years, it will bedepreciated on a straight line basis, and there will be no salvage value. This is just one of many projectsfor the firm, so any losses can be used to offset gains...
Waste Management Inc. is analyzing an average-risk project, and the following data have been developed. Unit...
Waste Management Inc. is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price will increase with inflation. Fixed costs will also be constant, but variable costs will rise with inflation. The project should last for 3 years, and there will be no salvage value. This is just one project for the firm, so any losses can be used to offset gains on other firm projects. What is the project's...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years, it will be depreciated on a straight-line basis, and there will be no salvage value. No change in net operating working capital wouThis is just one of many projects for the firm, so...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years. Under the new tax law, the equipment for the project is eligible for 100% bonus depreciation, so it will be fully depreciated at t = 0. At the end of the project’s life,...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years. Under the new tax law, the equipment for the project is eligible for 100% bonus depreciation, so it will be fully depreciated at t = 0. At the end of the project’s life,...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years, it will be depreciated on a straight-line basis, and there will be no salvage value. No change in net operating working capital would be required. This is just one of many projects for...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years, it will be depreciated on a straight-line basis, and there will be no salvage value. No change in net operating working capital would be required. This is just one of many projects for...
Desai Industries is analyzing an average-risk project, and the following data have been developed. Unit sales...
Desai Industries is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years, it will be depreciated on a straight-line basis, and there will be no salvage value. No change in net operating working capital would be required. This is just one of many projects for...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales...
Poulsen Industries is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years, it will be depreciated on a straight-line basis, and there will be no salvage value. No change in net operating working capital would be required. This is just one of many projects for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT