Can someone help with this question please?
The following is the income statement for Regina Company, Inc.:
Statement of Income (in thousands) 12/31/06 12/31/07
Net sales $76,144 $128,234
Costs of Goods Sold 46,213 70,756
Gross Margin 29,931 57,478
General Expenses 20,105 42,600
Operating Income 9,826 14,878
Interest Expense 1,930 1,584
Income Taxes 3,807 6,189
Net Income 4,089 7,105
Earnings per share .46 .78
Required: Prepare a vertical analysis of the financial statement.
Can someone help with this question please?
The following is the income statement for Regina Company, Inc.:
Statement of Income (in thousands) 12/31/06 12/31/07
Net sales $76,144 $128,234
Costs of Goods Sold 46,213 70,756
Gross Margin 29,931 57,478
General Expenses 20,105 42,600
Operating Income 9,826 14,878
Interest Expense 1,930 1,584
Income Taxes 3,807 6,189
Net Income 4,089 7,105
Earnings per share .46 .78
Required: Prepare a vertical analysis of the financial statement.
For unlimited access to Homework Help, a Homework+ subscription is required.
Related questions
What are Aetna Inc financial statements, sale profits, cash flow, debt level, liquidity, return on assets, and return on equity?
Income Statement
All numbers in thousands
Revenue | 12/31/2016 | 12/31/2015 | 12/31/2014 |
Total Revenue | 63,155,000 | 60,337,000 | 58,003,000 |
Cost of Revenue | 46,356,000 | 43,833,000 | 42,912,000 |
Gross Profit | 16,799,000 | 16,504,000 | 15,091,000 |
Operating Expenses | |||
Research Development | - | - | - |
Selling General and Administrative | 12,085,000 | 11,644,000 | 10,833,000 |
Non Recurring | - | - | - |
Others | 247,000 | 255,000 | 243,000 |
Total Operating Expenses | - | - | - |
Operating Income or Loss | 4,467,000 | 4,605,000 | 4,015,000 |
Income from Continuing Operations | |||
Total Other Income/Expenses Net | 128,000 | 128,000 | -181,000 |
Earnings Before Interest and Taxes | 4,595,000 | 4,605,000 | 3,834,000 |
Interest Expense | 604,000 | 369,000 | 334,000 |
Income Before Tax | 3,991,000 | 4,236,000 | 3,500,000 |
Income Tax Expense | 1,735,000 | 1,841,000 | 1,455,000 |
Minority Interest | 62,000 | 65,000 | 69,200 |
Net Income From Continuing Ops | 2,256,000 | 2,395,000 | 2,045,000 |
Non-recurring Events | |||
Discontinued Operations | - | - | - |
Extraordinary Items | - | - | - |
Effect Of Accounting Changes | - | - | - |
Other Items | - | - | - |
Net Income | |||
Net Income | 2,271,000 | 2,390,000 | 2,041,000 |
Preferred Stock And Other Adjustments | - | - | - |
Net Income Applicable To Common Shares | 2,271,000 | 2,390,000 | 2,041,000 |
Canadian Bacon Inc. financial statements are presented in the table below.
Based on the information in the table, calculate the firmâs the operating profit margin.
Round the answers to two decimal places in percentage form.
Balance Sheet December 31, 2013
Cash and marketable securities | $112,000 | Accounts payable | $211,000 |
Accounts receivable | $325,000 | Notes payable | $51,500 |
Inventories | $426,000 | Accrued expenses | $50,100 |
Prepaid expenses | $10,700 | Total current liabilities | $312,600 |
Total current assets | $873,700 | Long-term debt | $225,000 |
Gross fixed assets | $1,514,000 | Par value and paid-in-capital | $117,000 |
Less: accumulated depreciation | $315,000 | Retained Earnings | $1,418,100 |
Net fixed assets | $1,199,000 | Common Equity | 1,535,100 |
Total assets | $2,072,700 | Total liabilities and ownerâs equity | $2,072,700 |
Income Statement, Year of 2013
Net sales (all credit) | $3,256,600.00 |
Less: Cost of goods sold | $2,572,714.00 |
Selling and administrative expenses | $323,000.00 |
Depreciation expense | $115,000.00 |
EBIT | $245,886.00 |
Interest expense | $29,600.00 |
Earnings before taxes | $216,286.00 |
Income taxes | $86,514.40 |
Net income | $129,771.60 |
LULULEMON:
Need the following ratios to be calculated using the financial sheets copied at the bottom. Each ratio needs to be calculated using the information from 2016. Each ratio also needs to be broken down and illustrated by the step by step process. Finally, please include any and all observations for each ratio and analysis.
1) Common Size analysis
2) Common size vertical analysis & graph
3) Current Ratio
4) Quick Ratio
5) Cash Ratio
6) Inventory Turnover
7) Receivables Turnover
8) Total Asset Turnover
9) Fixed Asset Turnover
10) Gross profit margin
11) Operating Profit margin
12) Net profit margin
13) Return on total assets
14) return on equity
15) basic earning power
16) Deb/net worth ratio
17) debt ratio
18) DuPont System
19) Times-interest-earned
Financial Statements:
CONSOLIDATED BALANCE SHEETS - USD ($) $ in Thousands | Jan. 29, 2017 | Jan. 31, 2016 |
Current assets | ||
Cash and cash equivalents | $ 734,846 | $ 501,482 |
Accounts receivable | 9,200 | 13,108 |
Inventories | 298,432 | 284,009 |
Prepaid and receivable income taxes | 81,190 | 91,453 |
Other prepaid expenses and other current assets | 39,069 | 26,987 |
Total current assets | 1,162,737 | 917,039 |
Property and equipment, net | 423,499 | 349,605 |
Goodwill and intangible assets, net | 24,557 | 24,777 |
Deferred income tax assets | 26,256 | 11,802 |
Other non-current assets | 20,492 | 10,854 |
Total assets | 1,657,541 | 1,314,077 |
Current liabilities | ||
Accounts payable | 24,846 | 10,381 |
Accrued inventory liabilities | 8,601 | 25,451 |
Accrued compensation and related expenses | 55,238 | 43,524 |
Income taxes payable | 30,290 | 37,736 |
Unredeemed gift card liability | 70,454 | 57,736 |
Other accrued liabilities | 52,020 | 50,676 |
Total current liabilities | 241,449 | 225,504 |
Deferred income tax liabilities | 7,262 | 10,759 |
Other non-current liabilities | 48,857 | 50,332 |
Total liabilities | 297,568 | 286,595 |
Stockholders' equity | ||
Undesignated preferred stock, $0.01 par value: 5,000 shares authorized; none issued and outstanding | 0 | 0 |
Exchangeable stock, no par value: 60,000 shares authorized; 9,781 and 9,804 issued and outstanding | 0 | 0 |
Special voting stock, $0.000005 par value: 60,000 shares authorized; 9,781 and 9,804 issued and outstanding | 0 | 0 |
Common stock, $0.005 par value: 400,000 shares authorized; 127,304 and 127,482 issued and outstanding | 637 | 637 |
Additional paid-in capital | 266,622 | 245,533 |
Retained earnings | 1,294,214 | 1,019,515 |
Accumulated other comprehensive loss | (201,500) | (238,203) |
Total stockholders' equity | 1,359,973 | 1,027,482 |
Total liabilities and stockholders' equity | $ 1,657,541 | $ 1,314,077 |
Income statement:
CONSOLIDATED STATEMENTS OF OPERATIONS AND COMPREHENSIVE INCOME - USD ($) shares in Thousands, $ in Thousands | 3 Months Ended | 12 Months Ended | |||||||||
Jan. 29, 2017 | Oct. 30, 2016 | Jul. 31, 2016 | May 01, 2016 | Jan. 31, 2016 | Nov. 01, 2015 | Aug. 02, 2015 | May 03, 2015 | Jan. 29, 2017 | Jan. 31, 2016 | Feb. 01, 2015 | |
Income Statement [Abstract] | |||||||||||
Net revenue | $ 789,940 | $ 544,416 | $ 514,520 | $ 495,516 | $ 704,276 | $ 479,693 | $ 453,010 | $ 423,544 | $ 2,344,392 | $ 2,060,523 | $ 1,797,213 |
Cost of goods sold | 362,041 | 265,990 | 260,359 | 256,385 | 349,809 | 254,896 | 240,985 | 217,667 | 1,144,775 | 1,063,357 | 883,033 |
Gross profit | 427,899 | 278,426 | 254,161 | 239,131 | 354,467 | 224,797 | 212,025 | 205,877 | 1,199,617 | 997,166 | 914,180 |
Selling, general and administrative expenses | 231,270 | 185,451 | 180,202 | 181,542 | 188,184 | 156,619 | 145,446 | 137,841 | 778,465 | 628,090 | 538,147 |
Income from operations | 196,629 | 92,975 | 73,959 | 57,589 | 166,283 | 68,178 | 66,579 | 68,036 | 421,152 | 369,076 | 376,033 |
Other income (expense), net | 857 | 628 | 578 | (486) | 938 | (2,890) | 842 | 529 | 1,577 | (581) | 7,102 |
Income before income tax expense | 197,486 | 93,603 | 74,537 | 57,103 | 167,221 | 65,288 | 67,421 | 68,565 | 422,729 | 368,495 | 383,135 |
Income tax expense | 61,351 | 25,318 | 20,912 | 11,767 | 49,805 | 12,135 | 19,753 | 20,755 | 119,348 | 102,448 | 144,102 |
Net income | 136,135 | 68,285 | 53,625 | 45,336 | 117,416 | 53,153 | 47,668 | 47,810 | 303,381 | 266,047 | 239,033 |
Other comprehensive income (loss): | |||||||||||
Foreign currency translation adjustment | 15,941 | (24,748) | (28,052) | 73,562 | (47,369) | (665) | (39,368) | 22,606 | 36,703 | (64,796) | (105,339) |
Comprehensive income | $ 152,076 | $ 43,537 | $ 25,573 | $ 118,898 | $ 70,047 | $ 52,488 | $ 8,300 | $ 70,416 | $ 340,084 | $ 201,251 | $ 133,694 |
Basic earnings per share (in dollars per share) | $ 0.99 | $ 0.50 | $ 0.39 | $ 0.33 | $ 0.85 | $ 0.38 | $ 0.34 | $ 0.34 | $ 2.21 | $ 1.90 | $ 1.66 |
Diluted earnings per share (in dollars per share) | $ 0.99 | $ 0.50 | $ 0.39 | $ 0.33 | $ 0.85 | $ 0.38 | $ 0.34 | $ 0.34 | $ 2.21 | $ 1.89 | $ 1.66 |
Basic weighted-average number of shares outstanding (in shares) | 137,086 | 140,365 | 143,935 | ||||||||
Diluted weighted-average number of shares outstanding (in shares) | 137,302 | 140,610 | 144,298 |
Cash Flow Sheet:
CONSOLIDATED STATEMENTS OF CASH FLOWS - USD ($) $ in Thousands | 12 Months Ended | ||
Jan. 29, 2017 | Jan. 31, 2016 | Feb. 01, 2015 | |
Cash flows from operating activities | |||
Net income | $ 303,381 | $ 266,047 | $ 239,033 |
Items not affecting cash | |||
Depreciation and amortization | 87,697 | 73,383 | 58,364 |
Stock-based compensation expense | 16,822 | 10,356 | 8,269 |
Derecognition of unredeemed gift card liability | (4,548) | (3,647) | (1,468) |
Deferred income taxes | (17,563) | 11,142 | 2,087 |
Tax benefits from stock-based compensation | (1,273) | 1,202 | (413) |
Changes in operating assets and liabilities | |||
Inventories | (5,403) | (83,286) | (26,806) |
Prepaid and receivable income taxes | 11,537 | (52,110) | (15,234) |
Other prepaid expenses and other current assets | (6,730) | (3,816) | (6,444) |
Accounts payable | 14,080 | 1,247 | (2,198) |
Accrued inventory liabilities | (18,900) | 5,198 | 8,276 |
Accrued compensation and related expenses | 9,943 | 14,937 | 11,561 |
Income taxes payable | (10,020) | 19,470 | 19,304 |
Unredeemed gift card liability | 16,010 | 16,574 | 11,326 |
Other accrued liabilities | 467 | 19,563 | 3,788 |
Other non-current assets and liabilities | (10,381) | 2,480 | 5,004 |
Net cash provided by operating activities | 385,119 | 298,740 | 314,449 |
Cash flows from investing activities | |||
Purchase of property and equipment | (149,511) | (143,487) | (119,733) |
Net cash used in investing activities | (149,511) | (143,487) | (119,733) |
Cash flows from financing activities | |||
Proceeds from settlement of stock-based compensation | 6,907 | 4,704 | 2,913 |
Tax benefits from stock-based compensation | 1,273 | (1,202) | 413 |
Taxes paid related to net share settlement of stock-based compensation | (3,268) | (2,857) | (4,972) |
Repurchase of common stock | (29,327) | (274,193) | (147,431) |
Registration fees associated with prospectus supplement | 0 | (145) | 0 |
Deferred debt financing costs | (923) | 0 | 0 |
Net cash used in financing activities | (25,338) | (273,693) | (149,077) |
Effect of exchange rate changes on cash | 23,094 | (44,557) | (79,809) |
Increase (decrease) in cash and cash equivalents | 233,364 | (162,997) | (34,170) |
Cash and cash equivalents, beginning of period | 501,482 | 664,479 | 698,649 |
Cash and cash equivalents, end of period | $ 734,846 | $ 501,482 | $ 664,479 |