Share
Explore BrainMass

Cash Flow Analysis in Accounting

Attached you will find an excel format. Please answer the questions below with an explanation.

Cash Flow Statement
for Year ended March 31, 2007
Operating Activities
Net Income 2,50,000
Depreciation 90,000
Amortization 40,000
Gain on sale of restaurant -1,20,000
Loss on sale of equipment 5,000
Changes in W/C Accounts
Related to Operations
Decreased A/R 12,000
Decreased Inventory 5,000
Increased Prepaid Expenses -10,000
Decreased A/P -6,000
Increased Accrued Expenses Payable 2,000
Decreased Income Taxes Payable -18,000
Decreased Advance Deposits -16,000
Cash from (used in) operations 2,34,000
Investing Activities
Purchase of equipment -2,00,000
Sale of equipment 1,50,000
Sale of restaurant 3,00,000
Investment in restaurants -4,60,000
Cash from (used in) investing activities -2,10,000
Financing Activities
Sold Bonds 3,60,000
Borrowed 2,000
Drew Upon Line of Credit 1,000
Bought Treasury Stock -4,20,000
Cash from (used in) financing activities -57,000

Increase (Decrease) in cash -33,000
Cash and cash equivalents March 31, 2006 70,000
Cash and cash equivalents March 31, 2007 37,000

What is the beginning cash balance of this restaurant?

Attachments

Solution Preview

Attached you will find an excel format.

1. What is the beginning cash balance of this restaurant? 70,000

2. How much is this restaurant obtaining from each of its
internal sources of cash?
Source #1 Net Income 250000
Source #2 Depreciation 90000
Source #3 Amortization 40000
Total internal sources of cash 380000
3. Is this restaurant growing? How do you ...

Solution Summary

Solution helps in Cash Flow Analysis

$2.19