Finansal analizlerde kullan\u0131lan \u00f6nemli fonksiyonlardan biri de \u00d6rnek s\u00f6zdizimi a\u015fa\u011f\u0131daki gibi olacakt\u0131r:<\/p>\n Burada, 2021 y\u0131l\u0131n\u0131n ba\u015f\u0131ndan sonuna kadar olan 10,000 birimlik yat\u0131r\u0131m i\u00e7in %5 indirim oran\u0131 ve ger\u00e7ek\/ger\u00e7ek g\u00fcn say\u0131m temeliyle faiz getirisi hesaplanmaktad\u0131r.<\/p>\n Bir yat\u0131r\u0131mc\u0131n\u0131n, 1 y\u0131ll\u0131k sabit getirili bir tahvil i\u00e7in 50,000 birim yat\u0131r\u0131m yapt\u0131\u011f\u0131n\u0131 varsayal\u0131m. Tahvilin indirim oran\u0131 %4 ve bu i\u015flem i\u00e7in g\u00fcn say\u0131m temeli olarak 30\/360 kullan\u0131l\u0131yor. Yat\u0131r\u0131m\u0131n getirisinin hesaplanmas\u0131 i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131l\u0131r:<\/p>\n Bu i\u015flem sonucunda elde edilen tutar, yat\u0131r\u0131mc\u0131n\u0131n 1 y\u0131l sonunda tahvilden elde edece\u011fi net tutar\u0131 g\u00f6sterir.<\/p>\n \u0130ki farkl\u0131 tahvilin 6 ayl\u0131k getirisinin kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131 gerekti\u011fini d\u00fc\u015f\u00fcnelim. Birinci tahvil %3.5 ve ikinci tahvil %4 indirim oran\u0131na sahip. Her iki yat\u0131r\u0131m da 100.000 birim \u00fczerinden yap\u0131lm\u0131\u015f ve g\u00fcn say\u0131m temeli olarak ger\u00e7ek\/ger\u00e7ek kullan\u0131lm\u0131\u015ft\u0131r:<\/p>\n Bu hesaplamalar yat\u0131r\u0131mc\u0131lara hangi tahvilin yar\u0131 y\u0131l sonunda daha fazla getiri sa\u011flayaca\u011f\u0131n\u0131 g\u00f6sterecektir.<\/p>\n Tam olarak yat\u0131r\u0131lm\u0131\u015f bir tahvilin vadesinin bitiminde al\u0131nan miktar\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[578],"tags":[],"class_list":["post-15614","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nRECEIVED<\/code> (GET\u0130R\u0130) fonksiyonudur. Bu fonksiyon, yat\u0131r\u0131mlar\u0131n faiz gelirlerini hesaplarken kullan\u0131l\u0131r. Microsoft Excel ve Google E-Tablolar’da, bu i\u015flev belirli parametreler \u0131\u015f\u0131\u011f\u0131nda nominal de\u011fer \u00fczerinden al\u0131nan faizin hesaplanmas\u0131n\u0131 sa\u011flar. Bu makalede fonksiyonun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ve uygulama \u00f6rnekleri \u00fczerinden detaylar\u0131 inceleyece\u011fiz.<\/p>\n\u0130\u015flevin S\u00f6zdizimi ve Parametreleri<\/h2>\n
RECEIVED<\/code> fonksiyonu a\u015fa\u011f\u0131daki parametreleri al\u0131r:<\/p>\n\n
=RECEIVED(\"2021-01-01\", \"2021-12-31\", 10000, 0.05, 1)<\/code><\/pre>\nPratik Uygulama \u00d6rnekleri<\/h2>\n
\u00d6rnek 1: Y\u0131ll\u0131k Yat\u0131r\u0131m Getirisi Hesaplamas\u0131<\/h3>\n
=RECEIVED(\"2023-01-01\", \"2024-01-01\", 50000, 0.04, 0)<\/code><\/pre>\n\u00d6rnek 2: K\u0131sa S\u00fcreli Yat\u0131r\u0131m Kar\u015f\u0131la\u015ft\u0131rmas\u0131<\/h3>\n
=RECEIVED(\"2023-06-01\", \"2023-12-01\", 100000, 0.035, 1) =RECEIVED(\"2023-06-01\", \"2023-12-01\", 100000, 0.04, 1) <\/code><\/pre>\nYorumlar ve Ek Detaylar<\/h2>\n
RECEIVED<\/code> fonksiyonu kullan\u0131l\u0131rken, settlement ve maturity tarihlerinin do\u011fru formatta girildi\u011finden emin olunmal\u0131d\u0131r. Ayr\u0131ca, indirim oran\u0131 ve yat\u0131r\u0131m miktar\u0131n\u0131n do\u011fru hesaplanmas\u0131, getirinin do\u011fru bir \u015fekilde belirlenmesi i\u00e7in kritik \u00f6nem ta\u015f\u0131maktad\u0131r. Fonksiyonu kullan\u0131rken, parametreler aras\u0131ndaki ili\u015fkilerin ve faizin nas\u0131l i\u015flendi\u011finin iyi anla\u015f\u0131lmas\u0131 gerekmektedir. Bu anlamda, RECEIVED<\/code> finansal karar verme s\u00fcrecinde \u00f6nemli bir yard\u0131mc\u0131d\u0131r ve yat\u0131r\u0131m analizlerinde fayda sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"