Prepare a cash budget for sharpe covering

Assignment Help Financial Management
Reference no: EM13814040

The Sharpe Corporation's projected sales for the first 8 months of 2014:

January $190,000

February $120,000

March $135,000

April $240,000

May $300,000

June $270,000

July $225,000

August $150,000

Of Sharpe's sales, 10 percent is for cash, another 60 percent is collected in the month following the sales, and 30 percent is collected in the second month following sales. November and December sales for 2010 were $220,000 and $175,000 respectively.

Sharpe purchases its raw materials 2 months in advance of its sales. The purchases are equal to 60 percent of the final sales price of Sharpe's products. The supplier is paid 1 month after it makes a delivery. For example, purchases for April sales are made in February, and payment is made in March.

In addition, Sharpe pays $10,000 per month for rent and $20,000 each month for other expenditures. Tac prepayments of $22,500 are made each quarter, beginning in March.

The company's cash balance on December 31, 2013, was $22,000. This is the minimum balance the firm wants to maintain. Any borrowing that is needed to maintain this minimum is paid off in the subsequent month if there us sufficient cash. Interest on short-term loans (12 percent) is paid monthly. Borrowing to meet estimated monthly cash needs takes place at the beginning of the month. Thus, if in the month of April the firm expects to have a need for an additional $60,500, these funds would be borrowed at the beginning of April with interest of $605 (.12*1/12*$60,500) owed for April and paid at the beginning of May.

a. Prepare a cash budget for Sharpe covering the first 7 months of 2014.

b. Sharpe has $ 200,000 in notes payable due in Jult that must be repaid or renegotiated for an extension. Will the firm have ample cash to repay the notes?

Reference no: EM13814040

Questions Cloud

Underlying asset price is above the strike price : A Answer option has a zero intrinsic value; that is, for a call option, the underlying asset price is below the strike price. or for a put option, the underlying asset price is above the strike price.
Roughly evenly split between credit and cash sales : On March 31, 2013, Mike's Bike Shop had an outstanding accounts receivable of $19,000. Mike's sales are roughly evenly split between credit and cash sales, with the credit sales collected half in the month after the sale and the remainder 2 months af..
Consider the following hypothesis test : A sample of 100 yields x ¯ = 24. The population standard deviation is 12. If a = .05, find the acceptance/rejection region H_0 and determine if you accept or reject the hypothesis H_0 (Draw graph!).
Make sure the products they produce are safe : Pharmaceutical companies perform tests to make sure the products they produce are safe. One test is to make sure that the drugs has 100% potency, so the mean is 100%. Let's say for a particular tablet product that the production process has a populat..
Prepare a cash budget for sharpe covering : Of Sharpe's sales, 10 percent is for cash, another 60 percent is collected in the month following the sales, and 30 percent is collected in the second month following sales. November and December sales for 2010 were $220,000 and $175,000 respectively..
Low-end roadmaster tire brand with anew advertising : Firebrick Tire Company wants to increase sales of its long running, low-end Roadmaster Tire brand with anew advertising campaign promoting they will last at least 28,000 miles [Mu=28,000 miles].  Tests with arandom sample [n=30 tires] show a sample m..
Calculating free cash flows : Calculating free cash flows) Double meat Palace is considering a new plant for a temporary customer, and its finance department has determined the following characteristics. The company owns much of the plant and equipment to be used for the product.
The average number of days absent per term : A random sample of [n=64 children] of working mothers showed that they were absent from school a sample average of [x=5.3] days per term, with a standard deviation [s=1.8 days].  Provide a 96% confidence interval for the average number of days absent..
What are the expected values for each alternative : What are the expected values for each alternative? What decision should be made under expected value? What is the EVPI?

Reviews

Write a Review

Financial Management Questions & Answers

  Choose one 1 of the following ceos for this assignment

choose one 1 of the following ceos for this assignment larry page google tony hsieh zappos gary kelly southwest

  Valuation of a constant growth stock

A stock is expected to pay a dividend of $3.00 the end of the year (that is, D1 = $3.00), and it should continue to grow at a constant rate of 4% a year. If its required return is 14%, what is the stock's expected price 1 year from today? Round your ..

  Customers to interact with your organization

Which of these key organizational behaviors helps customers to interact with your organization?

  What is the return on the preferred stock

What is the value of a common stock if the firm's earnings and dividends are growing annually at 10%, the current dividend is $1.32, and investors require a 15% return on investment? What is the stock's rate of return if the market price of the stock..

  Exterior walls of a certain poultry processing plant

The heat loss through the exterior walls of a certain poultry processing plant is estimated to cost the owner $2,800 next year. A salesman from Superfiber Insulation, Inc., has told you, the plant engineer, that he can reduce the heat loss by 80% wit..

  Consider a project that has expected net cash flows

Consider a project that has expected Net Cash Flows of $25,000 in each of the 5 years of the project. The project has a Net Investment of $80,000. Given this, what is the IRR?

  Calculate the degree of operating leverage

Deci-Bell, Inc. is producing new headphones. Deci-Bell Inc. has a base level of sales of 312,464 units. Sales price per unit is $148.61 and variable cost per unit is $61.52. Total annual operating fixed costs are $6,294,441.

  Investigate the realistic assumptions for your location

Investigate the realistic assumptions for your location and include the information you found in the analysis. Create a paper in one page paper.

  1 the eurusd spot exchange rate is quoted as 132250-132267

1. the eurusd spot exchange rate is quoted as 1.32250-1.32267. how many eur are needed to purchase 100000000 usd on

  What types of products category

Choose a product from the list. Name and describe the product category below. What types of products are included? Breakfast Cereal, Dairy products, Footwear.

  Important you have joined zurich pvt ltd as a finance

you have joined zurich pvt. ltd as a finance manager. you are given the following information zurich pvt ltd. is a

  Both firms sell 10000 units of output at 250 per unit the

1. firm a has 10000 in assets entirely financed with equity. firm b also has 10000 in assets but these assets are

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