percent. 5:57Please respond as soon as you reasonably can. Eahibit 5. Recent Financial Statements Kangaroo Tail Winery Limited Bulance Sheet (in S thousanda Year Year Cart a Ca 1940 Accouns Receivable 1200 22210 Inventory Toal curent ae 1270 Property and Eipuipment Egipmen Buikdings 25 Accumulated depreciation Property and Equipment, net Land latangibles Toeal e RAS 15000 16 2000 50.590 Cament liabilitien Accounts payable Taes payable Netes payable- cue 420 Toeal current liabilities 5.570 Notes payuble 17.500 19000 Sulden eity Commen sock Reained caning Seackholden equiry Liabiliies and skden' oquity 23000 6735 Eshibir 5. Recene Fnancial Satements (omt) Kangan TaWiery la Income Sutemem inSnd Reven he ye 22. Windlai Seling and gmel adin Depeciaion e Tnl pering mp Opeing pd Income beore inme e Na ine King Ta Wy land Sutomen of Reainad taring as denda de yar endad Reainel ing- beginningf e yr Ne i Dvidend Rensined cming - mdof the yr CASH FLOW STATEMENT CASH FLOW FROM OPERATING ACTIVITIES 20KI 5,40 Net Income Add Back Non-Cash Items Depreciation 1,650 Amortization Changes in Working Capital Accounts Receivable 4,230 6,570 Inventory Accounts Payable Net Cash Provided by Operating Activities CASH FLOW FROMINVESTINGACTIVITIES Capital Exp, - Purchase of PPS E 3,400 Retined tarp Rnained eing giningd e yr 5:5 Ne ine Dvid Reained eingmdd de p CASH FLOW STATEMENT CASH FLOW FROM OPERATING ACTIVITIES 54G0 Net Income Add Back Non-Cash tems Depreciation 1650 Amortization 500 Changes in Working Capital Accounts Receivable 4230 6570 Inventory Accounts Payable 3400 210 Net Cash Provided by Operating Activities CASH FLOW FROM INVESTING ACTIVITIES Capital Exp. - Purchase of PPS E Net Cash Used in Investing Activities CASH FLOW FROM FINANCING ACTIVITIES Net Cash Provided by (Used in) FIN Acitivities Net Cash Flow Beginning Cash Balance Ending Cash Balance INCOME STATEMENT 20X1 Revenue Growth (N) 22,230 N/A Cost of Goods Sold % of Sales 7,200 Gross Profit 15,030 % of Sales Operating Expenses (SG&A) % of Sales 5,770 Depreciation Amortization Operating Profit (EBIT) 1650 50 7,110 Interest Expense 1091 Pretax Income (EBT) 6,019 Income Tax Expense Tax Rate 560 N/A Net Income 5,459 Operating income (EBIT) Depreciation Amortization 7,110 1650 500 EBITDA 9,260 Question 1 5 pts The Kangaroo Tail Winery Cash Flow Statement for Year 1 will start with and add back non cash items and in the Operating Cash flow section. Gross Profit, Cost of Sales, Amortization Gross Profit, Interest, Taxes Net Income, Wages, Dividends Net Income, Depreciation, Amortization Question 2 5 pts The Kangaroo Tail Operating Cash flow includes increases of balance sheet as uses of cash in the Operating Cash Flow section. and from the Goodwill, Cash Shareholder's Equity, Accounts Payable Property, Debt Accounts Receivable, Inventory Question 3 5 pts The Kangaroo Tail Operating Cash flow includes increases of and from the balance sheet as soruces of cash in the Operating Cash Flow section. Shareholder's Equity, Intangiles Accounts Payable, Taxes Payable Property, Debt Accounts Receivable, Inventory 5 pts Question 4 The Kangaroo Tail's Cash Flow from Operations in Year 1 was 4,510 9,440 7,610 5,460 Question 5 5 pts Changes in Kangaroo Tail's property plant and equipment and land between Year 0 and Year 1 are section of the Cash Flow Statement. reflected in the Operating Investing Financing None of these 5 pts Question 6 of cash in the The Kangaroo Tail's increase in common stock on the balance sheet is a financing section, and total cash flow from financing in Year 1 was use, 4,510 source, 6,450 source, 4,510 use, 6,450 Question 7 5 pts The Kangaroo Tail's Cash from Investing was a use of cash of 6,450 9,440 4,510 None of these Question 8 5 pts Which of the following is true about Kangaroo Tail's capital investments based on the Year 1 Cash Flow Statement? Operating cash flow is sufficient to fund all of the capital expenditures Operating cash flow is not sufficient to fund all of the capital expenditures and debt or equity financing is needed The capital expenditures decrease assets on balance sheet Capital expenditures are below the maintenance level Question 9 5 pts Kangaroo Winery's change in cash from Year 0 to Year 1 was 1,520 5,460 None of these 3,460 Question 10 5 pts The Kangaroo Tail's Dividends of 3,260 appear as a use of cash in the section of the Cash flow statement. Operating Financing Investing None of these Question 11 5 pts Project the Income Statement of Kangaroo Tail using the assumptions in the Quiz Instructions. Your Revenue in Year 3 is 5,733 None of these 23,575 23,342 Question 12 5 pts Project the Income Statement of Kangaroo Tail using the assumptions in the Quiz Instructions. Your Gross Profit in Year 2 is 15,782 23,342 7,466 15,939 Question 13 5 pts Project the Income Statement of Kangaroo Tail using the assumptions in the Quiz Instructions. Your Operating Profit Margin in Year 2 is 16% 32% 5% None of these Question 14 5 pts Project the Income Statement of Kangaroo Tail using the assumptions in the Quiz Instructions. The Operating Expense with the highest margin (largest % of Revenue) is Amortization Depreciation Wages SG&A Question 15 5 pts Project the Income Statement of Kangaroo Tail using the assumptions in the Quiz Instructions. Your Net Income in Year 3 is 6,384 None of these 7,540 5,790 Question 16 5 pts In order to show numerical cells with a $ in excel, the procedure is to: highlight the cell, right click on the mouse, and select Format Cells from the menu highlight the cell, click on the Insert tab in the excel menu bar, and click on Charts highlight the cell, click on the Formulas tab in the excel menu bar, and click on Trace Dependents none of these Question 17 5 pts In order to copy and paste a formula across multiple columns in excel, you can: highlight the cell and the cells to the right, depress the control key, and hit the r key highlight the cell, click on the Formulas tab in the excel menu, and click on Trace Precedents highlight the cell, right click on the mouse, and select Insert from the menu all of these 5 pts Question 18 A sparkline chart in excel is: a radar chart a pie chart a line chart all of these Question 19 5 pts Which of the following is a correct formula to calculate revenue growth rate in excel? = sum (the cell with Year 1 Revenue: the sell with Cost of Goods Sold) = Year 1 Revenue/ Cost of Goods Sold none of these (Year 2 Revenue - Year 1 Revenue) / Year 1 Revenue %3D Question 20 5 pts N Which of the following is the correct formula for gross margin calculation in excel? = Operating Income + SG&A (Revenue - Cost of Goods Sold)/ Revenue none of these = (Earnings Before Taxes - Taxes)