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

List the various methods of determining goodwill, Question 1 Explain the f...

Question 1 Explain the five accounting concepts with an example Separate entity concept Going concern concept Money measurement concept Cost concept Dual aspect

Compute the effect on retail sales, Molina Medical Supply Company is trying...

Molina Medical Supply Company is trying to decide whether or not to continue distributing hospital supplies. The following information is available for Molina's business segments.

Annulment of order-adjudication of debtor, Annulment of order The order...

Annulment of order The order may be annulled if In the opinion of the court the debtor ought not to have been adjudicated bankrupt; All the debts have been paid in fu

Determine balance sheet, Determine balance sheet: Income Statements ...

Determine balance sheet: Income Statements Year Ended December 31, 20X8   Insure Co. Go-med Co. Sales $3,900,000

Operating lease, For a capital lease the lessee records the lease payments ...

For a capital lease the lessee records the lease payments as rent expense, but for an operating lease the lessee reports the lease payments as depreciation expense For an operating

Journalize the transactions, During it's first year of operations, Rosa Cor...

During it's first year of operations, Rosa Corp has these transactions pertaining to its common stock. Jan. 10 Issued 30,000 shares for cash at $5 per share July 1 Issued 60,000 sh

#Withholding Tax Payable, #Hi! would you mind to help me? is there such an ...

#Hi! would you mind to help me? is there such an accounting term as Withholding Tax Payable??? please help me.. thanks

Analysis of the financial results, An introduction to the company, which fo...

An introduction to the company, which focuses on the context in which the company operates: • Ownership, development and location; • Resources, processes and employment; •

Quantitative techniques, Evaluate 1-1/3(5/6 - 1/2) ---------------- 2/5 / ...

Evaluate 1-1/3(5/6 - 1/2) ---------------- 2/5 / 2/5(5/6-2/3)

The federal government, The Federal Government The Federal Government...

The Federal Government The Federal Government is the single largest influence on the U.S. economy. There are two main areas in which the government can impact the economy: fi

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