Michael's Incorporated expect the following sales: Cash Credit $ 50,000 $ 150,000 $ 55,000 $ 170,000 $ 130,000 $ 24,000 $ 109,000 July August September October November $ 29,000 $ 34,000 $ 200,000 The cash budget is being developed, and the accountant is computing the projected cash collections. He notices a pattern: 45% collected in the month of sale; 35% collected the next month; and 20% collected the following month. The Accounts Receivable balance on July 1 was $71,000, which Includes $55,000 of June's sales and $16,000 of May's sales. Compute the projected Accounts Receivable balance on November 30:

Michael's Incorporated expect the following sales: Cash Credit $ 50,000 $ 150,000 $ 55,000 $ 170,000 $ 130,000 $ 24,000 $ 109,000 July August September October November $ 29,000 $ 34,000 $ 200,000 The cash budget is being developed, and the accountant is computing the projected cash collections. He notices a pattern: 45% collected in the month of sale; 35% collected the next month; and 20% collected the following month. The Accounts Receivable balance on July 1 was $71,000, which Includes $55,000 of June's sales and $16,000 of May's sales. Compute the projected Accounts Receivable balance on November 30:

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

You are hired as a financial manager and your first task is to establish the cash budget of your firm.You gathered the following information. The firm receives all income from sales•Sales estimates (in millions)* Quarter1 = 1,000; Quarter2 = 1,250; Quarter3 = 1,500; Quarter4 = 2,000; Quarter1 next year = 1,200• Accounts receivable* Beginning receivables = $3000* Average collection period = 45 days• Accounts payable* Purchases = 60% of next quarter’s sales* Beginning payables = 1,200* Accounts payable period is 45 days• Other expenses*Wages, taxes, and other expense are 25% of sales*Interest and dividend payments are $100*A major capital expenditure of $500 is expected in the second quarter•The initial cash balance is $100 and the company maintains a minimum balance of $50 1) Required: establish the cash budget of the firm.
You are hired as a financial manager and your first task is to establish the cash budget of your firm.You gathered the following information: The firm receives all income from sales•Sales estimates (in millions)* Quarter1 = 1,000; Quarter2 = 1,250; Quarter3 = 1,500; Quarter4 = 2,000; Quarter1 next year = 1,200• Accounts receivable* Beginning receivables = $3000* Average collection period = 45 days• Accounts payable* Purchases = 60% of next quarter’s sales* Beginning payables = 1,200* Accounts payable period is 45 days• Other expenses*Wages, taxes, and other expense are 25% of sales*Interest and dividend payments are $100*A major capital expenditure of $500 is expected in the second quarter•The initial cash balance is $100 and the company maintains a minimum balance of $50
(Short-Term Finance and Planning) You are hired as a financial manager and your first task is to establish the cash budget of your firm. You gathered the following information. The firm receives all income from sales Sales estimates (in millions) Q1 = 1,000; Q2 = 1,250; Q3 = 1,500; Q4 = 2,000; Q1 next year = 1,200 Accounts receivable Beginning receivables = $3000 Average collection period = 45 days Accounts payable Purchases = 60% of next quarter’s sales Beginning payables = 1,200 Accounts payable period is 45 days Other expenses Wages, taxes, and other expense are 25% of sales Interest and dividend payments are $100 A major capital expenditure of $500 is expected in the second quarter The initial cash balance is $100 and the company maintains a minimum balance of $50
Pacific Place has developed the following sales forecast for the following months. Month Sales May $500,000 June $650,000 July $380,000 August $300,000 The collection policy for customers is: 40 percent in the month of sale 60 percent in the following month after sale How much is the expected total cash collections from customers in June? Multiple Choice $610,000 $260,000 $590,000 $560,000 $300,000
Mooney Equipment is putting together its cash budget for the following year and has forecasted expected cash collections over the next five quarters (one year plus the first quarter of the next year). The cash collection estimates are based on sales projections and expected collection of receivables. The sales and cash collection estimates are shown in the following table (in millions of dollars): Q1 Q2 Q3 Q4 Q5 Sales $1,100 $1,400 $1,450 $1,250 $1,500 Total cash collections $1,100 $1,150 $1,200 $1,200 You also have the following information about Mooney Equipment: • In any given period, Mooney’s purchases from suppliers generally account for 72% of the expected sales in the next period, and wages, supplies, and taxes are expected to be 15% of next period’s sales. • In the third quarter, Mooney expects to expand one of its plants, which will require an additional $1,072 million investment. • Every quarter, Mooney pays $60 million in interest and…
Hurzdan, Inc., has a 50-day average collection period and wants to maintain a minimum cash balance of $35 million, which is what the company currently has on hand. The company currently has a receivables balance of $189 million and has developed the following sales and cash disbursement budgets (in millions): Q2 Sales $450 Total cash disbursement 268 390 Beginning receivables Sales Cash collections Ending receivables Total cash collections Total cash disbursements Net cash inflow Beginning cash balance Net cash inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit) Q1 $378 Complete the following cash budget for the company. (A negative answer should be Indicated by a minus sign. Do not round Intermediate calculations and enter your answers in millions rounded to the nearest whole million dollar amount, e.g., 32.) + Q3 Q4 $531 $495 412 617 Q1 HURZDAN, INC. Cash Budget (in millions) 378 268 Q2 450 390 Q3 531 617 Q4 495 412
Bee Nay has projected sales of 200,000, gross profit rate of 40% and return on sales of 10%. Accounts Receivable is 15% of sales; inventory is 5% of cost of sales. Bee Nay has minimum cash balance of 5,000 and fixed assets of 65,000. What is the total assets requirement?
PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS PLEASE, DO IT IN EXCEL AND SHOW THE FORMULASIn preparing the cash budgeting projected balance method, it is necessary to calculate the amount of the inventory balance. The following information is available for the current fiscal year: Inventory balance, $200,000.00, it is known that the inventory turnover is every 60 days. The Cost of Sales is forecasted to increase 15% for the next fiscal year. What is the budgeted inventory balance
Assume that your credit sales for March was $16,288,for April was $33,301 and May was $29,261. If credit sales are collected 55% during the month of sale, 25% the month following the sale, and 15% in the second month following the sale, what is the total expected cash collections to be received in May? Round your answer to one dollar.
Worthington Company expects that cash sales will be 20% of total sales, credit card sales will be 50% of total sales, and account sales will be 30% of total sales. Credit card sales are collected in the month following the sale, net a 3% credit card fee. This means that if the sale is $100, the credit card company's fee is $3, and Worthington receives $97. Account sales will be collected as follows: 40% in the first month following the sale, 50% in the second month following the sale, 8% in the third month following the sale, and 2% never collected. The following table identifed the projected sales for the first year of operations: Month Sales Month January $12,369,348 July Sales $21,747,839 February 15,936,293 August 14,908,534 March 13,294,309 September 11,984,398 April 19,373,689 October 18,894,535 May 20,957,566 November 21,983,545 June 18,874,717 December 20,408,367 Complete the following statement showing the cash expected each month from the collections of these sales. Round all…
The projected sales for the Leeds Company is given below. The company has determined that all sales are on credit and they do not have any cash sales. For the credit sales, experience tells Leeds they will collect 60% of sales in the quarter of the sale and the remaining 40% is collected the quarter after the sale. The sales in the last quarter of the previous year is $200,000. Qtr 1 Qtr 2 Qtr 3 Qtr 4 Budgeted Sales S600,000 S1,600,000 S800,000 S1,000,000 Leeds need cash to pay for purchases, wages, rent, interest, income taxes, cash dividends, and most other expenses. Leeds Company is a manufacturing company, the material purchases requirement for the next four quarters is given in the following table. Leed Company makes all material purchases on credit. Leed Company will pay for material purchases 80% in the quarter of purchase and 20% in the quarter after the purchase. The materials purchased in the last quarter of previous years is $400,000. Budgeted Material Purchases $250,000…
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done