{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["List1","Report","255.35.85","Designations"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":0,"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":"List1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Report","index":1,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[64,6,64,9],[63,6,63,9],[56,0,56,9],[58,0,58,1],[58,4,58,9],[61,0,61,9],[63,0,63,1],[64,0,64,1],[63,4,63,5],[64,4,64,5],[63,2,63,3],[64,2,64,3],[51,0,51,2],[51,3,51,5],[51,6,51,9],[53,0,53,2],[53,3,53,5],[53,6,53,9],[52,0,52,2],[52,3,52,5],[52,6,52,9],[49,0,49,9],[43,4,43,5],[43,6,43,7],[43,8,43,9],[44,4,44,5],[44,6,44,7],[44,8,44,9],[45,4,45,5],[45,6,45,7],[45,8,45,9],[47,6,47,7],[47,8,47,9],[41,0,41,1],[41,4,41,5],[41,6,41,7],[41,8,41,9],[42,0,42,1],[42,4,42,5],[42,6,42,7],[42,8,42,9],[39,0,39,1],[39,4,39,5],[39,6,39,7],[39,8,39,9],[40,0,40,1],[40,4,40,5],[40,6,40,7],[40,8,40,9],[33,4,33,6],[33,7,33,9],[36,0,36,9],[38,0,38,3],[38,4,38,9],[25,4,25,5],[25,6,25,9],[30,6,30,7],[30,8,30,9],[27,4,27,5],[26,4,26,5],[27,6,27,9],[26,6,26,9],[24,4,24,5],[24,6,24,9],[0,0,0,9],[3,0,3,9],[4,6,5,8],[4,9,5,9],[6,8,7,8],[6,9,7,9],[9,8,9,9],[14,0,14,9],[20,0,20,3],[20,4,20,9],[23,4,23,9]]}
["Vyhodnocení  návrhu investice"]
[]
[]
["Základní údaje:"]
[null,null,null,null,null,null,"identifikační číslo studie:",null,null,1]
["název:","Byt 3+kk v ulici Berkova",null,null,null,"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
["lokalita:","Brno - Královo pole, 612 00"]
[]
["adresa:","Berkova"]
[null,"Brno - Královo pole, 612 00",null,null,null,null,null,"datum vytvoření reportu:",{"$f":"TODAY()","v":"2019-01-06"}]
[]
["objednatel studie:","Jan Kovalčuk, Irkutská 315/2, Brno - Starý Lískovec, 625 00",null,null,null,null,null,"typ investora:","Fyzická osoba"]
[]
[]
["Technické charakteristiky nemovitosti:"]
[]
[null,"druh budovy:","Novostavba/developerský projekt",null,"užitná plocha:",87]
[null,"dispozice:","3+kk",null,"pronajímatelná plocha:",87]
[]
[]
["Investiční náklady:",null,null,null,"Způsob financování:"]
[]
[null,"cena nemovitosti:",null,null,"hypotéka:","ne",null,null,"další úvěr:","ne"]
[null,"provize RK:",null,null,{"$f":"IF(F23=\"NE\",IF(J23=\"NE\",\"Investice je plně hrazena z vlastních zdrojů\",\"\"),\"\")","v":"Investice je plně hrazena z vlastních zdrojů"}]
[null,"daň z nabytí nemovitosti:",null,null,{"$f":"IF(F23=\"NE\",IF(J23=\"ANO\",\"\",\"Celkem hrazeno z vlastních zdrojů:\"),\"parametry hypotéky\")","v":"Celkem hrazeno z vlastních zdrojů:"},null,{"$f":"IF(J23=\"NE\",IF(F23=\"ANO\",\"\",C34),\"parametry úvěru\")","v":0}]
[null,"právní služby:",null,null,"výše hypotéky:",null,"výše úvěru:"]
[null,"úschova:"]
[null,"poplatky KN:"]
[null,"další poplatky:",null,null,"doba splácení (roky):",null,null,null,"doba splácen (roky):"]
[null,"Ocenění nemovitosti:",null,null,"úroková míra (p.a.):",null,null,null,"úroková míra (p.a.):"]
[null,"poplatek za vyřízení úvěru:",null,null,"měsíční splátka:",{"$f":"G45","v":0},"měsíční splátka:",null,{"$f":"G46","v":0}]
[null,"rekonstrukce (stavební náklady):"]
[]
[null,"celkem investiční náklady:",{"$f":"SUM(C23:C32)","v":0},null,"vynaložené vlastní zdroje:",null,null,{"$f":"IF(J23=\"ne\",C34-E27,C34-G27-E27)","v":0}]
[]
[]
["Výpočet cashflow:"]
[]
["příjmy:",null,null,null,"výdaje:"]
[null,null,"měsíční","roční",null,null,"měsíční",null,"roční"]
["přijaté nájemné - hrubé:",null,null,{"$f":"C41*12","v":0},"pojištění nemovitosti:",null,null,null,{"$f":"G41*12","v":0}]
["ztráta vlivem neobsazenosti:",null,null,{"$f":"C42*12","v":0},"příspěvek na správu domu a pozemku:",null,null,null,0]
["přijaté nájemné - po korekci:",null,null,{"$f":"C43*12","v":0},"daň z příjmu z pronájmu:",null,null,null,0]
[null,null,null,null,"daň z vlastnictví nemovitosti:",null,null,null,0]
[null,null,null,null,"splátka hypotéky:",null,null,null,0]
[null,null,null,null,"splátka úvěru:",null,null,null,0]
[]
[null,"příjmy celkem:",{"$f":"C43","v":0},{"$f":"D43","v":0},null,"výdaje celkem:",{"$f":"SUM(G41:H46)","v":0},null,{"$f":"SUM(I41:J46)","v":0}]
[]
["výsledné cashflow:"]
[]
["před splacením hypotéky a úvěru",null,null,"po splacení úvěru",null,null,"po splacení úvěru a hypotéky"]
[]
[{"$f":"C48-G48","v":0},null,null,{"$f":"C48-SUM(G41:H45)","v":0},null,null,{"$f":"C48-SUM(G41:G44)","v":0}]
[]
[]
["Vyhodnocení investice:"]
[]
["délka doby zkoumání investice (v letech):"]
[null,"diskontní míra:"]
[]
["Výsledné ukazatele výnosnosti:"]
[]
["čistá současná hodnota NPV",null,"vnitřní výnosové procento IRR",null,"doba návratnosti PP (v letech)",null," diskontovaná doba návratnosti DPP (v letech)"]

{"sheet":"255.35.85","index":2,"n_rows":86,"n_cols":20,"rows_kept":86,"cut":false,"hidden":true,"merged":[]}
["NameI","Byt v Holicích"]
["IDI","255.35.85"]
[]
["StreetI","Holubova 735"]
["CityI","Jekatěrinburg, 110 09"]
["TypeBI","Zděná z cihel"]
["SizeBI","3+1"]
["AreaUI",89]
["AreaRI",78]
[]
["NameO","IP Invest, a.s."]
["PersonCB","Právnická osoba"]
["IDO",963368596]
["StreetO","Nigraskutská, 1125"]
["CityO","Jakutsk, 125 65"]
[]
["LngtI",252]
["DskntI",7.0000000000000007E-2]
[]
["PriceP",3500000]
["ProviP",500000]
["ProviP2"]
["TaxP",140000]
["LawP",3000]
["DeposP",4000]
["KNFP",500]
["OthrFP",1000]
["EstimP",4000]
["RemontP",250000]
["IntExpAP",{"$f":"SUM(B20:B28)","v":4152500}]
[]
["InsurP",1500]
["InsurP_Y",{"$f":"B32*12","v":18000}]
["FondP",500]
["FondP_Y",{"$f":"B34*12","v":6000}]
["TaxIP",{"$f":"IF(B12=1,B55*0.15,B55*0.19)","v":3790.5}]
["TaxIP_Y",{"$f":"B36*12","v":45486}]
["TaxOP",{"$f":"B41*B42*B8","v":89}]
["TaxOP_Y",{"$f":"B38*12","v":1068}]
[]
["KPtype",1]
["KPLoc",1]
[]
[]
[]
[]
[null,null,null,null,null,null,"PriceP_r.Caption","=","Worksheets(ID).Range(\"B20\")",null,null,null,{"$f":"CONCATENATE(G47,H47,\"format\",\"(\",G47,\",\",\"'currency'\",\")\")","v":"PriceP_r.Caption=format(PriceP_r.Caption,'currency')"},null,null,null,null,null,null,"PriceP_r.Caption=format(PriceP_r.Caption,\"currency\")"]
["OutsP",{"$f":"IF(B64=1,B32+B34+B36+B38+B71+B74,IF(B59=1,B32+B34+B36+B38+B71,B32+B34+B36+B38))","v":11020.5},null,null,null,null,"ProviP_r.Caption","=","Worksheets(ID).Range(\"B21\")",null,null,null,{"$f":"CONCATENATE(G48,H48,\"format\",\"(\",G48,\",\",\"'currency'\",\")\")","v":"ProviP_r.Caption=format(ProviP_r.Caption,'currency')"},null,null,null,null,null,null,"ProviP_r.Caption=format(ProviP_r.Caption,\"currency\")"]
["OutsP_Y",{"$f":"B48*12","v":132246},null,null,null,null,"TaxP_r.Caption","=","Worksheets(ID).Range(\"B23\")",null,null,null,"TaxP_r.Caption=format(TaxP_r.Caption,'currency')",null,null,null,null,null,null,"TaxP_r.Caption=format(TaxP_r.Caption,\"currency\")"]
["InsGross",21000,null,null,null,null,"LawP_r.Caption","=","Worksheets(ID).Range(\"B24\")",null,null,null,"LawP_r.Caption=format(LawP_r.Caption,'currency')",null,null,null,null,null,null,"LawP_r.Caption=format(LawP_r.Caption,\"currency\")"]
["InsGross_Y",{"$f":"B50*12","v":252000},null,null,null,null,"DeposP_r.Caption","=","Worksheets(ID).Range(\"B25\")",null,null,null,"DeposP_r.Caption=format(DeposP_r.Caption,'currency')",null,null,null,null,null,null,"DeposP_r.Caption=format(DeposP_r.Caption,\"currency\")"]
["LossBV",{"$f":"B50*B54","v":1050},null,null,null,null,"KNFP_r.Caption","=","Worksheets(ID).Range(\"B26\")",null,null,null,"KNFP_r.Caption=format(KNFP_r.Caption,'currency')",null,null,null,null,null,null,"KNFP_r.Caption=format(KNFP_r.Caption,\"currency\")"]
["LossBV_Y",{"$f":"B52*12","v":12600},null,null,null,null,"OthrFP_r.Caption","=","Worksheets(ID).Range(\"B27\")",null,null,null,"OthrFP_r.Caption=format(OthrFP_r.Caption,'currency')",null,null,null,null,null,null,"OthrFP_r.Caption=format(OthrFP_r.Caption,\"currency\")"]
["VacaP",0.05,null,null,null,null,"EstimP_r.Caption","=","Worksheets(ID).Range(\"B28\")",null,null,null,"EstimP_r.Caption=format(EstimP_r.Caption,'currency')",null,null,null,null,null,null,"EstimP_r.Caption=format(EstimP_r.Caption,\"currency\")"]
["InsNet",{"$f":"B50-B52","v":19950},null,null,null,null,"RemontP_r.Caption","=","Worksheets(ID).Range(\"B29\")",null,null,null,"RemontP_r.Caption=format(RemontP_r.Caption,'currency')",null,null,null,null,null,null,"RemontP_r.Caption=format(RemontP_r.Caption,\"currency\")"]
["InsNet_Y",{"$f":"B55*12","v":239400},null,null,null,null,"IntExpAP_r.Caption","=","Worksheets(ID).Range(\"B30\")",null,null,null,"IntExpAP_r.Caption=format(IntExpAP_r.Caption,'currency')",null,null,null,null,null,null,"IntExpAP_r.Caption=format(IntExpAP_r.Caption,\"currency\")"]
[]
["FinComP",0,null,null,null,null,"InsurP_r.Caption","=","Worksheets(ID).Range(\"B32\")",null,null,null,"InsurP_r.Caption=format(InsurP_r.Caption,'currency')",null,null,null,null,null,null,"InsurP_r.Caption=format(InsurP_r.Caption,\"currency\")"]
["MrtgON",1,null,null,null,null,"InsurP_Y_r.Caption","=","Worksheets(ID).Range(\"B33\")",null,null,null,"InsurP_Y_r.Caption=format(InsurP_Y_r.Caption,'currency')",null,null,null,null,null,null,"InsurP_Y_r.Caption=format(InsurP_Y_r.Caption,\"currency\")"]
["MrtgFP",525000,null,null,null,null,"FondP_r.Caption","=","Worksheets(ID).Range(\"B34\")",null,null,null,"FondP_r.Caption=format(FondP_r.Caption,'currency')",null,null,null,null,null,null,"FondP_r.Caption=format(FondP_r.Caption,\"currency\")"]
["MrtgFP2",{"$f":"B60/B20","v":0.15},null,null,null,null,"FondP_Y_r.Caption","=","Worksheets(ID).Range(\"B35\")",null,null,null,"FondP_Y_r.Caption=format(FondP_Y_r.Caption,'currency')",null,null,null,null,null,null,"FondP_Y_r.Caption=format(FondP_Y_r.Caption,\"currency\")"]
["MrtgLP",10,null,null,null,null,"TaxIP_r.Caption","=","Worksheets(ID).Range(\"B36\")",null,null,null,"TaxIP_r.Caption=format(TaxIP_r.Caption,'currency')",null,null,null,null,null,null,"TaxIP_r.Caption=format(TaxIP_r.Caption,\"currency\")"]
["MrtgIP",3.2899999999999999E-2,null,null,null,null,"TaxIP_Y_r.Caption","=","Worksheets(ID).Range(\"B37\")",null,null,null,"TaxIP_Y_r.Caption=format(TaxIP_Y_r.Caption,'currency')",null,null,null,null,null,null,"TaxIP_Y_r.Caption=format(TaxIP_Y_r.Caption,\"currency\")"]
["LoanON",0,null,null,null,null,"TaxOP_r.Caption","=","Worksheets(ID).Range(\"B38\")",null,null,null,"TaxOP_r.Caption=format(TaxOP_r.Caption,'currency')",null,null,null,null,null,null,"TaxOP_r.Caption=format(TaxOP_r.Caption,\"currency\")"]
["LoanFP",1000000,null,null,null,null,"TaxOP_Y_r.Caption","=","Worksheets(ID).Range(\"B39\")",null,null,null,"TaxOP_Y_r.Caption=format(TaxOP_Y_r.Caption,'currency')",null,null,null,null,null,null,"TaxOP_Y_r.Caption=format(TaxOP_Y_r.Caption,\"currency\")"]
["LoanLP",15,null,null,null,null,"MrtgP_r.Caption","=","Worksheets(ID).Range(\"B71\")",null,null,null,"MrtgP_r.Caption=format(MrtgP_r.Caption,'currency')",null,null,null,null,null,null,"MrtgP_r.Caption=format(MrtgP_r.Caption,\"currency\")"]
["LoanIP",4.5899999999999996E-2,null,null,null,null,"MrtgP_Y_r.Caption","=","Worksheets(ID).Range(\"B72\")",null,null,null,"MrtgP_Y_r.Caption=format(MrtgP_Y_r.Caption,'currency')",null,null,null,null,null,null,"MrtgP_Y_r.Caption=format(MrtgP_Y_r.Caption,\"currency\")"]
["OwnCapP",{"$f":"B30-B60","v":3627500},null,null,null,null,"LoanP_r.Caption","=","Worksheets(ID).Range(\"B74\")",null,null,null,"LoanP_r.Caption=format(LoanP_r.Caption,'currency')",null,null,null,null,null,null,"LoanP_r.Caption=format(LoanP_r.Caption,\"currency\")"]
["LoanFP2",{"$f":"B65/(B30-B60)","v":0.27567195037904896},null,null,null,null,"LoanP_Y_r.Caption","=","Worksheets(ID).Range(\"B75\")",null,null,null,"LoanP_Y_r.Caption=format(LoanP_Y_r.Caption,'currency')",null,null,null,null,null,null,"LoanP_Y_r.Caption=format(LoanP_Y_r.Caption,\"currency\")"]
[]
["AnuMrtgFP",{"$f":"ROUNDUP(((B63/12)*(POWER(1+(B63/12),(B62*12))))/(POWER(1+(B63/12),(B62*12))-1)*B60,0)","v":5141},null,null,null,null,"InsGross_r.Caption","=","Worksheets(ID).Range(\"B50\")",null,null,null,"InsGross_r.Caption=format(InsGross_r.Caption,'currency')",null,null,null,null,null,null,"InsGross_r.Caption=format(InsGross_r.Caption,\"currency\")"]
["AnuMrtgFP_Y",{"$f":"B71*12","v":61692},null,null,null,null,"InsGross_Y_r.Caption","=","Worksheets(ID).Range(\"B51\")",null,null,null,"InsGross_Y_r.Caption=format(InsGross_Y_r.Caption,'currency')",null,null,null,null,null,null,"InsGross_Y_r.Caption=format(InsGross_Y_r.Caption,\"currency\")"]
[null,null,null,null,null,null,"LossBV_r.Caption","=","Worksheets(ID).Range(\"B52\")",null,null,null,"LossBV_r.Caption=format(LossBV_r.Caption,'currency')",null,null,null,null,null,null,"LossBV_r.Caption=format(LossBV_r.Caption,\"currency\")"]
["AnuLoanFP",{"$f":"ROUNDUP(((B67/12)*(POWER(1+(B67/12),(B66*12))))/(POWER(1+(B67/12),(B66*12))-1)*B65,0)","v":7697},null,null,null,null,"LossBV_Y_r.Caption","=","Worksheets(ID).Range(\"B53\")",null,null,null,"LossBV_Y_r.Caption=format(LossBV_Y_r.Caption,'currency')",null,null,null,null,null,null,"LossBV_Y_r.Caption=format(LossBV_Y_r.Caption,\"currency\")"]
["AnuLoanFP_Y",{"$f":"B74*12","v":92364},null,null,null,null,"InsNet_r.Caption","=","Worksheets(ID).Range(\"B55\")",null,null,null,"InsNet_r.Caption=format(InsNet_r.Caption,'currency')",null,null,null,null,null,null,"InsNet_r.Caption=format(InsNet_r.Caption,\"currency\")"]
[null,null,null,null,null,null,"InsNet_Y_r.Caption","=","Worksheets(ID).Range(\"B56\")",null,null,null,"InsNet_Y_r.Caption=format(InsNet_Y_r.Caption,'currency')",null,null,null,null,null,null,"InsNet_Y_r.Caption=format(InsNet_Y_r.Caption,\"currency\")"]
[]
[null,null,null,null,null,null,"MrtgFP_r.Caption","=","Worksheets(ID).Range(\"B60\")",null,null,null,"MrtgFP_r.Caption=format(MrtgFP_r.Caption,'currency')",null,null,null,null,null,null,"MrtgFP_r.Caption=format(MrtgFP_r.Caption,\"currency\")"]
[null,null,null,null,null,null,"MrtgLP_r.Caption","=","Worksheets(ID).Range(\"B62\")"]
[null,null,null,null,null,null,"MrtgIP_r.Caption","=","Worksheets(ID).Range(\"B63\")","*",100]
[]
[null,null,null,null,null,null,"LoanFP_r.Caption","=","Worksheets(ID).Range(\"B65\")",null,null,null,"LoanFP_r.Caption=format(LoanFP_r.Caption,'currency')",null,null,null,null,null,null,"LoanFP_r.Caption=format(LoanFP_r.Caption,\"currency\")"]
[null,null,null,null,null,null,"LoanLP_r.Caption","=","Worksheets(ID).Range(\"B66\")"]
[null,null,null,null,null,null,"LoanIP_r.Caption","=","Worksheets(ID).Range(\"B67\")","*",100]
[]
[null,null,null,null,null,null,"OwnCapP_r.Caption","=","Worksheets(ID).Range(\"B68\")",null,null,null,"OwnCapP_r.Caption=format(OwnCapP_r.Caption,'currency')",null,null,null,null,null,null,"OwnCapP_r.Caption=format(OwnCapP_r.Caption,\"currency\")"]

{"sheet":"Designations","index":3,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":true,"merged":[[65,0,65,10],[49,1,49,10],[10,0,10,10],[1,0,1,10],[40,0,40,10],[28,0,28,10],[22,0,22,10],[5,0,5,10]]}
["Tier 1","Tier 2","item","basic designation (value)","item type","label","format","units","method","backendsheet1","formula"]
["MainMenu"]
[null,null,"Seznam investičních studií","ListMainMenu","commandbutton","-","-","-","click","no","-"]
[null,null,"Založit novou investiční studii","CreateMainMenu","commandbutton","-","-","-","click","no","-"]
[null,null,"Ukončit program","CancelMainMenu","commandbutton","-","-","-","click","no","-"]
["BasicInfo"]
[null,null,"Název investice","NameI","textbox",{"$f":"CONCATENATE(D7,\"_t\")","v":"NameI_t"},"text","-","user input",1,"-"]
[null,null,"Identifikační číslo investice","IDI","textbox",{"$f":"CONCATENATE(D8,\"_t\")","v":"IDI_t"},"number","-","user input",2,"-"]
[null,null,"Zrušit","CancelBasicInfo","commandbutton","-","-","-","click","no","-"]
[null,null,"Založit novou studii","CreateBasicInfo","commandbutton","-","-","-","click","no","-"]
["BasicInfo2"]
[null,null,"Adresa investice","StreetI","textbox","StreetI_t","text","-","user input",4,"-"]
[null,null,"město investice","CityI","textbox","CityI_t","text","-","user input",5,"-"]
[null,null,"druh budovy","TypeBI","textbox","TypeBI_t","text","-","user input",6,"-"]
[null,null,"velikost (b.j.)","SizeBI","textbox","SizeBI_t","text","-","user input",7,"-"]
[null,null,"užitna plocha","AreaUI","textbox","AreaUI_t","number","sqrm","user input",8,"-"]
[null,null,"pronajímatelná plocha","AreaRI","textbox","AreaRI_t","number","sqrm","user input",9,"-"]
[null,null,"Název (jméno) objednatele","NameO","textbox",{"$f":"CONCATENATE(D18,\"_t\")","v":"NameO_t"},"text","-","user input",11,"-"]
[null,null,"Objednatel (FO/PO)","PersonCB","combobox","PersonCB_t","text","-","combobox",12,"-"]
["PriceP",null,"IČO objednatele","IDO","textbox","IDO_t","number","-","user input",13,"-"]
["ProviP",null,"Adresa objednatele","StreetO","textbox","StreetO_t","text","-","user input",14,"-"]
["ProviP2",null,"město objednatele","CityO","textbox","CityO_t","text","-","user input",15,"-"]
["TaxP"]
["LawP",null,"délka posuzovaného období v","UnitsLI","combobox",{"$f":"CONCATENATE(D24,\"_t\")","v":"UnitsLI_t"},"text","-","combobox","no","-"]
["DeposP",null,"délka doby zkoumání investice","LngtI","textbox",{"$f":"CONCATENATE(D25,\"_t\")","v":"LngtI_t"},"number","years","user input",17,"-"]
["KNFP",null,"roční diskontní míra","DskntI","textbox",{"$f":"CONCATENATE(D26,\"_t\")","v":"DskntI_t"},"number","percent","user input",18,"-"]
["OthrFP",null,"Další","NextInvProp","commandbutton","-","-","-","click","no","-"]
["EstimP",null,"Zpět","BackInvProp","commandbutton","-","-","-","click","no","-"]
["RemontP"]
["IntExpAP",{"$f":"SUM(B20:B29)","v":0},"cena nemovitosti","PriceP","textbox",{"$f":"CONCATENATE(D30,\"_t\")","v":"PriceP_t"},"number","currency","user input",20,"-"]
[null,null,"provize RK - %","ProviP","textbox",{"$f":"CONCATENATE(D31,\"_t\")","v":"ProviP_t"},"number","percent","user input",21,"-"]
["InsurP",null,"provize RK - Kč","ProviP2","label","-","number","currency","computed",22,"=PriceP*(ProviP/100)"]
["InsurP_Y",null,"Daň z nabytí nemovitosti","TaxP","label","TaxP_t","number","currency","computed",23,"=PriceP*0.04"]
["FondP",null,"právní služby","LawP","textbox","LawP_t","number","currency","user input",24,"-"]
["FondP_Y",null,"úschova","DeposP","textbox","DeposP_t","number","currency","user input",25,"-"]
["TaxIP",null,"poplatky KN","KNFP","textbox","KNFP_t","number","currency","user input",26,"-"]
["TaxIP_Y",null,"další poplatky","OthrFP","textbox","OthrFP_t","number","currency","user input",27,"-"]
["TaxOP",null,"ocenění nemovitosti","EstimP","textbox","EstimP_t","number","currency","user input",28,"-"]
["TaxOP_Y",null,"rekonstrukce před zahájením pronajímání","RemontP","textbox","RemontP_t","number","currency","user input",29,"-"]
[null,null,"investiční náklady celkem","IntExpAP","label","IntExpAP_t","number","currency","computed",30,"=PriceP+PriceP*(ProviP/100)+PriceP*0.04+TaxP+LawP+DeposP+KNFP+OthrP+EstimP+RemontP"]
["KPtype"]
["KPLoc",null,"pojištění nemovitosti","InsurP","textbox",{"$f":"CONCATENATE(D42,\"_t\")","v":"InsurP_t"},"number","currency","user input",32,"-"]
[null,null,"pojištění nemovitosti - roční","InsurP_Y","label","-","number","currency","computed",33,"=InsurP*12"]
[null,null,"zálohy na dl. A kv. Opravy","FondP","textbox",{"$f":"CONCATENATE(D44,\"_t\")","v":"FondP_t"},"number","currency","user input",34,"-"]
[null,null,"zálohy na dl. A kv. Opravy - roční","FondP_Y","label","-","number","currency","computed",35,"=FondP*12"]
[null,null,"daň z příjmu","TaxIP","label",{"$f":"CONCATENATE(D46,\"_t\")","v":"TaxIP_t"},"number","currency","computed",36,"=InsNet*0.19 x InsNet*0.15"]
[null,null,"daň z příjmu - roční","TaxIP_Y","label","-","number","currency","computed",37,"=TaxIP*12"]
["OutsP",null,"daň z vlastnictví nemovitosti","TaxOP","label",{"$f":"CONCATENATE(D48,\"_t\")","v":"TaxOP_t"},"number","currency","computed",38,"=TaxOPK.KPtype*TaxOPK.KPloc*IntExp.PriceP"]
["OutsP_Y",null,"daň z vlastnictví nemovitosti - roční","TaxOP_Y","label","-","number","currency","computed",39,"=TaxOP*12"]
["InsGross","TaxOPK"]
["InsGross_Y",null,"Koeficient pro nemovitost","KPtype","textbox",{"$f":"CONCATENATE(D51,\"_t\")","v":"KPtype_t"},"number","decimal","user input",41,"-"]
["LossBV",null,"Koeficient pro lokalitu","KPloc","textbox",{"$f":"CONCATENATE(D52,\"_t\")","v":"KPloc_t"},"number","decimal","user input",42,"-"]
["LossBV_Y",null,"splátka hypotéky","MrtgP","label",{"$f":"CONCATENATE(D53,\"_t\")","v":"MrtgP_t"},"number","currency","computed",44]
["VacaP",null,"splátka hypotéky - roční","MrtgP_Y","label","-","number","currency","computed",45,"=MrtgP*12"]
["InsNet",null,"splátka dalšího úvěru","LoanP","label",{"$f":"CONCATENATE(D55,\"_t\")","v":"LoanP_t"},"number","currency","computed",46]
["InsNet_Y",null,"splátka dalšího úvěru - roční","LoanP_Y","label","-","number","currency","computed",47,"=LoanP*12"]
[null,null,"pravidelné náklady celkem","OutsP","label",{"$f":"CONCATENATE(D57,\"_t\")","v":"OutsP_t"},"number","currency","computed",48]
[null,null,"pravidelné náklady celkem - roční","OutsP_Y","label","-","number","currency","computed",49,"=OutsP*12"]
[null,null,"přijaté nájemné - hrubé","InsGross","textbox",{"$f":"CONCATENATE(D59,\"_t\")","v":"InsGross_t"},"number","currency","user input",50,"-"]
[null,null,"přijaté nájemné - hrubé - roční","InsGross_Y","label","-","number","currency","computed",51,"=InsGross*12"]
[null,null,"ztráta vlivem neobsazenosti","LossBV","label",{"$f":"CONCATENATE(D61,\"_t\")","v":"LossBV_t"},"number","currency","computed",52]
[null,null,"ztráta vlivem neobsazenosti - roční","LossBV_Y","label","-","number","currency","computed",53,"=LossBV*12"]
[null,null,"procentní sazba neobsazenosti","VacaP","textbox",{"$f":"CONCATENATE(D63,\"_t\")","v":"VacaP_t"},"number","percent","user input",54,"-"]
[null,null,"přijaté nájemné - po korekci","InsNet","label",{"$f":"CONCATENATE(D64,\"_t\")","v":"InsNet_t"},"number","currency","computed",55,"=InsGross-LossBV"]
[null,null,"přijaté nájemné - po korekci - roční","InsNet_Y","label","-","number","currency","computed",56,"=InsNet*12"]
["FinanceP"]
[null,null,"zvolte způsob financování nemovitoti","FinComP","combobox",{"$f":"CONCATENATE(D67,\"_t\")","v":"FinComP_t"},"text","-","user input",58,"-"]
[null,null,"Hypoteční úvěr","MrtgFrame","frame","-","-","-","-","-","-"]
[null,null,"Výše hypotečního úvěru","MrtgFP","textbox",{"$f":"CONCATENATE(D69,\"_t\")","v":"MrtgFP_t"},"number","currency","user input",60,"-"]
[null,null,"Výše hypotečního úvěru - %","MrtgFP2","label","-","number","currency","computed",61,"-"]
[null,null,"Doba splácení hypotéky","MrtgLP","textbox",{"$f":"CONCATENATE(D71,\"_t\")","v":"MrtgLP_t"},"number","decimal","user input",62,"-"]
[null,null,"Úroková míra hypotéky","MrtgIP","textbox",{"$f":"CONCATENATE(D72,\"_t\")","v":"MrtgIP_t"},"number","percent","user input",63,"-"]
[null,null,"Další úvěr","LoanFrame","frame","-","-","-","-","-","-"]
[null,null,"Výše úvěru","LoanFP","textbox",{"$f":"CONCATENATE(D74,\"_t\")","v":"LoanFP_t"},"number","currency","user input",65,"-"]
[null,null,"Doba splácení úvěru","LoanLP","textbox",{"$f":"CONCATENATE(D75,\"_t\")","v":"LoanLP_t"},"number","decimal","user input",66,"-"]
[null,null,"Úroková míra úvěru","LoanIP","textbox",{"$f":"CONCATENATE(D76,\"_t\")","v":"LoanIP_t"},"number","percent","user input",67,"-"]
[null,null,"Vlastní kapitál","OwnCapP","label",{"$f":"CONCATENATE(D77,\"_t\")","v":"OwnCapP_t"},"number","currency","computed",68,"-"]