Question

In: Accounting

Preparing Income Statements by Using Net Sales as the Base: Vertical Analysislt Jasmine Company provided the...

Preparing Income Statements by Using Net Sales as the Base: Vertical Analysislt Jasmine Company provided the following income statements for its first 3 years of operation:

Year 1 Year 2 Year 3

Net sales $5,000,000 $4,500,000 $4,000,000

Less: Cost of goods sold (3,000,000) (3,250,000) (3,600,000)

Gross margin $2,000,000 $1,250,000 $400,000

Less: Operating expenses (1,420,000) (800,000) (165,000)

Income taxes (232,000) (180,000) (134,000)

Net income $348,000 $270,000 $101,000

Required: Prepare common-size income statements by using net sales as the base. Round answers to the nearest whole percentage.

Jasmine Company Income Statement

Year 1 dollars Year 1 percent Year 2 dollars Year 2 percent Year 3 dollars Year 3 percent $ % $ % $ % $ $ $ $ $ $

Solutions

Expert Solution

Answer- JASMINE COMPANY

Common-size Income Statement

Year 1 Year 2 Year 3
$ % $ % $ %
Sales 5,000,000    100.00    4,500,000 100.00    4,000,000 100.00   
Cost of Goods Sold (3,000,000) 60 (3,250,000) 72.22 (3,600,000) 90
Gross Profit 2,000,000 40 1,250,000 27.78 400,000 10
Operating Expenses (1,420,000) 28.4 (800,000) 17.78 (165,000) 4.12
Income Taxes (232,000) 4.64 (180,000) 4 (134,000) 3.35
Net Income $348,000 6.96 $270,000 6 $101,000 2.53

Note :

Workings
Year 1 Year 2 Year 3
Sales 5,000,000/5,000,000*100 4,500,000/ 4,500,000*100 4,000,000/ 4,000,000*100
Cost of Goods Sold    3,000,000/5,000,000*100 3,250,000 / 4,500,000*100 3,600,000/ 4,000,000*100
Gross Profit 2,000,000/ 5,000,000*100 1,250,000/ 4,500,000*100 400,000/ 4,000,000*100
Operating Expenses 1,420,000 / 5,000,000*100 800,000/ 4,500,000*100 165,000/4,000,000*100
Income Taxes 232,000/5,000,000*100 180,000/4,500,000*100 134,000/4,000,000*100
Net Income 348,000 / 5,000,000*100 270,000/ 4,500,000*100 101,000/4,000,000*100

Kindly give thumbs up if u like my answer....Thanks!!!


Related Solutions

Preparing Common-Size Income Statements by Using Base Period Horizontal Analysis Scherer Company provided the following income...
Preparing Common-Size Income Statements by Using Base Period Horizontal Analysis Scherer Company provided the following income statements for its first 3 years of operation: Scherer Company Income Statements Years of Operation Year 1 Year 2 Year 3 Net sales $1,010,000 $1,131,200 $1,353,400 Less: Cost of goods sold (293,000) (314,000) (362,000) Gross margin $717,000 $817,200 $991,400 Less: Operating expenses (424,000) (490,000) (595,500) Income taxes (110,800) (120,200) (135,000) Net income $182,200 $207,000 $260,900 repare common-size income statements by using Year 1 as...
Assume that a company is using the CVP formula to calculate sales needed to achieve a desired net income.
  1) Desired sales ($) = (Total Fixed Costs + Net Income) / Contribution margin ratio Assume that a company is using the CVP formula to calculate sales needed to achieve a desired net income. If the company first calculates the breakeven point, what is true of desired net income (profit)? a. It will be equal to fixed costs b. It will be equal to variable costs c. It will be equal to unit contribution d. It is equal to...
Analyze the following common size income statements for 3T Company: 2015 2014 Net sales 100% 100%...
Analyze the following common size income statements for 3T Company: 2015 2014 Net sales 100% 100% COGS 89 87       Gross margin 11% 13% Selling, general and administrative     7 9 Restructuring, asset impairments and other charges     0    9        Income/(loss) from operations 4% (5)% Interest expense (1) (2)      Income/(loss) before taxes 3% (7%) Provision for/(benefit from) income taxes    1 0      Income/(loss) after taxes 2% (7)% Discontinued operations, net 6 1      Net income (loss)...
Answer question. Analyze the common size income statements below for 3T Company: 2015 2014 Net sales...
Answer question. Analyze the common size income statements below for 3T Company: 2015 2014 Net sales 100% 100% COGS 89 87       Gross margin 11% 13% Selling, general and administrative     7 9 Restructuring, asset impairments and other charges     0    9        Income/(loss) from operations 4% (5)% Interest expense (1) (2)      Income/(loss) before taxes 3% (7%) Provision for/(benefit from) income taxes    1 0      Income/(loss) after taxes 2% (7)% Discontinued operations, net 6 1      Net...
Case Study Scenario: Vertical Net Vertical Net is a public company that operates content specific websites...
Case Study Scenario: Vertical Net Vertical Net is a public company that operates content specific websites and business-to-business procurement portals. Vertical Net’s business model is to generate revenue by providing the interested organization’s advertising platform for its products and services where the interested organization can advertise its services or products over many related websites. Currently, Vertical Net has 43 of these industry-specific content websites and business-to-business procurement portals. For example, Vertical Net owns the rights to the following websites: Water-on-line,...
Using the information shown, what is the asset turnover ratio? Net Income $500,500 Net Sales $379,000...
Using the information shown, what is the asset turnover ratio? Net Income $500,500 Net Sales $379,000 Current Assets $750,000 Current Libabilities $212,000 Average Assets $875,000
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For the Year Ended December 31, 2018 ($ in 000s) Revenues and gains: Sales $ 740 Gain on sale of buildings 12 $ 752 Expenses and loss: Cost of goods sold $ 270 Salaries 114 Insurance 34 Depreciation 117 Interest expense 44 Loss on sale of machinery 11 590 Income before tax 162 Income tax expense 81 Net income $ 81 PARNELL COMPANY Selected Accounts...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For the Year Ended December 31, 2018 ($ in 000s) Revenues and gains: Sales $ 700 Gain on sale of buildings 10 $ 710 Expenses and loss: Cost of goods sold $ 250 Salaries 110 Insurance 30 Depreciation 113 Interest expense 40 Loss on sale of machinery 13 556 Income before tax 154 Income tax expense 77 Net income $ 77 PARNELL COMPANY Selected Accounts...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For the Year Ended December 31, 2018 ($ in 000s) Revenues and gains: Sales $ 780 Gain on sale of buildings 11 $ 791 Expenses and loss: Cost of goods sold $ 290 Salaries 118 Insurance 38 Depreciation 121 Interest expense 48 Loss on sale of machinery 12 627 Income before tax 164 Income tax expense 82 Net income $ 82 PARNELL COMPANY Selected Accounts...
Portions of the financial statements for Hawkeye Company are provided below. HAWKEYE COMPANY Income Statement For...
Portions of the financial statements for Hawkeye Company are provided below. HAWKEYE COMPANY Income Statement For the Year Ended December 31, 2018 Sales $ 810 Cost of goods sold 305 Gross margin 505 Operating expenses: Salaries $ 223 Depreciation 181 Loss on sale of land 10 Total operating expenses 414 Operating income 91 Other income (expense): Gain on sale of cash equivalents 4 Interest expense (31 ) Income before tax 64 Income tax expense 32 Net income $ 32 HAWKEYE...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT