Creating a
• LO4–10
Cadux Candy Company’s income statement for the year ended December 31, 2018, reported interest expense of $2 million and income tax expense of $12 million. Current assets listed in its balance sheet include cash,
Debt to equity ratio | 1.0 |
2.0 | |
Acid-test ratio | 1.0 |
Times interest earned ratio | 17 times |
Return on assets | 10% |
Return on shareholders’ equity | 20% |
Profit margin on sales | 5% |
Gross profit margin (gross profit divided by net sales) | 40% |
Inventory turnover | 8 times |
Receivables turnover | 20 times |
Required:
Prepare a December 31, 2018, balance sheet for the Cadux Candy Company.
Ratio analysis
Ratio analysis is a tool to analyze the financial statements of a company which helps to express a mathematical relationship among the items of financial statements.
Balance sheet
This financial statement reports a company’s resources (assets) and claims of creditors (liabilities) and stockholders (stockholders’ equity) over those resources. The resources of the company are assets which include money contributed by stockholders and creditors. Hence, the main elements of the balance sheet are assets, liabilities, and stockholders’ equity.
To prepare: The balance sheet of Company CC for the year ended December, 31 2018.
Explanation of Solution
Prepare the balance sheet of Company CC for the year ended December, 31 2018.
Corporation CC | ||
Balance Sheet | ||
For the year ended December 31, 2018 | ||
Assets | Amount ($ in millions) |
Amount ($ in millions) |
Current assets: | ||
Cash (3) | 10 | |
Accounts receivables (2) | 20 | |
Inventories (1) | 30 | |
Total current assets | 60 | |
Net property, plant, and equipment (5) | 140 | |
Total assets | 200 | |
Liabilities and Shareholders' Equity | Amount ($ in millions) |
Amount ($ in millions) |
Current liabilities (4) | 30 | |
Long-term liabilities (7) | 70 | |
Shareholders’ equity (6) | 100 | |
Total liabilities and shareholders’ equity | 200 |
Table (1)
Working notes:
1)
To determine: The amount of net income.
Solution:
Given, Interest expense is $2 and Income tax expense $12
2)
To determine: The average total assets using return on assets ratio.
Solution:
3)
To determine: The amount of net sales.
Solution:
4)
To determine: The gross profit and cost of goods sold.
Solution:
5)
To determine: The amount of average inventory.
Solution:
6)
To determine: The amount of average receivables.
Solution:
7)
To determine: The cash balance.
Solution:
By using the above equation, determine amount of cash.
8)
To determine: The amount of current liabilities.
Solution:
9)
To determine: The amount of non-current assets.
Solution:
10)
To determine: The amount of average shareholders’ equity.
Solution:
11)
To determine: The amount of long-term liabilities
Solution:
Want to see more full solutions like this?
Chapter 4 Solutions
INTERMEDIATE ACCOUNTING(LL)-W/CONNECT
- Computing Asset Ratios The following information relates to Mazy's Inc. $ millions Total Assets Revenue Net Income Fiscal Year 2015 $47,325 $62,282 $2,461 Fiscal Year 2014 46,926 Mazy's fiscal years for 2015 and 2014 end on January 30, 2016, and January 31, 2015, respectively. Note: Carry all decimals in calculations; enter the answers rounded to two digits after the decimal; for example, enter 1.42 for 1.424, or 1.43 for 1.425. a. Compute the asset turnover ratio for fiscal year 2015. Answer b. Compute the return on assets ratio for fiscal year 2015. Answerarrow_forwardQuestion 7 Comparative financial statement data for Cullumber Company and Crane Company, two competitors, appear below. All balance sheet data are as of December 31, 2017. Cullumber Crane Company Company 2017 2017 Net sales $2,700,000 $930,000 Cost of goods sold 1,762,500 510,000 Operating expenses 424,500 147,000 Interest expense 13,500 5,700 Income tax expense 127,500 54,000 Current assets 411,100 194,636 Plant assets (net) 798,000 209,592 Current liabilities 99,488 50,574 Long-term liabilities 162,750 61,026 Net cash provided by operating activities 207,000 54,000 Capital expenditures 135,000 30,000 Dividends paid on common stock 54,000 22,500 Weighted-average number of shares outstanding 80,000 50,000arrow_forwardCalculate the average life, average age, and asset turnover ratios for Exxon Mobil. Discuss what each ratio tells you in the context of your chosen company. Calculate the accounts receivable turnover ratio and convert that ratio into days. Discuss what each ratio tells you in the context of your chosen company. Assets Fiscal year is January-December. All values USD millions. 2018 2019 Cash & Short Term Investments 3.04B 3.09B Cash Only 3.04B 3.09B Short-Term Investments - - Total Accounts Receivable 24.7B 26.97B Accounts Receivables, Net 19.64B 21.1B Accounts Receivables, Gross 20.04B 21.51B Bad Debt/Doubtful Accounts (400M) (405M) Other Receivables 5.06B 5.87B Inventories 18.96B 18.53B Finished Goods 14.8B 14.01B Work in Progress - - Raw Materials 4.16B 4.52B Progress Payments & Other - - Other Current Assets 1.27B 1.47B…arrow_forward
- Part C. Cullumber Appliances Corporation has reported its financial results for the year ended December 31, 2017. Cullumber Appliances Corporation Income Statement for the Fiscal Year Ended December 31, 2017 Net sales $ 5,899,512,000 Cost of goods sold 3,224,958,940 Gross profit $ 2,674,553,060 Selling, general, and administrative expenses 1,101,893,423 Depreciation 334,776,116 Operating income $ 1,237,883,521 Interest expense 32,014,500 EBT $ 1,205,869,021 Income taxes 320,866,566 Net earnings $ 885,002,455 Cullumber Appliances Corporation Balance Sheet as of December 31, 2017 Assets: Liabilities Equity: Cash and cash equivalents $ 642,840,000 Short-term borrowings $…arrow_forwardWorksheet chapter 9 Assets 2,980,000 Liabilities 1,250,000 Inventory 1,410,000 Sales 5,000,000 Avg Inventory 1,500,000 Accounts Receivable 1,320,000 Debt 1,000,000 Given the data above, provide the following calculations: Debt ratio Total asset turnover Receivables turnover Inventory turnover Quick ratio Current ratio Given the above data, construct a balance sheetarrow_forwardTrying to calculate, Times Interest Earned. tax rate is 22% 3M Company Consolidated Statements Of Earnings $ millions Dec. 31, 2018 Dec. 31, 2017 Net sales $ 32,765 $ 31,657 Cost of sales $ 16,682 $ 16,055 Research, development and engineering expenses $ 1,821 $ 1,870 Selling, general and administrative expenses $ 7,602 $ 6,626 Gain on sale of business -$ 547 -$ 586 Total operating expenses $ 25,558 $ 23,965 Operating income $ 7,207 $ 7,692 Nonoperating expense, net $ 207 $ 144 Earnings before income taxes $ 7,000 $…arrow_forward
- Return on Assets Ratio and Asset Turnover Ratio Northern Systems reported the following financlal data (in millions) In its annual report: 2018 2019 Net Income $9,050 $7.500 Net Sales 52,350 37,200 Total Assets 58,734 68,128 If the company's total assets are $55,676 in 2017, calculate the company's: (a) return on assets (round answers to one decimal place - ex: 10.79%6) (b) asset turnover for 2018 and 2019 (round answers to two decimal places) 2018 2019 a. Return on Assets Ratio 96 96 b. Asset Turnover Ratio Check O Prevlous Save Answersarrow_forwardWhat are the firm's days' sales outstanding for 2018 and 2019? Income Statements ($ in millions) Balance Sheets ($ in millions) 2018 2019 Assets 2018 2019 $1,265 | Cash $780 Short-Term investments $92 | Accounts rec. Sales Revenue $1,180 $35 $20 $660 $20 $5 Less: Cost of goods sold Less: Operating Expenses Less: Depreciation Earnings before interest and taxes Less: Interest paid $75 190 235 $50 Inventory $343 Total Current Assets $40 250 300 $405 $495 $560 $170 $150 | Net fixed assets 990 1,105 Taxable Income $235 $193 Less: Taxes (40%) $94 $77 Total assets $1,485 1,665 Net income $141 $116 Liabilities and Owner's Equity Dividends (45%) Additions to Retained Earnings $63 $52 2018 2019 $78 $64 Accounts payable $125 $100 Accruals $10 $10 Notes payable 35 40 Total Current Liabilities $170 $150 Long-term debt 598 790 Total Liabilities $768 $940 Common stock 554 498 Retained earnings Total Equity Total liab.& equity 163 $227 717 $725 $1,485 $1,665arrow_forward28 A company's income statement reveals the following amounts related to the company's operations for the most recent year: • Net sales revenue: $5,000,000 • Interest expense: $60,000 • Income tax expense: $80,000 • Net income: $400,000 What was the company's times-interest-earned ratio for the year? 4.33 O 6.75 O 7.67 9.00 NEXT. BOOKMARKarrow_forward
- Problem: Remesh Corporation prepared the following income statement and statement of retained earnings for the year ended December 31, 2021. Remesh Corporation December 31, 2021 Expense and Profit Statement Dollars in thousands Sales (net) $206,000 Less: Selling Expenses (20,600) Net Sales $185,400 Add: Interest Revenue 2,400 Add: Gain on sale of equipment 3,600 Gross Sales Revenue $191,400 Less: Cost of operations: Cost of Goods Sold $126,100 Correction of overstatement in last years income because of error $5,500 (net of tax credit) $3850 Dividend cost ($0.50 per share for 8k common shares) $4000 Unusual loss due to a hurricane, $6,400 (net of tax credit) $1,920 ($135,870) Taxable Revenues $55,530 Less: Income tax on income from continuing operations $16,659 Net income $38871 Miscellaneous Deductions Loss from operations of…arrow_forwardFirm A: Assets Current assets 4 Fixed assets 10 Total assets 14 Firm A: Total sales 12 Cost of sales -5 7 Gross Profit Firm B: Assets Current assets 7 7 14 Fixed assets Total assets Firm B: 12 Total sales Cost of sales -7 Gross Profit 5 Above are portions of the balance sheet and income statement for two companies in 2018. Based upon this information, which of the following statements is most likely to be true? Current asset turnover indicates greater liquidity for firm B than firm A. Both asset turnover ratios and fixed asset turnover ratios indicate that firm A is generating greater revenue per dollar of assets than firm B. Asset turnover ratios indicate that firm A is generating greater revenue per dollar of assets than firm B. O Fixed asset turnover ratios indicate that firm A generating more sales for the assets it employs than firm B. Fixed asset turnover ratios indicate that firm A generating fewer sales for the assets it employs than firm B.arrow_forwardFigures are in millions. Total assets Total liabilities Net sales Net income December 31, 2019 $930.90 197.10 515.70 80.70 December 31, 2018 $920.10 208.60 517.40 67.20 Find Asset turnover, return on assets and profit margin on sales for the year 2019?arrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT