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

Scheduling or budgeting, Tool Belt Store (TBS) is expanding its chain of ha...

Tool Belt Store (TBS) is expanding its chain of hardware stores across the country. TBS has more than 5,000 full-time employees and more than 20,000 part-time employees. TBS recent

Calculate the average issue price of the common stock, Star corporation iss...

Star corporation issued both common and predered stock during 20X6. The stockholders' equity section of the company's balance sheets at the end of 20X6 and 20X5 follow: 20X6 20X5 P

Calculate the profit maximization, Complete the table and use the informati...

Complete the table and use the information to determine profit maximization or loss minimization. 1. Complete the table Normal 0 false false false EN-I

Procedure after winding up order-liquidation of companies, Procedure after ...

Procedure after Winding-up Order 1. A copy of the order must be filed by the company with the registrar s.227. 2. The company must deliver a statement of affairs to the Offici

FIAR VALUE ALLOCATIONS, How do I figure fair value of assets..2 year estima...

How do I figure fair value of assets..2 year estimated useful life and indefinite life recognized by purchased company

Retained earnings, Ask question #MiniFollowing is the shareholder''s equity...

Ask question #MiniFollowing is the shareholder''s equity of Valdez Corporation on Jan. 1, 2018:Ordinary Shares, P100 par P6,000,000 Share Premium 500,000 Retained Earnings 1,800,

What role does accounting play in the planning, What role does accounting p...

What role does accounting play in the planning, implementation, analysis of CSR in particular and organizational strategies in general?

State the economic benefit of having accounting information, State the Econ...

State the Economic benefit of having accounting information Economic benefit of having accounting information is even harder to assess. It's possible to implement some 'scienc

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?

Assignment, I have an assignment due in four hours. Is it possible to get a...

I have an assignment due in four hours. Is it possible to get an inquiry if at least half of it can be done within that time?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages