Question: need help with this problem, please show excle formulas as well. thank you ProDom 30 po Loomin Corporation is considering a new five-year expansion project

need help with this problem, please show excle formulas as well. thank you  need help with this problem, please show excle formulas as well.
thank you ProDom 30 po Loomin Corporation is considering a new five-year

ProDom 30 po Loomin Corporation is considering a new five-year expansion project that requires an initial fixed asset investment of $560,000 The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will have no market value. The project is expected to generate $550,000 in annual sales. Variable costs are 35% of sales and fixed costs are projected to be $65,000 per year. Assume no change in net working capital (NWC) due to the project. If the tax rate is 21% and the hurdle rate is 16%, what is the project's NPV? Should the project be accepted? Assumptions Incremental sales Variable costs % of sales Fixed costs Initial investment: Depreciation method: Depreciation life Salvage value Tax rate: Discount (hurdle) rate: 0 1 1 2 3 3 Incremental sales Variable costs Fixed costs Depreciation EBIT Taxes Net income EBIT Plus: depreciation Minus: taxes Operating cash flow Operating cash flow Capital spending Net cash flow NPV: Accept? (Yes/No)

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!