Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I created a spreadsheet for the below assignment. Can someone please assist if it looks correct and how I Calculate the value of stocks and

image text in transcribed
I created a spreadsheet for the below assignment. Can someone please assist if it looks correct and how I Calculate the
value of stocks and rate of return?
Investment Tracker
Summary Table
\table[[,American Express,JP Morgan Chase,Discover Financial Services,Value of Stock,Expected Rate of Return per Day,],[Shares Purchased,90,85,65,,2%,],[2024-02-07,209.08,175.40,106.28,,,],[2024-02-08,211.21,174.80,108.84,,,],[2024-02-09,212.47,175.01,109.18,,,],[2024-02-12,212.26,175.79,110.50,,,],[2024-02-13,209.67,174.26,108.39,,,],[2024-02-14,210.90,176.03,109.11,,,],[2024-02-15,212.53,179.87,110.72,,,],[2024-02-19,0.00,0.00,0.00,,,Presidents day no nasdaq],[2024-02-20,212.49,179.73,124.42,,,],[2024-02-21,210.89,180.90,120.71,,,],[2024-02-22,\table[[213.99]],183.07,120.06,,,],[2024-02-23,214.56,183.99,121.71,,,],[2024-02-26,216.96,183.36,121.96,,,],[2024-02-27,217.98,183.45,122.65,,,],[2024-02-28,218.03,184.38,123.25,,,],[2024-02-29,219.42,186.06,120.70,,,],[2024-03-01,219.66,185.29,120.81,,,],[2024-03-04,218.91,186.68,120.07,,,],[2024-03-05,217.20,188.55,121.27,,,],[2024-03-06,218.45,189.53,119.40,,,],[2024-03-07,223.42,187.78,121.52,,,],[2024-03-08,223.37,188.22,121.26,,,],[2024-03-11,220.19,188.29,121.92,,,],[2024-03-12,222.65,189.84,124.75,,,],[2024-03-13,222.81,191.38,125.96,,,],[2024-03-14,220.47,187.97,123.84,,,],[2024-03-15,218.46,190.30,120.24,,,],[2024-03-18,220.97,192.66,120.38,,,],[2024-03-19,221.69,193.79,121.24,,,],[2024-03-20,227.91,196.33,125.77,,,],[2024-03-21,229.12,199.06,127.18,,,],[2024-03-21,225.96,196.62,125.76,,,],[2024-03-25,226.03,194.82,125.26,,,],[2024-03-26,224.46,195.73,125.42,,,],[2024-03-27,227.75,199.52,128.00,,,],[2024-03-28,227.69,200.30,131.09,,,],[2024-03-29,0.00,0.00,0.00,,,Closed Good Friday],[2024-04-01,227.61,198.84,129.38,,,],[2024-04-02,225.53,198.86,127.81,,,],[2024-04-03,226.63,198.30,126.89,,,],[2024-04-04,219.59,195.65,125.00,,,],[2024-04-05,222.46,197.45,125.86,,,],[2024-04-08,224.11,198.48,125.71,,,],[2024-04-09,219.84,197.15,125.34,,,],[2024-04-10,217.65,195.47,123.29,,,],[2024-04-11,218.20,195.43,122.94,,,],[2024-04-12,218.40,182.79,120.91,,,],[,9.879.63,8.497.18,5.462.75,,,

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Financial Accounting Information The Alternative to Debits and Credits

Authors: Gary A. Porter, Curtis L. Norton

10th edition

978-1337276337, 1337276332, 978-1337517546, 1337517542, 978-1337491471

More Books

Students also viewed these Accounting questions

Question

2. Find all zeroes (real and imaginary) of f (x) = + 3x2 5x 10

Answered: 1 week ago