Lawrence, Korman, and Conway dissolved their partnership and re-formed as Coopie Awards Inc. You are asked to complete financial statement analysis for the company. 2 Required: Complete the purple cells for horizontal and vertical analysis for Coopic Awards using the following formulas: Vertical Analysis: (Financial Statement item/base amount), where your base amount is Total Revenue for the income statement and Total Assets for the balance sheet. Horizontal Analysis: (Current year-base year)/base year 4 5 Then, complete the purple cells in the financial ratios below. 6 Coopie Awards Inc. Income Statement (in 000) 9 Sales Revenue 10 Product Cast of Goods Sold 11 Total Gross Margin 12 Selling, Marketing and Administrative Expenses 13 karnings from Operations 14 Interest Expense 15 Income Taxes 16 Net Faming 17 EP.S. 18 19 20 Balance Sheet (in 000) 21 (Cash and Cash Equivalents 22 Accounts Receivable 23 Inventory 24 Total Current Assets 25 Property, Plant and Fquipment net of $1250, $1100, and $990 accumulated depreciation 76 Intangibles 27 Total Assets 28 Accounts Payable 29 Accrued Liabilities 30 Total Current Liabilities 31 Total Noncurent Liabilities Total liabilities 33 Common Stock 34 Retained Larmings 35 Total Equity 36 Total liabilities and Shareholders Equity 3T Year 1 Year 2 Year 3 (base) Vertical Analysis Year 1 Vertical Analysis Year 2 Vertical Analysis Horizontal Analysis Year 3 Year 3 to 1 1,000 995 1.200 100.00% 100.00% 100.00% 400 398 117 10.00% 40.00% 34.00% 630 597 THE 60.0% 60.00% 06.00% 418 400 426 42.00% 40.00% 35.00% 187 197 352 18.00% 20.00% 30.00% 7.1% 1.00% 1.00% 15 8 67 60 63 7.00% 4.00% 6.00% 100 129 28/ 10.00% 13.00% 24.00% 0.100 0.129 0.287 0.00% 0.00% 0.00% Year 1 Year 2 Year 3 (base) 1,200 1,000 1,430 700 098 751 328 300 315 2,228 3058 2,547 3,000 3,060 3,180 20 20 20 5,248 5,138 5,747 110 122 127 00 100 78 1/0 232 205 3,000 3,000 3,700 3,170 3,232 3,905 1,000 1,000 1,000 1,078 900 B12 2,026 1,500 1.PM> 5,048 5,138 5.747 Vertical Analysis Year 1 Vertical Analysis Vertical Analysis Horizontal Analysis Year 2 Year 3 Year 3 to 1 23.00% 19.00% 26.00% 13.00% 14.00% 13.00% 5.00% 100% 5.00% 12.00% 10.00% 44.00% + 57.00% 60.00% 55.00% 0.00% 0.00% 0.00% 0.00% 100.00% 100.00% 100.00%