The following information was taken from the accounting records of Prentice Company for the years ended April 30:

Required:
Use a computer spreadsheet to do the following:
A. Complete a vertical analysis for 2010, 2009, and 2008.
B. Complete a horizontal analysis for 2010 and 2009.
C. Complete a ratio analysis for 2010 and 2009.

Transcribed Image Text:

2010 2009 Current assets: Cash Trading securities Accounts receivable Inventories Prepaid expenses $ 35,000 12,000 175,000 225,000 5,000 452,000 $ 38,000 11,000 166,000 209,000 10,000 $ 434,000 $ 10,000 62,000 112,000 269,000 4,000 S 457,000 Total current assets Property, plant, and equipment $ 50,000 141,000 68,000 Total property, plant and ent 259,000 $ 711,000 S 50,000 149,000 74,000 273,000 707,000 $ 50,000 157,000 72,000 279,000 736,000 Land Building, netof depreciation Equipment, net of depreciation Total assets Current liabilities $ 69,000 40,000 52000 $ 161,000 88,000 $ 249,000 462,000 711,000 $ 60,000 60,000 19,000 $ 139,000 161,000 300,000 436000 S 736,000 Accounts payable $ 67,000 60,000 41,000 $ 168,000 92,000 $ 260,000 447,000 $ 707000 $2,085,000 1,209,000 S 876,000 731,000 145,000 Notes payable Other current liabilities Total current liabilities Long-term liabilities Total liabilities Owners' equity Total liabilities and owners' equity Sales Cost of goods sold Gross margin Operating expenses Net income $1,920,000 1.152,000 $ 768,000 698,000 70,000 $1,880,000 1,110,000 770,000 688,000 $ 82,000