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

  Efficient market hypothesis

Provide a description of the three forms of the Efficient Market Hypothesis using the picture below.  Do you think the markets are efficient?

  What is total opportunity cost for the class

Josh has decided to take a course at the local community college that could help him get a promotion at work. The course begins at 5 p.m. and goes until 9 p.m. on Monday nights. Josh normally works until 5 p.m. each day, but because of the drive time..

  Considering is expected to generate an operating cash flow

A new project you are considering is expected to generate an operating cash flow of $45,620 and will initially free up to 22,000 in net working capital. purchases of fixed assets costing 68,800 will be required to start up the project. what is the to..

  1 suppose that the market contains three stocks a b and c

1. suppose that the market contains three stocks a b and c and two systematic risk- factors 1 and 2 that have the

  What is the after-tax of capital to walgreen for the bonds

The Walgreen Corporation is contemplating a new investment that it plans to finance using one-third debt. The firm can sell new $1000 par value with a 15-year maturity at a price of $953 that carry a coupon interest rate of 12.1 percent that is paid ..

  Brown ltd operates outdoor amusement centres in a number of

brown ltd operates outdoor amusement centres in a number of country towns. the company has decided to build another

  Business are setting the price on a new service

Assume that manager of a business are setting the price on a new service. Relevant data estimates: variable cost per visit: $5.00, Annual direct fixed costs: $500,000, Annually overhead allocation: $50,000, Expected annual utilization 10,000 visits i..

  Calculate tax paid on gain on disposal

Genetic insights co. Purchases an asset for $12752. This qualifies as a seven-year recovery asset under MACRS. The seven-year fixed depreciation percentages for years 1, 2, 3, 4, 5, and 6 are 14.29%, 24.49%, 17.49%, 12.49%, 8.93%, and 8.93%, respecti..

  Make earnings per share

Jackson Inc. and Simon are two identical firms operating in identical markets. Jackson is unlevered with assets valued at $3,000 and has 175 shares of stock outstanding. Simon also has $3,000 in assets and has $1,200 in debt financed at an interest r..

  Callable feature affect the required rate of return

Suppose that Acme Inc. is issuing 10-year bonds that are not callable. The required rate of return that the firm must pay to bondholders is 10%. They are also considering some callable bonds, which are identical to the proposed issue, but will be cal..

  What is the implied discount rate

If the future value of an annuity due is $25,000 and $24,000 is the future value of an ordinary annuity that is otherwise similar to the annuity due, what is the implied discount rate?

  What price would the investor receive a margin call

Suppose that an investor sells 400 shares short at $50 per share. The initial margin is 50% and the maintenance margin is 30%. After 125 days, the investor purchases the shares for $40 and closes the short position. At what price would the investor r..

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