Quarterly cash dividends are planned, Financial Accounting

Assignment Help:

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

Adjusting Entries, The following accounts and balances have been taken from...

The following accounts and balances have been taken from the general ledger trial balance of Daiton Repairs Limited as at October 31, 19×2, after its first year of operation. Adjus

Accounting and finance, I want you guys to make my assignment of 2500 words...

I want you guys to make my assignment of 2500 words please let me know the price and I din''t have time I want it by tomorrow

Journalizing, ABC Corportation purchased $15,000 of office furniture by put...

ABC Corportation purchased $15,000 of office furniture by putting down $7000 soqn in cash and the rest on accout

Ias 1 rules, IAS 1 rules IAS 1 requires companies to observe the follow...

IAS 1 rules IAS 1 requires companies to observe the following rules in preparing published financial statements: 1) The financial statements should reflect a true and fair v

Winding up under supervision-liquidation of companies, Winding up under sup...

Winding up under supervision Virtually obsolete, in consequence of s.303 and the power to invoke the court's assistance under s.301. If a supervision order is made, the effect

Project Assistance, How do you create an Excel document with several financ...

How do you create an Excel document with several financial statements, all linked together with specific financial data?

Types of gift by way of a will-executorship laws and account, TYPES OF GIFT...

TYPES OF GIFT BY WAY OF A WILL (a) A special (or specific) legacy is a testamentary gift of a particular part of the property of the testator, which identifies that part by a s

Adjudication order-adjudication of debtor, Adjudication order The court...

Adjudication order The court may adjudge the debtor bankrupt on the application of the O.R. or any creditor in the following cases: If the creditors so resolve at their first

Compute ratio, The comparative financial statement of new World Piano Compa...

The comparative financial statement of new World Piano Company for 2003,2002, and 2001 included the following selected data: 2003 2002 2003 In Millions Cash $67 $66 $62 Short T

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#

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages