Please see question on top of the tables attached.

Gb699 Decision Making Model Enter formulas in the below cells. Afirm reported the financial data for one year. Prepare the balance sheet and income statement Complete the cash flow calculations. Column B Column C Column D ColumnE Row 10 Column A 10 Reported Data Cash Other assets Debt Capital Revenues Expenses Interest Taxes Dividends, percent of income Jan-17Dec-17 10700 37768 521000519000 11000 14000 520700542768 609950 544000 9975 20% 40% 12 13 14 15 12 13 14 15 16 17 18 19 20 21 17 18 19 20 21 Balance sheet Cash Other assets Total assets Debt Capital Liabilities & equity Jan-17 Dec-17 23 24 25 23 24 25 26 27 28 29 30 31 32 27 28 29 30 Income Statement Revenues Expenses X Gb699-Fin2 Wrk.xlsx 32 Expenses Operating income Interest Pre-taxearnings Taxes Net income Dividends 34 35 36 37 38 39 40 41 42 43 35 37 38 39 40 41 42 43 Cash Flow Cash low from operations Net income Less dividends Changes in balance sheet accounts Change in other assets Change in debt Expected change in cash 45 46 47 47 49 Check to be sure it is correct Starting cash Ending cash Actual Change in cash 49 50 51 52 53 54 52 53 Present Value Exercise What is the following asset's net present value? What is the internal rate of return on the investment? 57 58 59 60 61 62 56 57 58 Year 0 Year 1Year 2 Year 3 59 60 20000 2500030000 61 70000 62 Net Present Value Calculation NCO Annual Cash Residual Cash -100000 20 Open X Gb699_Fin2_Wirk.xlsx 52 53 54 Actual Change in cash 53 Present Value Exercise What is the following assets net present value? What is the internal rate of return on the investment? 56 57 58 59 60 61 56 57 58 Year 0 Year 1Year 2 Year 3 59 60 20000 25000 30000 61 70000 62 12% 63 15% 64 2.68 65 Net Present Value Calculation NCO -100000 Annual Cash Residual Cash Required Rtn Cash Flow Req Rtn, Residual PV Mid-year Factors Present Values PV Residual 63 12% 12% 0.57 1.62 67 68 69 70 67 68 69 70 71 Year 3 72 73 74 75 76 Formula: FIRISTVYN = PV Internal Rate of Return Calculation Year 0 Year 1Year 2 NCO 74 75 76 Annual Cash Residual Cash Discount Factor to Zero NPV Trial/Error, Try PV Md-year Factors Annual Cash Residual Cash NPV IRR Formula: FV(1+STVN PV 78 268 78 79 0.57 1 62 80 81 82 83 81 82 83