Question: How to do those on excel? Plz provide the process, thanks. Universal Farm Supply's management team has observed that the company can sell as much
How to do those on excel? Plz provide the process, thanks.

Universal Farm Supply's management team has observed that the company can sell as much fertilizer as it can stock. They are considering purchasing a forklift and additional warehouse space to stock more fertilizer. The forklift costs $86,000 and will be depreciated to a salvage value of $0 in 5 years even though it is expected to last the life of the project. The additional warehouse space costs $152,000 and will be depreciated to a salvage value of $65,000 over 15 years. At the end of that year the project will be wound down, and the warehouse and forklift will be sold for an estimated $55,000. If the forklift and warehouse space are purchased it will allow Universal to sell an additional 1,700,000 pounds of fertilizer annually. Universal sells fertilizer for $0.65 per pound, and it costs $0.57 per pound. The increase in sales will require an additional $49,000 in Net Working Capital. Universal, marginal tax rate is 26%, and the required return for this project is 17%. Fill in all the missing information to project the cash flows for Universal's proposed expansion. Cost Forklift 86,000 Warehouse 152,000 65,000 15 5,800.00 Salvage Value \ Life Depreciation Scrap Value \ Change in NWC Sales Increase Price per Pound Cost per Pound Profit per Pound Tax Rate Required Return 5 17,200.00 55.000 49,000 1,700,000 0.65 0.57 0.08 26% 17% Profits One Time CFS (115.000.00) Depreciation Year 0 1 2 3 4 5 6 7 W Taxes After Tax CFS W (115,000.00) 29,380.00 106,620.00 W 29,380.00 \ 106,620.00 29,380.00 106,620.00 29,380.00 W 106,620.00 29,380.00 106.620.00 W 29,380.00 106,620.00 W 29,380.00 106,620.00 29.380.00 W 106.620.00 W 29,380.00 106,620.00 29,380.00 W 106,620.00 W 29,380.00 W 106,620.00 W 29,380.00 W 106,620.00 29,380.00 106.620.00 29.380.00 106,620.00 29,380.00 106,620.00 W 136,000.00 136,000.00 136,000.00 136,000.00 136,000.00 W 136,000.00 136,000.00 136,000.00 136,000.00 136,000.00 136,000.00 136,000.00 136,000.00 136,000.00 136,000.00 W PV (115,000.00 91.128.21 77,887.35 66,570.39 56,897.77 48,630.57 41,564.59 35,525.29 30,363.50 25,951.71 22.180.95 18,958.07 16,203.48 13,849.13 11,836.86 10,116.98 23,000.00 23,000.00 W 23,000.00 W 23,000.00 23,000.00 23,000.00 23,000.00 23,000.00 23,000.00 23,000.00 W 23,000.00 23,000.00 23.490.00 23.000 23,000.00 8 9 10 11 12 13 14 15 \ \ \ What are the net present value and internamate of return for the expansion? Should Universal expend? NPV IRR Expand? 452,664.84 93% Yes
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
