Question

In: Finance

The balance sheet for Stud Clothiers is shown next. Sales for the year were $3,200,000, with...

The balance sheet for Stud Clothiers is shown next. Sales for the year were $3,200,000, with 75 percent of sales sold on credit.

STUD CLOTHIERS
Balance Sheet 20X1
Assets Liabilities and Equity
Cash $ 25,000 Accounts payable $ 247,000
Accounts receivable 351,000 Accrued taxes 97,000
Inventory 251,000 Bonds payable (long-term) 136,000
Plant and equipment 423,000 Common stock 100,000
Paid-in capital 150,000
Retained earnings 320,000
Total assets $ 1,050,000 Total liabilities and equity $ 1,050,000


Compute the following ratios: (Use a 360-day year. Do not round intermediate calculations. Round your answers to 2 decimal places. Input your debt-to-total assets answer as a percent rounded to 2 decimal places.)

a. Current ratio times
b. Quick ratio times
c. Debt-to-total-assets ratio %
d Asset turnover times
e. Average collection period days

Solutions

Expert Solution

Answer a
Current ratio = Current assets / Current Liabilities
Current assets = Cash + AR + Inventory = $25000 + $351000 + $251000 = $627,000.00
Current liabilities = Accounts Payable + accrued taxes = $247000 + $97000 = $344,000.00
Current ratio = $627000 / $344000 = 1.82
Answer b
Quick ratio = Liquid current assets / Current liabilities
Liquid Current assets = Cash + AR = $25000 + $351000 = $376,000.00
Current liabilities = Accounts Payable + accrued taxes = $247000 + $97000 = $344,000.00
Quick ratio = $376000 / $344000 = 1.09
Answer c
Debt to total asset ratio = Total Liabilities / Total assets
Total assets = $1050000
Total Liabilities = Accounts Payable + accrued taxes + Bonds payable = $247000 + $97000 + $136000 = $480000
Debt to total asset ratio = $480000/$1050000 = 45.71%
Answer d
Asset turnover ratio = Net Sales / Average Total assets
Net Sales = $32,00,000
Let us assume average total assets equivalent to total assets = $10,50,000
Asset turnover ratio = $32,00,000 / $10,50,000 = 3.05 times
Answer e
Average collection period = 360 days / Accounts receivable turnover ratio
Accounts receivable turnover ratio = Credit sales in year / Average Accounts receivables
Let us assume average accounts receivables equivalent to accounts receivables = $3,51,000
Credit sales in year = $3200000 * 75% = $24,00,000
Accounts receivable turnover ratio = $24,00,000 / $3,51,000 = 6.84
Average collection period = 360 days / 6.84 = 52.65 days

Related Solutions

The balance sheet for Stud Clothiers is shown next. Sales for the year were $3,420,000, with...
The balance sheet for Stud Clothiers is shown next. Sales for the year were $3,420,000, with 75 percent of sales sold on credit. STUD CLOTHIERS Balance Sheet 20X1 Assets Liabilities and Equity Cash $ 27,000 Accounts payable $ 293,000 Accounts receivable 291,000 Accrued taxes 125,000 Inventory 308,000 Bonds payable (long-term) 201,000 Plant and equipment 393,000 Common stock 100,000 Paid-in capital 150,000 Retained earnings 150,000 Total assets $ 1,019,000 Total liabilities and equity $ 1,019,000 Compute the following ratios: (Use a...
Berman & Jaccor Corporation's current sales and partial balance sheet are shown below. This year Sales...
Berman & Jaccor Corporation's current sales and partial balance sheet are shown below. This year Sales $ 1,000 Balance Sheet: Assets Cash $ 200 Short-term investments $ 140 Accounts receivable $ 100 Inventories $ 150     Total current assets $ 590 Net fixed assets $ 400     Total assets $ 990 Sales are expected to grow by 12% next year. Assuming no change in operations from this year to next year, what are the projected total operating assets? Do not round intermediate...
The balance sheet for Bryan Corporation is given below. Sales for the year were $3,090,000, with...
The balance sheet for Bryan Corporation is given below. Sales for the year were $3,090,000, with 75 percent of sales sold on credit. BRYAN CORPORATION Balance Sheet Dec. 31, 20XX Assets Liabilities and Equity   Cash $60,000        Accounts payable $245,000      Accounts receivable 290,000        Accrued taxes 55,000      Inventory 375,000        Bonds payable (long term) 200,000      Plant and equipment 435,000        Common stock 330,000        Retained earnings 330,000          Total assets $1,160,000           Total liabilities and equity $1,160,000...
The balance sheet for Bryan Corporation is given below. Sales for the year were $3,190,000, with...
The balance sheet for Bryan Corporation is given below. Sales for the year were $3,190,000, with 75 percent of sales sold on credit. BRYAN CORPORATION Balance Sheet Dec. 31, 20XX Assets Liabilities and Equity   Cash $60,000        Accounts payable $295,000      Accounts receivable 390,000        Accrued taxes 50,000      Inventory 425,000        Bonds payable (long term) 300,000      Plant and equipment 485,000        Common stock 430,000        Retained earnings 285,000          Total assets $1,360,000           Total liabilities and equity $1,360,000...
Berman & Jaccor Corporation's current sales and partial balance sheet are shown below. This year $1,000...
Berman & Jaccor Corporation's current sales and partial balance sheet are shown below. This year Sales$1,000Balance Sheet: Assets Cash$ 150  Short-term investments  $ 145Accounts receivable  $ 300Inventories  $ 300Total current assets $ 895Net fixed assets  $ 600Total assets  $ 1,495 Sales are expected to grow by 12% next year. Assuming no change in operations from this year to next year, what are the projected total operating assets? Do not round intermediate calculations. Round your answer to the nearest dollar.
The firm is generating its proforma balance sheet for 2016. For the year 2015, sales were...
The firm is generating its proforma balance sheet for 2016. For the year 2015, sales were $4 million. Sales are expected to be $5 million in 2016. The company expects its net profit margin for 2016 to equal 5%. In each of the past several years, the company has been paying $50,000 in dividends to its stockholders. The company wants to increase dividends to $80,000 in 2016. The 2015 balance sheet for the company is below. Assume that Cash, Accounts...
the balance sheet for the serden company is shown below for sales of $300000. using the...
the balance sheet for the serden company is shown below for sales of $300000. using the percentage of sales method, assuming no long-term debt is paid off how much outside financing is required?(assume net profit to sales is 6 percent, payout ratio is 60 percent of net income, and sales increase 40 percent during 2019). serden company balance sheet as of Dec. 31, 2018 cash    $15,000 accounts receivable    $60,000 inventory $90,000 current assets $165,000 fixed assets $30,000 total...
The annual sales for​ Salco, Inc. were $4.67 million last year. The​ firm's end-of-year balance sheet...
The annual sales for​ Salco, Inc. were $4.67 million last year. The​ firm's end-of-year balance sheet was as​ follows:  Current assets   $501,000   Liabilities   $1,004,500 Net fixed assets   1,508,000   Owners' equity   1,004,500 Total Assets   $2,009,000   Total   $2,009,000 . ​ Salco's income statement for the year was as​ follows: Sales    $4,670,000 Less: Cost of goods sold    (3,498,000) Gross profit    $1,172,000 Less: Operating expenses    (497,000) Net operating income    $675,000 Less: Interest expense    (98,000) Earnings before taxes   ...
The annual sales for Salco, Inc. were $4.57 million last year. The firm's end-of-year balance sheet...
The annual sales for Salco, Inc. were $4.57 million last year. The firm's end-of-year balance sheet was as follows: Current assets $509,000 Liabilities $997,000 Net fixed assets 1,485,000 ​Owners' equity 997,000 Total Assets $1,994,000 Total $1,994,000 Salco's income statement for the year was as follows: Sales $4,570,000 ​Less: Cost of goods sold (3,492,000) Gross profit $1,078,000 ​Less: Operating expenses \(503,000) Net operating income $575,000 ​Less: Interest expense (97,000) Earnings before taxes $478,000 ​Less: Taxes ​(35%​) (167,300) Net income $310,700 a....
 The annual sales for​ Salco, Inc. were $4.46 million last year. The​ firm's end-of-year balance sheet...
 The annual sales for​ Salco, Inc. were $4.46 million last year. The​ firm's end-of-year balance sheet was as​ follows:   . ​ Salco's income statement for the year was as​ follows:   . a. Calculate​ Salco's total asset​ turnover, operating profit​ margin, and operating return on assets. b.  Salco plans to renovate one of its plants and the renovation will require an added investment in plant and equipment of $1.04 million. The firm will maintain its present debt ratio of 50 percent...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT