{"id":5888,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/yielddisc\/"},"modified":"2021-02-26T10:06:17","modified_gmt":"2021-02-26T10:06:17","slug":"yielddisc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/yielddisc\/","title":{"rendered":"YIELDDISC"},"content":{"rendered":"

Jak pou\u017e\u00edvat finan\u010dn\u00ed funkci pro v\u00fdpo\u010det v\u00fdnosu v diskontovan\u00fdch cenn\u00fdch pap\u00edrech<\/h2>\n

Funkce, o kter\u00e9 budeme mluvit, je ve sv\u011bt\u011b tabulkov\u00fdch kalkul\u00e1tor\u016f velmi u\u017eite\u010dn\u00e1 pro finan\u010dn\u00ed anal\u00fdzy, zejm\u00e9na pokud se zab\u00fdv\u00e1te investicemi do diskontovan\u00fdch dluhopis\u016f nebo pokladni\u010dn\u00edch pouk\u00e1zek. Tato funkce v\u00e1m umo\u017en\u00ed vypo\u010d\u00edtat ro\u010dn\u00ed v\u00fdnos cenn\u00e9ho pap\u00edru, kter\u00fd je prod\u00e1v\u00e1n pod jeho nomin\u00e1ln\u00ed hodnotou (diskontem). <\/p>\n

Syntaxe a pou\u017eit\u00ed<\/h2>\n

Funkce vypad\u00e1 takto pro MS Excel i Google Tabulky: <\/p>\n

YIELDDISC(settlement, maturity, pr, redemption, [basis])<\/code><\/pre>\n
    \n
  • settlement<\/code> – Datum, kdy kupuj\u00edc\u00ed z\u00edsk\u00e1v\u00e1 cenn\u00fd pap\u00edr.<\/li>\n
  • maturity<\/code> – Datum splatnosti cenn\u00e9ho pap\u00edru.<\/li>\n
  • pr<\/code> – Cena, za kterou je cenn\u00fd pap\u00edr koupen.<\/li>\n
  • redemption<\/code> – Nomin\u00e1ln\u00ed hodnota cenn\u00e9ho pap\u00edru, kter\u00e1 bude zaplacena v den splatnosti.<\/li>\n
  • basis<\/code> (voliteln\u00fd) – Metoda v\u00fdpo\u010dtu dn\u016f v roce, kter\u00e1 m\u016f\u017ee ovlivnit v\u00fdpo\u010det. P\u0159ij\u00edm\u00e1 hodnoty od 0 do 4.<\/li>\n<\/ul>\n
    P\u0159\u00edklad:<\/strong> P\u0159edpokl\u00e1dejme, \u017ee m\u00e1me cenn\u00fd pap\u00edr s n\u00e1sleduj\u00edc\u00edmi \u00fadaji:<\/p>\n
      \n
    • Datum n\u00e1kupu: 1.1.2020<\/li>\n
    • Datum splatnosti: 1.1.2021<\/li>\n
    • Kupn\u00ed cena: 9700 K\u010d<\/li>\n
    • Nomin\u00e1ln\u00ed hodnota: 10000 K\u010d<\/li>\n
    • B\u00e1zov\u00e1 hodnota metody: 2 (Aktu\u00e1ln\u00ed\/360)<\/li>\n<\/ul>\n
       V\u00fdpo\u010det v\u00fdnosu: <\/p>\n
       YIELDDISC(\"1.1.2020\", \"1.1.2021\", 9700, 10000, 2) <\/code><\/pre>\n
       Tato funkce vr\u00e1t\u00ed v\u00fdnos cenn\u00e9ho pap\u00edru jako procentu\u00e1ln\u00ed hodnotu. <\/p>\n
      Praktick\u00e9 vyu\u017eit\u00ed<\/h2>\n
       Krom\u011b b\u011b\u017en\u00fdch investi\u010dn\u00edch kalkulac\u00ed, mohou b\u00fdt funkce pro v\u00fdpo\u010det v\u00fdnosu vyu\u017eity ve specifick\u00fdch finan\u010dn\u00edch \u00faloh\u00e1ch: <\/p>\n
      Ur\u010den\u00ed ROI pro kr\u00e1tkodob\u00e9 korpor\u00e1tn\u00ed dluhopisy<\/h2>\n
       Investor zva\u017euje koupi kr\u00e1tkodob\u00e9ho korpor\u00e1tn\u00edho dluhopisu s n\u00e1sleduj\u00edc\u00edmi \u00fadaji: <\/p>\n
        \n
      • Datum n\u00e1kupu: 1.5.2020<\/li>\n
      • Datum splatnosti: 1.5.2021<\/li>\n
      • Kupn\u00ed cena: 9500 K\u010d<\/li>\n
      • Nomin\u00e1ln\u00ed hodnota: 10000 K\u010d<\/li>\n<\/ul>\n
        Pro v\u00fdpo\u010det v\u00fdnosu pou\u017eijeme n\u00e1sleduj\u00edc\u00ed p\u0159\u00edkaz:<\/p>\n
         YIELDDISC(\"1.5.2020\", \"1.5.2021\", 9500, 10000, 0) <\/code><\/pre>\n
         Tento v\u00fdpo\u010det pom\u016f\u017ee investorovi ur\u010dit, jestli je investice atraktivn\u00ed s ohledem na o\u010dek\u00e1van\u00fd ro\u010dn\u00ed v\u00fdnos. <\/p>\n
        Porovn\u00e1n\u00ed v\u00fdnos\u016f r\u016fzn\u00fdch investi\u010dn\u00edch p\u0159\u00edle\u017eitost\u00ed<\/h2>\n
         Finan\u010dn\u00ed analytik p\u0159ipravuje porovn\u00e1n\u00ed r\u016fzn\u00fdch diskontovan\u00fdch cenn\u00fdch pap\u00edr\u016f, aby doporu\u010dil nejlep\u0161\u00ed mo\u017enosti pro portfolio. Pro ka\u017edou investici vypo\u010d\u00edt\u00e1 v\u00fdnos pomoc\u00ed na\u0161\u00ed funkce a porovn\u00e1 v\u00fdsledky. <\/p>\n
          \n
        • Cenn\u00fd pap\u00edr A: YIELDDISC(\"1.4.2020\", \"1.4.2021\", 9200, 10000, 1)<\/code><\/li>\n
        • Cenn\u00fd pap\u00edr B: YIELDDISC(\"1.6.2020\", \"1.6.2021\", 9300, 10000, 1)<\/code><\/li>\n<\/ul>\n
           V\u00fdsledky t\u011bchto v\u00fdpo\u010dt\u016f pomohou analytikovi sestavit report, kter\u00fd d\u00e1v\u00e1 p\u0159ehled o relat\u00edvn\u00ed v\u00fdhodnosti jednotliv\u00fdch cenn\u00fdch pap\u00edr\u016f. <\/p>\n
           Z t\u011bchto p\u0159\u00edklad\u016f je patrn\u00e9, \u017ee finan\u010dn\u00ed funkce pro v\u00fdpo\u010det v\u00fdnosu je kl\u00ed\u010dov\u00e1 pro racion\u00e1ln\u00ed investi\u010dn\u00ed rozhodov\u00e1n\u00ed a pro finan\u010dn\u00ed pl\u00e1nov\u00e1n\u00ed. <\/p>\n","protected":false},"excerpt":{"rendered":"
          Vr\u00e1t\u00ed ro\u010dn\u00ed v\u00fdnos diskontn\u00edho cenn\u00e9ho pap\u00edru, nap\u0159\u00edklad sm\u011bnky st\u00e1tn\u00ed pokladny<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[283],"tags":[],"class_list":["post-5888","post","type-post","status-publish","format-standard","hentry","category-financni"],"acf":[],"yoast_head":"\nFunkce YIELDDISC v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije YIELDDISC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/cs\/yielddisc\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce YIELDDISC v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije YIELDDISC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/yielddisc\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T10:06:17+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce YIELDDISC v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/yielddisc\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/yielddisc\/\",\"name\":\"Funkce YIELDDISC v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:45+00:00\",\"dateModified\":\"2021-02-26T10:06:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije YIELDDISC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/yielddisc\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/yielddisc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/yielddisc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finan\u010dn\u00ed\",\"item\":\"https:\/\/functiontranslator.com\/cs\/financni\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"YIELDDISC\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce YIELDDISC v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije YIELDDISC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/cs\/yielddisc\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce YIELDDISC v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije YIELDDISC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/yielddisc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T10:06:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce YIELDDISC v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/yielddisc\/","url":"https:\/\/functiontranslator.com\/cs\/yielddisc\/","name":"Funkce YIELDDISC v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:45+00:00","dateModified":"2021-02-26T10:06:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije YIELDDISC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/yielddisc\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/yielddisc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/yielddisc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Finan\u010dn\u00ed","item":"https:\/\/functiontranslator.com\/cs\/financni\/"},{"@type":"ListItem","position":3,"name":"YIELDDISC"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5888","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5888"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5888\/revisions"}],"predecessor-version":[{"id":31022,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5888\/revisions\/31022"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}