Please include formulas. Thank you!!!
A C D E F G H K L M O P Q R S Z AA AB Name Box Breed Airport Services 2021 Budgets UI AW Actuals Budgets February March % April % May % June % July % August % Sept. % Oct. % Nov. % Dec. % Total % 6 Net Sales 58,221 100% - Cost of Goods Sold 43% 25,162 43% = Gross Profit 57% 33,059 57% 10 - S,G & A Expenses 33% 18,632 32% 11 = EBITDA 24% 14,427 25% 12 13 - Interest 4% 2,000 3% 14 - Depreciation/Amort. 2% 1,344 2% 15 = EBT 18% 11,083 19% 16 17 - Taxes 4% 2,327 4% 18 = Net Income 14% 8,756 15% 19A B C D E F G H I K L M N Breed Airport Services N - 2019 Actuals UAW January February March April May June July August September October November December Total Net Sales 68,922 58,221 61,715 66,035 70,657 76,310 81,651 86,550 90,878 87,243 83,753 74,540 906,474 6 - Cost of Goods Sold 30,326 25,162 26,913 28,797 30,813 33, 278 35,607 37,744 39,631 38,003 36,519 32,501 395,292 = Gross Profit 38,596 33,059 34,802 37,238 39,844 43,032 46,044 48,807 51,247 49,240 47,234 42,039 511,182 - S,G & A Expenses 20,677 18,632 19,132 20,472 21,905 23,657 25,313 26,832 28,173 27,156 25,978 23,122 281,048 10 = EBITDA 17,920 14,427 15,669 16,766 17,940 19,375 20,731 21,975 23,074 22,084 21,257 18,918 230,134 12 - Interest 2,500 2,000 2,179 2,179 2,179 2,179 2,179 2,179 2, 179 2,179 2, 179 2,179 26,293 13 - Depreciation/Amort. 1,455 1,455 1,455 1,455 1,455 1,455 1,455 1,455 1,455 1,455 1,455 1,455 17,460 14 = EBT 13,965 11,083 12,035 13,132 14,305 15,741 17,097 18,341 19,439 18,450 17,622 15.283 186,492 15 16 - Taxes 2,933 2,327 2,527 2,758 3,004 3,306 3,590 3,852 4,082 3,874 3,701 3,209 39,163 17 = Net Income 11,032 8,756 9,508 10,374 11,301 12,435 13,506 14,489 15,357 14,575 13,922 12,074 147,329 18 19 Sales growth rate 4.0% 6.0% 7.0% 7.0% 8.0% 7.0% 6.0% 5.0% -4.0% -4.0% -11.0% 20 21 Net Sales 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 22 - Cost of Goods Sold 14% 43% 44% 44% 44% 44% 44% 44% 44% 44% 44% 44% 44% 23 = Gross Profit 56% 57% 56% 56% 56% 56% 56% 56% 56% 56% 56% 56% 56% 24 25 - S,G & A Expenses 30% 32% 31% 31% 31% 31% 31% 31% 31% 31% 31% 31% 31% 26 = EBITDA 26% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 28 - Interest 4% 3% 4% 3% 3% 3% 3% 3% 2% 2% 3% 3% 3% 29 - Depreciation/Amort. 2% 2% 2% 2% 2% 2% 2% 2% 2% 2% 2% 2% 2% 30 = EBT 20% 19% 20% 20% 20% 21% 21% 21% 21% 21% 21% 21% 21% 31 32 - Taxes 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 33 = Net Income 16% 15% 15% 16% 16% 16% 17% 17% 17% 17% 17% 16% 16%
