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

 

Posted Date: 3/22/2013 1:14:50 AM | Location : United States







Related Discussions:- Quarterly cash dividends are planned, Assignment Help, Ask Question on Quarterly cash dividends are planned, Get Answer, Expert's Help, Quarterly cash dividends are planned Discussions

Write discussion on Quarterly cash dividends are planned
Your posts are moderated
Related Questions
Provisions of the Partnership Act In the event of absence of a partnership agreement/deed or in the event of ambiguity therein, the provisions to the partnership Act will apply

On December 15, 2011 Risby Sales Co. sold a track of land that cost $3,600,000 for $4,500,000. Rigsby appropriately uses the installment sale method of accounting for this transact

Q. Explain Final Location Survey? A final Location Survey is under taken on the completion of traffic survey to select the final rout of the line to be constructed, taking into

Define Case Study of A Company that exports goods? A company exports goods to country K. Your work as an international cash manager needs you to estimate the value of country K

XYZ Inc. whose stock is currently valued at $125/share with an implied volatility of 40% has debt of $80/share. a. Assuming a global recovery rate of 50% and a standard deviatio

Q. What do you understand by Exempt Organization? Exempt Organization - Organization that is normally exempt from paying federal income tax. Exempt organizations comprise relig

The common stock of the PP Corporation has been trading in a narrow price range for the past month, and you are convinced it is going to break far out that range in the next 3 mont

In common terms the present value of a regular annuity may be shown as given below: PVNn = A/(1 + k) + A/(1 + k) 2 + ..................+ A/(1 + k) N = A (1/(1 + k) + 1/(

Statement of Cash Flows - A statement of cash flows is one of the fundamental financial statements which is required as part of a complete set of financial statements prepared in c

QUESTION 1: Part A Malcolm was in business as an import merchant and the following balances were extracted from his books on 31st December 2003: Purchases