Working capital management, eoq, and external funds

Assignment Help Finance Basics
Reference no: EM13831666

Assignment 2: Working Capital Management, EOQ, and External Funds

Part One: Working Capital Analysis

Capers, Inc. has just promoted you to Chief financial officer. Since this is a new office in the company, you are understaffed and many of the responsibilities have been assigned to you.

The first task you have been assigned concerns the cash conversion cycle. Your boss has asked that you examine the following data:

  1. Inventory conversion period is 60 Days
  2. Payables deferral period is 30 days
  3. Receivables collection period of 40 days

The second task concerns the cost of bank loans under differing conditions. Specifically:

  1. The company needs $1,500,000 for a new project.
  2. The loan will cost 10% simple interest, for 4 months, with a 20% compensating balance.

Required:

  1. What is the firm’s cash conversion cycle?
  2. How many times per year is the firm’s inventory turnover, if sales are $4,000,000 per year?
  3. If sales are all credit sales and amount to $4,000,000 per year, what is the firm’s average investment in receivables?
  4. What is the nominal interest rate on the loan?

Part Two:  Cash Budget

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.

Part Three:  EOQ

Capers Inc. is also initiating an inventory management program using EOQ. Capers needs fastener supplies to manufacture its products. The CFO estimates that the company will need about 250,000 cases next year. The cost of storing cases is about $1.10 each. The ordering cost is $400 for a shipment.

Required:

  1. What is the EOQ?
  2. How many times will you order?
  3. What are the shortcomings of the EOQ? What is your rationale? 

Reference no: EM13831666

Questions Cloud

Bond purchasers will : 1. Bond purchasers will
Locate in the csu online library : Unit I Article Critique Your task is to offer a detailed critique of a peer-reviewed article you locate in the CSU Online Library. The article must be related to explaining how political developments and movements have influenced the practice of budg..
How does new mexicos landscape mostly vary : How does New Mexicos landscape mostly vary
Briefly describe the enterprise in terms of its operations : Illustrate how its e-commerce or ERP implementation integrated with related CT (information and communication technologies- data mining. business htelligences. data ware house. databases. internet. RFID. VAN. EDI)?
Working capital management, eoq, and external funds : Capers, Inc. has just promoted you to Chief financial officer. Since this is a new office in the company, you are understaffed and many of the responsibilities have been assigned to you.The first task you have been assigned concerns the cash conversi..
Evaluating a new gold mine in south dakota : Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company's geologist, has just finished his analysis of the mine site. He has estimated that the mine would be productive for eight years, a..
Fiona invents a new deep-sea fishing net : Fiona invents a new deep-sea fishing net, which she names Great Catch. She also writes the operating manual to be included with each net. Fiona could obtain copyright protection for
Positive or negative impact on shareholders : Explain why the 100 member rule was introduced in 1981 - Explain the process whereby 100 members could call a general meeting of the company under s249D prior to its amendment

Reviews

Write a Review

 

Finance Basics Questions & Answers

  What is the ocf for this project

The project is estimated to generate $2,010,000 in annual sales, with costs of $705,000. If the tax rate is 34 percent, what is the OCF for this project?

  If a firms roe is low and management wants to improve it

if a firms roe is low and management wants to improve it explain how using more debt might

  Lee 2001 rejects the naive view of market efficiency

lee 2001 rejects the naive view of market efficiency. explain. if lee is correct what are the implications for capital

  Finding net income and effective tax rate

Finding net income and effective tax rate from given financial ratios - Compute the Company's 2007 pro-forma net income (or adjusted net earnings) that is indicative of the Company's net income going forward

  Using the wacc and the above cash flows calculate the npv

Your employer, GBATT, headquartered in the United States of America, has decided to expand operations into Brazil. Although the decision to expand has been made, the CFO has asked for an analysis of the risks associated with the expansion. Your instr..

  Are dividends relevant in determining share values

Are dividends relevant in determining share values? Identify one factor that indicates they are, and one that indicates they are not. Give your opinion on this question and why you hold it.

  Mary bought a house in thunder bay 3 years ago the house

mary bought a house in thunder bay 3 years ago. the house was listed at 350000 and mary was able to make a down payment

  What is the variable cost per unit

A project has earnings before interest and taxes of $5,750, fixed costs of $50,000, a selling price of $13 a unit, and a sales quantity of 11,500 units. Depreciation is $7,500.

  What is the current cost of common equity for the firm

What is the current cost of common equity for the firm? (Round intermediate calculations to 4 decimal places, and final answer to 2 decimal places.)

  Define what is the required rate of return on a stock

Assume that the risk-free rate is 6 percent and the expected return on the market is 13 percent. What is the required rate of return on a stock that has a beta of 0.7?

  What is the price of each bond today

This bond pays a 8 percent coupon, has a YTM of 10 percent, and also has 14 years to maturity. What is the price of each bond today?

  Calculate the zero coupon spot rates

Calculate the zero coupon spot rates that must accompany these bonds

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