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

Related Discussions:- Quarterly cash dividends are planned

Financial break , OCF 218200 will result in a zero net present value for th...

OCF 218200 will result in a zero net present value for the project. The FC 329000 and CM 216.4 per unit. Financial break even?

What is the net present value of this machine, A company is considering the...

A company is considering the purchase of new equipment for $45,000. The projected after-tax net income is $3,000 after deducting $15,000 of depreciation. The machine has a useful l

Ed Mettway, Should Touring Enterprises consider liabilities as a part of it...

Should Touring Enterprises consider liabilities as a part of its permanent financing? Why or why not?n #Minimum 100 words accepted#

Labour variance, what is labour variance?

what is labour variance?

Define the term relevance - accounting information, Define the term Relevan...

Define the term Relevance - accounting information Accounting information should have the ability to influence decisions. Except this characteristic is present, there is ac

Determine the cost of capital and risk free rate, Instructions: The ...

Instructions: The case should be done in your assigned groups. Hand in a brief write-up not exceeding two pages explaining what was done. In April 198

Accounting standards in the united states, Which of the following was the f...

Which of the following was the first private sector entity that set accounting standards in the United States? a. Accounting Principles Board b. Committee on Acocounting Procedure

If analysis, conduct a-what-if-analysis

conduct a-what-if-analysis

Brushy mountain mining''s stock, Brushy Mountain Mining Company's ore reser...

Brushy Mountain Mining Company's ore reserves are being depleted, so its sales are declining. Also, its pit is getting deeper every year, so its costs are rising. As a result, the

Present value of an annuity, Let us assume you expect to obtain Rs.2000 yea...

Let us assume you expect to obtain Rs.2000 yearly for the next three years. The receipt of Rs.2000 is evenly divided. One part that is: Rs.1000 is obtained at the beginning of the

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages