EBK FINANCIAL ANALYSIS WITH MICROSOFT E
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
8th Edition
ISBN: 9781337515528
Author: Mayes
Publisher: CENGAGE LEARNING - CONSIGNMENT
Question
Book Icon
Chapter 1, Problem 1P

a.

Summary Introduction

To show: The data in tabular form in new worksheet.

Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.

a.

Expert Solution
Check Mark

Explanation of Solution

The date have been shown in ‘column A’ while price of stock has been represented in ‘column’ B. The tabular presentation of the given data has been shown below:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  1

b.

Summary Introduction

To compute: Rate of return for each year.

Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.

b.

Expert Solution
Check Mark

Explanation of Solution

Rate of return for each year has been computed using the following formula:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  2

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  3

Thus, the calculated rate of return has been shown below:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  4

c.

Summary Introduction

To compute: Cumulative total return since 2011.

Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.

c.

Expert Solution
Check Mark

Explanation of Solution

Cumulative rate of return can be computed by adding each year’s rate of return. It can be computed on excel using following formula:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  5

Thus, the calculated cumulative rate of return has been shown below:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  6

d.

Summary Introduction

To compute: Rate of return for holding period and compound average rate of return.

Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.

d.

Expert Solution
Check Mark

Explanation of Solution

The rate of return for the holding period can be computed as:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  7

The calculated answer has been shown below:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  8

Now, compound annual average of return can be computed using:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  9

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  10

e.

Summary Introduction

To prepare: Line chart and scattered chart. Also, state the difference between the two charts and suggest the most suitable.

Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.

e.

Expert Solution
Check Mark

Explanation of Solution

The line chart has been prepared for FAST stock prices:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  11

The scattered chart has been prepared for FAST stock prices:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  12

Following are the differences between line and scatter chart:

Line chart: The values ??are plotted only on the y-axis i.e., the vertical axis. While, on the x-axis i.e., the horizontal axis the sequence number of the value is shown. Exceptions: graphs with the date on the X-axis.

Scatter chart: The relationship between two values is represented using the scatter chart. Scatter charts is often known as XY chart.

Here, two different values are not given which means there is no need to find the relationship between two values. So, in order to find trend of stock prices a line chart is more appropriate.

f.

Summary Introduction

To prepare: 3-D line chart and discuss if it helps in better understanding.

Introduction: An investor may purchase stock of a company and become the stockholder (owner) of the company. Based on the performance of the company and demand for company’s stocks, the value of company’s stocks increases or decreases.

f.

Expert Solution
Check Mark

Explanation of Solution

The line chart has been prepared for FAST stock prices:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  13

The 3-D line chart has been prepared:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 1, Problem 1P , additional homework tip  14

The comparison between the two charts can be seen easily. Thus, yes the enhancements will make data more attractive for the reader.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
The Short-Line Railroad is considering a $140,000 investment in either of two companies. The cash flows are as follows:  Year                     Electric Co.                  Water Works 1..................          $85,000                         $30,0002..................           25,000                            25,0003..................           30,000                            85,0004–10 ............          10,000                            10,000a. Using the payback method, what will the decision be?  b. Using the Net Present Value method, which is the better project? The discount rate is 10%.
Skyline Corp. will invest $130,000 in a project that will not begin to produce returns until after the 3rd year. From the end of the 3rd year until the end of the 12th year (10 periods), the annual cash flow will be $34,000. If the cost of capital is 12 percent, should this project be undertaken?
Which of the following would hurt your credit score? Closing a long-held credit card account. Paying off student loan debt. Getting married

Chapter 1 Solutions

EBK FINANCIAL ANALYSIS WITH MICROSOFT E

Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
International Financial Management
Finance
ISBN:9780357130698
Author:Madura
Publisher:Cengage