Question

use the following ratio data to coplete old mill's income statement. 1. Inventory turnover was 3.70...

use the following ratio data to coplete old mill's income statement.

1. Inventory turnover was 3.70 (beginning merchandise inventory was $810; ending merchandise inventory was $770).

2. profit margin ratio is 14%

Old Mills Income Statement Year Ended December 31, 2018

Net sales revenue $6,900, cost of goods sold_________, selling and administrative expensed 1,710, interest expense____________, other expenses 120, income before income taxes 1,150, income tax expense_____________, net income_____________.

Homework Answers

Answer #1

Solution:

Inventory turnover = 3.70

Cost of goods sold / Average inventory = 3.70

Average inventory = ($810 + $770) / 2 = $790

Cost of goods sold = 3.70 * $790 = $2,923

Net Sales = $6,900

Profit margin ratio = 14%

Net Income = $6,900 * 14% = $966

Income statement - Old Mills Company
For year ended Dec 31, 2018
Particulars Amount
Net Sales revenue $6,900.00
Cost of goods sold $2,923.00
Gross Profit $3,977.00
Selling and administrative expenses $1,710.00
Interest expense $997.00
Other expense $120.00
Income before income taxes $1,150.00
Income tax expense $184.00
Net Income $966.00
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Traditional ​Mills's income statement appears as follows​ (amounts in​ thousands): ​(Click the icon to view the...
Traditional ​Mills's income statement appears as follows​ (amounts in​ thousands): ​(Click the icon to view the income​ statement.)Use the following ratio data to complete Traditional ​Mills' income​ statement:1. Inventory turnover was 3.20 ​(beginning Merchandise Inventory was $ 910 ending Merchandise Inventory was $ 870 2. Profit margin ratio is 12​%. ​(Enter amounts in thousands as provided to you in the problem statement. Round your answer to the nearest​ thousands.) Traditional Mills Income Statement Year Ended December 31, 2018 (in thousands)...
Exercise 9-11 Accounts receivable turnover, inventory turnover, and net margin LO 9-2, 9-4 Selected data from...
Exercise 9-11 Accounts receivable turnover, inventory turnover, and net margin LO 9-2, 9-4 Selected data from Stuart Company follow: Balance Sheets As of December 31 2018 2017 Accounts receivable $ 396,000 $ 380,000 Allowance for doubtful accounts (19,800 ) (15,200 ) Net accounts receivable $ 376,200 $ 364,800 Inventories, lower of cost or market $ 476,500 $ 435,000 Income Statement For the Years Ended December 31 2018 2017 Net credit sales $ 2,017,000 $ 1,757,000 Net cash sales 419,000 308,000...
The income statement of Sheffield Company is shown below. SHEFFIELD COMPANY INCOME STATEMENT FOR THE YEAR...
The income statement of Sheffield Company is shown below. SHEFFIELD COMPANY INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2017 Sales revenue $7,430,000 Cost of goods sold Beginning inventory $2,090,000 Purchases 4,770,000 Goods available for sale 6,860,000 Ending inventory 1,440,000 Cost of goods sold 5,420,000 Gross profit 2,010,000 Operating expenses Selling expenses 440,000 Administrative expenses 690,000 1,130,000 Net income $880,000 Additional information: 1. Accounts receivable decreased $350,000 during the year. 2. Prepaid expenses increased $150,000 during the year. 3. Accounts...
Income statement and balance sheet data for The Sports Shack are provided below. The Sports Shack...
Income statement and balance sheet data for The Sports Shack are provided below. The Sports Shack Income Statements For the years ended December 31 2019 2018 Sales revenue $8,200,000 $6,600,000 Cost of goods sold 6,100,000 4,700,000 Gross profit 2,100,000 1,900,000        Expenses:            Operating expenses 1,450,000 1,400,000            Depreciation expense 90,000 100,000            Interest expense 25,000 50,000            Income tax expense 95,000 80,000                Total expenses 1,660,000 1,630,000 Net income $440,000 $270,000 The Sports Shack Balance Sheets December 31 Assets 2019 2018 2017 Current assets:         Cash...
The following income statement and balance sheets for Laser World are provided: LASER WORLD Income Statement...
The following income statement and balance sheets for Laser World are provided: LASER WORLD Income Statement For the year ended December 31, 2018   Sales revenue $ 2,380,400   Cost of goods sold 1,560,000      Gross profit 820,400   Expenses:       Operating expenses 343,000       Depreciation expense 61,000       Loss on sale of land 4,400       Interest expense 22,000       Income tax expense 54,000             Total expenses 484,400      Net income $   336,000 LASER WORLD Balance Sheet December 31   2018   2017   Assets   Current assets:       Cash $ 128,000   ...
Exercise 23-3 The income statement of Pearl Company is shown below. PEARL COMPANY INCOME STATEMENT FOR...
Exercise 23-3 The income statement of Pearl Company is shown below. PEARL COMPANY INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2017 Sales revenue $6,630,000 Cost of goods sold    Beginning inventory $1,840,000    Purchases 4,520,000    Goods available for sale 6,360,000    Ending inventory 1,530,000    Cost of goods sold 4,830,000 Gross profit 1,800,000 Operating expenses    Selling expenses 450,000    Administrative expenses 660,000 1,110,000 Net income $690,000 Additional information: 1. Accounts receivable decreased $290,000 during the year. 2. Prepaid expenses increased $180,000 during the year....
The income statement of Indigo Company is shown below. INDIGO COMPANY INCOME STATEMENT FOR THE YEAR...
The income statement of Indigo Company is shown below. INDIGO COMPANY INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2017 Sales revenue $ 6,630,000 Cost of goods sold    Beginning inventory $ 1,840,000    Purchases 4,520,000    Goods available for sale 6,360,000    Ending inventory 1,530,000    Cost of goods sold 4,830,000 Gross profit 1,800,000 Operating expenses    Selling expenses 450,000    Administrative expenses 660,000 1,110,000 Net income $ 690,000 Additional information: 1. Accounts receivable decreased $ 290,000 during the year. 2. Prepaid expenses increased $ 180,000...
The income statement of Sandhill Company is shown below. SANDHILL COMPANY INCOME STATEMENT FOR THE YEAR...
The income statement of Sandhill Company is shown below. SANDHILL COMPANY INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2020 Sales revenue $6,860,000 Cost of goods sold Beginning inventory $1,810,000 Purchases 4,790,000 Goods available for sale 6,600,000 Ending inventory 1,570,000 Cost of goods sold 5,030,000 Gross profit 1,830,000 Operating expenses Selling expenses 420,000 Administrative expenses 640,000 1,060,000 Net income $770,000 Additional information: 1. Accounts receivable decreased $280,000 during the year. 2. Prepaid expenses increased $160,000 during the year. 3. Accounts...
Ansara Company had the following abbreviated income statement for the year ended December 31, 20Y2: 1...
Ansara Company had the following abbreviated income statement for the year ended December 31, 20Y2: 1 (in millions) 2 Sales $18,838.00 3 Cost of goods sold $15,495.00 4 Selling, administrative, and other expenses 2,002.00 5 Total expenses $17,497.00 6 Income from operations $1,341.00 Assume that there were $3,804 million fixed manufacturing costs and $1,166 million fixed selling, administrative, and other costs for the year. The finished goods inventories at the beginning and end of the year from the balance sheet...
Use the financial data shown below to calculate the following ratios for the current year: (a)...
Use the financial data shown below to calculate the following ratios for the current year: (a) Current ratio. (b) Acid-test ratio. (c) Accounts receivable turnover. (d) Days' sales uncollected. (e) Inventory turnover. (f) Days' sales in inventory. Income statement data Sales (all on credit) $650,000 Cost of goods sold 425,000 Income before taxes 78,000 Net income 54,600 Ending Balances Beginning Balances Cash $19,500 $15,000 Accounts receivable (net) 65,000 60,000 Inventory 71,500 64,500 Plant and equipment (net) 195,000 183,900 Total assets...