Problem #3 at the bottom please:

B D E F G H 1 J K L M N o 10% 1 2 3 4 5 3003000 4680000 3867768.595 3096000 2326070.624 3640000 2486168.978 2730000 14,486,673.35 4955000 3076665.156 Calculate the PV of each cash flow in this row Add the PV amounts to obtain the total PV $14,486,673.35 Use the NPV formula to complete the same process in one step A 1 Excel exercises - complete the boxes 2 3 1 4 PV exercise 5 Discount rate 6 7 Net cash flows from operating activities 8 PV of CF 9 Total PV 10 11 PV 12 13 CAGR of cash flows 14 15 2 16 17 Projected cash flow 18 CAGR 19 PV of CF 20 Total PV 21 22 23 24 25 13.34% Calculate the CAGR of cash flows from time 1 to time 4 3403513.001 3857442.806 4371913.666 3003000 13.34% 4955000 Use the CAGR in exercise 1 to obtain forecast cash flows From exercise 1 3076665.156 Calculate the PV of each cash flow in this row Add the PV amounts to obtain the total PV 2812820.662 2898153.874 2986075.86 2730000 $14,503,715.55 Complete the Data Table sensitivity analysis Data Table Discount rate 14503715.55 8% 10% 12% 10.00% $14,427,319.60 $13,650,000.00 $12,935,929.20 13.34% $15,347,282.92 $14,504,480.95 $13,730,903.48 15.00% $15,825,634.33 $14,948,607.63 $14,143,938.27 20.00% $17,355,057.24 $16,367,879.93 $15,463,182.50 26 CAGR 27 28 29 30 31 32 3 33 34 35 Start with your completed assignment 1 Label this scenario as the baseline scenario. Create two new scenarios named optimistic and pessimistic by changing the following in scenario manager: Optimistic: Each cash flow is slightly (you can define slightly) higher and the discount rate is slightly lower Pessimistic Each cash flow is slightly (you can define slightly) lower and the discount rate is slightly higher 36 37 B D E F G H 1 J K L M N o 10% 1 2 3 4 5 3003000 4680000 3867768.595 3096000 2326070.624 3640000 2486168.978 2730000 14,486,673.35 4955000 3076665.156 Calculate the PV of each cash flow in this row Add the PV amounts to obtain the total PV $14,486,673.35 Use the NPV formula to complete the same process in one step A 1 Excel exercises - complete the boxes 2 3 1 4 PV exercise 5 Discount rate 6 7 Net cash flows from operating activities 8 PV of CF 9 Total PV 10 11 PV 12 13 CAGR of cash flows 14 15 2 16 17 Projected cash flow 18 CAGR 19 PV of CF 20 Total PV 21 22 23 24 25 13.34% Calculate the CAGR of cash flows from time 1 to time 4 3403513.001 3857442.806 4371913.666 3003000 13.34% 4955000 Use the CAGR in exercise 1 to obtain forecast cash flows From exercise 1 3076665.156 Calculate the PV of each cash flow in this row Add the PV amounts to obtain the total PV 2812820.662 2898153.874 2986075.86 2730000 $14,503,715.55 Complete the Data Table sensitivity analysis Data Table Discount rate 14503715.55 8% 10% 12% 10.00% $14,427,319.60 $13,650,000.00 $12,935,929.20 13.34% $15,347,282.92 $14,504,480.95 $13,730,903.48 15.00% $15,825,634.33 $14,948,607.63 $14,143,938.27 20.00% $17,355,057.24 $16,367,879.93 $15,463,182.50 26 CAGR 27 28 29 30 31 32 3 33 34 35 Start with your completed assignment 1 Label this scenario as the baseline scenario. Create two new scenarios named optimistic and pessimistic by changing the following in scenario manager: Optimistic: Each cash flow is slightly (you can define slightly) higher and the discount rate is slightly lower Pessimistic Each cash flow is slightly (you can define slightly) lower and the discount rate is slightly higher 36 37 B D E F G H 1 J K L M N o 10% 1 2 3 4 5 3003000 4680000 3867768.595 3096000 2326070.624 3640000 2486168.978 2730000 14,486,673.35 4955000 3076665.156 Calculate the PV of each cash flow in this row Add the PV amounts to obtain the total PV $14,486,673.35 Use the NPV formula to complete the same process in one step A 1 Excel exercises - complete the boxes 2 3 1 4 PV exercise 5 Discount rate 6 7 Net cash flows from operating activities 8 PV of CF 9 Total PV 10 11 PV 12 13 CAGR of cash flows 14 15 2 16 17 Projected cash flow 18 CAGR 19 PV of CF 20 Total PV 21 22 23 24 25 13.34% Calculate the CAGR of cash flows from time 1 to time 4 3403513.001 3857442.806 4371913.666 3003000 13.34% 4955000 Use the CAGR in exercise 1 to obtain forecast cash flows From exercise 1 3076665.156 Calculate the PV of each cash flow in this row Add the PV amounts to obtain the total PV 2812820.662 2898153.874 2986075.86 2730000 $14,503,715.55 Complete the Data Table sensitivity analysis Data Table Discount rate 14503715.55 8% 10% 12% 10.00% $14,427,319.60 $13,650,000.00 $12,935,929.20 13.34% $15,347,282.92 $14,504,480.95 $13,730,903.48 15.00% $15,825,634.33 $14,948,607.63 $14,143,938.27 20.00% $17,355,057.24 $16,367,879.93 $15,463,182.50 26 CAGR 27 28 29 30 31 32 3 33 34 35 Start with your completed assignment 1 Label this scenario as the baseline scenario. Create two new scenarios named optimistic and pessimistic by changing the following in scenario manager: Optimistic: Each cash flow is slightly (you can define slightly) higher and the discount rate is slightly lower Pessimistic Each cash flow is slightly (you can define slightly) lower and the discount rate is slightly higher 36 37 B D E F G H 1 J K L M N o 10% 1 2 3 4 5 3003000 4680000 3867768.595 3096000 2326070.624 3640000 2486168.978 2730000 14,486,673.35 4955000 3076665.156 Calculate the PV of each cash flow in this row Add the PV amounts to obtain the total PV $14,486,673.35 Use the NPV formula to complete the same process in one step A 1 Excel exercises - complete the boxes 2 3 1 4 PV exercise 5 Discount rate 6 7 Net cash flows from operating activities 8 PV of CF 9 Total PV 10 11 PV 12 13 CAGR of cash flows 14 15 2 16 17 Projected cash flow 18 CAGR 19 PV of CF 20 Total PV 21 22 23 24 25 13.34% Calculate the CAGR of cash flows from time 1 to time 4 3403513.001 3857442.806 4371913.666 3003000 13.34% 4955000 Use the CAGR in exercise 1 to obtain forecast cash flows From exercise 1 3076665.156 Calculate the PV of each cash flow in this row Add the PV amounts to obtain the total PV 2812820.662 2898153.874 2986075.86 2730000 $14,503,715.55 Complete the Data Table sensitivity analysis Data Table Discount rate 14503715.55 8% 10% 12% 10.00% $14,427,319.60 $13,650,000.00 $12,935,929.20 13.34% $15,347,282.92 $14,504,480.95 $13,730,903.48 15.00% $15,825,634.33 $14,948,607.63 $14,143,938.27 20.00% $17,355,057.24 $16,367,879.93 $15,463,182.50 26 CAGR 27 28 29 30 31 32 3 33 34 35 Start with your completed assignment 1 Label this scenario as the baseline scenario. Create two new scenarios named optimistic and pessimistic by changing the following in scenario manager: Optimistic: Each cash flow is slightly (you can define slightly) higher and the discount rate is slightly lower Pessimistic Each cash flow is slightly (you can define slightly) lower and the discount rate is slightly higher 36 37