C4C Excel 710 BOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW M Calibri General WE Autom F- BIU. == TWIN TH A. Merge Center Anment Repy mat Pavel Clip card 36 Insert Delete Format Sort finde 9. Conditional Format Cell Formatting Table Styles Styles Tont Num CH Tating Form B X G C M H N E Your division is considering two investment projects, each of which requires an up front expenditure of 45 million. You estimate that the investments will produce the following net cash flows Project A Project Project Project 145.000.000 145,000,000) 145,000,000 145,000.000 1 15,000,000 30,000,000 14,000,000 12.000.000 2 10.000.000 10.000.000 10,000,000 20,000,000 3 5.000.000 2,000,000 13,000,000 20,000,000 4 21,000,000 3.000.000 6,000,000 7.000.000 Now create a table that shows the FV0l 35for till 25 years. Then create a graph with years on the horizontal axis and FV on the vertical axis to dnplay your results. The value of PV depend upon your choice hop C4C Excel 710 BOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW M Calibri General WE Autom F- BIU. == TWIN TH A. Merge Center Anment Repy mat Pavel Clip card 36 Insert Delete Format Sort finde 9. Conditional Format Cell Formatting Table Styles Styles Tont Num CH Tating Form B X G C M H N E Your division is considering two investment projects, each of which requires an up front expenditure of 45 million. You estimate that the investments will produce the following net cash flows Project A Project Project Project 145.000.000 145,000,000) 145,000,000 145,000.000 1 15,000,000 30,000,000 14,000,000 12.000.000 2 10.000.000 10.000.000 10,000,000 20,000,000 3 5.000.000 2,000,000 13,000,000 20,000,000 4 21,000,000 3.000.000 6,000,000 7.000.000 Now create a table that shows the FV0l 35for till 25 years. Then create a graph with years on the horizontal axis and FV on the vertical axis to dnplay your results. The value of PV depend upon your choice hop