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

Determine estimated cost, XYZ Company is a large manufacturer of auto parts...

XYZ Company is a large manufacturer of auto parts for the auto manufacturers and parts distributors. XYZ has plants throughout the world, but most are located in North America. XYZ

The income statement-financial statement, THE INCOME STATEMENT It shows t...

THE INCOME STATEMENT It shows the financial performance of the company during the given financial period. It discloses the income and expenses and thus the net profit for the per

Describe the internal revenue code, Exclusions - Income item that is exclud...

Exclusions - Income item that is excluded from a taxpayer's gross income by INTERNAL REVENUE CODE or an administrative action. Common exclusions comprise gifts, inheritances and de

Illustration of deffered tax-financial statement, Illustration of Deffered ...

Illustration of Deffered Tax A firm bought an item of plant at a total amount of £50,000. During the first year, the firm provided for depreciation of 10,000. The item of plant

Traditional techniques - techniques of inventory control, Inventory Control...

Inventory Control Ratios For reasons of monitoring the effectiveness of inventory management this is useful to look at the subsequent ratios and indexes: Overall Inventory Tu

Illustration regarding profit that head office can claim, Illustration rega...

Illustration regarding profit that head office can claim E Ltd sets up a branch in Nyeri on 1 July 2001. Goods are sent to branch at an invoice price which is 10% above cost. S

Finacial management, There are two projects A and B. The initial capital ou...

There are two projects A and B. The initial capital outlay of A and B are Rs.1,35,000 and Rs.2,40,000 respectively. There will be no scrap value at the end of the life of both the

Journalize, wrote check to purchase law books for 2500 what 2 accounts

wrote check to purchase law books for 2500 what 2 accounts

Absorption costing, Absorption costing is a cost accounting method that ...

Absorption costing is a cost accounting method that tries to charge all direct costs and all production costs of an organization to specific units of pr

Safety stock, Safety Stock What must be the level of safety stock? In a...

Safety Stock What must be the level of safety stock? In a simple condition where merely the usage rate is variable and the maximum usage rate can be given, the safety stock nee

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages