Question: Answer in excel with formulas 3. Determine the NPV and IRR of the following project. The following information is available: Initial Investment Tax Rate .....
Answer in excel with formulas
3. Determine the NPV and IRR of the following project. The following information is available: Initial Investment Tax Rate ..... Annual Expected Sale for years 1-5 Annual Expected Sale for years 6 10. Costs $20,000,000 .....34% $50,000,000 $40,000,000 55% of sales Assume that Costs do not include depreciation or interest expense. Assume straight line depreciation. Accounts receivable is 25% of next year Sales; cash is 5% of next year sales; Inventory is 10% of next year sales; and accounts payable is 15% of next year sales. Assume that the ATWACOC = 10%. Would you accept the project? (15 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
