Question

Focus Drilling Supplies has been growing steadily over the last 20 years. With increased exploration in...

Focus Drilling Supplies has been growing steadily over the last 20 years. With increased exploration in the mining sector, the company has decided to expand their facilities for supplies and custom drill bit production to meet the increased demand.

The expansion will occur over 4 years and is expected to require $2.8 million.

Management has developed a payment plan for carrying out this expansion. The plan requires a cash input of $300,000 now, $700,000 one year from now, $800,000 two years from now, and finally, $1,000,000 four years from now.

While Focus Drilling is able to allocate $2.6 million dollars from the cash reserves to fund the project, there is no other contingency fund for cost overruns or construction delays. However, any interest earned on the expansion fund during the four-year time frame will be set aside for the project.

Before the final decision on implementation, the company treasurer is asked to assess the plan to determine if the current $2.6 million allocation will meet the $2.8 million in payment obligations of the plan over the four-year period. The Treasurer has predicted interest rates over the next four years to be as follows:  

  • Year 1: interest rate of 4.5% p.a. compounded semi-annually
  • Year 2: interest rate of 5.0% p.a. compounded semi-annually
  • Year 3: interest rate of 5.0% p.a. compounded semi-annually
  • Year 4: interest rate of 5.5% p.a. compounded semi-annually

As an alternative, the Treasurer has found that the $2.6 million cash allocation could be invested at a fixed rate of 5.2% p.a. compounded quarterly for a period of five years.

The company can withdraw part of the money from either investment at any time without penalty to meet the cash payment requirements.

Questions (total of 40 marks)

In a single Word doc, answer each of the following questions based on the Focus Drilling case, including any calculations and rationale used.

  1. Can Focus Drilling meet the cash payment requirements of the expansion given the variable interest rates given above? Use today as a focal date. Show your calculations.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
26.  You plan to retire in 35 years.  Two savings plans have been presented to you, both earn...
26.  You plan to retire in 35 years.  Two savings plans have been presented to you, both earn 7.5% p.a compounded annually.  Plan A has annual fees and transaction costs of 1.1% per year of your assets, whereas Plan B has annual fees and transaction costs of 0.08%.  Regardless of which plan you choose; you plan to contribute $6000 per year.  How much extra money will you have upon retirement if you choose Plan B?  Assume you are saving into your TFSA.   PLEASE SHOW ALL YOUR...
Time Value of Money 1. En. Ahmad invested Rm50,000 in a mutual fund 5 years ago....
Time Value of Money 1. En. Ahmad invested Rm50,000 in a mutual fund 5 years ago. The fund provided compounded rate of return of 7% p.a over the last 5 years. What is the value of En. Ahmad’s investment now? 2. Johnny has a child whose education plan requires RM500,000 to finance the completion of his tertiary education 10 years from today. Johnny has set aside RM200,000 for this purpose. He wants to know what investment rate of return is...
MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt-equity...
MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt-equity ratio of 50 percent and the tax rate is 22 percent. The required return on the firm’s levered equity is 15 percent. The company is planning to expand its production capacity. The equipment to be purchased is expected to generate the following unlevered cash flows: Year 0- Cash Flow −$18,300,000, Year 1 - 5,730,000. Year 2- 9,530,000 Year 3- 8,830,000. The company has arranged...
MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt-equity...
MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt-equity ratio of 45 percent and the tax rate is 22 percent. The required return on the firm’s levered equity is 14 percent. The company is planning to expand its production capacity. The equipment to be purchased is expected to generate the following unlevered cash flows:    Year Cash Flow 0 −$18,800,000 1 5,780,000 2 9,580,000 3 8,880,000    The company has arranged a debt...
MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt-equity...
MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt-equity ratio of 45 percent and the tax rate is 21 percent. The required return on the firm’s levered equity is 14 percent. The company is planning to expand its production capacity. The equipment to be purchased is expected to generate the following unlevered cash flows: Year Cash Flow 0 −$18,200,000 1 5,720,000 2 9,520,000 3 8,820,000 The company has arranged a debt issue of...
MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt-equity...
MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt-equity ratio of 60 percent and the tax rate is 25 percent. The required return on the firm’s levered equity is 13 percent. The company is planning to expand its production capacity. The equipment to be purchased is expected to generate the following unlevered cash flows:    Year Cash Flow 0 −$19,500,000 1 5,910,000 2 9,710,000 3 9,010,000    The company has arranged a debt...
A company has two investment opportunities: Alternative A returns $36,000 now, $20,000 in two years and...
A company has two investment opportunities: Alternative A returns $36,000 now, $20,000 in two years and $8,000 in four years. Alternative B returns $1,470 at the end of every month for four years. The required rate of return is 8.5% compounded semi-annually. Using the discounted cash flow (DCF) method, which alternative is preferable?
1. For the next 6 years, you pan to make equal quarterly deposits of $600.00 into...
1. For the next 6 years, you pan to make equal quarterly deposits of $600.00 into an account paying 8% compounded quarterly. How much will be the total you have at the end of the time? 2. How much money will you have to deposit now if you wish to have $5,000 at the end of 8 years. Interest is to be at the rate of 6% compounded semiannually? 3. In the California “Million Dollar Lottery” a winner is paid...
The company has been growing steadily over the past 5 years, and the financials and future...
The company has been growing steadily over the past 5 years, and the financials and future prospects look good. Your CEO has asked you to run the numbers. After doing some digging into the business, you have gathered information on the following: The estimated purchase price for the equipment required to move the operation in-house would be $750,000. Additional net working capital to support production (in the form of cash used in Inventory, AR net of AP) would be needed...
MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt–equity...
MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt–equity ratio of 40 percent and is in the 35 percent tax bracket. The required return on the firm’s levered equity is 15 percent. The company is planning to expand its production capacity. The equipment to be purchased is expected to generate the following unlevered cash flows: Year Cash Flow 0 −$18,450,000 1 5,830,000 2 9,630,000 3 8,930,000 The company has arranged a debt issue...