{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tool","Printer Friendly"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Tool","index":0,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,35,10],[0,1,0,4],[6,4,6,5],[16,5,16,8],[5,1,5,2],[7,1,7,2],[8,1,8,2],[3,2,3,3],[6,2,6,3],[8,5,8,10],[3,5,3,10],[15,6,15,10],[15,1,15,5],[4,8,4,10],[9,8,9,10]]}
[null,"Inflation Modeller Tool\nbuilt by M&G",null,null,null,null,null,null,"Tax Year 2024/25"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-04-05"}]
[null,null,"Assumptions",null,null,"Current position ",null,null,null,null,null,null,null,null,"2025-04-05"]
[null,null,null,null,null,null,null,null,"Projected values"]
[null,"Cash held",null,null,null,null,"Current value",null,"Before inflation","After inflation","Real return"]
[null,null,"Net Return (Inc charges and any OAC on invested)",null,"Cash  (No Investment)",null,{"$f":"D6","v":0},null,{"$f":"D6*(1+D8)^D12","v":0},{"$f":"D6*J26^D12","v":0},{"$f":"J7-G7","v":0}]
[null,"Cash"]
[null,"Invested ",null,null,null,"Potential position after cash invested"]
[null,null,null,null,null,null,null,null,"Projected values"]
[null,null,"Inflation assumption",null,null,null,"Current value",null,"Before inflation","After inflation","Real return"]
[null,null,"Investment period (yrs)",null,null,"Invested",{"$f":"(D6*D14)*(1-D15)","v":0},null,{"$f":"G12*(1+D9)^D12","v":0},{"$f":"G12*J27^D12","v":0},{"$f":"J12-G12","v":0}]
[null,null,null,null,null,"Cash",{"$f":"D6*(1-D14)","v":0},null,{"$f":"G13*(1+D8)^D12","v":0},{"$f":"G13*(1+D8-D11)^D12","v":0},{"$f":"J13-G13","v":0}]
[null,null,"Cash to be invested (%)",null,null,null,{"$f":"SUM(G12:G13)","v":0},null,{"$f":"SUM(I12:I13)","v":0},0,0]
[null,null,"Initial Adviser Charge (%)"]
[null,"Projected values",null,null,null,null,"Real Return"]
[]
[]
[]
[null,null,"Initial split","Before inflation","After inflation","Real \nReturn"]
[null,"Cash (No Investment)",{"$f":"G7","v":0},{"$f":"I7","v":0},{"$f":"J7","v":0},{"$f":"K7","v":0},null,null,"Before",{"$f":"K7","v":0}]
[null,"Invested",{"$f":"G12","v":0},{"$f":"I12","v":0},0,0,null,null,"After",{"$f":"K14","v":0}]
[null,"Cash",{"$f":"G13","v":0},0,0,0]
[]
[null,null,null,null,null,null,null,null,"Inflation adjusted"]
[null,null,null,null,null,null,null,null,"Cash",{"$f":"1+D8-D11","v":1}]
[null,null,null,null,null,null,null,null,"Stocks and shares",{"$f":"1+D9-D11","v":1}]
[]
[]
[null,"Important information about this tool"]
[null,"This calculator allows you to demonstrate the impact of inflation on your client’s investment and cash holdings over a set time period. It also demonstrates the overall returns achievable before and after inflation is taken into account.\nThe inflation modeller is not a personal illustration and the values presented do not suggest any recommendation and should not be taken as offering advice from M&G.\nThe figures represent only potential growth over the term shown and is not an indicator of future performance.\nEvery care has been takento the accuracy of this calculator, but it must be appreciated that neither M&G nor its representatives can accept any responsibility for loss, however caused, suffered by any person who has acted or refrained from acting as a result of material contained in this calculator.\nPlease note, this tool will cease to operate at the end of the tax year displayed above.\nThe value of an investment can go down as well as up. Your clients may get back less than they have paid in."]

{"sheet":"Printer Friendly","index":1,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,2,6,3],[6,4,6,5],[16,5,16,8],[30,1,35,10],[7,1,7,2],[8,1,8,2],[8,5,8,10],[9,8,9,10],[15,1,15,5],[15,6,15,10],[0,1,0,4],[3,2,3,3],[3,5,3,10],[4,8,4,10],[5,1,5,2]]}
[null,"Inflation Modeller Tool\nbuilt by M&G",null,null,null,null,null,null,{"$f":"Tool!I1","v":"Tax Year 2024/25"}]
[]
[]
[null,null,{"$f":"Tool!C4","v":"Assumptions"},null,null,{"$f":"Tool!F4","v":"Current position "},{"$f":"Tool!G4","v":0},{"$f":"Tool!H4","v":0},{"$f":"Tool!I4","v":0},{"$f":"Tool!J4","v":0},{"$f":"Tool!K4","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Tool!I5","v":"Projected values"},{"$f":"Tool!J5","v":0},{"$f":"Tool!K5","v":0}]
[null,{"$f":"Tool!B6","v":"Cash held"},{"$f":"Tool!C6","v":0},{"$f":"Tool!D6","v":0},null,null,{"$f":"Tool!G6","v":"Current value"},null,{"$f":"Tool!I6","v":"Before inflation"},{"$f":"Tool!J6","v":"After inflation"},{"$f":"Tool!K6","v":"Real return"}]
[null,null,{"$f":"Tool!C7","v":"Net Return (Inc charges and any OAC on invested)"},{"$f":"Tool!D7","v":0},{"$f":"Tool!E7","v":"Cash  (No Investment)"},{"$f":"Tool!F7","v":0},null,null,{"$f":"Tool!I7","v":0},{"$f":"Tool!J7","v":0},{"$f":"Tool!K7","v":0}]
[null,{"$f":"Tool!B8","v":"Cash"},{"$f":"Tool!C8","v":0},{"$f":"Tool!D8","v":0}]
[null,{"$f":"Tool!B9","v":"Invested "},{"$f":"Tool!C9","v":0},{"$f":"Tool!D9","v":0},null,{"$f":"Tool!F9","v":"Potential position after cash invested"},{"$f":"Tool!G9","v":0},{"$f":"Tool!H9","v":0},{"$f":"Tool!I9","v":0},{"$f":"Tool!J9","v":0},{"$f":"Tool!K9","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Tool!I10","v":"Projected values"},{"$f":"Tool!J10","v":0},{"$f":"Tool!K10","v":0}]
[null,null,{"$f":"Tool!C11","v":"Inflation assumption"},{"$f":"Tool!D11","v":0},null,null,{"$f":"Tool!G11","v":"Current value"},null,{"$f":"Tool!I11","v":"Before inflation"},{"$f":"Tool!J11","v":"After inflation"},{"$f":"Tool!K11","v":"Real return"}]
[null,null,{"$f":"Tool!C12","v":"Investment period (yrs)"},{"$f":"Tool!D12","v":0},null,{"$f":"Tool!F12","v":"Invested"},{"$f":"Tool!G12","v":0},null,{"$f":"Tool!I12","v":0},{"$f":"Tool!J12","v":0},{"$f":"Tool!K12","v":0}]
[null,null,null,null,null,{"$f":"Tool!F13","v":"Cash"},{"$f":"Tool!G13","v":0},null,{"$f":"Tool!I13","v":0},{"$f":"Tool!J13","v":0},{"$f":"Tool!K13","v":0}]
[null,null,{"$f":"Tool!C14","v":"Cash to be invested (%)"},{"$f":"Tool!D14","v":0},null,null,{"$f":"Tool!G14","v":0},null,{"$f":"Tool!I14","v":0},{"$f":"Tool!J14","v":0},{"$f":"Tool!K14","v":0}]
[null,null,{"$f":"Tool!C15","v":"Initial Adviser Charge (%)"},{"$f":"Tool!D15","v":0}]
[null,"Projected values",null,null,null,null,"Real Return"]
[]
[]
[]
[null,null,"Initial split","Before inflation","After inflation","Real \nReturn"]
[null,"Cash (No Investment)",{"$f":"G7","v":0},{"$f":"I7","v":0},{"$f":"J7","v":0},{"$f":"K7","v":0},null,null,"Before",{"$f":"K7","v":0}]
[null,"Invested",{"$f":"G12","v":0},{"$f":"I12","v":0},0,0,null,null,"After",{"$f":"K14","v":0}]
[null,"Cash",{"$f":"G13","v":0},0,0,0]
[]
[null,null,null,null,null,null,null,null,"Inflation adjusted"]
[null,null,null,null,null,null,null,null,"Cash",{"$f":"1+D8-D11","v":1}]
[null,null,null,null,null,null,null,null,"Stocks and shares",{"$f":"1+D9-D11","v":1}]
[]
[]
[null,"Important information about this tool"]
[null,{"$f":"Tool!B31","v":"This calculator allows you to demonstrate the impact of inflation on your client’s investment and cash holdings over a set time period. It also demonstrates the overall returns achievable before and after inflation is taken into account.\nThe inflation modeller is not a personal illustration and the values presented do not suggest any recommendation and should not be taken as offering advice from M&G.\nThe figures represent only potential growth over the term shown and is not an indicator of future performance.\nEvery care has been takento the accuracy of this calculator, but it must be appreciated that neither M&G nor its representatives can accept any responsibility for loss, however caused, suffered by any person who has acted or refrained from acting as a result of material contained in this calculator.\nPlease note, this tool will cease to operate at the end of the tax year displayed above.\nThe value of an investment can go down as well as up. Your clients may get back less than they have paid in."}]