PROBLEM 14-14. Horizontal Analysis [LO 1] Refer to the financial data for Bao Corporation in Problem 14-13. Using these financial statements, complete the following steps. REQUIRED a. Prepare a horizontal analysis for the balance sheet. b. Prepare a horizontal analysis for the income statement c. Comment on the results of any significant findings. d. What types of issues does the company seem to be facing? e. What suggestions do you have for the Bao Corporation? PROBLEM 14-13. Common-Size Financial Statements [LO 1] The financial statements for the Bao Corporation are given below: Bao Corporation Comparative Balance Sheets December 31, 2018, and 2017 2018 2017 $ $ 1,900 9,100 11,300 560 22,860 1,300 7,300 9,100 250 17,950 86,000 48,600 134,600 $157,460 86,000 52,000 138,000 $155,950 Assets Current assets: Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Property and equipment: Land Buildings and equipment, net Total property and equipment Total assets Liabilities and Stockholders' Equity Current liabilities: Accounts payable Accrued expenses Notes payable, short term Total current liabilities Long-term liabilities: Bonds payable Notes payable Total liabilities Stockholders' equity: Common stock Additional paid-in capital Total paid-in capital Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ 17,600 1,620 $ 21,000 4,430 220 25,650 540 19,760 5,300 34,400 59,460 5,300 35,000 65,950 11,000 19,000 30,000 68,000 98,000 $157,460 11,000 19,000 30,000 60,000 90,000 $155,950 Bao Corporation Comparative Income Statement For the Years Ended December 31, 2018, and 2017 2018 2017 $130,000 67,000 63,000 $111,000 61,000 50,000 Sales Cost of goods sold Gross margin Operating expenses: Selling expenses Administrative expenses Total operating expenses Income from operations Interest expense Income before taxes Less income taxes Net income 24,500 17,500 42,000 21,000 5,600 15,400 6,160 9,240 20,000 14,600 34,600 15,400 4,700 10,700 4,280 6,420 $ $ REQUIRED a. Present the balance sheet with each account balance as a percent of total assets. b. Present the income statement with each balance as a percent of sales. c. Comment on the results of any significant findings. d. What types of issues does the company seem to be facing? e. What suggestions do you have for the Bao Corporation