Instructions:

1. Create a horizontal analysis of the Income Statement in a new Excel spreadsheet.

2. Create a vertical analysis of the Balance Sheet for 2016 and 2015. Please use the same

spreadsheet you created in Instruction 1. Y

ou can either put this on a new tab of the

spreadsheet, or you can put it below the Income Statement.

3. Compute the following ratios using the data on both the Income Statement and the Balance

Sheet. These should also be on the same Excel spreadsheet e

ither on a new tab, or listed below

the statements.

a. Current ratio

b. Inventory turnover

c. Days sales in inventory

d. Accounts receivable turnover

e. Days sales in receivables

f. Gross profit percentage

4. Write a short summary of how this compa

ny improved or did not improve from 2015 to

2016. Please use information from the horizontal analysis, vertical analysis, and ratio an

alysis

to support your opinion. This should be done on the same Excel spreadsheet.

5. Save your spreadsheet as Module 3

assessment followed by your last name (Module 3

assessment Pace)

6. Attach the file to the Learning Assessment submission page.

Instructions:

Market price of Tylers common stock:$84.32 at dec 31st 2016. And $51.75 at December 31, 2015. Common shares outstanding 10,000 during 2016 and 9000 during 2014 and 2015. All sales on credit

1. Create a horizontal analysis of the Income Statement in a new Excel spreadsheet.

2. Create a vertical analysis of the Balance Sheet for 2016 and 2015. Please use the same

spreadsheet you created in Instruction 1. Y

ou can either put this on a new tab of the

spreadsheet, or you can put it below the Income Statement.

3. Compute the following ratios using the data on both the Income Statement and the Balance

Sheet. These should also be on the same Excel spreadsheet e

ither on a new tab, or listed below

the statements.

a. Current ratio

b. Inventory turnover

c. Days sales in inventory

d. Accounts receivable turnover

e. Days sales in receivables

f. Gross profit percentage

4. Write a short summary of how this compa

ny improved or did not improve from 2015 to

2016. Please use information from the horizontal analysis, vertical analysis, and ratio an

alysis

to support your opinion. This should be done on the same Excel spreadsheet.

Comparative financial statement data of Tyler, Inc. follow: Tyler, Inc Comparative Income Statement Years Ended December 31, 2016 and 2015 2015 Net Sales $450,000 Cost of Goods Sold 227,000 Grow Profit 222.000 Operating Expenses 137.000 Income from Operations 25,000 Interest Expense 12.000 Income before income 73.000 Income Tape 19,000 Net income 5 54.000 2015 5424,000 215.000 200.000 135,000 74000 14.000 50.000 25.000 $ 35,000 2016 2014 Tyler, Inc. Comparative Income Statement Years Ended December 31, 2016 and 2015 2015 Assets Curent Cash $99.000 $6.000 Accounts Receivable et 110.000 116.000 Merchandise nentory 145.000 16.000 Prepaid Expenses 12.000 7.000 Total Current 366.000 380,000 Property, Pant and copment, et 219.000 180.000 Totalt $ 505.000 5562.000 $ 105,000 210.000 598.000 Liabilities Total Current Long term Total be $223,000 120.000 343.000 5246,000 95.000 341,000 Stockholders' Equity Putered Stod. 3 Common Stockholders' Equity, no Tot Liabilities and Stockholders outy 98.000 144.000 5 585.000 98.000 120.000 5562,000 0.000 Selected 2014 amounts 1. Market price of Tyler's common stock: $84.32 at December 31, 2016, and $51.75 at December 31, 2015. 2. Common shares outstanding: 10,000 during 2016 and 9,000 during 2015 and 2014. 3. All sales are on credit. Comparative financial statement data of Tyler, Inc. follow: Tyler, Inc. Comparative Income Statement Years Ended December 11, 2016 and 2015 2016 2015 Net Sales $499,000 1.224.000 Cost of Goods Sold 237,000 215.000 Gross Profit 222.000 209,000 Operating perses 137,000 135.000 Income from Operations 85.000 74.000 Interest Expense 12,000 14.000 Income Before Income Tax 73,000 60.000 Income Tax Expense 19,000 25.000 Net Income $ 54,000 5 35.000 Tyler, Inc. Comparative Income Statement Years Ended December 31, 2016 and 2015 2016 2015 2014 Assets Current Assets: Cash Accounts Receivable, Net Merchandise Inventory Prepaid Expenses Total Current Assets Property, Piant, and Equpment, Net Total Assets $ 101.000 210,000 599.000 110,000 145.000 12.000 366,000 219.000 5 585,000 $ 96,000 115,000 163,000 7.000 382,000 180,000 $ 562,000 598.000 Liabilities Total Current Liabilities Long-term Liabilities Total abilities 5 223,000 120,000 343,000 $ 245,000 95,000 341.000 Stockholders' Equity Preferred Stock, 3% Common Stockholders' Equity, no par Total Liabilities and Stockholders' Equity 98,000 144,000 S 585,000 98,000 123,000 5562,000 85,000