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

1 what is the difference between the assignment of a

1. What is the difference between the assignment of a take-out commitment to the construction lender and a triparty agreement? If neither device is used in project financing, what is the relationship between lenders in s ...

The expected return on hilo stock is 1204 percent while the

The expected return on HiLo stock is 12.04 percent while the expected return on the market is 10.52 percent. The beta of HiLo is 1.28. What is the risk-free rate of return?

Assignment - financial research report amanda todds

Assignment - Financial Research Report Amanda Todd's Story Watch the video titled "Amanda Todd's Story: Struggling, Bullying, Suicidal, Self-harm" (8 min 55 s). Video Source: ChisVideos. (2012, October 11). Amanda Todd's ...

Find data to decide whether to open a store-you have been

Find data to decide whether to open a store:- You have been asked to determine the feasibility of opening a frozen yogurt store in Greenville, North Carolina. Answer the following questions, using the latest figures avai ...

The last decade has witnessed an unprecedented number of

The last decade has witnessed an unprecedented number of mega-mergers in the banking industry: Bank of America's acquisitions of Fleet Bank, MBNA, and U.S. Trust; Bank of New York's acquisition of Mellon Financial; and W ...

One of the behavioral research case studies in this chapter

One of the Behavioral Research Case Studies in this chapter involved Agocha and Cooper's (1999) study of partner characteristics and intentions to practice safe sex. Below are the Pearson correlations between the lik ...

An electronic retail chain wishes to minimize its ordering

An electronic retail chain wishes to minimize its ordering costs for a particularly popular model of laptop computer. This retail has a line credit to finance its inventory and the current holding rate is 5.5%. The chain ...

Use the attached document reply format to answer the

Use the attached document (Reply Format) to answer the information below: Brief Description: McDonald's is the world's leading global food service retailer with over 36,000 locations in over 100 countries. More than 80% ...

Check and revise sentences for parallel structuredetermine

Check and revise sentences for parallel structure Determine whether the following sentences use parallel structure. Revise sentences as needed to make the structure parallel. a. The executive at Ernst & Young writes repo ...

1 distinguish between theory model and hypothesis2 describe

1. Distinguish between theory, model, and hypothesis. 2. Describe how researchers use induction versus deduction to generate research hypotheses. 3. Describe the process by which hypotheses are developed and tested.

  • 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