Question: In an Excel spreadsheet, add the stocks down below and determine their expected return (ROI) from finance.yahoo.com. Presume you would average the return. Stocks: Apple

In an Excel spreadsheet, add the stocks down below and determine their expected return (ROI) from finance.yahoo.com. Presume you would average the return.

Stocks: Apple Inc, American Airlines, Dunkin Donuts, and Ulta Beuty.

After calculating ROI, figure out what amount should be saved monthly to meet savings of a retiremnet plan. You will need to do a TVM financial calculation for this. Assume you need $100K for retirement and that you will invest 20% equally in these 5 stocks. The period (time) is 324 months since you're making monthly payments.

Please do proper calculations regarding ROI, this piece of information plays a huge role in my final assignment. Thanks!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!