E2-46. Constructing Balance Sheets and Intrepreting Liquidity Measures
The following balance sheet data are reported for Bettis Contractors at June 30, 2015.
Accounts payable. . . . . . . . . . . . . . . . . $ 8,900 Common stock. . . . . . . . . . . . . . . . . . . $100,000
Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . 14,700 Retained earnings . . . . . . . . . . . . . . . . ?
Supplies . . . . . . . . . . . . . . . . . . . . . . . . 30,500 Notes payable . . . . . . . . . . . . . . . . . . . 30,000
Equipment . . . . . . . . . . . . . . . . . . . . . . 98,000 Accounts receivable. . . . . . . . . . . . . . . 9,200
Land . . . . . . . . . . . . . . . . . . . . . . . . . . . 25,000
Assume that during the next two days only the following three transactions occurred:
July 1 Paid $5,000 cash toward the notes payable owed.
2 Purchased equipment for $10,000, paying $2,000 cash and an $8,000 note payable for the remaining balance.
2 Declared and paid a $5,500 cash dividend.
a. Prepare a balance sheet at June 30, 2015.
b. Prepare a balance sheet at July 2, 2015.
c. Calculate its current and quick ratios at June 30, 2015. (Notes Payable is a noncurrent liability.)
d. Assume the industry average is 3.0 for the current ratio and 2.0 for the quick ratio. Comment on Bettis’s current and quick ratios relative to the industry.
Solution:
PART:A)
BALANCE SHEET |
Jun-30 |
Assets |
|
Cash |
14,700 |
Accounts receivable |
9,200 |
Supplies |
30,500 |
Current assets |
54,400 |
Land |
25,000 |
Equioment |
98,000 |
Total assets |
177,400 |
Liabilities |
|
Accounts payable |
8,900 |
Current liabilities |
8,900 |
Notes payable |
30,000 |
Total liabilities |
38,900 |
Stockholders’ equity |
|
Common stock |
100,000 |
Retained earnings |
38,500 |
Total stockholders' equity |
138,500 |
Total liabilities and stockholders’ equity |
177,400 |
PART-B)
BALANCE SHEET |
Jul-02 |
Assets |
|
Cash |
2,200 |
Accounts receivable |
9,200 |
Supplies |
30,500 |
Current assets |
41,900 |
Land |
25,000 |
Equioment |
108,000 |
Total assets |
174,900 |
Liabilities |
|
Accounts payable |
8,900 |
Current liabilities |
8,900 |
Notes payable |
33,000 |
Total liabilities |
41,900 |
Stockholders’ equity |
|
Common stock |
100,000 |
Retained earnings |
33,000 |
Total stockholders' equity |
133,000 |
Total liabilities and stockholders’ equity |
174,900 |
PART-C)
Current Ratio = $54,400/$8,900 = 6.1
Quick Ratio = ($14,700 + $9,200) / $8,900 = 2.69
PART-D)
The current ratio of Betti displays a strong liquidity position. The firm may take into considertion on investing some of its cash in assets that contribute to the earning power of the firm. The quick ratio is reasonable as the firm does not want to tie up too much of its assets in a nonearning asset (cash). A quick glance at the data shows that liquidity position of the firm has weakened since June
E2-46. Constructing Balance Sheets and Intrepreting Liquidity Measures The following balance sheet data are reported for...
I don't know how to do this question. It is E2-36 A-D
E2-36. Preparing Balance Sheets, Computing Income, and Applying the Current and Quick Ratios LO1, 5, 7 Balance sheet information for Lang Services at the end of 2014 and 2015 is December 31, 2015 December 31, 2014 Accounts receivable. . . $22,800 1,800 10,000 32,000 4,700 25,000 $17,500 1,600 8,000 27,000 4,200 25,000 Supplies . .. a. Prepare its balancesheet for December 31 of each year. b. Lang Services...
What is the correct answer for part C?
Required a. Prepare Brownlee Catering's balance sheet at September 30, 2015. b. Prepare the company's balance sheet at the close of business on October 1, 2015. BROWNLEE CATERING SERVICE BALANCE SHEETS September 30, October 1, 2015 2015 Assets Cash 5,000 $ (1,000) Accounts Receivable 8,500 8,500 Supplies Inventory 4,500 4,500 Equipment 17,000 28,000 Total Assets $ 35,000 $ 40,000 Liabilities Accounts Payable $ 11,000 $ 11,000 Notes Payable 7,000 15,000 Total Liabilities...
Balance Sheets for a Corporation The following balance sheet data are given for Cornell Catering Service, a corporation, as of May 31: Accounts Receivable $28,300 Accounts Payable $5,200 Notes Payable 20,000 Cash 12,200 Equipment 55,000 Common Stock 62,500 Supplies 16,400 Retained Earnings ? Assume that on June 1, the following transactions occurred: June 1: Purchased additional equipment costing $25,000, giving $5,000 cash and a $20,000 note payable. June 1: Paid a cash dividend of $7,000 Required a. Prepare a balance...
Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target's common-size balance sheets as of January 31, 2015 and February 1, 2014 (Round your answers to one decimal place.) January 31, February 1, (5 millions) 2015 2014 Assets Cash and cash equivalents 52.210 5670 Inventory 8.790 Other current assets 2.625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders' investment Accounts payable 57,759...
SNot yet answered Marked out of 19.00gqestion Balance Sheet The following balance sheet data are for Betis Plumbing Contractors, Inc. a corporation, a May 31, 2016 Finish attempt Accounts Payable 59.900 Common Stock $101,000 Cash Equipment, net 100.000 Notes Payable Supplies 15,700 Retained Earnings 31,000 28,500 Accounts Receivable 9,200 5,000 Required Prepare a balance sheer for Betis as of May 31, 2016 BETTIS PLUMBING Balance Sheet Total Assets MacBook Air F3 FS F6 F7
The following is a balance sheet for Mundy Corporation at June 30, 2019. Mundy Corporation Balance Sheet June 30, 2019 ASSETS LIABILITIES Current Assets Current Liabilities Cash 20,300 Accounts Payable 25,600 Accounts Receivable - Net 8,160 Wages Payable 34,300 Inventory 16,450 Interest Payable 1,350 Supplies 6,650 Unearned Revenue 5,700 Prepaid Insurance 10,000 Total Current Liabilities 66,950 Total Current Assets 61,560 Long-Term Liabilities Property, Plant & Equipment Notes Payable 24,700 Land 5,590 Total Liabilities 91,650 Buildings 21,000 STOCKHOLDERS' EQUITY Equipment 44,500...
Sandhill Supply Company Balance Sheet as of June 30, 2017($ thousands) Assets: Liabilities and Equity: Cash and marketable $396,000 Accounts payable $820,000 109,000 41,300 $970,300 1,177,000 $2,147,300 1,318,000 819,100 $2,137,100 $4,284,400 securities Accounts receivable Inventory Other current assets 711,200 Notes payable 1,156,000Accrued income taxes 42,200 Total current liabilities Total current assets $2,305,400 Long-term debt Net plant and equipment Total liabilities Common stock Retained earnings 1,979,000 Total common equity Total assets $4,284,400 Total liabilities and equity Using the 2017 data for...
The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $480,300 $386,400 Marketable securities 556,200 434,700 Accounts and notes receivable (net) 227,500 144,900 Inventories 730,000 420,900 Prepaid expenses 376,000 269,100 Total current assets $2,370,000 $1,656,000 Current liabilities: Accounts and notes payable (short-term) $458,200 $483,000 Accrued liabilities 331,800 207,000 Total current liabilities $790,000 $690,000 a. Determine for each year (1) the working capital, (2)...
The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $563,200 $435,200 Marketable securities 489,600 652,100 266,700 Accounts and notes receivable (net) 163,200 Inventories 463,300 290,400 185,600 Prepaid expenses 238,700 Total current assets $2,184,000 $1,564,000 Current liabilities: Accounts and notes payable (short-term) $452,400 327,600 $476,000 204,000 Accrued liabilities Total current liabilities $780,000 $680,000 a. Determine for each year (1) the working capital, (2)...
The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $396,700 $320,000 Marketable securities 459,400 360,000 Accounts and notes receivable (net) 187,900 120,000 Inventories 382,800 244,000 Prepaid expenses 197,200 156,000 Total current assets $1,624,000 $1,200,000 Current liabilities: Accounts and notes payable (short-term) $336,400 $350,000 Accrued liabilities 243,600 150,000 Total current liabilities $580,000 $500,000 a. Determine for each year (1) the working capital, (2)...