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

Example of continuous compounding, Determine the future value of Rs.1000 co...

Determine the future value of Rs.1000 compounded continuously for 5 year on the interest rate of 12 percent per year and contrast it along with annual compounding.   Solution :

Accounting adjustment, In February, one of Team Shirts' best customers went...

In February, one of Team Shirts' best customers went bankrupt owing team shirts $85. Team shirts uses the sales method for estimating bad debts. February sales were $15,000. The ac

maximize profit, Natural Furniture Company manufactures three outdoor prod...

Natural Furniture Company manufactures three outdoor products, benches, chairs, and tables. Every product must pass by the following departments before it is shipped: sanding, sawi

Trust accounts-breach of law-trusts accounts, TRUST ACCOUNTS (a) Obje...

TRUST ACCOUNTS (a) Object of trust accounts : To demonstrate that the trust funds have been applied in accordance with the trust instrument; To give details of tra

Petition by creditor-bankruptcy, Petition by creditor Any creditor incl...

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

Determine the missing amounts, Two items are omitted from each of the follo...

Two items are omitted from each of the following summaries of balance sheet and income statement data for two corporations for the year 2014, Steven Craig and Georgia Enterprises.

Calculate the cash flow-agency costs, Tom Scott is the owner, president, an...

Tom Scott is the owner, president, and primary salesperson for Scott Manufacturing. Because of this, the company's profits are driven by the amount of work Tom does. If he works 40

Terms of trade, Terms of Trade Doe Ltd must negotiate agreed terms of tr...

Terms of Trade Doe Ltd must negotiate agreed terms of trade with its customers in order to encourage prompter payment. These terms of trade may tender discounts for early paymen

Explain about short-term bank loans and overdrafts, Q. Explain about Short-...

Q. Explain about Short-term bank loans and Overdrafts? Short-term bank loans and Overdrafts. The symptom are that Vertid is unlikely to obtain further finance from its bank alt

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd