Reference no: EM131913251
15-10 CASH BUDGETING Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017.
May 2016 $180,000
June 180,000
July 360,000
August 540,000
September 720,000
October 360,000
November 360,000
December 90,000
January 2017 180,000
Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the 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 2016 $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 administrative salaries are approximately $27,000 a month. Lease payments under long-term leases are $9,000 a month. Depreciation charges are $36,000 a month. Miscellaneous expenses are $2,700 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 October.
Cash on hand on July 1 will be $132,000, and a minimum cash balance of $90,000 should be maintained throughout the cash budget period.
a. Prepare a monthly cash budget for the last 6 months of 2016.
b. Prepare monthly estimates of the required financing or excess funds-that is, the amount of money Bowers will need to borrow or will have available to invest.
|
How much money should you place in this savings account
: You plan to buy the house of your dreams in 16 years. You have estimated that the price of the house will be $115,559 at that time.
|
|
What is the internal rate of return for the given investment
: What is the net present value (NPV) of this investment? What is the internal rate of return (IRR) for this investment?
|
|
What major learning from the reading
: What was your major learning from the reading, (New Sales. Simplified, by Mike Weinberg chapter 2?
|
|
Types of white collar and business-related crimes
: List, define, and discuss the various types of white collar and business-related crimes discussed in our text book. Then, list and discuss any federal laws
|
|
Prepare monthly estimates of the required financing
: Prepare monthly estimates of the required financing or excess funds-that is, the amount of money Bowers will need to borrow or will have available to invest.
|
|
Place on environmental scanning
: If you were the CEO of an online clothing retailer, how much emphasis would you place on environmental scanning? What major threats do you think this industry
|
|
Determine how much must you invest today
: If you believe your mutual fund can achieve a 12.2 percent annual rate of return and you want to buy the car in 8 years, how much must you invest today?
|
|
Confirmation of the availability
: In the counteroffer, Englesen asked Kepple to remove from their contract a clause requiring written confirmation of the availability of a "free split"
|
|
At what exchange rate will you break-even
: If you pay an option premium of $5,000 to buy this call, at what exchange rate will you break-even?
|