COGS is the only expense on the pro forma that is listed as a negative number. Using the paste special: multiply function to convert the expense numbers to a positive number.

-> This will require you to fix the Gross Profit calculation (subtract rather than add)

Spirit Airlines Pro Forma In USD Millions) Historical Forecast 4 Fiscal Period (Annual or Quarter #NAME? Period End Date 12 12 12 12 12 12 12 3 months 3 months 3 months 3 months 12 months months. months months. months months months months months months. Mar-31. Jun-30- Sep-30- Dec-31 Date Dec 31-2010 Dec 31 Dee-31 Dec 31 Dec 31- Dec-31 Dec 31- Dec 31- Dec 31- Dec-31 2014 2014 2014 2014 2014 2015 2016 2011 2012 2013 2017 2018 2019 Currency USD USD USD USD USD USD USD USD USD USD USD USD USD USD 1071.2 1318.4 1654.4 438.0 499.3 519.8 566.6 2023.7 2529.6 3035.5 3490.9 3944.7 4339.1 10 HVALUE! 0.2 0.3 -0.7 0.1 0.0 0.1 2.6 0.3 0.2 0.2 0.1 11 -508.8 -902.4 -1068.0 -295.1 -306.3 -328.4 -362.6 T-1292.4 -1391.3 -1366.0 -1396.3 -2366.8 -2603.5 -349.6 12 Cost of Goods Sold 13 COGS Margin Spirit Airlines Pro Forma In USD Millions) Historical Forecast 4 Fiscal Period (Annual or Quarter #NAME? Period End Date 12 12 12 12 12 12 12 3 months 3 months 3 months 3 months 12 months months. months months. months months months months months months. Mar-31. Jun-30- Sep-30- Dec-31 Date Dec 31-2010 Dec 31 Dee-31 Dec 31 Dec 31- Dec-31 Dec 31- Dec 31- Dec 31- Dec-31 2014 2014 2014 2014 2014 2015 2016 2011 2012 2013 2017 2018 2019 Currency USD USD USD USD USD USD USD USD USD USD USD USD USD USD 1071.2 1318.4 1654.4 438.0 499.3 519.8 566.6 2023.7 2529.6 3035.5 3490.9 3944.7 4339.1 10 HVALUE! 0.2 0.3 -0.7 0.1 0.0 0.1 2.6 0.3 0.2 0.2 0.1 11 -508.8 -902.4 -1068.0 -295.1 -306.3 -328.4 -362.6 T-1292.4 -1391.3 -1366.0 -1396.3 -2366.8 -2603.5 -349.6 12 Cost of Goods Sold 13 COGS Margin