Using an Excel spreadsheet, show the calculation of your gain or loss for each security for the week. Make sure you show a dollar return calculation and a percentage return calculation. Be especially careful on the computation of the gain/loss on the stock you purchased on margin. If you wish, you may sell none, one, or two (but no more) of your holdings. Please replace any stocks you sell on the same terms (long or short). An accompanying 1-2-page Word document addresses the checklist items below. Checklist: Discuss why you took the actions you did in your portfolio, with particular attention to your reasoning behind holding or selling specific stocks. Make special note of any observations you made when analyzing your calculations. Also, invest in one mutual fund and one exchange-traded fund this week, again limiting your investment in each to $50,000. Include in your report this week the price of the investments made, including the $25 commission and your justification for the purchases. Incorporate these buys in your spreadsheet. File Home Insert Page Layout Formulas Data Review View Help Acrobat Cut Calibri A A Wrap Text Number Normal Bad Copy Paste BI 5 Format Painter === SIMerge & Center $% 98 +8 0.00 Table Conditional Format as Calculation Formatting Check Clipboard Font Alignment Number St UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Update now A9 fx BABAF A B C D F H K 1 STOCK PURCHASE PRICE PREDICTION 6 WEEKS GAIN LOSS FEE WEEK 2 M DOLLAR N % CHANGE 2 3 AAPL 140.38 146.01 5.63 138.98 1.40 1,00 4 WMT 128.99 131.99 3.00 130.34 1.351/05 5 PFE 42.50 40.00 2.50 42.86 0.36 6 RIVN 33.05 35.18 2.13 29.01 4.04 7 SCHK 34.88. 40.00 5.12 25.00 34.78 10 11 12 13 14 15 16 17