Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Piano Man, Inc., has a 30-day average collection period and wants to maintain a minimum cash balance of $20 million, which is what the company

image text in transcribed

Piano Man, Inc., has a 30-day average collection period and wants to maintain a minimum cash balance of $20 million, which is what the company currently has on hand. The company currently has a receivables balance of $193 million and has developed the following sales and cash disbursement budgets in millions: Q4 Sales Total cash disbursement Q1 $ 414 352 Q2 $486 439 Q3 $ 567 686 $ 531 434 Required: Complete the following cash budget for the company. (Do not round intermediate calculations. Negative amounts should be indicated by a 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 Q2 $ 486 Q3 $ Beginning receivables Sales Cash collections Q4 $ 531 414 567 00:09 Ending receivables $ $ $ Total cash collections Total cash disbursements 352 439 686 434 Net cash inflow $ $ $ $ Beginning cash balance Net cash inflow Ending cash balance Minimum cash balance AA A A A tA A TA " Cumulative surplus (deficit) $ $ $

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

Contemporary Financial Management

Authors: R. Charles Moyer, William J. Kretlow, James R. Mcguigan

8th Edition

0324065914, 9780324065916

More Books

Students also viewed these Finance questions