View the step-by-step solution to:

I need the formulas to answer the attached questions correctly and I need to know how to put this information into an Excel spreadsheet. Any help

I need the formulas to answer the attached questions correctly and I need to know how to put this information into an Excel spreadsheet. Any help would be greatly appreciated. I don't know were to begin. Thanks
The text book being used is:
Ross, Westerfield, Jaffe - Corporate Finance 8th edition copyright 2008
The case is on pgs. 547-548
CASE: Electronic Timing, Inc.
Electronic Timing, Inc. (ETI), is a small company founded 15 years ago by electronics engineers Tom Miller and Jessica Kerr. ETI manufactures integrated circuits to capitalize on the complex mixed-signal design technology and has recently entered the market for frequency timing generators, or silicon timing devices, which provide the timing signals or "clocks" necessary to synchronize electronic systems. Its clock products originally were used in PC video graphics applications, but the market subsequently expanded to include motherboards, PC peripheral devices, and other digital consumer electronic, such as digital television boxes and game consoles. ETI also designs and markets custom application-specific integrated circuits (ASICs) for industrial customers. The ASIC's design combines analog and digital, or mixed-signal, technology. In addition to Tom and Jessica, Nolan Pittman, who provided capital for the company, is the third primary owner. Each owns 25 percent of the 1 million shares outstanding. Several other individuals, including current employees, own the remaining company shares.
Recently, the company designed a new computer motherboard. The company's design is both more efficient and less expensive to manufacture, and ETI design is expected to become standard in many personal computers. After investigating the possibility of manufacturing the motherboard, ETI determined that the cost involved in building a new plant would be prohibitive. The owners also decided to an outside that they were unwilling to bring in another large outside owner. Instead, ETI sold the design to an outside firm. The sale of the motherboard design was completed for an after-tax payment of $30million.
1. Tom believes the company should use the extra cash to pay a special one-time dividend. How will this proposal affect the stock price? How will it affect the value of the company?
2. Jessica believes that the company should use the extra cash to pay debt and upgrade and expand it existing manufacturing capability. How would Jessica's proposals affect the company?
3. Nolan is in favor of a share repurchase. He argues will increase the company's P/E ratio, return on assets, and return on equity. Are his arguments correct? How will a share repurchase affect the value of the company?
4. Another option discussed by Tom, Jessica and Nolan would be to begin a regular dividend payment to shareholders. How would you evaluate this proposal?
5. One way to value a share of stock is the dividend growth, or growing perpetuity, model. Consider the following: The dividend payout ratio is 1 minus b, where b is the "retention" or "plowback" ratio. So, the dividend next year will be the earnings next year, E1, times 1 minus the retention ratio. The most commonly used equation to calculate the sustainable growth rate is the return on equity times the retention ratio. Substituting these relationships into the dividend growth model, we get the following equation to calculate the price of a share of stock today: What are the implications of this result in terms of whether the company should pay a dividend or upgrade and expand its manufacturing capability? Explain.
6. Does the question of whether the company should pay a dividend depend on whether the company is organized as a corporation or an LLC?

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question