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

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
Get step-by-step solutions from verified subject matter experts
