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

Using financial data from an appropriate source eg yahoo

Using financial data from an appropriate source (e.g. Yahoo Finance, Google Finance, annual reports, etc.), calculate the operating and cash conversion cycles for Darden Restaurants (ticker DRI). Explain what your answer ...

Find the future value of the following ordinary annuities

Find the future value of the following ordinary annuities. Payments are made and interest is compounded as given . R=$8000, 6% interest compounded annually for 20 years.

1 what are the trade-offs among the three alternative loan

1. What are the trade-offs among the three alternative loan maturities? 2. Based on the information on finance payments that you retrieved from the loan payment Web site, advise the Sampsons on the best loan maturity for ...

Show how to combine a currency swap paying swiss francs at

Show how to combine a currency swap paying Swiss francs at a floating rate and receiving Japanese yen at a floating rate with another currency swap to obtain a plain vanilla swap paying Swiss francs at a floating rate an ...

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?

1 what are the five groups that must be fully engaged in

1. What are the five groups that must be fully engaged in the nation's war on terrorism? 2. What is the goal of emergency management in regards to the terrorism threat? 3. How much money did the federal government spend ...

1 you are trying to value zombie games inc a company

1. You are trying to value Zombie Games Inc,, a company that manufactures games for the major game systems. You have been provided the following information: · The firm generated $ 30 million as operating profit (EBIT) i ...

1 what is a forward transaction what is a forward contract2

1. What is a forward transaction? What is a forward contract? 2. What is the spot price? What is the settlement date? 3. An opinion column in the Wall Street Journal observes: "Speculators earn a profit by absorbing risk ...

Net assets and employees retirement fundthe city of

Net Assets and Employees' Retirement Fund The City of Sweetwater maintains an Employee's Retirement Fund, a single-employer, defined benefit plan that provides annuity and disability benefits. The fund is financed by act ...

By introducing personal taxes into the model for capital

By introducing personal taxes into the model for capital structure choice, how did Miller alter the previous M&M conclusion that 100 percent debt is optimal? What happens to the gains from leverage if personal tax rates ...

  • 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