Question

A share on Facebook was worth 178 on the 17^th of April 2019. A share in Amazon was worth 1620 on the 8^th of March 2019. On the 30^th of October 2019, Amazon was worth 1780 per share, Facebook 194.20 per share. Assuming you had bought and sold on those dates, which of the two investments would have been most attractive, using the excel functions show your calculations to 2 decimal places. How else could we use excel when evaluating investments?

Answer 1

Particular	Formula	Facebook	Amazon
(A) Buy		178	1620
(B) Sell		194.2	1780
(C) Profit	(B-A)	16.2	160
(D) Return	(C/A) x100	9.10%	9.88%
(E) Buy Date		17/04/2019	08/03/2019
(F) Sell Date		30/10/2019	30/10/2019
(G) Invested Days	(F-E)	196	236
Annualized Profit	D x (365/G)	16.95%	15.28%

Investment in Facebook is more attractive as given higher annulized return 16.95%.

(All formula mention in formula table to calculate respective data)

If any help require then please comment i will help you.