Sample solution | bartleby

Sample Solution from

EBK FINANCIAL ANALYSIS WITH MICROSOFT E

8th Edition

ISBN: 9781337515528

Chapter 1

Problem 1P

Try another sample solution

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.

Expert Solution

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:

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.

Expert Solution

Explanation of Solution

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

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

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.

Expert Solution

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:

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

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.

Expert Solution

Explanation of Solution

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

The calculated answer has been shown below:

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

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.

Expert Solution

Explanation of Solution

The line chart has been prepared for FAST stock prices:

The scattered chart has been prepared for FAST stock prices:

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.

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.

Expert Solution

Explanation of Solution

The line chart has been prepared for FAST stock prices:

The 3-D line chart has been prepared:

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

Not sold yet?Try another sample solution

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.

Explanation of Solution

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.

Explanation of Solution

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.

Explanation of Solution

Explanation of Solution

Explanation of Solution

Explanation of Solution

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.

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.

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.