Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Balance Sheet | Horizontal Analysis | |||
USD | USD |
Increase or (Decrease) 2018 over 2017 |
||
Assets | 2018 | 2017 | Dollars | Percent |
Cash | 21,120.00 | 13,844.00 | 7,276.00 | 52.56% |
Marketable Securities | 20,481.00 | 11,233.00 | 9,248.00 | 82.33% |
Accounts Receivable | 16,849.00 | 17,460.00 | (611.00) | -3.50% |
Inventories | 2,349.00 | 2,111.00 | 238.00 | 11.27% |
Deferred Tax Assets | 5,546.00 | 4,318.00 | 1,228.00 | 28.44% |
Vendor Non Trade Receivables | 13,494.00 | 9,759.00 | 3,735.00 | 38.27% |
Other Current Assets | 9,539.00 | 9,806.00 | (267.00) | -2.72% |
Total Current Assets | 89,378.00 | 68,531.00 | 20,847.00 | 30.42% |
Long Term Securities | 164,065.00 | 130,162.00 | 33,903.00 | 26.05% |
PP&E | 22,471.00 | 20,624.00 | 1,847.00 | 8.96% |
Goodwill | 5,116.00 | 4,616.00 | 500.00 | 10.83% |
Intangible Assets | 3,893.00 | 4,142.00 | (249.00) | -6.01% |
Other Assets | 5,556.00 | 3,764.00 | 1,792.00 | 47.61% |
Total Assets | 290,479.00 | 231,839.00 | 58,640.00 | 25.29% |
Liabilities | ||||
Accounts Payable | 35,490.00 | 30,196.00 | 5,294.00 | 17.53% |
Accrued Expense | 25,181.00 | 18,453.00 | 6,728.00 | 36.46% |
Deferred Revenue | 8,940.00 | 8,491.00 | 449.00 | 5.29% |
Commercial Paper | 8,499.00 | 6,308.00 | 2,191.00 | 34.73% |
Current Portion- LT Debt | 2,500.00 | - | 2,500.00 | 100.00% |
Total Current Liabilities | 80,610.00 | 63,448.00 | 17,162.00 | 27.05% |
Deferred Revenue- Non Current | 3,624.00 | 3,031.00 | 593.00 | 19.56% |
Long Term debt | 53,463.00 | 28,987.00 | 24,476.00 | 84.44% |
Other Non Current Liabilities | 33,427.00 | 24,826.00 | 8,601.00 | 34.65% |
Total Liabilities | 171,124.00 | 120,292.00 | 50,832.00 | 42.26% |
Stockholder's Equity | ||||
Common Stock | 27,416.00 | 23,313.00 | 4,103.00 | 17.60% |
Retained Earnings | 92,284.00 | 87,152.00 | 5,132.00 | 5.89% |
Accum. OCI | (345.00) | 1,082.00 | (1,427.00) | -131.89% |
Total Stockholder's Equity | 119,355.00 | 111,547.00 | 7,808.00 | 7.00% |
Total Liabilities and Equity | 290,479.00 | 231,839.00 | 58,640.00 | 25.29% |
Income Statement | Horizontal Analysis | |||
USD | USD |
Increase or (Decrease) 2018 over 2017 |
||
2018 | 2017 | Dollars | Percent | |
Net Sales | 233,715.00 | 182,795.00 | 50,920.00 | 27.86% |
Cost of sales | 140,089.00 | 112,258.00 | 27,831.00 | 24.79% |
Gross Margin | 93,626.00 | 70,537.00 | 23,089.00 | 32.73% |
Research & Development | 8,067.00 | 6,041.00 | 2,026.00 | 33.54% |
Selling, General & Administrative | 14,329.00 | 11,993.00 | 2,336.00 | 19.48% |
Total Operating Expenses | 22,396.00 | 18,034.00 | 4,362.00 | 24.19% |
Operating Income | 71,230.00 | 52,503.00 | 18,727.00 | 35.67% |
Other Income | 1,285.00 | 980.00 | 305.00 | 31.12% |
Income before taxes | 72,515.00 | 53,483.00 | 19,032.00 | 35.59% |
Income Taxes | 19,121.00 | 13,973.00 | 5,148.00 | 36.84% |
Net Income | 53,394.00 | 39,510.00 | 13,884.00 | 35.14% |
Basic Earnings Per share | 9.28 | 6.59 | 2.69 | 40.82% |
Balance Sheet | Vertical Analysis | |||
USD | USD | Common Size Percent | ||
Assets | 2018 | 2017 | 2018 | 2017 |
Cash | 21,120.00 | 13,844.00 | 7.27% | 5.97% |
Marketable Securities | 20,481.00 | 11,233.00 | 7.05% | 4.85% |
Accounts Receivable | 16,849.00 | 17,460.00 | 5.80% | 7.53% |
Inventories | 2,349.00 | 2,111.00 | 0.81% | 0.91% |
Deferred Tax Assets | 5,546.00 | 4,318.00 | 1.91% | 1.86% |
Vendor Non Trade Receivables | 13,494.00 | 9,759.00 | 4.65% | 4.21% |
Other Current Assets | 9,539.00 | 9,806.00 | 3.28% | 4.23% |
Total Current Assets | 89,378.00 | 68,531.00 | 30.77% | 29.56% |
Long Term Securities | 164,065.00 | 130,162.00 | 56.48% | 56.14% |
PP&E | 22,471.00 | 20,624.00 | 7.74% | 8.90% |
Goodwill | 5,116.00 | 4,616.00 | 1.76% | 1.99% |
Intangible Assets | 3,893.00 | 4,142.00 | 1.34% | 1.79% |
Other Assets | 5,556.00 | 3,764.00 | 1.91% | 1.62% |
Total Assets | 290,479.00 | 231,839.00 | 100.00% | 100.00% |
Liabilities | ||||
Accounts Payable | 35,490.00 | 30,196.00 | 12.22% | 13.02% |
Accrued Expense | 25,181.00 | 18,453.00 | 8.67% | 7.96% |
Deferred Revenue | 8,940.00 | 8,491.00 | 3.08% | 3.66% |
Commercial Paper | 8,499.00 | 6,308.00 | 2.93% | 2.72% |
Current Portion- LT Debt | 2,500.00 | - | 0.86% | 0.00% |
Total Current Liabilities | 80,610.00 | 63,448.00 | 27.75% | 27.37% |
Deferred Revenue- Non Current | 3,624.00 | 3,031.00 | 1.25% | 1.31% |
Long Term debt | 53,463.00 | 28,987.00 | 18.41% | 12.50% |
Other Non Current Liabilities | 33,427.00 | 24,826.00 | 11.51% | 10.71% |
Total Liabilities | 171,124.00 | 120,292.00 | 58.91% | 51.89% |
Stockholder's Equity | 0.00% | 0.00% | ||
Common Stock | 27,416.00 | 23,313.00 | 9.44% | 10.06% |
Retained Earnings | 92,284.00 | 87,152.00 | 31.77% | 37.59% |
Accum. OCI | (345.00) | 1,082.00 | -0.12% | 0.47% |
Total Stockholder's Equity | 119,355.00 | 111,547.00 | 41.09% | 48.11% |
Total Liabilities and Equity | 290,479.00 | 231,839.00 | 100.00% | 100.00% |
Income Statement | Vertical Analysis | |||
USD | USD | Common Size Percent | ||
2018 | 2017 | 2018 | 2017 | |
Net Sales | 233,715.00 | 182,795.00 | 100.00% | 100.00% |
Cost of sales | 140,089.00 | 112,258.00 | 59.94% | 61.41% |
Gross Margin | 93,626.00 | 70,537.00 | 40.06% | 38.59% |
Research & Development | 8,067.00 | 6,041.00 | 3.45% | 3.30% |
Selling, General & Administrative | 14,329.00 | 11,993.00 | 6.13% | 6.56% |
Total Operating Expenses | 22,396.00 | 18,034.00 | 9.58% | 9.87% |
Operating Income | 71,230.00 | 52,503.00 | 30.48% | 28.72% |
Other Income | 1,285.00 | 980.00 | 0.55% | 0.54% |
Income before taxes | 72,515.00 | 53,483.00 | 31.03% | 29.26% |
Income Taxes | 19,121.00 | 13,973.00 | 8.18% | 7.64% |
Net Income | 53,394.00 | 39,510.00 | 22.85% | 21.61% |
Help me fill out the yellow collums. also make sure you add the formulas with the...
please answer the yellow colums and please put the answers down below with the formulas make sure you put the explanatation for the answer 16 D FIG 4 Present a comparative balance sheet 2018 2017 Dollar Change Percent Change Assets Cash Marketable securities Accounts receivable Inventories Deferred tax assets Vendor non-trade receivables Other current assets Total current assets Long-term securities 21,120 $ 13,844 20,481 11,233 16,849 17,460 2,349 2,111 5,546 4,318 13,494 9,759 9,539 89,378 68,531 164,065 130,162 22,471 20,624...
Compute the following ratios for 2014 and 2013 using apples financial statements found in Appendix A and attached: Current ratio Quick (or acid-test ratio) Profit margin Return on total assets (ROA) [Sept 29, 2012, total assets equaled $176,064] Price-earnings ratio Stock price – 9/27/14: $100.75 Stock Price – 9/28/13: $68.96 September 27,2014 September 28,2013 ASSETS: Current assets: Cash and cash equivalents Short-term marketable securitics Accounts receivable, less allowances of $86 and $99, respectively 3,844 S 11,233 17,460 13,102 3,453 7,539...
1. assuming that the company makes all sales on accont, compute the amount of cash collected from customers during 2014. 2. compute the cost of inventory (either newly purchases or manufactured) during 2014. Draw Page Layout Formulas Data Review Financial Report - Excel View Help Abu About Search Jo CONSOLIDATED STATEMENTS OF CASH FLOWS (USDS) GRAVIO STAT CIVIC OF CON 12 Months Ended Sep. 27, 2014 Sep. 28, 2013 Sep. 29, 2012 $14,259 $10,746 $9,815 - use... 39,510 37,037 41,733...
Compute the following ratios for 2014 and 2013 using apples financial statements found in Appendix A and attached: Current ratio Quick (or acid-test ratio) Profit margin Return on total assets (ROA) [Sept 29, 2012, total assets equaled $176,064] Price-earnings ratio Stock price – 9/27/14: $100.75 Stock Price – 9/28/13: $68.96 September 27,2014 September 28,2013 ASSETS: Current assets: Cash and cash equivalents Short-term marketable securitics Accounts receivable, less allowances of $86 and $99, respectively 3,844 S 11,233 17,460 13,102 3,453 7,539...
make an analysis of the consolidated statements of operations. are the sales increasing or decreasing? is the net income increasing or decreasing? are the basic earnings per share increasing or decreasing? (also connect with the consolidated statements of shareholder's equity). consider the reasonableness of your answer. CONSOLIDATED STATEMENTS OF OPERATIONS (In millions, except number of shares which are reflected in thousands and per share amounts) Years ended September 24,. September 26, 2015 September 27, 2016 2014 Net sales 215,639 233,715...
please help me out experts ! 1. The comparative statements of Villa Tool Company are presented below: VILLA TOOL COMPANY INCOME STATEMENT For the year ended on December 31 2018 2017 $1,750,000 Net Sales $1.818,500 Cost of Goods Sold S1.011.500 $996.000 Gross Profit $807.000 $754,500 Selling and Administrative Expenses $516,000 $479.000 $291,000 $275,500 Income from Operations Other Expenses and Losses- Interest expense Income before taxes $18.000 $14,000 $273,000 $261,500 $81.000 $77,000 Income tax expense Net Income $192,000 $184,500 VILLA TOOL...
Can someone help me calculate the financial leverage, Debt ratio and also debt-to-equity ratio. please show work. thank you Southwest Airlines Co. Consolidated Statement of Income (in millions, except per share amounts) 2018 Year ended December 31, 2017 As Recast 2016 As Recast $ $ $ OPERATING REVENUES: Passenger Freight Other Total operating revenues 20,455 175 1,335 21,965 19,763 173 1,210 19,068 171 1,050 21,146 20,289 7,649 OPERATING EXPENSES: Salaries, wages, and benefits Fuel and oil Maintenance materials and repairs...
Could some please help me fill out this income statement. Here is the adjusted trial balance, statement of stockholders' equity, and balance sheet. Multiple Step Income Statement For the Year Ended December 31st, 2019 Revenue: Net Revenue Less: Cost of Goods Sold Gross Profit Operating Expenses Total Operating Expenses Operating Income Other Revenue and Expenses Total Other Revenue and Expenses Income Before Income Tax Income Tax Expense Net Income Credit 119113 7500 1800 17280 200 17600 Adjusted Trial Balance December...
Please answer all questions and make answers very clear. Thank you so much and I will make sure to give a good rating!!! Use the information contained in these financial statements and notes to complete this case. All answers should be for the most current year (September 24, 2016) unless asked otherwise. Many companies show amounts in the thousands or millions please state amounts as shown on the financial statements. Do not add zeros. You do not need to include...
locate the largest amount of cash generated by the company's financing activities. identify the transaction that contributes to this particular cash inflow. ( year is 2013) 3.277 1.459 2.824 STATEMENT OF CASH Flows OHSODASIEWS OF CAST 12 Months Ended in Million s de specified Sep 27,2014 Sep 28, 2013 Sep 29, 2012 Cash and cash equivalents, beginning of the $14.259 $10,746 $9,815 Operating activities: Net income 39,510 37,037 41,733 Adjustments to reconcile net income to cash generated by operating activities:...