I was given the information below and am not understanding the calculations or what I'm doing wrong for the table at the bottom, can someone please break it down to me?

Input Tables Table 1: Quotes for the Outsourced Scenario Warehouse Supply and installation quoted North $6,000,000 South $5,000,000 North + South combined $10,000,000 Table 2: Installation Costs for the Insourced Scenario Warehouse Installation cost estimate North $225,000 South $175,000 North + South combined $400,000 Table 3: Electricity Purchase Costs/Credits and Total Electricity Usage Yr 1 Public Project electricity grid: Y'r 1 total electricity Purchase usage KWh North $0.34 12,000,000 South $0.32 10,000,000 Table 4: Solar System Sizes and Capacities Sun exposure: Solar system size: Project Panels (each 1 Total solar system | Average daily KWh capacity KW' produced per KW sqm) of capacity North 6,000 1,020 8.9 South 4,000 680 6.6Assumptions and Parameters Parameters Value Electiricty Inflation Rate 7% General Inflation Rate 3% Tax Rate 30% Discount Rate (Hurtle Rate) 8% Useful Life of Solar Panels 10 years Financial Reporting Depreciation 10 years straight-line Tax Reporting Depreciation 5 years straight-line Annual Maintenance Cost per Panel $1.00 (inflated annually by 3%) Workings Metric North Warehouse South Warehouse Daily kWh Production 9.078 4.488 Annual kWh Production 3,313,470 1,638.120 Year 1 Electricity Cost Savings $1.126.579.80 $524.198.40Outsourced $0005 YO Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 Yr7 Yr8 Yr9 Yr10 North Warehouse Capital Expenditures $6.000.000.00 EBITDA EBIT Relevant Cash Flows NPV IRA South Warehouse Capital Expenditures $5,000,000. 00 EBITDA $524.198.40 EBIT Relevant Cash Flows NPV IRR North & South Combined Capital Expenditures $10,000,000. 00 EBITDA $1,650.778.20 $524.198.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 EBIT Relevant Cash Flows NPV IRR Use this worksheet to prepare tables that calculate EBIT, EBITDA, Relevant Cash flows, NPV & IRR - for each of the three alternatives