Question

A firm has estimated the two-month cash budget below. What is the cash surplus or deficit...

A firm has estimated the two-month cash budget below. What is the cash surplus or deficit for these two months? (Enter your answers in millions of dollars.)

($ in millions) March April
Sales 93.0 86.0
Cash collection 81.0 83.0
Total cash disbursement 69.0 66.0
Net cash flow 12.0 17.0
Cumulative net cash flow 29.0
Minimum cash balance 20.0 20.0
Cash surplus or deficit
0 0
Add a comment Improve this question Transcribed image text
Answer #1

April's Cumulative net cash flow = March's Cumulative net cash flow + Net Cash Flow

= 29 + 17 = $46 million

March Cash Surplus or Deficit = Cumulative net cash flow - Minimum cash balance

= 29 - 20 = $9 million

April Cash Surplus or Deficit = Cumulative net cash flow - Minimum cash balance

= 46 - 20 = $26 million

Add a comment
Know the answer?
Add Answer to:
A firm has estimated the two-month cash budget below. What is the cash surplus or deficit...
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
  • Piano Man, Inc., has a 40-day average collection period and wants to maintain a minimum cash balance of $30 million, which is what the company currently has on hand. The company currently has a r...

    Piano Man, Inc., has a 40-day average collection period and wants to maintain a minimum cash balance of $30 million, which is what the company currently has on hand. The company currently has a receivables balance of $194 million and has developed the following sales and cash disbursement budgets in millions: Q1 02 3 Q4 $423 S495 $576 $540 322 440 686 445 Sales Total cash disbursement Complete the following cash budget for the company. (A negative answer should be...

  • 15. Calculating the Cash Budget (L03) Cottonwood Inc. has estimated sales (in millions) for the next...

    15. Calculating the Cash Budget (L03) Cottonwood Inc. has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 03 04 $160 $175 $190 $215 Click here for a description of Table: Questions and Problems 15. Sales for the first quarter of the year after this one are projected at $170 million. Accounts receivable at the beginning of the year were $68 million. Cottonwood has a 45 day collection period Cottonwood's purchases from suppliers in a quarter...

  • 5. Cash budget The cash budget is considered the primary forecasting tool when firms try to...

    5. Cash budget The cash budget is considered the primary forecasting tool when firms try to estimate their cash flows and figure out if they are likely to need additional cash flows or to generate surplus cash. Consider the case of Mooney Equipment: 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...

  • please answer b1 and b2 Wildcat, Inc., has estimated sales (in millions) for the next four...

    please answer b1 and b2 Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2   Q3   Q4   Sales $ 155 $ 175 $ 195 $ 225 Sales for the first quarter of the year after this one are projected at $170 million. Accounts receivable at the beginning of the year were $67 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next...

  • Cash is King! Good cash management is an essential job of the financial manager! You own...

    Cash is King! Good cash management is an essential job of the financial manager! You own a small auto sales business called King Kars. You stock up on inventory in February, April, June, and September. Your annual cash budget indicates that your MONTHLY NET CASH for the year will be the following: JAN $5,000 FEB -$30,000 MAR $20,000 APRIL -$35,000 MAY $25,000 JUNE -$10,000 JULY $25,000 AUG   $25,000 SEPT -$30,000 OCT $15,000 NOV $15,000 DEC $25,000 You begin the year...

  • Jason Allen has been working on Vaughn Paints' cash budget for the coming year. Based on...

    Jason Allen has been working on Vaughn Paints' cash budget for the coming year. Based on his projections for March, the beginning cash balance will be $45,700; cash collections will be $520,000; and cash disbursements will be $554,000. Vaughn Paints desires to maintain a $40,000 minimum cash balance. The company has a 6% open line of credit with its bank, which provides short-term borrowings in $500 increments. All borrowings are made at the beginning of the month, and all repayments...

  • The cash budget is considered the primary forecasting tool when firms try to estimate their cash...

    The cash budget is considered the primary forecasting tool when firms try to estimate their cash flows and figure out if they are likely to need additional cash flows or to generate surplus cash Consider the case of Mooney Equipment: 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...

  • Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Sales Q1...

    Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Sales Q1 $120 Q2 $140 Q3 $160 Q4 $190 Sales for the first quarter of the year after this one are projected at $135 million. Accounts receivable at the beginning of the year were $53 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 40 percent of the next quarter's forecast sales, and suppliers are normally paid in...

  • Wildcat, Inc., has estimated sales in millions) for the next four quarters as follows: Sales Q1...

    Wildcat, Inc., has estimated sales in millions) for the next four quarters as follows: Sales Q1 $120 Q2 Q3 Q4 $140 $160 $190 Sales for the first quarter of the year after this one are projected at $135 million. Accounts receivable at the beginning of the year were $53 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 40 percent of the next quarter's forecast sales, and suppliers are normally paid in...

  • Can you please show calculations. Wildcat, Inc., has estimated sales (in millions) for the next four...

    Can you please show calculations. Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $200 $220 $240 $270 Sales for the first quarter of the year after this one are projected at $215 million. Accounts receivable at the beginning of the year were $85 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 50 percent of the next quarter's forecast sales, and...

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