Please help in completing financial statement analysis, if you have any questions, please let me know.

Welcome to the Modified Midterm for Financial Statement Analysis This is one large problem, therefore any information attained in earlier sections and problems can be Please put all answers in the cell provided. You can solve in excel or on paper and then just type the answer in. answer into the cell provided. If you use excel, you can solve anywhere in the excel, just be sure to point t You have until next friday (Sept 16th) to submit this assignment. In grading, there will be no partial credit. Also, the answer must be in the cell provided to coun Thanks! ncial Statement Analysis tions and problems can be used to solve going forward. en just type the answer in. If you use paper, than just type your excel, just be sure to point the cell to the answer using "=". ubmit this assignment. n the cell provided to count towards your score. Interest Income Interest Expense Tax rate Current Share Price Share Price at time of Repurchase Shares Outstanding Non Controlling Interest 2015 Non Controlling Interest 2016 Operating Assets Operating Liabilities Financial Assets Financial Liabilities WACC 100 250 32% $29 $27 290 330 2500 1480 780 1100 9.50% 2015 Equity Balance Net Income Unrealized Gain on Debt investments Foreign Currency Translation Other Comprehensive Income Shares issued on exercise of options including Tax benefits of $240 Repurchase of 38 million shares Increase in non-controlling interest 2016 Equity Balance 5847 1750 25 -230 40 600 -1240 40 6832 Cash From Operations Net income Adjustments from Operating Activities Depreciation Investment Gains / Losses Adjustments from Accounts Receivables Inventory Payables Other Liabilities Net Cash From Operating Activies 1750 200 -165 43 75 -100 130 1933 Cash From Investing Purchase of Property Plant Build out Equipment Investments Sale of marketable securities Interest bearing loan Gains from selling land Net Cash From Investing Activies -150 -200 -400 540 -1000 400 -810 1 After Tax Loss on Options 2 3 4 Beginning Equity Options Exercise Repurchase Deal Net Transactions wit Shareholders 5 6 7 8 Net Income Other Comprehensive Gain/Loss on Options Gain/Loss on Repurchase Comprehensive Income 9 Ending Equity 10 11 Adjusted CFO Adjusted CFI 12 Free Cash Flow 13 Payment to Debt Holders 14 15 16 Net Operating Assets Net Financial Obligations Common Shareholder Equity 17 18 After Tax Net Financial Expense/Income Operating Income 19 Return on Net Operating Assets 20 Residual Operating Income 21 22 Present Value of ReOI Total Value of Firm wit Shareholders Equity Statement Cash Flow Stateme Balance Sheet Income Statement Profitability Valuation ity Statement h Flow Statement ance Sheet ome Statement fitability