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

1 list four important drivers of housing demand and price

1. List four important drivers of housing demand and price appreciation. 2. What are public goods? How may they be reflected in house prices? 3. When considering an investment in "distressed'' properties, what are the tw ...

1 modify the wagner-within model for the case where the

1. Modify the Wagner-Within model for the case where the warehouse is capacitated. Does the ZIO property still hold? 2. What is the optimal order quantity in the newsboy model if the warehouse is capacitated? 3. Extend t ...

1 compare and contrast the transport principles of economy

1. Compare and contrast the transport principles of economy of scale and economy of distance. Illustrate how they combine to create efficient transportation. 2. Describe the five modes of transportation, identifying the ...

An article in the wall street journal discussing the fear

An article in the Wall Street Journal discussing the fear that some farmers had that regulation of derivatives would make it harder for them to hedge risk, described the situation of a feedlot owner who "uses derivatives ...

1 a successive independent survey design and a longitudinal

1. A successive independent survey design and a longitudinal survey design both examine changes in responses over time. How do they differ in their approach? 2. Distinguish between demographic and epidemiological researc ...

Ethan is investing 50 every month for 20 years the annual

Ethan is investing $50 every month for 20 years. The annual rate is 6%. How much money will Ethan have in 20 years? An investment promises to pay $3,000 yearly for 10 years. The payments are received at the beginning of ...

1 what are the characteristics of the nordic and

1. What are the characteristics of the Nordic and Scandinavian management culture at TietoEnator? 2. What ways can a company use to leverage its knowledge resources globally? 3. How does a rapidly growing startup maintai ...

1 what is the relationship between confounding and internal

1. What is the relationship between confounding and internal validity? 2. What are experimenter expectancy effects, and how do researchers minimize them? 3. Should demand characteristics be eliminated or strengthened in ...

Comprehensive problemuse what you have learned about the

Comprehensive Problem Use what you have learned about the time value of money to analyze each of the following decisions: Decision #1: Which set of Cash Flows is worth more now? Assume that your grandmother wants to give ...

Modern machines try to execute many instructions at the

Modern machines try to execute many instructions at the same time, including branching instructions. Thus, there is a severe cost if the machine speculatively follows one branch, when control actually goes another way (a ...

  • 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