Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

Create for the cash budget: Sharpe Corporation’s proposed sales for first 8 months of 2011 are given below:

January $190,000 May $300,000
February $120,000 June 270,000
March 135,000 July 225,000
April 240,000 August 150,000

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

Sharpe buys its raw material two months in advance of its sales. Purchases are equal to 60% of final sales price of Sharpe’s products.. Supplier is paid 1 month after it makes delivery. For instance, purchases for April sales are made in February and payment is made in March. Additionally, Sharpe pays $10,000 per month for rent and $20,000 each month for other expenditures. Tax prepayments of $22,500 are made each quarter, beginning in March.

Company’s cash balance at December 31, 2010 was $22,000. This is the minimum balance firm wishes to sustain. Any borrowing which is required to preserve this minimum is paid off in subsequent month if there is enough cash. Interest on short-term loans (12%) is paid monthly. Borrowing to meet estimated monthly cash requires take place at the beginning of month. Hence, if in month of April firm expects to have the requirement for the extra $60,500, these funds would be borrowed at beginning of April with interest of $605 (0.12 x 1/12 x $60.500) owed for April being paid at the beginning of May.

a) Create the cash budget for Sharpe covering the first seven months of 2011.

b) Sharpe has $200,000 in notes payable due July which should be repaid or renegotiated for the extension. Will the firm have enough cash to repay notes?

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M914420

Have any Question? 


Related Questions in Basic Finance

Name the two ways in which joints loaded in shear resist

Name the two ways in which joints loaded in shear resist loads ? Which kind is slip-critical? Which kind requires control of bolt preload during assembly? What are typical coefficients of friction for slip-critical joint ...

1 why do consumers usually prefer fixed-payment loans to

1. Why do consumers usually prefer fixed-payment loans to simple loans when buying cars and houses? 2. What is a STRIP? Why were STRIPS created? What need were STRIPS intended to fill? 3. When corporations borrow money f ...

1 why is it essential for researchers to establish a stable

1. Why is it essential for researchers to establish a stable baseline of behavior during the initial A phase of an ABA design? 2. Under what circumstances is an ABA design relatively useless as a way of testing the effec ...

Capital budgeting analysis you have been asked to evaluate

Capital Budgeting Analysis : You have been asked to evaluate a potential acquisition of a smaller privately owned competitor. The acquisition candidate produces an EBITDA of 10% of your current EBITDA and is offered to y ...

100 of the purchase price or it can lease the machinery

100% of the purchase price, or it can lease the machinery. Assume that the following facts apply: 1. The machinery falls into the MACRS 3-year class. 2. Under either the lease or purchase, Big Sky must pay for insurance, ...

To qualify as a true experiment a research study requires

To qualify as a true experiment, a research study requires the manipulation of at least one variable. The fact that some variables cannot (or should not) be manipulated limits the topics that can be investigated easily w ...

1 describe four types of invalidity that can be found in

1. Describe four types of invalidity that can be found in experimental research designs. 2. What are extraneous and confounding variables? Which type of variable is most dangerous to the statistical conclusion validity a ...

On august 20 a stock index futures which expires on

On August 20 a stock index futures, which expires on September 20, was priced at 429.70. The index was at 428.51. The dividend yield was 2.7 percent. Discuss the concept of the implied repo rate on an index arbitrage tra ...

1 a certain number of bankruptcies are good for the economy

1. A certain number of bankruptcies are good for the economy. Discuss why you agree or disagree with this statement. 2. A business should always be liquidated when the liquidation value exceeds the business's value as a ...

Explain how characteristics of mncs can affect the cost of

Explain how characteristics of MNCs can affect the cost of capital ? From an investor's standpoint, have small companies, in general over the past, been more profitable than their larger brethren?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro