Question
Please construct a statement of cash flows for the mosr recent fiscal year (2017-2018)
Balance Sheet ASSEETS Cash and marketable securities 2018 2014 ,425 90,078 309,099 28,826 250,00012,000 415,000 250,000 00,00
Questions Q1. Which statements should Juan refer to and which ones should he construct so as to develop a fair assessment of
Balance Sheet ASSEETS Cash and marketable securities 2018 2014 ,425 90,078 309,099 28,826 250,00012,000 415,000 250,000 00,00077,653 595,948 Accounts receivable 270,00020,000 20,000 640,000$200,000100,000500,0005668,50 $995,948 Current Assets $591,099 Land, building and equipment 25,000 50,000 -150,000 350,000$300,000 Net fixed assets $225,000 $791,099 Total assets 968,503 2018 IABILITIES AND EOUITIES 2015 Shon-term bank loans 0,000 145,000 16,795 9.99850 11.626 10,506 5,000 65,000 3,100 175,00098,000$167329 271,000 467,000 Current liabilities $173.296 $176,421 3,3663160,60733115,995 183,000 debt 271,000 447,000 Total liabilities 303,366 431 1,606$634,329 $631,296 $623.421 320,000 Common stock (100,000 shares) 320,000 320,000 640000 $33949341,619 $791,099 Retained earnings 16,634 25,184 Total equity 336,634 $345,184 345,082 995.948 Total liabilities and Quickfix Autoparts Income Statement 2014 2015 2018 Net sales 600,000.00 655,000.00 780,000.00873,600.00 1,013,376.00 Cost of good sold 480,000.00 537,100.00 633,200.00742,360.0061,370.00 Gross profit $120,000 17900.00 $124,80000 $131,040.00 $152,006.00 15,345.00 30,000.00 25,000.00 6,881.00 43,680.00 40535.00 0,000.00 0,000.00 5,725.00 17.472.005 Total operating expenses 7,02700 $43,90.00 $72,6060,1200 S105,736.00 2,027.00 3,557.00 15,201.00 $,6800013,3200046270.00 13,680.00 EBIT 62,973.00 73,998.00 52,1940019 Interest on short-term loans 15,950.00 13,320.00 15,000.00 Interest on long-term loans 7,840,00 8,000.00 Intcrest on mortTotal interest 8,760.0018,480.00 $35,250.00 $35,900.00$48,650.00 $47 280.00 $46,440.00 12,250.00 12,11000 18,970.00 170.00 Before tax earnings 27,723.00 11,08920 38,098.00 ,544.00 27,392.00 417.60 10,956.80 15,239.20 -68.00 16,633.80 $22,858.80 S2,12640(S16.435.20) Net Income S0.00 $16,634.00 $22,859.00 $2,12600 50.00 0.00 S0.00 to retained carnings EPS (100,000 shares) $0.23 $0.02 (SO.16) (50.00 50.17
Questions Q1. Which statements should Juan refer to and which ones should he construct so as to develop a fair assessment of the firm's financial condition? Explain why and construct the one needed for the most recent fiscal year?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Cash flow statement gives a very clear picture of :

how much cash is generated or used-up in various activities such as:

day-to-day operating activities for which the business was formed,

investment in/or sale of fixed assets that are necessary for carrying out the above operation as also other types of investment in securities of other companies ; and

financing activities like issue or retirement of stocks & shares ,payment of cash dividends,and other long-term loans .

CFS is a roadmap of how the cash in the business got in & where and how it was spent.

Cash Flow Statement
For the Fiscal Year ended 2018
Operating Activities
Net Income as per Income Statement -102
Add Back: Non-cash charge
Depreciation 50000
Adjusted Net income 49898
Changes to Working Capital
Less:Increase in A/R(90078-77653) -12425
Less: Increase in Inventory(560000-520000) -40000
Add: Increase in A/P(16795-15995) 800
Add: Increase in Accruals(11626-9301) 2325
Net changes to Working Capital -49300
Cash flow from operating activities 598
Investing Activities
Cash flow from Investing Activities 0
Financing Activities
Repayment of long-term loans(183000-190000) -7000
Mortgage payment(264000-268000) -4000
Cash flow from Financing activities -11000
Net cash used -10402
Add:Beginning cash balance 28826
Ending cash balance 18424
-1
Add a comment
Know the answer?
Add Answer to:
Please construct a statement of cash flows for the mosr recent fiscal year (2017-2018) Balance Sheet ASSEETS Cash a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Prepare a statement of cash flows based on the following financial statements: Balance Sheet 2017 2018...

    Prepare a statement of cash flows based on the following financial statements: Balance Sheet 2017 2018 Assets Current assets Cash $5,000 $6,500 Accounts receivable $31,500 30,000 $42,000 Inventory 40,000 Total $75,000 $80,000 Fixed assets Net plant and equipment $393,750 375,000 $450,000 Total assets $473,750 Liabilities and Owners Equity Current liabilities Accounts payable $50,000 $53,750 Notes payable 25,000 $26,250 Total $75,000 $80,000 Long-term debt Owners' equity $85,000 $89,250 Common stock $60,000 $63,000 Accumulated retained 241,500 230,000 earnings Total $290,000 $304,500 Total...

  • Construct a statement of cash flows from the following balance sheet and income statement information. Answer...

    Construct a statement of cash flows from the following balance sheet and income statement information. Answer the following three questions: Patterson, Inc Balance Sheets for Year-End ($ millions) Year 2019 Year 2018 $10 $80 Assets Cash and marketable securities Accounts receivable Inventories Total current assets Not lontandoviment Net plant and equipment Total assets 315 415 375 615 $1000 1000 $2,000 $810 870 $1,680 Year 2018 $30 60 Liabilities and Equity Accounts payable Notes payable Accruals Total current liabilities Long-term bonds...

  • 1) Given the following financial information for 2014 and 2015, construct an Income Statement, Balance Sheet...

    1) Given the following financial information for 2014 and 2015, construct an Income Statement, Balance Sheet and Statement of Cash Flows for Grand Twins.    - The Income Statement information is for the entire year.    - The Balance Sheet information is for December 31 of each year.                                                   2014                    2015 Accounts Payable                    $2,065,168           $3,732,362 Accounts Receivable               47,677,904           53,413,866 Cash                                      5,786,943           1,260,691 Common Stock                       27,280,000           27,280,000 Cost of Goods Sold                  45,014,348           50,298,751 Depreciation Expense                   975,000             975,000...

  • Please complete in excel The Statement of Cash Flows 989 P16-34A Preparing the statement of cash...

    Please complete in excel The Statement of Cash Flows 989 P16-34A Preparing the statement of cash flows-indirect method with Learning Objective 2 non-cash transactions The 2015 income statement and comparaive balance sheet of Rolling Hills, Inc. follow 1. Net Cash Prov. by Op. Act. $125,700 ROLLING HILLS, INC. Income Statement Year Ended December 31, 2015 Sales Revenue $436,000 Cost of Goods Sold 202,200 Gross Profit 233,800 Operating Expenses Salaries Expense $78,400 Depreciation Expense-Plant Assets 14,400 Other Operating Expenses 10,200 Total...

  • Some recent financial statements for Smolira Golf Corp. follow Assets 2018 2017 $ Current assets Cash...

    Some recent financial statements for Smolira Golf Corp. follow Assets 2018 2017 $ Current assets Cash Accounts receivable Inventory $ 24,246 14.448 27,992 SMOLIRA GOLF CORP. 2017 and 2018 Balance Sheets Liabilities and Owners' Equity 2018 2017 Current liabilities $ 26,100 Accounts payable $ 25,184 17,200 Notes payable 20,000 29,100 Other 13,571 $ 72,400 Total $ 58,755 Long-term debt $ 89,000 29,100 12,800 18,100 Total $ 66,686 $ 60,000 $ 101,000 $ 50.000 Owners' equity Common stock and paid-in $...

  • The 2018 Income Statement and Balance Sheet of Tampa Clinic, a not-for-profit organization, are presented below....

    The 2018 Income Statement and Balance Sheet of Tampa Clinic, a not-for-profit organization, are presented below. Tampa Clinic Income Statement Year Ended December 31, 2018 Operating Revenues: Patient service revenue $524,630 Less provision for bad debts (27630) $497,000 Net patient service revenue Other revenue Net operating revenues 10,000 $507,000 Expenses: Salaries and benefits Supplies Insurance Depreciation Interest Total expenses Operating income Nonoperating income: Investment income Net income $231,950 76,050 16,700 8,000 41,000 $373,700 $133,300 S 2,700 $136,000 Tampa Clinic Balance...

  • Prepare common-sized balance sheet and income statements for the company for 2017 and 2018. All values...

    Prepare common-sized balance sheet and income statements for the company for 2017 and 2018. All values in millions except for per share data. (In $, not %) 12/31/18 12/31/17 Sales Cost Of Goods Gross Profit Selling & Adminstrative & Depr. & Amort Expenses Income After Depreciation & Amortization Non-Operating Income Interest Expense Pretax Income -11 -21 -20 Income Taxes Minority Interest Investment Gains/Losses Other Income/Charges 0 0 00 -9 -20 - 0 22 Income From Cont. Operations Extras & Discontinued...

  • Given the following information please construct a balance sheet and an income statement for the company....

    Given the following information please construct a balance sheet and an income statement for the company. It provides software via a cloud subscription. There is n inventory All information in $000 Total Revenues Cash Common Stock Cost of Revenues Subscription Interest Expense Additional Paid in Capital Retained Earnings Cost of Revenues Professional Services 365 Gross Margin Short term securities Long term debt Accounts Receivable Accounts Payable Research &Development Marketing & Sales Other current liabilities Other current assets Investment income General...

  • How does Tampa Clinic’s statement of cash flows compare with Sunnyvale’s statement? Exhibit 4.6. The 2018...

    How does Tampa Clinic’s statement of cash flows compare with Sunnyvale’s statement? Exhibit 4.6. The 2018 Income Statement and Balance Sheet of Tampa Clinic, a not-for-profit organization, are presented below Tampa Clinic Income statement Year Ended December 31, 2018 Operating Revenues: Patient service revenue Less provision for bad debts Net patient service revenue Other revenue Net operating revenues $524,630 (27.630) $497,000 10,000 $507 000 Expenses: Salaries and benefits Supplies Insurance Depreciation Interest Total expenses Operating income $231,950 76,050 16,700 8,000...

  • prepares a “Statement of Cash Flows” for the year ended December 31, 2018.                              &nbsp

    prepares a “Statement of Cash Flows” for the year ended December 31, 2018.                                                                                               Keith corporation balance sheet                                                                                             December 31 Assets                                                                                 2003        2002 Cash                                                                                 $1,500       $1,000 Marketable securities                                                     1,800         1,200 Accounts receivable                                                        2,000         1,800 Inventories                                                                        2,900         2,800        Total current assets                                                 $8,200      $6,800 Gross fixed assets                                                           $29,500    $28,100 Less: Accumulated depreciation                                    14,700       13,100 Net fixed assets                                                                 $14,800     $15,000 Total Assets                                                                        $23,000     $21,000                                                                  Liabilities and Stockholders’ Equity Accounts payable                                                           $1,600       $1,500 Notes payable                                                                    2,800         2,200 Accruals                                                                                 200             300         Total current liabilities                                             $4,600       $4,000 Long -term debt                                                                $5,000       $5,000 Common stock                                                                  $10,000     $10,000 Retained earnings                                                                3,400         2,800        Total stockholders’ equity                                       $13,400     $12,800 Total Liabilities and stockholders” equity                    $23,000     $21,800 Income Statement Data(2003) Depreciation expense                                                   $1,600 Earning before interest taxes                                        2,700 Taxes                                                                                     933 Net profits...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT