Assignment Instruction You are the CFO of Miller Co. You need to predict your company's financial statements in order to make financing plans for funding shortage. The company has experienced high growth over the last 5 years and now start to slow down. Annual sales in 2020 are expected to be $3.15 billion, a 5% increase of year 2019. The firm's operating costs (including cost of goods sold and the other operating costs) will grow at the same pace with sales. All assets and accounts payables and accruals will grow at the same pace with sales. 60% of net income will be paid as dividend. Tax rate is 40%. Given its current financial statements below, you are asked to (1) Construct its Pro Forma income statement in 2020 using sales percentage method; (2) Construct its Pro Forma Balance Sheet in 2020; (3) Given these pro forma statements, find whether the company will have sufficient funding to support its current operation, or have funding gap needed to fill; (4) If the company has funding gap, what possible actions do you suggest the company to make to get needed financing. (Note: this part is an open question with no standard answer. Use what you have learned in the chapter along with your intuition to answer this part of the assignment) 2019 Balance Sheet (Millions of $) Cash Accounts receivable Inventories Total CA Fixed assets 80.00 Accounts payables 150.00 Notes payables 200.00 Accruals 430.00 Total CL 700.00 Long-term debt Common stock Retained Earnings 1,130.00 Total liabilities and equity 70.00 120.00 55.00 245.00 170.00 440.00 275.00 1,130.00 Total assets 2019 Income Statements (Millions of S) Sales Cost of Goods Sold Other Operating Costs EBIT Interest EBT Taxes(40%) Net Income Dividends 3,000.00 1,500.00 1,000.00 500.00 90.00 410.00 164.00 246.00 147.60 Add to Retained Earnings 98.40 Submission requirement: Use Microsoft Excel file to conduct all the calculations. For each calculation, type in the calculation formula and let Excel do the calculation. (Check the video lecture to see how to do calculation in Excel) You MUST show your work using excel formula to earn credit! (if you used excel to calculate each number and save the file properly, the formula should be embedded in each excel cell. Double check that before submission) Answer questions 3 and 4 on a separate spreadsheet in the same Excel file Submit your file to Dropbox prior to deadline Assignment Instruction You are the CFO of Miller Co. You need to predict your company's financial statements in order to make financing plans for funding shortage. The company has experienced high growth over the last 5 years and now start to slow down. Annual sales in 2020 are expected to be $3.15 billion, a 5% increase of year 2019. The firm's operating costs (including cost of goods sold and the other operating costs) will grow at the same pace with sales. All assets and accounts payables and accruals will grow at the same pace with sales. 60% of net income will be paid as dividend. Tax rate is 40%. Given its current financial statements below, you are asked to (1) Construct its Pro Forma income statement in 2020 using sales percentage method; (2) Construct its Pro Forma Balance Sheet in 2020; (3) Given these pro forma statements, find whether the company will have sufficient funding to support its current operation, or have funding gap needed to fill; (4) If the company has funding gap, what possible actions do you suggest the company to make to get needed financing. (Note: this part is an open question with no standard answer. Use what you have learned in the chapter along with your intuition to answer this part of the assignment) 2019 Balance Sheet (Millions of $) Cash Accounts receivable Inventories Total CA Fixed assets 80.00 Accounts payables 150.00 Notes payables 200.00 Accruals 430.00 Total CL 700.00 Long-term debt Common stock Retained Earnings 1,130.00 Total liabilities and equity 70.00 120.00 55.00 245.00 170.00 440.00 275.00 1,130.00 Total assets 2019 Income Statements (Millions of S) Sales Cost of Goods Sold Other Operating Costs EBIT Interest EBT Taxes(40%) Net Income Dividends 3,000.00 1,500.00 1,000.00 500.00 90.00 410.00 164.00 246.00 147.60 Add to Retained Earnings 98.40 Submission requirement: Use Microsoft Excel file to conduct all the calculations. For each calculation, type in the calculation formula and let Excel do the calculation. (Check the video lecture to see how to do calculation in Excel) You MUST show your work using excel formula to earn credit! (if you used excel to calculate each number and save the file properly, the formula should be embedded in each excel cell. Double check that before submission) Answer questions 3 and 4 on a separate spreadsheet in the same Excel file Submit your file to Dropbox prior to deadline