Purchase Solution

Cash Flow Analysis in Accounting

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution

Solution Summary

Solution helps in Cash Flow Analysis

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

Purchase this Solution


Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Introduction to Finance

This quiz test introductory finance topics.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.