{"id":10669,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/rent-bs\/"},"modified":"2021-02-26T05:26:12","modified_gmt":"2021-02-26T05:26:12","slug":"tbillyield","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pl\/tbillyield\/","title":{"rendered":"RENT.BS"},"content":{"rendered":"

Funkcja TBILLYIELD (w polskiej wersji Excela znana jako RENT.BS) s\u0142u\u017cy do obliczania rocznej rentowno\u015bci skarbowych weksli dyskontowych. Poni\u017cej znajdziesz szczeg\u00f3\u0142owy opis tej funkcji, jej zastosowania oraz przyk\u0142ady, kt\u00f3re u\u0142atwi\u0105 Ci zrozumienie jej praktycznego wykorzystania w Microsoft Excel i Google Sheets.<\/p>\n

Opis i sk\u0142adnia funkcji<\/h2>\n

Funkcja RENT.BS oblicza roczn\u0105 stop\u0119 zwrotu na podstawie ceny zakupu, ceny nominalnej i okresu do wykupu obligacji. Sk\u0142adnia funkcji przedstawia si\u0119 nast\u0119puj\u0105co:<\/p>\n

RENT.BS(data_zakupu, data_wykupu, cena_zakupu, redemption, [baza])<\/code><\/pre>\n
    \n
  • data_zakupu<\/strong> – Data nabycia weksla.<\/li>\n
  • data_wykupu<\/strong> – Data wykupu weksla.<\/li>\n
  • cena_zakupu<\/strong> – Cena, po kt\u00f3rej weksel zosta\u0142 zakupiony.<\/li>\n
  • redemption<\/strong> – Cena nominalna weksla, czyli kwota, za kt\u00f3r\u0105 weksel zostanie odkupiony.<\/li>\n
  • baza<\/strong> – Opcjonalny parametr okre\u015blaj\u0105cy system liczenia dni. Mo\u017ce przyj\u0105\u0107 warto\u015bci: 0 lub nieokre\u015blone (NASD), 1 (rzeczywisty), 2 (rzeczywisty\/360), 3 (rzeczywisty\/365) lub 4 (europejski 30\/360).<\/li>\n<\/ul>\n
    Przyk\u0142adowe zastosowania<\/h2>\n
    Oto kilka praktycznych przyk\u0142ad\u00f3w u\u017cycia funkcji RENT.BS, kt\u00f3re mo\u017cesz napotka\u0107 w realnych scenariuszach finansowych:<\/p>\n
    Obliczanie rentowno\u015bci weksla skarbowego<\/h2>\n
    Za\u0142\u00f3\u017cmy, \u017ce zakupi\u0142e\u015b weksel skarbowy za 980 z\u0142, jego cena nominalna wynosi 1000 z\u0142, a okres do wykupu to 90 dni. Je\u015bli u\u017cyjemy standardowego systemu liczenia dni NASD (baza = 0), formu\u0142a do obliczenia rocznej rentowno\u015bci weksla prezentuje si\u0119 w nast\u0119puj\u0105cy spos\u00f3b:<\/p>\n
    =RENT.BS(\"2022-01-01\", \"2022-04-01\", 980, 1000, 0)<\/code><\/pre>\n
    Wynik tej formu\u0142y poka\u017ce roczn\u0105 rentowno\u015b\u0107 weksla zakupionego 1 stycznia i wykupionego 1 kwietnia po cenie ni\u017cszej od nominalnej.<\/p>\n
    Por\u00f3wnywanie rentowno\u015bci weksli o r\u00f3\u017cnych terminach wykupu<\/h2>\n
    Je\u015bli interesuje Ci\u0119 por\u00f3wnanie rentowno\u015bci weksli z r\u00f3\u017cnymi datami wykupu, mo\u017cesz skorzysta\u0107 z tej funkcji, aby podj\u0105\u0107 lepsze decyzje inwestycyjne. Na przyk\u0142ad:<\/p>\n
    =RENT.BS(\"2022-01-01\", \"2022-04-01\", 980, 1000, 0) =RENT.BS(\"2022-01-01\", \"2022-05-01\", 970, 1000, 0)<\/code><\/pre>\n
    Powy\u017csze formu\u0142y pomog\u0105 Ci oceni\u0107, kt\u00f3re weksle s\u0105 bardziej op\u0142acalne bior\u0105c pod uwag\u0119 r\u00f3\u017cne terminy wykupu i ceny zakupu.<\/p>\n
    Zarz\u0105dzanie finansami osobistymi lub firmowymi staje si\u0119 znacznie prostsze, gdy znasz narz\u0119dzia takie jak funkcja TBILLYIELD. Dzi\u0119ki zaprezentowanym tutaj przyk\u0142adom i zastosowaniom, zyskasz lepsze zrozumienie, jak efektywnie inwestowa\u0107 w kr\u00f3tkoterminowe papiery warto\u015bciowe.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Zwraca rentowno\u015b\u0107 bonu skarbowego<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[424],"tags":[],"class_list":["post-10669","post","type-post","status-publish","format-standard","hentry","category-finansowe"],"acf":[],"yoast_head":"\nFunkcja TBILLYIELD (RENT.BS) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia<\/title>\n<meta name=\"description\" content=\"Opis funkcji TBILLYIELD (RENT.BS) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\" \/>\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\/pl\/tbillyield\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkcja TBILLYIELD (RENT.BS) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\" \/>\n<meta property=\"og:description\" content=\"Opis funkcji TBILLYIELD (RENT.BS) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pl\/tbillyield\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T05:26:12+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkcja TBILLYIELD (RENT.BS) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\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\/pl\/tbillyield\/\",\"url\":\"https:\/\/functiontranslator.com\/pl\/tbillyield\/\",\"name\":\"Funkcja TBILLYIELD (RENT.BS) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-26T05:26:12+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcji TBILLYIELD (RENT.BS) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pl\/tbillyield\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pl\/tbillyield\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pl\/tbillyield\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkcje programu Excel\",\"item\":\"https:\/\/functiontranslator.com\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finansowe\",\"item\":\"https:\/\/functiontranslator.com\/pl\/finansowe\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"RENT.BS\"}]},{\"@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\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@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\/pl\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkcja TBILLYIELD (RENT.BS) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","description":"Opis funkcji TBILLYIELD (RENT.BS) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","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\/pl\/tbillyield\/","og_locale":"pl_PL","og_type":"article","og_title":"Funkcja TBILLYIELD (RENT.BS) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","og_description":"Opis funkcji TBILLYIELD (RENT.BS) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","og_url":"https:\/\/functiontranslator.com\/pl\/tbillyield\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-26T05:26:12+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkcja TBILLYIELD (RENT.BS) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","twitter_misc":{"Napisane przez":"glavadmin","Szacowany czas czytania":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pl\/tbillyield\/","url":"https:\/\/functiontranslator.com\/pl\/tbillyield\/","name":"Funkcja TBILLYIELD (RENT.BS) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-26T05:26:12+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcji TBILLYIELD (RENT.BS) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pl\/tbillyield\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pl\/tbillyield\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pl\/tbillyield\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkcje programu Excel","item":"https:\/\/functiontranslator.com\/pl\/"},{"@type":"ListItem","position":2,"name":"Finansowe","item":"https:\/\/functiontranslator.com\/pl\/finansowe\/"},{"@type":"ListItem","position":3,"name":"RENT.BS"}]},{"@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":"pl-PL"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pl-PL","@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\/pl\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/comments?post=10669"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10669\/revisions"}],"predecessor-version":[{"id":27981,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10669\/revisions\/27981"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/media?parent=10669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/categories?post=10669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/tags?post=10669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}