Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by nis division's return on investment (ROI), which has been above 22% each of the (ROI), which has been above 22% each of the last three years. Casey is considering a capital budgeting project that would require a $3,800,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company's discount rate is 18%. All sales are collected in cash, all variable expenses are paid in cash during the year they are incurred, and all out-of- pocket fixed expenses are paid in cash during the year they are incurred. The project would provide net operating income each year for five years as follows: Sales Variable expenses $3,700,000 1,720,000 1,980,000 Contribution margin Fixed expenses: Advertising, salaries, and other fixed out-of-pocket costs Depreciation $730,000 760,000 Total fixed expenses 1,490,000 Net operating income $ 490,000 Required: 1. What are the annual net cash inflows for this project? Annual Net Cash Inflows 2. What is the present value of the cash inflows? (Use Microsoft Excel to calculate present values. Do not round intermediate calculations.) Present value of Cash Inflows Required: 1. What are the annual net cash inflows for this project? Annual Net Cash Inflows 2. What is the present value of the cash inflows? (Use Microsoft Excel to calculate present values. Do not round intermediate calculations.) Present value of Cash Inflows 3. What is the project's net present value? (Use Microsoft Excel to calculate present values. Do not round intermediate calculations.) Net present value 4. What is the project's internal rate of return? (Use Microsoft Excel to calculate present values. Round your percentage to two decimal places.) Internal rate of return Screenshot saved The screenshot was added to your OneDrive. OneDrive 4-a. Would the company want Casey to pursue this investment opportunity? Yes O No Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by nis division's return on investment (ROI), which has been above 22% each of the (ROI), which has been above 22% each of the last three years. Casey is considering a capital budgeting project that would require a $3,800,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company's discount rate is 18%. All sales are collected in cash, all variable expenses are paid in cash during the year they are incurred, and all out-of- pocket fixed expenses are paid in cash during the year they are incurred. The project would provide net operating income each year for five years as follows: Sales Variable expenses $3,700,000 1,720,000 1,980,000 Contribution margin Fixed expenses: Advertising, salaries, and other fixed out-of-pocket costs Depreciation $730,000 760,000 Total fixed expenses 1,490,000 Net operating income $ 490,000 Required: 1. What are the annual net cash inflows for this project? Annual Net Cash Inflows 2. What is the present value of the cash inflows? (Use Microsoft Excel to calculate present values. Do not round intermediate calculations.) Present value of Cash Inflows Required: 1. What are the annual net cash inflows for this project? Annual Net Cash Inflows 2. What is the present value of the cash inflows? (Use Microsoft Excel to calculate present values. Do not round intermediate calculations.) Present value of Cash Inflows 3. What is the project's net present value? (Use Microsoft Excel to calculate present values. Do not round intermediate calculations.) Net present value 4. What is the project's internal rate of return? (Use Microsoft Excel to calculate present values. Round your percentage to two decimal places.) Internal rate of return Screenshot saved The screenshot was added to your OneDrive. OneDrive 4-a. Would the company want Casey to pursue this investment opportunity? Yes O No