Ask Question, Ask an Expert


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

Festwalia has two types of workers low-skill workers who

Festwalia has two types of workers: low-skill workers, who earn $10 per hour, and high-skill workers, who earn $20 per hour. The government of Festwalia currently imposes a 20% proportional tax on all labor earnings. It ...

An investor has two bonds in her portfolio bond c and bond

An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 8.4%. Bond C pays a 10% annual coupon, while Bond Z is a zero coupon ...

Finanical statment analysiswrite at least 3 paragraphs

Finanical Statment Analysis Write at least 3 paragraphs answering the following: What is the SEC, and what is its role in protecting the integrity of financial statements prepared and disseminated by publically traded co ...

During the financial crisis libor was manipulated libor is

During the financial crisis LIBOR was manipulated. LIBOR is a frequent index in adjustable rate mortgages. what made it relatively easy to manipulate LIBOR?

Do you think the us dollar is more likely to strengthen or

Do you think the U.S. dollar is more likely to strengthen or weaken over the next few months? Explain your reasoning.

International financial markets assignment-q1 you have 100

International Financial Markets Assignment- Q(1) You have 100% of your wealth in the U.S. stock market. You learned in MBA 796 that international diversifications often lead to a portfolio with better risk-return charact ...

Financial management assignmentdirections be sure to save

Financial Management ASSIGNMENT Directions: Be sure to save an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure to us ...

Comment on this statement people care about real interest

Comment on this statement: "People care about real interest rates, not nominal rates. Therefore, money demand should depend on the difference between the real rates on money and bonds, not the nominal rate on bonds."

Financial crisis discussion postwhat were some of the

Financial Crisis Discussion Post What were some of the credit risks that arose from the 2008 financial crisis? How were banks affected by the credit risks? How were individuals and businesses affected by the credit risks ...

The goal of this course work is that you prepare a report

The goal of this course work is that you prepare a Report where you analyse some papers describing real-world application of Networks in Finance. For preparing your report you must consider first a general introduction b ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate