Ask Financial Management Expert

1. The September 30, 2004 financial statements for Millipore Company are provided on the following page. Millipore's chief financial officer has asked you to prepare a proforma income statement, balance sheet, and statement of external financing required (EFR) for Millipore Corp for the 2005 fiscal year. The Statement of EFR should show the total financing required, the internal sources, and any adjustments to EFR.  The following forecasts for the 2005 fiscal year are available:

- The company's sales are forecasted to increase by 32%.

- Cost of goods sold are expected to be 70.8% of sales.

- Selling and administration expenses will increase by $80,000.

- Amortization will increase by $10,000 since the company is planning to acquire new fixed assets that will cost $628,200.

- Lease Payments will remain unchanged.

- Interest expense will increase by $15,000.

- Millipore's tax rate is 20%.

- The company's policy is to pay 25% of their net income after tax as common share dividends.

- The firm wishes to have a minimum cash balance of $45,000.

- The company's goal is to have an average collection period of 65 days, an average age of inventory of 72 days, and an average payment period of 85 days.

- Accruals will increase by $5,000.

- During the 2005 fiscal year, the company is required to repay $205,000 of the principal on their outstanding long-term debt.

Any external financing required will be raised as follows: 60% line of credit, 40% sale of common shares.

Millipore Corp Income Statement

 

ProForma

 

2004

2005

Sales (all on credit)

$1,875,000

 

Cost of goods sold

1,310,000

 

Gross margin

565,000

 

Selling and admin. expense

217,500

 

Amortization

48,200

 

Lease Payments

39,000

 

Operating earnings (EBIT)

260,300

 

Interest expense

85,000

 

Earnings before taxes

175,300

 

Taxes

55,300

 

NIAT

$ 120,000

 

Millipore CorpBalance Sheet

 

 

ProForma

Assets

2004

2005

Cash

$ 60,000

 

Accounts receivable

360,000

 

Inventory

290,000

 

 Total current assets

710,000

 

Net plant and equipment

1,390,000

 

Total assets

$2,100,000

 

Liabilities and Owners' Equity

 

Accounts payable

$ 460,000

 

Accruals

35,000

 

Line of Credit

45,000

 

Total current liabilities

540,000

 

Long-term debt

703,900

 

Common shares

340,000

 

Retained earnings

516,100

 

Total liabilities and equity

$2,100,000

 

2. Fine Foods Catering Ltd (FFC) operates a serving-line cafeteria in an office building in downtown Halifax, Nova Scotia. About 1,500 people work in the office building.  The cafeteria is open 250 days a year and operates from 7:00 am until 4:00 pm.  Demand always peaks during the lunch hours. For lunch, 600 people want to use the cafeteria, however, the serving-line facilities can only accommodate 400 people.  Therefore, each day 200 potential customers are turned away.  The owners of FFC have recently recognized that this is resulting in a considerable loss of revenue for the cafeteria.

To tap the excess demand, the cafeteria is considering expanding the current serving-line facilities over the upcoming Christmas holidays.  Expanding the serving-line will cost $260,000.  With the expansion, it is estimated that 75% of the customers that are currently being turned away from the cafeteria will use the cafeteria.

For the cafeteria, the current average lunch sale is $5.40 excluding taxes.  The direct cost of the average lunch (the food sold) is 40%. This will remain the same if the serving-line facilities are expanded. With the expanded serving-line, an extra cook, dish washer, and cash clerk will be required.  The wages for these new employees will be $28,000, $12,500, and $21,500 per year, respectively.  In addition, extra cleaning costs of $45 per day will be incurred.

Since sales will increase with the expanded serving-line, the cafeteria will have to invest an additional $0.10 in food inventory for each $1.00 increase in sales. The serving line expansion has an expected useful life of 20 years.  The salvage value of the new equipment at the end of its 20 year life will be $25,000 and it will cost $2,500 to dismantle.  The CCA rate for the new serving-line facilities is 15%. FFC's tax rate is 20% while their cost of capital is 14%.

Required:

a)    Should FFC expand the current serving-line facilities in the cafeteria? Fully explain being sure to provide a complete net present value analysis.

b)    For the following question, additional calculations are not required.  If the firm's cost of capital were 12.5% and not the 14% used above, would this change your answer? Briefly discuss.

Remember, do not make any calculations.

3. It is January 2, 2005 and the President of Byfield Corporation has approached you with a problem.  The president has uncovered three possible independent projects that the company could invest in. The president is wondering which of the projects the company should select.  You inform the President, based on the knowledge gained in your corporate finance course, that she must first determine the company's cost of capital.

Based on this response, the President hires you to complete the analysis.  You know that after calculating the company's cost of capital, you can make a decision regarding the available projects.

Byfield's capital structure, which is considered optimal, is as follows:

Bonds (10% coupon, due December 6, 2005)

$ 3,800,000

Preferred equity ($20 stated value, 8.1% dividend rate)

1,400,000

Common shares (972,152 common shares outstanding)

1,000,000

Retained earnings

3,800,000

Total Capital

$10,000,000

If Byfield were to issue a bond, it would have a life of 25 years.  Byfield's current bonds were issued in 1985 for $998.25 per $1,000 of par. The bonds are now rated BBB (low) and are currently trading for $1,011.61 per $1,000 of par. Magna Canada, also rated BBB (low), has a bond outstanding that has 20 years to run to maturity and has a coupon rate of 11% (paid semi-annually) This bond is currently trading for $1,238.47.

Byfield's underwriter has informed the company that for a bond with a 25 year maturity, the market would require a premium 30 basis points (0.30%) more than that provided on a 20 year bond issue with the same default risk. The new bond would be sold for $1,002 and issue costs on a new bond issue would be 2.2% of par. Byfield's tax rate is 20%.

Byfield's preferred shares are currently trading for $18.10.  If Byfield issued new preferred shares, their underwriter has suggested that issue costs would be 2.7% of the $25 stated value of the new issue.

Byfield's most recent earnings available to common shareholders were $1,905,418 and the company paid common share dividends of $369,418 or $0.38 per share.  Byfield's common shares are currently trading for $12.22 per share. You have been told that the company's earnings and dividends are expected to grow by 16% per year for the foreseeable future.  For a sale of new common shares, issue costs would be 4.83% of the current share price.

The costs and the expected returns of the three projects Byfield is considering are presented below.

Expected

Project

 Cost

Return

Laser-based imaging machine

$1,000,000

 13.4%

Thermal transfer colour printer

$3,000,000

 18.8%

Industrial application imaging machine

$5,500,000

 15.9%

Required:

a) Calculate Byfield's cost of capital. Which project(s) should Byfield accept? Explain.

b) In the phrase "cost of capital," what has a cost? Briefly explain why knowing the cost of capital is important for a company.

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M91519861
  • Price:- $60

Priced at Now at $60, Verified Solution

Have any Question?


Related Questions in Financial Management

Assignment problems1 on the day harry was born his parents

Assignment Problems 1. On the day Harry was born, his parents put $1600 into an investment account that promises to pay a fixed interest rate of 5 percent per year. How much money will Harry have in this account when he ...

1 activities of a company that require the spending of cash

1) Activities of a company that require the spending of cash are known as: A) Uses of cash. B) Cash on hand. C) Cash receipts. D) Sources of cash. E) Cash collections. 2) Relationships determined from a firm's financial ...

Module discussion forumto prepare for this discussion

Module : Discussion Forum To prepare for this discussion, review "Basics of Speechwriting" and "Basics of Giving a Speech" in textbook Chapter 15. Then watch this video of Apple founder and CEO Steve Jobs giving the 2005 ...

Launching a new product linefor this portfolio project

Launching a New Product Line For this Portfolio Project Option, you will act as an employee in a large company that develops and distributes men's and women's personal care products. The company has developed a new produ ...

Question 1 discuss valuing bonds and how interest rates

Question : 1) Discuss valuing bonds and how interest rates affect their value. Also consider the importance of the yield-to-maturity (YTM). 2) Discuss common stocks and preferred stocks. Also, which common stock valuatio ...

Introductionlast week you determined the root causes of the

Introduction Last week, you determined the root cause(s) of the problem you are trying to resolve for your final paper. As a reminder, the decision you are working on is the one that you selected in week two. This week, ...

You have owned and operated a successful brick-and-mortar

You have owned and operated a successful brick-and-mortar business for several years. Due to increased competition from other retailers, you have decided to expand your operations to sell your products via the Internet. ...

You will be conducting an interview with a market research

You will be conducting an interview with a market research professional or a company representative. Use the results of your research to make specific recommendations on how market research can be applied to the Marketpl ...

Question 1 what is marketing research what are the two

Question 1: What is marketing research? What are the two primary types of research? Question 2: What factors influence marketing research? Question 3: The role of statistics in business decision-making? Assignment : Sele ...

Chapter 74 for commercial banks what is meant by a managed

Chapter 7 4. For commercial banks, what is meant by a managed liability? What role do liquid assets play on the balance sheet of commercial banks? What role do money market instruments play in the asset and liability man ...

  • 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

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As