2. Analyze the income statement line items by calculating the Avg, percentage change and CAGR for...

  

Transcribed Image Text:

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 ww 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? A 1 Income Statement Analysis 2 Revenue 3 Rental Revenue 4 Delivery Revenue 5 6 Cost of Revenue 7 Salaries 8 Other Cost of Revenue 9 10 Operating Expenses 11 General and Administrative Salaries 12 Other General Administrative Expenses 13 Bad Debt Expense 14 Total 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 Percentage Paid Out 31 32 Margin Analysis 33 COGS Margin 34 Gross Profit Margin 35 OPEX Margin 36 EBITDA Margin 37 EBIT Margin 38 Net Profit Margin 39 Sales (% Chngl 40 Sales (Dollars! at Total Revenue Total Cast of Revenue F 1995 1996 1,794,807 1,990,853 2,469,474 1,968,862 0 171,184.0 179,173 168,959 180,567 1,917,980 2,159,812 2,650,041 2,140,045.0 575,253 547,611 610,602 556,109.0 302,877 347,094 419,050 320,122.0 878,130 894,705 1,029,652 1,263,815.0 434,434 539,168 840,718 548,955.0 376,541 406,658 477,772 414,926.0 977 22.186 5,188 1,323,678 8,513.0 972,394.0 811,952 968,012 283,898 297,095 296,711 291,421.0 136,228 142,324 171,319 142,421.0 147,670 154,771 125,392 149,000.0 27,820- 33,912 44,545 37,580 -35.964.0 140,347 113,758 110,226 87,812 113,036.0 60,000 46,700 95,000 27,660 -57,340.0 80,347 67,058 15,226 60152 55,696.0 57.2 58.9 13,8 68.5 49.6 42.8 41.3 86.2 31.5 50.4 1994 1995 1996 1997 AVG 39.5% 44.5% 41.4% 38.9% 411% 60.5% 55.5% 58.6% 61.1% 58.9% 44.2% 41.1% 44.8% 49.9% 45.0% 16.2% 14.4% 13.8% 11.2% 13.9% 95% 7.5% 7.2% 4.7% 7.2% 7.9% 5.8% 5.1% 3.3% 5.5% 10.8% 10.9% 24,0% 15.2% $1,620,313.00 51,794,807,0 $1.990,853.00 52.469 474.00 $1,968,862.00 B 1994 1,620,313 156,035 1,776,348 490,968 211,468 702,436 381,501 398,731 5,702 785,934 287,978 119,811 168,167 C D E 1997 AVG G 26 thng % Ching 52.4 15.7 49.2 24.4 98.2 50.9 120.4 19.8 9 68.4 3 43 -25.4 35.1 -37.4 -53.9 -25.1 19.7 -26.3 -1.7% 1.1% 12.9% -30.9% -50.0% -58.1% 52.4% H CAGR CAGR 15.1 5.0 14.3 7.5 25.6 14.7 30.1 6.2 -3.1 19.0 1.0 12.7 9.3 10.5 -14.5 -22.7 9.2 6.2 69 ~~ -9.7 -0.6% 0.4% 4.1% -11.6% -20.6% -25.1% 30.7% 15.1% 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 ww 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? A 1 Income Statement Analysis 2 Revenue 3 Rental Revenue 4 Delivery Revenue 5 6 Cost of Revenue 7 Salaries 8 Other Cost of Revenue 9 10 Operating Expenses 11 General and Administrative Salaries 12 Other General Administrative Expenses 13 Bad Debt Expense 14 Total 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 Percentage Paid Out 31 32 Margin Analysis 33 COGS Margin 34 Gross Profit Margin 35 OPEX Margin 36 EBITDA Margin 37 EBIT Margin 38 Net Profit Margin 39 Sales (% Chngl 40 Sales (Dollars! at Total Revenue Total Cast of Revenue F 1995 1996 1,794,807 1,990,853 2,469,474 1,968,862 0 171,184.0 179,173 168,959 180,567 1,917,980 2,159,812 2,650,041 2,140,045.0 575,253 547,611 610,602 556,109.0 302,877 347,094 419,050 320,122.0 878,130 894,705 1,029,652 1,263,815.0 434,434 539,168 840,718 548,955.0 376,541 406,658 477,772 414,926.0 977 22.186 5,188 1,323,678 8,513.0 972,394.0 811,952 968,012 283,898 297,095 296,711 291,421.0 136,228 142,324 171,319 142,421.0 147,670 154,771 125,392 149,000.0 27,820- 33,912 44,545 37,580 -35.964.0 140,347 113,758 110,226 87,812 113,036.0 60,000 46,700 95,000 27,660 -57,340.0 80,347 67,058 15,226 60152 55,696.0 57.2 58.9 13,8 68.5 49.6 42.8 41.3 86.2 31.5 50.4 1994 1995 1996 1997 AVG 39.5% 44.5% 41.4% 38.9% 411% 60.5% 55.5% 58.6% 61.1% 58.9% 44.2% 41.1% 44.8% 49.9% 45.0% 16.2% 14.4% 13.8% 11.2% 13.9% 95% 7.5% 7.2% 4.7% 7.2% 7.9% 5.8% 5.1% 3.3% 5.5% 10.8% 10.9% 24,0% 15.2% $1,620,313.00 51,794,807,0 $1.990,853.00 52.469 474.00 $1,968,862.00 B 1994 1,620,313 156,035 1,776,348 490,968 211,468 702,436 381,501 398,731 5,702 785,934 287,978 119,811 168,167 C D E 1997 AVG G 26 thng % Ching 52.4 15.7 49.2 24.4 98.2 50.9 120.4 19.8 9 68.4 3 43 -25.4 35.1 -37.4 -53.9 -25.1 19.7 -26.3 -1.7% 1.1% 12.9% -30.9% -50.0% -58.1% 52.4% H CAGR CAGR 15.1 5.0 14.3 7.5 25.6 14.7 30.1 6.2 -3.1 19.0 1.0 12.7 9.3 10.5 -14.5 -22.7 9.2 6.2 69 ~~ -9.7 -0.6% 0.4% 4.1% -11.6% -20.6% -25.1% 30.7% 15.1%

Answer rating: 100% (QA)

1 1995 1996 1997 1998 RENTAL INCOME 1620313 1794807 1990... View the full answer