Question: Could someone help me work this problem out in excel please? Universal Farm Supply's management team has observed that the company can sell as much

Could someone help me work this problem out in excel please? UniversalCould someone help me work this problem out in excel please?

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 $62,000 and will be depreciated to a salvage value of $0 in 6 years even though it is expected to last the life of the project. The additional warehouse space costs $129,000 and will be depreciated to a salvage value of $55,000 over 11 years. At the end of that year the project will be wound down, and the warehouse and forklift will be sold for an estimated $41,000. If the forklift and warehouse space are purchased it will allow Universal to sell an additional 2,200,000 pounds of fertilizer annually. Universal sells fertilizer for $0.57 per pound, and it costs $0.47 per pound. The increase in sales will require an additional $42,000 in Net Working Capital. Universal's marginal tax rate is 25%, and the required return for this project is 20%. Fill in all the missing information to project the cash flows for Universal's proposed expansion. Forklift 62,000 $ $ Warehouse $ 129,000 $ 55,000 11 6 $ $ Cost Salvage Value Life Depreciation Scrap Value Change in NWC Sales Increase Price per Pound Cost per Pound Profit per Pound Tax Rate Required Return 41,000 42,000 2,200,000 0.57 0.47 $ $ 25% 20% Year One Time CFS Profits Depreciation Taxes After Tax CFS PV 0 1 2 3 4 5 6 7 8 9 10 11 What are the net present value and internal rate of return for the expansion? Should Universal expand? NPV IRR Expand

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!