Question

The Cash Budget Once we see how the components of the cash budget are calculated, it...

The Cash Budget

Once we see how the components of the cash budget are calculated, it is just a matter of putting together an entire cash budget. It almost seems redundant to say, but a cash budget includes only cash items. So if a company makes sales on account, those are not included in the cash budget until cash is received on account. Similarly, a company may have non cash expenses. These are not included in the cash budget.

A company expects sales of $100,000 in July and expects sales of $115,000 in August. The company provided the following information:

a. Sales in the previous three months were:

April $88,000
May 90,000
June 95,000

Of the sales, 10% are cash sales, the remaining are on account. The company experiences the following accounts receivable payment pattern: 25% in the month of sale, 50% in the month after sale, 20% in the second month after sale.

b. Purchases of goods are made the month before the anticipated sale at a rate of 60% of sales. Of monthly purchases, 25% are paid in the month of purchase, and the remaining 75% in the following month.

c. Wages for staff total $6,450 per month.

d. Telecommunications and utilities are $1,900 per month.

e. The property tax bill of $6,000 is due in August.

f. Insurance is paid quarterly at $1,200 per quarter. The next payment is due July 15.

g. Depreciation is $2,000 per month.

h. Advertising is budgeted at $2,000 per month in the summer months.

i. Professional fees (legal, bookkeeping, etc.) average $600 per month.

j. Maintenance is $800 per month.

k. Office supplies average $150 per month.

l. The owner took out a loan from her family and is paying it back at the rate of $4,000 per month.

m. The cash balance on July 1 was $2,190.

Develop a cash budget for July by filling in the following table. If an amount box does not require an entry, enter "0" or leave the cell "blank".

Beginning cash balance, July 1 2,190
Add: Cash sales 10,000
Payments on accounts receivable:
May 59,850 (WRONG)
June 77,715 (WRONG)
July 81,450 (WRONG) 219,015 (WRONG)
Cash available 229,015 (WRONG)
Cash Disbursements:
     Purchases 62,250
     Wages 6,450
     Telecommunications 1,900
     Property tax 0
     Insurance 1,200
     Depreciation 0
     Advertising 2,000
     Professional fees 600
     Maintenance 800
     Office supplies 150
     Loan payment 4,000
Total disbursements 79,350
Cash balance, July 31 151,855 (WRONG)

PLEASE HELP FIX WRONG ONES! Thank you :)

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Based on the following data, prepare a cash budget (in proper form with labels) for July...
Based on the following data, prepare a cash budget (in proper form with labels) for July and August. Forecast sales May     $12,000       Cash sales are 30% of total sales.  Credit sales June     15,000         are collected as follows: 60% one month after the July      $16,000        sale and 40% 2 months after the sale August $12,000 Accounts payable are paid 100% 2 months after the purchase Expected A/P May     $4,500              In addition to purchases, there are utility June    $6,500              bills of $1,500 each month and rent of $1,200 July     $7,000              per month. August $8,000 Beginning...
Application/theory (excel problem) Problem - Cash Budget The following information pertains to Amigo Corporation: Month Sales...
Application/theory (excel problem) Problem - Cash Budget The following information pertains to Amigo Corporation: Month Sales Purchases July $60,000 $20,000 August 68,000 24,000 September 76,000 28,000 October 84,000 32,000 November 96,000 36,000 December 120,000 40,000 • Cash is collected from customers in the following manner: Month of sale 40% Month following sale 50% Two months following sale 10% • 50% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month....
Cash Budget Background: Sales for July, August, and September are expected to be $200,000, $210,000, and...
Cash Budget Background: Sales for July, August, and September are expected to be $200,000, $210,000, and $190,000, respectively, for Pasta Company. All sales are on account and are collected 50% in the month of the sale and 45% in the following month. The remaining 5% is determined to be uncollectible. Raw materials are purchased one month before being needed, and all purchases and expenses are paid for as incurred. The cash balance at 8/1/2017 is $8750. Activities for the quarter...
ThinkPad Corporation in the beginning states in the preparation of the cash budget. The company estimates...
ThinkPad Corporation in the beginning states in the preparation of the cash budget. The company estimates cost of goods sold are 60% of sales.  The merchandise purchases are required to be acquired during the month preceding the month of the sales.  ThinkPad Corporation pays 60% in the month of the purchase and the remaining the following month.  The Controller estimates wages are 20% of sales and are paid in the month of the sale. The company incurs other operating expenses approximating 10% of...
Little Flower Establishment would like to prepare a cash budget for July and August. The following...
Little Flower Establishment would like to prepare a cash budget for July and August. The following information has been gathered:        (i) Cash balance as of July 1: $ 1,440,000        (ii) Forecasted sales are as follows:                                                       May                June               July             August Cash sales............................ $1,600,000    $ 1,920,000    $ 1,920,000    $ 1,920,000 Credit sales..........................  1,280,000      1,440,000       1,600,000       1,920,000 Total..................................... $ 2,880,000    $ 3,360,000     $ 3,520,000     $ 3,840,000        (iii) Credit sales are collected 40% in the month of the sale, 35%...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April...
Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for...
Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2017: April May June Credit sales $ 327,000 $ 307,000 $ 367,000 Credit purchases 135,000 158,000 183,000 Cash disbursements Wages, taxes, and expenses 44,700 12,200 63,700 Interest 11,700 11,700 11,700 Equipment purchases 87,000 164,000 0    The company predicts that 5 percent of its credit sales will never be collected, 25 percent of its sales will be collected in the...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 35%...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 35% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 40%...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 40% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August...
The following information is from Tejas WindowTint’s financial records. Month Sales Purchases April $ 81,000 $...
The following information is from Tejas WindowTint’s financial records. Month Sales Purchases April $ 81,000 $ 48,000 May 66,000 44,000 June 63,000 32,000 July 72,000 50,000 Collections from customers are normally 66 percent in the month of sale, 18 percent in the month following the sale, and 14 percent in the second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takes full advantage of the 3 percent discount allowed on purchases...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT