2. Analyze the income statement line items by calculating the Avg, percentage change and CAGR for each line item. What do the trends imply about the operations of the Be Our Guest business? 3. Calculate and analyze the following margins from the income statement using AVG, percentage change and CAGR. Margins to be calculated: Gross Margin, COGS margin, Total Operating Expense Margin, EBITDA Margin, EBIT Margin and Net Profit Margin. What do the margin trends imply regarding the operations of Be Our Guest? 4. Calculate the percentage of earnings retained in the firm and the percentage of earnings paid out? Note: Percentage of Earnings Retained = Earnings Retained/Net Earnings Percentage of Earnings Paid Out - 1-Percentage of Earnings Retained A. What does the trend imply about earnings distributed to the firm's management? B. Did they violate the bank covenants? If so, by what percentage and what are the implications? 0 E F G H B 1995 1994 1990 1997 AVG CAGR x ches 1620,313 156,035 1,776,348 1,794,B07 179,173 1,937,980 1.990,53 168,959 2,159,812 2469 474 180,567 2,650,041) 1,968,8620 171.184.0 2,140,045.0 52.4 15.2 49.2 15.1 5.0 14.3 490,968 211 468 202,436 575,253 302,872 878,130 547,611 347,094 894,705 610,602 419,050 1,029,652 556,109.0 320,122.0 1,263,815.0 24.4 982 50.9 7.5 25.6 14.7 38L501 398,731 434 434 376,541 977 811,952 539 168 406,658 22 186 968,012 840,718 477,772 5188 1,323,670 548,955.0 414,926,0 8,513.0 972,394,0 120.4 19,8 9 68.4 30.1 6.2 -3.1 19.0 5,702 785,934 1 Income Statement Analysis 2 Revenue 3 Rental Revenue 4 Delivery Revenue 5 Total Revenue 6 Cost of Revenue 7 Salaries 8 Other Cost of Revenue 9 Total Cast of Revenue 10 Operating Expenses 11 General and Administrative Salaries 12 Other General Administrative Expenses 13 Bad Debt Expense 14 Totul Operating Expenses 15 16 EBITDA 17 18. Deprelation 19 20 EBIT 21 22 Interest 23 24 PBT 25 26 Distribution to Shareholders 27 Retained Earnings 28 29 Percentge Retained 30 Percentare Paid Out 287,978 283,898 297,095 296,711 291.421.01 3 10 119,811 136,228 142,324 171,319 142,421.01 43 12.7 168, 167 147 670 154,771 125,392 149,000.0 -25.4 -9.3 27,820 33.912 44.545 37,580 -35.964.0 35.1 10.5 140,347 113,758 110,226 87.812 113,0360 -37.4 14.5 60,000 80. 307 46,700 62.05 95,000 225 226 27,660 69252 -57,340.0 55.696.0 -53.9 -25.1 22.7 9.21 522 589 411 13 86.2 68.5 31s 49.6 500 19.7 -26.3 6.2 .9.2 32 Mardin Analysis 33 cods Margin 34 Gross Profit Margin 35 OPEX Margin 36 EBITDA Margin 37 EBIT Margin 38 Net Profit Marin 39 Sales Chart 40 Salos Dollars 1994 1995 1996 1997 AVG % Chns CAGR 39.5X 44.5% 41.4% 38.9% 11.1% -1,7% -0.6% 60.5% 55.5% 58.6% 61 181 58.9% 11% 0.4% 44.2% 41.1% 44.09 49.9% 45.0% 12 9% 4.1% 16.2% 14.45 13.8% 11.2% 13 9% -30.99 11.690 9.5% 2.5W 12% 4,7% 7.2% -S0.09 -20.6% 2.9% 5 BX 51% 33% 5.5% -58.1% -25.1% 10.8% 10.9% 24.0% 15.2% 30.7% 51,620 313.00 51.204,807,03 1.990 B53.00 52.469 474,00 $ 1968.862.00 52.4% 15.16 2. Analyze the income statement line items by calculating the Avg, percentage change and CAGR for each line item. What do the trends imply about the operations of the Be Our Guest business? 3. Calculate and analyze the following margins from the income statement using AVG, percentage change and CAGR. Margins to be calculated: Gross Margin, COGS margin, Total Operating Expense Margin, EBITDA Margin, EBIT Margin and Net Profit Margin. What do the margin trends imply regarding the operations of Be Our Guest? 4. Calculate the percentage of earnings retained in the firm and the percentage of earnings paid out? Note: Percentage of Earnings Retained = Earnings Retained/Net Earnings Percentage of Earnings Paid Out - 1-Percentage of Earnings Retained A. What does the trend imply about earnings distributed to the firm's management? B. Did they violate the bank covenants? If so, by what percentage and what are the implications? 0 E F G H B 1995 1994 1990 1997 AVG CAGR x ches 1620,313 156,035 1,776,348 1,794,B07 179,173 1,937,980 1.990,53 168,959 2,159,812 2469 474 180,567 2,650,041) 1,968,8620 171.184.0 2,140,045.0 52.4 15.2 49.2 15.1 5.0 14.3 490,968 211 468 202,436 575,253 302,872 878,130 547,611 347,094 894,705 610,602 419,050 1,029,652 556,109.0 320,122.0 1,263,815.0 24.4 982 50.9 7.5 25.6 14.7 38L501 398,731 434 434 376,541 977 811,952 539 168 406,658 22 186 968,012 840,718 477,772 5188 1,323,670 548,955.0 414,926,0 8,513.0 972,394,0 120.4 19,8 9 68.4 30.1 6.2 -3.1 19.0 5,702 785,934 1 Income Statement Analysis 2 Revenue 3 Rental Revenue 4 Delivery Revenue 5 Total Revenue 6 Cost of Revenue 7 Salaries 8 Other Cost of Revenue 9 Total Cast of Revenue 10 Operating Expenses 11 General and Administrative Salaries 12 Other General Administrative Expenses 13 Bad Debt Expense 14 Totul Operating Expenses 15 16 EBITDA 17 18. Deprelation 19 20 EBIT 21 22 Interest 23 24 PBT 25 26 Distribution to Shareholders 27 Retained Earnings 28 29 Percentge Retained 30 Percentare Paid Out 287,978 283,898 297,095 296,711 291.421.01 3 10 119,811 136,228 142,324 171,319 142,421.01 43 12.7 168, 167 147 670 154,771 125,392 149,000.0 -25.4 -9.3 27,820 33.912 44.545 37,580 -35.964.0 35.1 10.5 140,347 113,758 110,226 87.812 113,0360 -37.4 14.5 60,000 80. 307 46,700 62.05 95,000 225 226 27,660 69252 -57,340.0 55.696.0 -53.9 -25.1 22.7 9.21 522 589 411 13 86.2 68.5 31s 49.6 500 19.7 -26.3 6.2 .9.2 32 Mardin Analysis 33 cods Margin 34 Gross Profit Margin 35 OPEX Margin 36 EBITDA Margin 37 EBIT Margin 38 Net Profit Marin 39 Sales Chart 40 Salos Dollars 1994 1995 1996 1997 AVG % Chns CAGR 39.5X 44.5% 41.4% 38.9% 11.1% -1,7% -0.6% 60.5% 55.5% 58.6% 61 181 58.9% 11% 0.4% 44.2% 41.1% 44.09 49.9% 45.0% 12 9% 4.1% 16.2% 14.45 13.8% 11.2% 13 9% -30.99 11.690 9.5% 2.5W 12% 4,7% 7.2% -S0.09 -20.6% 2.9% 5 BX 51% 33% 5.5% -58.1% -25.1% 10.8% 10.9% 24.0% 15.2% 30.7% 51,620 313.00 51.204,807,03 1.990 B53.00 52.469 474,00 $ 1968.862.00 52.4% 15.16
