For IRR How would I include all cash flows in your excel calculation?

n n $ 7 100% * s .0 00 123- Default (Ca.. . 12 . B I S A . B E v E- 1 - - V co Y - E - fx Points Possible J K L B C D E F G H I Year 0 1 2 3 4 5 11 12 13 14 1 Revenues 1,900,000,000 4,300,000,000.00 5,891,000,000.00 6,185,550,000.00 5257717500 3943288125 15 16 17 2 Costs* 83,524,000,000.00 1,890,280,000.00 2,530,773,600.00 2,657,312,280.00 2,311, 292,613.00 1,733,075,130.00 19 19 2 Depreciation 20 20% 20% 21 Tax Rate 20% 20% 20% 20% 22 23 Capital Expenditures 4494949499 4494999 2234455 3344553 2 7748494 4494949 24 25 26 27 28 21 NWC Che NWC 987993 3397488 338776 339847 338474 338377 29 20 Recover NWC 31 32 FCF (millions) 23 24 Cost of Capital 25 4,647,295,267 3,591,091,797 2,448,471,680 36 NPV = 1,179,750,514 3,909,090,909 4,868,595,041 37 IRR = 38 (For the IRR include all cash flows in your excel calculation.) 39 + WACC Calculation . Bond Information . Financial Statements . New Stores Project