Prepare the Cash Budget assuming: 1. January 1, 2021 cash balance is expected to be $60,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare the Cash Budget assuming: 1. January 1, 2021 cash balance is expected to be $60,000 2. Sales are expected to be collected: a. 60% in the quarter of the sale. b. 25% one quarter after the sale. c. 15% two quarter after the sale. 3. Accounts Receivable of $68,000 at December 31, 2020 are expected to be collected in full, $40,000 in the first quarter and the remaining in the second quarter of 2021. Direct material is expected to be paid: 4. a. 35% in the quarter of purchase. b. 35% one quarter after the purchase. c. 30% two quarter after the purchase. 5. Short term investments are expected to be sold for $5,000 in the second quarter and $3,500 in the third quarter. 6. Long term investment is expected to be sold for $25,000 in the third quarter. 7. Direct labor is 100% paid in the quarter incurred. 8. Manufacturing overhead, all items except depreciation are paid in the quarter incurred. 9. Selling and administrative expenses, all items except depreciation are paid in the quarter incurred. 10. 11. 12 Management plans to purchase a minivan in the fourth quarter for $35,000, and a delivery truck in the third quarter for $10,600. McGregor makes equal quarterly payments of its estimated annual income taxes. Accounts payable of $25,500 at December 31, 2020 are expected to be paid in full in the second quarter. 13. McGregor wishes to maintain a balance of at least $30,000 in cash. 14. Assume interest of $1,000 in the repayment 15. 16. Common Stock are expected to be issued in the fourth quarter for an amount of 20,000. Loans are repaid in the earlier quarter in which there is sufficient cash (that is when the cash on hand exceeds the $30,000 minimum required balance). Prepare the Budgeted Balance Sheet with the information above and the following information: 1. Pertinent data at December 31, 2020 are as follows: a. Building and equipment, $250,000 b. Accumulated depreciation $120,000 c. Common stocks $201,000 d. Retained earnings $230,997.48 2. The accounts that should be in the statements are: a. Cash b. Account receivable c. Finished goods inventory d. Raw material inventory e. Accounts payable f. The accounts mentioned in part 1 of this section. Prepare the Cash Budget assuming: 1. January 1, 2021 cash balance is expected to be $60,000 2. Sales are expected to be collected: a. 60% in the quarter of the sale. b. 25% one quarter after the sale. c. 15% two quarter after the sale. 3. Accounts Receivable of $68,000 at December 31, 2020 are expected to be collected in full, $40,000 in the first quarter and the remaining in the second quarter of 2021. Direct material is expected to be paid: 4. a. 35% in the quarter of purchase. b. 35% one quarter after the purchase. c. 30% two quarter after the purchase. 5. Short term investments are expected to be sold for $5,000 in the second quarter and $3,500 in the third quarter. 6. Long term investment is expected to be sold for $25,000 in the third quarter. 7. Direct labor is 100% paid in the quarter incurred. 8. Manufacturing overhead, all items except depreciation are paid in the quarter incurred. 9. Selling and administrative expenses, all items except depreciation are paid in the quarter incurred. 10. 11. 12 Management plans to purchase a minivan in the fourth quarter for $35,000, and a delivery truck in the third quarter for $10,600. McGregor makes equal quarterly payments of its estimated annual income taxes. Accounts payable of $25,500 at December 31, 2020 are expected to be paid in full in the second quarter. 13. McGregor wishes to maintain a balance of at least $30,000 in cash. 14. Assume interest of $1,000 in the repayment 15. 16. Common Stock are expected to be issued in the fourth quarter for an amount of 20,000. Loans are repaid in the earlier quarter in which there is sufficient cash (that is when the cash on hand exceeds the $30,000 minimum required balance). Prepare the Budgeted Balance Sheet with the information above and the following information: 1. Pertinent data at December 31, 2020 are as follows: a. Building and equipment, $250,000 b. Accumulated depreciation $120,000 c. Common stocks $201,000 d. Retained earnings $230,997.48 2. The accounts that should be in the statements are: a. Cash b. Account receivable c. Finished goods inventory d. Raw material inventory e. Accounts payable f. The accounts mentioned in part 1 of this section. Prepare the Cash Budget assuming: 1. January 1, 2021 cash balance is expected to be $60,000 2. Sales are expected to be collected: a. 60% in the quarter of the sale. b. 25% one quarter after the sale. c. 15% two quarter after the sale. 3. Accounts Receivable of $68,000 at December 31, 2020 are expected to be collected in full, $40,000 in the first quarter and the remaining in the second quarter of 2021. Direct material is expected to be paid: 4. a. 35% in the quarter of purchase. b. 35% one quarter after the purchase. c. 30% two quarter after the purchase. 5. Short term investments are expected to be sold for $5,000 in the second quarter and $3,500 in the third quarter. 6. Long term investment is expected to be sold for $25,000 in the third quarter. 7. Direct labor is 100% paid in the quarter incurred. 8. Manufacturing overhead, all items except depreciation are paid in the quarter incurred. 9. Selling and administrative expenses, all items except depreciation are paid in the quarter incurred. 10. 11. 12 Management plans to purchase a minivan in the fourth quarter for $35,000, and a delivery truck in the third quarter for $10,600. McGregor makes equal quarterly payments of its estimated annual income taxes. Accounts payable of $25,500 at December 31, 2020 are expected to be paid in full in the second quarter. 13. McGregor wishes to maintain a balance of at least $30,000 in cash. 14. Assume interest of $1,000 in the repayment 15. 16. Common Stock are expected to be issued in the fourth quarter for an amount of 20,000. Loans are repaid in the earlier quarter in which there is sufficient cash (that is when the cash on hand exceeds the $30,000 minimum required balance). Prepare the Budgeted Balance Sheet with the information above and the following information: 1. Pertinent data at December 31, 2020 are as follows: a. Building and equipment, $250,000 b. Accumulated depreciation $120,000 c. Common stocks $201,000 d. Retained earnings $230,997.48 2. The accounts that should be in the statements are: a. Cash b. Account receivable c. Finished goods inventory d. Raw material inventory e. Accounts payable f. The accounts mentioned in part 1 of this section. Prepare the Cash Budget assuming: 1. January 1, 2021 cash balance is expected to be $60,000 2. Sales are expected to be collected: a. 60% in the quarter of the sale. b. 25% one quarter after the sale. c. 15% two quarter after the sale. 3. Accounts Receivable of $68,000 at December 31, 2020 are expected to be collected in full, $40,000 in the first quarter and the remaining in the second quarter of 2021. Direct material is expected to be paid: 4. a. 35% in the quarter of purchase. b. 35% one quarter after the purchase. c. 30% two quarter after the purchase. 5. Short term investments are expected to be sold for $5,000 in the second quarter and $3,500 in the third quarter. 6. Long term investment is expected to be sold for $25,000 in the third quarter. 7. Direct labor is 100% paid in the quarter incurred. 8. Manufacturing overhead, all items except depreciation are paid in the quarter incurred. 9. Selling and administrative expenses, all items except depreciation are paid in the quarter incurred. 10. 11. 12 Management plans to purchase a minivan in the fourth quarter for $35,000, and a delivery truck in the third quarter for $10,600. McGregor makes equal quarterly payments of its estimated annual income taxes. Accounts payable of $25,500 at December 31, 2020 are expected to be paid in full in the second quarter. 13. McGregor wishes to maintain a balance of at least $30,000 in cash. 14. Assume interest of $1,000 in the repayment 15. 16. Common Stock are expected to be issued in the fourth quarter for an amount of 20,000. Loans are repaid in the earlier quarter in which there is sufficient cash (that is when the cash on hand exceeds the $30,000 minimum required balance). Prepare the Budgeted Balance Sheet with the information above and the following information: 1. Pertinent data at December 31, 2020 are as follows: a. Building and equipment, $250,000 b. Accumulated depreciation $120,000 c. Common stocks $201,000 d. Retained earnings $230,997.48 2. The accounts that should be in the statements are: a. Cash b. Account receivable c. Finished goods inventory d. Raw material inventory e. Accounts payable f. The accounts mentioned in part 1 of this section. Prepare the Cash Budget assuming: 1. January 1, 2021 cash balance is expected to be $60,000 2. Sales are expected to be collected: a. 60% in the quarter of the sale. b. 25% one quarter after the sale. c. 15% two quarter after the sale. 3. Accounts Receivable of $68,000 at December 31, 2020 are expected to be collected in full, $40,000 in the first quarter and the remaining in the second quarter of 2021. Direct material is expected to be paid: 4. a. 35% in the quarter of purchase. b. 35% one quarter after the purchase. c. 30% two quarter after the purchase. 5. Short term investments are expected to be sold for $5,000 in the second quarter and $3,500 in the third quarter. 6. Long term investment is expected to be sold for $25,000 in the third quarter. 7. Direct labor is 100% paid in the quarter incurred. 8. Manufacturing overhead, all items except depreciation are paid in the quarter incurred. 9. Selling and administrative expenses, all items except depreciation are paid in the quarter incurred. 10. 11. 12 Management plans to purchase a minivan in the fourth quarter for $35,000, and a delivery truck in the third quarter for $10,600. McGregor makes equal quarterly payments of its estimated annual income taxes. Accounts payable of $25,500 at December 31, 2020 are expected to be paid in full in the second quarter. 13. McGregor wishes to maintain a balance of at least $30,000 in cash. 14. Assume interest of $1,000 in the repayment 15. 16. Common Stock are expected to be issued in the fourth quarter for an amount of 20,000. Loans are repaid in the earlier quarter in which there is sufficient cash (that is when the cash on hand exceeds the $30,000 minimum required balance). Prepare the Budgeted Balance Sheet with the information above and the following information: 1. Pertinent data at December 31, 2020 are as follows: a. Building and equipment, $250,000 b. Accumulated depreciation $120,000 c. Common stocks $201,000 d. Retained earnings $230,997.48 2. The accounts that should be in the statements are: a. Cash b. Account receivable c. Finished goods inventory d. Raw material inventory e. Accounts payable f. The accounts mentioned in part 1 of this section. Prepare the Cash Budget assuming: 1. January 1, 2021 cash balance is expected to be $60,000 2. Sales are expected to be collected: a. 60% in the quarter of the sale. b. 25% one quarter after the sale. c. 15% two quarter after the sale. 3. Accounts Receivable of $68,000 at December 31, 2020 are expected to be collected in full, $40,000 in the first quarter and the remaining in the second quarter of 2021. Direct material is expected to be paid: 4. a. 35% in the quarter of purchase. b. 35% one quarter after the purchase. c. 30% two quarter after the purchase. 5. Short term investments are expected to be sold for $5,000 in the second quarter and $3,500 in the third quarter. 6. Long term investment is expected to be sold for $25,000 in the third quarter. 7. Direct labor is 100% paid in the quarter incurred. 8. Manufacturing overhead, all items except depreciation are paid in the quarter incurred. 9. Selling and administrative expenses, all items except depreciation are paid in the quarter incurred. 10. 11. 12 Management plans to purchase a minivan in the fourth quarter for $35,000, and a delivery truck in the third quarter for $10,600. McGregor makes equal quarterly payments of its estimated annual income taxes. Accounts payable of $25,500 at December 31, 2020 are expected to be paid in full in the second quarter. 13. McGregor wishes to maintain a balance of at least $30,000 in cash. 14. Assume interest of $1,000 in the repayment 15. 16. Common Stock are expected to be issued in the fourth quarter for an amount of 20,000. Loans are repaid in the earlier quarter in which there is sufficient cash (that is when the cash on hand exceeds the $30,000 minimum required balance). Prepare the Budgeted Balance Sheet with the information above and the following information: 1. Pertinent data at December 31, 2020 are as follows: a. Building and equipment, $250,000 b. Accumulated depreciation $120,000 c. Common stocks $201,000 d. Retained earnings $230,997.48 2. The accounts that should be in the statements are: a. Cash b. Account receivable c. Finished goods inventory d. Raw material inventory e. Accounts payable f. The accounts mentioned in part 1 of this section. Prepare the Cash Budget assuming: 1. January 1, 2021 cash balance is expected to be $60,000 2. Sales are expected to be collected: a. 60% in the quarter of the sale. b. 25% one quarter after the sale. c. 15% two quarter after the sale. 3. Accounts Receivable of $68,000 at December 31, 2020 are expected to be collected in full, $40,000 in the first quarter and the remaining in the second quarter of 2021. Direct material is expected to be paid: 4. a. 35% in the quarter of purchase. b. 35% one quarter after the purchase. c. 30% two quarter after the purchase. 5. Short term investments are expected to be sold for $5,000 in the second quarter and $3,500 in the third quarter. 6. Long term investment is expected to be sold for $25,000 in the third quarter. 7. Direct labor is 100% paid in the quarter incurred. 8. Manufacturing overhead, all items except depreciation are paid in the quarter incurred. 9. Selling and administrative expenses, all items except depreciation are paid in the quarter incurred. 10. 11. 12 Management plans to purchase a minivan in the fourth quarter for $35,000, and a delivery truck in the third quarter for $10,600. McGregor makes equal quarterly payments of its estimated annual income taxes. Accounts payable of $25,500 at December 31, 2020 are expected to be paid in full in the second quarter. 13. McGregor wishes to maintain a balance of at least $30,000 in cash. 14. Assume interest of $1,000 in the repayment 15. 16. Common Stock are expected to be issued in the fourth quarter for an amount of 20,000. Loans are repaid in the earlier quarter in which there is sufficient cash (that is when the cash on hand exceeds the $30,000 minimum required balance). Prepare the Budgeted Balance Sheet with the information above and the following information: 1. Pertinent data at December 31, 2020 are as follows: a. Building and equipment, $250,000 b. Accumulated depreciation $120,000 c. Common stocks $201,000 d. Retained earnings $230,997.48 2. The accounts that should be in the statements are: a. Cash b. Account receivable c. Finished goods inventory d. Raw material inventory e. Accounts payable f. The accounts mentioned in part 1 of this section. Prepare the Cash Budget assuming: 1. January 1, 2021 cash balance is expected to be $60,000 2. Sales are expected to be collected: a. 60% in the quarter of the sale. b. 25% one quarter after the sale. c. 15% two quarter after the sale. 3. Accounts Receivable of $68,000 at December 31, 2020 are expected to be collected in full, $40,000 in the first quarter and the remaining in the second quarter of 2021. Direct material is expected to be paid: 4. a. 35% in the quarter of purchase. b. 35% one quarter after the purchase. c. 30% two quarter after the purchase. 5. Short term investments are expected to be sold for $5,000 in the second quarter and $3,500 in the third quarter. 6. Long term investment is expected to be sold for $25,000 in the third quarter. 7. Direct labor is 100% paid in the quarter incurred. 8. Manufacturing overhead, all items except depreciation are paid in the quarter incurred. 9. Selling and administrative expenses, all items except depreciation are paid in the quarter incurred. 10. 11. 12 Management plans to purchase a minivan in the fourth quarter for $35,000, and a delivery truck in the third quarter for $10,600. McGregor makes equal quarterly payments of its estimated annual income taxes. Accounts payable of $25,500 at December 31, 2020 are expected to be paid in full in the second quarter. 13. McGregor wishes to maintain a balance of at least $30,000 in cash. 14. Assume interest of $1,000 in the repayment 15. 16. Common Stock are expected to be issued in the fourth quarter for an amount of 20,000. Loans are repaid in the earlier quarter in which there is sufficient cash (that is when the cash on hand exceeds the $30,000 minimum required balance). Prepare the Budgeted Balance Sheet with the information above and the following information: 1. Pertinent data at December 31, 2020 are as follows: a. Building and equipment, $250,000 b. Accumulated depreciation $120,000 c. Common stocks $201,000 d. Retained earnings $230,997.48 2. The accounts that should be in the statements are: a. Cash b. Account receivable c. Finished goods inventory d. Raw material inventory e. Accounts payable f. The accounts mentioned in part 1 of this section.
Expert Answer:
Answer rating: 100% (QA)
1 Cash budget Particulars Quarter 1 Quarter 2 Quarter 3 Quarter 4 Beginning cash balance 60000 10000... View the full answer
Related Book For
Fundamentals of Financial Management
ISBN: 978-0324664553
Concise 6th Edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these accounting questions
-
The real risk-free rate is 3%. Inflation is expected to be 2% this year and 4% during the next 2 years. Assume that the maturity risk premium is zero. What is the yield on 2-year Treasury securities?...
-
The PW value for an alternative is expected to be one of two values based on bids from two vendors. Your office partner told you that the low bid is $3200 per year. If she indicates a chance of 70%...
-
The US inflation rate is expected to be Rs.3 per cent annually and that of India is expected to be 4.5 per cent annually. The current spot rate of US $ in India is Rs.47.4060/US $.Find the expected...
-
a) Verify the above differential equation is not exact. b) Find an integrating factor that will make the differential equation exact. Verify your work. c) Solve the differential equation (implicit...
-
List the main risks auditors will be concerned with in assessing risk in the production and payroll processes of a typical manufacturing business.
-
Block B, with mass 5.00 kg, rests on block A, with mass 8.00 kg, which in turn is on a horizontal tabletop (Fig. 5.72). There is no friction between block A and the tabletop, but the coefficient of...
-
Xpress Delivery Service completed the following transactions and events involving the purchase and operation of equipment for its business: Required Prepare journal entries to record these...
-
For each of the following situations, evaluate the segregation of duties implemented by the company and indicate the following: a. Any deficiency in the segregation of duties described (Indicate None...
-
Determine the graph of the cylinder. x 2 + y = 36 Choose the correct graph of the equation. A. X B. OC. X X Z
-
Davis has the following obligations at December 31, 2025: Note payable due in monthly installments of $50,000, plus interest, through November 30, 2026 Note payable due in monthly installments of...
-
Do you believe that the unionization should be allowed for certain groups of students but not others? For example, student athletes should be allowed but not non-student athletes OR minorities should...
-
Eagles inc. sells products to chiefs inc., and offers rebates based on annual sales volume. specifically, rebates of 3% will be granted if chiefs inc. purchases 1,000 or more units, 4% if 1,500 or...
-
Suppose that the annual expected rates of inflation over each of the next five years are 5%,7%,9%,13% and 12%, respectively.What is the average expected rate of inflation over the 5-year period?
-
Martinez Manufacturing purchased a machine on January 1, 2023 for use in its factory. Martinez paid $578,000 for the machine and estimated that it had a useful life of 10 years, at the end of which...
-
You are saving for retirement. To live comfortably, you decide you will need to save $4,000,000 in your RRSP by the time you are 65. Today is your 34th birthday, and you decide, starting today and...
-
The real risk-free rate of interest is 3%. Inflation is expected to be 2% this year and 4% during the next 2 years. Assume that the maturity risk premium is zero. a. What is the nominal interest rate...
-
Question 1 A manufacturing company, VMTC PLC, makes the product, blitz. Monthly sales for the first five months of 2022 have been estimated as: Additional Information: Month Units January 210 000...
-
a. What is meant by the term tax haven? b. What are the desired characteristics for a country if it expects to be used as a tax haven? c. What are the advantages leading an MNE to use a tax haven...
-
Explain briefly the dividend irrelevance theory that was put forward by Modigliani and Miller. What were the key assumptions underlying their theory?
-
Investors expect a company to announce a 10% increase in earnings; instead, the company announces a 1% increase. If the market is semi-strong form efficient, which of the following would you expect...
-
Walter Industries has $5 billion in sales and $1.7 billion in fixed assets. Currently, the companys fixed assets are operating at 90% of capacity. a. What level of sales could Walter Industries have...
-
Alpha AG is wholly owned by Mr Alpha and Beta AG is wholly owned by Mr Beta. The key figures for the two companies are as follows: Alpha acquires Beta. Calculate the shareholdings (as a percentage)...
-
Can the success of a merger be judged by looking at the change in share price of the companies when the merger is announced?
-
What is the difference between the relative value ratio and the exchange ratio?
Study smarter with the SolutionInn App