{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Form_C - MODELE","Tables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"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_C - MODELE","index":0,"n_rows":60,"n_cols":17,"rows_kept":60,"cut":false,"hidden":false,"merged":[[39,12,40,12],[39,14,40,14],[39,1,40,1],[39,2,40,2],[39,3,40,3],[39,4,40,4],[39,5,40,5],[39,8,40,8],[26,13,27,13],[26,14,27,14],[26,15,27,15],[26,16,27,16],[3,4,3,5],[4,4,4,5],[5,4,5,5],[10,9,11,11],[10,12,10,14],[11,12,11,14],[12,9,12,11],[12,12,12,14],[10,4,10,7],[11,4,11,7],[12,4,12,7],[21,9,21,13],[20,1,20,2],[62,1,62,16],[63,1,63,16],[51,1,51,4],[60,1,60,16],[61,1,61,16],[26,1,27,1],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,6,27,6],[26,8,27,8],[26,9,27,9],[26,10,27,10],[26,11,27,11],[26,12,27,12],[15,1,15,3],[17,1,17,3],[16,1,16,3],[2,4,2,7],[18,1,18,3],[10,1,11,3],[12,1,12,3],[15,4,15,7],[16,4,16,7],[17,4,17,7],[18,4,18,7],[22,9,22,13],[1,4,1,7],[15,9,15,11],[16,9,16,13],[19,9,19,13]]}
[]
[null,"Complété par :","Sociéte"]
[null,null,"Personne de contact"]
[null,null,"Téléphone"]
[null,null,"Adresse email",null,null,55]
[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,1,"Monnaie","",29]
[null,null,null,null,null,50]
[null,"No AVS",null,null,null,null,null,null,null,"Période fiscale, du  …",null,null,null,"au …"]
[null,"Nom et prénom",null,null,null,null,null,null,null,"Date d'arrivée en Suisse (résidence)",null,null,null,null,null,5]
[null,"Rue",null,null,null,null,null,null,null,"Date de début d'activité lucrative (pour le groupe)",null,null,null,null,null,7]
[null,"Localité",null,null,null,null,null,null,null,"Date de début d'activité lucrative pour la société en Suisse",null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,"Date de fin d'activité lucrative pour la société en Suisse",null,null,null,null,null,10]
[null,"CALCULS AUTOMATIQUES",null,null,null,null,null,null,null,"Date de fin d'activité lucrative (pour le groupe)",null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,"Date de départ de Suisse (résidence)",null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,"Destination (pays de résidence ou de travail)",null,null,null,null,null,12]
[]
[null,"Historique des participations et état à la fin de la période, au :",null,null,null,null,{"$f":"IF(ISBLANK($O$16),\"\",$O$16)","v":""},"(à déclarer pour mémoire dans l'état des titres de la déclaration d'impôt)"]
[null,2,13,39,27,25,16,35,14,24,45,28,15,40,41,42]
[null,"Désignation du plan de participations","Date d'octroi des participations","Pays de travail à la date d'octroi des participations","Nombre de participations octroyées","Date de vesting prévue dans le plan","Date d'échéance de l'éventuel délai de blocage","Eventuel prix d'exercice","Date d'échéance","Date effective de vesting des participations","Pays de travail à la date de vesting","Nombre de participations réalisées depuis l'octroi","Nombre de participations annulées depuis l'octroi","Jours travaillés en Suisse entre l'octroi et le vesting","Total des jours entre l'octroi et le vesting","PRORATA\n(en cas de réalisation)","Nombre de participations détenues à la fin de la période"]
[null,null,null,null,null,"(Pour info)",null,{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O$21<J29,IF(O$21-C29>0,O$21-C29,J29-C29),IF(J29-C29>0,J29-C29,\"\"))","v":""},{"$f":"IF(OR(O29=\"\",O29=0),\"\",N29/O29)","v":""},{"$f":"E29-L29-M29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O$21<J30,IF(O$21-C30>0,O$21-C30,J30-C30),IF(J30-C30>0,J30-C30,\"\"))","v":""},"",{"$f":"E30-L30-M30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de participations détenues à la fin de la période :",{"$f":"SUM(Q29:Q35)","v":0}]
[]
[null,"Calcul du revenu imposable pour les participations réalisées durant cette période (ex.: exercice d'options, vesting de restricted stock units, etc.)"]
[null,2,23,27,13,24,35,31,16,null,null,null,30,null,42]
["Tableau_2","Désignation du plan de participations","Date de réalisation du revenu","Nombre de participations réalisées",{"$f":"C27","v":"Date d'octroi des participations"},{"$f":"J27","v":"Date effective de vesting des participations"},"Eventuel prix d'exercice","Valeur de l'action lors de la réalisation","Date d'échéance de l'éventuel délai de blocage","Durée du délai de blocage","Escompte pour délai de blocage","Revenu total lors de la réalisation","Taux de change lors de la réalisation","Revenu total lors de la réalisation","PRORATA\n(voir calcul dans le 1er tableau)","Revenu imposable en Suisse","Revenu imposable à l'étranger, pour le taux"]
[null,null,null,null,null,null,{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},null,"(En années)","(%)",{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},null,"(CHF)",null,"(CHF)","(CHF)"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(I42),0,(I42-C42)/365)","v":0},{"$f":"1-POWER(1+0.06,-J42)","v":0},{"$f":"D42*(H42*(1-K42)-G42)","v":0},1,{"$f":"L42*M42","v":0},null,{"$f":"N42*O42","v":0},{"$f":"N42-P42","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(I43),0,(I43-C43)/365)","v":0},{"$f":"1-POWER(1+0.06,-J43)","v":0},{"$f":"D43*(H43*(1-K43)-G43)","v":0},1,{"$f":"L43*M43","v":0},null,{"$f":"N43*O43","v":0},{"$f":"N43-P43","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(I44),0,(I44-C44)/365)","v":0},{"$f":"1-POWER(1+0.06,-J44)","v":0},{"$f":"D44*(H44*(1-K44)-G44)","v":0},1,0,null,{"$f":"N44*O44","v":0},{"$f":"N44-P44","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"REVENU imposable lors de la réalisation, déclaré au chiffre 5 du certificat de salaire",{"$f":"SUM(N42:N45)","v":0},null,{"$f":"SUM(P42:P45)","v":0},{"$f":"SUM(Q42:Q45)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,46,45]
[null,null,null,null,null,null,null,null,null,null,null,null,"RESIDENCE*","TRAVAIL"]
[null,"Traitement du revenu imposable en Suisse selon le pays de résidence et de travail lors de la réalisation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"* Lors de la réalisation"]
[null,"Résident suisse (qui travaille en Suisse ou à l'étranger) :",null,null,null,"CS (si soumis à l'impôt à la source : barèmes usuels), à déclarer comme salaire dans la déclaration d'impôt"]
[]
[null,"Résident étranger"]
[null,"- travaille en Suisse :",null,null,null,"CS (imposition à la source ordinaire définitive)"]
[null,"- travaille à l'étranger (ou ne travaille plus) :",null,null,null,"attestation pour l'imposition à la source élargie + liste récapitulative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CS = certificat de salaire"]
[]
[]
["Observations","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,"Options de collaborateur imposables lors de l'exercice"]
[null,"EUR","Euro",null,"AI",null,"Expectatives sur actions de collaborateur"]
[null,"USD","US Dollar",null,"AR",null,"Participations improprement dites (espèces)"]
[null,"JPY","Yen",null,"BE",null,"Autres"]
[null,"AFN","Afghani",null,"BL"]
[null,"DZD","Algerian Dinar",null,"BS"]
[null,"ARS","Argentine Peso",null,"FR",null,"Tab_Pays_residence"]
[null,"AMD","Armenian Dram",null,"GE",null,"Pays de résidence"]
[null,"AWG","Aruban Florin",null,"GL",null,"Suisse"]
[null,"AUD","Australian Dollar",null,"GR",null,"Etranger"]
[null,"AZN","Azerbaijanian Manat",null,"JU"]
[null,"BSD","Bahamian Dollar",null,"LU"]
[null,"BHD","Bahraini Dinar",null,"NE",null,"Tab_Pays_travail"]
[null,"THB","Baht",null,"NW",null,"Pays de travail"]
[null,"PAB","Balboa",null,"OW",null,"Suisse"]
[null,"BBD","Barbados Dollar",null,"SG",null,"Etranger"]
[null,"BYR","Belarussian Ruble",null,"SH",null,"Ne travaille plus"]
[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"]