On April 11, 2022 portfolio had 100,000 dollars in cash and was long 3000 shares of MSFT at a closing price on April 11, 2022, (look at Yahoo finance), long 200 Shares of AMZN and short 100 shares of SPY. What is the Net Asset Value (NAV) of portfolio on the close of April 11, 2022 (value of money left if portfolio is liquidated). What is the gross and net leverage of portfolio on close of April 11, 2022? Using historical data from Yahoo and assuming cash earned 1% annually with daily compounding, simulate in spreadsheet portfolio NAV and leverage from January 4, 2010 to April 11, 2022. Calculate portfolio NAV and portfolio leverage for every business day. Use split and dividend adjusted price (adjusted close on Yahoo)

Please show all work!