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

  Prepare a loan amortization table

To expand its operation, Amarillo Industries has applied to the Local Bank for a 3-year, $3,500,000 loan. Prepare a loan amortization table assuming 10 percent rate of interest. Be sure to show “payment”; “principal” and “interest” for each year.

  Using straight-line depreciation

Your company is considering a new project that will require $985,000 of new equipment at the start of the project. The equipment will have a depreciable life of 9 years and will be depreciated to a book value of $157,000 using straight-line depreciat..

  Compute the expected balance in accounts receivable

Prepare a schedule of cash collections for May through July and compute the expected balance in Accounts Receivable as of July 31.

  weight used for equity in the computation of Sportss WACC

Sports Corp has 11.5 million shares of common stock outstanding, 6.5 million shares of preferred stock outstanding, and 2.5 million bonds. If the common shares are selling for $26.5 per share, the preferred share are selling for $14.0 per share, and ..

  A bond is purchased for 985557 it is kept for 5 years and

a bond is purchased for 9855.57. it is kept for 5 years and interest is received at the end of each year. immediately

  What growth rate is expected for the companys stock price

The stock price of Webber Co. is $68. Investors require an 11 percent rate of return on similar stocks. If the company plans to pay a dividend of $3.85 next year, what growth rate is expected for the company’s stock price?

  Write a report on evaluation of the models and concepts

write a report on evaluation of the models and concepts proposed outlining their limitations and merits.the report

  Municipal bond with a coupon rate

A municipal bond with a coupon rate of 4.80 percent sells for $4,850 and has five years until maturity. What is the yield to maturity of the bond?

  Determine the magnitude of year 0 investment

Reclamation costs on a project are expected to be incurred over a 30 year period from 27 to 56 years in the future from now. Reclamation costs are estimated to escalate 5.0% per year in the future

  Determine the relationship of each bud­ get line to volume

Explain how each amount in the flexible budget was calculated. (Hint Examine the static budget to determine the relationship of each bud­ get line to volume.)

  What annual savings can aqua system expect

Aqua System Inc. expects to have $18,526,400 in credit sales during the coming year. Currently all checks are sent to the home office. A proposed lockbox system can eliminate 1 days of float, releasing funds which, when invested, will earn 12.10 perc..

  Result of depositing a fixed instalment amount

What factor would you use to determine the future lump sum amount that could be withdrawn from a bank as a result of depositing a fixed instalment amount for "n" years? State its name and show its standard notation.

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