Monthly estimates of the required financing of excess funds

Assignment Help Financial Management
Reference no: EM131189004

Cash Budgeting Helen Bowers, owne of Helen's Fashion Designs is planning to the firm of parts of 2014 and 2015

                                                          May 2014        $180,000

                                                           June               $180,000

                                                           July                 $360,000

                                                            August           $540,000

                                                            September     $720,000

                                                            October          $360,000

                                                            November       $360,000

                                                             December      $90,000

                                                            January 2015 $180,000

Estimate regarding payments obtained from the credit deprtment are as gollows: collected within the month of sale, 10%, collected month following the sale 75%, collected the second month following the sale 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials:

                                                                May 2014       $90,000

                                                                June                $90,000

                                                                July                  $126,000

                                                                August             $882,000

                                                                September       $306,000

                                                                October           $234,000

                                                                November       $162,000

                                                                December       $90,000

General and admisnistrative salaries are approimately $27,000 a month. Lease payments uner long-term leases are $9,000 a month. Depreciation charges are $36,000 a month. Miscellaneous expenses are $2700 a month. Income tax payments of $63,000 are due in September and December. A progress payment of $180,000 on a new design studio must be paid in Ovtober. Cash on hand on July 1 will be $132,000, and minimum cash balance of $90,000 should be maintained throughout the cash budget pariod.

a. Prepare a monthly cash budget for the last 6 months of 2014

b. Prepare a monthly estimates of the required financing of excess funds-that is the amount of money bowers will need to borrow or will have available to invest.

c. Now suppose receipts from sales come in uniformly during the month (that is cash receipts come in at the rate of 1/30 each day) but all outflows must be paid on the 5th. Will this affect the cash budget? That is will the cash budget you prepared be vaild under these assupmtions? No calculations are required although if you prefer you can use calculations to illustrate the effects.

Reference no: EM131189004

Questions Cloud

What woluld be the amount of additional expense on equitment : What woluld be the amount of additional expense on equitment that would make productivity of the two systems equal.
Lease paymentsunder long-term leases : General and administravitve salaries are approximately $27,000 a month. Lease paymentsunder long-term leases are $9,000 a month. Depreciation charges are $36,000 a month. Miscellaneous expenses are $2700 a month. Income tax payments of $63,000 are du..
What counter measure can be used of offset given effect : In what way can improper incentives lead to lack of coordination in a supply chain?- what counter measure can be used of offset this effect?
Describe how human resources and labor can support : Develop a PowerPoint presentation to identify five areas from the project that you believe will be useful in your future personal, professional, or academic endeavors. Provide a brief rationale for each area.
Monthly estimates of the required financing of excess funds : Estimate regarding payments obtained from the credit deprtment are as gollows: collected within the month of sale, 10%, collected month following the sale 75%, collected the second month following the sale 15%. Prepare a monthly cash budget for the l..
Instances of suspicious intrusive activities : Identify a scenario where two instances of suspicious intrusive activities were detected in a computer information system. The two activities might or might not be of the same type (i.e., spam, phishing, DOS, etc.).
Instances of suspicious intrusive activities : Identify a scenario where two instances of suspicious intrusive activities were detected in a computer information system. The two activities might or might not be of the same type (i.e., spam, phishing, DOS, etc.).
Uses cumulative voting procedures : The shareholders of Motive Power Corp. need to elect three new directors to the board. There are 14, 600,000 shares of common stock outstanding, and the current share price is $10.95. If the company uses cumulative voting procedures, how much will it..
Firm increased its net working capital investment : The 2013 income statement of Southern Products, Inc., showed $3.2 million EBIT, $410,000 depreciation, $500,000 interest expenses, and its tax rate is 34%. If the firm's net capital spending for 2013 was $540,000, and the firm increased its net worki..

Reviews

Write a Review

Financial Management Questions & Answers

  Determine the coupon rate of bond

Dave needs to pay $1000 at the end of each year for the next 3 years. He purchased 3 different annual coupon bonds to match the liabilities exactly. The bonds have the following properties: Determine the coupon rate of Bond B to match the cash flows ..

  Find the financial break-even quantity

Consider a project with the following data: accounting break-even quantity = 5,500 units; cash break-even quantity = 5,000 units; life = eight years; fixed costs = $140,000; variable costs = $22 per unit; required return = 12 percent. Ignoring the ef..

  Calculate the current earnings per share

Calculate the firms EOQ for the item of inventory and what is the firms total cost based upon the EOQ calculated above - Calculate the current earnings per share

  What is the standard deviation of the stock returns

A stock produced returns of 19 percent, 27 percent, and -38 percent over three of the past four years, respectively. The arithmetic average for the past four years is 7 percent. What is the standard deviation of the stock's returns for the four-year ..

  After-tax market rate of return on research

The research and development division of a large corporation is considering the purchase of a new tunneling X-ray microscope for $320,125. The projected net benefits from gains in materials engineering is projected to be $127,000 in today’s real doll..

  General and administrative expenses

Advantage First Corporation has sales of $4,964,060; income tax of $514,886; the selling, general and administrative expenses of $224,035; depreciation of $368,851; cost of goods sold of $2,900,500; and interest expense of $101,207. What is the amoun..

  Credit report-processing and document preparation

A person was considering buying a house priced at $220,000. A mortgage company claimed the interest rate for the 20-year loan is 3.125%. The company also estimated that the points and Appraisal, Credit Report, Processing, Document Preparation. What w..

  What ways might such a perspective be problematic

What ideas/discourses undergirded the ways the various American 'Wests' were created (through purchases, treaties, and acts of war), viewed (in pictures and rhetorically) and realized (through settlement and development)? How might the historical geo..

  Result of implementing the lockbox system

It takes Cookie Cutter Modular Homes, Inc., about six days to receive and deposit checks from customers. Cookie Cutter’s management is considering a lockbox system to reduce the firm’s collection times. What is the reduction in outstanding cash balan..

  The value of a zero-coupon bond with a face value

What is the value of a perpetual bond with a 1,000 face value, a coupon rate of 8% compounded annually, and a required return of 7%? What is the value of a zero-coupon bond with a face value of 10,000, maturing in 20 years with a required return of 5..

  Finding annuity payments-periods and interest rates

You have $51,501.70 in a brokerage account, and you plan to deposit an additional $7,500 at the end of every future year until your account totals $425,000. You expect to earn 8.4% annually on the account. How many years will it take to reach your go..

  Estimate the country equity risk premium

You are trying to estimate the country equity risk premium for Poland. You find that S&P has assigned an A rating to Poland and that Poland has issued euro-denominated Bonds that yield 7.6%. in the market currently.

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