Question

Cash Budget Beginning cash balance Plus: Cash collections Cash available Less: Cash payments Purchases of direct materials Operating expenses Capital expenditures Ending cash balance Aug $34,000 $8,000 $11,000 $51,000 $51,000 45,000 85,000 $59,000 $56,000 36,000 9,000 1,000 40,000 30,000 30,800 7,400 $8,000 $11,000 $6,800 1,000 9,000 Subsequently, the marketing department revised its figures for cash collections. New data are as follows: $53,000 in July $56,000 in August, and $43,000 in September. Based on the new data, calculate the new projected cash balance at the end of September. OA. $6,800 ? B. $18,000 O C. $11,800 OD, $10,000
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Calculate new project cash balance :

Jul Aug Sep
Beginning cash balance 34000 10000 18000
Cash collection 53000 56000 43000
Cash available 87000 66000 61000
Less; Cash payment
Purchase of direct material 36000 9000 11000
Operating expense 40000 30000 30800
Capital expense 1000 9000 7400
Ending cash balance 10000 18000 11800

So answer is c) $11800

Add a comment
Know the answer?
Add Answer to:
Cash Budget Beginning cash balance Plus: Cash collections Cash available Less: Cash payments Purchases of direct...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • a) Underline the main components which are considered while preparing a budget in a Company. What...

    a) Underline the main components which are considered while preparing a budget in a Company. What are the major considerations business owners should make as they budget and forecast? b) Prepare a Cash budget for the Quarter April To June based on the following data and additional information. Month Sales($) Purchase($) Wages($) Overheads($) Jan 60,000 36,000 9,000 10,000 Feb 62,000 38,000 8,000 9,500 Mar 64,000 33,000 10,000 11,500 Apr 58,000 35,000 8,500 9,000 May 56,000 39,000 9,000 9,500 Jun 60,000...

  • A. ABC Industries is in the Business of manufacturing agro equipment. Prepare the cash budget for...

    A. ABC Industries is in the Business of manufacturing agro equipment. Prepare the cash budget for the quarter April to June, based upon the following data and additional information. Month Sales Purchases Wages Selling Overheads Office Overheads Mfg. Overheads $ $ $ $ $ $ January 60,000 36,000 9,000 4,000 2,000 4,000 February 62,000 38,000 8,000 5,000 1,500 3,000 March 64,000 33,000 10,000 4,500 2,500 4,500 April 58,000 35,000 8,500 3,500 2,000 3,500 May 56,000 39,000 9,000 4,500 1,000 4,000...

  • Supplements Plus, Inc. Income Statement Year Ended September 30, 2018 Net Sales Revenue $ 230,000 Cost...

    Supplements Plus, Inc. Income Statement Year Ended September 30, 2018 Net Sales Revenue $ 230,000 Cost of Goods Sold 93,000 Gross Profit 137,000 Operating Expenses: Salaries Expense $ 57,000 Depreciation Expense Plant Assets 28,000 Total Operating Expenses 85,000 Net Income Before Income Taxes 52,000 Income Tax Expense 8,000 $ Net Income 44,000 c. a. Acquisition of plant assets is $118,000. Of this amount, $105,000 is paid in cash and $13,000 by signing a note payable. b. Cash receipt from sale...

  • CARLA VISTA COMPANY Cash Budget January February Beginning cash balance 60650 Add : Cash receipts Collections...

    CARLA VISTA COMPANY Cash Budget January February Beginning cash balance 60650 Add : Cash receipts Collections from customers 85650 160650 Sale of short-term investments 12610 Click if you would like to Show Work for this question: Open Show Work Exercise 7-14 Carla Vista Company expects to have a cash balance of $60,650 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $85,650, February $160,650. 2. Payments...

  • Shorstein Manufacturing Company purchases raw materials on account each month. Purchases are paid for according to...

    Shorstein Manufacturing Company purchases raw materials on account each month. Purchases are paid for according to the following schedule: 30% is paid in the month of the purchase 60% is paid in the month following the purchase 10% is paid in the second month following the purchase Budgeted purchases are as follows: March $75,000 April $90,000 May $85,000 How much will be reported for Accounts Payable for material purchases as of the end of May? $59,500 O $68,500 $87,000 $95,500...

  • Exercise 216 Holcomb Company expects to have a cash balance of $43,000 on January 1, 2017....

    Exercise 216 Holcomb Company expects to have a cash balance of $43,000 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $85,000, February $132,000 2. Payments to suppliers: January $40,000, February $50,000 * Wages: January $34,000, February $40,000. Wages are paid in the month they are incurred. Administrative expenses: January $24,000, February $31,000. These costs include depreciation of $1,000 per month. All other costs are paid...

  • Prepare a cash flow statement using both the direct and the Indirect methods. Preparing a Statement...

    Prepare a cash flow statement using both the direct and the Indirect methods. Preparing a Statement of Cash Flows (Indirect Method) Dair Company's income statement and comparative balance sheets follow. LO3, 4 DAIR COMPANY Income Statement For Year Ended December 31, 2013 Sales Cost of goods sold Wages and other operating expenses Depreciation expense. Amortisation expense. Interest expense Income tax expense Loss on bond retirement. $700,000 $440,000 95,000 22,000 7,000 10,000 36,000 5,000 615,000 $ 85,000 Net income. . DAIR...

  • From owner's capital and down which selection is credit and debit D&G Catering Company Trial Balance...

    From owner's capital and down which selection is credit and debit D&G Catering Company Trial Balance September 30th, 2020 Credit $ Debit 54,000 48,000 317,000 30,000 70,000 19,000 270,000 12,000 48,000 36,000 4,000 5,000 20,000 8,000 24,000 Cash Land Equipment Short Term Investment Inventory Trademark Building Franchise Account Receivable Delivery Van Interest Receivable Office Supplies PREPAID LEGAL EXPENSES PREPAID ADVERTISING EXPENSE UNEARNED CATERING REVENUE ACCOUNTS PAYABLE MORTGAGE PAYABLE SALARY PAYABLE INCOME TAX PAYABLE NOTES PAYABLE Owner's Capital Owner's Drawing CATERING...

  • The following additional data were provided: 1. Dividends declared and paid were $35,000. 2. During the...

    The following additional data were provided: 1. Dividends declared and paid were $35,000. 2. During the year equipment was sold for $17,000 cash. This equipment cost $28,000 originally and had a book value of $17,000 at the time of sale. 3. All depreciation expense is in the operating expenses. 4. All sales and purchases are on account. 5. Accounts payable pertain to merchandise suppliers. 6. All operating expenses except for depreciation were paid in cash. Prepare a statement of cash...

  • The income statement and additional data of Supplements Plus, Inc. follow: (Click the icon to view...

    The income statement and additional data of Supplements Plus, Inc. follow: (Click the icon to view the income statement.) i (Click the icon to view the additional data.) Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. Use the transaction references in Panel B when selecting the transaction references in Panel Alf a box is not used in the spreadsheet, leave the box emoty: do not select a label...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT