Question

Consider the case: Mooney Equipment is putting together its cash budget for the following year and...

Consider the case: 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,430 $1,730 $1,780 $1,580 $1,830
Total cash collections $1,430 $1,480 $1,530 $1,530

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 $55 million in interest and dividend payments to long-term debt and equity investors.

Mooney prefers to keep a minimum target cash balance of at least $14 million at all times.

Using the preceding information, answer the following questions:

1. What is the net cash inflow that Mooney expects in the first quarter (Q2): -$118 million / -$972 million / -$131 million / -$124 million

2. If Mooney is beginning this year with a cash balance of $36 million and expects to maintain a minimum target cash balance of at least $14 million, what will be its likely cash balance at the end of the year (after Q4): -$1,309million / -$219 million / -$95 million / -$1,191million

3. What is the maximum investable funds that the firm expects to have in the next year? -$76million / -$55 million / -$93 million / -$109 million

4. What is the largest cash deficit that the firm expects to suffer in the next year? -$1,323 million / -$926 million / -$662 million / -$794 million

5. If a fr changes its credit policy and allows customers to pay in 90 days instead of 60 days, and everything else remains the same, the net cash flow in the next quarter is likely to decrease  . True / False

Homework Answers

Answer #1
Q1 Q2 Q3 Q4 Q5
Sales 1430 1730 1780 1580 1830
Total cash collections 1430 1480 1530 1530
Purchases (72% of next period) -1246 -1282 -1138 -1318
Wages, salaries, Taxes (15% of next period sales) -260 -267 -237 -275
Investment -1072
Interest -55 -55 -55 -55
Cash Flow -131 -124 -972 -118 0
Opening cash balance 36 -95 -219 -1191
Ending cash balance -95 -219 -1191 -1309
Target cash balance 14 14 14 14
Surplus / Deficit -109 -233 -1205 -1323

1.  Net cash inflow that Mooney expects in the first quarter = - $131 million

2. likely cash balance at the end of the year (after Q4) = -$1309 million

3. Not sure if the options are correct,

Ans: - 118+ 36 = - $82 million

4. Cumulative cash balance = -$1345 million

largest cash deficit that the firm expects to suffer in the next year = -1345 + 36-14 = - $1323 million

5. True

Any doubt please comment.

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
Clarks Italian Ice is creating a sales budget for 2019. For the year, they expect to...
Clarks Italian Ice is creating a sales budget for 2019. For the year, they expect to sell 100,000 cases of popsicles at a price of $20 per case for total budget sales of $2,000,000. For each quarter the budget unit sales are Q1-10,000 ; Q2-30,000; Q3-40,000 ; Q4-20,000. Of the total sales, Clarks Italian Ice expects to collect 70% in the current quarter and the remaining 30% in the following quarter. Desired Units of finished goods inventory is 20% of...
Question 1: Green Company shows the following estimates for unit sales for 2017: Q1 Q2 Q3...
Question 1: Green Company shows the following estimates for unit sales for 2017: Q1 Q2 Q3 Q4 Year Units sold 1,000 1,200 1,250 2,100 5,550 The company expects to sell its goods for $12 per unit. Required: Prepare a sales budget for the year. Additional Information: The company expects to collect 90% of sales in the quarter of the sale, and 8% in the quarter following the sale. 2% of sales are expected to be uncollectible. The company’s beginning accounts...
Axon Corporation, which has three divisions, is preparing its sales budget. Each division expects a different...
Axon Corporation, which has three divisions, is preparing its sales budget. Each division expects a different growth rate because economic conditions vary in different regions of the country. The growth expectations per quarter are 4 percent for Cummings Division, 2 percent for Springfield Division, and 5 percent for Douglas Division. Division First Quarter Second Quarter Third Quarter Fourth Quarter Cummings Division $ 75,000 ? ? ? Springfield Division   125,000 ? ? ? Douglas Division   100,000 ? ? ? Required Complete...
reliable company specializes in home made biscuits and receives all income from sales.. the sales estimates...
reliable company specializes in home made biscuits and receives all income from sales.. the sales estimates (in million $) for the four quarters are as follows Q1 = 600, Q2 = 500, Q3 = 550 and Q4 = 640 The average collection period for the accounts receivables is 45 days. Beginning receivables (Q1 beginning) is $300 million. The purchase are 50% of next quarter sales. Beginning payables (Q1 beginning) is $100 million. The accounts payable period is 45 days. The...
Texas Rex expects the following Cash Receipts in each quarter:                      Q1           &n
Texas Rex expects the following Cash Receipts in each quarter:                      Q1                     Q2                          Q3                          Q4                                               $10,600           $11,850                 $14,775                 $19,625 Texas Rex believes the amount of cash needed for payments on account for raw materials each quarter is:                      Q1                     Q2                          Q3                          Q4                                               $4,594              $5,039                   $6,219                   $6,819 The Cash Budget is critically important to the survival of businesses. It tells management how much cash is available, and shortfalls of cash need to be anticipated and handled through expense reductions...
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget...
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company’s sales are made on account. The following information has been provided by Spicer’s management.    Month Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 428,000 (estimated) April 805,000 (estimated) May 800,000 (estimated)    The company’s collection activity on credit sales historically has been as follows.    Collections in the month of the sale...
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget...
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company’s sales are made on account. The following information has been provided by Spicer’s management.    Month Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 559,000 (estimated) April 584,000 (estimated) May 800,000 (estimated)    The company’s collection activity on credit sales historically has been as follows.    Collections in the month of the sale...
In March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget...
In March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company’s sales are made on account. The following information has been provided by Spicer’s management.    Month Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 593,000 (estimated) April 503,000 (estimated) May 800,000 (estimated)    The company’s collection activity on credit sales historically has been as follows.    Collections in the month of the sale...
The marketing department of Colette Corporation has submitted the following sales forecast for the upcoming fiscal...
The marketing department of Colette Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account, and recorded in Accounts Receivable): 1st quarter 2nd quarter 3rd quarter 4th quarter Budgeted unit sales 10,000 13,000 12,000 15,000 The selling price of the company's product is $15 per unit. Management expects to collect 60% of sales in the quarter in which the sales are made, 35% in the following quarter, and 5% of sales are expected...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,000 12,000 14,000 13,000 The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT