Task #$2(10$ points$)$

a$)$ Using Yahoo Finance, obtain the summary trading information for Netflix, Inc. $($ticker NFLX$).$ Take a screenshot of the data and paste into your excel workbook.

b$)$ Using the data obtained in step a$),$ calculate the price an investor would have to pay to purchase $50$ shares of Netflix's stock. Looking at recent prices of these shares, is the investor getting a good price? How can you tell?

c$)$ Using the data obtained in step a$),$ calculate the amount a current owner of $25$ shares of Netflix's stock would earn if they were to sell all their shares. Again, would this seller be happy with their price? Explain.

d$)$ Cooper had a limit order in to sell Netflix shares at a price of $$940$ per share. He placed the order on December $1,2024$ and set a $1-$month time limit for the trade. Looking at historical data of Netflix, when $($if ever$)$ did Cooper's trade go through?

Task #$3(15$ points$)$

Arthur, from Canada, is selling his prized bone collection and has decided he is willing to ship his collection anywhere in the world for the best offer. He has received $4$ offers, which are outlined below:

Option #$1-$ Coco, from Mexico, is willing to pay $3,500.$ Coco will pay for all shipping.

Option #$2-$ Duchess, from England has offered $150,$ however Arthur will be responsible for shipping which amounts to CA $$25.$

Option #$3-$ Bondi, from Australia, offered AUD $$275.$ Bondi will pay for shipping.

Option #$4-$ Lincoln, from the USA, has offered US $$180.$ Arthur is responsible for shipping which amounts to CA $$15.$

Using exchange rates obtained from the Bank of Canada website, complete your analysis and conclude on who Arthur should sell his collection to$,$ given that he wants to make the most money. Please be sure to provide screenshots of your exchange rates from the Bank of Canada for full marks.

$**$Please Note, I cannot mark this task without your screenshots from the Bank of Canada, as everyone will have different rates. Failure to submit screenshots of your rates will result in a grade of $0$ for this task.

Task #$4(20$ points$)$

Bridget just won a prize that comes with $5$ payout choices, as follows:

#$1-$ Receive $$1,000,000$ today, and nothing thereafter.

#$2-$ Receive $$500,000$ today, and $$550,000$ in one year's time.

#$3-$ Receive nothing today, $$550,000$ in one year's time, and another final payment of $$540,000$ in two year's time.

#$4-$ Starting today, receive $3$ equal annual payments of $$355,000.$

#$5-$ Receive $10$ equal annual payments of $$125,000,$ with the first payment being received $1$ year from today.

If Bridget's discount rate is $4\%,$ which prize payout should she accept? Please show your analysis in excel, using the PV$/$FV functions.