B. Balance Sheet Analysis: 1. Analyze the balance sheet line items by calculating AVG, Percentage Change and CAGR. What do the balance sheet trends imply about the operations of the Be Our Guest business? 2. Calculate the Total Loan to Shareholder/Total Assets ratio from 1994 to 1997. What is the trend in term of the percentage change from 1994 to 1997 and the CAGR from 1994? to 1997? What does this say about the money the shareholders take out of the business relative to the total assets of the business? Is this a value maximizing trend for the business? ste ENG 2 B B A D AVG 1 Balance Sheet Account Analysis Chng CAGR 295,335 51.58% 14.05 2 Accounts Receivable 14,483 3 Due from Officers & Employees 235.26% -25.67 4 Other Current Assets 4,348 292.67% 282.57 5 Total Current Assets 320,447 54.68% 10.36 6 Rental Equipment 1,006,359 62.80% 16.11 7 Net Property and Equipment 562,976 48.88% 11.86 8. Total Assets 1,011,911 34.67% 1.31 9 Liabilities: 10 Borrowings under Bank Line of Credit 78,318 86.67% 42.46 11 Current Installment sof Term Note 57,962 131.32% 6.53 12 Accounts Payable and Accounts 81,037 62.54% 16.83 13 Total Liabilities 519,099 280.52% 65.83 14 Retained Earnings 416,812 41.42% 14.12 15 Total Shareholders Equity 491,812 33.92% 11.98 16 Total Lones to Shareholder / Total Assets 1.99% 17 Page 1 of 4 144% 823 Words English (US) Case#1 Be Our....pdf Case#1 Be Our....pdf Be Our Guest B. Balance Sheet Analysis: 1. Analyze the balance sheet line items by calculating AVG, Percentage Change and CAGR. What do the balance sheet trends imply about the operations of the Be Our Guest business? 2. Calculate the Total Loan to Shareholder/Total Assets ratio from 1994 to 1997. What is the trend in term of the percentage change from 1994 to 1997 and the CAGR from 1994? to 1997? What does this say about the money the shareholders take out of the business relative to the total assets of the business? Is this a value maximizing trend for the business? ste ENG 2 B B A D AVG 1 Balance Sheet Account Analysis Chng CAGR 295,335 51.58% 14.05 2 Accounts Receivable 14,483 3 Due from Officers & Employees 235.26% -25.67 4 Other Current Assets 4,348 292.67% 282.57 5 Total Current Assets 320,447 54.68% 10.36 6 Rental Equipment 1,006,359 62.80% 16.11 7 Net Property and Equipment 562,976 48.88% 11.86 8. Total Assets 1,011,911 34.67% 1.31 9 Liabilities: 10 Borrowings under Bank Line of Credit 78,318 86.67% 42.46 11 Current Installment sof Term Note 57,962 131.32% 6.53 12 Accounts Payable and Accounts 81,037 62.54% 16.83 13 Total Liabilities 519,099 280.52% 65.83 14 Retained Earnings 416,812 41.42% 14.12 15 Total Shareholders Equity 491,812 33.92% 11.98 16 Total Lones to Shareholder / Total Assets 1.99% 17 Page 1 of 4 144% 823 Words English (US) Case#1 Be Our....pdf Case#1 Be Our....pdf Be Our Guest
