{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["FORM_A - MODELE","Tables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":7,"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":"FORM_A - MODELE","index":0,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[[44,1,44,14],[33,6,33,7],[23,9,23,10],[18,4,18,6],[18,7,18,11],[18,1,18,3],[41,1,41,14],[42,1,42,14],[43,1,43,14],[19,1,19,3],[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,6,25,6],[24,8,25,8],[3,4,3,5],[4,4,4,5],[5,4,5,5],[16,7,16,11],[12,4,12,7],[1,4,1,7],[2,4,2,7],[12,12,12,14],[12,9,12,11],[17,1,17,3],[15,1,15,3],[15,4,15,6],[16,1,16,3],[16,4,16,6],[17,4,17,6],[17,8,17,9],[14,1,14,4],[12,1,12,3],[10,12,10,14],[10,1,11,3],[11,4,11,7],[10,9,11,11],[11,12,11,14],[10,4,10,7]]}
[]
[null,"Complété par :","Société"]
[null,null,"Personne de contact"]
[null,null,"Téléphone"]
[null,null,"Adresse e-mail"]
[null,null,"Date"]
[]
[null,null,"Ruling du",null,null,"Canton"]
[]
[]
[null,"Nom du groupe ou de la société \ndont proviennent les participations",null,null,null,null,null,null,null,"Nom de l'employeur (ou ex-employeur)"]
[]
[null,"Nom de l'action + code boursier",null,null,null,null,null,null,52,"Type de participations"]
[null,null,null,null,null,null,"Monnaie","",29]
[null,null,null,null,null,50]
[null,"No AVS"]
[null,"Nom et prénom"]
[null,"Rue",null,null,null,null,null,null,"CALCULS AUTOMATIQUES"]
[null,"Localité"]
[null,"Période fiscale, du …",null,null,null,"au …"]
[null,null,null,null,null,null,null,null,null,31,32]
[null,"Historique des participations et état à la fin de la période, au :",null,null,null,null,{"$f":"IF(ISBLANK($G$20),\"\",$G$20)","v":""},"(à déclarer dans l'état des titres de la déclaration d'impôt - imposable en fortune)"]
[]
[null,2,13,16,20,18,27,21,28,"ou",null,34,null,30]
[null,"Désignation du plan de participations","Date d'acquisition des participations","Date d'échéance du délai de blocage","Durée jusqu'à l'expiration du délai de blocage","Escompte pour le temps restant jusqu'à la fin du délai de blocage","Nombre de participations acquises","Durée de l'éventuelle obligation de restitution","Nombre de participations détenues à la fin de la période","Valeur vénale de la participation à la fin de la période","Valeur de l'action non cotée établie à l'aide d'une formule","Valeur vénale escomptée\n par participation","Valeur totale escomptée","Cours de change","Fortune imposable en Suisse"]
[null,null,null,null,"(En années)","(%)",null,"(En années)",null,{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},null,"(CHF)"]
[null,null,null,null,{"$f":"IF(AND($G$20>0,$G$22>0),IF((D27-$G$22)/365>=0,(D27-$G$22)/365,0),0)","v":0},{"$f":"IF(E27=0,0,1-POWER(1+0.06,-E27))","v":0},null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(J27)),IF(F27=\"0\",J27,J27*(1-F27)),IF(F27=\"0\",K27,K27*(1-F27)))","v":0},{"$f":"L27*I27","v":0},1,{"$f":"IF(M27*N27>0,M27*N27,0)","v":0}]
[null,null,null,null,{"$f":"IF(AND($G$20>0,$G$22>0),IF((D28-$G$22)/365>=0,(D28-$G$22)/365,0),0)","v":0},{"$f":"IF(E28=0,0,1-POWER(1+0.06,-E28))","v":0},null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(J28)),IF(F28=\"0\",J28,J28*(1-F28)),IF(F28=\"0\",K28,K28*(1-F28)))","v":0},{"$f":"L28*I28","v":0},1,{"$f":"IF(M28*N28>0,M28*N28,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FORTUNE IMPOSABLE à déclarer dans l'état des titres de la déclaration d'impôt",{"$f":"IF(SUM(O27:O29)>0,SUM(O27:O29),0)","v":0}]
[null,null,null,null,null,null,31,32]
[null,"Calcul du revenu imposable pour les participations acquises durant cette période :"]
[]
[null,2,13,16,17,27,"ou",null,33,21,35,36,37,30]
[null,"Désignation du plan de participations","Date d'acquisition des participations","Date d'échéance du délai de blocage","Abattement pour délai de blocage","Nombre de participations acquises","Valeur vénale de la participation à la date d'acquisition","Valeur de l'action non cotée établie à l'aide d'une formule","Formule de calcul pour l'évaluation de l'action","Durée de l'éventuelle obligation de restitution","Prix d'acquisition","Prestation appréciable en argent par participation","Prestation totale","Cours de change","Revenu déclaré dans le certificat de salaire"]
[null,null,null,null,"(%)",null,{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},"(Texte)","(En années)",{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},null,"(CHF)"]
[null,null,null,null,{"$f":"IF(ISBLANK(D37),0,1-POWER(1+0.06,-(D37-C37)/365))","v":0},null,null,null,null,null,null,{"$f":"IF(AND(H37>0,G37>0),\"Erreur\",IF(NOT(ISBLANK(H37)),H37*(1-E37)-K37,G37*(1-E37)-K37))","v":0},{"$f":"L37*F37","v":0},1,{"$f":"M37*N37","v":0}]
[null,null,null,null,{"$f":"IF(ISBLANK(D38),0,1-POWER(1+0.06,-(D38-C38)/365))","v":0},null,null,null,null,null,null,{"$f":"IF(AND(H38>0,G38>0),\"Erreur\",IF(NOT(ISBLANK(H38)),H38*(1-E38)-K38,G38*(1-E38)-K38))","v":0},{"$f":"L38*F38","v":0},1,{"$f":"M38*N38","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"REVENU imposable, déclaré au chiffre 5 du certificat de salaire",{"$f":"SUM(O37:O39)","v":0}]
[null,"Remarques :",56]

{"sheet":"Tables","index":1,"n_rows":173,"n_cols":7,"rows_kept":173,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Tab_Monnaie",null,null,"Tab_Canton",null,"Tab_Type_participation"]
[null,"Monnaie",null,null,"Canton",null,"Type de participations"]
[null,"CHF","Swiss Franc",null,"AG",null,"Actions de collaborateur"]
[null,"EUR","Euro",null,"AI",null,"Options cotées en bourse et librement négociables"]
[null,"USD","US Dollar",null,"AR"]
[null,"JPY","Yen",null,"BE"]
[null,"AFN","Afghani",null,"BL",null,"Tab_Type_operation"]
[null,"DZD","Algerian Dinar",null,"BS",null,"Type d'opération"]
[null,"ARS","Argentine Peso",null,"FR",null,"Attribution"]
[null,"AMD","Armenian Dram",null,"GE",null,"Acquisition"]
[null,"AWG","Aruban Florin",null,"GL"]
[null,"AUD","Australian Dollar",null,"GR"]
[null,"AZN","Azerbaijanian Manat",null,"JU"]
[null,"BSD","Bahamian Dollar",null,"LU"]
[null,"BHD","Bahraini Dinar",null,"NE"]
[null,"THB","Baht",null,"NW"]
[null,"PAB","Balboa",null,"OW"]
[null,"BBD","Barbados Dollar",null,"SG"]
[null,"BYR","Belarussian Ruble",null,"SH"]
[null,"BZD","Belize Dollar",null,"SO"]
[null,"BMD","Bermudian Dollar",null,"SZ"]
[null,"VEF","Bolivar",null,"TG"]
[null,"BOB","Boliviano",null,"TI"]
[null,"BRL","Brazilian Real",null,"UR"]
[null,"BND","Brunei Dollar",null,"VD"]
[null,"BGN","Bulgarian Lev",null,"VS"]
[null,"BIF","Burundi Franc",null,"ZG"]
[null,"CVE","Cabo Verde Escudo",null,"ZH"]
[null,"CAD","Canadian Dollar"]
[null,"KYD","Cayman Islands Dollar"]
[null,"XOF","CFA Franc BCEAO"]
[null,"XAF","CFA Franc BEAC"]
[null,"XPF","CFP Franc"]
[null,"CLP","Chilean Peso"]
[null,"COP","Colombian Peso"]
[null,"KMF","Comoro Franc"]
[null,"CDF","Congolese Franc"]
[null,"BAM","Convertible Mark"]
[null,"NIO","Cordoba Oro"]
[null,"CRC","Costa Rican Colon"]
[null,"HRK","Croatian Kuna"]
[null,"CUP","Cuban Peso"]
[null,"CZK","Czech Koruna"]
[null,"GMD","Dalasi"]
[null,"DKK","Danish Krone"]
[null,"MKD","Denar"]
[null,"DJF","Djibouti Franc"]
[null,"STD","Dobra"]
[null,"DOP","Dominican Peso"]
[null,"VND","Dong"]
[null,"XCD","East Caribbean Dollar"]
[null,"EGP","Egyptian Pound"]
[null,"SVC","El Salvador Colon"]
[null,"ETB","Ethiopian Birr"]
[null,"EUR","Euro"]
[null,"FKP","Falkland Islands Pound"]
[null,"FJD","Fiji Dollar"]
[null,"HUF","Forint"]
[null,"GHS","Ghana Cedi"]
[null,"GIP","Gibraltar Pound"]
[null,"HTG","Gourde"]
[null,"PYG","Guarani"]
[null,"GNF","Guinea Franc"]
[null,"GYD","Guyana Dollar"]
[null,"HKD","Hong Kong Dollar"]
[null,"UAH","Hryvnia"]
[null,"ISK","Iceland Krona"]
[null,"INR","Indian Rupee"]
[null,"IRR","Iranian Rial"]
[null,"IQD","Iraqi Dinar"]
[null,"JMD","Jamaican Dollar"]
[null,"JOD","Jordanian Dinar"]
[null,"KES","Kenyan Shilling"]
[null,"PGK","Kina"]
[null,"LAK","Kip"]
[null,"KWD","Kuwaiti Dinar"]
[null,"MWK","Kwacha"]
[null,"AOA","Kwanza"]
[null,"MMK","Kyat"]
[null,"GEL","Lari"]
[null,"LBP","Lebanese Pound"]
[null,"ALL","Lek"]
[null,"HNL","Lempira"]
[null,"SLL","Leone"]
[null,"LRD","Liberian Dollar"]
[null,"LYD","Libyan Dinar"]
[null,"SZL","Lilangeni"]
[null,"LTL","Lithuanian Litas"]
[null,"LSL","Loti"]
[null,"MGA","Malagasy Ariary"]
[null,"MYR","Malaysian Ringgit"]
[null,"MUR","Mauritius Rupee"]
[null,"MXN","Mexican Peso"]
[null,"MXV","Mexican Unidad de Inversion (UDI)"]
[null,"MDL","Moldovan Leu"]
[null,"MAD","Moroccan Dirham"]
[null,"MZN","Mozambique Metical"]
[null,"BOV","Mvdol"]
[null,"NGN","Naira"]
[null,"ERN","Nakfa"]
[null,"NAD","Namibia Dollar"]
[null,"NPR","Nepalese Rupee"]
[null,"ANG","Netherlands Antillean Guilder"]
[null,"ILS","New Israeli Sheqel"]
[null,"RON","New Romanian Leu"]
[null,"TWD","New Taiwan Dollar"]
[null,"NZD","New Zealand Dollar"]
[null,"BTN","Ngultrum"]
[null,"KPW","North Korean Won"]
[null,"NOK","Norwegian Krone"]
[null,"PEN","Nuevo Sol"]
[null,"MRO","Ouguiya"]
[null,"TOP","Pa’anga"]
[null,"PKR","Pakistan Rupee"]
[null,"MOP","Pataca"]
[null,"CUC","Peso Convertible"]
[null,"UYU","Peso Uruguayo"]
[null,"PHP","Philippine Peso"]
[null,"GBP","Pound Sterling"]
[null,"BWP","Pula"]
[null,"QAR","Qatari Rial"]
[null,"GTQ","Quetzal"]
[null,"ZAR","Rand"]
[null,"OMR","Rial Omani"]
[null,"KHR","Riel"]
[null,"MVR","Rufiyaa"]
[null,"IDR","Rupiah"]
[null,"RUB","Russian Ruble"]
[null,"RWF","Rwanda Franc"]
[null,"SHP","Saint Helena Pound"]
[null,"SAR","Saudi Riyal"]
[null,"RSD","Serbian Dinar"]
[null,"SCR","Seychelles Rupee"]
[null,"SGD","Singapore Dollar"]
[null,"SBD","Solomon Islands Dollar"]
[null,"KGS","Som"]
[null,"SOS","Somali Shilling"]
[null,"TJS","Somoni"]
[null,"SSP","South Sudanese Pound"]
[null,"LKR","Sri Lanka Rupee"]
[null,"SDG","Sudanese Pound"]
[null,"SRD","Surinam Dollar"]
[null,"SEK","Swedish Krona"]
[null,"CHF","Swiss Franc"]
[null,"SYP","Syrian Pound"]
[null,"BDT","Taka"]
[null,"WST","Tala"]
[null,"TZS","Tanzanian Shilling"]
[null,"KZT","Tenge"]
[null,"TTD","Trinidad and Tobago Dollar"]
[null,"MNT","Tugrik"]
[null,"TND","Tunisian Dinar"]
[null,"TRY","Turkish Lira"]
[null,"TMT","Turkmenistan New Manat"]
[null,"AED","UAE Dirham"]
[null,"UGX","Uganda Shilling"]
[null,"CLF","Unidad de Fomento"]
[null,"COU","Unidad de Valor Real"]
[null,"UYI","Uruguay Peso en Unidades Indexadas"]
[null,"USD","US Dollar"]
[null,"USN","US Dollar (Next day)"]
[null,"UZS","Uzbekistan Sum"]
[null,"VUV","Vatu"]
[null,"CHE","WIR Euro"]
[null,"CHW","WIR Franc"]
[null,"KRW","Won"]
[null,"YER","Yemeni Rial"]
[null,"JPY","Yen"]
[null,"CNY","Yuan Renminbi"]
[null,"ZMW","Zambian Kwacha"]
[null,"ZWL","Zimbabwe Dollar"]
[null,"PLN","Zloty"]