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

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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