what formula should i put in M17

Number of Shares Sold 294.00 1 END OF YEAR Total Value TOTAL Total Shares Sell Amount Cash on of All Equity (End Held (End of Year) Hand Investments of Year) Cash Flow $10,000.00 $0.00 $10,000.00 53.95 $5.947.62 $7,356.62 $1,091,50 $8,448.12L-$1,551.88 -..5995____$0.00 --- $7,356.62$975.50 $8,332.12 $116.00 $0.00__-_$,356.62 $1,060.18 $8,416.80 $84.681 $7256.62 - $1.210.20 $8,566.82 __$150.03 _$7,356.62 __$1,500.75 $8,857.37 $290.55 $7,356.62 $1,465.14 $8,821.76 $35. 61 $7,356.62 $1,630.51 $8,987.13 $165.37 --- $7,856.62 - $2,066.46 - 99,423.08 __$135.95 .00 --- $7,356.62 - $2,337.85 --$9,694.47 ---$271.39 00 $7,356.62 $2,389.11 $9,745.73 $51.26 ! TTTTTT i i 1 1 siwalaaaassa lalalalalalalalala 1 1 1 1 iiiiii 1 i i I i 1 1 1 1 1 sssssssss! iiiiiiiiii i i iii I i II 1 NPV = #5191% Jonathan Weiss M17 - The NPV is the NPV, using the Cost of Money in C1 with the Cash Flow across all the Years. 1/30/2020 2:26 PM Reply Styles Clipboard Font UPDATES AVAILABLE Updates for Office we ready to be installed, but first we need to close some 800 M17 =C1-M6) D 1 Cost of Money 3 STOCK PERFORMANCE START OF YEAR Annual Investment Shares Amount Bought Investment Year Close Number of Shares Sold Delta % Value 5 6 Year Year O Year 1 524 69 $20.23 347.95 ALLS.928.12 0.00110 001 0. 150.000 0.001L50.0001 $19.65 sisisisi END OF YEAR Total Value Total Shares TOTAL Sell Amount Cash on of All Equity End Held (End of Year) Hand Investments of Year) Cash Flow $10,000.00 $0.00 $10,000.00 6.947 62 17.856.62 $1,091.50 $8.44812 51.88 02 2256.02 $875.50 LS.132.13 $116.00 00___- $7,356.62 - 1.060. 15..GR ----- --1.210.20..8,566 LLLLLS150.00 ----23.62 SS00S LLLSE.RSZ S 290158 2.856.62 S1.465.14 5. THES,156 83 - SL.63051 SALE $18.53 -- --2317.85 6 99.00 $7.156.62 $123 52.189.11 1.75.73 LTSS1 28 33 -5725662231328 NPV 51918 Financial Example Weather Example