Question

In: Accounting

Income Statement (vertical) report with a run date of 12/31/-. Provide a narrative analysis of this...

Income Statement (vertical) report with a run date of 12/31/-. Provide a narrative analysis of this report in a manner similar to that done in the chapter. Use your own words based on the information provided in this report.

Casey Corporation
Income Stmt. Vertical Analysis
For Years Ended 12/31/17 and 12/31/18
Current Current Previous Previous
Amount Percent Amount Percent
Operating Revenue
Sales 869,695.50 101.91 836,490.00 101.16
Sales Returns & Allow. -9,150.00 -1.07 -6,000.00 -0.73
Sales Discounts -7,154.01 -0.84 -3,595.00 -0.43
------------- ------------- ------------- ----------
Total Operating Revenue 853,391.49 100 826,895.00 100
Cost
Cost of Merchandise Sold 592,660.00 69.45 593,255.00 71.74
------------- ------------- ------------- ----------
Total Cost 592,660.00 69.45 593,255.00 71.74
------------- ------------- ------------- ----------
Gross Profit 260,731.49 30.55 233,640.00 28.26
Operating Expenses
Sales Salaries Expense 74,368.94 8.71 63,873.10 7.72
Advertising Expense 13,750.00 1.61 11,500.00 1.39
Depr. Exp. Store Eqpt. 3,935.00 0.46 2,960.00 0.36
Insurance Expense Selling 4,595.00 0.54 3,350.00 0.41
Store Supplies Expense 820.32 0.1 1,729.30 0.21
Misc. Selling Expense 850 0.1 1,525.00 0.18
------------- ------------- ------------- ----------
Selling Expenses 98,319.26 11.52 84,937.40 10.27
Office Salaries Expense 20,386.61 2.39 20,377.00 2.46
Utilities Expense 8,991.47 1.05 8,776.72 1.06
Depr. Exp. Building 19,000.00 2.23 17,000.00 2.06
Depr. Exp. Office Eqpt. 2,020.00 0.24 1,135.00 0.14
Insurance Expense General 2,500.00 0.29 1,800.00 0.22
Office Supplies Expense 1,503.74 0.18 613.4 0.07
Misc. General Expense 400 0.05 415 0.05
------------- ------------- ------------- ----------
Administrative Expenses 54,801.82 6.42 50,117.12 6.06
------------- ------------- ------------- ----------
Total Operating Expenses 153,121.08 17.94 135,054.52 16.33
------------- ------------- ------------- ----------
Net Income from Operations 107,610.41 12.61 98,585.48 11.92
Other Revenue
Interest Income 815.5 0.1 1,833.00 0.22
Gain on Sale Office Eqpt. 130 0.02
Gain on Sale Store Eqpt. 65 0.01
Other Expense
Interest Expense 10,779.80 1.26 6,211.14 0.75
------------- ------------- ------------- ----------
Net Income before Income Tax 97,711.11 11.45 94,337.34 11.41
Income Tax
Corporate Income Tax 26,800.00 3.14 24,872.00 3.01
------------- ------------- ------------- ----------
Net Income after Income Tax 70,911.11 8.31 69,465.34 8.4
============= ============= ============= ==========

Solutions

Expert Solution

1.Sales Revenue has benn increased by 0.75%, however Gross profit ratio increased by 2.29% which shows Casey Corporation has reduce their cost, which is good sign for the orgnization.

2.Total operating cost has been increased by 1.61% as compare to previous year, however Net profit also increased by 0.69% that means orgnization is on growth stage.

3.Non opearting Income means other income has decreased by 0.01% that means organization has not dependent on non opearting Income.

4.Interset expenses increased by 0.51% as compare to previous year which shows company has taken loan from outrside.

5.This is common theory if you are earning more you have to pay more to government, here orgnization is earning higher net profit hence they have to pay higher amount of tax to government.

6.Since Casey corporation is paying higher taxes, hence it is impact to companies profit after tax ratio which is decreased by 0.09%.

7.In this year company has sale their equipment, taken loan from outside & take back their advance loan given to others beacuse of this companies interses income reduced.


Related Solutions

Problem 9-A F) Statement of Cash Flows report with a run date of 12/31/-. Provide a...
Problem 9-A F) Statement of Cash Flows report with a run date of 12/31/-. Provide a narrative analyisis of this report. Mike Bokman Casey Corporation Statement of Cash Flows For Year Ended 12/31/18 Cash Flows from Operating Activities Notes Receivable 50,382.00 Accounts Receivable 588,700.50 Merchandise Inventory 84,500.00 Notes Payable 14,500.00 Sales 121,995.00 Sales Discounts -7,154.01 Cost of Merchandise Sold -84,500.00 Interest Income 843 -------------- Total Cash Received 769,266.49 Merchandise Inventory -4,242.00 Store Supplies 2,115.32 Office Supplies 1,173.24 Prepaid Insurance 5,250.00...
How would you do vertical analysis of an income statement? Of a balance sheet? Provide a...
How would you do vertical analysis of an income statement? Of a balance sheet? Provide a specific example as part of you explanation.
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Calvin Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $92,316 $104,544 Event-related revenue 135,648 131,648 NASCAR broadcasting revenue 179,922 170,368 Other operating revenue 63,114 77,440 Total revenue $471,000 $484,000 Expenses and other: Direct expense of...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Calvin Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $94,400 $107,580 Event-related revenue 138,768 147,189 NASCAR broadcasting revenue 169,448 160,881 Other operating revenue 69,384 73,350 Total revenue $472,000 $489,000 Expenses and other: Direct expense of...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Motor Speedways Inc., owner and operator of several major motor speedways. Current Year Previous Year Revenues: Admissions $89,870 $102,690 Event-related revenue 145,684 147,189 NASCAR broadcasting revenue 170,753 161,859 Other operating revenue 66,693 77,262 Total revenues $473,000 $489,000 Expenses and other: Direct expense of events $97,911 $97,800 NASCAR purse and sanction fees 116,358 117,849...
1. Using Walt Disney Inc. Annual Report income statement, prepare a horizontal and vertical analysis on...
1. Using Walt Disney Inc. Annual Report income statement, prepare a horizontal and vertical analysis on years 2017 and 2016. 2. Perform the following ratios, Current, Debt, Return on Equity on years 2017 and 2016 https://www.thewaltdisneycompany.com/wp-content/uploads/2017-Annual-Report.pdf Return on common stockholders’ equity ratio. Return on asset ratio. Profit margin rate. Earnings per share. Debt to total asset ratio. Current ratio Average collection period. Receivables turnover ratio. Asset turnover ratio.
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for two...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for two recent fiscal years was adapted from the annual report of Speedway Motorsports, Inc. (TRK), owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $90,639 $100,694 Event-related revenue 136,900 146,980 NASCAR broadcasting revenue 224,227 217,469 Other operating revenue 60,390 31,320 Total revenues $512,156 $496,463 Expenses and other: Direct expense of...
Carolina Products Income Statement Years Ended 12/31/2016 & 12/31/2015 Horizontal Analysis 2016 2015 $ Change %...
Carolina Products Income Statement Years Ended 12/31/2016 & 12/31/2015 Horizontal Analysis 2016 2015 $ Change % Change Sales $272,500 $270,010 Cost of Goods Sold $157,472 $154,589 Gross Profit $115,028 $115,421 Operating Expenses: Selling Expense $49,675 $48,500 Salary Expense $30,000 $28,000 Administrative Expense $15,500 $15,400 Advertising Expense $3,400 $3,200 Utilities Exp $1,100 $1,000 Depreciation Exp $1,620 $1,450 Total Operating Expenses $101,295 $97,550 Net Income $13,733 $17,871
1. Prepare a vertical analysis on the income statement and Balance statement. (Please show the formula...
1. Prepare a vertical analysis on the income statement and Balance statement. (Please show the formula & your calculations). Balance Sheet December 31, 20X7 & 20X6 Assets 20X7 20X6 Cash $ 15,000   17,000 Marketable securities 10,000 10,000 Accounts receivable (net) 20,000 22,000 Inventory 30,000 27,000 Prepaid expenses 8,000 9,000 Property, plant, and equipment 117,000 117,000 Total assets $200,000 202,000 Liabilities and Stockholders' Equity Current liabilities $ 30,000 27,000 Long-term liabilities 61,000 56,000 Stockholders' equity 109,000 119,000 Total liabilities and stockholders'...
Using the income statement, calculate the vertical and horizontal analysis and insert your answers in the...
Using the income statement, calculate the vertical and horizontal analysis and insert your answers in the appropriate spaces provided VERTICAL ANALYSIS HORIZONTAL ANALYSIS Statement of Operations Income Statement 2017 Percent 2018 percent CHANGE PERCENT Sales (net) 8,100,000 10,000,000 Cost of goods sold 5,300,000 6,000,000 Gross Margin 2,800,000 4,000,000 General Expense (1,050,000.00) (1,080,000) Depreciation Expense (300,000.00) (300,000) Operating Income 1,450,000.00 2,620,000 Interest Expense (40,000.00) (50,000) Income Taxes (35%) (507,500.00) (917,000.00) Net Income 902,500.00 1,653,000
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT