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

Explain how the repurchase agreement plays a role in the

Explain how the repurchase agreement plays a role in the pricing of futures contracts. What is the implied repo rate? Identify and explain some factors that make the execution of stock index futures arbitrage difficult i ...

A firm has the choice of investing in one of two projects

A firm has the choice of investing in one of two projects. Both projects last for one year. Project 1 requires an investment of $11,000 and yields $11,000, with a probability of 0.5, and $13,000, with a probability of 0. ...

Both old line industries and new tech inc use the irr to

Both Old Line Industries and New Tech, Inc., use the IRR to make investment decisions. Both firms are considering investing in a more efficient $4.5 million mail-order processor. This machine could generate after-tax sav ...

Company b just paid an annual dividend of 42 a share the

Company B just paid an annual dividend of $.42 a share. The stock is selling for $18 a share and has a growth rate of 2.2 percent. What is the dividend yield, using the constant growth model?

Using the navier-stokes equations in appendix e solve

Using the Navier-Stokes equations in Appendix E, solve Problem 8.13. Problem 8.13 The device in the schematic diagram below is a viscosity pump. It consists of a rotating drum inside of a stationary case. The case and th ...

What is the objective of an industry self-regulatory

What is the objective of an industry self-regulatory organization? Compare and contrast three types of futures trading costs? Compare and contrast cash settlement with physical settlement ? Identify the typical character ...

Dr jones conducts an experiment investigating the effects

Dr. Jones conducts an experiment investigating the effects of distraction on memory. A list of 40 two-syllable words is prepared. Dr. Jones obtains a sample of 50 students, all between the ages of 18 and 22, and presents ...

Determine whether each of the following hypotheses is

Determine whether each of the following hypotheses is testable and refutable; if not, explain why. a. The color red as seen by males is different from the color red as seen by females. b. A list of three-syllable words i ...

In planning this course we first wanted to cover financial

In planning this course, we first wanted to cover financial topics that are important to virtually anyone. This week's final chapters go on to discuss corporate concepts of WACC, NPV, IRR and working capital decisions an ...

1 what are sources of economic profits for a company or an

1 .What are sources of economic profits for a company or an industry? 2. The following is an excerpt that appeared in an article "Strategic Planning: Not Just for Big Business" published at www.smallbusinessnotes. com/pl ...

  • 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