Reference no: EM13963184
Prepare a Statement of Cash Flows. Cite all references used and detail formulas and or calculations. Review the income statement for the Country Vista Company.
You will use the income statement to help you complete Part 1 and Part 2 below.
Part 1: Indirect Method Using Excel, prepare the Statement of Cash Flows Indirect Method.
Your SOCF should be based upon the income statement and the additional information below:
Additional Information:
Increase in Accounts Receivables=$4,000
Increase in Accounts Payables=$16,000
Increase in Income Taxes Payable=$300
Decrease in Prepaid Expenses=$10,000
Decrease in Merchandise Inventory=$14,000
Decrease in Long Term Notes Payable=$20,000
Cash Paid to Purchase Land=$50,000
Cash Paid to Purchase Equipment=$15,000
Cash Paid to Retire Bonds=$25,000
Cash Paid to for Dividends=$10,000
Cash Received from the Sale of common stock=$50,000
Cash at the start of the year=$
Part 2: Direct Method Using Excel and the below information please prepare the complete statement of cash flows using the direct method.
Additional Information:
Cash Received from Customers=$80,000
Cash Payments for Merchandise=$10,000
Cash Payments for Operating Expenses=$5,000
Cash payments for Interest=$6,000
Cash Payments for Income Taxes=$3,000
| Country Vista Company |
| Income Statement |
| For the Year Ended December 31, 2011 |
| |
|
|
| Sales |
|
$248,000 |
| Cost of Goods Sold |
|
$116,000 |
| Gross Profit |
|
$132,000 |
| Operating Expenses |
|
|
| Wages and Salaries Expense |
$44,000 |
|
| Rent Expense |
$16,000 |
|
| Depreciation Expense |
$30,000 |
|
| Other Operating Expenses |
$18,000 |
$108,000 |
| Income from Operations |
|
$24,000 |
| Gain on Sale of Equipment |
|
$26,000 |
| Income before Income Taxes |
|
$50,000 |
| Income Tax Expense |
|
$17,500 |
| Net Income |
|
$32,500 |
|
Describe the research hypothesis and question
: Funding is available for any research with a strong defined need, which should be clearly outlined in the proposal. Priority will be given to those proposals that specifically describe the research hypothesis and question(s), the research methodol..
|
|
Finance net capital expenditures
: The firm's beta is 1.5 and the current risk-free rate is 6 percent. The firm plans to finance net capital expenditures (Cap Ex - Depreciation) and working capital with 20 percent debt. The firm also has current revenues of $5,000, which it expects..
|
|
What is the greatest height reached by the ball
: A stone is thrown vertically upward at a speed of 38.40m/s at time t=0. A second stone is thrown upward with the same speed3.410 seconds later. At what time are the two stones at the same height? At what height do the two stones pass each other?
|
|
Write junit test methods for the starter code given
: Write JUnit test methods for the starter code given in the Filtering Data exercise of the Abstract Classes and Interfaces lesson.
|
|
Prepare a statement of cash flows
: Prepare a Statement of Cash Flows. Cite all references used and detail formulas and or calculations. Review the income statement for the Country Vista Company.
|
|
What is the market demand for health promotion professionals
: What is the market demand for health promotion professionals, and what are some of the career opportunities both inside and outside of the U.S. for individuals who are interested in this field
|
|
Million in debt outstanding
: The firm has $100 million in debt outstanding and 50 million shares outstanding, selling for $10 per share. The firm currently has net income of $90 million and depreciation charges of $10 million. It also has the following projects available:
|
|
Calculate the frequency of oscillation and explain it
: The figure attached shows the Armstrong oscillator. A transformer with two secondary winding's has been use, one to give feedback and one to give the oscillator's output
|
|
Write a java program that repeatedly enters a date
: Write a Java Program that repeatedly enters a date and prints the day of the week that corresponds to each input date. Use a Calendar class object to find the day of week.
|