Question

You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where...

You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million in net income during the year but paid $800,000 in dividends to common shareholders. Throughout the year, the firm purchased $5.4 million of machinery that was needed for a new project. You have just spoken to the firm's accountants and learned that annual depreciation expense for the year is $460,000; however, the purchase price for the machinery represents additions to property, plant, and equipment before depreciation. Finally, you have determined that the only financing done by the firm was to issue long-term debt of $1 million at a 7% interest rate. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.

Cash at the Beginning of Year $100,000.00

Change in Net Operating Working Capital Except Cash $0.00

Net Income $5,000,000.00

Common Dividends $800,000.00

Machinery Equipment Purchases $5,400,000.00

Depreciation Expense $460,000.00

Long-Term Debt $1,000,000.00

Interest Rate on Long-Term Debt 7.00%

Statement of Cash Flows I.

Operating Activities Formulas   

Net income #N/A   

Depreciation expense #N/A   

Change in net operating working capital except cash $0.00   

Net cash provided by (used in) operations #N/A

Long-Term Investing Activities

Additions to property, plant and equipment #N/A   

Net cash used in investing activities #N/A

Financing Activities   

Increase in long-term debt #N/A   

Payment of common dividends #N/A   

Net cash provided by financing activities #N/A IV. Summary   

Net increase (decrease) in cash #N/A   

Cash at beginning of year $100,000.00   

Cash at end of year #N/A

Homework Answers

Answer #1

cash flow statement

cash flow from operating activities

net income

5000000

add depreciation

460000

changes in working capital

0

net cash flow from operating activities

5460000

cash flow from investing activities

purchase of machinery

-5400000

net cash flow from investing activities

-5400000

cash flow from financing activities

dividend paid

-800000

proceeds from issuance of bonds

1000000

net cash flow from financing activities

200000

net cash flow during the year

260000

beginning cash balance

100000

yearend cash flow

360000

Know the answer?
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
Similar Questions
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million in net income during...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million in net income during...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million in net income during...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million in net income during...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million in net income during...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where...
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million in net income during...
STATEMENT OF CASH FLOWS You have just been hired as a financial analyst for Barrington Industries....
STATEMENT OF CASH FLOWS You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million...
STATEMENT OF CASH FLOWS You have just been hired as a financial analyst for Barrington Industries....
STATEMENT OF CASH FLOWS You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million...
Excel Online Structured Activity: Statement of cash flows You have just been hired as a financial...
Excel Online Structured Activity: Statement of cash flows You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year....
You are the CFO of a company called hamburger. Unfortunately, the firm’s headquarters (where all the...
You are the CFO of a company called hamburger. Unfortunately, the firm’s headquarters (where all the records are kept) have recently been destroyed by fire. So, your task is to recreate the cash flow statement for the year that has just ended. •   The firm originally had $4,800 in the bank at the end of the prior year (i.e., beginning cash), and its net working capital accounts, except cash, remained constant during the year. •   The company earned $18,300 in...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • The following sample observations were randomly selected. (Round intermediate calculations and final answers to 2 decimal...
    asked 3 minutes ago
  • what type of graph is best suitable for data obtained from customer ratings. The ratings are...
    asked 7 minutes ago
  • Determine the cumulative 15-year 18 kip ESAL’s in the design lane for 2-lane highway for the...
    asked 14 minutes ago
  • Q: Dr.Grimace, the evil dentist, is trying to find out if his patients suffer from periodontal...
    asked 14 minutes ago
  • After collecting data on 19283 dogs, you find that male vallhunds have an average weight of...
    asked 16 minutes ago
  • Research Target Corporation and assess your satisfaction with the company you researched and make recommendations about...
    asked 17 minutes ago
  • Evidence suggests that 70% of FSU students like turtles. Suppose we randomly sampled 15 FSU students....
    asked 17 minutes ago
  • Ulrich challenges the appropriateness of the nearly universal symbolism of the spinning wheel as the marker...
    asked 18 minutes ago
  • Differential Equations: Please try to computer type, if not possible be clear and organize. Thank you...
    asked 18 minutes ago
  • In your opinion, what are the three (3) most important benefits an employer can give to...
    asked 24 minutes ago
  • In a test of the effectiveness of garlic for lowering​ cholesterol, 81 subjects were treated with...
    asked 27 minutes ago
  • How does the 95% confidence interval correspond to the reported conclusion at a 0.05 significance level?...
    asked 27 minutes ago