The following is cash flow data for Rocket Transport: Cash dividend Purchase of bus Interest paid on debt Sales of old equipment Repurchase of stock Cash payments to suppliers Cash collections from customers Required: $ 90,000 $ 27,000 $ 25,000 $ 57,000 $ 87,000 $ 125,000 $ 400,000 a. Find the net cash provided by or used in investing activities. Note: Input the amount as positive value. b. Find the net cash provided by or used in financing activities. Note: Input the amount as positive value. c. Find the net increase or decrease in cash for the year. Note: Input the amount as positive value. a. Net cash b. Net cash investing activities financing activities c. Net in cash

PLEASE USE EXCEL AND SHOW THE FORMULAS USED. FOR EXAMPLE, IF SUM FUNCTION IS USED, PLEASE SHOW THE EXACT EXCEL FUNCTION TO SOLVE THE PROBLEM.

The statement of cash flo ws helps analysts evaluate all but which of the following? Multiple Cholce The amount of debt relative to equlty. Source of cash used for debt repayments. Source of cash used to finance investing activities. Differences between net income and net operating cash flow. Source of cash used for plant expansion.

Please show how you got your answer.

Calculate the Free Cash Flow for Polaris. Item EBITDA Depreciation Tax Rate, T Current Assets Current Liabilities CAPEX Polaris Inc. Selected Financial Information ($000's) Year 0 19,324 17,147 Year 1 10,000 1,188 31% 15,520 15,823 2,078

Kindly help me with accounting questions

How do you solve this on excel  with formulas ?

Hi please construct a cash flow statement

The following is the balance sheet and income statement for Metro Eagle Outfitters, in condensed form, plus some information from the cash flow statement. Balance Sheet Cash and short-term investments Accounts receivable Inventory Other current assets Total current assets Long-lived assets Total assets Current liabilities Total liabilities Shareholders' equity Total liabilities and equity Income Statement Sales Cost of sales Gross margin Operating expenses Earnings before interest and taxes Net income Interest paid in cash Taxes paid in cash Cash Flows Cash flow from operations Capital expenditures Dividends 2022 $ 649,992 48,221 351, 452 111,135 1,160,800 573,332 $ 1,734, 132 $ 480,402 511,045 1,223,087 $ 1,734, 132 1. Inventory turnover. 2. Current ratio. 3. Quick ratio. 4. Cash flow ratio. $ 3,479,602 2,104,480 $ 1,375,122 971, 184 $ 403,938 $ 251,108 99 143,909 $ 604,171 95,839 87,492 Required: Calculate the following liquidity ratios for Metro Eagle in 2021 and 2022: 2021 $…

Staley Inc. reported the following data: Net income Depreciation expense Loss on disposal of equipment Increase in accounts receivable Increase in accounts payable Prepare the Cash Flows from Operating Activities section of the statement of cash flows, using the indirect method. Use the minus sign to indicate cash out flows, cash payments, decreases in cash, or any negative adjustments. $485,300 57,200 30,500 22,400 12,100 Staley Inc. Statement of Cash Flows (partial) Cash flows from operating activities: Adjustments to reconcile net income to net cash flow from operating activities: Changes in current operating assets and liabilities: Net cash flow from operating activities