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
Qualified Opinion - AUDIT opinion which states, except for effect of a matter to which a qualification relates, FINANCIAL STATEMENTS are fairly presented in accordance with GENERAL

Clemens Cars' job cost sheet for job A40 shows that the cost to add security features to a car was $10,500. The car was delivered to the customer, who paid $14,900 in cash for the

Business start up accounting transactions: Jane Whitfield, a sole proprietor, established the JW Flower Shop on January 2, 2010. The following transactions have occurred during

Sales volume reaches the maximum capacity of the new machine in Year 4. The positive NPV point to that the investment in Machine Two is financially acceptable althoug

Problem 1 (28 marks) Pre-Contribution Balance Sheets and Fair Values June 30, 20X9 (in thousands of $) Swag Co. Perk Ltd. Pre- Contribution Fair Value Pre- Contributi

The enhancing qualitative characteristic of understand ability means that information should be understood by a those who are experts int eh interpretation of financial information

What is the function of balance sheet


what is the treatment of increase in allowance receivable.

Prepare a year trading cash budget: Gary Hart needs to calculate how much working capital he will need in his first year as a restaurateur. An accountant friend recommends he