E\u011fer 50,000 TL tutar\u0131nda bir kredi ile araba sat\u0131n almay\u0131 d\u00fc\u015f\u00fcn\u00fcyorsan\u0131z ve banka size y\u0131ll\u0131k %6 faiz oran\u0131 ve 5 y\u0131l vadeli bir teklif sunmu\u015fsa, ayl\u0131k \u00f6deme miktar\u0131n\u0131z\u0131 \u015fu \u015fekilde hesaplayabilirsiniz:<\/p>\n Bu form\u00fclle, her ay ne kadar \u00f6deme yapaca\u011f\u0131n\u0131z\u0131 kolayca hesaplayabilirsiniz.<\/p>\n 100,000 TL ba\u015flang\u0131\u00e7 sermayesiyle ve y\u0131ll\u0131k %8 getiri beklentisiyle 20 y\u0131l s\u00fcreyle yat\u0131r\u0131m yapmay\u0131 planl\u0131yorsan\u0131z, \u015fu form\u00fcl\u00fc kullan\u0131n:<\/p>\n Bu hesaplama, her d\u00f6nem sonunda yap\u0131lmas\u0131 gereken \u00f6deme miktar\u0131n\u0131 g\u00f6sterir.<\/p>\n","protected":false},"excerpt":{"rendered":" Bir y\u0131ll\u0131k d\u00f6nemsel \u00f6demeyi 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-15590","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nDEVRESEL_\u00d6DEME<\/code> veya \u0130ngilizce ad\u0131yla PMT<\/code>, belirli bir d\u00f6nem say\u0131s\u0131 ve faiz oran\u0131 ile sabit \u00f6deme plan\u0131 \u00e7er\u00e7evesinde, bir bor\u00e7 veya yat\u0131r\u0131m\u0131n toplam \u00f6denmesi gereken miktar\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131lan finansal bir fonksiyondur. Hem Microsoft Excel hem de Google Sheets’te bulunur ve genellikle kredi taksitlerini ya da yat\u0131r\u0131mlar\u0131n d\u00f6nemsel \u00f6demelerini belirlemek i\u00e7in kullan\u0131l\u0131r.<\/p>\nFonksiyonun S\u00f6zdizimi<\/h2>\n
DEVRESEL_\u00d6DEME(faiz_oran\u0131, d\u00f6nem_say\u0131s\u0131, anapara, [gelecek_de\u011fer], [\u00f6deme_tipi])<\/code><\/p>\n\n
\u00d6rnek Kullan\u0131m<\/h2>\n
\u00d6rne\u011fin, y\u0131ll\u0131k %5 faiz oran\u0131yla 20,000 TL'lik bir kredi 10 y\u0131l s\u00fcreyle nas\u0131l \u00f6denir hesaplayal\u0131m: =DEVRESEL_\u00d6DEME(5%\/12, 10*12, 20000) Burada; - Faiz oran\u0131 ayl\u0131k %0.416666 olarak hesapland\u0131 (5% \/ 12 ay). - D\u00f6nem say\u0131s\u0131 olarak 120 ay (10 y\u0131l x 12 ay) belirlendi. - Anapara olarak 20,000 TL girildi. <\/code> <\/pre>\nPratik Uygulamalar<\/h2>\n
\u00d6rnek 1: Ki\u015fisel Finans Planlamas\u0131<\/h3>\n
=DEVRESEL_\u00d6DEME(6%\/12, 5*12, 50000)<\/code> <\/pre>\n\u00d6rnek 2: Yat\u0131r\u0131m Planlamas\u0131<\/h3>\n
=DEVRESEL_\u00d6DEME(8%\/12, 20*12, -100000, , 1)<\/code> <\/pre>\n