Prepare a monthly cash budget for capers inc

Assignment Help Corporate Finance
Reference no: EM13199404

Capers, Inc. is developing its cash budget for the next year. Of Capers' sales, 20% is for cash, another 60% is collected in the month following sale, and 20% is collected in the second month following sale. November and December sales for 2010 were $229000 and $250,000, respectively.

Capers' purchases its raw materials two months in advance of its sales equal to 70% of its final sales price. The supplier is paid one month after it makes delivery. For example, purchases for April sales are made in February, and payment is made in March.

In addition, Capers pays $10,000 per month for rent and $20,000 each month for other expenditures. Tax prepayments for $32,000 are made each quarter beginning in March.

The company's cash balance at December 31, 2010, was $26,000 and minimum balance of $25,000 must be maintained at all times.  Assume that any short-term financing needed to maintain cash balance would be paid off in the month following the month of financing if sufficient funds are available. 

Interest on short-term loans (12%) is paid monthly.  Borrowing to meet estimated monthly cash needs takes place at the beginning of the month.  For example, if in the month of April the firm expects to have a need for an additional $60,500, these funds would be borrowed at the beginning of April with interest of $605 (.12 x 1/12 x $60,500) owed for April and paid at the beginning of May.

Sales for Capers Inc.:                                             

January

$229,000

February

$250,000

March

$270,000

April

$275,000

May

$280,000

June

$290,000

July

$280,000

August

$260,000

Required:

  • Prepare a monthly cash budget for Capers Inc. covering the first 7 months of 2010.

Reference no: EM13199404

Questions Cloud

In how many hours will airplane b to catch up to airplane a : airplane B takes off 60 minutes after airplane A and heads in the same direction. if airplane A travels with a constant velocity of 735 mph and airplane B with a constant velocity of 1070 mph, in how many hours will airplane B to catch up to airpl..
What is the height of the building : The angle of elevation to the top of a building from a point on the ground is 39 degrees. From a point 50 feet closer to the building, the angle of elevation is 45 degrees. What is the height of the building?
Examine the influence that legal issues : Analyze the influence that legal issues, ethics, and corporate social responsibility have had on management planning at your chosen company. Provide at least one example for each.
Use x and y to denote floor : The sales representative here tells you they also have two floor plans available, but they only have 38 homes still for sale. Write an equation that illustrates the situation. Use x and y to denote floor plan one and floor plan two respectively.
Prepare a monthly cash budget for capers inc : Prepare a monthly cash budget for Capers Inc. covering the first 7 months of 2010 - Borrowing to meet estimated monthly cash needs takes place at the beginning of the month
Defining strategies to improve patient intake : Write a 750- to 1,050-word essay discussing strategies to improve patient intake efficiency not covered in the text. Include the following components in your essay:
What is the minimum score : vin needs 420 points to have a B average in math. His scores so far are 88, 89, 79, and 77. What is the minimum score he can make on the next test to maintain the b?
What is the significance of resource pricing : Explain how the factors determining resource demand differ from those determining product demand. Explain the meaning and significance of the fact that the demand for a resource is a derived demand. Why do resource demand curves slope downward
State the predictable outcome of historical developments : the predictable outcome of historical developments before 1914? Or was Tsarism likely to have survived had it not been for the First World War?

Reviews

Write a Review

Corporate Finance Questions & Answers

  Determine if this is an equitable exchange for jack

Five years ago, Jack purchased an Inu Corporation 15-year bond having a face value of $150,000 and paying 6% annual interest. In a "Type E" reorganization, Inu is going to exchange Jack's bond with 10 years remaining for a 5-year bond having a fac..

  Taxation, financial disclosure and ownership structure

Discuss and explain the differences between businesses in the United State & in other countries with respect to financial disclosure, taxation, and ownership structure.

  Calculate the current share value

ABC pays dividends over the next 4 years: 2.50; 3.20; 4.75; and 5.20 starting in period 1 After the 4th year the company projects constant growth of 3%. Suppose investors need an 11 percent return.

  Determine the auditor responsibility

Describe how the acceptance of large, high-risk audit customers for relatively high audit fees may threaten an audit company's de factor and perceived independence.

  How much must frank save at the end of each year

Frank expects to be able to earn 5% after tax on any investments. How much must Frank save at the end of each year for the next 10 years in order to provide for Laura's education and auto?

  Selection of optimal source of finance

Selection of optimal source of finance - Which plan do you recommend the company adopt?

  Determine the working capital and current ratios

The ability of a business to meet its short-term cash needs is called liquidity. It is affected by the timing of a firm's cash inflows & outflows along with prospects for future performance.

  Benefits of portfolio diversification

Explain what the CAPM is all about in terms of expected return on an individual stock and how a firm seeking to raise money by issuing new common stock would be concerned with the Beta of its common stock.

  Determine the amount of additional financing required

Jones Corporation sales last year were $25 million and its total assets were 8 milliondollar. Accounts payable were $2 million & common stock & retained earnings were 5 million dollar.

  Difference between cccs expected roe

What is the difference between CCC's expected ROE if it finances with 40% debt versus its expected ROE if it finances entirely with common stock? Round your answer to two decimal places.

  Explain current ratio, discuss implications

Can someone please provide information on the following: what the company can do to handle short-term debt that is coming due.

  Calculate the amount of net exports of goods and services

A very small nation's gross domestic product is 12 million dollar. If government expenditures amount to 7.5 million dollar and gross private domestic investment is $5.5 million,

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd