Explore BrainMass
Share

Plot P/E on Excel

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

Follow one stock and record its price every day (Open, high, low, close), number of share traded, and its P/E ratio. Construct a chart of the above variables. Then use the and estimate its value and compare your estimated value with the market price of the stock.

The number of share traded and P/E ratio should be recorded each day in Excel, and at the end of the semester use Excel's chart to plot number of shares (Y-axis) against time (Each day). The P/E ratio does not change that often, but again use Excel to plot P/E (Y-axis) against time.

*See attachment of stocks high , low, close, volume

© BrainMass Inc. brainmass.com March 22, 2019, 12:14 am ad1c9bdddf
https://brainmass.com/business/price-to-earnings-ratio/plot-p-e-ratio-excel-493416

Attachments

Solution Summary

This solution helps plot P/E on Excel.

$2.19