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

The demand curve for a product is given by Qxd = 2,000 - 5Px + 0.2Pz, Where, Pz = $500. a. What is the own price elasticity of demand when Px = $120? Is demand elastic or inelasti

This is a research case.  You must complete this assignment INDIVIDUALLY.  This means no help from other students.  You may consult Dr. Eldridge while you are working on this case.

Investments under the Trustee Act The act defines the categories of investment as follows:         1. Fixed interest securities are: Securities which under their te

1. Briarcrest Condiments is a spice-making firm. Recently, it developed a new process for producing spices. The process requires new machinery that would cost $2,218,246. have a

Petition by creditor Any creditor including an assignee of a debt, may petition, provided: The debt due to him amounts to at least Shs 1,000; The debt is certain and i


Q. Estimation of current cost of debt? The debenture will be used to estimation the current cost of debt as it is the only marketable debt. The present market value of the debe

ORDER OF PAYMENTS The bankrupt’s estate must be distributed in the following order. 1. Cost and charges: Costs and charges properly incurred in administering the estate mu

How much must you save annually in order to accumulate Rs. 20, 00,000 by the ending of 10 years, whether the saving earns an interest of 12%?             Solution : A = [k/(