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? 1994 1995 1996 1997 1,620,313 156,035 1,776,348 1,794,807 179,173 1,937,980 1,990,853 168,959 2,159,812 2,469,474 180,567 2,650,041 Revenue Rental Revenue Delivery Revenue Total Revenue Cost of Revenue Salaries Other Cost of Revenue Total Cost of Revenue Operating Expenses General and Administrative Salaries Other General Administrative Expenses Bad Debt Expense Total Operating Expenses 490,968 211,468 702,436 575,253 302,877 878,130 547,611 347,094 894,705 610,602 419,050 1,029,652 381,501 398,731 5,702 785,934 434,434 376,541 977 811,952 539,168 406,658 22,186 968,012 840,718 477,772 5,1881 1,323,678 EBITDA 287.978 283,898 297,095 296,711 Depreiation 119,811 136,228 142,324 171,319 EBIT 168,167 147,670 154,771 125,392 Interest 27,820 33,912 44,545 37,580 PBT 140,347 113,758 110,226 87,812 Distribution to Shareholders Retained Earnings 60,000 80,347 46,700 67,058 95,000 15,226 27,660 60.152 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? 1994 1995 1996 1997 1,620,313 156,035 1,776,348 1,794,807 179,173 1,937,980 1,990,853 168,959 2,159,812 2,469,474 180,567 2,650,041 Revenue Rental Revenue Delivery Revenue Total Revenue Cost of Revenue Salaries Other Cost of Revenue Total Cost of Revenue Operating Expenses General and Administrative Salaries Other General Administrative Expenses Bad Debt Expense Total Operating Expenses 490,968 211,468 702,436 575,253 302,877 878,130 547,611 347,094 894,705 610,602 419,050 1,029,652 381,501 398,731 5,702 785,934 434,434 376,541 977 811,952 539,168 406,658 22,186 968,012 840,718 477,772 5,1881 1,323,678 EBITDA 287.978 283,898 297,095 296,711 Depreiation 119,811 136,228 142,324 171,319 EBIT 168,167 147,670 154,771 125,392 Interest 27,820 33,912 44,545 37,580 PBT 140,347 113,758 110,226 87,812 Distribution to Shareholders Retained Earnings 60,000 80,347 46,700 67,058 95,000 15,226 27,660 60.152