{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Params_Calcs","Split DP Calculator"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":0,"defined_names":9,"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":"Params_Calcs","index":0,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
["Parameters",null,null,"Calculations"]
[]
["Max Benefit",4750,null,null,null,"Max BFS Income",{"$f":"ROUNDDOWN(MIN(((MIN(Upper_RR_Band,Income*12)*Lower_RR+MAX(0,Income*12-Upper_RR_Band)*Upper_RR))/12,Max_Benefit),2)","v":0}]
[]
["Income Band","Rep. Ratio",null,"Month","Salary","Employer Sick Pay","BFS Benefits"]
[0,0.65,null,"1 to 6",{"$f":"Income","v":0},{"$f":"E7","v":0},{"$f":"IF(F7=0,Max_Income_BFS,IF(F7>Max_Income_BFS,0,Max_Income_BFS-F7))","v":0}]
[60000,0.45,null,"7 to 12",0,{"$f":"IF(Income_Ind=\"% of Salary\",Income*Income_6m_pc,Income_6m_Am)","v":0},{"$f":"IF(F8=0,Max_Income_BFS,IF(F8>Max_Income_BFS,0,Max_Income_BFS-F8))","v":0}]
[null,null,null,"13+",0,0,{"$f":"IF(F9=0,Max_Income_BFS,IF(F9>Max_Income_BFS,0,Max_Income_BFS-F9))","v":0}]

{"sheet":"Split DP Calculator","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[7,1,7,5],[10,4,11,5],[18,1,18,2],[19,1,19,2],[25,1,25,2],[31,1,31,2],[18,4,18,5],[10,1,14,2]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Split Deferred Period Calculator"]
[]
[null,"Overview",null,null,"The Policies You Might Want To Consider"]
[null,"This calculator is designed for clients who would receive full sick pay from their employer for 6 months, before it reduces for the next 6 months, with no sick pay to be received after 12 months. Clients in this situation could easily become over-insured when they take out a single policy with one deferred period option. This calculator may help illustrate more cost effective solutions by taking 2 policies at different deferred periods that better align to their sick pay arrangements.",null,null,"The table below illustrates the policies your client could take out to ensure that their cover aligns with their sick pay arrangemnets while protecting against overinsurance. "]
[]
[null,null,null,null,"Deferred Period","Monthly benefit amount per policy"]
[null,null,null,null,"26 Weeks",{"$f":"Params_Calcs!G8","v":0}]
[null,null,null,null,"52 Weeks",{"$f":"F17-F14","v":0}]
[]
[null,"How it works",null,null,"Total monthly benefit amount after 52 weeks",{"$f":"Params_Calcs!G9","v":0}]
[null,"1. Enter your client’s monthly income before tax."]
[null,"2. Choose whether to  enter the sick pay they would receive after 6 months from their employer as a percentage or amount.",null,null,"The chart below shows how employer sick pay will combine with the benefits provided by the policies shown in the table above."]
[null,"3. Enter the percentage or amount of sick pay they would receive after 6 months."]
[]
[null,"Please complete the details below:"]
[]
[null,"Monthly Gross Income (£)"]
[]
[]
[null,"Employer Sick Pay (% Salary or Amount)","Amount"]
[]
[]
[null,"Sick Pay (%)"]
[null,"Monthly Sick Pay (£)"]
[]
[null,"Inputs OK?",{"$f":"IF(AND(Income_6m_pc=\"\",Income_6m_Am=\"\"),\"Enter Sick Pay % or £\",IF(OR(Income_6m_Am>Income,Income_6m_pc>1),\"Must be lower than initial income\",\"OK\"))","v":"Enter Sick Pay % or £"}]