(Answered) Piano man inc has a 32 day average collection period and

Finance

Piano Man, Inc, has a 32 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 receivable balance of $218 million and has developed the following sales and cash disbursement budgets in millions:

Q1 Q2. Q3 Q4

Sales $378. $468. $570. $522

total cash disbursement $318. $408. $726. $450

Complete the following cash budget for the company. What conclusiorns do you draw?

Q1 Q2 Q3

Beginning receivables

Sales

Cash collections

Ending receivables

Total cash collections

Total cash disbursement

Net cash inflow

Beginning cash balance

Net cash inflow

Ending cash balance

Minimum cash balance

Cumulative surplus (deficit)

Please answer and explain.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92530152
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Stock in the abc corporation was contributed to the london

Stock in the ABC Corporation was contributed to the London School of Economics and Business, a public school in the United Kingdom. The basis in the stock was $1,000, but its fair market value was $1,500 at the time of t ...

Interest rates and arbitragethe treasurer of a major us

Interest Rates and Arbitrage The treasurer of a major U.S. firm has $30 million to invest for three months. The interest rate in the United States is .31 percent per month. The interest rate in Great Britain is .34 perce ...

What is the comparison and contrast between ethical

What is the comparison and contrast between ethical leadership and unethical leadership qualities in an ethnically diverse and multicultural workplace in terms of project management. What is an example of each qualities?

Questions -q1 circuit city stores cc recently paid a 16

Questions - Q1: Circuit City Stores (CC) recently paid a $.16 dividend. The dividend is expected to grow at a 23 percent rate. At the current stock price of $7.96, what is the return shareholders are expecting? Q2:Helm I ...

What is the value of an investment that pays 25000

What is the value of an investment that pays $25,000 every other year forever, if the first payment occurs one year from today and the discount rate is 9 percent compounded daily? What is the value today if the first p ...

Prepare a amortization schedule for a five-year loan of

Prepare a amortization schedule for a five-year loan of $71,000. The interest rate is 7 percent per year, and the loan calls for equal annual payments. YEAR BEGINNING BALANCE TOTAL PAYMENT INTEREST PAYMENT PRINCIPAL PAYM ...

1 consider an investment which has the following cash

1. Consider an investment which has the following cash flows: Year Cash flow ($) 0 (31,000) 1 10,000 2 20,000 3 10,000 4 10,000 5 5,000 Compute the: (a) payback period; (b) NPV at 14 percent cost of capital; and (c) IRR. ...

How people in midlife or late adulthood can enhance optimal

How people in midlife or late adulthood can enhance optimal aging?

Asset management ratios corn products corp ended the year

Asset Management Ratios Corn Products, Corp. ended the year 2008 with an average collection period of 32 days. The firm's credit sales for 2008 were $10.7 million. What is the year-end 2008 balance in accounts receivable ...

Fools gold jewelry has just paid a stock dividend of 150

Fools Gold Jewelry has just paid a stock dividend of $1.50. Over the next 3 years, Fools Gold plans to increase their dividend by 10% each year. Beginning in year 4 Fools Gold will decrease their dividend to 5% growth fo ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert