Use the following information for the Exercises below. (Algo)Skip to question[The following information applies to the questions displayed below.]Simon Company's year-end balance sheets follow.At December 31 Current Year 1 Year Ago 2 Years AgoAssets Cash $ 32,463 $ 37,563 $ 39,527Accounts receivable, net 96,939 67,077 52,703Merchandise inventory 120,687 89,524 58,987Prepaid expenses 10,877 9,760 4,525Plant assets, net 294,813 275,196 247,558Total assets $ 555,779 $ 479,120 $ 403,300Liabilities and Equity Accounts payable $ 134,237 $ 80,162 $ 52,171Long-term notes payable 102,397 110,198 90,912Common stock, $10 par value 163,500 163,500 163,500Retained earnings 155,645 125,260 96,717Total liabilities and equity $ 555,779 $ 479,120 $ 403,300For both the current year and one year ago, compute the following ratios:Exercise 17-6 (Algo) Common-size percents LO P2Express the balance sheets in common-size percents
Question
Use the following information for the Exercises below. (Algo)Skip to question[The following information applies to the questions displayed below.]Simon Company's year-end balance sheets follow.At December 31 Current Year 1 Year Ago 2 Years AgoAssets Cash 37,563 555,779 403,300Liabilities and Equity Accounts payable 80,162 10 par value 163,500 163,500 163,500Retained earnings 155,645 125,260 96,717Total liabilities and equity 479,120 $ 403,300For both the current year and one year ago, compute the following ratios:Exercise 17-6 (Algo) Common-size percents LO P2Express the balance sheets in common-size percents
Solution
To express the balance sheets in common-size percents, we need to calculate each item as a percentage of total assets for each year. Here's how to do it:
- For each line item on the balance sheet, divide the amount by the total assets for that year, then multiply by 100 to get the percentage.
For example, to calculate the common-size percent for Cash in the current year:
(Cash / Total Assets) * 100 = (555,779) * 100 = 5.84%
Repeat this process for each line item on the balance sheet for each year.
Here's how you would calculate the common-size percent for Accounts Receivable in the current year:
(Accounts Receivable / Total Assets) * 100 = (555,779) * 100 = 17.44%
And so on for each line item.
Remember to do this for each year to compare how the proportions of each line item to total assets have changed over time.
Similar Questions
Following are comparative balance sheets spanning 3 years. Express the balance sheets in common-size percentages for each year.Comparative Balance SheetsFor Years Ended December 31 Current Year 1 Year Ago 2 Years AgoCash $ 640 $ 525 $ 552Accounts receivable, net 960 1,200 1,104Merchandise inventory 2,000 1,650 1,242Plant assets, net 4,400 4,125 4,002Total assets $ 8,000 $ 7,500 $ 6,900Accounts payable $ 1,600 $ 825 $ 966Long-term notes payable 1,760 1,875 1,518Common stock 3,440 3,675 3,450Retained earnings 1,200 1,125 966Total liabilities and equity $ 8,000 $ 7,500 $ 6,900
Exercise 12-16 Closing entries for a corporation LO6Spicer Inc. showed the following alphabetized list of adjusted account balances at December 31, 2023: Accounts Payable $ 25,560 Accounts Receivable 39,000 Accumulated depreciation, Equipment 10,540 Accumulated depreciation, Warehouse 21,080 Cash 8,200 Cash Dividends 19,400 Common Shares 110,000 Equipment 78,200 Income Tax Expense 40,400 Land 115,600 Notes Payable, due in 2026 33,400 Operating Expenses 109,000 Preferred Shares 39,000 Retained Earnings 27,520 Revenue 269,500 Warehouse 126,800 The company uses an income summary account in the closing process. Required:1. Assuming normal balances, prepare the closing entries at December 31, 2023, the company’s year-end.
Good Job Ltd. had the following list of balance sheet items: equity $240,000, non-current assets $500,000, accounts receivable $230,000, bank overdraft $300,000. Accounts payable, the only item missing from the list, must be: Group of answer choices 1.$670,000 2.$190,000 3.$210,000 4.$790,000
At the end of its first year of operations, December 31, 2018, Caoayan, Inc. reported the following information: Accounts receivable, net of allowance for doubtful accountsP9,500,000Customer accounts written off as uncollectible during 2018240,000Bad debts expense for 2018840,000 What should be the balance in accounts receivable at December 31, 2018, before subtracting the allowance for doubtful accounts?Select one:a.P10,340,000b.P10,100,000c.P10,580,000d.P 9,740,000
Required informationSkip to question[The following information applies to the questions displayed below.]Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan CompanyData from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 780,000 $ 907,200Cash $ 19,500 $ 33,000 Cost of goods sold 590,100 630,500Accounts receivable, net 36,400 59,400 Interest expense 8,000 13,000Merchandise inventory 84,240 130,500 Income tax expense 14,992 25,045Prepaid expenses 5,600 7,500 Net income 166,908 238,655Plant assets, net 320,000 305,400 Basic earnings per share 4.17 5.79Total assets $ 465,740 $ 535,800 Cash dividends per share 3.74 4.03Liabilities and Equity Beginning-of-year balance sheet data Current liabilities $ 71,340 $ 103,300 Accounts receivable, net $ 30,800 $ 55,200Long-term notes payable 78,800 105,000 Merchandise inventory 63,600 105,400Common stock, $5 par value 200,000 206,000 Total assets 448,000 392,500Retained earnings 115,600 121,500 Common stock, $5 par value 200,000 206,000Total liabilities and equity $ 465,740 $ 535,800 Retained earnings 98,292 48,8812a. For both companies compute the (a) profit margin ratio, (b) total asset turnover, (c) return on total assets, and (d) return on equity. Assuming that each company’s stock can be purchased at $90 per share, compute their (e) price-earnings ratios and (f) dividend yields.2b. Identify which company’s stock you would recommend as the better investment.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.