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 $750,000 in dividends to common shareholders. Throughout the year, the firm purchased $5.5 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 $450,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 6% interest rate. What was the firm's end-of-year cash balance? Recreate the firm's cash flow statement to arrive at your answer.

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum Arial General ta copy. в 1 프 . Ej-, , Δ.--, 還狸函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Paste Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. Styles ▼ ㆆ ▼ Clipboard Font Alignment Number Cells AV58 AU AV AW AX AY AZ BA 58 59 60 61 62 63 64 65 cash flow from operating activities net income depreciation net changes in current accounts 5000000 450000 1. cash from operating activities 5450000 investing activities cash flow from purchase of property & equipment 5500000 67 68 69 70 71 72 73 74 75 76 2. cash from investing activities 5500000 financing activities issue of long term debt payment of dividends 1000000 -750000 3. cash from financing activities 250000 change in cash cash balance at the beginning of the year 200000 100000 300000 (200000+100000) 78 answer cash balance at the end of the year トト | Sheet1 , Sheet2· MD< 福 140% 08:51 01-02-2019

Add a comment
Know the answer?
Add Answer to:
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • eBook You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters...

    eBook 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...

  • 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...

  • 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...

  • 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....

  • 3-7: Free Cash Flow Statement of Cash Flows You have just been hired as a financial...

    3-7: Free Cash Flow Statement of Cash Flows You have just been hired as a financial analyst for Basel 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....

  • 4. Problem 3.13 (Statement of Cash Flows) eBook You have just been hired as a financial...

    4. Problem 3.13 (Statement of Cash Flows) eBook 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....

  • 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....

  • 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....

  • 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....

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
ADVERTISEMENT