Can you please help me with the formulas to calculate on the excel spreadsheet?

Capital Budgeting

BioMed Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows:

In your report, identify which project would be selected (assuming they are mutually exclusive) for each investment criterion. Note that cash outflows (costs) are given in parenthesis. Employ the Excel file to answer the following questions.

Part 1: Net Present Value

1. Use the Excel NPV function to calculate the NPV for each project at a cost of capital equal to 8%. Note the range of values in the NPV function should not include the initial cost (CF₀). Make sure to add this separately.

2. Use the Excel NPV function to calculate the NPV for each project at a cost of capital equal to 16%. Note the range of values in the NPV function should not include the initial cost (CF₀). Make sure to add this separately.

3. Construct NPV profiles (a data table of project NPVs for different costs of capital) using the Excel NPV function for Projects A and B.

4. HOW DO YOU CREATE A GRAPH ON EXCEL?? Graph both NPV profiles in a single plot with NPV on the y-axis and cost of capital on the x-axis (label the x-axis, y-axis, chart title, and axis). Use a scatter with straight lines chart type.

7 BioMed Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Time 0 9 10 11 12 13 14 15 16 17 1 2 Expected Net Cash Flows Project A Project B ($405) ($705) ($285) $200 ($205) $205 ($105) $210 $605 $215 $650 $220 $925 $225 ($200) $230 3 4 5 6 18 7 19 (See example 2 at https://support.office.com/en-us/article/NPV-function-8672CB67-2576-4D07-B67B-AC28ACF2A568) 24 A) Net Present Value at 8% Cost of Capital 25 26 Cost of capital = 27 Cost of capital = 28 29 8% NPV A = 8% NPV 3 = 31 B) Net Present Value Project at 16% Cost of Capital 32 33 Cost of capital = 34 Cost of capital = 35 16% NPVA 16% NPV 8 = Project A Project B 37 C) NPV Profiles 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Cost of Capital 0% 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% D) NPV Profiles Graph