B D E Open a new Excel spreadsheet and save it as "lastname.firstname.modquiz5" You are a consultant hired to value the equity of the company (your client). The valuation should be sent by email to 2 3 4 5 Forecasted growth in revenues 6.00% 6.00% 6.00% 6 7 Zora Corporation, Inc. Balance Sheet as of December 31 89 9 10 Forecast Forecast Assets: 2019 Today 2017 2,000 10,000 14,000 26,000 2018 2,120 11,000 16,000 29,120 8,144 11,660 16,960 36,764 Forecast 2020 15,439 12,360 17,978 45,776 11 Cash 12 Accounts receivable 13 Inventory 14 Total current assets 15 16 Property, plant and equipment 17 Accumulated depreciation 18 Net property plant & equipment 19 20 Total assets 21 76,000 78,000 80,000 82,200 (24,000) (30,000) (36,000) (42,000) 52,000 48,000 44,000 40,200 $78,000 $77,120 $80,764 $85,976 Assignment NezKendall.ModQuiz5 Ready Type here to search O F G H 21 B D E 22 Liabilities: 23 Accounts payable 24 Salaries payable 15,000 17,000 18,020 19,101 25 Interest payable 1,000 0 0 0 0 0 26 Total current liabilities 0 0 16,000 17,000 27 18,020 19,101 28 Bonds payable 30,000 30,000 34,000 39,000 29 Total liabilities 46,000 47,000 52,020 58,101 30 31 Shareholders' Equity: 32 Common stock 20,000 17,000 14,000 11,000 33 Retained earnings 12,000 13,120 14,744 16,875 34 Total stockholders' equity 32,000 30,120 28,744 27,875 35 36 Total liabilities & stockholders' equity $78,000 $77,120 $80,764 $85,976 37 38 39 Zora Corporation, Inc. 40 Income Statement for 12 months ending December 31 41 Actual Forecast Forecast Forecast Assignment Nez. Kendall.ModQuiz5 + Ready E Type here to search o 43F Calibri General DX Delete Paste BIU - A - $ % 9 623 Format Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells F58 fr F G H A B D E 40 Income Statement for 12 months ending December 31 41 Actual Forecast Forecast Forecast 42 2017 2018 2019 2020 43 Sales $120,000 $127,200 $134,832 44 Cost of good sold 90,000 95,400 101 124 45 Gross margin 30,000 31,800 33,708 46 47 Salaries expense 8,000 8,480 8,989 48 Depreciation expense 6,000 6,000 6,000 49 Other operating expenses 4,000 4,494 50 Income from operations 12,000 13,080 14,225 51 52 Interest expense 1,800 2,040 2,340 53 Net income before taxes 10,200 11,040 11,885 54 55 Income taxes 4,080 4,416 4,754 56 Net Income $6,120 $6,624 $7,131 57 58 Zora Corporation, Inc. 59 Statement of Cash Flows for 12 months ending December 31 60 Today Forecast Forecast Forecast Assignment Nez.Kendall.ModQuiz5 + Lens F78 : for D E F G H B 58 Zora Corporation, Inc. 59 Statement of Cash Flows for 12 months ending December 31 60 Today 61 Cash flows from operations: 2017 62 Net income 63 Plus: depreciation expense 64 Less: increase in accounts receivable 65 Less: increase in inventory 66 Plus: increase in accounts payable 67 Net Cash Flows from Operations 68 69 Cash flows from investing: 70 Purchase of property, plant & equipment (net) 71 Net Cash Flows from Investing 72 73 Cash flows from financing 74 Increases in debt (bonds payable) 75 Issuance of common shares 76 Repurchase of common shares 77 Cash dividends paid 78 Net Cash Flows from Financing Forecast Forecast 2018 2019 $6,120 $6,624 6,000 6,000 (1,000) (660) (2,000) (960) 1,000 1,020 $10,120 $12,024 Forecast 2020 $7,131 6,000 (700) (1,018) 1,081 $12,495 (2.000) (2.000) ($2,000) ($2,000) (2,200) ($2,200) 0 4,000 5,000 0 0 0 (3,000) (3,000) (3,000) (5,000) (5,000) (5,000) ($8,000) ($4,000) ($3,000) Nez.Kendall.ModQuiz5 Assignment