please show your work and which excel row you used for the formula( ex: d13*b3)

A B D E F G H 1 J L M N o Q R Year 2 Year 3 Year 4 Year 5 Formula (Enter the appropriate cells for the variables given below): Operating income = Revenue - Sum of all costs 1 Year o 2 Equipment cost $ 3 Net revenues 4 Less:Labor/maintenance costs 5 Utilities costs 6 Supplies 7 Operating income 8 Equipment salvage value 9 Net cash flow Year 1 (1,000,000) $ $ $ 700,000 $ 735,000 $ 150,000 $ 157,500 $ 15,000 $ 15,750 $ 70,000 $ 73,500 $ 771,750 $ 810,338 $ 850,854 165,375 $ 173,644 $ 182,326 16,538 $ 17,364 $ 18,233 77,175 $ 81,034 $ 85,085 Net Cash Flow Year 0 = Equipment cost Year 1 to Year 4 = Operating income Year 5 = Operating income + Salvage value $ 200,000 10 NPV =NPV(Cost of Capital, Cash Flow Year 1:Cash Flow Year 5)+Cash Flow Year 0 11 Note: All costs and revenues are expected to increase at a 5% inflation rate after Year 1 12 =IRR(Cash Flow Year 0: Cash Flow Year 5) 13 14 Cost of capital 8% 15 16 NPV Is the project profitable? Why? 17 IRR 18 19 20 21 22 23 n