{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Frontespizio","Hp1 - EntroGIOISCR","Hp2 - SplafGIOISCR","Hp3 - EntroISCR ","Hp4 - PlafISCR ","FLAT TAX","Impostazioni"],"not_rendered":{"charts":4,"images":10,"macros":1,"external_links":0,"defined_names":6,"comments":5,"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":"Frontespizio","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Nei fogli che seguono"]
[null,null,null,null,null,"è possibile selezionare solo"]
[null,null,null,null,null,"le celle evidenziate dal colore "]
[null,null,null,null,null,"Azzurro "]

{"sheet":"Hp1 - EntroGIOISCR","index":1,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,8],[20,1,20,8],[3,2,3,8]]}
[]
[null,"Pianificazione Fiscale e Gestione del CashFlow"]
[]
[null,null,"Hp 1: Regime Forfettario SU - GIOVANE ISCRITTO - Reddito Professionale entro il minimale 17.069"]
[]
[]
[null,"FATTURATO",15000,null,"TAX",0.05,null,"TOTALE",{"$f":"C19+D19+E19+F19","v":2475.585576923077}]
[null,"IMPONIBILE",{"$f":"C7/1.04","v":14423.076923076922},null,"SOGGETTIVO",7.2499999999999995E-2,null,"PRESSIONE",{"$f":"K19/C7","v":0.16503903846153847}]
[null,"BASE CONTR",{"$f":"C8*0.78","v":11250},null,"INTEGRATIVO",0.04]
[null,"REDDITO ",{"$f":"C9-D19-F19","v":10390.375},null,null,null,null,"NETTO",{"$f":"C7-I7","v":12524.414423076923}]
[null,null,null,null,null,null,null,"NETTO MENSILE",{"$f":"I10/12","v":1043.701201923077}]
[null,null,"IMPOSTE DIRETTE","SOGGETTIVO","INTEGRATIVO","MATERNITA'"]
[null,"SALDO",{"$f":"C10*F7","v":519.51875000000007},{"$f":"C9*F8/2","v":407.8125},{"$f":"C8*0.04/2","v":288.46153846153845},{"$f":"44/2","v":22}]
[null,"ACCONTO",{"$f":"C13","v":519.51875000000007},{"$f":"D13","v":407.8125},{"$f":"E13","v":288.46153846153845},{"$f":"F13","v":22},null,"2023-06-30",{"$f":"K14*-1","v":-563},null,{"$f":"(I26+I27)/2+26.5","v":563}]
[null,null,null,null,null,null,null,"2023-09-30",{"$f":"K15*-1","v":-554},null,{"$f":"(I26+I27)/2+(F19-26.5)","v":554}]
[null,null,null,null,null,null,null,"2024-07-31",{"$f":"K17*-1","v":-779.27812500000005},"CONGUAGLIO",{"$f":"(D19+E19+F19)-(K14+K15)","v":319.54807692307691}]
[null,null,null,null,null,null,null,"2024-11-30",{"$f":"K18*-1","v":-259.75937500000003},null,{"$f":"C13+(C14/2)","v":779.27812500000005}]
[null,null,null,null,null,null,null,"2024-12-31",{"$f":"K16*-1","v":-319.54807692307691},null,{"$f":"C14/2","v":259.75937500000003}]
[null,"USCITE",{"$f":"SUM(C13:C18)","v":1039.0375000000001},{"$f":"SUM(D13:D18)","v":815.625},{"$f":"SUM(E13:E18)","v":576.92307692307691},{"$f":"SUM(F13:F18)","v":44},null,"TOTALE ",{"$f":"SUM(I14:I18)","v":-2475.5855769230766},null,{"$f":"SUM(K14:K18)","v":2475.585576923077}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF((I7=K19),\"QUADRA\",\"ERRORE!\")","v":"QUADRA"}]
[null,"Importi arrotondati all'unità di euro"]
[]
[]
[]
[null,null,null,null,null,null,null,"MINIMI GIOISCR"]
[null,null,null,null,null,null,null,"SOGGETTIVO",825]
[null,null,null,null,null,null,null,"INTEGRATIVO",248]

{"sheet":"Hp2 - SplafGIOISCR","index":2,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,3,8],[20,1,20,8],[29,7,29,15],[30,7,30,13]]}
[]
[null,"Pianificazione Fiscale e Gestione del CashFlow"]
[]
[null,"Hp 2: Regime Forfettario SU - GIOVANE ISCRITTO - Splafonamento Reddito Medio € 27.903"]
[]
[]
[null,"FATTURATO",37205,null,"TAX",0.05,null,"TOTALE",{"$f":"C19+D19+E19+F19","v":7902.3759134615393}]
[null,"IMPONIBILE",{"$f":"C7/1.04","v":35774.038461538461},null,"SOGGETTIVO",0.14499999999999999,null,"PRESSIONE",{"$f":"K19/C7","v":0.21240091152967447}]
[null,"BASE CONTR",{"$f":"C8*0.78","v":27903.75},null,"INTEGRATIVO",0.04]
[null,"REDDITO ",{"$f":"C9-D19-F19","v":23813.706249999999},null,null,null,null,"NETTO",{"$f":"C7-I7","v":29302.624086538461}]
[null,null,null,null,null,null,null,"NETTO MENSILE",{"$f":"I10/12","v":2441.8853405448717}]
[null,null,"IMPOSTE DIRETTE","SOGGETTIVO","INTEGRATIVO","MATERNITA'"]
[null,"SALDO",{"$f":"C10*F7","v":1190.6853125},{"$f":"C9*F8/2","v":2023.0218749999999},{"$f":"C8*0.04/2","v":715.48076923076928},{"$f":"44/2","v":22}]
[null,"ACCONTO",{"$f":"C13","v":1190.6853125},{"$f":"D13","v":2023.0218749999999},{"$f":"E13","v":715.48076923076928},{"$f":"F13","v":22},null,"2023-06-30",{"$f":"K14*-1","v":-563},null,{"$f":"(I26+I27)/2+26.5","v":563}]
[null,null,null,null,null,null,null,"2023-09-30",{"$f":"K15*-1","v":-554},null,{"$f":"(I26+I27)/2+(F19-26.5)","v":554}]
[null,null,null,null,null,null,null,"2024-07-31",{"$f":"K17*-1","v":-1786.0279687500001},"CONGUAGLIO",{"$f":"(D19+E19+F19)-(K14+K15)","v":4404.0052884615379}]
[null,null,null,null,null,null,null,"2024-11-30",{"$f":"K18*-1","v":-595.34265625},null,{"$f":"C13+(C14/2)","v":1786.0279687500001}]
[null,null,null,null,null,null,null,"2024-12-31",{"$f":"K16*-1","v":-4404.0052884615379},null,{"$f":"C14/2","v":595.34265625}]
[null,"USCITE",{"$f":"SUM(C13:C18)","v":2381.370625},{"$f":"SUM(D13:D18)","v":4046.0437499999998},{"$f":"SUM(E13:E18)","v":1430.9615384615386},{"$f":"SUM(F13:F18)","v":44},null,"TOTALE ",{"$f":"SUM(I14:I18)","v":-7902.3759134615375},null,{"$f":"SUM(K14:K18)","v":7902.3759134615384}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF((I7=K19),\"QUADRA\",\"ERRORE!\")","v":"QUADRA"}]
[null,"Importi arrotondati all'unità di euro"]
[]
[]
[]
[null,null,null,null,null,null,null,"MINIMI GIOISCR"]
[null,null,null,null,null,null,null,"SOGGETTIVO",825]
[null,null,null,null,null,null,null,"INTEGRATIVO",248]
[]
[]
[null,null,null,null,null,null,null,"si applica l’aliquota intera del 14,50% (e non quella del 7,25%) sull’intero reddito professionale dichiarato."]
[null,null,null,null,null,null,null,"https://www.inarcassa.it/site/home/contributi/i-benefici-per-i-giovani-iscritti.html"]

{"sheet":"Hp3 - EntroISCR ","index":3,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,3,8],[20,1,20,8]]}
[]
[null,"Pianificazione Fiscale e Gestione del CashFlow"]
[]
[null,"Hp 3: Regime Forfettario -  ISCRITTO - Reddito Professionale entro il minimale 17.069"]
[]
[]
[null,"FATTURATO",20000,null,"TAX",0.15,null,"TOTALE",{"$f":"C19+D19+E19+F19","v":6822.5307692307688}]
[null,"IMPONIBILE",{"$f":"C7/1.04","v":19230.76923076923},null,"SOGGETTIVO",0.14499999999999999,null,"PRESSIONE",{"$f":"K19/C7","v":0.35491500000000004}]
[null,"BASE CONTR",{"$f":"C8*0.78","v":15000},null,"INTEGRATIVO",0.04]
[null,"REDDITO ",{"$f":"C9-D19-F19","v":12781},null,null,null,null,"NETTO",{"$f":"C7-I7","v":13177.469230769231}]
[null,null,null,null,null,null,null,"NETTO MENSILE",{"$f":"I10/12","v":1098.1224358974359}]
[null,null,"IMPOSTE DIRETTE","SOGGETTIVO","INTEGRATIVO","MATERNITA'"]
[null,"SALDO",{"$f":"C10*F7","v":1917.1499999999999},{"$f":"C9*F8/2","v":1087.5},{"$f":"C8*0.04/2","v":384.61538461538464},{"$f":"44/2","v":22}]
[null,"ACCONTO",{"$f":"C13","v":1917.1499999999999},{"$f":"D13","v":1087.5},{"$f":"E13","v":384.61538461538464},{"$f":"F13","v":22},null,"2023-06-30",{"$f":"K14*-1","v":-1636.5},null,{"$f":"(    (I26+I27)/2)    +26.5","v":1636.5}]
[null,null,null,null,null,null,null,"2023-09-30",{"$f":"K15*-1","v":-1627.5},null,{"$f":"(I26+I27)/2+                (F19-26.5)","v":1627.5}]
[null,null,null,null,null,null,null,"2024-07-31",{"$f":"K17*-1","v":-2875.7249999999999},null,{"$f":"IF(            (D19+E19+F19)-(K14+K15)<0,                   0,                 (D19+E19+F19)-(K14+K15)                      )","v":0}]
[null,null,null,null,null,null,null,"2024-11-30",{"$f":"K18*-1","v":-958.57499999999993},null,{"$f":"C13+(C14/2)","v":2875.7249999999999}]
[null,null,null,null,null,null,null,"2024-12-31",{"$f":"K16*-1","v":0},null,{"$f":"C14/2","v":958.57499999999993}]
[null,"USCITE",{"$f":"SUM(C13:C18)","v":3834.2999999999997},{"$f":"SUM(D13:D18)","v":2175},{"$f":"SUM(E13:E18)","v":769.23076923076928},{"$f":"SUM(F13:F18)","v":44},null,"TOTALE ",{"$f":"SUM(I14:I18)","v":-7098.3},null,{"$f":"SUM(K14:K18)","v":7098.3}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF((I7=K19),\"QUADRA\",\"ERRORE!\")","v":"ERRORE!"}]
[null,"Importi arrotondati all'unità di euro"]
[]
[]
[]
[null,null,null,null,null,null,null,"MINIMI GIOISCR"]
[null,null,null,null,null,null,null,"SOGGETTIVO",2475]
[null,null,null,null,null,null,null,"INTEGRATIVO",745]

{"sheet":"Hp4 - PlafISCR ","index":4,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,3,8],[20,1,20,8]]}
[]
[null,"Pianificazione Fiscale e Gestione del CashFlow"]
[]
[null,"Hp 4: Regime Forfettario SU -  ISCRITTO - Splafonamento Reddito Medio € 27.903"]
[]
[]
[null,"FATTURATO",50000,null,"TAX",0.15,null,"TOTALE",{"$f":"C19+D19+E19+F19","v":17010.126923076921}]
[null,"IMPONIBILE",{"$f":"C7/1.04","v":48076.923076923078},null,"SOGGETTIVO",0.14499999999999999,null,"PRESSIONE",{"$f":"K19/C7","v":0.34020253846153842}]
[null,"BASE CONTR",{"$f":"C8*0.78","v":37500},null,"INTEGRATIVO",0.04]
[null,"REDDITO ",{"$f":"C9-D19-F19","v":32018.5},null,null,null,null,"NETTO",{"$f":"C7-I7","v":32989.873076923075}]
[null,null,null,null,null,null,null,"NETTO MENSILE",{"$f":"I10/12","v":2749.1560897435897}]
[null,null,"IMPOSTE DIRETTE","SOGGETTIVO","INTEGRATIVO","MATERNITA'"]
[null,"SALDO",{"$f":"C10*F7","v":4802.7749999999996},{"$f":"C9*F8/2","v":2718.75},{"$f":"C8*0.04/2","v":961.53846153846155},{"$f":"44/2","v":22}]
[null,"ACCONTO",{"$f":"C13","v":4802.7749999999996},{"$f":"D13","v":2718.75},{"$f":"E13","v":961.53846153846155},{"$f":"F13","v":22},null,"2023-06-30",{"$f":"K14*-1","v":-1636.5},null,{"$f":"(I26+I27)/2+26.5","v":1636.5}]
[null,null,null,null,null,null,null,"2023-09-30",{"$f":"K15*-1","v":-1627.5},null,{"$f":"(I26+I27)/2+(F19-26.5)","v":1627.5}]
[null,null,null,null,null,null,null,"2024-07-31",{"$f":"K17*-1","v":-7204.1624999999995},null,{"$f":"IF((D19+E19+F19)-(K14+K15)<0,0,(D19+E19+F19)-(K14+K15))","v":4140.5769230769229}]
[null,null,null,null,null,null,null,"2024-11-30",{"$f":"K18*-1","v":-2401.3874999999998},null,{"$f":"C13+(C14/2)","v":7204.1624999999995}]
[null,null,null,null,null,null,null,"2024-12-31",{"$f":"K16*-1","v":-4140.5769230769229},null,{"$f":"C14/2","v":2401.3874999999998}]
[null,"USCITE",{"$f":"SUM(C13:C18)","v":9605.5499999999993},{"$f":"SUM(D13:D18)","v":5437.5},{"$f":"SUM(E13:E18)","v":1923.0769230769231},{"$f":"SUM(F13:F18)","v":44},null,"TOTALE ",{"$f":"SUM(I14:I18)","v":-17010.126923076921},null,{"$f":"SUM(K14:K18)","v":17010.126923076921}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF((I7=K19),\"QUADRA\",\"ERRORE!\")","v":"QUADRA"}]
[null,"Importi arrotondati all'unità di euro"]
[]
[]
[]
[null,null,null,null,null,null,null,"MINIMI GIOISCR"]
[null,null,null,null,null,null,null,"SOGGETTIVO",2475]
[null,null,null,null,null,null,null,"INTEGRATIVO",745]

{"sheet":"FLAT TAX","index":5,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,1,3,6],[26,1,26,3],[34,1,34,3],[4,1,4,6]]}
[]
[]
[]
[null,"FLAT TAX INCREMENTALE"]
[]
[null,"Anno","Reddito",null,null,null,"Differenza"]
[null,2023,105000,null,null,null,{"$f":"IF(     (C7-MAX(C8:C10))>0,      (C7-MAX(C8:C10)),          \"NON APPLICABILE\")","v":40000}]
[null,2022,63000,null,null,null,"Riduzione"]
[null,2021,65000,null,null,null,{"$f":"MAX(C8:C10)*0.05","v":3250}]
[null,2020,55000]
[]
[null,null,"Base imponibile",null,null,"Base imponibile ","TAX"]
[null,"Flat Tax 15%",{"$f":"G7","v":40000},"-",{"$f":"G9","v":3250},{"$f":"G7-G9","v":36750},{"$f":"F13*0.15","v":5512.5}]
[null,"IRPEF",{"$f":"C7","v":105000},"-",{"$f":"F13","v":36750},{"$f":"C7-F13","v":68250},{"$f":"E32","v":22247.5}]
[null,"TAX",null,null,null,null,{"$f":"G13+G14","v":27760}]
[]
[null,null,"Base imponibile",null,null,"Base imponibile ","IRPEF"]
[null,"IRPEF",{"$f":"C7","v":105000},null,null,{"$f":"C18","v":105000},{"$f":"E40","v":38050}]
[]
[]
[null,"Risparmio di Imposta",null,null,null,null,{"$f":"G18-G15","v":10290}]
[]
[]
[]
[]
[]
[null,"Reddito imponibile IRPEF+FT",null,null,{"$f":"F14","v":68250},"%"]
[null,null,15000,15000,{"$f":"IF(E27>$C28,$C28*$F28,E27*$F28)","v":3450},0.23]
[null,null,28000,28000,{"$f":"IF(E27>$C29,                        ($C29-$C28)*$F29,               IF(E27<$C28,0,         (E27-$C28)*$F29)      )","v":3250},0.25]
[null,null,50000,50000,{"$f":"IF(E27>$C30,           ($C30-$C29)*$F30,         IF(E27<$C29,0,   (E27-$C29)*$F30))","v":7699.9999999999991},0.35]
[null,null,null,null,{"$f":"IF(E27>$C30,                   (E27-$C30)*$F31,0)","v":7847.5},0.43]
[null,null,null,null,{"$f":"SUM(E28:E31)","v":22247.5}]
[]
[]
[null,"Reddito imponibile IRPEF",null,null,{"$f":"C18","v":105000},"%"]
[null,null,15000,15000,{"$f":"IF(E35>$C36,$C36*$F36,E35*$F36)","v":3450},0.23]
[null,null,28000,28000,{"$f":"IF(E35>$C37,                        ($C37-$C36)*$F37,               IF(E35<$C36,0,         (E35-$C36)*$F37)      )","v":3250},0.25]
[null,null,50000,50000,{"$f":"IF(E35>$C38,           ($C38-$C37)*$F38,         IF(E35<$C37,0,   (E35-$C37)*$F38))","v":7699.9999999999991},0.35]
[null,null,null,null,{"$f":"IF(E35>$C38,                   (E35-$C38)*$F39,0)","v":23650},0.43]
[null,null,null,null,{"$f":"SUM(E36:E39)","v":38050}]

{"sheet":"Impostazioni","index":6,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Allegato:","Percorso dell'ultimo file"]
["HP1:","C:\\Users\\massimo.crosara\\Desktop\\Hp1 - EntroGIOISCR-2023-feb-20 9-13-15.pdf"]
["HP2:"]
["HP3:"]
["HP4:"]
["FLAT TAX:"]