Question

Question 5:     4 marks  (3 marks for question 1  and  1 mark for question 2) Using the following operating data...

Question 5:     4 marks  (3 marks for question 1  and  1 mark for question 2)

Using the following operating data for Liwa Corporation, illustrate vertical analysis.

                                                            2008                    2007           

Net sales                             $350,000            $320,000

Cost of goods sold                200,000              100,000

Gross  profit                           150,000             220,000

Operating expenses              120,000              160,000

Net income                              30,000                60,000

Instructions:

1- Using the data presented for Liwa Company, prepare a schedule showing a vertical analysis for 2007 and 2008 ( use net  sales as base).                                                            (3  marks)

2- Interpret the  percentage of Net income that  you  find for  2008.                      (1 mark)

Homework Answers

Answer #1

Ans:

1.Particulars 2007 2008
Amount Amount % On net Sales Amount % On net Sales
Net Sales (A) 320000 100% 350000 100%
Cost of Goods Sold (B) 100000 31% 200000 57%
Gross Profit (C=A-B) 220000 69% 150000 43%
Operating Expenses (D) 160000 50% 120000 34%
Net Income (C-D) 60000 19% 30000 9%
2.Net Income for the year 2008 is 9% of Net Sales which is decreased from 19% when compared with 2007 Percentage of Net Income on Sales


Hope this helped ! Let me know in case of any queries.

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
I need correct Answers ASAP Please.. 2 A division's operating data for the past two years...
I need correct Answers ASAP Please.. 2 A division's operating data for the past two years is as follows: Year 1 Year 2 Return on investment 14% 18% Net operating income ? $180,000 Turnover ? 2 Margin ? ? Sales $1,000,000 ? In Year 2 the margin was twice as much as the margin in Year 1. How much was the division’s Net Operating Income for Year 1? Multiple Choice $180,000 $140,000 $45,000 $90,000 3. Financial data for Guyer Corporation,...
Question 4: Comparative information taken from the Wells Company financial statements is shown below:                          &n
Question 4: Comparative information taken from the Wells Company financial statements is shown below:                                                                                                  2009                     2008     (a)     Notes receivable                                                             20,000                15000      (b)    Accounts receivable                                                     182,000                 140,000 (c)     Retained earnings                                                           30,000                   20,000 (d)    Income taxes payable                                                     44,000                   20,000 (e)     Sales                                                                              960,000                 750,000 (f)     Operating expenses                                                       170,000                 200,000 Instructions: 1-Using horizontal analysis, show the percentage change from 2008 to 2009 with 2008 as the base year.                                                                                                                  2- Interpret the result that you find for sales and operating expenses.        (0.5*2 = 1 mark)
Operating data for Joshua Corporation are presented below. 2020 2019 Sales revenue $746,000 $603,000 Cost of...
Operating data for Joshua Corporation are presented below. 2020 2019 Sales revenue $746,000 $603,000 Cost of goods sold 466,250 384,714 Selling expenses 124,582 67,536 Administrative expenses 55,204 54,873 Income tax expense 37,300 24,120 Net income 62,664 71,757 Prepare a schedule showing a vertical analysis for 2020 and 2019. (Round answers to 1 decimal place, e.g. 48.5%.)
Question 3 (20 MINUTES, 14 MARKS) Part A Sicilian Bakery had the following operating results, based...
Question 3 (20 MINUTES, 14 MARKS) Part A Sicilian Bakery had the following operating results, based on sales of 100,000 units, in 2020: Sales                                                                          $2,000,000 Total variable Expenses                                         $1,200,000 Total fixed costs                                                       $400,000 The corporate tax rate was 30%. REQUIRED: If the company wanted to earn net income after tax of 7% of sales, what level of sales would be required to earn that amount? Part B Calculate the correct amount for each question mark: Sales                                                              ???? Total VC                                                       ...
PR 17-1B Horizontal analysis of income statement OBJ. 2 For 20Y2, Macklin Inc. reported a significant...
PR 17-1B Horizontal analysis of income statement OBJ. 2 For 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparative income statement: Macklin Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 Sales................................................................. Costofgoodssold..................................................... Grossprofit........................................................... Sellingexpenses...................................................... Administrativeexpenses............................................... Totaloperatingexpenses .............................................. Incomefromoperations............................................... Otherrevenue........................................................ Incomebeforeincometax ............................................. Incometaxexpense................................................... Netincome........................................................... Instructions 20Y2 $910,000 441,000 $469,000 $ 139,150 99,450 $238,600 $230,400 65,000 $295,400 65,000 $230,400...
A division's operating data for the past two years is as follows: Year 1 Year 2...
A division's operating data for the past two years is as follows: Year 1 Year 2 Return on investment 8% 12% Net operating income ? $120,000 Turnover ? 2 Margin ? ? Sales $1,000,000 ? In Year 2 the margin was twice as much as the margin in Year 1. How much was the division’s Net Operating Income for Year 1?
Problem 5-23 CVP Applications; Contribution Margin Ratio: Degree of Operating Leverage [LO5-1, LO5-3, LO5-4, LO5-5, LO5-8]...
Problem 5-23 CVP Applications; Contribution Margin Ratio: Degree of Operating Leverage [LO5-1, LO5-3, LO5-4, LO5-5, LO5-8] Feather Friends, Inc., distributes a high-quality wooden birdhouse that sells for $40 per unit. Variable expenses are $20.00 per unit, and fixed expenses total $160,000 per year. Its operating results for last year were as follows: Sales $ 1,120,000 Variable expenses 560,000 Contribution margin 560,000 Fixed expenses 160,000 Net operating income $ 400,000 Required: Answer each question independently based on the original data: 1....
Financial data for Guyer Corporation, for last year follow: Guyer Corporation Balance Sheet Beginning Balance Ending...
Financial data for Guyer Corporation, for last year follow: Guyer Corporation Balance Sheet Beginning Balance Ending Balance Assets Cash $ 140,000 $ 120,000 Accounts receivable 450,000 530,000 Inventory 320,000 380,000 Plant and equipment, net 680,000 680,000 Investment in ABC, Inc. 250,000 280,000 Land (undeveloped) 180,000 170,000 Total assets $ 2,020,000 $ 2,160,000 Liabilities and Stockholders' Equity Accounts payable $ 360,000 $ 310,000 Long-term debt 1,500,000 1,500,000 Stockholders' equity 160,000 350,000 Total liabilities and stockholders' equity $ 2,020,000 $ 2,160,000 Guyer...
USE THE FOLLOWING INFORMATION FOR QUESTION 3: Data for BikeNet Logistics most recent balance sheet and...
USE THE FOLLOWING INFORMATION FOR QUESTION 3: Data for BikeNet Logistics most recent balance sheet and income statement is presented below: Sales $723,000 Cost of goods sold 614,550 Interest expense 33,000 Net income $ 75,450 Cash & Mkt securities $ 120,000 Accts Receivables 210,000 Accounts payable $ 92,000 Inventories 183,000 Long-term debt 100,000 Net fixed assets 320,000 Common equity 641,000 Total assets $833,000 Total liab. and equity $833,000 3. Compute BikeNet’s quick ratio (and times-interest-earned (TIE) ratio: A)   Quick: 1.47,...
Operating data for Ayayai Corp. are presented below. 2017 2016 Sales revenue $836,700 $650,500 Cost of...
Operating data for Ayayai Corp. are presented below. 2017 2016 Sales revenue $836,700 $650,500 Cost of goods sold 521,400 409,700 Selling expenses 126,900 75,800 Administrative expenses 78,800 51,500 Income tax expense 35,100 25,600 Net income 74,500 87,900 Prepare a schedule showing a vertical analysis for 2017 and 2016. (Round percentages to 1 decimal place, e.g. 12.1%.) AYAYAI CORP. Condensed Income Statement For the Years Ended December 31December 31For the Month Ended December 31 2017 2016 Amount Percent Amount Percent Sales...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT