Purchase Solution

Stock Price Comparison

Not what you're looking for?

Ask Custom Question

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!!

Purchase this Solution
Solution Summary

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

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 ...

Purchase this Solution
Free BrainMass Quizzes
Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

View More Free Quizzes
Related BrainMass Solutions

  • Stock valuation comparison betwee General Materials and Standard Fixtures

    110720 Stock valuation comparison betwee General Materials and Standard Fixtures Two years ago, General Materials and Standard Fixtures' stock prices were the same.

  • Creating a stock comparison table

    The solution creates a stock comparison table. This table includes the companies name and symbol, current share price, 52 week highs and lows, market capitalization, and the industry.

  • Option Strategies

    following position at expiration as a function of stock price.

  • Importance of beta

    A low Beta or a Beta of less than one will happen when the stock price moves less in comparison to the market.

  • Common Stock Valuation

    Price Earning ratios = Market price of equity per share/Earnings per share. The relationship between the market price of a share of stock and the stock's current earnings per share is often stated in terms of a price-earnings ratio.

  • Cash dividend, share repurchase, stock dividend, stock split

    A company will tend to split its stock whenever its stock price increases significantly above its market median price.

  • Valuation with Trading Multiples and Discounted Cash Flows

    Additionally, certain trading multiples make comparison difficult. For instance, the ratio of stock price to net income is susceptible to variations in accounting methods, as are the ratios of stock price to EBT and EBIT.

  • Managerial Finance: Finance Department

    Price Earning ratios = Market price of equity per share/Earnings per share. The relationship between the market price of a share of stock and the stock's current earnings per share is often stated in terms of a price-earnings ratio.

  • Acme Stock Options Problem

    So the current price of the structure should be: $120 -PV ($124) = $120 - $124/1.0609 = $3.11. Therefore the current price of a call should be higher. Comparison of Acme European call option and European put option.

View More Related Solutions