{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["MAIN ENTITY","2nd ENTITY","3rd ENTITY","4th ENTITY","5th ENTITY","RKP","Sheet1","BE CALC","HELP","BOH","ADMIN"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":38,"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":"MAIN ENTITY","index":0,"n_rows":93,"n_cols":34,"rows_kept":93,"cut":false,"hidden":false,"merged":[[24,1,24,6],[10,8,10,12],[36,1,36,6],[8,5,8,6],[10,5,10,6],[1,4,3,13],[74,1,74,2],[73,1,73,2],[72,1,72,2],[60,1,60,6],[65,7,65,9],[57,1,57,6],[54,1,54,6],[25,1,25,6],[11,3,11,4],[38,1,38,5],[43,1,43,6],[52,1,52,5],[70,1,70,2],[65,10,65,12],[55,1,55,6],[79,1,82,12],[5,15,8,17],[8,1,8,2],[9,1,9,2],[13,15,61,18],[53,1,53,6],[29,1,29,5],[35,1,35,6],[26,1,26,3],[27,1,27,6],[39,1,39,6],[40,1,40,6],[42,1,42,6],[23,1,23,6],[41,1,41,6],[58,1,58,5],[84,1,90,12],[92,12,92,13],[16,1,16,4],[17,1,17,4],[5,1,7,4],[9,3,9,4],[56,1,56,6],[72,10,74,12],[92,10,92,11],[8,3,8,4],[10,3,10,4],[62,10,63,12],[68,10,69,12],[78,1,78,3],[71,1,71,2],[70,10,71,12]]}
[]
[null,null,null,null,"Insurable income calculator"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lemon",null,null,null,"The Cookie Shop",null,null,null,null,null,1,"lemon","Fred smith"]
[]
[null,"MAIN ENTITY",null,null,null,null,null,null,null,null,null,null,null,null,null,"Help Notes",null,null,null,null,null,"pie",null,null,"Cookie type","lemon",null,null,null,null,null,2,"pie"," doodle dandy"]
[]
[]
[null,"Reference",null,null,null,"Most Recent Year",null,null,null,null,{"$f":"IF(I9=\"\",\"\",I9-1)","v":""},null,{"$f":"IF(I9=\"\",\"\",I9-2)","v":""},null,null,null,null,null,null,null,null,"carrot",null,null,null,null,null,null,null,"Fred smith",null,3,"carrot","bananas are cool oh yeah"]
[null,"Client Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click here to search for",null,null,null,null,"chip",null,null,null,{"$f":"IF(Z6=\"carrot\",AD9,\"\")","v":""},null,null,null,null,null,4,"chip","la al "]
[null,"Age/Occupation",null,null,null,"Main Trading Entity",null,null,null,null,null,null,null,null,null,"Help…","INSTRUCTIONS",null,null,null,null,"monkey",null,null,null,null,null,null,null,null,null,5,"monkey","itchy and scratchy went to market"]
[null,null,null,"Self-employed or business owner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Z6,AG4:AH11,2,FALSE)","v":"Fred smith"}]
["A","Income",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q11","v":"INSTRUCTIONS"}]
["-B","Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q11,HELP!B4:C43,2,FALSE)","v":"The Insurable Income Calculator is designed to assist with determining an individuals insurable income based on financial information from Tax Returns, Profit & Loss Statements, IRD Income Summary Statements and Pay Slips etc. Please follow the instructions below:\n1. Enter the life insured's details at the top of the MAIN ENTITY worksheet and select whether 'Employee Only' or Self-employed or business owner'.\n2. Enter the most recent financial year at cell I9 eg 2022\n3a. Where the life insured is an EMPLOYEE ONLY and has NO ownership interest in the business (directly or otherwise), select Employee ONLY and enter the life insured's details in the MAIN ENTITY worksheet and enter actual yearly salary & wage figures etc as per the IRD Income Summary Statements etc in the section 'Plus Salary/Wages/Fringe Benefit etc from 3rd Party Employers' (located at rows 54 to 58); or\n3b. Where the life insured is SELF-EMPLOYED (or a business owner) complete the main entity worksheet and where there is more than one trading entity in the business structure complete an additional entity worksheet for each entity by clicking on the GREEN tabs at the bottom of the worksheet.  Complete additional entity worksheets for any additional entities that make up the overall business structure based on the financials for each additional entity. When information has been entered for all entities the summary at the bottom of the MAIN ENTITY worksheet will provide an indicative maximum monthly benefit amount (based on the income from all business entities).\n4. Using the life insured's financials and information in the App and/or FinQ etc complete all WHITE fields as required and refer to the HELP search menu as required to complete each field. \n5. If you are unsure about how to complete the Insurable income calculator, please contact your Underwriter.\n\nPlease note, this calculator provides an indicative guide of insurable income only."}]
["=C","Net Income",null,null,null,null,null,null,{"$f":"SUM(I13-I14)","v":0},null,{"$f":"SUM(K13-K14)","v":0},null,{"$f":"SUM(M13-M14)","v":0}]
[]
[null,"Ownership Interest"]
[null,"Life Insured's Share of Net Income",null,null,null,null,null,null,{"$f":"SUM(I15*I17)","v":0},null,{"$f":"SUM(K15*K17)","v":0},null,{"$f":"SUM(M15*M17)","v":0}]
[]
[null,"Plus Business Add Backs",null,null,null,null,null,null,{"$f":"IF(I9=\"\",\"\",I9)","v":""},null,{"$f":"K9","v":""},null,{"$f":"M9","v":""}]
["+D","Donations"]
["+E","Motor Vehicles"]
["+F","Loss on the Sale of an Asset"]
["+G"]
["+H"]
["+I"]
[null,"Sub-total Business Add Backs",null,null,null,null,null,null,{"$f":"SUM(I21:I26)","v":0},null,{"$f":"SUM(K21:K26)","v":0},null,{"$f":"SUM(M21:M26)","v":0}]
[null,{"$f":"\"Total Business Add Backs (\"&D10&\"'s share thereof)\"","v":"Total Business Add Backs ('s share thereof)"},null,null,null,null,null,null,{"$f":"I27*I17","v":0},null,{"$f":"K27*K17","v":0},null,{"$f":"M27*M17","v":0}]
[]
[null,{"$f":"\"Plus (\"&D10&\"'s) Business Add Backs\"","v":"Plus ('s) Business Add Backs"}]
["+J","Directors Fees"]
["+K","Salary "]
["+L","Superannuation (or KiwiSaver)"]
["+M","Income Split Salary"]
["+N","Income Split Superannuation (or KiwiSaver)"]
["+O"]
[null,{"$f":"\"Adjusted Net Income (for \"&I11&\")\"","v":"Adjusted Net Income (for )"},null,null,null,null,null,null,{"$f":"SUM(I18,I28,I31,I32,I34,I36,I33,I35)","v":0},null,{"$f":"SUM(K18,K28,K31,K32,K34,K36,K33,K35)","v":0},null,{"$f":"SUM(M18,M28,M31,M32,M34,M36,M33,M35)","v":0}]
[]
[null,"Plus Other Supplementary (Business Entity) Income",null,null,null,null,null,null,{"$f":"IF(I9=\"\",\"\",I9)","v":""},null,{"$f":"K9","v":""},null,{"$f":"M9","v":""}]
["2nd",{"$f":"IF('2nd ENTITY'!I11=\"\",\"\",'2nd ENTITY'!I11)","v":""},null,null,null,null,null,null,{"$f":"'2nd ENTITY'!I38","v":0},null,{"$f":"'2nd ENTITY'!K38","v":0},null,{"$f":"'2nd ENTITY'!M38","v":0}]
["3rd",{"$f":"IF('3rd ENTITY'!I11=\"\",\"\",'3rd ENTITY'!I11)","v":""},null,null,null,null,null,null,{"$f":"'3rd ENTITY'!I38","v":0},null,{"$f":"'3rd ENTITY'!K38","v":0},null,{"$f":"'3rd ENTITY'!M38","v":0}]
["4th",{"$f":"IF('4th ENTITY'!I11=\"\",\"\",'4th ENTITY'!I11)","v":""},null,null,null,null,null,null,{"$f":"'4th ENTITY'!I38","v":0},null,{"$f":"'4th ENTITY'!K38","v":0},null,{"$f":"'4th ENTITY'!M38","v":0}]
["5th",{"$f":"IF('5th ENTITY'!I11=\"\",\"\",'5th ENTITY'!I11)","v":""},null,null,null,null,null,null,{"$f":"'5th ENTITY'!I38","v":0},null,{"$f":"'5th ENTITY'!K38","v":0},null,{"$f":"'5th ENTITY'!M38","v":0}]
[null,"Adjusted Net Income (for Other Supplementary Business Entities)",null,null,null,null,null,null,{"$f":"SUM(I40:I43)","v":0},null,{"$f":"SUM(K40:K43)","v":0},null,{"$f":"SUM(M40:M43)","v":0}]
[null,"Adjusted Net Income before depreciation (for all Business Entities)",null,null,null,null,null,null,{"$f":"I37+I44","v":0},null,{"$f":"K37+K44","v":0},null,{"$f":"M37+M44","v":0}]
[]
["+P","Plus Depreciation Add Back (including amortisation)"]
[null,"Life insured's share of depreciation from main entity",null,null,null,null,null,null,{"$f":"I47*I17","v":0},null,{"$f":"K47*K17","v":0},null,{"$f":"M47*M17","v":0}]
[null,"Life insured's share of depreciation from other entities",null,null,null,null,null,null,{"$f":"'2nd ENTITY'!I41+'3rd ENTITY'!I41+'4th ENTITY'!I41+'5th ENTITY'!I41","v":0},null,{"$f":"'2nd ENTITY'!K41+'3rd ENTITY'!K41+'4th ENTITY'!K41+'5th ENTITY'!K41","v":0},null,{"$f":"'2nd ENTITY'!M41+'3rd ENTITY'!M41+'4th ENTITY'!M41+'5th ENTITY'!M41","v":0}]
[null,"Total Depreciation (maximum 10% of Adjusted Net Profit rule applies)",null,null,null,null,null,null,{"$f":"IF(I45<0,0,IF((I45*10%)>=(I48+I49),(I48+I49),(I45*10%)))","v":0},null,{"$f":"IF(K45<0,0,IF((K45*10%)>=(K48+K49),(K48+K49),(K45*10%)))","v":0},null,{"$f":"IF(M45<0,0,IF((M45*10%)>=(M48+M49),(M48+M49),(M45*10%)))","v":0}]
[null,"Total Adjusted Net Income (for all Business Entities)",null,null,null,null,null,null,{"$f":"I50+I44+I37","v":0},null,{"$f":"K50+K44+K37","v":0},null,{"$f":"M50+M44+M37","v":0}]
[]
[null,"Plus Salary/Wages etc from 3rd Party Employers",null,null,null,null,null,null,{"$f":"IF(I9=\"\",\"\",I9)","v":""},null,{"$f":"K9","v":""},null,{"$f":"M9","v":""}]
["s/w"]
["s/w"]
["s/w"]
["s/w"]
["s/w"]
[null,"Total Salary/Wages etc from 3rd Party Employers",null,null,null,null,null,null,{"$f":"SUM(I54:I58)","v":0},null,{"$f":"SUM(K54:K58)","v":0},null,{"$f":"SUM(M54:M58)","v":0}]
[]
[null,{"$f":"\"Total Net Income - \"&D10&\"\"","v":"Total Net Income - "},null,null,null,null,null,null,{"$f":"SUM(I51+I59)","v":0},null,{"$f":"SUM(K51+K59)","v":0},null,{"$f":"SUM(M51+M59)","v":0}]
[]
[null,"Net Income - to apply for benefit ie indicative insurable income",null,null,null,null,null,null,{"$f":"ADMIN!F9","v":0}]
[null,"Net unearned/investment income (greater than 25% Net Income = adjustment)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I64>(I63*25%),I63+I64,I63)","v":0}]
[null,"Select AGREED VALUE or INDEMNITY or MORTGAGE REPAYMENT",null,null,null,null,null,"AGREED VALUE",null,null,{"$f":"IF(I63=0,\"\",IF(I63<I61,\"*ATTENTION* INCOME INCREASE\",IF(I61<(K61*80%),\"*ATTENTION* INCOME DROP\",\"\")))","v":""}]
[]
[]
[null,{"$f":"IF(H66=\"AGREED VALUE\",\"INCOME PROTECTION BENEFIT - AGREED VALUE\",IF(H66=\"INDEMNITY\",\"INCOME PROTECTION BENEFIT - INDEMNITY\",\"MORTGAGE REPAYMENT BENEFIT - INCOME BASED\"))","v":"INCOME PROTECTION BENEFIT - AGREED VALUE"},null,null,null,null,null,null,null,null,{"$f":"IF(I64>(I63*25%),\"Adjusted Monthly Benefit\",\"Monthly Benefit\")","v":"Monthly Benefit"}]
[null,{"$f":"IF(H66=\"AGREED VALUE\",\"Replacement Ratios - Agreed Value Benefits\",IF(H66=\"INDEMNITY\",\"Replacement Ratios - Indemnity Benefits\",\"Replacement Ratio - Mortgage Repayment Benefits\"))","v":"Replacement Ratios - Agreed Value Benefits"}]
[null,{"$f":"IF(H66=\"AGREED VALUE\",IF(I65>70000,70000,I65),IF(H66=\"MORTGAGE REPAYMENT\",IF(I65>900000,900000,I65),IF(I65>320000,320000,I65)))","v":0},null,{"$f":"IF(H66=\"AGREED VALUE\",\"62.5% of the first $70,000\",IF(H66=\"MORTGAGE REPAYMENT\",\"45% of income\",\"75% of the first $320,000\"))","v":"62.5% of the first $70,000"},null,null,null,null,{"$f":"IF(H66=\"AGREED VALUE\",B71*62.5%,IF(H66=\"MORTGAGE REPAYMENT\",B71*45%,B71*75%))","v":0},null,{"$f":"IF(K76<0,0,IF(H66=\"AGREED VALUE\",MIN(K76,K77,30000),IF(H66=\"MORTGAGE REPAYMENT\",MIN(K76,K77,30000),MIN(K76,K77,30000))))","v":0}]
[null,{"$f":"IF(H66=\"AGREED VALUE\",IF(I65>100000,30000,IF(I65<70001,0,I65-70000)),IF(H66=\"MORTGAGE REPAYMENT\",\"\",IF(I65>400000,120000,IF(I65<320001,0,I65-320000))))","v":0},null,{"$f":"IF(H66=\"AGREED VALUE\",\"60% of the next $30,000\",IF(H66=\"MORTGAGE REPAYMENT\",\"\",\"50% of the next $120,000\"))","v":"60% of the next $30,000"},null," ",null,null,{"$f":"IF(H66=\"AGREED VALUE\",B72*60%,IF(H66=\"MORTGAGE REPAYMENT\",\"\",B72*50%))","v":0}]
[null,{"$f":"IF(H66=\"AGREED VALUE\",IF(I65>320000,220000,IF(I65<100001,0,I65-100000)),IF(H66=\"MORTGAGE REPAYMENT\",\"\",IF(I65<440001,0,IF(I65<(440000+240000),I65-440000,IF(I65>(440000+240000),240000,IF(I65<(440000+240001),I65-440000,0))))))","v":0},null,{"$f":"IF(H66=\"AGREED VALUE\",\"55% of the next $220,000\",IF(H66=\"MORTGAGE REPAYMENT\",\"\",\"25% of all over $440,000\"))","v":"55% of the next $220,000"},null," ",null,null,{"$f":"IF(H66=\"AGREED VALUE\",B73*55%,IF(H66=\"MORTGAGE REPAYMENT\",\"\",B73*25%))","v":0},null,{"$f":"IF(K69=\"Adjusted Monthly Benefit\",\"NB: Indicative Maximum Monthly Benefit (after unearned/investment income adjustment) - each case subject to individual consideration\",IF(K71=30000,\"NB: Maximum Monthly Benefit is $30,000\",\"NB: Indicative Maximum Monthly Benefit only\"))","v":"NB: Indicative Maximum Monthly Benefit only"}]
[null,{"$f":"IF(H66=\"AGREED VALUE\",IF(I65>440000,120000,IF(I65<320001,0,I65-320000)),\"\")","v":0},null,{"$f":"IF(H66=\"AGREED VALUE\",\"35% of the next $120,000\",\"\")","v":"35% of the next $120,000"},null," ",null,null,{"$f":"IF(H66=\"AGREED VALUE\",B74*35%,\"\")","v":0}]
[null,{"$f":"IF(H66=\"INDEMNITY\",\"\",IF(H66=\"MORTGAGE REPAYMENT\",\"\",IF(I65<440001,0,IF(I65<(440000+676251),I65-440000,IF(I65>(440000+676250),676250,0)))))","v":0},null,{"$f":"IF(H66=\"AGREED VALUE\",\"20% of all over $440,000\",\"\")","v":"20% of all over $440,000"},null,null,null,null,{"$f":"IF(H66=\"AGREED VALUE\",B75*20%,\"\")","v":0}]
[null,{"$f":"IF(B77=\"\",IF(H66=\"AGREED VALUE\",\"Total Agreed Value Benefit After Replacement Ratios\",IF(H66=\"INDEMNITY\",\"Total Indemnity Benefit After Replacement Ratios\",\"Total Mortgage Repayment Benefit After Replacement Ratios\")),\"\")","v":"Total Agreed Value Benefit After Replacement Ratios"},null,null,null,null,null,null,{"$f":"IF(I77=\"\",IF(H66=\"AGREED VALUE\",SUM(I71+I72+I73+I74+I75),IF(H66=\"MORTGAGE REPAYMENT\",I71,SUM(I71+I72+I73))),\"\")","v":0},{"$f":"IF(I77=\"\",\"or\",\"\")","v":"or"},{"$f":"IF(I77=\"\",IF(I76<0,0,IF(I76>360000,30000,I76/12)),\"\")","v":0},{"$f":"IF(I77=\"\",\"pm\",\"\")","v":"pm"}]
[null,{"$f":"IF(ADMIN!H12=\"greater than 25% - adjustment required\",\"Adjusted Total Mortgage Repayment Benefit after unearned income\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(ADMIN!H12=\"less than 25% - no adjustment\",\"\",IF(H66=\"Agreed value\",IF(ADMIN!H21=0,\"\",ADMIN!H22),IF(H66=\"indemnity\",ADMIN!H33,ADMIN!H41)))","v":""},{"$f":"IF(I77=\"\",\"\",\"or\")","v":""},{"$f":"IF(I77=\"\",\"\",I77/12)","v":""},{"$f":"IF(I77=\"\",\"\",\"pm\")","v":""}]
[]
[null,"Additional Notes"]
[]
[]
[]
[]
[]
[null,"Important Information: The purpose of this calculator is to provide an indicative guide only and isn’t intended to be a comprehensive final assessment of an applicant's allowable insured monthly benefit. A final determination of the allowable insured monthly benefit is subject to the satisfactory completion of an application for each life insured, and providing Fidelity Life with all requested information through the application and underwriting process. Conditions, limits and exclusions may apply to any cover issued. Please see the Policy Document for cover terms.  For the full details of the Terms of Use of this calculator please refer to the Help notes.\n\nThis calculator is provided by Fidelity Life Assurance Company Limited\n* Fidelity Life has an A- (Excellent) financial strength rating from A.M. Best. The rating scale that this rating forms part of is available for inspection at our offices. For more information please visit Fidelity Life's financial strength page (https://fidelitylife.nz/our-story/our-financial-strength/) \n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[null,"Version 1.4 November 2023",null,null,null,null,null,null,null,null,{"$f":"NOW()","v":45253.370260763892},null,{"$f":"TODAY()","v":"2023-11-23"}]

{"sheet":"2nd ENTITY","index":1,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,4,3,13],[10,8,10,12],[16,1,16,4],[17,1,17,4],[19,1,19,5],[10,1,10,2],[10,3,10,4],[10,5,10,6],[42,1,49,12],[5,1,7,4],[10,14,40,17],[27,1,27,6],[8,1,8,2],[8,3,8,4],[8,5,8,6],[9,1,9,2],[9,3,9,4],[24,1,24,6],[25,1,25,6],[26,1,26,3],[37,1,37,6],[35,1,35,6],[29,1,29,5],[23,1,23,6]]}
[]
[null,null,null,null,"Insurable income calculator"]
[]
[]
[]
[null,"SECOND ENTITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click here to search for"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Help…","INSTRUCTIONS"]
[null,"Reference",null,{"$f":"IF('MAIN ENTITY'!D9:E9=\"\",\"\",'MAIN ENTITY'!D9:E9)","v":""},null,"Most Recent Year",null,null,{"$f":"IF('MAIN ENTITY'!I9=\"\",\"\",'MAIN ENTITY'!I9)","v":""},null,{"$f":"IF(I9=\"\",\"\",I9-1)","v":""},null,{"$f":"IF(I9=\"\",\"\",I9-2)","v":""}]
[null,"Client Name",null,{"$f":"IF('MAIN ENTITY'!D10:E10=\"\",\"\",'MAIN ENTITY'!D10:E10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"P8","v":"INSTRUCTIONS"}]
[null,"Age/Occupation",null,{"$f":"IF('MAIN ENTITY'!D11:E11=\"\",\"\",'MAIN ENTITY'!D11:E11)","v":""},null,"2nd Entity",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P8,HELP!B4:C43,2,FALSE)","v":"The Insurable Income Calculator is designed to assist with determining an individuals insurable income based on financial information from Tax Returns, Profit & Loss Statements, IRD Income Summary Statements and Pay Slips etc. Please follow the instructions below:\n1. Enter the life insured's details at the top of the MAIN ENTITY worksheet and select whether 'Employee Only' or Self-employed or business owner'.\n2. Enter the most recent financial year at cell I9 eg 2022\n3a. Where the life insured is an EMPLOYEE ONLY and has NO ownership interest in the business (directly or otherwise), select Employee ONLY and enter the life insured's details in the MAIN ENTITY worksheet and enter actual yearly salary & wage figures etc as per the IRD Income Summary Statements etc in the section 'Plus Salary/Wages/Fringe Benefit etc from 3rd Party Employers' (located at rows 54 to 58); or\n3b. Where the life insured is SELF-EMPLOYED (or a business owner) complete the main entity worksheet and where there is more than one trading entity in the business structure complete an additional entity worksheet for each entity by clicking on the GREEN tabs at the bottom of the worksheet.  Complete additional entity worksheets for any additional entities that make up the overall business structure based on the financials for each additional entity. When information has been entered for all entities the summary at the bottom of the MAIN ENTITY worksheet will provide an indicative maximum monthly benefit amount (based on the income from all business entities).\n4. Using the life insured's financials and information in the App and/or FinQ etc complete all WHITE fields as required and refer to the HELP search menu as required to complete each field. \n5. If you are unsure about how to complete the Insurable income calculator, please contact your Underwriter.\n\nPlease note, this calculator provides an indicative guide of insurable income only."}]
[]
["A","Income"]
["-B","Expenses"]
["=C","Net Income",null,null,null,null,null,null,{"$f":"SUM(I13-I14)","v":0},null,{"$f":"SUM(K13-K14)","v":0},null,{"$f":"SUM(M13-M14)","v":0}]
[]
[null,"Ownership Interest"]
[null,"Life Insured's Share of Net Income",null,null,null,null,null,null,{"$f":"SUM(I15*I17)","v":0},null,{"$f":"SUM(K15*K17)","v":0},null,{"$f":"SUM(M15*M17)","v":0}]
[]
[null,"Plus Business Add Backs",null,null,null,null,null,null,{"$f":"IF('MAIN ENTITY'!I20=\"\",\"\",'MAIN ENTITY'!I20)","v":""},null,{"$f":"IF(I20=\"\",\"\",I20-1)","v":""},null,{"$f":"IF(I20=\"\",\"\",I20-2)","v":""}]
["+D","Donations"]
["+E","Motor Vehicles"]
["+F","Loss on the Sale of an Asset"]
["+G"]
["+H"]
["+I"]
[null,"SubtTotal Business Add Backs",null,null,null,null,null,null,{"$f":"SUM(I21:I26)","v":0},null,{"$f":"SUM(K21:K26)","v":0},null,{"$f":"SUM(M21:M26)","v":0}]
[null,{"$f":"\"Total Business Add Backs (\"&D10&\"'s share thereof)\"","v":"Total Business Add Backs ('s share thereof)"},null,null,null,null,null,null,{"$f":"I27*I17","v":0},null,{"$f":"K27*K17","v":0},null,{"$f":"M27*M17","v":0}]
[]
[null,{"$f":"\"Plus (\"&D10&\"'s) Business Add Backs\"","v":"Plus ('s) Business Add Backs"},null,null,null,null,null,null,{"$f":"IF('MAIN ENTITY'!I30=\"\",\"\",'MAIN ENTITY'!I30)","v":""},null,{"$f":"IF(I30=\"\",\"\",I30-1)","v":""},null,{"$f":"IF(I30=\"\",\"\",I30-2)","v":""}]
["+J","Directors Fees"]
["+K","Salary"]
["+L","Superannaution (or KiwiSaver)"]
["+M","Income Split Salary"]
["+N","Income Split Superannuation"]
["+O"]
[]
[null,{"$f":"\"Adjusted Net Income (\"&I11&\")\"","v":"Adjusted Net Income ()"},null,null,null,null,null,null,{"$f":"SUM(I18,I28,I31,I32,I34,I36,I33,I35)","v":0},null,{"$f":"SUM(K18,K28,K31,K32,K34,K36,K33,K35)","v":0},null,{"$f":"SUM(M18,M28,M31,M32,M34,M36,M33,M35)","v":0}]
[]
["+P","Plus Depreciation (including amortisation) Add Back"]
[null,"Life insured's share of depreciation from 2nd entity",null,null,null,null,null,null,{"$f":"I40*I17","v":0},null,{"$f":"K40*K17","v":0},null,{"$f":"M40*M17","v":0}]
[]
[null,"Important Information: The purpose of this calculator is to provide an indicative guide only and isn’t intended to be a comprehensive final assessment of an applicant's allowable insured monthly benefit. A final determination of the allowable insured monthly benefit is subject to the satisfactory completion of an application for each life insured, and providing Fidelity Life with all requested information through the application and underwriting process. Conditions, limits and exclusions may apply to any cover issued. Please see the Policy Document for cover terms. For the full details of the Terms of Use of this calculator please refer to the Help notes.\n\nThis calculator is provided by Fidelity Life Assurance Company Limited\n* Fidelity Life has an A- (Excellent) financial strength rating from A.M. Best. The rating scale that this rating forms part of is available for inspection at our offices. For more information please visit Fidelity Life's financial strength page (https://fidelitylife.nz/our-story/our-financial-strength/) \n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version 1.4 November 2023"]

{"sheet":"3rd ENTITY","index":2,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,4,3,13],[10,8,10,12],[16,1,16,4],[17,1,17,4],[19,1,19,5],[10,1,10,2],[10,3,10,4],[10,5,10,6],[5,1,7,4],[42,1,49,12],[10,14,40,17],[27,1,27,6],[8,1,8,2],[8,3,8,4],[8,5,8,6],[9,1,9,2],[9,3,9,4],[35,1,35,6],[37,1,37,6],[24,1,24,6],[25,1,25,6],[26,1,26,3],[29,1,29,5],[23,1,23,6]]}
[]
[null,null,null,null,"Insurable income calculator"]
[]
[]
[]
[null,"THIRD ENTITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click here to search for"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Help…","INSTRUCTIONS"]
[null,"Reference",null,{"$f":"IF('MAIN ENTITY'!D9:E9=\"\",\"\",'MAIN ENTITY'!D9:E9)","v":""},null,"Most Recent Year",null,null,{"$f":"IF('MAIN ENTITY'!I9=\"\",\"\",'MAIN ENTITY'!I9)","v":""},null,{"$f":"IF(I9=\"\",\"\",I9-1)","v":""},null,{"$f":"IF(I9=\"\",\"\",I9-2)","v":""}]
[null,"Client Name",null,{"$f":"IF('MAIN ENTITY'!D10:E10=\"\",\"\",'MAIN ENTITY'!D10:E10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"P8","v":"INSTRUCTIONS"}]
[null,"Age/Occupation",null,{"$f":"IF('MAIN ENTITY'!D11:E11=\"\",\"\",'MAIN ENTITY'!D11:E11)","v":""},null,"3rd Entity",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P8,HELP!B4:C43,2,FALSE)","v":"The Insurable Income Calculator is designed to assist with determining an individuals insurable income based on financial information from Tax Returns, Profit & Loss Statements, IRD Income Summary Statements and Pay Slips etc. Please follow the instructions below:\n1. Enter the life insured's details at the top of the MAIN ENTITY worksheet and select whether 'Employee Only' or Self-employed or business owner'.\n2. Enter the most recent financial year at cell I9 eg 2022\n3a. Where the life insured is an EMPLOYEE ONLY and has NO ownership interest in the business (directly or otherwise), select Employee ONLY and enter the life insured's details in the MAIN ENTITY worksheet and enter actual yearly salary & wage figures etc as per the IRD Income Summary Statements etc in the section 'Plus Salary/Wages/Fringe Benefit etc from 3rd Party Employers' (located at rows 54 to 58); or\n3b. Where the life insured is SELF-EMPLOYED (or a business owner) complete the main entity worksheet and where there is more than one trading entity in the business structure complete an additional entity worksheet for each entity by clicking on the GREEN tabs at the bottom of the worksheet.  Complete additional entity worksheets for any additional entities that make up the overall business structure based on the financials for each additional entity. When information has been entered for all entities the summary at the bottom of the MAIN ENTITY worksheet will provide an indicative maximum monthly benefit amount (based on the income from all business entities).\n4. Using the life insured's financials and information in the App and/or FinQ etc complete all WHITE fields as required and refer to the HELP search menu as required to complete each field. \n5. If you are unsure about how to complete the Insurable income calculator, please contact your Underwriter.\n\nPlease note, this calculator provides an indicative guide of insurable income only."}]
[]
["A","Income"]
["-B","Expenses"]
["=C","Net Income",null,null,null,null,null,null,{"$f":"SUM(I13-I14)","v":0},null,{"$f":"SUM(K13-K14)","v":0},null,{"$f":"SUM(M13-M14)","v":0}]
[]
[null,"Ownership Interest"]
[null,"Life Insured's Share of Net Income",null,null,null,null,null,null,{"$f":"SUM(I15*I17)","v":0},null,{"$f":"SUM(K15*K17)","v":0},null,{"$f":"SUM(M15*M17)","v":0}]
[]
[null,"Plus Business Add Backs",null,null,null,null,null,null,{"$f":"IF('MAIN ENTITY'!I20=\"\",\"\",'MAIN ENTITY'!I20)","v":""},null,{"$f":"IF(I20=\"\",\"\",I20-1)","v":""},null,{"$f":"IF(I20=\"\",\"\",I20-2)","v":""}]
["+D","Donations"]
["+E","Motor Vehicles"]
["+F","Loss on the Sale of an Asset"]
["+G"]
["+H"]
["+I"]
[null,"SubtTotal Business Add Backs",null,null,null,null,null,null,{"$f":"SUM(I21:I26)","v":0},null,{"$f":"SUM(K21:K26)","v":0},null,{"$f":"SUM(M21:M26)","v":0}]
[null,{"$f":"\"Total Business Add Backs (\"&D10&\"'s share thereof)\"","v":"Total Business Add Backs ('s share thereof)"},null,null,null,null,null,null,{"$f":"I27*I17","v":0},null,{"$f":"K27*K17","v":0},null,{"$f":"M27*M17","v":0}]
[]
[null,{"$f":"\"Plus (\"&D10&\"'s) Business Add Backs\"","v":"Plus ('s) Business Add Backs"}]
["+J","Directors Fees"]
["+K","Salary"]
["+L","Superannaution (or KiwiSaver)"]
["+M","Income Split Salary"]
["+N","Income Split Superannuation"]
["+O"]
[]
[null,{"$f":"\"Adjusted Net Income (\"&I11&\")\"","v":"Adjusted Net Income ()"},null,null,null,null,null,null,{"$f":"SUM(I18,I28,I31,I32,I34,I36,I33,I35)","v":0},null,{"$f":"SUM(K18,K28,K31,K32,K34,K36,K33,K35)","v":0},null,{"$f":"SUM(M18,M28,M31,M32,M34,M36,M33,M35)","v":0}]
[]
["+P","Plus Depreciation (including amortisation) Add Back"]
[null,"Life insured's share of depreciation from 2nd entity",null,null,null,null,null,null,{"$f":"I40*I17","v":0},null,{"$f":"K40*K17","v":0},null,{"$f":"M40*M17","v":0}]
[]
[null,"Important Information: The purpose of this calculator is to provide an indicative guide only and isn’t intended to be a comprehensive final assessment of an applicant's allowable insured monthly benefit. A final determination of the allowable insured monthly benefit is subject to the satisfactory completion of an application for each life insured, and providing Fidelity Life with all requested information through the application and underwriting process. Conditions, limits and exclusions may apply to any cover issued. Please see the Policy Document for cover terms.  For the full details of the Terms of Use of this calculator please refer to the Help notes.\n\nThis calculator is provided by Fidelity Life Assurance Company Limited\n* Fidelity Life has an A- (Excellent) financial strength rating from A.M. Best. The rating scale that this rating forms part of is available for inspection at our offices. For more information please visit Fidelity Life's financial strength page (https://fidelitylife.nz/our-story/our-financial-strength/) \n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version 1.4 November 2023"]

{"sheet":"4th ENTITY","index":3,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,4,3,13],[10,8,10,12],[16,1,16,4],[17,1,17,4],[19,1,19,5],[10,1,10,2],[10,3,10,4],[10,5,10,6],[5,1,7,4],[42,1,49,12],[10,14,40,17],[27,1,27,7],[8,1,8,2],[8,3,8,4],[8,5,8,6],[9,1,9,2],[9,3,9,4],[35,1,35,6],[37,1,37,6],[24,1,24,6],[25,1,25,6],[26,1,26,3],[29,1,29,5],[23,1,23,6]]}
[]
[null,null,null,null,"Insurable income calculator"]
[]
[]
[]
[null,"FOURTH ENTITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click here to search for"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Help…","INSTRUCTIONS"]
[null,"Reference",null,{"$f":"IF('MAIN ENTITY'!D9:E9=\"\",\"\",'MAIN ENTITY'!D9:E9)","v":""},null,"Most Recent Year",null,null,{"$f":"IF('MAIN ENTITY'!I9=\"\",\"\",'MAIN ENTITY'!I9)","v":""},null,{"$f":"IF(I9=\"\",\"\",I9-1)","v":""},null,{"$f":"IF(I9=\"\",\"\",I9-2)","v":""}]
[null,"Client Name",null,{"$f":"IF('MAIN ENTITY'!D10:E10=\"\",\"\",'MAIN ENTITY'!D10:E10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"P8","v":"INSTRUCTIONS"}]
[null,"Age/Occupation",null,{"$f":"IF('MAIN ENTITY'!D11:E11=\"\",\"\",'MAIN ENTITY'!D11:E11)","v":""},null,"4th Entity",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P8,HELP!B4:C43,2,FALSE)","v":"The Insurable Income Calculator is designed to assist with determining an individuals insurable income based on financial information from Tax Returns, Profit & Loss Statements, IRD Income Summary Statements and Pay Slips etc. Please follow the instructions below:\n1. Enter the life insured's details at the top of the MAIN ENTITY worksheet and select whether 'Employee Only' or Self-employed or business owner'.\n2. Enter the most recent financial year at cell I9 eg 2022\n3a. Where the life insured is an EMPLOYEE ONLY and has NO ownership interest in the business (directly or otherwise), select Employee ONLY and enter the life insured's details in the MAIN ENTITY worksheet and enter actual yearly salary & wage figures etc as per the IRD Income Summary Statements etc in the section 'Plus Salary/Wages/Fringe Benefit etc from 3rd Party Employers' (located at rows 54 to 58); or\n3b. Where the life insured is SELF-EMPLOYED (or a business owner) complete the main entity worksheet and where there is more than one trading entity in the business structure complete an additional entity worksheet for each entity by clicking on the GREEN tabs at the bottom of the worksheet.  Complete additional entity worksheets for any additional entities that make up the overall business structure based on the financials for each additional entity. When information has been entered for all entities the summary at the bottom of the MAIN ENTITY worksheet will provide an indicative maximum monthly benefit amount (based on the income from all business entities).\n4. Using the life insured's financials and information in the App and/or FinQ etc complete all WHITE fields as required and refer to the HELP search menu as required to complete each field. \n5. If you are unsure about how to complete the Insurable income calculator, please contact your Underwriter.\n\nPlease note, this calculator provides an indicative guide of insurable income only."}]
[]
["A","Income"]
["-B","Expenses"]
["=C","Net Income",null,null,null,null,null,null,{"$f":"SUM(I13-I14)","v":0},null,{"$f":"SUM(K13-K14)","v":0},null,{"$f":"SUM(M13-M14)","v":0}]
[]
[null,"Ownership Interest"]
[null,"Life Insured's Share of Net Income",null,null,null,null,null,null,{"$f":"SUM(I15*I17)","v":0},null,{"$f":"SUM(K15*K17)","v":0},null,{"$f":"SUM(M15*M17)","v":0}]
[]
[null,"Plus Business Add Backs",null,null,null,null,null,null,{"$f":"IF('MAIN ENTITY'!I20=\"\",\"\",'MAIN ENTITY'!I20)","v":""},null,{"$f":"IF(I20=\"\",\"\",I20-1)","v":""},null,{"$f":"IF(I20=\"\",\"\",I20-2)","v":""}]
["+D","Donations"]
["+E","Motor Vehicles"]
["+F","Loss on the Sale of an Asset"]
["+G"]
["+H"]
["+I"]
[null,"SubtTotal Business Add Backs",null,null,null,null,null,null,{"$f":"SUM(I21:I26)","v":0},null,{"$f":"SUM(K21:K26)","v":0},null,{"$f":"SUM(M21:M26)","v":0}]
[null,{"$f":"\"Total Business Add Backs (\"&D10&\"'s share thereof)\"","v":"Total Business Add Backs ('s share thereof)"},null,null,null,null,null,null,{"$f":"I27*I17","v":0},null,{"$f":"K27*K17","v":0},null,{"$f":"M27*M17","v":0}]
[]
[null,{"$f":"\"Plus (\"&D10&\"'s) Business Add Backs\"","v":"Plus ('s) Business Add Backs"}]
["+J","Directors Fees"]
["+K","Salary"]
["+L","Superannaution (or KiwiSaver)"]
["+M","Income Split Salary"]
["+N","Income Split Superannuation"]
["+O"]
[]
[null,{"$f":"\"Adjusted Net Income (\"&I11&\")\"","v":"Adjusted Net Income ()"},null,null,null,null,null,null,{"$f":"SUM(I18,I28,I31,I32,I34,I36,I33,I35)","v":0},null,{"$f":"SUM(K18,K28,K31,K32,K34,K36,K33,K35)","v":0},null,{"$f":"SUM(M18,M28,M31,M32,M34,M36,M33,M35)","v":0}]
[]
["+P","Plus Depreciation (including amortisation) Add Back"]
[null,"Life insured's share of depreciation from 2nd entity",null,null,null,null,null,null,{"$f":"I40*I17","v":0},null,{"$f":"K40*K17","v":0},null,{"$f":"M40*M17","v":0}]
[]
[null,"Important Information: The purpose of this calculator is to provide an indicative guide only and isn’t intended to be a comprehensive final assessment of an applicant's allowable insured monthly benefit. A final determination of the allowable insured monthly benefit is subject to the satisfactory completion of an application for each life insured, and providing Fidelity Life with all requested information through the application and underwriting process. Conditions, limits and exclusions may apply to any cover issued. Please see the Policy Document for cover terms.  For the full details of the Terms of Use of this calculator please refer to the Help notes.\n\nThis calculator is provided by Fidelity Life Assurance Company Limited\n* Fidelity Life has an A- (Excellent) financial strength rating from A.M. Best. The rating scale that this rating forms part of is available for inspection at our offices. For more information please visit Fidelity Life's financial strength page (https://fidelitylife.nz/our-story/our-financial-strength/) \n\n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version 1.4 November 2023"]

{"sheet":"5th ENTITY","index":4,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,4,3,13],[10,14,40,17],[19,1,19,5],[37,1,37,6],[10,1,10,2],[10,3,10,4],[10,5,10,6],[24,1,24,6],[10,8,10,12],[16,1,16,4],[17,1,17,4],[42,1,49,12],[5,1,7,4],[25,1,25,6],[26,1,26,3],[29,1,29,5],[35,1,35,6],[23,1,23,6],[27,1,27,7],[8,1,8,2],[8,3,8,4],[8,5,8,6],[9,1,9,2],[9,3,9,4]]}
[]
[null,null,null,null,"Insurable income calculator"]
[]
[]
[]
[null,"FIFTH ENTITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click here to search for"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Help…","INSTRUCTIONS"]
[null,"Reference",null,{"$f":"IF('MAIN ENTITY'!D9:E9=\"\",\"\",'MAIN ENTITY'!D9:E9)","v":""},null,"Most Recent Year",null,null,{"$f":"IF('MAIN ENTITY'!I9=\"\",\"\",'MAIN ENTITY'!I9)","v":""},null,{"$f":"IF(I9=\"\",\"\",I9-1)","v":""},null,{"$f":"IF(I9=\"\",\"\",I9-2)","v":""}]
[null,"Client Name",null,{"$f":"IF('MAIN ENTITY'!D10:E10=\"\",\"\",'MAIN ENTITY'!D10:E10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"P8","v":"INSTRUCTIONS"}]
[null,"Age/Occupation",null,{"$f":"IF('MAIN ENTITY'!D11:E11=\"\",\"\",'MAIN ENTITY'!D11:E11)","v":""},null,"5th Entity",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P8,HELP!B4:C43,2,FALSE)","v":"The Insurable Income Calculator is designed to assist with determining an individuals insurable income based on financial information from Tax Returns, Profit & Loss Statements, IRD Income Summary Statements and Pay Slips etc. Please follow the instructions below:\n1. Enter the life insured's details at the top of the MAIN ENTITY worksheet and select whether 'Employee Only' or Self-employed or business owner'.\n2. Enter the most recent financial year at cell I9 eg 2022\n3a. Where the life insured is an EMPLOYEE ONLY and has NO ownership interest in the business (directly or otherwise), select Employee ONLY and enter the life insured's details in the MAIN ENTITY worksheet and enter actual yearly salary & wage figures etc as per the IRD Income Summary Statements etc in the section 'Plus Salary/Wages/Fringe Benefit etc from 3rd Party Employers' (located at rows 54 to 58); or\n3b. Where the life insured is SELF-EMPLOYED (or a business owner) complete the main entity worksheet and where there is more than one trading entity in the business structure complete an additional entity worksheet for each entity by clicking on the GREEN tabs at the bottom of the worksheet.  Complete additional entity worksheets for any additional entities that make up the overall business structure based on the financials for each additional entity. When information has been entered for all entities the summary at the bottom of the MAIN ENTITY worksheet will provide an indicative maximum monthly benefit amount (based on the income from all business entities).\n4. Using the life insured's financials and information in the App and/or FinQ etc complete all WHITE fields as required and refer to the HELP search menu as required to complete each field. \n5. If you are unsure about how to complete the Insurable income calculator, please contact your Underwriter.\n\nPlease note, this calculator provides an indicative guide of insurable income only."}]
[]
["A","Income"]
["-B","Expenses"]
["=C","Net Income",null,null,null,null,null,null,{"$f":"SUM(I13-I14)","v":0},null,{"$f":"SUM(K13-K14)","v":0},null,{"$f":"SUM(M13-M14)","v":0}]
[]
[null,"Ownership Interest"]
[null,"Life Insured's Share of Net Income",null,null,null,null,null,null,{"$f":"SUM(I15*I17)","v":0},null,{"$f":"SUM(K15*K17)","v":0},null,{"$f":"SUM(M15*M17)","v":0}]
[]
[null,"Plus Business Add Backs",null,null,null,null,null,null,{"$f":"IF('MAIN ENTITY'!I20=\"\",\"\",'MAIN ENTITY'!I20)","v":""},null,{"$f":"IF(I20=\"\",\"\",I20-1)","v":""},null,{"$f":"IF(I20=\"\",\"\",I20-2)","v":""}]
["+D","Donations"]
["+E","Motor Vehicles"]
["+F","Loss on the Sale of an Asset"]
["+G"]
["+H"]
["+I"]
[null,"SubtTotal Business Add Backs",null,null,null,null,null,null,{"$f":"SUM(I21:I26)","v":0},null,{"$f":"SUM(K21:K26)","v":0},null,{"$f":"SUM(M21:M26)","v":0}]
[null,{"$f":"\"Total Business Add Backs (\"&D10&\"'s share thereof)\"","v":"Total Business Add Backs ('s share thereof)"},null,null,null,null,null,null,{"$f":"I27*I17","v":0},null,{"$f":"K27*K17","v":0},null,{"$f":"M27*M17","v":0}]
[]
[null,{"$f":"\"Plus (\"&D10&\"'s) Business Add Backs\"","v":"Plus ('s) Business Add Backs"}]
["+J","Directors Fees"]
["+K","Salary"]
["+L","Superannaution (or KiwiSaver)"]
["+M","Income Split Salary"]
["+N","Income Split Superannuation"]
["+O"]
[]
[null,{"$f":"\"Adjusted Net Income (\"&I11&\")\"","v":"Adjusted Net Income ()"},null,null,null,null,null,null,{"$f":"SUM(I18,I28,I31,I32,I34,I36,I33,I35)","v":0},null,{"$f":"SUM(K18,K28,K31,K32,K34,K36,K33,K35)","v":0},null,{"$f":"SUM(M18,M28,M31,M32,M34,M36,M33,M35)","v":0}]
[]
["+P","Plus Depreciation (including amortisation) Add Back"]
[null,"Life insured's share of depreciation from 2nd entity",null,null,null,null,null,null,{"$f":"I40*I17","v":0},null,{"$f":"K40*K17","v":0},null,{"$f":"M40*M17","v":0}]
[]
[null,"Important Information: The purpose of this calculator is to provide an indicative guide only and isn’t intended to be a comprehensive final assessment of an applicant's allowable insured monthly benefit. A final determination of the allowable insured monthly benefit is subject to the satisfactory completion of an application for each life insured, and providing Fidelity Life with all requested information through the application and underwriting process. Conditions, limits and exclusions may apply to any cover issued. Please see the Policy Document for cover terms. For the full details of the Terms of Use of this calculator please refer to the Help notes.\n\nThis calculator is provided by Fidelity Life Assurance Company Limited\n* Fidelity Life has an A- (Excellent) financial strength rating from A.M. Best. The rating scale that this rating forms part of is available for inspection at our offices. For more information please visit Fidelity Life's financial strength page (https://fidelitylife.nz/our-story/our-financial-strength/) \n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version 1.4 November 2023"]

{"sheet":"RKP","index":5,"n_rows":51,"n_cols":34,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,4,3,13],[8,1,10,4],[6,3,6,4],[7,3,7,4],[6,1,6,2],[7,1,7,2],[5,15,6,16],[12,12,13,12],[12,10,13,10],[8,5,8,6],[8,8,8,12],[11,15,50,18],[50,10,50,11],[50,12,50,13],[37,1,39,12],[15,2,15,4],[16,2,16,4],[17,2,17,4],[19,6,19,10],[25,7,25,11],[18,1,18,6],[14,2,14,4],[51,1,51,6],[52,1,52,6],[54,1,54,6],[55,1,55,5],[57,1,57,6],[53,1,53,6],[20,1,22,6],[22,12,23,12],[22,8,23,8],[22,10,23,10],[27,7,27,11],[69,1,69,2],[69,10,71,12],[70,1,70,2],[71,1,71,2],[59,10,60,12],[62,7,62,9],[62,10,62,12],[65,10,66,12],[67,1,67,2],[67,10,68,12],[68,1,68,2],[76,1,79,12],[81,1,86,12],[88,10,88,11],[88,12,88,13],[75,1,75,3],[41,1,48,12],[28,12,29,12],[30,2,30,4],[31,2,31,4],[49,1,49,13],[35,1,35,6],[36,1,36,6]]}
[]
[null,null,null,null,"Rural key person cover calculator"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lemon",null,null,null,"The Cookie Shop",null,null,null,null,null,1,"lemon","Fred smith"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Help Notes",null,null,null,null,null,"pie",null,null,"Cookie type","lemon",null,null,null,null,null,2,"pie"," doodle dandy"]
[null,"Reference"]
[null,"Client Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click here to search for"]
[null,"FARM OWNER(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Help…","INSTRUCTIONS",null,null,null,null,"monkey",null,null,null,null,null,null,null,null,null,5,"monkey","itchy and scratchy went to market"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q9","v":"INSTRUCTIONS"}]
[null,"Gross farm income (enter the gross farm income or GFI)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q9,HELP!B46:C68,2,FALSE)","v":"The Rural key person cover (or RKP) calculator is designed to assist in providing an indicative guide as to the maximum RKP benefit an individual FARM OWNER or SHAREMILKER may support based on financial information from farm Profit & Loss Statements or the Sharemilking (or Contract milker) agreement (contract) etc. Please follow the instructions below:\n1. Enter your reference and the client's details at the top of the RKP worksheet in the WHITE fields as required.\n2. Complete either the FARM OWNER or SHAREMILKER section depending on whether your client is a farm owner or share-milker (the latter section also applies contract milkers)\n2a. Where the client is FARM OWNER enter the Gross farm income (row 12) and their name as Person 1 (row 15). Enter the names of any other owners as Person 2, 3 & 4 accordingly as required (rows 16-18). Select Hours per week or % O'ship as the method of calculation to determine the split of Gross farm income (column K) and the indicative monthly benefit (column M); or\n2b. Where the client is a SHAREMILKER or CONTRACT MILKER refer to their milking agreement, and complete the SHAREMILKER section accordingly depending upon whether their agreement is based on a Production target for milksolids (row 25) or the Number of cows in the herd (row 27), to determine the indicative monthly benefit (column M). \n3. Refer to the HELP search menu as required to complete each field. \n4. If you are unsure about how to complete the Rural key person cover calculator, please contact your Underwriter. \n\nIf cover is for a key worker, who is not a FARM OWNER or SHAREMILKER please contact your underwriter.  A SHAREMILKER includes contract milkers. \n\nPlease note, this calculator provides an indicative guide of the RKP monthly benefit only."}]
[null,null,null,null,null,null,null,null,null,null,"Split of GFI",null,"RKP monthly benefit"]
[null,"Farm owners (enter the names of all the farm owners who work on the farm)",null,null,null,null,null,null,"Hours per week"]
[null,"Person 1",null,null,null,null,null,null,null,null,{"$f":"IF(I15=0,0,IF($I$14=\"Hours per week\",(I15/$I$19)*$G$12,IF($I$19=100,(I15/$I$19)*$G$12,0)))","v":0},1,{"$f":"IF(K15=\"\",\"\",IF(((K15*35%)/12)>10000,10000,((K15*35%)/12)))","v":0}]
[null,"Person 2",null,null,null,null,null,null,null,null,{"$f":"IF(I16=0,0,IF($I$14=\"Hours per week\",(I16/$I$19)*$G$12,IF($I$19=100,(I16/$I$19)*$G$12,0)))","v":0},2,{"$f":"IF(K16=\"\",\"\",IF(((K16*35%)/12)>10000,10000,((K16*35%)/12)))","v":0}]
[null,"Person 3",null,null,null,null,null,null,null,null,{"$f":"IF(I17=0,0,IF($I$14=\"Hours per week\",(I17/$I$19)*$G$12,IF($I$19=100,(I17/$I$19)*$G$12,0)))","v":0},3,0]
[null,"Person 4",null,null,null,null,null,null,null,null,{"$f":"IF(I18=0,0,IF($I$14=\"Hours per week\",(I18/$I$19)*$G$12,IF($I$19=100,(I18/$I$19)*$G$12,0)))","v":0},4,0]
[null,{"$f":"\"Total based on (\"&I14&\") - be sure to enter hours for each person named\"","v":"Total based on (Hours per week) - be sure to enter hours for each person named"},null,null,null,null,null,null,{"$f":"SUM(I15:I18)","v":0},null,{"$f":"SUM(K15:K18)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(I14=\"% O'ship\",IF(I19=100,\"\",\"ERROR Total % O'ship must be 100\"),\"\")","v":""}]
[null,"SHAREMILKER or CONTRACT MILKER"]
[]
[null,null,null,null,null,null,null,null,"% to SM",null,"$ per kgMS",null,"RKP monthly benefit"]
[null,"Basis of agreement (complete according to the terms of the sharemilking agreement)"]
[null,"Target production (enter kg of milk solids annual target production)",null,null,null,null,null,null,null,"OR",null,{"$f":"IF($H26=\"\",IF($I25>0,($G25*7.4*$I25*35%)/12,($G25*$K25*35%)/12),0)","v":0},{"$f":"IF(L25>10000,10000,L25)","v":0}]
[null,"OR",null,null,null,null,null,{"$f":"IF(AND(I25>0,K25>0),\"ERROR Either % to SM OR $ per kg - not both\",\"\")","v":""}]
[null,"Number of cows (enter the number of cows in the herd)",null,null,null,null,null,null,null,"OR",null,{"$f":"IF($H28=\"\",IF($I27>0,($G27*383*7.4*$I27*35%)/12,($G27*383*$K27*35%)/12),0)","v":0},{"$f":"IF(L27>10000,10000,L27)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(I27>0,K27>0),\"ERROR Either % to SM OR $ per kg - not both\",\"\")","v":""}]
[null,"Where a couple or spouses are joint sharemilking or contract milking also complete Split of GFI",null,null,null,null,null,null,null,null,null,null,"RKP monthly benefit"]
[null,"Split of Gross farm income (based on either Target production or Number of cows)",null,null,null,null,null,null,"Hours per week",null,"Target prod'n"]
[null,"Person 1",null,null,null,null,null,null,null,null,{"$f":"IF(I33=0,0,IF($K$30=\"Number of cows\",(($L$27*12)*(I31/$I$33))/0.35,(($L$25*12)*(I31/$I$33))/0.35))","v":0},1,{"$f":"IF(K31=\"\",\"\",IF(((K31*35%)/12)>10000,10000,((K31*35%)/12)))","v":0}]
[null,"Person 2",null,null,null,null,null,null,null,null,{"$f":"IF(I33=0,0,IF($K$30=\"Number of cows\",(($L$27*12)*(I32/$I$33))/0.35,(($L$25*12)*(I32/$I$33))/0.35))","v":0},2,{"$f":"IF(K32=\"\",\"\",IF(((K32*35%)/12)>10000,10000,((K32*35%)/12)))","v":0}]
[null,"Total based on (Hours per week) - be sure to enter hours for both persons named",null,null,null,null,null,null,{"$f":"IF(SUM(I31:I32)<0,0,SUM(I31:I32))","v":0},null,{"$f":"SUM(K31:K32)","v":0}]
[]
[null,"NB: The maximum Rural key person cover monthly benefit is $10,000 and the RKP monthly benefit is the maximum indicative monthly benefit only. "]
[]
[null,"Additional Notes"]
[]
[]
[]
[]
[null,"Important Information: The purpose of this calculator is to provide an indicative guide only and isn’t intended to be a comprehensive final assessment of an applicant's allowable insured monthly benefit. A final determination of the allowable insured monthly benefit is subject to the satisfactory completion of an application for each life insured, and providing Fidelity Life with all requested information through the application and underwriting process. Conditions, limits and exclusions may apply to any cover issued. Please see the Policy Document for cover terms.  For the full details of the Terms of Use of this calculator please refer to the Help notes.\n\nThis calculator is provided by Fidelity Life Assurance Company Limited\n* Fidelity Life has an A- (Excellent) financial strength rating from A.M. Best. The rating scale that this rating forms part of is available for inspection at our offices. For more information please visit Fidelity Life's financial strength page (https://fidelitylife.nz/our-story/our-financial-strength/) \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version 1.4 November 2023",null,null,null,null,null,null,null,null,{"$f":"NOW()","v":45253.370260763892},null,{"$f":"TODAY()","v":"2023-11-23"}]

{"sheet":"Sheet1","index":6,"n_rows":81,"n_cols":3,"rows_kept":81,"cut":false,"hidden":true,"merged":[]}
["RESET"]
[]
["Worksheet","Range ","Value"]
["MAIN ENTITY","D9:e9"]
["MAIN ENTITY","D10:e10"]
["MAIN ENTITY","D11:e11"]
["MAIN ENTITY","i9"]
["MAIN ENTITY","i11:m11"]
["MAIN ENTITY","i13"]
["MAIN ENTITY","i14"]
["MAIN ENTITY","i17"]
["MAIN ENTITY","i21"]
["MAIN ENTITY","i22"]
["MAIN ENTITY","i23"]
["MAIN ENTITY","i24"]
["MAIN ENTITY","i25"]
["MAIN ENTITY","i26"]
["MAIN ENTITY","i31"]
["MAIN ENTITY","i32"]
["MAIN ENTITY","i33"]
["MAIN ENTITY","i34"]
["MAIN ENTITY","i35"]
["MAIN ENTITY","i36"]
["MAIN ENTITY","i47"]
["MAIN ENTITY","i54"]
["MAIN ENTITY","i55"]
["MAIN ENTITY","i56"]
["MAIN ENTITY","i57"]
["MAIN ENTITY","i58"]
["MAIN ENTITY","i64"]
["MAIN ENTITY","k13"]
["MAIN ENTITY","k14"]
["MAIN ENTITY","k17"]
["MAIN ENTITY","k21"]
["MAIN ENTITY","k22"]
["MAIN ENTITY","k23"]
["MAIN ENTITY","k24"]
["MAIN ENTITY","k25"]
["MAIN ENTITY","k26"]
["MAIN ENTITY","k31"]
["MAIN ENTITY","k32"]
["MAIN ENTITY","k33"]
["MAIN ENTITY","k34"]
["MAIN ENTITY","k35"]
["MAIN ENTITY","k36"]
["MAIN ENTITY","k47"]
["MAIN ENTITY","k54"]
["MAIN ENTITY","k55"]
["MAIN ENTITY","k56"]
["MAIN ENTITY","k57"]
["MAIN ENTITY","k58"]
["MAIN ENTITY","m13"]
["MAIN ENTITY","m14"]
["MAIN ENTITY","m17"]
["MAIN ENTITY","m21"]
["MAIN ENTITY","m22"]
["MAIN ENTITY","m23"]
["MAIN ENTITY","m24"]
["MAIN ENTITY","m25"]
["MAIN ENTITY","m26"]
["MAIN ENTITY","m31"]
["MAIN ENTITY","m32"]
["MAIN ENTITY","m33"]
["MAIN ENTITY","m34"]
["MAIN ENTITY","m35"]
["MAIN ENTITY","m36"]
["MAIN ENTITY","m47"]
["MAIN ENTITY","m54"]
["MAIN ENTITY","m55"]
["MAIN ENTITY","m57"]
["MAIN ENTITY","m58"]
["MAIN ENTITY","B24:g24"]
["MAIN ENTITY","B25:g25"]
["MAIN ENTITY","B26:g26"]
["MAIN ENTITY","B36:g36"]
["MAIN ENTITY","b54:g54"]
["MAIN ENTITY","B55:g55"]
["MAIN ENTITY","B56:g56"]
["MAIN ENTITY","B57:g57"]
["MAIN ENTITY","B58:g58"]
["MAIN ENTITY","B80:m83"]

{"sheet":"BE CALC","index":7,"n_rows":78,"n_cols":21,"rows_kept":78,"cut":false,"hidden":true,"merged":[[46,1,46,5],[53,2,53,4],[54,2,54,4],[7,1,7,2],[8,5,8,6],[10,5,10,6],[7,3,7,4],[8,1,8,2],[8,3,8,4],[57,13,58,15],[55,2,55,4],[55,13,56,15],[58,7,58,9],[77,16,77,18],[70,1,75,17],[63,1,68,17],[62,1,62,3],[59,7,59,9],[53,13,54,15],[45,1,45,5],[11,19,50,22],[0,4,0,8],[2,4,3,19],[7,11,7,13],[7,15,7,17],[8,15,8,17],[42,1,42,5],[8,11,8,13],[43,1,43,5],[44,1,44,5],[8,7,8,9],[7,7,7,9],[6,1,6,2],[6,3,6,4]]}
["                  "]
[]
[null,null,null,null,"Business Expenses - Ongoing fixed expenses calculator"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable for all new Business expenses policies from 1 July 2022"]
[]
[null,"Reference"]
[null,"Client Name",null,null,null,null,null,"Entity 1",null,null,null,"Entity 2",null,null,null,"Entity 3",null,null,null,null,"Click here to search for"]
[null,"Age/Occupation",null,null,null,"Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,"Help…","INSTRUCTIONS"]
[]
[null,"Eligible Business Overheads",null,null,null,"Most Recent Year",null,null,null,{"$f":"IF(H11=\"\",\"\",H11-1)","v":""},null,{"$f":"IF(H11=\"\",\"\",H11)","v":""},null,{"$f":"IF(H11=\"\",\"\",H11-1)","v":""},null,{"$f":"IF(H11=\"\",\"\",H11)","v":""},null,{"$f":"IF(H11=\"\",\"\",H11-1)","v":""},null,{"$f":"U9","v":"INSTRUCTIONS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(U9,HELP!B74:C114,2,FALSE)","v":"The Business Expenses (BE) Calculator is designed to assist in determining the amount of eligible business expenses for Business expenses cover based on financial information from Tax Returns, Profit & Loss Statements etc for all the entities that make up the business structure. Please note, the BE Calculator only provides an indicative guide to the maximum level of business overheads cover that may be supported.\n\nTo use the BE calculator follow these steps:\n1. Complete all WHITE fields as required, starting with life insured’s Name, Name of Entity, Year, then enter the actual yearly figures as per the information from the Tax Returns and/or Profit & Loss Statement etc. Refer to the Help drop down menu as required for guidance on completing each field. Where several items come under just one Eligible business overheads description eg. Professional Registrations $800 and Professional Membership $400. These should be included under Registrations by entering =800+400 in the appropriate field.\n2. Where there is more than one entity complete additional entity columns shown (for up to 3 entities). \n3. Enter the life insured’s ownership interest for each entity for each year at the bottom of each column (row 49). The information you complete for all entities will then be summarised and automatically updated in the Summary of Eligible Business expenses at the bottom of the page. \n\nPlease refer to the actual Business expenses cover policy documents for further information on what are eligible business overheads and what is payable under a Business Expenses contracts. This BE Calculator is intended to provide an indicative guide only."}]
[1,"Accounting Fees"]
[{"$f":"A13+1","v":2},"ACC Levies (non income producing employees only)"]
[{"$f":"A14+1","v":3},"Advertising"]
[4,"Audit Fees"]
[5,"Bank Fees"]
[6,"Cleaning (fixed contracts only)"]
[7,"Computer & IT Costs (fixed support contracts only)"]
[8,"Electricity  (and other utility costs)"]
[9,"Filing Fees"]
[10,"Gas"]
[11,"Heating"]
[12,"Hire of Business Plant and/or Equipment"]
[13,"Insurance - Business Insurance Premiums only (NOT income protection)"]
[14,"Interest - Business only"]
[15,"Lease Costs - Business Equipment & Vehicles (paid to 3rd parties only)"]
[16,"Legal Fees (fixed and regular only)"]
[17,"Loan Principal/Capital Repayments on business assets (min repayments only)"]
[18,"Locum (net cost only ie cost less revenue produced by locum)"]
[19,"Motor Vehicle (registration, WOF, insurance and leasing costs only)"]
[20,"Printing, Postage & Stationery"]
[21,"Property Rates and Taxes"]
[22,"Registrations - Business and Professional only"]
[23,"Rent (paid to third parties only)"]
[24,"Repairs & Maintenance (fixed contract only)"]
[25,"Salary/Wages (non income producing employees only)"]
[26,"Security (fixed contract only)"]
[27,"Subscriptions - Business and Professional only"]
[28,"Superannuation or KiwiSaver (non income producing employees only)"]
[29,"Telephone"]
[30,"Water"]
[31]
[32]
[33]
[34]
[35]
[null,"Total Eligible Business Overheads",null,null,null,null,null,{"$f":"SUM(H13:H47)","v":0},null,{"$f":"SUM(J13:J47)","v":0},null,{"$f":"SUM(L13:L47)","v":0},null,{"$f":"SUM(N13:N47)","v":0},null,{"$f":"SUM(P13:P47)","v":0},null,{"$f":"SUM(R13:R47)","v":0}]
[]
[null,{"$f":"\"\"&D8&\"'s Ownership Interest\"","v":"'s Ownership Interest"}]
[null,{"$f":"\"\"&D8&\"'s share of Eligible Business Overheads\"","v":"'s share of Eligible Business Overheads"},null,null,null,null,null,{"$f":"SUM(H48*H50)","v":0},null,{"$f":"SUM(J48*J50)","v":0},null,{"$f":"SUM(L48*L50)","v":0},null,{"$f":"SUM(N48*N50)","v":0},null,{"$f":"SUM(P48*P50)","v":0},null,{"$f":"SUM(R48*R50)","v":0}]
[]
[null,"Summary of Eligible Business Overheads"]
[null,null,{"$f":"IF(H9=\"\",\"\",H9)","v":""},null,null,null,null,{"$f":"H51","v":0},null,{"$f":"J51","v":0},null,null,null,"Monthly Benefit"]
[null,null,{"$f":"IF(L9=\"\",\"\",L9)","v":""},null,null,null,null,{"$f":"L51","v":0},null,{"$f":"N51","v":0},null,null,{"$f":"H60","v":0}]
[null,null,{"$f":"IF(P9=\"\",\"\",P9)","v":""},null,null,null,null,{"$f":"P51","v":0},null,{"$f":"R51","v":0},null,null,null,{"$f":"IF(H60>60000,60000,H60)","v":0}]
[null,{"$f":"\"Total Eligible Business Overheads for \"&D8&\"\"","v":"Total Eligible Business Overheads for "},null,null,null,null,null,{"$f":"SUM(H54:H56)","v":0},null,{"$f":"SUM(J54:J56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N56<1000,\"NB: Minimum monthly amount insured is $1,000\",IF(N56=60000,\"NB: Maximum monthly amount insured is $60,000\",\"\"))","v":"NB: Minimum monthly amount insured is $1,000"}]
[null,"Total Maximum Annual Benefit (lesser of Current Year or Average)",null,null,null,null,null,{"$f":"IF(J57=0,H57,IF(H57<((H57+J57)/2),H57,((H57+J57)/2)))","v":0}]
[null,"Total Maximum Monthly Benefit",null,null,null,null,null,{"$f":"SUM(H59/12)","v":0}]
[]
[]
[null,"Notes & Comments"]
[]
[]
[]
[]
[]
[]
[]
[null,"Important Information: The purpose of this calculator is to provide an indicative guide only and is not intended to be a comprehensive final assessment of an applicant's allowable insured monthly benefit. A final determination of the allowable insured monthly benefit is subject to the satisfactory completion of an application, including a personal statement for each life insured, and providing Fidelity with all information it requests through the underwriting process. Conditions, limits and exclusions may apply and are explained in the applicable FidelityPolicy Documents. Always consider the Policy Docucuments before making any decision in relation to insurance.\nFor the full details of the Terms of Use of this calculator please refer to the Help notes.\n\nThis calculator is prepared by Fidelity Life Assurance Company Limited."]
[]
[]
[]
[]
[]
[]
[null,"Version XXX",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":45253.370260763892},{"$f":"TODAY()","v":"2023-11-23"}]

{"sheet":"HELP","index":8,"n_rows":135,"n_cols":3,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
[]
["Insurable income calculator Help"]
["Number","Help Topic","Help Topic Content"]
[1,"INSTRUCTIONS","The Insurable Income Calculator is designed to assist with determining an individuals insurable income based on financial information from Tax Returns, Profit & Loss Statements, IRD Income Summary Statements and Pay Slips etc. Please follow the instructions below:\n1. Enter the life insured's details at the top of the MAIN ENTITY worksheet and select whether 'Employee Only' or Self-employed or business owner'.\n2. Enter the most recent financial year at cell I9 eg 2022\n3a. Where the life insured is an EMPLOYEE ONLY and has NO ownership interest in the business (directly or otherwise), select Employee ONLY and enter the life insured's details in the MAIN ENTITY worksheet and enter actual yearly salary & wage figures etc as per the IRD Income Summary Statements etc in the section 'Plus Salary/Wages/Fringe Benefit etc from 3rd Party Employers' (located at rows 54 to 58); or\n3b. Where the life insured is SELF-EMPLOYED (or a business owner) complete the main entity worksheet and where there is more than one trading entity in the business structure complete an additional entity worksheet for each entity by clicking on the GREEN tabs at the bottom of the worksheet.  Complete additional entity worksheets for any additional entities that make up the overall business structure based on the financials for each additional entity. When information has been entered for all entities the summary at the bottom of the MAIN ENTITY worksheet will provide an indicative maximum monthly benefit amount (based on the income from all business entities).\n4. Using the life insured's financials and information in the App and/or FinQ etc complete all WHITE fields as required and refer to the HELP search menu as required to complete each field. \n5. If you are unsure about how to complete the Insurable income calculator, please contact your Underwriter.\n\nPlease note, this calculator provides an indicative guide of insurable income only."]
[2,"A-B=C","For SELF-EMPLOYED (or business owners) review the financials and use the Profit & Loss (for each entity that makes up the overall business structure) to determine insurable income by calculating A-B=C plus Add-backs. Key points here are:\n• “A” includes only those items shown in the Revenue sections of the Profit & Loss that relate to Active Income. Hence, “A” does NOT include:\no Dividends\no Distributions\no Drawings\no Rent from third parties\no Royalties\no Interest or an investment or passive income\no Gain on the Sale of an Asset\no Any other item NOT related to Active Income\n• “B” is generally always Total Expenses, as shown in the Profit & Loss.\n• “C” is as calculated (from A-B=C) using the Insurable income calculator after entering “A” and “B”. \n\nComplete A-B=C for all the entities that make up the business structure. Do this by clicking on the GREEN tabs at the bottom of the worksheet for each additional business entity (as required).\n"]
[3,"ADD-BACKS","Add-backs only apply to calculating insurable income (A-B=C plus Add-backs) for SELF-EMPLOYED (or business owners), NOT EMPLOYEES ONLY. Only expenses showing in the Profit & Loss can be Add-backs and should only be added back to the extent they relate to the life assured or his/her ownership share of the business entity. \n\nAdd-backs fall into 3 categories and include:\n1. Personal\n• Directors Fees of the life insured\n• Donations (based on % o'ship share)\n• Income Splitting in the form of Directors Fees, Salary/Wages and Superannuation (or KiwiSaver)\n• Motor Vehicle Expenses (based on % o'ship share)\n• Salary/Wages of the life insured\n• Superannuation (or KiwiSaver) of the life insured\n2. One-offs\n• Loss on Sale of an Asset (based on % o'ship share)\n• Other one-off expenses (based on % o'ship share)\n3. Non Cash\n• Depreciation (based on % o'ship share) which also includes amortisation\n\nBefore finalizing any Add-back amount, always consider “is it reasonable and does it make sense” considering the nature of the business and how the business produces its income.\n\nREMEMBER, if the item is not an expense in the business entity Profit & Loss, it is NOT an Add-back.  Only add-back items to the extent they relate to the life insured and his/her ownership share of the business entity. Refer to Help guide as required for help with each specific add-back."]
[4,"AMORTISATION","Amortisation is an Add-back to the same extent as Depreciation is an Add-back and should be calculated as if it is Depreciation (and part of the Depreciation add-back), ie include it with deprecation at either row 47 in the MAIN ENTITY worksheet (for the main entity) or row 40 in the supplementary entity worksheets (for any supplementary entities). See Depreciation."]
[null,"BUSINESS ADD BACKS","Business Add Backs are those add backs where the amount is based on the life insured's % o'ship share. See Help search menu for each specific add back as required."]
[6,"DEPRECIATION","Depreciation is an Add-back, and you may include the following expenses items in the PL as part of depreciation:\n• Amortisation\n• Depreciation\n• Immediate deduction – business assets less than $1,000 (it may be described in the PL expenses as low value asset, write off asset or immediate deduction). \n\nThe maximum depreciation that can be added back is the lesser of: \n• Actual total depreciation (across all entities that make up the business structure); and \n• 10% of the total adjusted net profit after all other add-backs (across all entities that make up the business structure).\n\nIn short, a simple 10% rule applies and the total Depreciation (across all entities) that can be added back is limited to 10% of Total Adjusted Net Profit (before Depreciation add-back) across all entities. This is calculated automatically in the Insurable income calculator by entering the depreciation amount in the section \"Plus Depreciation Add-back (including amortisation)\". See row 47 in the main entity worksheet and row 40 in the supplementary entity worksheets..\n\nPlease note the following in relation to immediate deduction and instant asset write-offs. Prior to 17/03/20 the low value asset write-off threshold was $500, then this increased temporarily during Covid-19 to $5,000 up until 16/03/21. From 17/03/21 the threshold increased permanently to $1,000.  \n"]
[7,"DIRECTORS FEES","Where the life insured is a business owner and he/she is paid a Directors Fee (or Salary) by the entity he/she has an ownership interest in (directly or otherwise) this is an Add-back. Please note, it must be an expense in the profit and loss to be considered as an add-back.\n\nWhere the life insured is employed to sit as a Director on a company board and is effectively an employee ONLY , not a business owner in relation to the entity they sit on the board of, directors fees should be treated as part of their insurable income and included under the section \"Salary/Wages etc from 3rd parties\" (rows 54-58).  These individuals are often employed (or contracted) by various companies or organisations to sit on their boards and generally sit on mutliple boards."]
[8,"DISTRIBUTIONS (3Ds)","Ignore the 3Ds (Drawings, Dividends & Distributions) and go back to the source and do A – B = C\nDistributions are generally shown in the Balance Sheet, NOT the Profit & Loss.  This is indicative that Distributions have nothing to do with the calculation of insurable income. As the name implies, it is only a method of distributing or transferring earnings from one entity to another, usually for tax purposes or estate planning purposes (with distributions generally made by partnerships and trusts only). Distributions therefore, do not necessarily reflect actual insurable income and should not be considered part of insurable income. Always go back to the source.\n\n"]
[9,"DIVIDENDS (3Ds)","Ignore the 3Ds (Drawings, Dividends & Distributions) and go back to the source and do A – B = C\nDividends are generally shown in the Balance Sheet, NOT the Profit & Loss.  This is indicative that Dividends have nothing to do with the calculation of insurable income. Like Distributions, Dividends are a way of transferring earnings from one company to another entity (generally an owner or shareholder), usually paid out of retained earnings which could be from multiple historical periods and therefore do not necessarily reflect actual insurable income. Always go back to the source. \n\n"]
[10,"DONATIONS","Donations are an Add-back. Hence, the life insured’s share of Donations as shown in the businesses Profit & Loss statement (for each business entity) should be added-back for the calculation of insurable income.  \nThe inherent nature of a Donation is that:\n• It is based on a personal choice or decision rather than being a business decision; and \n• There is no expectation of anything in return (in contrast to gifts, sponsorship and advertising).\nA Donation would have otherwise occurred on a personal basis, based on personal motivations and/or sympathies (ie. based on personal choice/decision rather than for business reasons or a business decision) therefore it is an Add-back. In contrast, with sponsorship and advertising these are generally based a business decison and there is an expectation of something in return. \n"]
[null,"DRAWINGS (3Ds)","Ignore the 3Ds (Drawings, Dividends & Distributions) and go back to the source and do A – B = C\nDrawings generally come from the Balance Sheet, NOT the Profit & Loss and therefore have nothing to do with the calculation of insurable income.\n\nPlease note, when a business owner says they “Draw a salary of $X from the business”; it is important to understand exactly what they mean and the type of business entity involved. Why?\n● If the business entity (structure) is a Sole Trader it must be Drawings rather than Salary/Wages as a Sole Trader and the life insured are one and the same (the same entity). There needs to be 2 entities for an employer/employee relationship to exist and salaries to be paid from one entity to another. Hence, go back to the source (the Sole Trader Profit & Loss) and do A – B = C\n● If the life insured is actually employed by a separate entity in which they have an ownership interest or control (directly or indirectly) it is most likely Salary/Wages. Hence, go back to the source (the entity Profit & Loss) and do A – B = C plus add-backs...adding back the Salary/Wages for the life insured.\n\n"]
[11,"EMPLOYEES ONLY - NO OWNERSHIP INTEREST","Where the life insured has NO ownership interest (directly or otherwise) in an Employer and is an EMPLOYEE ONLY complete the section \"Plus Salary/Wages/Benefits etc from 3rd Party Employers\" of the Main Entity worksheet (rows 54 to 58) eg, using information from IRD Income Summary Statements etc this section could be completed for each year as follows:\no Employer 1 Salary $80,000\no Employer 2 Salary $60,000\no Benefits & allowances (taxed through PAYE) $29,990\no Superannuation (all third party sources) $4,200 \n\nPlease note, this same approach would also apply where the life insured is merely an employee with an investment rather than a business owner, ie the life insured has a minimal minority ownership interest that represents NO influence in voting and/or business decision making. If unsure about this speak to your Underwriter.\n\n"]
[null,"EXPENSES","Expenses is generally the Total Expenses figure in the profit & loss. ie “B” is generally total expenses, as shown in the Profit & Loss. Please note, sometimes accountants will separate out some expenses into sections, so be careful to read the profit & loss carefully and make sure B for total expenses is the correct figuire."]
[null,"FRINGE BENEFITS AND ALLOWANCES","Fringe benefits and/or allowances provided by employers on top of an employee’s usual pay are taxed through PAYE. These are generally included as part of insurable income. However, there are some benefits and allowances that are tax free (not taxed through PAYE) and should not be included as part of insurable income. These tax free benefits and allowances are generally provided by the employer because they relate directly to the employees work and/or the carrying out of their work role and duties.    \nThe general rule on including fringe benefits and/or allowances as part of insurable income is that they are: \n• Regular and usual payments\n• Inclusive in the overall salary/remuneration package\n• Taxed through PAYE and are subject to ceasing if the life insured is unable to work\n\nAs a guide only and subject to underwriting, fringe benefits may include:\no Use of a company vehicle for private use\no Medical benefits \no Fixed mobile phone costs\no Insurance premiums\no Employer contributions to a registered superannuation scheme\n\nIf unsure speak with your Underwriter."]
[13,"INCOME","Income (or 'A' in A - B = C) for a self-employed person (or a business owner) is generally the Total Revenue or Gross Profit figure in the profit & loss excluding any items that do not relate directly to personal exertion or active income. ie “A” includes only those items shown in the Revenue (and Gross Profit) sections of the profit & loss that relate to active income. Hence, “A” does NOT include:\no Dividends\no Distributions\no Drawings\no Rent from third parties\no Royalties\no Interest and investment or passive income\no Gain on the Sale of an Asset\no Any other item NOT related to active income (ie. not from personal exertion)\no Other income – where it is not from identifiable active income (or personal exertion)\n\nNB: From an underwriting perspective one of the basic principals of insurable income is that insurable income should reflect what is an individuals usual and regular income, ie that usual regular income that would most likely stop if they were unable to work due to disability as a result of sickness or injury.  \n"]
[14,"INCOME SPLITTING - SALARY etc","Income Splitting in the form of Salary/Wages, Directors Fees and/or Superannuation showing in the Profit & Loss as expenses are Add-backs. When an expense amount is identified as possible income splitting ask and consider the following 4 questions to determine whether Income Splitting is actually occurring: \n1. What are the spouse/partner's roles and duties in the business? \n2. What are the spouse/partner’s total hours worked per week in the business? \n3. If the spouse/partner was unable to work, would they need to be replaced?\n4. What would a replacement cost the business (based on market rates considering role and duties and hours worked)? \n\nConsider the following three examples:\nExample A - If the spouse/partner’s role is doing the books for 8-10 hrs per week and he/she would not need to be replaced this is income splitting. All the spouse/partner’s salary/wages (and superannuation) should be added-back. \nExample B - Same as A however, the spouse/partner does the books for 20 hrs per week, earns $35,000 and would need to be replaced with a replacement costing the business at least $35,000. This is not Income Splitting and is NOT an Add-back. \nExample C - Same as B however the spouse/partner was being paid $70,000 and a replacement would only cost $35,000. In this example there is an income split component of $35,000 ($70,000 - $30,000).\n\nBefore finalizing the Add-back amount, always ask “is this reasonable and does it make sense” considering the nature of the business and how the business produces its income.\n"]
[null,"INCOME SPLITTING - SUPER (or KiwiSaver)","Income Splitting in the form of Superannuation (or KiwiSaver) documented in the Profit & Loss as an expense is an Add-back. When an amount of superannuation is identified as possible income splitting (the same approach as with salary/wages applies) ask and consider the following 4 questions to determine whether Income Splitting is actually occurring: \n1. What are the spouse/partner's roles and duties in the business? \n2. What are the spouse/partner’s total hours worked per week in the business?\n3. If the spouse/partner is unable to work, would there be a need for her/his replacement?\n4. What would a replacement cost the business (at market rates)? \n\nSee also Income Splitting - Salary etc and before finalizing the Add-back always ask “is this reasonable and does it makes sense” considering the nature of the business and how the business produces its income.\n"]
[null,"NET UNEARNED/INVESTMENT INCOME","Investment income and unearned income should NOT be included (in A) when calculating A-B=C for insurable income.\nHowever, where net unearned/investment income is greater than 25% of insurable income an adjustment will be made to determine the benefit level the life insured may be able to support. For an indicative guide only, the adjustment calculation can be made in the IP Calc by entering what is net unearned/investment income at row 64 (in the main entity worksheet). Please note, this is the NET unearned/investment income, not the gross. \n\nFor example:  \nIndemnity cover where insurable income is $100,000 and net unearned/investment income is $30,000 ie net unearned/investment income is greater than 25% of insurable income and so is considered significant enough that an adjustment should be made.  \nAdjustment calculation \n1. $100,000 insurable income + $30,000 net unearned/investment income = $130,000\n2. $130,000 x 75% (indemnity replacement ratios) = $97,500\n3. $97,500 - $30,000 net unearned/investment income come = $67,500\n4. $67,500/12 = $5,625pm (monthly benefit) \n\nPlease note, unearned/investment income includes that unearned/investment income produced by assets and investments the life insured has either an ownership interest in or control over (directly or otherwise) including those held in the spouse/partner's name, in trusts or other entities owned by trusts or any other entity that you have control over. \n\nPlease note, this calculator provides an indicative guide of insurable income only, any adjustment calculation is an indicative guide only and each case will be subject to individual consideration.\n"]
[15,"LIFE INSURED'S BUSINESS ADD BACKS","These are the add-backs that relate specifically to the life insured only, regardless of ownership interest - not other owners in the business."]
[16,"LOSS ON THE SALE OF AN ASSET","The Loss on the Sale of an Asset is a One-off expense and should be an Add-Back. The only exception is where it is in the ordinary course of the business to buy and sell assets and as such it would NOT be considered a One-off.\n\nPlease also note that conversely the Gain on the Sale of an Asset should NOT be included in calculating “A” as part of A-B=C."]
[null,"MAIN TRADING ENTITY","Main trading entity is the main trading entity of the business, ie the business entity that produces the majority of the business revenue. If there are additional entities in the business structure use the 2nd Entity etc worksheets as required (by clicking on the GREEN tabs at the bottom of the worksheet) to determine A-B=C plus add-backs for each and every entity that make up the overall business structure. "]
[17,"MGT/SERVICE/ADMIN FEES","Where a Management, Service and/or Administration Fee is shown as an expense in a Profit & Loss ask the following question:\n- Is this Management Fee going to another entity which the business owner has an ownership interest in, or control of, directly or otherwise?\nIf the answer is NO, the Management Fee should be treated like an ordinary expense.\nIf the answer is YES:\n1. Establish whether the life insured has an ownership interest in the business (directly or otherwise)\n2. Request the Profit & Loss, Balance Sheet and Tax Return for the Management entity for the last  3 years\n3. Complete A-B=C plus Add-backs for the Management entity, applying risk profiling and the key financial underwriting principals outlined in these help notes. \n\nManagement/Service/Admin Fees are NOT Add-backs.\n\nNote: If Rent is being paid to a related party (ie an entity the life insured has an ownership interest in directly or indirectly) then it should be treated the same as Management/Admin/Service fees that are paid to a related party (as outlined above)."]
[18,"MOST RECENT YEAR","Most recent year should generally be the most recently completed full financial year (this could include most recent full year draft financials)."]
[19,"MOTOR VEHICLE EXPENSES","Motor vehicle expenses should only be added back to the extent that the expense showing in the Profit & Loss relates to personal use and is NOT reflective of the real business expense incurred by the business in relation to the motor vehicle considering:\n• the nature of the life insured's occupation/business;\n• how the business produces income\n• roles and duties of the individual life insured\n• where the life insured's time is spent (as per the application)\n• type of motor vehicle\n• whether any apportionment for private use has already been made.\nAnother indicator may be if FBT is showing as a tax-deductible expense in the Profit & Loss or if Employee contribution is showing as a revenue item, which could be indicative of a motor vehicle/s being used for personal or private use. \n\nThe amount added-back should be limited to either 0%, 25%, 50%, 75%, or 100% and must be reasonable and make sense considering all the above factors.\nEg if motor vehicle expenses in the profit & loss total $15,000 and the life insured is a Doctor who has a surgery in the city and only makes occasional house calls it would be reasonable to add back 75%. However, if the applicant was a tradesperson, such as a plumber, the vehicle carries their tools of trade, then the maximum add back would be 25% of motor vehicle expenses and more likely 0% in most cases.\n\nWhere private use has already been taken into account and the motor vehicle expense amount showing in the Profit & Loss seems like a reasonable business expense which makes sense considering the above mentioned factors an add-back is not applicable. ation\n\nWhen considering motor vehicle add-backs always consider “is it reasonable and does it make sense” considering the nature of the business and how the business produces its income.\n"]
[21,"NET INCOME TO APPLY FOR BENEFIT","As an indicative guide the Insurable income calculator automatically calculates the Net Income (or insurable income) at row 63 to apply for the benefit based on the following rules:\n1. If the Total Net Income for the most recent year is less than $1, the average income is $0, regardless of previous years.\n2. If the Total Net Income is trending up more than 20% the average applies...and where Total Net Income is trending up less than 20% the most recent years Total Net Income applies.\n3. If the Total Net Income is trending down the most recent years Total Net Income applies.\n4.  Where 3 years are available and the above rules say average, if the 3rd year (oldest year) is more than 20% different to the most recent year only the last 2 years will be used to take the average.\n\nPlease remember, the Insurable income calculator provides an indicative financial guide only.\n"]
[22,"ONE-OFFS","A One-Off is any item that occurs in the business Profit & Loss that upon risk profiling is NOT considered to be part of the usual, typical and expected income of the business (ie from usual active income or personal exertion).\nOne-off revenue items should NOT be included in calculating “A” as part of A-B=C.\nOne-off expenses should be an Add-back (only if they truly are a One-off).\n\n"]
[23,"OWNERSHIP INTEREST","Enter the life insured's % ownership (or beneficial ownership) interest in the business entity. Eg if the life insured is a Sole Trader this will be 100%, or if this is a Family Trust and all of the beneficiaries are the life insured and/or members of his/her family (who do not have an active role in the business) this will be 100%. If unsure please contact your Underwriter."]
[24,"PERSONAL EXERTION INCOME","The life insured's personal exertion (or active) income is what is referred to as insurable income. Whilst determining what is insurable income for an EMPLOYEE ONLY is generally straight forward, this is not so for SELF-EMPLOYED (business owners). Businesses are dynamic by their very nature, constantly changing, so determining what is the life assured’s insurable income from personal exertion in a business can be difficult to truly ascertain.  Therefore, to determine insurable income review the financials and:\n1. Establish the business structure and determine the % ownership interest in each of the business entities\n2. Ignore the 3Ds and go back to the source (Step 1.)\n3. Identify any Management/Admin/Service fees in the expenses and where they are going? If going to a related entity go back to the source (Step 1.)\n4. Calculate A-B=C \n5. Calculate add-backs \n6. Include any 3rd party salary/wages etc\n7. Consider does everything make sense and sound reasonable.\n\nCalculating A-B=C plus add-backs is where the Insurable income calculator becomes such a valuable tool. \n\nPlease note, Insurable Income is NOT the same as Taxable or Accounting Income.\n"]
[null,"PLUS OTHER SUPPLEMENTARY ENTITY...","This section (rows 40-43) summarises income attributable to the life insured from the other entities s/he has an ownership interest in directly or otherwise (that make up the overall business structure). Refer to the INSTRUCTIONS and use the GREEN Entity tabs at the bottom of the worksheet to work out income where there are multiple entities (up to five entities) in the overall business structure. If there are more than five entities in the business structure, contact your Underwriter for assistance."]
[null,"PLUS SALARY/WAGES ETC FROM...","This section (rows 54-58) shows salary, wages and other remuneration sourced from third parties, usually third party employers (in which the life insured has NO ownership interest indirectly or otherwise). This is also the section which would be completed if the life insured is an EMPLOYEE ONLY."]
[25,"PRIVATE OR PERSONAL EXPENSES","Any personal or private expenses showing in the business PL should be added back. These are best added back at line item \"+O\" (row 36). Please note, only items actually showing as expenses in the business PL can be added back. "]
[null,"RENT PAID TO RELATED PARTY","Where the business premises are owned by a related party the life insured has an ownership interest in or control of (directly or otherwise) AND the associated rent is showing as an expense in the business Profit & Loss follow these steps:\n1. Determine what the business owner’s ownership interest is (directly or otherwise) in the entity that owns the business premises\n2. Request the Profit & Loss, Balance Sheet and Tax Return for this related entity for the last 3 years\n3. Complete A - B = C plus Add-backs for the related entity applying risk profiling and the key financial underwriting principals.\nRent showing as an expense in the Profit & Loss is generally NOT an Add-back, and where the Rent expense is going to a third party it should be treated like an ordinary expense and is NOT an Add-back. "]
[null,"REPLACEMENT RATIOS","Replacement ratios are used at application/underwriting stage to determine the level of benefit the life insured may support based on their insurable income. The replacement ratios used depend upon the type of benefit.   \n\nAgreed Value - the maximum sum insured is based on percentage of insurable income, worked out as follows: \n• 62.5% of the first $70,000\n• 60% of the next $30,000\n• 55% of the next $220,000\n• 33% of the next $240,000, and\n• 20% of the balance\n\nIndemnity - the maximum sum insured is based on percentage of insurable income, worked out as follows:\n• 75% of the first $250,000\n• 50% of the next $150,000, and\n• 25% of the balance \n\nMortgage Repayment cover - when the maximum sum insured is based on percentage of insurable income, it is worked out as follows:\n• 45% of insurable income\n\nPlease refer to the Insurable income calculator MAIN ENTITY worksheet for an indicative guide as to how to calculate insurable income and the replacement ratios that apply. Also, please refer to the actual Income Protection Cover and Mortgage Repayment Cover policy documents for further information on what is payable under Agreed Value, Indemnity and Mortgage Repayment Cover. This Insurable income calculator is intended to provide an indicative guide only."]
[null,"SALARY/WAGES/DIRECTORS FEES","Where the life insured is SELF-EMPLOYED (business owner) and he/she is paid a Salary or Directors Fee by the entity he/she has an ownership interest in (directly or otherwise) this is an Add-back. However, if the life insured is an EMPLOYEE ONLY it is NOT an Add-back and is just part of insurable income.\n\nWhere the life insured is an EMPLOYEE ONLY the Salary amount showing in their IRD Income Summary Statement etc should be included in the \"Plus Salary/Wages etc from 3rd Party Employers\" section on the Main Entity worksheet (rows 54-58).  For example, using information from the IRD Income Summary Statement, this section should be completed for each year as follows:\no Employer 1 Salary $70,000\no Employer 2 Salary $30,000\no Reportable Fringe Benefits $29,990\no Superannuation (all third party sources) $3,000\n\n"]
[null,"SELF-EMPLOYED or BUSINESS OWNER","Generally when someone has ownership and/or control (directly or otherwise) of a business (and the entities that make up the business) they will be considered SELF-EMPLOYED (or a business owner). It is very important to establish this at initial risk profiling, because if they are merely an employee in the business who also happens to have a minority shareholding that is more akin to an investment in the business and they should be treated as an EMPLOYEE ONLY, NOT SELF-EMPLOYED (or a business owner). If you are unsure please speak to your Underwriter. \n\nPlease note contractors should generally be treated like self-employed for the purpose of financial underwriting as they will generally have a Profit & Loss with expenses that they deduct/claim against their income.\n\nIf unsure speak with your Underwriter.\n"]
[26,"SUPERANNUATION (OR KIWISAVER)","Where the life insured is a Business Owner and the business entity he/she has an ownership interest in (directly or otherwise) pays a Superannuation (or KiwiSaver) contribution amount in their name, this is an Add-back.  Please note where the life insured is an Employee ONLY the super (KiwiSaver) amount should be included in the section \"Plus Salary/Wages etc from 3rd Party Employers\" of the Main Entity worksheet (rows 54-58).  For example, using information from the Personal Income Tax Return or IRD Income Summary Statement this section could be completed for each year as follows:\no Employer 1 Salary $70,000\no Employer 2 Salary $30,000\no Fringe Benefits $29,990\no Superannuation (all third party sources) $3,000\n\n"]
[27,"TERMS OF USE DISCLAIMER (Part 1)","This calculator is provided by Fidelity Life Assurance Company Limited (referred to below as “Fidelity life”, “we”, “us” or “our”) for use by financial advisers authorised by Fidelity Life, in relation to an application for Fidelity life Income protection cover and monthly mortgage repayment cover only and is subject to copyright.\n\nThe following are terms of use of this calculator:\n1. You must enter all information into the relevant areas of the calculator to reflect the scenario you are trying to model.\n2. The purpose of this calculator is to provide an indicative guide of a maximum available benefit based on the inputs provided only. It’s not intended to be a comprehensive final assessment of an Applicant's allowable Monthly Disability Income Insurance Benefit. A final determination of the allowable Income Protection Cover or Monthly Mortgage Repayment cover is subject to the satisfactory completion of an application for each insured person, and providing Fidelity life with all requested information through the application and underwriting process. Conditions, limits and exclusions may apply to any cover issued. Please see the Policy Document for cover terms.\n3. The calculator is provided as a guide only. It isn’t financial advice and does not reflect the needs of a customer.  It only provides the maximum benefit that a customer may be entitled to based on the information input into the calculator. You should consider the appropriateness and accuracy of the input information before making any recommendations. \n4. You must not (i) copy, disassemble, reverse engineer, reproduce, adapt or otherwise attempt to derive, tamper or modify the code of the calculator, (ii) sell, license or in any way distribute or transmit the calculator to your customers and/or other third parties, and (iii) copy or use in any way Fidelity life's name and all associated trademarks which may appear on the calculator; you acknowledge that to do so would constitute an infringement of intellectual property rights in the calculator and Fidelity life’s trademarks, and may cause errors in the calculator and any calculations generated. \nContinued...(in Part 2)"]
[28,"TERMS OF USE DISCLAIMER (cont… Part 2)","Terms of use (cont...Part 2)\n5. While we have used all reasonable care in preparing this calculator, as the available monthly benefit calculation relies on the information input into the calculator, we do not accept responsibility for any calculation that results from incorrect information that is entered into the calculator.  Where you provide information to an employee of Fidelity life to input into the calculator Fidelity life takes no responsibility for the accuracy of the information provided.\n6. To the extent the law allows us to, we will not be responsible for any loss (including, without limitation, loss of data, interruption to business, loss of profits and loss of investments) arising directly or indirectly from use of the calculator.\n7. This calculator is generic in nature and has not been designed for any particular person.  It has been prepared in good faith and without assuming a duty of care. You are responsible to input correct information, no guarantee, warranty, or representation is given or implied you are responsible for the reliability or accuracy of the information used to compile each calculation.\n8. The calculator does not take into account any tax treatment of cover.  Independent professional taxation advice should be sought if this is required. \n9. Before using the calculator you should read the Notes and Instructions detailing how to use the calculator and what inputs are required.  "]
[29]
[30]
["RKP Cover Calculator Help"]
["Number","Help Topic","Help Topic Content"]
[1,"INSTRUCTIONS","The Rural key person cover (or RKP) calculator is designed to assist in providing an indicative guide as to the maximum RKP benefit an individual FARM OWNER or SHAREMILKER may support based on financial information from farm Profit & Loss Statements or the Sharemilking (or Contract milker) agreement (contract) etc. Please follow the instructions below:\n1. Enter your reference and the client's details at the top of the RKP worksheet in the WHITE fields as required.\n2. Complete either the FARM OWNER or SHAREMILKER section depending on whether your client is a farm owner or share-milker (the latter section also applies contract milkers)\n2a. Where the client is FARM OWNER enter the Gross farm income (row 12) and their name as Person 1 (row 15). Enter the names of any other owners as Person 2, 3 & 4 accordingly as required (rows 16-18). Select Hours per week or % O'ship as the method of calculation to determine the split of Gross farm income (column K) and the indicative monthly benefit (column M); or\n2b. Where the client is a SHAREMILKER or CONTRACT MILKER refer to their milking agreement, and complete the SHAREMILKER section accordingly depending upon whether their agreement is based on a Production target for milksolids (row 25) or the Number of cows in the herd (row 27), to determine the indicative monthly benefit (column M). \n3. Refer to the HELP search menu as required to complete each field. \n4. If you are unsure about how to complete the Rural key person cover calculator, please contact your Underwriter. \n\nIf cover is for a key worker, who is not a FARM OWNER or SHAREMILKER please contact your underwriter.  A SHAREMILKER includes contract milkers. \n\nPlease note, this calculator provides an indicative guide of the RKP monthly benefit only."]
[null,"AGREEMENT","This is an agreement (contract) between the farm owner and the SHAREMILKER or CONTRACT MILKER to operate the farm and/or carry on the milking of the cows on the farm. The agreement should set out the nature of the arrangement, including the basis of the profit share which is generally based on, either an estimated annual target production of milksolids or the number of cows in the herd and either a % rate or rate of $ per kgMS.\n\nPlease note, for SHAREMILKERS or CONTRACT MILKERS seeking Rural key person cover underwriting will require a copy of the sharemilking or contract milking agreement, and it should include sections showing: \n•\tDescription of the parties\n•\tMilksolids produced in previous three seasons\n•\tRemuneration, including the target production\n•\tHerd at start of term\n•\tMaximum and minimum herd numbers"]
[null,"CONTRACT MILKER","A CONTRACT MILKER is generally a self-employed farmer managing a dairy farm for a farm owner, and is paid on the a negotiated set price per kgMS produced. The agreed price per kgMS is set out in the contract milking agreement.  "]
[null,"FARM OWNER","A FARM OWNER is the owner of the farm and there may be more than one. For example, if a husband and wife own the farm there are 2 owners, so both their names should be listed along with hours worked for each. Please note, where there is more than one FARM OWNER working on the farm the hours per week should be entered for each owner (even if the other person/s is not applying for Rural key person cover).\n\nFor a FARM OWNER Rural key person cover is based on their split of 35% of the gross farm income, with financial proof of gross farm income required and details of average working hours per week should be noted in the application for all owners (even if the other owners are not applying for Rural key person cover).  "]
[null,"GROSS FARM INCOME","Gross farm income is the actual gross income (revenue) generated by farming activities on the farm. It does not include, contracting income, interest, rental and/or any investment income. "]
[null,"HOURS PER WEEK","Hours per week is the number of hours each of the FARM OWNERs is active operating the farm (on average each week). This should be completed for all owners even if they are not applying for Rural key person cover."]
[null,"kgMS","KgMS is kilogram of milksolids."]
[null,"MILK PRICE","The assumed milk price used in the calculator is $7.40 per kg of milk solids (from 1 June 2023). This is based on the average of the last 5 years. "]
[null,"NUMBER OF COWS","This is the number of cows the SHAREMILKER or CONTRACT MILKER is under agreement to milk, as set out in the sharemilking or contract milking agreement."]
[null,"PRODUCTION VALUE","The assumed milk production value (milksolids or kgMS per cow) used in the calculator is 383 kg per cow (from 1 June 2023)"]
[null,"RESET","The reset buttons at the top of the worksheet reset all the values in the worksheet back to nil. If required, be sure to save a copy of your work before resetting the worksheet. "]
[null,"RKP MONTHLY BENEFIT","The RKP monthly benefit calculated in column M is the maximum indicative RKP monthly benefit only. It is based on the information entered into the calculator in either the FARM OWNER or SHAREMILKER section. "]
[null,"RURAL KEY PERSON COVER","Rural key person cover provides an agreed value monthly income protection style benefit in the event a FARM OWNER or key employee is unable to work due to sickness or injury. The basis of the benefit calculation is either up to 35% of gross farm turnover for FARM OWNERs, or where cover is for a SHAREMILKER or CONTRACT MILKER it is up to 35% of production based on milk solids or number of cows, as per their sharemilking or contract milking agreement.\n\nFor sharemilkers and contract milkers underwriting will require a copy of the sharemilking or contact milking agreement to determine the basis of the benefit calculation. \n\nThe maximum level of cover is $10,000 monthly benefit. "]
[null,"SHAREMILKER","A SHAREMILKER either milks a dairy farmer's cows for a profit share, or owns a herd of cows and milks them on a farm owner's land for profit share. The profit share arrangement is set out in the sharemilking agreement.\n\nPlease refer to the sharemilking or contract milking agreement when completing the calculator for sharemilkers and contract milkers. "]
[null,"SM","SM means SHAREMILKER and would also include CONTRACT MILKERS (for the purpose of this calculator). "]
[null,"SPLIT OF GFI","This is the split of Gross farm income, either based on split of hours per week or % ownership between the FARM OWNERs. Select either Hours per week or % O'ship (row 14)."]
[null,"TARGET PRODUCTION","Target production is the estimated annual target production of kgMS as referred to in the sharemilking or contract milking agreement. This is used in the calculator (row 25) providing it is reasonable when considering the herd size and milksolids produced in previous years (which is generally also outlined in the sharemilking or contract milking agreement). "]
[null,"$ PER kgMS","$ per kgMS is the agreed rate of $ per kgMS that the SHAREMILKER or CONTRACT MILKER gets under their agreement with the farm owner (if the agreement is based on $ per kgMS and is entered in column K).  Alternatively, the agreement may be based on % to SM (entered in column I)."]
[null,"% O'SHIP","% O'ship is the percentage ownership split of the farm between the FARM OWNERs. This should be selected (row 14) when Hours per week are not used for splitting Gross farm income."]
[null,"% TO SM","Percentage to SM is effectively the revenue share percentage attributable to the SHAREMILKER or CONTRACT MILKER according to the terms of the agreement (entered in column I). Alternatively, the agreement may be based on $ per kgMS (entered in column K)."]
[null,"TERMS OF USE DISCLAIMER (Part 1)","This calculator is provided by Fidelity Life Assurance Company Limited (referred to below as “Fidelity life”, “we”, “us” or “our”) for use by financial advisers authorised by Fidelity Life, in relation to an application for Fidelity life Rural Key Person Cover only and is subject to copyright.\n\nThe following are terms of use of this calculator:\n1. You must enter all information into the relevant areas of the calculator to reflect the scenario you are trying to model.\n2. The purpose of this calculator is to provide an indicative guide of a maximum available benefit based on the inputs provided only. It’s not intended to be a comprehensive final assessment of an Applicant's allowable Monthly Disability Insurance Benefit. A final determination of the allowable Rural Key Person Cover is subject to the satisfactory completion of an application for each insured person, and providing Fidelity life with all requested information through the application and underwriting process. Conditions, limits and exclusions may apply to any cover issued. Please see the Policy Document for cover terms.\n3. The calculator is provided as a guide only. It isn’t financial advice and does not reflect the needs of a customer.  It only provides the maximum benefit that a customer may be entitled to based on the information input into the calculator. You should consider the appropriateness and accuracy of the input information before making any recommendations. \nContinued...(in Part 2)"]
[null,"TERMS OF USE DISCLAIMER (cont… Part 2)","Terms of use (cont...Part 2)\n4. You must not (i) copy, disassemble, reverse engineer, reproduce, adapt or otherwise attempt to derive, tamper or modify the code of the calculator, (ii) sell, license or in any way distribute or transmit the calculator to your customers and/or other third parties, and (iii) copy or use in any way Fidelity life's name and all associated trademarks which may appear on the calculator; you acknowledge that to do so would constitute an infringement of intellectual property rights in the calculator and Fidelity life’s trademarks, and may cause errors in the calculator and any calculations generated. \n5. While we have used all reasonable care in preparing this calculator, as the available monthly benefit calculation relies on the information input into the calculator, we do not accept responsibility for any calculation that results from incorrect information that is entered into the calculator.  Where you provide information to an employee of Fidelity life to input into the calculator Fidelity life takes no responsibility for the accuracy of the information provided.\n6. To the extent the law allows us to, we will not be responsible for any loss (including, without limitation, loss of data, interruption to business, loss of profits and loss of investments) arising directly or indirectly from use of the calculator.\n7. This calculator is generic in nature and has not been designed for any particular person.  It has been prepared in good faith and without assuming a duty of care. You are responsible to input correct information, no guarantee, warranty, or representation is given or implied you are responsible for the reliability or accuracy of the information used to compile each calculation.\nContinued...(in Part 3)"]
[null,"TERMS OF USE DISCLAIMER (cont… Part 3)","Terms of use (cont...Part 3)\n8. The calculator does not take into account any tax treatment of cover.  Independent professional taxation advice should be sought if this is required. \n9. Before using the calculator you should read the Notes and Instructions detailing how to use the calculator and what inputs are required.  "]
[]
[]
[]
["BOH Calculator Help"]
["Number","Help Topic","Help Topic Content"]
[1,"INSTRUCTIONS","The Business Expenses (BE) Calculator is designed to assist in determining the amount of eligible business expenses for Business expenses cover based on financial information from Tax Returns, Profit & Loss Statements etc for all the entities that make up the business structure. Please note, the BE Calculator only provides an indicative guide to the maximum level of business overheads cover that may be supported.\n\nTo use the BE calculator follow these steps:\n1. Complete all WHITE fields as required, starting with life insured’s Name, Name of Entity, Year, then enter the actual yearly figures as per the information from the Tax Returns and/or Profit & Loss Statement etc. Refer to the Help drop down menu as required for guidance on completing each field. Where several items come under just one Eligible business overheads description eg. Professional Registrations $800 and Professional Membership $400. These should be included under Registrations by entering =800+400 in the appropriate field.\n2. Where there is more than one entity complete additional entity columns shown (for up to 3 entities). \n3. Enter the life insured’s ownership interest for each entity for each year at the bottom of each column (row 49). The information you complete for all entities will then be summarised and automatically updated in the Summary of Eligible Business expenses at the bottom of the page. \n\nPlease refer to the actual Business expenses cover policy documents for further information on what are eligible business overheads and what is payable under a Business Expenses contracts. This BE Calculator is intended to provide an indicative guide only."]
[null,"ACC ","ACC is only an eligible business overhead to the extent it relates to the regular ACC premiums paid in relation to non-income producing employees. It does NOT relate to any one-off or other type of ACC expense or payments made in relation to income producing employees."]
[2,"ACCOUNTING FEES","Accounting Fees include fees for the completion of business accounts and tax returns (including monthly, bi-monthly or quarterly GST returns)."]
[3,"ADVERTISING","Advertising costs of a regular and contractual nature should be included as eligible business expenses eg  Advertising in Yellow pages\nAdvertising costs for special marketing campaigns would not be considered eligible business expenses as these are not considered ongoing fixed expenses.\n"]
[4,"ELIGIBLE BUSINESS OVERHEADS","Generally, business expenses that are of a regular and recurring nature that would not be incurred if there was no revenue being produced in a business would be considered eligible business expenses. These are usually the infra-structure type of fixed expenses associated with running the business that would continue to be incurred even if the business doors were closed. \n\nPlease refer to the actual Business expenses cover policy documents for further information on what are eligible business overheads and what is payable under a Business expenses contracts. This BE Calculator is intended to provide an indicative guide only.\n"]
[5,"AUDIT FEES","Audit Fees include the annual cost of getting accounts audited. Most small businesses are unlikely to have any audit fees as these are usually costs for larger businesses with many shareholders and Trusts and/or Organisations with memberships that are required by law to provide audited accounts. However, if audit fees are an expense in the profit & loss they will generally be considered eligible business expenses."]
[6,"BANK FEES","Bank Fees, which include regular bank fees and charges on business accounts are eligible business expenses. This does not include EFTPOS or Merchant type service fees (which are transaction based), unless these are part of a fixed contract."]
[7,"CLEANING","Cleaning expenses that relate to the completion of fixed on-going contracts to provide cleaning services are eligible business expenses."]
[8,"COMPUTER COSTS","Computer costs that relate to the completion of fixed on-going service or maintenance support are included as eligible business expenses. Expenses relating to one-off software and/or hardware purchases are NOT eligible business expenses."]
[9,"ELECTRICITY","Electricity and other fixed utility costs are included as eligible business expenses."]
[10,"FILING FEES","Filing Fees are generally a small fee of several hundred dollars relating to the filing of annual accounts with the companies office and applies to companies only. Filing fees are eligible business expenses."]
[11,"GAS","Gas is treated the same way as for Electricity and other fixed utility costs, these are included as eligible business expenses."]
[12,"HEATING","This is treated the same way as Gas, Electricity and other fixed utility costs, these are included as eligible business expenses."]
[13,"HIRE OF BUSINESS PLANT ETC","The cost of Plant and Equipment Hire is an eligible business overhead where it is paid to third parties. Where it is paid to a related party, ie an entity where the life insured has an ownership interest (either directly or indirectly), review the Profit & Loss for that entity and calculate the real expense in that additional entity by completing the columns for the additional entity under either 2nd or 3rd entity heading."]
[14,"INSURANCE","Business insurance is an eligible business expense (only if it is a true business insurance and not personal). This does NOT include the cost of Income Protection premiums as these premiums would be waived in the event of a claim."]
[15,"INTEREST","Interest on borrowings that are incurred by the business for the business are considered eligible business expenses."]
[16,"LEASE COSTS","Lease costs associated with leasing business equipment, plant, machinery and motor vehicles are eligible business expenses (provided it is paid to a third party). Where these payments are made to a related party, ie an entity the life assured has an ownership interest in directly or otherwise, review the Profit & Loss for that entity and calculate the real expense in that additional entity by completing the columns for an additional entity under either 2nd or 3rd entity heading. "]
[17,"LEGAL FEES","Fixed and regular legal fees are considered an eligible business expense (must be regular from one year to the next)."]
[18,"LOAN/MORTGAGE REPAYMENTS","Principal/capital loan/mortgage repayments may be included as eligible business expense only to the extent that they are the minimum repayments required under the loan or mortgage and are directly related to one or more identifiable business assets. Otherwise loan/mortgage repayments are NOT considered eligible business overheads and should NOT be included in the calculation of eligible business expenses."]
[19,"LOCUM","Net Cost of a Locum is the expected net cost, ie the fees expected to be produced by the locum less the costs associated with hiring the locum. Please note this is NOT the Gross Cost to hire the locum. What this means for example, is if a Dentist charges out at $300 per hour and the cost of a locum is $200 per hour there is no net cost. A best estimate of the Net cost of a locum needs to be made. It should sound reasonable and make sense considering the nature of the business.\n\nIf the life insured is seeking to cover the cost of a replacement for the owner or an employee in the business who is also a key person in the business ask your Underwriter about other product options that may be available."]
[20,"MAXIMUM BENEFIT AMOUNT","The BE Calculator calculates an indicative maximum benefit on the basis of the lesser of the current year or the average of the 2 years entered (across all business entities). The maximum benefit level available is $30,000 per month, with up to a maximum of 100% of the benefit payable in the first 12 months and up to 50% in the next 12 months."]
[21,"MOTOR VEHICLE","Motor Vehicle expenses are considered eligible business expenses only to the extent that they are fixed and business related, ie. variable running costs such as fuel and motor vehicle repairs & maintenance are NOT eligible business overheads. Also, motor vehicle expenses should not be considered eligible business overheads to the extent that they were added back for Income Protection. Hence, fixed motor vehicle costs such as registration, insurance and leasing costs are eligible business expenses to the extent that they are business related. \n\nEg, if 25% of motor vehicle expenses were added back for Income Protection as personal use, then only 75% of the fixed motor vehicle expenses can be considered as eligible business expenses."]
[22,"MULTIPLE ENTITIES","This calculator caters for up to 3 entities in the overall business structure. If there are more than 3 entities careful consideration should be given as to whether Business expenses cover is appropriate. If unsure contact your Underwriter.\n\nWhere there is more than one trading entity in the business structure, complete the relevant columns for each additional entity. When information has been entered for all entities the summary at the bottom of the worksheet will provide an indicative maximum monthly benefit amount (based on the income from all business entities).\n\n"]
[23,"OWNERSHIP INTEREST","Enter the life insured’s ownership interest (directly or otherwise) in relation to each entity at the bottom of each expense column in the appropriate cell (row 49)."]
[24,"PRINTING, POSTAGE & STATIONARY","Printing, postage and stationary are considered eligible business overheads. If these are itemised separately in the Profit & Loss just click on the cell to enter information then enter in the formula bar the expense numbers like this =200+300+150"]
[25,"PROPERTY RATES & TAXES","Property rates & taxes are generally fixed costs associated with the ownership of premises and/or buildings the business operates out of - these are eligible business expenses. It does not include rates and taxes related to investment properties or personal residential properties."]
[26,"REGISTRATIONS","All professional body memberships, registrations, licenses etc that are required for the life insured to practice and produce an income (to maintain their license or registration to do so) are considered eligible business overheads. The same applies to subscriptions to periodicals etc required for the life insured to keep up to date with latest practices etc. These are all eligible business expenses, however it does not include magazine subscriptions for the waiting room."]
[27,"RENT","Rent includes rent paid to third parties only. \n\nWhere rent is paid to a related entity the Profit & Loss of that related entity needs to be reviewed to determine the life assured’s share of the real expense, ie what are the eligible business expenses in the related property owning entity? This will require completion of either the 2nd or 3rd entity business expenses calculation to determine the real expense and therefore the true level of eligible business expenses across the whole business (all business entities). See Rent paid to related parties."]
[null,"RENT PAID TO RELATED PARTIES","Where the business premises are owned by a related party the life insured has an ownership interest in or control of (directly or otherwise) AND the associated rent is showing as an expense in the business Profit & Loss follow these steps:\n1. Determine what the business owner’s ownership interest is (directly or otherwise) in the entity that owns the business premises \n2. Request the Profit & Loss for this related entity for the last 3 years\n3. Enter the eligible business overheads that relate to the property/business premises under another Entity (either Entity 2 or Entity 3) in the BOH Calculator to determine the eligible business overheads in this entity. Generally, this will be less than the actual rental charge expensed in the associated or main trading entity. \n\nRent paid to a related party should NOT be included as an eligible business expense in the entity it's expensed in, always track the expense to the related party entity and determine the eligible business expenses in the related party entity.   "]
[28,"REPAIRS & MAINTENANCE","These are only considered eligible business expenses to the extent they relate to a fixed on-going service and/or repairs and maintenance contract."]
[29,"SALARY/WAGES","Salary/Wages for non-income producing employees only are eligible business expenses. Therefore, salary/wages for income producing employees and spouse/partners who may be income splitting are NOT eligible business expenses."]
[30,"SECURITY","Security costs are only considered eligible business expenses to the extent they relate to the fixed on-going supply of security services to the business, ie a fixed on-going contract."]
[31,"SUBSCRIPTIONS","All subscriptions to professional bodies and purchase of periodicals etc required for the life assured to keep up to date with latest practices etc are eligible business expenses.  However, this does not include magazine subscriptions for the waiting room."]
[32,"SUPERANNUATION","Superannuation for non-income producing employees only are eligible business expenses. Therefore, superannuation for income producing employees and for income splitting spouse/partners are NOT eligible business expenses."]
[33,"TELEPHONE","Telephone expenses (including mobile phone costs) are considered eligible business expenses."]
[34,"WATER","Water expenses are  treated the same way as for Heating, Gas, Electricity and other fixed utility costs, these are included as eligible business expenses."]
[36,"TERMS OF USE (Part 1)"]
[37,"TERMS OF USE (cont… Part 2)"]
[38,"TERMS OF USE (cont… Part 3)"]
[39]
["MRC IP Split Benefit Calculator Help"]
["Number","Help Topic","Help Topic Content"]
[null,"INSTRUCTIONS","The MRC IP Split Benefit Calculator is designed to provide an indicative guide only of the level of Mortgage Repayment Cover and/or Income Protection Cover that may be available where the life assured has existing Mortgage Repayment Cover and/or Income Protection Cover.  Details can be entered to for both the primary life and spouse/partner.\n\nPlease enter details in ORANGE fields for the primary life (and spouse/partner as applicable) following the instructions below:\n1. Reference details - enter reference details in Row 8, eg Adviser name or customer reference number.  \n2. Primary life details - enter primary life details including life assured's name (Row 9) and occupation class from the drop down list (Row 10).\n3. Insurable income - enter insurable income (Row 12) and monthly mortgage or rent repayment amount (Row 13).   Based on this information the calculator will provide an indicative guide as to what is the maximum monthly mortgage repayment cover benefit available (Row 14) and also the maximum top-up benefits available (before any existing and/or proposed top-up benefits have been entered).\n4. Existing benefits - enter any existing benefits that are to be retained for each of the benefit types (rows 18-20).\n5. Proposed top-up benefits - enter any proposed top-up benefits (in addition to existing covers that are to be retained) for each of the benefit types (rows 30-33). \n4. If you are unsure about how to complete the MRC /Income Cover Split Benefit Calculator please contact your Underwriter.\n\nRe insurable income, if unsure how to calculate insurable income please refer to the Insurable income calculator, ie the GREEN IP CALC MAIN ENTITY worksheet tab. \n\nPlease note, this calculator provides an indicative guide only and should be used for illustrative purposes only."]
[null,"AFTER REPLACEMENT RATIOS","After replacement ratios shows the benefit applicable based on the insurable income that has been used, after applying replacement ratios.\n\nPlease note, this calculator provides an indicative guide only and should be used for illustrative purposes only."]
[null,"AGREED VALUE COVER","Agreed value cover is where full financial underwriting occurs at application/underwriting stage and the benefit payable in the event of a claim is based on the monthly sum insured (less any reductions or offsets that may apply).  \n\nThe maximum amount of cover available is $20,000 pm.\n\nPlease refer to the actual Income Protection Cover policy documents for further information on what is payable under Agreed Value contracts. This calculator is intended to provide an indicative guide only."]
[null,"ANNUAL BENEFIT AMOUNT","This is 12 x the monthly benefit amount."]
[null,"BALANCE OF INCOME AVAILABLE","Balance of income available is the income available after entering existing cover (to be retained) and any proposed top-up cover."]
[null,"EXISTING BENEFITS","Existing benefits are the existing benefits that are currently inforce and plan to be retained ie not cancelled. Enter for both the primary life and spouse/partner as required. "]
[null,"INDEMNITY COVER","Indemnity cover is where minimal financial underwriting requirements are required (subject to level of cover) at application/underwriting stage and the benefit payable in the event of a claim is based on the lesser of the monthly sum insured and the monthly equivalent of a percentage of pre-disability income (less any reductions or offsets that may apply). \n\nThe maximum amount of cover available is $25,000 pm.   \n\nPlease refer to the actual Income Protection Cover policy documents for further information on what is payable under Indemnity contracts. This calculator is intended to provide an indicative guide only."]
[null,"INSURABLE INCOME","Insurable income is an individuals usual and regular active income that would be used in calculating income to support income cover, ie that usual regular income that would most likely stop if they were unable to work due to disability as a result of sickness or injury.  \n\nPlease refer to the Fidelity Income Protection Calculator - it is a income calculation tool that will provide an indicative guide to what is an individuals insurable income.  \n"]
[null,"MAXIMUM MONTHLY MORTGAGE REPAYMENT COVER BENEFIT","This is the maximum monthly mortgage repayment cover benefit available based on insurable income and/or monthly mortgage or rent repayment amount entered for the primary life (and spouse/partner). Please note, the monthly mortgage or rent repayment amount for the spouse/partner is fixed based on what was entered for the primary life. \n\nIf you wish to work out the maximum monthly mortgage repayment cover benefit available for the spouse/partner based on a different monthly mortgage or rent repayment amount (to that for the primary life (and spouse/partner) we suggest saving this excel file and completing a new MRC Split Benefit Calculator for the spouse/partner as the primary life. If unsure please speak to your Fidelity Underwriter."]
[null,"MAXIMUM TOP-UP","Maximum top-up is an indicative guide of the maximum top-up cover available for each benefit type after considering insurable income and/or monthly mortgage or rent repayment amounts; existing benefits to be retained; and any proposed top-up benefits (in addition to existing). \n\nPlease note, this calculator is intended to provide an indicative guide only.  "]
[null,"MONTHLY BENEFIT","This is the monthly benefit amount either entered into the calculator for existing and/or proposed top-up benefits for Mortgage Repayment Cover, Agreed Value or Indemnity."]
[null,"MORTGAGE REPAYMENT COVER","Mortgage Repayment Cover is insurance that pays a monthly benefit amount to help cover mortgage repayments, rent or income in the event of disability because of illness or injury.  Cover is based on either: \n-up to 110% of mortgage or rent; or \n-up to 40% of insurable income. \n\nThe maximum amount of cover available is $20,000 pm. \n\nPlease note, in the event of a claim if the monthly sum insured is more that $5,000pm the amount above $5,000pm will be subject to any reductions or offsets that may apply - including an offset for any on-going income. \n\nPlease refer to the actual Mortgage Repayment Cover policy documents for further information on what is payable under Mortgage Repayment Cover contracts. This calculator is intended to provide an indicative guide only."]
[null,"OCCUPATION CLASS","Select the occupation class that best matches the life (from the drop down list):  \n• Class 1 - Professional/executive\n• Class 2 - Clerical\n• Class 3 - Light manual/tradesperson\n• Class 4 - Manual \n• Class 5 - Homemaker or non-worker - includes housewife/househusband/student/unemployed person. \n\nIf the class is other than in the list provided it will be subject to individual consideration, please refer to your Underwriter. \n\nPlease note, if a life assured has more than one occupation the occupation rating will usually be based on the more hazardous occupation. If you are unsure what occupation class applies please contact your Underwriter. "]
[null,"PRIMARY LIFE","This is the primary life to be insured. Enter their name at F9, select the occupation class that applies from the drop down list. Follow the same process of there is a spouse (or partner) as required.  Then enter other details and information in the ORANGE fields as required. "]
[null,"REPLACEMENT RATIOS","Replacement ratios determine the level of benefit based on insurable income. The replacement ratios used depend upon the type of benefit.   \n\nAgreed Value - the maximum sum insured is based on percentage of insurable income, worked out as follows: \n• 62.5% of the first $70,000\n• 60% of the next $30,000\n• 55% of the next $220,000\n• 33% of the next $240,000, and\n• 20% of the balance\n\nIndemnity (and Loss of Earnings) - the maximum sum insured is based on percentage of insurable income, worked out as follows:\n• 75% of the first $250,000\n• 50% of the next $150,000, and\n• 25% of the balance\n\nPlease refer to the Fidelity Income Protection Calculator for an indicative guide as to how to calculate insurable income and the replacement ratios that apply. This calculator provides an indicative guide only.  "]
[null,"REFERENCE","Enter your reference here, eg Adviser name or customer number etc."]
[null,"SPOUSE","Enter spouse (or partner) details at I9 and select the occupation class that applies from the drop down list. Then enter other details and information in the ORANGE fields as required. "]
[null,"TERMS OF USE (Part 1)"]
[null,"TERMS OF USE (cont… Part 2)"]
[null,"TERMS OF USE (cont… Part 3)"]

{"sheet":"BOH","index":9,"n_rows":77,"n_cols":21,"rows_kept":77,"cut":false,"hidden":true,"merged":[[6,1,6,2],[6,3,6,4],[7,1,7,2],[8,5,8,6],[10,5,10,6],[8,7,8,9],[8,11,8,13],[8,15,8,17],[56,13,57,15],[69,1,74,18],[54,2,54,4],[11,19,45,22],[44,1,44,5],[45,1,45,5],[52,2,52,4],[53,2,53,4],[0,4,0,8],[2,4,3,19],[62,0,67,18],[7,7,7,9],[7,11,7,13],[7,15,7,17],[61,1,61,3],[42,1,42,5],[43,1,43,5],[52,13,53,15],[54,13,55,15],[7,3,7,4],[8,1,8,2],[8,3,8,4],[57,7,57,9],[58,7,58,9]]}
["                  "]
[]
[null,null,null,null,"Business Overheads - Ongoing fixed expenses calculator"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable for all new Business expenses policies from"]
[]
[null,"Reference"]
[null,"Client Name",null,null,null,null,null,"Entity 1",null,null,null,"Entity 2",null,null,null,"Entity 3",null,null,null,null,"Click here to search for"]
[null,"Age/Occupation",null,null,null,"Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,"Help…","INSTRUCTIONS"]
[]
[null,"Allowable Business Expenses",null,null,null,"Most Recent Year",null,null,null,{"$f":"IF(H11=\"\",\"\",H11-1)","v":""},null,{"$f":"IF(H11=\"\",\"\",H11)","v":""},null,{"$f":"IF(H11=\"\",\"\",H11-1)","v":""},null,{"$f":"IF(H11=\"\",\"\",H11)","v":""},null,{"$f":"IF(H11=\"\",\"\",H11-1)","v":""},null,{"$f":"U9","v":"INSTRUCTIONS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(U9,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
[1,"Accounting Fees"]
[2,"Advertising"]
[3,"Audit Fees"]
[4,"Bank Fees"]
[5,"Cleaning (fixed contracts only)"]
[6,"Computer Costs (fixed support contracts only)"]
[7,"Electricity  (and other utlities costs)"]
[8,"Filing Fees"]
[9,"Gas"]
[10,"Heating"]
[11,"Hire of Business Plant and/or Equipment"]
[12,"Insurance - Business Insurance Premiums only (NOT IP)"]
[13,"Interest - Business only"]
[14,"Lease Costs - Business Equipment & Vehicles (paid to 3rd party)"]
[15,"Legal Fees (fixed and regular only)"]
[16,"Loan Repayments (minimum capital repayments only)"]
[17,"Locum (net cost only) FutureWise Only"]
[18,"Motor Vehicle (registration, insurance and leasing costs only)"]
[19,"Printing, Postage & Stationery"]
[20,"Property Rates and Taxes"]
[21,"Registrations - Business and Professional only"]
[22,"Rent (paid to third party)"]
[23,"Repairs & Maintenance (fixed contract only)"]
[24,"Salary/Wages (non income generating employees only)"]
[25,"Security (fixed contract only)"]
[26,"Subscriptions - Business and Professional only"]
[27,"Superannuation (non income generating employees only)"]
[28,"Telephone"]
[29,"Water"]
[30,"Workers Comp (non income generating employees only)"]
[31]
[32]
[33]
[34]
[null,"Total Allowable Business Expenses",null,null,null,null,null,{"$f":"SUM(H13:H46)","v":0},null,{"$f":"SUM(J13:J46)","v":0},null,{"$f":"SUM(L13:L46)","v":0},null,{"$f":"SUM(N13:N46)","v":0},null,{"$f":"SUM(P13:P46)","v":0},null,{"$f":"SUM(R13:R46)","v":0}]
[]
[null,{"$f":"\"\"&D8&\"'s Ownership Interest\"","v":"'s Ownership Interest"}]
[null,{"$f":"\"\"&D8&\"'s share of Allowable Business Expenses\"","v":"'s share of Allowable Business Expenses"},null,null,null,null,null,{"$f":"SUM(H47*H49)","v":0},null,{"$f":"SUM(J47*J49)","v":0},null,{"$f":"SUM(L47*L49)","v":0},null,{"$f":"SUM(N47*N49)","v":0},null,{"$f":"SUM(P47*P49)","v":0},null,{"$f":"SUM(R47*R49)","v":0}]
[]
[null,"Summary of Allowable Business Expenses"]
[null,null,{"$f":"IF(H9=\"\",\"\",H9)","v":""},null,null,null,null,{"$f":"H50","v":0},null,{"$f":"J50","v":0},null,null,null,"Monthly Benefit"]
[null,null,{"$f":"IF(L9=\"\",\"\",L9)","v":""},null,null,null,null,{"$f":"L50","v":0},null,{"$f":"N50","v":0},null,null,{"$f":"H59","v":0}]
[null,null,{"$f":"IF(P9=\"\",\"\",P9)","v":""},null,null,null,null,{"$f":"P50","v":0},null,{"$f":"R50","v":0},null,null,null,{"$f":"IF(H59>60000,60000,H59)","v":0}]
[null,{"$f":"\"Total Allowable Business Expenses for \"&D8&\"\"","v":"Total Allowable Business Expenses for "},null,null,null,null,null,{"$f":"SUM(H53:H55)","v":0},null,{"$f":"SUM(J53:J55)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N55<1000,\"NB: Minimum monthly amount insured is $1,000\",IF(N55=60000,\"NB: Maximum monthly amount insured is $60,000\",\"\"))","v":"NB: Minimum monthly amount insured is $1,000"}]
[null,"Total Maximum Annual Benefit (lesser of Current Year or Average)",null,null,null,null,null,{"$f":"IF(J56=0,H56,IF(H56<((H56+J56)/2),H56,((H56+J56)/2)))","v":0}]
[null,"Total Maximum Monthly Benefit",null,null,null,null,null,{"$f":"SUM(H58/12)","v":0}]
[]
[]
[null,"Notes & Comments"]
[]
[]
[]
[]
[]
[]
[]
[null,"Important Information: The purpose of this calculator is to provide an indicative guide only and is not intended to be a comprehensive final assessment of an applicant's allowable insured monthly benefit. A final determination of the allowable insured monthly benefit is subject to the satisfactory completion of an application, including a personal statement for each life insured, and providing Z with all information it requests through the underwriting process. Conditions, limits and exclusions may apply and are explained in the applicable Z Product Disclosure Statement and Policy Document (PDS). Always consider the PDS before making any decision in relation to insurance.\nFor the full details of the Terms of Use of this calculator please refer to the Help notes.\n\nThis calculator is prepared by "]
[]
[]
[]
[]
[]
[]
[null,"XXX"]

{"sheet":"ADMIN","index":10,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["IP Calculator Administration"]
[null,null,null,null,"Years",{"$f":"'MAIN ENTITY'!I9","v":0},null,{"$f":"'MAIN ENTITY'!K9","v":""},null,{"$f":"'MAIN ENTITY'!M9","v":""}]
[null,{"$f":"'MAIN ENTITY'!B61","v":"Total Net Income - "},null,null,null,{"$f":"'MAIN ENTITY'!I61","v":0},null,{"$f":"'MAIN ENTITY'!K61","v":0},null,{"$f":"'MAIN ENTITY'!M61","v":0},null,"Yes","per annum",null,"30 days"]
[null,null,null,null,null,null,null,null,null,null,null,"No","per month",null,"60 days"]
[null,"Latest Year variance on previous year >",null,null,0.2,{"$f":"IF(F3<1,0,IF(F3<H3,F3,IF(F3>=(H3+(H3*E5)),F7,IF((F3>H3),F3,F7))))","v":0},null,null,null,null,null,null,"per week",null,"90 days"]
[]
[null,"Average for the years entered",null,null,null,{"$f":"IF(H3=0,F3,IF(OR(J3=0,J3>F3*120%,J3<F3*80%),(F3+H3)/2,(F3+H3+J3)/3))","v":0},null,null,null,null,null,null,"Key Person Replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ongoing Fixed"]
[null,"Negative Check",null,null,null,{"$f":"IF(F5<0,0,F5)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Self-employed or business owner"]
[null,"After unearned income adjustment",null,null,null,{"$f":"'MAIN ENTITY'!I64","v":0},null,{"$f":"IF(F12>(F9*25%),\"GREATER THAN 25% - ADJUSTMENT REQUIRED\",\"LESS THAN 25% - NO ADJUSTMENT\")","v":"LESS THAN 25% - NO ADJUSTMENT"},null,null,null,null,"Employee ONLY"]
[]
[null,"AV Replacement ratios",null,null,null,{"$f":"IF(H12=\"Greater than 25% - adjustment required\",F12+F9,F9)","v":0},null,"Annual",null,"Monthly",null,null,"AGREED VALUE",null,null,null,"Hours per week"]
[null,"Up to $70,000 income per year",null,null,0.625,{"$f":"IF(F14>70000,70000,F14)","v":0},null,{"$f":"E15*F15","v":0},null,{"$f":"H15/12","v":0},null,null,"INDEMNITY",null,null,null,"% O'ship"]
[null,"$70,001 – $100,000 income per year",null,null,0.6,{"$f":"IF(F14>100000,100000-F15,\"\")","v":""},null,{"$f":"IF(F16=\"\",0,E16*F16)","v":0},null,{"$f":"H16/12","v":0},null,null,"MORTGAGE REPAYMENT"]
[null,"$100,001 – $320,000 income per year",null,null,0.55000000000000004,{"$f":"IF(F14>320000,320000-F16-F15,F14-F15-F16)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(F17=\"\",0,E17*F17)","v":{"$error":"#VALUE!"}},null,{"$f":"H17/12","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,"Target prod'n"]
[null,"$320,001 – $440,000 income per year",null,null,0.35,{"$f":"IF(F14>440000,440000-F17-F16-F15,F14-F15-F16-F17)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(F18=\"\",0,E18*F18)","v":{"$error":"#VALUE!"}},null,{"$f":"H18/12","v":{"$error":"#VALUE!"}},{"$f":"SUM(J15:J18)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Number of cows"]
[null,"In excess of $440,000 income per year",null,null,0.2,{"$f":"IF(F14>440000,F14-440000,\"\")","v":""},null,{"$f":"IF(F19=\"\",0,E19*F19)","v":0},null,{"$f":"H19/12","v":0},null,null,"Mortgage/Rent"]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(H15:H19)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(J15:J19)","v":{"$error":"#VALUE!"}},null,null,"Income"]
[null,null,null,null,null,"Less unearned income ",null,{"$f":"IF($H$12=\"greater than 25% - adjustment required\",$F$12,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H20-H21<0,0,IF((H20-H21)>240000,240000,H20-H21))","v":{"$error":"#VALUE!"}},null,{"$f":"H22/12","v":{"$error":"#VALUE!"}},{"$f":"IF(J22>30000,30000,J22)","v":{"$error":"#VALUE!"}},null,"Max benefit available with any unearned income adjustment is $20,000mb"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Max AV benefit of $30,000pm equates to income ",null,null,null,{"$f":"440000+(((30000-K18)*12)/0.2)","v":{"$error":"#VALUE!"}}]
[null,"Max AV benefit is",null,30000,"equates to",{"$f":"440000+(((30000-K18)*12)/0.2)","v":{"$error":"#VALUE!"}},null,1116250]
[null,"Indemnity top-up",null,null,0.25,{"$f":"IF(F14=0,0,IF((F14-H24)<0,0,F14-H24))","v":0},null,{"$f":"IF(F25<0,0,E25*F25)","v":0},null,{"$f":"H25/12","v":0},{"$f":"IF(J25>30000,30000,J25)","v":0}]
[]
[null,"Indemnity Replacement ratios",null,null,null,{"$f":"F14","v":0},null,"Annual",null,"Monthly"]
[null,"Up to $320,000 income per year",null,null,0.75,{"$f":"IF(F27>320000,320000,F27)","v":0},null,{"$f":"E28*F28","v":0},null,{"$f":"H28/12","v":0}]
[null,"$320,001 – $440,000 income per year",null,null,0.5,{"$f":"IF(F27>440000,120000,F27-F28)","v":0},null,{"$f":"IF(F29=\"\",0,E29*F29)","v":0},null,{"$f":"H29/12","v":0},{"$f":"SUM(J28:J29)","v":0}]
[null,"In excess of $440,000 income per year",null,null,0.25,{"$f":"IF(F27>440000,F27-440000,\"\")","v":""},null,{"$f":"IF(F30=\"\",0,E30*F30)","v":0},null,{"$f":"H30/12","v":0}]
[null,null,null,null,null,{"$f":"SUM(F28:F30)","v":0},null,{"$f":"SUM(H28:H30)","v":0},null,{"$f":"SUM(J28:J30)","v":0}]
[null,null,null,null,null,"Less unearned income ",null,{"$f":"IF($H$12=\"greater than 25% - adjustment required\",$F$12,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H31-H32<0,0,IF((H31-H32)>240000,240000,H31-H32))","v":0},null,{"$f":"H33/12","v":0},{"$f":"IF(J33>30000,30000,J33)","v":0},null,"Max benefit available with any unearned income adjustment is $20,000mb"]
[]
[null,"Max Indemnity benefit is",null,30000,"equates to ",{"$f":"440000+(((30000-K29)*12)/0.25)","v":1880000},null,680000]
[null,"Indemnity top-up",null,null,0.25,{"$f":"IF(F27=0,0,IF((F27-H35)<0,0,F27-H35))","v":0},null,{"$f":"IF(F36<0,0,E36*F36)","v":0},null,{"$f":"H36/12","v":0},{"$f":"IF(J36>30000,30000,J36)","v":0}]
[]
[null,"Mortgage repayment cover replacement ratios",null,null,null,null,null,"Annual",null,"Monthly"]
[null,null,null,null,0.4,{"$f":"F14","v":0},null,{"$f":"E39*F39","v":0},null,{"$f":"H39/12","v":0}]
[null,null,null,null,null,"Less unearned income ",null,{"$f":"IF($H$12=\"greater than 25% - adjustment required\",$F$12,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H39-H40<0,0,IF((H39-H40)>240000,240000,H39-H40))","v":0},null,{"$f":"H41/12","v":0},{"$f":"IF(J41>30000,30000,J41)","v":0},null,"Max benefit available with any unearned income adjustment is $20,000mb"]
[]
[null,"Max MRC benefit is ",null,30000,"equates to ",{"$f":"(30000/0.4)*12","v":900000},null,900000]
[null,"Indemnity top-up",null,null,0.25,{"$f":"IF(F39=0,0,IF((F39-H43)<0,0,F39-H43))","v":0},null,{"$f":"IF(F44<0,0,E44*F44)","v":0},null,{"$f":"H44/12","v":0},{"$f":"IF(J44>30000,30000,J44)","v":0}]