1. Analyze the balance sheet line items by calculating AVG, Percentage Change and CAGR. What do...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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? C. Summary: Based on the analysis above, what is the financial and operational condition of the firm? Table 1. Balance Sheet Note: This is an example. Your tables may be different Assets: Balance Sheet Account Analysis Accounts Receivable (a) Due from Officers & Employees Other Current Assets Total Current Assets Rental Equipment Net Property and Equipment Total Assets Liabilities: Borrowings under Bank Line of Credit Current Installments of Term Note Accounts Payable and Accounts Total Liabilities Retained Earnings Total Shareholders' Equity Total Loans to Shareholder/Total Assets AVG % Chng N> CAGR Exhibit 4 Be Our Guest, Inc. Balance Sheets ASSETS Current Assets: Cash (Overdraft) Accounts Receivable (a) Due from Officers & Employees Loan Receivable from Shareholder (b) Other Current Assets Total Current Assets Property and Equipment: Rental Equipment Leasehold Improvements & Other Equipment Less Accumulated Depreciation Net Property and Equipment Other Assets: Loan Receivable from Shareholder (b) Due from Affiliate (c) Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: Borrowings under Bank Line of Credit Current Installments of Term Note (d) Due to Officer Accounts Payable and Accounts Total Current Liabilities Term Notes Payable, Less Current Install (d) Total Liabilities Shareholders' Equity: Common Stock, $1 Par Value 1994 $ (2,595) $ 228,333 5,000 7,500 682 238,920 768,481 102,272 870,753 414,988 455,765 30,000 110,000 140,000 $834,685 S 75,000 $ 32,539 17,000 63,465 188,004 226,814 414,818 2,000 74,000 343,867 419,867 $ 834,685 $ December 31, 1995 565 $ 303,430 13,617 7,500 13,332 338,444 928,391 133,850 1,062,241 551,214 511,027 20,000 110,000 130,000 979,471 $ 53,388 32,816 69,233 155,437 337,109 492,546 2,000 74,000 410,925 1996 486,925 979,471 $ 645 $ 303,476 22,552 7,500 700 334,873 1,077,484 208,827 1,286,311 679,734 606,577 98,270 $ 70,651 32,816 88,296 290,033 317,266 607,299 1997 Additional Paid-In Capital Retained Earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity (a) Accounts Receivable are shown net of allowance for doubtful accounts of $5,000. (b) A loan was made to a shareholder to purchase shares. $17,500 was outstanding as of 12/31/97. (c) At Dec. 31, 1996, the outstanding balance of the bank term loan was $383,484 of which $69,893 was due in one year. (3,498) 10,000 10,000 158,000 65,950 168,000 75,950 1,109,450 $ 1,124,037 346,109 16,763 7,500 2,678 369,552 1,251,080 278,508 1,529,588 851,053 678,535 140,000 75,268 103,155 318,423 243,311 561,734 2,000 2,000 74,000 74,000 426,151 486,303 502,151 562,303 1,109,450 $ 1,124.037 Exhibit 7 Be Our Guest, Inc. 1997 Quarterly Balance Sheets March 31 ASSETS Current Assets: Cash (Overdraft) Accounts Receivable Due from Officers & Employees Loan Receivable from Shareholder Other Current Assets Total Current Assets Net Property and Equipment Other Assets: Loan Receivable from Shareholder Due from Affiliate Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: Borrowings under Bank Line of Credit Current Installments of Term Note Accounts Payable and Accruals Total Current Liabilities Term Notes Payable, Less Current Install. Other Term Notes Total Liabilities Shareholders' Equity: Common Stock, $1 Par Value Additional Paid-In Capital Retained Earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity Average Debt $ 5,338 S 12,882 $ 401,432 43,186 144,926 31,028 7,500 700 189,492 626,847 10,000 61,527 71,527 June 30 71,201 74,649 214,120 296,281 4,432 514,833 7,500 1,630 2,000 74,000 297,034 466,630 685,616 S 68,270 S 97,270 $ 71,826 10,000 61,527 71,527 145,097 314,194 278,567 4,432 597,193 Sept. 30 2,000 74,000 550,581 626,581 39,239 S 318,698 40,072 10,000 65,950 75,950 S887,867 $1,223,774 $1,231,168 $ 1,124,037 7,500 2,828 408,337 751,304 10,000 61,527 71,527 Dec. 31 (3,498) 346,109 16,763 7,500 2,678 2,000 74,000 562,801 638,801 369,552 678,535 87,270 $ 140,000 72,455 75,268 167,769 103,155 327,494 318,423 260,440 243,311 4,432 592,367 561,734 2,000 74,000 486,303 373,034 562,303 S 887,867 $1,223,774 $1,231,168 $ 1,124,037 (298,220) (319,409) (289,035) (306,954) 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? C. Summary: Based on the analysis above, what is the financial and operational condition of the firm? Table 1. Balance Sheet Note: This is an example. Your tables may be different Assets: Balance Sheet Account Analysis Accounts Receivable (a) Due from Officers & Employees Other Current Assets Total Current Assets Rental Equipment Net Property and Equipment Total Assets Liabilities: Borrowings under Bank Line of Credit Current Installments of Term Note Accounts Payable and Accounts Total Liabilities Retained Earnings Total Shareholders' Equity Total Loans to Shareholder/Total Assets AVG % Chng N> CAGR Exhibit 4 Be Our Guest, Inc. Balance Sheets ASSETS Current Assets: Cash (Overdraft) Accounts Receivable (a) Due from Officers & Employees Loan Receivable from Shareholder (b) Other Current Assets Total Current Assets Property and Equipment: Rental Equipment Leasehold Improvements & Other Equipment Less Accumulated Depreciation Net Property and Equipment Other Assets: Loan Receivable from Shareholder (b) Due from Affiliate (c) Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: Borrowings under Bank Line of Credit Current Installments of Term Note (d) Due to Officer Accounts Payable and Accounts Total Current Liabilities Term Notes Payable, Less Current Install (d) Total Liabilities Shareholders' Equity: Common Stock, $1 Par Value 1994 $ (2,595) $ 228,333 5,000 7,500 682 238,920 768,481 102,272 870,753 414,988 455,765 30,000 110,000 140,000 $834,685 S 75,000 $ 32,539 17,000 63,465 188,004 226,814 414,818 2,000 74,000 343,867 419,867 $ 834,685 $ December 31, 1995 565 $ 303,430 13,617 7,500 13,332 338,444 928,391 133,850 1,062,241 551,214 511,027 20,000 110,000 130,000 979,471 $ 53,388 32,816 69,233 155,437 337,109 492,546 2,000 74,000 410,925 1996 486,925 979,471 $ 645 $ 303,476 22,552 7,500 700 334,873 1,077,484 208,827 1,286,311 679,734 606,577 98,270 $ 70,651 32,816 88,296 290,033 317,266 607,299 1997 Additional Paid-In Capital Retained Earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity (a) Accounts Receivable are shown net of allowance for doubtful accounts of $5,000. (b) A loan was made to a shareholder to purchase shares. $17,500 was outstanding as of 12/31/97. (c) At Dec. 31, 1996, the outstanding balance of the bank term loan was $383,484 of which $69,893 was due in one year. (3,498) 10,000 10,000 158,000 65,950 168,000 75,950 1,109,450 $ 1,124,037 346,109 16,763 7,500 2,678 369,552 1,251,080 278,508 1,529,588 851,053 678,535 140,000 75,268 103,155 318,423 243,311 561,734 2,000 2,000 74,000 74,000 426,151 486,303 502,151 562,303 1,109,450 $ 1,124.037 Exhibit 7 Be Our Guest, Inc. 1997 Quarterly Balance Sheets March 31 ASSETS Current Assets: Cash (Overdraft) Accounts Receivable Due from Officers & Employees Loan Receivable from Shareholder Other Current Assets Total Current Assets Net Property and Equipment Other Assets: Loan Receivable from Shareholder Due from Affiliate Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: Borrowings under Bank Line of Credit Current Installments of Term Note Accounts Payable and Accruals Total Current Liabilities Term Notes Payable, Less Current Install. Other Term Notes Total Liabilities Shareholders' Equity: Common Stock, $1 Par Value Additional Paid-In Capital Retained Earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity Average Debt $ 5,338 S 12,882 $ 401,432 43,186 144,926 31,028 7,500 700 189,492 626,847 10,000 61,527 71,527 June 30 71,201 74,649 214,120 296,281 4,432 514,833 7,500 1,630 2,000 74,000 297,034 466,630 685,616 S 68,270 S 97,270 $ 71,826 10,000 61,527 71,527 145,097 314,194 278,567 4,432 597,193 Sept. 30 2,000 74,000 550,581 626,581 39,239 S 318,698 40,072 10,000 65,950 75,950 S887,867 $1,223,774 $1,231,168 $ 1,124,037 7,500 2,828 408,337 751,304 10,000 61,527 71,527 Dec. 31 (3,498) 346,109 16,763 7,500 2,678 2,000 74,000 562,801 638,801 369,552 678,535 87,270 $ 140,000 72,455 75,268 167,769 103,155 327,494 318,423 260,440 243,311 4,432 592,367 561,734 2,000 74,000 486,303 373,034 562,303 S 887,867 $1,223,774 $1,231,168 $ 1,124,037 (298,220) (319,409) (289,035) (306,954)
Expert Answer:
Answer rating: 100% (QA)
Assets Balance Sheet Account Analysis Accounts Receivables ... View the full answer
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
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....
-
profitability be our guest profitibility ratios 1994 1995 1996 1997 Avg % change CAGR ROE 0.334 0.234 0.220 0.156 0.236 -5396 -22.496 ROA 0.168 0.116 0. Be Our Guest, Inc. Steve Lizio, Al Lovata and...
-
This is an example of a poorly designed dashboard. It displays key performance measures of a fictitious company. Various sales and profit measures are shown.? Comment on what does not work well in...
-
Consider J symmetric firms operating in two periods with constant over time cost functions C j (x j , e j ) = (x j b j e j ) 2 /2b j , +c j x 2 j /2 The output prices are exogenous and given by p 1...
-
Is Alonso right? If so, what is this idea and what is it supposed to do for people? If Alonso is wrong and there is nothing like this, is there something else you can suggest they use?
-
Show that the wave function (x,t) = Ae kx - t does not satisfy the time-dependent Schrdinger equation.
-
\(P(z>-0.74)\). In Exercises 2126, find the indicated probability using the standard normal distribution. If convenient, use technology to find the probability.
-
Sevilla Consulting offers environmental consulting services worldwide. The managers of branch offices are rewarded for superior performance with bonuses based on the economic value that the office...
-
Exercise Bonds Payable & Notes Payable Exercise 1 Eve Corporation issues a $9,000,000, 5%, 20-year mortgage note payable on December 31, 2017, to obtain needed financing for the construction of a ...
-
Coca Cola (KO) price is $61/share. The company is expected to pay dividend of $1.7/share next year. (In reality, dividends are paid quarterly. In this question we will assume for simplicity that all...
-
There are many personal finance articles about the importance for individual consumers to increase saving for their retirement. From a macroeconomic perspective, if all consumers follow this advice...
-
Pets Co is determining whether to use the direct method or the step method in allocating service department costs to production departments. Costs of the human resources department are allocated...
-
Crane Manufacturing s sales decreased significantly in 2 0 2 1 due to increased online purchasing. The company s income statement showed the following results from selling 4 1 0 , 0 0 0 units of...
-
JC Warehouse Corporation has estimated the cash flows of Projects A, B, and C as follows. Year Project Alpha Project Beta Project Delta 0 -$100,000 -$200,000 -$100,000 1 70,000 130,000 75,000 2...
-
Blue Cross and Blue Shield are, a) Health maintenance organizations (HMO) b) Private insurance companies c) Hospital and medical service plans d) Types of Medicare e) Preferred provider organizations...
-
A manufacturer reports the information below for three recent years. Variable costing income Beginning finished goods inventory (units) Ending finished goods inventory (units) Year 1 $ 113,000 0...
-
Once a polluting firm attains a regulatory standard, there is...Select one or more: a. underproduction and too low a price tobuyers b. profit to be made by enhancing environmental quality evenfurther...
-
A horizontal annulus with inside and outside diameters of 8 and 10 cm, respectively, contains liquid water. The inside and outside surfaces are maintained at 40 and 20oC, respectively. Calculate the...
-
Recall the travails of Agatha, from the previous chapter. She had to travel 1,500 miles from Istanbul to Paris. She had only $200 with which to buy first-class and second-class tickets on the Orient...
-
Tip and Spot finally got into college. Tip can write term papers at the rate of 10 pages per hour and solve workbook problems at the rate of 3 per hour. Spot can write term papers at the rate of 6...
-
Each year, 1,000 citizens of New Crankshaft, Pennsylvania, sell their used cars and buy new cars. The original owners of the old cars have no place to keep second cars and must sell them. These used...
-
Record the following details for the month of November 19X7 and extract a trial balance as at 30 November: 19X7 Nov 1 Started with 5,000 in the bank. 3 Bought goods on credit from: T Henriques 160; J...
-
Record the following for the month of January, balance off all the accounts, and then extract a trial balance as at 31 January 19X8: 19X8 Jan 1 Started business with 3,500 cash. 2 Put 2,800 of the...
-
From the following trial balance of B Webb, extracted after one years trading, prepare a trading and profit and loss account for the year ended 31 December 19X6. A balance sheet is not required....
Study smarter with the SolutionInn App