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

Discussion please use references bullwhat effect do

Discussion ** please use references ** • What effect do interest rates have on the calculation of future and present value? ( 125- words ) • How does the length of time affect future and present value? How do these two f ...

The unemployment rate in a city is 12 if 9 people from the

The unemployment rate in a city is 12%. If 9 people from the city are sampled at random, find the probability that fewer than 2 of them are unemployed. Carry your intermediate computations to at least four decimal places ...

How does the value of an unlevered firm change if it takes

How does the value of an unlevered firm change if it takes on debt in the presence of corporate taxes? Repeat the analysis for ANF from the previous problem, after relaxing only the "no corporate tax" assumption of perfe ...

In each of 4 years a random sample of 100 voters different

In each of 4 years a random sample of 100 voters (different each year) are asked if they support a political party. The numbers each year who support the party are 41, 32, 35, and 33. (a) Give a 95 percent confidence int ...

J smythe inc manufactures fine furniture the company is

J. Smythe, Inc., manufactures fine furniture. The company is deciding whether to introduce a new mahogany dining room table set. The set will sell for $6,800, including a set of eight chairs. The company feels that sales ...

This year you are planning to raise all your capital by

This year you are planning to raise all your capital by borrowing. Your assistant says that you should evaluate new investments this year using the cost of debt only. Is he/she correct? Why or why not?

1 complete the following table2 comment on the following

1 .Complete the following table: 2 .Comment on the following statement: "Forward rates are good predictors of future interest rates.

1 what is the main advantage of the typical optimization

1. What is the main advantage of the typical optimization technique in comparison to simulation? 2. At what point in the typical analysis does the technique give way to the managerial review and evaluation process? 3. Co ...

Explain how a swaption can be terminated at expiration by

Explain how a swaption can be terminated at expiration by either exercising it or settling it in cash. Why are these procedures financially equivalent? Explain how the two types of swaptions are like interest rate option ...

Ethical dilemma the irs tax code allows for the deduction

Ethical Dilemma. The IRS tax code allows for the deduction of expenses incurred in traveling to a job interview. Sean, Erica, and their two children have used this deduction to fund their vacations for the last eight yea ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen