Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Prepare a statement of cash flows for fiscal year 2019of Hunter Inc.using the indirect methodbased on the following information. Use the provided Excel template to prepare the statement.Delete or add...

1 answer below »
Prepare a statement of cash flows for fiscal year 2019of Hunter Inc.using the indirect methodbased on the following information. Use the provided Excel template to prepare the statement.Delete or add rows for each section if necessary.Hunter Inc.'s comparative balance sheets are presented below.HUNTERCORPORATIONComparative Balance SheetsDecember 3120192018Cash$ 18,700$ 22,700Accounts receivable 24,70022,300Investments25,00016,000Equipment59,00070,000Accumulated depreciation(14,500)(10,000)Total$112,900$121,000Accounts payable $ 13,600$11,100Bonds payable6,00030,000Common stock50,00045,000Retained earnings43,30034,900Total $112,900$121,000Additional information:1.Net income was $17,700. Dividends declared and paid were $9,300.2.Equipment which cost $11,000 and had accumulated depreciation of $2,000 was sold for $4,000.3.All other changes in noncurrent account balances had a direct effect on cash flows, except the change in accumulated depreciation.Part B.Horizontal and Vertical Analysis(12points)Performhorizontal and vertical analysis onthe Balance Sheet and Income Statement of BE Electric Bikes. For horizontal analysis please show both the dollar and percent change.If using Excel (and formulas) properly, this step should be very quick to complete.This part of assignmentbuilds onyour submission from Module 3which includsthe preparation of the income statement, statement of equity, and balance sheetfor BE Electric Bikes.My suggestion isto use theModule 3assignment solution(to be uploaded in Canvas after Module 3 due date)to perform your analysis. NOTE: It is recommended that you create new tabs for each part in anExcel workbook (one tab for Part A and one tab for Part B). For Part B, it is recommended that you add the requested horizontal and vertical analysis information to the balance sheet and income statement numbers. As with previous assignments, make sure to have each tab formatted so that it will print properly(and beautifully).
Answered Same Day Feb 14, 2021

Solution

Bhavani answered on Feb 16 2021
143 Votes
Sheet1
    HUNTER CORPORATION
    STATEMENT OF CASH FLOWS
    Period of the statement
                    2013 TO 2014 CHANGE
    Cash flows from operating activities
    Net Income                                    17700
    Adjustments to reconcile net income to net cash provided
or (used) by operating activities
        Depreciation expense    6,500
        Loss on sale of ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here