Question
Do in Excel. Calculate the NAV per share and % price change on 5/12/2021 (since inception) of an equally weighted portfolio of the following stocks
Do in Excel.
Calculate the NAV per share and % price change on 5/12/2021 (since inception) of an equally weighted portfolio of the following stocks in an open ended mutual fund with 100,000 shares outstanding. The fund was created on 5/7/2021 with $2 mil initial investment.
| TICKER | Price (5/7/2021) | Price (5/12/2021) |
| TESLA, INC. (XNAS:TSLA) | $ 670.94 | $ 744.12 |
| SQUARE, INC. (XNYS:SQ) | $ 231.87 | $ 245.25 |
| Teladoc Health, Inc. (XNYS:TDOC) | $ 156.99 | $ 183.00 |
| ROKU, INC. (XNAS:ROKU) | $ 304.17 | $ 356.62 |
| ZILLOW GROUP, INC. (XNAS:Z) | $ 113.80 | $ 135.06 |
| Baidu, Inc. (XNAS:BIDU) | $ 195.63 | $ 214.64 |
| ZOOM VIDEO COMMUNICATIONS, INC. (XNAS:ZM) | $ 297.59 | $ 322.76 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
The Selected Works Of George J. Benston Banking And Financial Services Volume 1
Authors: James D. Rosenfeld
1st Edition
0195389018, 0199745471, 9780199745470
