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

Termination of appointments-trust laws, TERMINATION OF APPOINTMENTS A tru...

TERMINATION OF APPOINTMENTS A trustee may cease to hold office in the following ways: (a) Disclaimer : At any time before acceptance of the trusts. (b) Retirement : Eith

Calculate profit and loss, On 1 January 2008, a young artist called Michela...

On 1 January 2008, a young artist called Michelangelo signed a contract with a charity named Art Angels, which supports young artists to do large projects. The agreement requires M

How to determine the market economy, How to determine the market economy ...

How to determine the market economy Within a market economy there are strong competitive forces at work which ensure that failure to enhance owners' wealth won't be tolerated f

UNDERSTANDING bUSINESS, I NEED HELP in business ratios for two company.Ido...

I NEED HELP in business ratios for two company.Ido not know how to do the formulas. Can you help.

Effect of receiving order, Effect of receiving order The consequences o...

Effect of receiving order The consequences of the making of the receiving order are: The debtor retains ownership, but loses possession and control of his property; Th

Prepare all journal entries for 2013, A summary of Jarvis Company's Decembe...

A summary of Jarvis Company's December 31, 2013, accounts receivable aging schedule is presented below along with the estimated percent uncollectible for each age group: Age Gro

Features of the torrens title system, Answer both parts of this question. E...

Answer both parts of this question. Each part is worth seven and a half marks each. (a) Describe the features of the Torrens Title system of land registration and compare them t

The accounting equation., Indicate how each of the following transactions a...

Indicate how each of the following transactions affects the accounting equation. a.Purchase of supplies on account. b.Payment of wages. c.Cash sale of goods for more than their cos

Fv of the annuity due, Find the current value of the following ordinary ann...

Find the current value of the following ordinary annuities. (Notes: If you are using a financial calculator, you can enter the known values and then press the appropriate key to se

Show the management report, Q. Show the Management Report? Management's...

Q. Show the Management Report? Management's Report - Management is essential to include in its annual report its assessment of the effectiveness of the company's internal contr

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages