Quarterly cash dividends are planned, Financial Accounting

Given the information that follows, draw a cash budget for the XYZ Store for the first six months of 2012.

  • Every prices and costs remain constant.
  • Sales are 80% for credit and 20% for cash.
  • With respect to credit sales, 55% are collected in the month after the sale, 30% in the second month, and 15% in the third.  Bad-debt losses are insignificant.
  • Sales, actual and estimated, are:

October 2011

$300,000

March 2012

$200,000

November 2011

450,000

April 2012

350,000

December 2011

400,000

May 2012

280,000

January 2012

200,000

June 2012

220,000

February 2012

250,000

July 2012

320,000

  • Payments for purchases of merchandise are 90% of the following month's anticipated sales.
  • Wages and salaries are:

January 2012

$40,000

April 2012

$50,000

February 2012

45,000

May 2012

45,000

March 2012

55,000

June 2012

55,000

  • Rent is $5,000 a month.
  • Interest of $8,500 is due on the last day of every calendar quarter, and no quarterly cash dividends are planned.
  • A tax prepayment of $60,000 for 2012 income is due in April.
  • A capital investment of $60,000 is planned in June, to be paid for then.
  • The company has a cash balance of $90,000 at December 31, 2011, which is the minimum desired level for cash.  Funds can be borrowed in multiples of $5,000. (Ignore interest on this type of borrowings.)

 

Posted Date: 3/22/2013 1:14:50 AM | Location : United States







Related Discussions:- Quarterly cash dividends are planned, Assignment Help, Ask Question on Quarterly cash dividends are planned, Get Answer, Expert's Help, Quarterly cash dividends are planned Discussions

Write discussion on Quarterly cash dividends are planned
Your posts are moderated
Related Questions
How useful is accounting information? No one would seriously claim that accounting information fully meets all of the needs of every various user groups. Accounting is still a

Determine the future value of Rs.1000 compounded continuously for 5 year on the interest rate of 12 percent per year and contrast it along with annual compounding.   Solution :

I have a presentation on an article (around 20 pages). I also need 2 current real life examples (2 companies) to support the presentation. Can you do that? How long it will take yo

Pre-acquisition dividends Pre-acquisition dividends may also arise in the following situations; 1 ) Where the holding company acquires the subsidiary company’s shares cum-div


I need help with assignment completeion

A company does not need to record the receipt of a bill for utilities used during this year if they will not pay for it until next year. True or False

Q. How does FCA diverse from what cities already do? Numerous cities at present employ budget-based, or cash-flow, accounting-they report their present costs and figure their e

Explain in detail about the Sole proprietorship Sole proprietorship, as the name suggests, is where an individual is the sole owner of a business. This type of business is ofte

Consider the expected return and standard deviation of the following two assets: Asset 1: E[r1]=0.1 und σ1=0.3 Asset 2: E[r2]=0.2 und σ2=0.4 (a) Draw (e.g. with Excel) the