1. The most recent balance sheet and income statement for JPX for 2018 is provided in the attached spreadsheet (sheet Q1). The target sales growth rate for 2019 is 15%. Interest expense, tax rate, and dividend payout are expected to remain constant. Further, operating costs, depreciation, current assets, net fixed assets, and accounts payable are expected to increase spontaneously with sales. Assume the firm is operating at full capacity. a) Using the formula approach, estimate the EFN for 2019 b) Using percent sales method, project balance sheet and income statement for 2019 and estimate the EFN c) Estimate the sustainable growth rate and internal growth rate based on 2018 financial statements 2. The Income Statement and Balance Sheet for 2017 and 2018 for XYZ Inc. are provided in the attached Excel spreadsheet (sheet Q2). a) Using the information provided, construct the firm's accounting statement of cash flows for 2018. Specifically, estimate the cash flow from operations, cash flow from investing funninn nntivities and the net change in cash. 4 Assumptions 2 Sales Growth 3 Tax Rate 15.00% 20% DI UN Projected 2019 7 Income Statement 3 Sales 9 Operating Costs 10 Depreciation 11 Operating Income-EBIT 12 Interest Expense 13. Earnings before Taxes 14 Taxes 15 Net Income 16 Dvidends 17 Actual 2018 S 1,050,000 $ 900,000 S 70,000 80.000 20,000 60,000 $ 12,000 S 48,000 14.400 18 19 R $ $ $ $ $ 2018 2018 25,000 55.000 90.000 170,000 500,000 670,000 + 20 Balance Sheet 21 Assets 22 Cash 23 Acc Receivable 24 Inventory 25 Total Current Assets 26 Net Fixed Assets 27 Total Assets 28 29 Liab + Shareholder Equity 30 Accounts Payable 31 Total Current Liab 32 Long Term Debt 33 Common Stock 34 Retained Earnings 35 Total Stockholder Equity 36 Total Liab +SE 37 38 39 EFN- Formula Approach EFN- Financial Forecasting 40 Statement Approach 41 Internal Growth Rate 42 Sustainable Growth Rates 100,000 200,000 210,000 160,000 370,000 670,000