Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

Question: Cash Budget The controller of Feinberg Company is gathering data to prepare the cash budget for July. He plans to develop the budget from the following information:

a. Of all sales, 40 percent are cash sales.

b. Of credit sales, 45 percent are collected within the month of sale. Half of the credit sales collected within the month receive a 2 percent cash discount (for accounts paid within 10 days). Thirty percent of credit sales are collected in the following month; remaining credit sales are collected the month thereafter. There are virtually no bad debts.

c. Sales for the second two quarters of the year follow.

                                 Sales

April                        $450,000

May                          580,000

June                         900,000

July                       1,140,000

August                   1,200,000

September              1,134,000

d. The company sells all that it produces each month. The cost of raw materials equals 26 percent of each sales dollar. The company requires a monthly ending inventory of raw materials equal to the coming month's production requirements. Of raw materials purchases, 50 percent are paid for in the month of purchase. The remaining 50 percent is paid for in the following month.

e. Wages total $105,000 each month and are paid in the month incurred.

f. Budgeted monthly operating expenses total $376,000, of which $45,000 is depreciation and $6,000 is expiration of prepaid insurance (the annual premium of $72,000 is paid on January 1).

g. Dividends of $130,000, declared on June 30, will be paid on July 15.

h. Old equipment will be sold for $25,200 on July 4.

i. On July 13, new equipment will be purchased for $173,000.

j. The company maintains a minimum cash balance of $20,000.

k. The cash balance on July 1 is $27,000.

Required: Prepare a cash budget for July. Give a supporting schedule that details the cash collections from sales.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M92502526
  • Price:- $15

Priced at Now at $15, Verified Solution

Have any Question?


Related Questions in Accounting Basics

Question -a jalisco inc net credit sales of 75000 and

Question - A) Jalisco Inc. net credit sales of $75,000 and estimates that bad debts are approximately 3% of net credit sales. The yearend balance in accounts receivable is $200,000 and $2,000 of accounts receivable were ...

Problem - pearl co is building a new hockey arena at a cost

Problem - Pearl Co. is building a new hockey arena at a cost of $2,620,000. It received a down payment of $450,000 from local businesses to support the project, and now needs to borrow $2,170,000 to complete the project. ...

Discussion as a present for doing so well in your finance

Discussion: As a present for doing so well in your finance class, your uncle has offered you a choice: He will give you either a zero coupon long term bond or a short term bond that pays coupon payments. Which would you ...

Question income tax implication of capital investment

Question: Income Tax Implication Of Capital Investment Decisions Read the following case study: The Whitley Corporation's year-end is December 31, 2013. It is now October 1, 2013. The Whitley management team is taking a ...

Question - based on the loan amortization table1 whats the

Question - Based on the loan amortization table 1) What's the current and long-term liability that would appear on the Dec. 31, 2016 Balance sheet? 2) What's the interest expense for 2017? 3) What's the current and long- ...

Question - victorias 2016 tax return was due on april 15

Question - Victoria's 2016 tax return was due on April 15, 2017, but she did not file it until June 12, 2017. Victoria did not file an extension. The tax due on the tax return when filed was $9,400. In 2016, Victoria pai ...

Question - lana operates a real estate appraisal service

Question - Lana operates a real estate appraisal service business in a small town serving local lenders. After noting that lenders must pay to bring in a surveyor from out of town, she completes a course and obtains a su ...

Quesiton company general mills incfinancial ratios are used

Quesiton: Company: General Mills Inc Financial ratios are used to assess a company's strengths and weaknesses. One way to use ratios is to compare the company under consideration to the industry average. Deriving meaning ...

Question if the per worker production function is given by

Question: If the per worker production function is given by y=k^1/2, the population growth rate is n= .04, and the depreciation is .01. a. The golden rule level of capital and output per worker is: b. What is the saving ...

Question - following are the transactions for abc computer

Question - Following are the transactions for ABC Computer Service's first month of business, September 2018: Sept 1 The owner invested $10,000 into the business in exchange for common stock. Sept 4 Purchased equipment f ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As