Complete the given cash budget for the company

Assignment Help Finance Basics
Reference no: EM132032342

Question: 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 Q2 Q3 Q4 Sales $ 423 $ 495 $ 576 $ 540 Total cash disbursement 322 440 686 445 Complete the following cash budget for the company. (A negative answer should be indicated by a minus sign. Enter your answers in millions of dollars, e.g., 32. Do not round intermediate calculations and round your answers to the nearest whole million dollar amount, e.g., 32.) PIANO MAN, INC. Cash Budget (in millions)

Q1 Q2 Q3 Q4

Beginning receivables $ $ $ $

Sales 423 495 576 540

Cash collections Ending receivables $ $ $ $

Total cash collections $ $ $ $

Total cash disbursements 322 440 686 445

Net cash inflow $ $ $ $

Beginning cash balance $ $ $ $ N

et cash inflow Ending cash balance $ $ $ $

Minimum cash balance $ $ $ $

Cumulative surplus (deficit) $ $ $ $

Reference no: EM132032342

Questions Cloud

Find expected return on the market portfolio : Phoenix Solar is expected to pay a dividend of $3.60 in the upcoming year, and their stock is trading in the market today at $60 per share.
Describe the presenting problem in one concise sentence : Describe the presenting problem in one concise sentence. Describe an intervention you would implement to promote resiliency.
How much will be available forever beginning : A philanthropist working to set up a permanent endownment wants to deposit money each year, starting now and making 10 more(i,e., 11) deposits.
How might that have colored your perceptions : Choose a religious community and make contact. You might ask any religious friends or acquaintances of yours for suggestions.
Complete the given cash budget for the company : 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.
What is the equivalent uniform annual worth : Petroleum Drilling, Inc., is considering installation of a new automated drilling equipment. The new equipment can be installed for $11,750,000 today.
How would you assess your socioeconomic status : How would you assess your socioeconomic status based on the measurements we discussed in class?
What is was the phillips curve : What is was the Phillips Curve? If the Fed seeks to exploit the Phillips Curve to stimulate the economy, what difference does it make whether the public forms.
Discuss at least two different such items : Describe (and cite) and discuss at least two different such items. Explain and cite what you have found, and describe how it connects to.

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd