Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you please amswer with formulas in excel ? Plano Mon, Inc., has a 50-day average collection period and wants to maintain a minimum cash
can you please amswer with formulas in excel ?
Plano Mon, 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 $183 million and has developed the following sales and cash disbursement budgets in millions. Sales Total cash disbursement @1 $324 245 Q2 $396 338 Q3 Q4 $477 $441 549 369 Required: Complete the following cash budget for the company. (Do not round Intermediate calculations. Negative amounts should be indicated by o minus sign. Enter your answers in millions of dollars. Round your answers to the nearest whole million dollar amount (e.g. 32).) PIANO MAN, INC Cash Budget (in millions) Q1 S 03 Q4 Q2 S 396 Beginning receivables Sales Cash collections $ 324 477 Ending receivables $ S S Total cash collections Total cash disbursements $ s 245 338 549 369 Net cash inflow S S Beginning cash balance Net cash inflow $ $ S S Ending cash balance Minimum cash balance s $ s s $ S S Cumulative surplus (deficit) 5 $ S S Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started