HOW TO DO IN EXCEL. SHOW FORMULAS$)$

$($Question $1$Part $1$: NPV

Part $3$: Payback

Part $4$: Investment Projects

Part $5$: Feasible Project Combinations.

Assume the net inflows provided in the Excel file and a terminal value of $$500.$ The discount rate to use is $5\%.$ Calculate the NPV$.$

Question $2.$

Assume the net inflows provided in the Excel file and a terminal value of $$500.$ Calculate the IRR.

Question $3.$

Assume the net inflows provided in the Excel file. Calculate the cumulative cash flows and the payback.

Question $4.$

Assume the discount rates and cash flows provided in the Excel file. Use the Excel NPV function, IRR function, and the Rank.EQ function. Fill in the table.

Question $5.$

Assume a budget constraint of $$2,000.$ Using the data from Question $4,$ create all feasible project combinations $($two or more projects$).$ Fill in the table. Use Excel Conditional Formatting to identify the total NPV for the optimal project set.