{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Manually","Function","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Manually","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7],[11,5,11,6],[11,2,11,4]]}
[]
[null,"Dataset for Expected Return"]
[]
[null,"Investment",2023,2024,2025,2026,"Weight","Each Investment Return"]
[null,"Investment1",0.03,0.05,7.0000000000000007E-2,0.1,0.25,{"$f":"C5*G5+D5*G5+E5*G5+F5*G5","v":6.25E-2}]
[null,"Investment2",-0.05,0.06,0.1,0.15,0.25,{"$f":"C6*G6+D6*G6+E6*G6+F6*G6","v":6.5000000000000002E-2}]
[null,"Investment3",0.06,0.06,0.06,0.06,0.25,0.06]
[null,"Investment4",0.03,7.0000000000000007E-2,0.08,0.1,0.25,7.0000000000000007E-2]
[null,"Each Year Return",{"$f":"C5*$G$5+C6*$G$6+C7*$G$7+C8*$G$8","v":1.7499999999999998E-2},{"$f":"D5*$G$5+D6*$G$6+D7*$G$7+D8*$G$8","v":0.06},7.7499999999999999E-2,0.10250000000000001]
[]
[]
[null,null,"Total Expected Return",null,null,{"$f":"(C9+D9+E9+F9)/4","v":6.4375000000000002E-2}]

{"sheet":"Function","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7],[11,2,11,4],[11,5,11,6]]}
[]
[null,"Expected Return with Function"]
[]
[null,"Investment",2023,2024,2025,2026,"Weight","Each Investment Return"]
[null,"Investment1",0.03,0.05,7.0000000000000007E-2,0.1,0.25,{"$f":"PRODUCT(SUM(C5:F5), G5)","v":6.25E-2}]
[null,"Investment2",-0.05,0.06,0.1,0.15,0.25,{"$f":"PRODUCT(SUM(C6:F6), G6)","v":6.5000000000000002E-2}]
[null,"Investment3",0.06,0.06,0.06,0.06,0.25,0.06]
[null,"Investment4",0.03,7.0000000000000007E-2,0.08,0.1,0.25,7.0000000000000007E-2]
[null,"Each Year Return",{"$f":"SUMPRODUCT(C5:C8,$G$5:$G$8)","v":1.7499999999999998E-2},{"$f":"SUMPRODUCT(D5:D8,$G$5:$G$8)","v":0.06},7.7499999999999999E-2,0.10250000000000001]
[]
[]
[null,null,"Total Expected Return",null,null,{"$f":"AVERAGE(H5:H8)","v":6.4375000000000002E-2}]

{"sheet":"VBA","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7],[11,2,11,4],[11,5,11,6]]}
[]
[null,"Finding Expected Return with VBA Code"]
[]
[null,"Investment",2023,2024,2025,2026,"Weight","Each Investment Return"]
[null,"Investment1",0.03,0.05,7.0000000000000007E-2,0.1,0.2,{"$f":"PRODUCT(SUM(C5:F5), G5)","v":0.05}]
[null,"Investment2",-0.05,0.06,0.1,0.15,0.3,{"$f":"PRODUCT(SUM(C6:F6), G6)","v":7.8E-2}]
[null,"Investment3",0.06,0.06,0.06,0.06,0.35,8.3999999999999991E-2]
[null,"Investment4",0.03,7.0000000000000007E-2,0.08,0.1,0.15,4.2000000000000003E-2]
[null,"Each Year Return",{"$f":"SUMPRODUCT(C5:C8,$G$5:$G$8)","v":1.6499999999999997E-2},{"$f":"SUMPRODUCT(D5:D8,$G$5:$G$8)","v":5.9500000000000004E-2},7.6999999999999999E-2,0.10099999999999999]
[]
[]
[null,null,"Total Expected Return",null,null,{"$f":"AVERAGE(C9:F9)","v":6.3500000000000001E-2}]