{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["DCA Calculator","Formula Guide"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"DCA Calculator","index":0,"n_rows":24,"n_cols":14,"rows_kept":24,"merged":[[0,0,0,7],[0,9,0,13],[1,0,1,7],[3,3,3,7],[18,0,18,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[22,1,22,7],[23,1,23,7]]}
["How Much to Buy Calculator",{"$nulls":8},"Extra editable ladder: up to 8 positions"]
["Edit the blue input cells. The calculator will automatically calculate each buy level, amount invested, shares, cumulative shares, and blended average cost.",{"$nulls":8},"Position","Drop From High","Entry Price","Allocation %","Investment Amount"]
[{"$nulls":9},1,{"v":0.285,"d":"28.50%"},{"$f":"IF(K3=\"\",\"\",$B$6*(1-K3))","v":{"v":77.935,"d":"$77.94"}},{"v":0.17344,"d":"17.34%"},{"$f":"IF(M3=\"\",\"\",$B$5*M3)","v":{"v":17.344,"d":"$17.34"}}]
["Stock Name","NVDA",null,"Summary if all positions trigger",{"$nulls":5},2,{"v":0.37,"d":"37.00%"},{"v":68.67,"d":"$68.67"},{"v":0.2168,"d":"21.68%"},{"v":21.68,"d":"$21.68"}]
["Total Amount Dedicated",{"v":100,"d":"$100.00"},null,"Total Invested",{"$f":"SUM(D13:D16)","v":{"v":100,"d":"$100.00"}},null,"Total Shares",{"$f":"SUM(E13:E16)","v":{"v":1.8342458174906267,"d":"1.8"}},null,3,{"v":0.48,"d":"48.00%"},{"v":56.68,"d":"$56.68"},{"v":0.271,"d":"27.10%"},{"v":27.1,"d":"$27.10"}]
["High Point To Measure From",{"v":109,"d":"$109.00"},null,"Average Cost",{"$f":"IFERROR(E5/H5,0)","v":{"v":54.51831976196452,"d":"$54.52"}},null,"Lowest Entry",{"$f":"MIN(C13:C16)","v":{"v":41.42,"d":"$41.42"}},null,4,{"v":0.62,"d":"62.00%"},{"v":41.42,"d":"$41.42"},{"v":0.33876,"d":"33.88%"},{"v":33.876,"d":"$33.88"}]
["Number of Positions",null,null,"Final Drop %",{"$f":"MAX(B13:B16)","v":{"v":0.62,"d":"62.00%"}},null,"Cash Unused",{"$f":"B5-E5","v":{"v":0,"d":"$0.00"}},null,5,null,"",null,""]
["Currency Symbol","USD",null,"Breakeven Gain From Lowest",{"$f":"IFERROR(E6/H6-1,0)","v":{"v":0.31623176634390426,"d":"31.62%"}},null,"Positions Used",{"$f":"COUNT(C13:C16)","v":4},null,6,null,"",null,""]
[{"$nulls":9},7,null,"",null,""]
[{"$nulls":9},8,null,"",null,""]
[]
["Position","Drop From High","Entry Price","Investment Amount","Shares To Buy","Cumulative Shares","Allocation %","Notes"]
[1,{"v":0.285,"d":"28.50%"},{"$f":"$B$6*(1-B13)","v":{"v":77.935,"d":"$77.94"}},{"$f":"$B$5*G13","v":{"v":17.344,"d":"$17.34"}},{"$f":"IFERROR(D13/C13,0)","v":{"v":0.22254442804901522,"d":"0.2"}},{"$f":"SUM($E$13:E13)","v":{"v":0.22254442804901522,"d":"0.2"}},{"v":0.17344,"d":"17.34%"}]
[2,{"v":0.37,"d":"37.00%"},{"$f":"$B$6*(1-B14)","v":{"v":68.67,"d":"$68.67"}},{"$f":"$B$5*G14","v":{"v":21.68,"d":"$21.68"}},{"$f":"IFERROR(D14/C14,0)","v":{"v":0.31571282947429735,"d":"0.3"}},{"$f":"SUM($E$13:E14)","v":{"v":0.5382572575233125,"d":"0.5"}},{"v":0.2168,"d":"21.68%"}]
[3,{"v":0.48,"d":"48.00%"},{"$f":"$B$6*(1-B15)","v":{"v":56.68,"d":"$56.68"}},{"$f":"$B$5*G15","v":{"v":27.1,"d":"$27.10"}},{"$f":"IFERROR(D15/C15,0)","v":{"v":0.47812279463655616,"d":"0.5"}},{"$f":"SUM($E$13:E15)","v":{"v":1.0163800521598687,"d":"1.0"}},{"v":0.271,"d":"27.10%"}]
[4,{"v":0.62,"d":"62.00%"},{"$f":"$B$6*(1-B16)","v":{"v":41.42,"d":"$41.42"}},{"$f":"$B$5*G16","v":{"v":33.876,"d":"$33.88"}},{"$f":"IFERROR(D16/C16,0)","v":{"v":0.8178657653307579,"d":"0.8"}},{"$f":"SUM($E$13:E16)","v":{"v":1.8342458174906267,"d":"1.8"}},{"v":0.33876,"d":"33.88%"}]
[]
[]
["How it works"]
["1","Blue cells are editable inputs: stock name, total cash, high price, drop %, and allocation %."]
["2","Entry Price = High Point × (1 - Drop From High). Example: $208.82 × (1 - 28.5%) = $149.31."]
["3","Investment Amount = Total Amount × Allocation %. Change the allocation percentages if you want a more aggressive or conservative ladder."]
["4","Shares To Buy = Investment Amount ÷ Entry Price."]
["5","Average Cost = Total Invested ÷ Total Shares."]

{"sheet":"Formula Guide","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"merged":[[0,0,0,3]]}
["DCA Calculator Formula Guide"]
[]
["Output","Formula","Example using screenshot","Meaning"]
["Entry Price","High Point × (1 - Drop %)","$208.82 × (1 - 28.5%) = $149.31","Price where you plan to buy"]
["Investment Amount","Total Amount × Allocation %","$1,500 × 17.34% = $260.16","How much cash to put in that level"]
["Shares To Buy","Investment Amount ÷ Entry Price","$260.16 ÷ $149.31 = 1.7 shares","Number of shares bought at that level"]
["Cumulative Shares","Running total of shares","1.7 + 2.5 + 3.7 + 6.4 = 14.4","Total position size if levels trigger"]
["Average Cost","Total Invested ÷ Total Shares","$1,499.99 ÷ 14.4 = about $104.17","Your blended breakeven before fees"]