{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet2","index":0,"n_rows":114,"n_cols":18,"rows_kept":114,"cut":false,"hidden":false,"merged":[[103,2,103,4],[110,2,111,2],[110,3,111,3],[0,6,13,11],[4,2,5,4],[6,3,6,4],[7,3,7,4],[51,14,51,15]]}
[{"$nulls":6},"Instructions:\nPlease ensure that all highlighted cells (Grey) have an appropriate response.\n1) Enter Client's Name and Code.\n2) Ensure that there is only one response for each question.\n3) Ensure that there is no error in responses.\n4) Check to see if the client agrees with the risk profile.\n5) If there is a disagreement then, select the alternate risk profile as per client's reckoning.\n6) Ensure that the client has signed off on the risk profiler.\n\n"]
[]
[null,null,null,"MSA Financial Services"]
[]
[null,null," Risk Profiler"]
[]
[null,null,"Name:"]
[null,null,"Mobile No"]
[null,null,null,"Please select from Drop-down"]
[null,null,"No.","Questions","Select"]
[null,{"$f":"IF(C12>B10,\"\",IF(C11=\"\",B10,C11))","v":1},1,"Client's Age",{"$f":"IF(E12=\"Y\",4,IF(E13=\"Y\",3,IF(E14=\"Y\",2,IF(E15=\"Y\",1,\"-\"))))","v":"-"},3]
[null,1,null,"<30",null,3]
[null,1,null,"30-45",null,3]
[null,1,null,"45-60",null,3]
[null,1,null,">60",null,1]
[null,""]
[null,2,{"$f":"B15+1","v":2},"What is your current profession?",{"$f":"IF(E18=\"Y\",5,IF(E19=\"Y\",4,IF(E20=\"Y\",3,IF(E21=\"Y\",1,IF(E22=\"Y\",2,\"-\")))))","v":"-"},5]
[null,2,null,"Skilled Professional (Doctor, Lawyer, etc.)",null,5]
[null,2,null,"Salaried",null,4]
[null,2,null,"Businessman",null,3]
[null,2,null,"Homemaker",null,1]
[null,2,null,"Retired",null,2]
[null,""]
[null,3,{"$f":"B22+1","v":3},"What is your marital status?",{"$f":"IF(E25=\"Y\",2,IF(E26=\"Y\",1,\"-\"))","v":"-"},1]
[null,3,null,"Unmarried",null,2]
[null,3,null,"Married",null,1]
[null,""]
[null,4,{"$f":"B26+1","v":4},"Select the number of dependent children",{"$f":"IF(E29=\"Y\",4,IF(E30=\"Y\",3,IF(E31=\"Y\",2,IF(E32=\"Y\",1,\"-\"))))","v":"-"},3]
[null,4,null,0,null,4]
[null,4,null,1,null,3]
[null,4,null,2,null,2]
[null,4,null,">3",null,1,{"$nulls":6},"Q","Answer","Min","Max"]
[null,"",{"$nulls":10},1,{"$f":"IFERROR(INDEX(E:E,MATCH(M33,C:C)),\"0\")","v":"-"},{"$f":"MIN(IF(B$11:B$98=M33,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M33,F$11:F$98))","v":3}]
[null,5,{"$f":"B32+1","v":5},"Select the number of other dependents",{"$f":"IF(E35=\"Y\",4,IF(E36=\"Y\",3,IF(E37=\"Y\",2,IF(E38=\"Y\",1,\"-\"))))","v":"-"},3,{"$nulls":6},{"$f":"M33+1","v":2},"-",{"$f":"MIN(IF(B$11:B$98=M34,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M34,F$11:F$98))","v":5}]
[null,5,null,0,null,4,{"$nulls":6},3,"-",{"$f":"MIN(IF(B$11:B$98=M35,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M35,F$11:F$98))","v":2}]
[null,5,null,1,null,3,{"$nulls":6},4,"-",{"$f":"MIN(IF(B$11:B$98=M36,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M36,F$11:F$98))","v":4}]
[null,5,null,2,null,2,{"$nulls":6},5,"-",{"$f":"MIN(IF(B$11:B$98=M37,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M37,F$11:F$98))","v":4}]
[null,5,null,">3",null,1,{"$nulls":6},6,"-",{"$f":"MIN(IF(B$11:B$98=M38,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M38,F$11:F$98))","v":5}]
[null,"",{"$nulls":10},7,"-",{"$f":"MIN(IF(B$11:B$98=M39,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M39,F$11:F$98))","v":4}]
[null,6,{"$f":"B38+1","v":6},"What is your current net worth in lakhs?",{"$f":"IF(E41=\"Y\",5,IF(E42=\"Y\",4,IF(E43=\"Y\",3,IF(E44=\"Y\",2,IF(E45=\"Y\",1,\"-\")))))","v":"-"},1,{"$nulls":6},8,"-",{"$f":"MIN(IF(B$11:B$98=M40,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M40,F$11:F$98))","v":4}]
[null,6,null,">1,500",null,5,{"$nulls":6},9,"-",{"$f":"MIN(IF(B$11:B$98=M41,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M41,F$11:F$98))","v":4}]
[null,6,null,"500-1,500",null,4,{"$nulls":6},10,"-",{"$f":"MIN(IF(B$11:B$98=M42,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M42,F$11:F$98))","v":3}]
[null,6,null,"100-500",null,3,{"$nulls":6},11,"-",{"$f":"MIN(IF(B$11:B$98=M43,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M43,F$11:F$98))","v":4}]
[null,6,null,"25-100",null,2,{"$nulls":6},12,"-",{"$f":"MIN(IF(B$11:B$98=M44,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M44,F$11:F$98))","v":4}]
[null,6,null,"<25",null,1,{"$nulls":6},13,"-",{"$f":"MIN(IF(B$11:B$98=M45,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M45,F$11:F$98))","v":4}]
[null,"",{"$nulls":10},14,"-",{"$f":"MIN(IF(B$11:B$98=M46,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M46,F$11:F$98))","v":4}]
[null,7,{"$f":"B45+1","v":7},"What is your annual income from all sources in lakhs?",{"$f":"IF(E48=\"Y\",1,IF(E49=\"Y\",2,IF(E50=\"Y\",3,IF(E51=\"Y\",4,\"-\"))))","v":"-"},2,{"$nulls":6},15,"-",{"$f":"MIN(IF(B$11:B$98=M47,F$11:F$98))","v":1},{"$f":"MAX(IF(B$11:B$98=M47,F$11:F$98))","v":4}]
[null,7,null,"<10 ",null,1,{"$nulls":6},"Sum",{"$f":"SUM(N33:N47)","v":0},15,58,null,{"$f":"P48-O48","v":43}]
[null,7,null,"10-50",null,2,{"$nulls":6},{"$f":"IF(AND(N48>=O53,N48<=P53),N53,IF(AND(N48>=O54,N48<=P54),N54,IF(AND(N48>=O55,N48<=P55),N55,IF(AND(N48>=O56,N48<=P56),N56,IF(AND(N48>=O57,N48<=P57),N57,IF(N48<O53,\"\"))))))","v":""}]
[null,7,null,"50-100",null,3]
[null,7,null,">100",null,4]
[null,"",{"$nulls":11},"Risk Profile","(Score)"]
[null,8,{"$f":"B51+1","v":8},"What is your annual family income from all sources in lakhs?",{"$f":"IF(E54=\"Y\",1,IF(E55=\"Y\",2,IF(E56=\"Y\",3,IF(E57=\"Y\",4,\"-\"))))","v":"-"},2,{"$nulls":7},"Super Safe",{"$f":"O48","v":15},{"$f":"O53+Q53","v":23},8,{"$f":"SUM(Q53:Q57)+COUNTA(O53:O57)-1","v":43}]
[null,8,null,"<10 ",null,1,{"$nulls":7},"Safe",{"$f":"P53+1","v":24},32,8]
[null,8,null,"10-50",null,2,{"$nulls":7},"Balanced",33,42,9]
[null,8,null,"50-100",null,3,{"$nulls":7},"Aggressive",43,51,8]
[null,8,null,">100",null,4,{"$nulls":7},"Very Aggressive",52,{"$f":"P48","v":58},{"$f":"P57-O57","v":6}]
[]
[null,{"$f":"IF(C64>B58,\"\",IF(C63=\"\",B58,C63))","v":9},null,null,null,2]
[null,9,null,null,null,1,{"$nulls":7},"Yes"]
[null,9,null,null,null,2,{"$nulls":7},"No"]
[null,9,null,null,null,3]
[null,9,{"$f":"B57+1","v":9},"What percentage of family annual income have you saved in last 3 years?",{"$f":"IF(E64=\"Y\",1,IF(E65=\"Y\",2,IF(E66=\"Y\",3,IF(E67=\"Y\",4,\"-\"))))","v":"-"},4]
[null,"",null,"< 15%"]
[null,10,null,"15-30%",null,2]
[null,10,null,"30-40%",null,3]
[null,10,null,"> 40%",null,2]
[null,10,null,null,null,1]
[null,"",{"$f":"B63+1","v":10},"What best characterizes your risk appetite?",{"$f":"IF(E70=\"Y\",3,IF(E71=\"Y\",2,IF(E72=\"Y\",1,\"-\")))","v":"-"}]
[null,11,null,"High ",null,2]
[null,11,null,"Moderate ",null,4]
[null,11,null,"Low ",null,2]
[null,11,null,null,null,1]
[null,11,{"$f":"B68+1","v":11},"What best characterizes your Risk/Reward preference?",{"$f":"IF(E75=\"Y\",4,IF(E76=\"Y\",2,IF(E77=\"Y\",1,IF(E78=\"Y\",3,\"-\"))))","v":"-"},3]
[null,"",null,"High Risk / High Return"]
[null,12,null,"Medium Risk / Medium Return",null,2]
[null,12,null,"Low Risk / Low Return",null,4]
[null,12,null,"Market linked",null,3]
[null,12,null,null,null,2]
[null,12,{"$f":"B74+1","v":12},"What is your primary investment objective?",{"$f":"IF(E81=\"Y\",4,IF(E82=\"Y\",3,IF(E83=\"Y\",2,IF(E84=\"Y\",1,\"-\"))))","v":"-"},1]
[null,"",null,"Capital appreciation"]
[null,13,null,"Regular income",null,3]
[null,13,null,"Liquidity",null,1]
[null,13,null,"Capital preservation",null,2]
[null,13,null,null,null,3]
[null,13,{"$f":"B80+1","v":13},"What is your investment horizon (# of years)?",{"$f":"IF(E87=\"Y\",1,IF(E88=\"Y\",2,IF(E89=\"Y\",3,IF(E90=\"Y\",4,\"-\"))))","v":"-"},4]
[null,"",null,"<2"]
[null,14,null,"2-4",null,4]
[null,14,null,"4-7",null,1]
[null,14,null,">7",null,2]
[null,14,null,null,null,3]
[null,14,{"$f":"B86+1","v":14},"What is your outstanding obligation (in lakhs)?",{"$f":"IF(E93=\"Y\",1,IF(E94=\"Y\",2,IF(E95=\"Y\",3,IF(E96=\"Y\",4,\"-\"))))","v":"-"},4]
[null,"",null,">100"]
[null,15,null,"25-100",null,3]
[null,15,null,"5-25",null,1]
[null,15,null,"<5",null,2]
[null,15,null,null,null,3]
[null,15,{"$f":"B92+1","v":15},"How familiar are you with investments in securities market?",{"$f":"IF(E99=\"Y\",1,IF(E100=\"Y\",2,IF(E101=\"Y\",3,IF(E102=\"Y\",4,\"-\"))))","v":"-"},4]
[null,null,null,"Not at all"]
[null,null,null,"Limited familiarity"]
[null,null,null,"Good familiarity"]
[null,null,null,"Extensive knowledge"]
[]
[null,null,{"$f":"IF(AND(COUNTIF(E11:E102,\"Y\")<>15,COUNTIF(E11:E102,\"Y\")<>0),\"Error in reponses, please check all responses\",\"\")","v":""}]
[null,null,"Based on above responses, your risk profile is ",null,{"$f":"IF(C104<>\"\",\"\",M49)","v":""}]
[]
[null,null,"Do you accept our assessment of risk profile?"]
[]
[null,null,{"$f":"IF(E107=\"Yes\",\"I agree with the assesment\",\"No, I don't agree with risk profile evaluated above and I believe my risk profile is\")","v":"No, I don't agree with risk profile evaluated above and I believe my risk profile is"}]
[]
[null,null,"Client's Signature"]
[]
[]
[null,null,"Date:"]