Answered step by step
Verified Expert Solution
Link Copied!

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 ?
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship In Finance Successfully Launching And Managing A Hedge Fund In Asia

Authors: Henri Arslanian

1st Edition

331943912X,3319439138

More Books

Students also viewed these Finance questions