Piano Man, Inc., has a 32-day average collection period and wants to maintain a minimum cash balance
Question:
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 receivables balance of $182 million and has developed the following sales and cash disbursement budgets in millions:
Complete the following cash budget for the company. What conclusions do you draw?
Transcribed Image Text:
Q1 Q2 Q3Q4 Sales S315 S390 $475 $435 Total cash disbursement 265 340 605 375 PIANO MAN, INC. Cash Budget in millions) Q1 Q2 Q3 Beginning receivables Sales Cash collections Ending receivables Total cash collections Total cash disbursements Net cash inflow Beginning cash balance Net cash inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 50% (8 reviews)
Input Area Collection period 32 Minimum cash balance 20 Beginning receivable...View the full answer
Answered By
Simon kingori
I am a tier-one market researcher and content developer who has been in this field for the last six years. I’ve run the freelancing gamut; from market research, data mining and SEO/SMM to copywriting, Content Development, you name it, I’ve done it. I’m extremely motivated, organized and disciplined – you have to be to work from home. My experience in Freelancing is invaluable- but what makes me a cut above the rest is my passion to deliver quality results to all my clients- it’s important to note, I've never had a dissatisfied client. Backed by a Masters degree in Computer Science from MOI university, I have the required skill set and burning passion and desire to deliver the best results for my clients. This is the reason why I am a cut above the rest. Having taken a Bsc. in computer science and statistics, I deal with all round fields in the IT category. It is a field i enjoy working in as it is dynamic and new things present themselves every day for research and exploration.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Essentials of Corporate Finance
ISBN: 978-0078034756
8th edition
Authors: Stephen Ross, Randolph Westerfield, Bradford Jordan
Question Posted:
Students also viewed these Corporate Finance questions
-
Forrester Fashions has annual credit sales of 250,000 units with an average collection period of 70 days. The company has a per-unit variable cost of $20 and a per unit sale price of $30. Bad debts...
-
The Sooner Equipment Company has total assets of $100 million. Of this total, $40 million was financed with common equity and $60 million with debt (both long- and short-term). Its average accounts...
-
Assume that the operation of your business resulted in sales of $730,000 last year. Year-end receivables are $100,000. You are considering factoring the receivables to raise cash to help finance your...
-
In September, Larson Inc. sold 45,000 units of its only product for $438,000, and incurred a total cost of $405,000, of which $43,000 was fixed costs. The flexible budget for September showed total...
-
Consider again the setting of Problem 19. Now that you realize your best investment is to prepay your student loan, you decide to prepay as much as you can each month. Looking at your budget, you can...
-
The balance sheet and statement of profit or loss for Coconut Plantations Pty Ltd are presented below. The weighted average cost of capital is 15 percent. Required Calculate the EVA.
-
Limestone Corporation is a C corporation that uses the calendar year as its tax year. Its employer identification number is 44-1357913. Limestone is located at 234 Main Street, Anytown, New York...
-
A rower wants to row her kayak across a channel that is 1400 ft wide and land at a point 800 ft upstream from her starting point. She can row (in still water) at 7 ft/s and the current in the channel...
-
what is Culture and it's related things?
-
There is a lottery with n coupons and n people take part in it. Each person picks exactly one coupon. Coupons are numbered consecutively from 1 to n, n being the maximum ticket number. The winner of...
-
Calvani, Inc., has a cash cycle of 38.7 days, an operating cycle of 57.5 days, and an inventory period of 21.4 days. The company reported cost of goods sold in the amount of $430,000, and credit...
-
In exchange for a $400 million fixed commitment line of credit, your firm has agreed to do the following: 1. Pay 1.6 percent per quarter on any funds actually borrowed. 2. Maintain a 5 percent...
-
Healthful Foods Inc., a manufacturer of breakfast cereals and snack bars, has experienced several years of steady growth in sales, profits, and dividends while maintaining a relatively low level of...
-
The mean defined in the text is sometimes called the arithmetic mean to distinguish it from other possible means. For example, a different mean, called the geometric mean (G.M.), is used in business...
-
Read the man page or other documentation for the Unix/Windows utility netstat. Use netstat to display the current IP routing table on your host. Explain the purpose of each entry. What is the...
-
Suppose two learning bridges B1 and B2 form a loop as shown in Figure 3.50 and do not implement the spanning tree algorithm. Each bridge maintains a single table of address, interface pairs. (a) What...
-
What properties of postal addresses would be likely to be shared by a network addressing scheme? What differences might you expect to find? What properties of telephone numbering might be shared by a...
-
One of the purposes of TIME_WAIT is to handle the case of a data packet from a first incarnation of a connection arriving very late and being accepted as data for the second incarnation. (a) Explain...
-
The following account balances were included in the trial balance of J.R. Reid Corporation at June 30, 2008. The Retained Earnings account had a balance of $337,000 at July 1, 2007. There are 80,000...
-
Determine the values of the given trigonometric functions directly on a calculator. The angles are approximate. tan 0.8035
-
Suppose the real rate is 1.9 percent and the inflation rate is 3.4 percent. What rate would you expect to see on a Treasury bill?
-
Suppose you buy a 7 percent coupon. 20-year bond today when it's first issued. If interest rates suddenly rise to 15 percent, what happens to the value of your bond? Why?
-
Suppose the following bond quote for IOU Corporation appears in the financial page of today's newspaper. Assume the bond has a face value of $1,000, and the current date is April 15, 2016. What is...
-
Suppose you want to move out of your apartment and buy a small house. Let s assume that your income is $ 3 9 , 6 0 0 a year, your student loans cost $ 2 5 0 per month, and your car payment is $ 3 2 5...
-
An investor purchased a corporate bond for $ 9 1 5 . The bond pays 3 . 7 5 % interest and matures this year. Calculate the current yield on the bond investment at the time of purchase. Determine the...
-
There's an old cliche that says you can't inspect quality into a product. Similarly, can assessment instruments like CEAI assess or induce innovation into organizations?" Someone wrote in regards to...
Study smarter with the SolutionInn App