Explore BrainMass
Share

# Stock Price Comparison

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

I need help with an excel spreadsheet in the format listed below. I have been struggling to finish some accounting that requires me to use aggregate functions inside of Microsoft Excel.

This is the format originally but needs to be done by the way it is listed below the astericks.

Symbol Stock Name Mon Tues Wed Thurs Fri

This assignment requires that I need to look up specific stock symbols, identify the company name, and the closing price-per-share (PPS) value at the end of business for five weekdays. Then, create an average price for the week for each stock. Finally, I need to compare the relative growth of each stock over the course of the week to determine which one performed the best during that time period.

* * *

Using Microsoft Excel, create a spreadsheet with a similar format and solve Juan's problem. Use the following stock symbols: MSFT, YHOO, AAPL, IBM, and JAVA. Complete the weekly average analysis using aggregate functions.

It would be greatly appreciated if oyu can assist me with this. Thanks!!

#### Solution Preview

Please find attached, a formatted MS Excel spreadsheet containing the information below, as well as notes on how the figures were calculated. Feel free to contact me in the future, in the event that additional assistance is required.

CLOSING ...

#### Solution Summary

This file contains a formatted MS Excel spreadsheet containing instructions on how to perform a stock price comparison.

\$2.19

## Compare the ratio of the fundamental value per share that you computed in the previous question to Palm's market price per share (for February 23, 2001). 3. Compare Palm's market P/E on February 23, 2001, with the fundamental P/E you derive. 4. Analyze the approach that Palm's CFO took in trying to ascertain whether or not Palm was fairly valued in February 2001.

See attached worksheet.

In 2000, the firm 3Com spun out its personal digital assistant division as Palm Inc. On February 23, 2001, the financial services firm Telerate reported the following information about Palm.

The closing price for a share of Palm was \$21.69.
Its book value of equity was \$1,110,640,000.
It held \$742,888,000 in cash.
Its trailing P/E was 181.
Palm was an all-equity financed firm and had no debt.

During a presentation to investors, Palm's CFO Judy Bruner was asked two questions. (1) What is Palm's cost of capital? (2) What is Palm's return on equity likely to be over the next several years? Palm's CFO responded by saying that she thought that the firm's cost of equity was 16 percent and that her best estimate for ROE was 26 percent per year for the next six years.

The length of the horizon during which the expected ROE exceeds the required return on equity is called the CAP (an acronym for competitive advantage period). Assume that Palm's managers plan to maintain its dividend payout ratio at zero for six years, the length of the CAP.

The CFO of Palm also remarked that in view of recent volatility in the price of Palm stock, her firm was trying to understand how the market values Palm, relative to the right factors to value Palm. Its current price of about \$22 was below the offer price of \$38 that prevailed when Palm had gone public a year earlier.

Palm's CFO indicated that she focused on trailing P/E and price-to-sales, noting that these may send conflicting signals. For example, she indicated that the market assigned Palm a high P/E ratio (145 at the time) but, relative to other firms such as Handspring, a low price-to-sales ratio (8 at the time). (In 2001, Handspring was a separate firm, which competed with Palm. Palm acquired Handspring in 2003. Subsequently, the firm split itself into two, becoming PalmOne and PalmSource.)

Case Analysis Questions

1. On the basis of the data presented in the case, use the textbook techniques to compute the fundamental value of Palm on February 23, 2001. The file Chapter 2 answer template.xls (available on the book Web site, www.mhhe.com/shefrin) is a spreadsheet that is set up along the lines of the textbook valuation of eBay's stock.

2. Compare the ratio of the fundamental value per share that you computed in the previous question to Palm's market price per share (for February 23, 2001).

3. Compare Palm's market P/E on February 23, 2001, with the fundamental P/E you derive.

4. Analyze the approach that Palm's CFO took in trying to ascertain whether or not Palm was fairly valued in February 2001.

View Full Posting Details