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

How the yield curve may respond to prevailing conditions

How the Yield Curve May Respond to Prevailing Conditions : Consider how economic conditions affect the default risk premium. Do you think the default risk premium will likely increase or decrease during this semester? Ho ...

Assignment cash managementsolve the following problem

Assignment: Cash Management Solve the following problem. Norma's Cat Food of Shell Knob ships cat food throughout the country. Norma has determined that through the establishment of local collection centers around the co ...

Walmart npv analysisusing the publicly traded fortune 500

Walmart NPV Analysis Using the publicly traded Fortune 500 Company that you picked earlier in the course answer the following questions in 2-3 pages: • What types of long term investments would you recommend that they ma ...

Under what conditions could an import quota and a tariff

Under what conditions could an import quota and a tariff have exactly the same effect on price and bring the same gains and losses (given a tariff level that restricts imports just as much as the quota would)?

What are some of the factors that determine the spread

What are some of the factors that determine the spread between the bid and asked price? If the bid- asked spread narrows, what does this mean?

Confounding effects what factors might be considered by

Confounding Effects : What factors might be considered by financial market participants who are assessing whether an increase in money supply growth will affect inflation?

How much would you have to deposit today in order to have

How much would you have to deposit today in order to have $500,000 in 20 years? Assume you can earn annual interest of 3.5%

For this assignment you will analyze a home mortgage loan1

For this assignment, you will analyze a home mortgage loan. 1. Find a description, asking price, and real estate taxes of a house for sale, and decide on a purchase price you would be willing to pay (assuming you have th ...

How does each of the following affect the money supplya the

How does each of the following affect the money supply? a. The Fed lowers the required reserve ratio. b. The Fed buys government securities.

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?

  • 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