{"id":4927,"date":"2024-12-08T13:57:59","date_gmt":"2024-12-08T13:57:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/irr-la-gi-huong-dan-cach-dung-va-y-nghia-cua-ham-irr-trong-excel\/"},"modified":"2024-12-08T13:57:59","modified_gmt":"2024-12-08T13:57:59","slug":"irr-la-gi-huong-dan-cach-dung-va-y-nghia-cua-ham-irr-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/irr-la-gi-huong-dan-cach-dung-va-y-nghia-cua-ham-irr-trong-excel\/","title":{"rendered":"IRR l\u00e0 g\u00ec \u2013 H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng v\u00e0 \u00fd ngh\u0129a c\u1ee7a h\u00e0m IRR trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"irr l\u00e0 g\u00ec\" cite=\"https:\/\/blog.hocexcel.online\/irr-la-gi-huong-dan-cach-dung-va-y-nghia-cua-ham-irr-trong-excel.html?irr-la-gi?\">\n<p>\u0110\u1ec3\u00a0\u0111\u00e1nh gi\u00e1 hi\u1ec7u qu\u1ea3 c\u1ee7a 1 d\u1ef1\u00a0\u00e1n hay 1 ph\u01b0\u01a1ng\u00a0\u00e1n\u00a0\u0111\u1ea7u t\u01b0, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m\u00a0IRR trong\u00a0Excel. Nh\u01b0ng\u00a0IRR l\u00e0 g\u00ec? C\u00e1ch d\u00f9ng h\u00e0m n\u00e0y nh\u01b0 th\u1ebf n\u00e0o?\u00a0\u00dd ngh\u0129a c\u1ee7a h\u00e0m\u00a0IRR trong vi\u1ec7c\u00a0\u0111\u00e1nh gi\u00e1 ra sao? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u n\u1ed9i dung n\u00e0y nh\u00e9.<\/p>\n<\/blockquote>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6755a5e6df113\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/irr-la-gi-huong-dan-cach-dung-va-y-nghia-cua-ham-irr-trong-excel.html#IRR_la_gi_Y_nghia_cua_IRR_trong_danh_gia_du_an\" title=\"IRR l\u00e0 g\u00ec?\u00a0\u00dd ngh\u0129a c\u1ee7a\u00a0IRR trong\u00a0\u0111\u00e1nh gi\u00e1 d\u1ef1\u00a0\u00e1n\">IRR l\u00e0 g\u00ec?\u00a0\u00dd ngh\u0129a c\u1ee7a\u00a0IRR trong\u00a0\u0111\u00e1nh gi\u00e1 d\u1ef1\u00a0\u00e1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/irr-la-gi-huong-dan-cach-dung-va-y-nghia-cua-ham-irr-trong-excel.html#Cach_su_dung_ham_IRR_trong_Excel\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0IRR trong\u00a0Excel\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0IRR trong\u00a0Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"IRR_la_gi_Y_nghia_cua_IRR_trong_danh_gia_du_an\"><\/span>IRR l\u00e0 g\u00ec?\u00a0\u00dd ngh\u0129a c\u1ee7a\u00a0IRR trong\u00a0\u0111\u00e1nh gi\u00e1 d\u1ef1\u00a0\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>IRR \u0111\u01b0\u1ee3c vi\u1ebft t\u1eaft c\u1ee7a <strong>Internal Rate of Return<\/strong>, c\u00f3 ngh\u0129a l\u00e0 t\u1ef7 su\u1ea5t ho\u00e0n v\u1ed1n n\u1ed9i b\u1ed9.<\/p>\n<p>IRR c\u00f3\u00a0\u00fd ngh\u0129a:<\/p>\n<ul>\n<li>L\u00e0 t\u1ef7 su\u1ea5t chi\u1ebft kh\u1ea5u m\u00e0 t\u1ea1i\u00a0\u0111\u00f3 NPV = 0, l\u00e0 khi 1 d\u1ef1\u00a0\u00e1n kh\u00f4ng c\u00f2n b\u1ecb l\u1ed7<\/li>\n<li>Hay c\u00f2n c\u00f3 ngh\u0129a kh\u00e1c l\u00e0 t\u1ed1c\u00a0\u0111\u1ed9 t\u0103ng tr\u01b0\u1edfng m\u00e0 d\u1ef1\u00a0\u00e1n\u00a0\u0111\u00f3 t\u1ea1o ra.<\/li>\n<li>IRR d\u00f9ng\u00a0\u0111\u1ec3\u00a0\u0111o l\u01b0\u1eddng m\u1ee9c\u00a0\u0111\u1ed9 r\u1ee7i ro c\u1ee7a kho\u1ea3n\u00a0\u0111\u1ea7u t\u01b0 trong t\u01b0\u01a1ng lai, v\u00ec ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u01b0\u1edbc l\u01b0\u1ee3ng\u00a0\u0111\u01b0\u1ee3c t\u1ef7 su\u1ea5t chi ph\u00ed cao nh\u1ea5t m\u00e0 d\u1ef1\u00a0\u00e1n\u00a0\u0111\u00f3 c\u00f3 th\u1ec3 ch\u1ea5p nh\u1eadn\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1ec3\u00a0\u0111\u1ea1t\u00a0\u0111\u1ebfn\u00a0\u0111i\u1ec3m h\u00f2a v\u1ed1n (NPV=0) trong m\u1ed9t kho\u1ea3ng th\u1eddi gian x\u00e1c\u00a0\u0111\u1ecbnh.<\/li>\n<\/ul>\n<p>IRR c\u00e0ng l\u1edbn th\u00ec c\u00e0ng t\u1ed1t, v\u00e0\u00a0IRR &gt; T\u1ef7 su\u1ea5t chi\u1ebft kh\u1ea5u (chi ph\u00ed s\u1eed d\u1ee5ng v\u1ed1n) th\u00ec t\u1ea1i th\u1eddi\u00a0\u0111i\u1ec3m\u00a0\u0111\u00f3 d\u1ef1\u00a0\u00e1n c\u00f3 l\u00e3i.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_IRR_trong_Excel\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0IRR trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m\u00a0IRR nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=IRR(values, guess)<\/p>\n<\/blockquote>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<p><strong>Values<\/strong>: l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb n\u1ea1p v\u00e0o\u00a0\u0111\u1ec3 t\u00ednh to\u00e1n, bao g\u1ed3m:<\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb\u00a0\u0111\u1ea7u t\u01b0 ban\u00a0\u0111\u1ea7u: l\u00e0 1 s\u1ed1\u00a0\u00e2m<\/li>\n<li>Nh\u1eefng gi\u00e1 tr\u1ecb ti\u1ebfp theo: l\u00e0 l\u1ee3i nhu\u1eadn h\u00e0ng n\u0103m c\u1ee7a d\u1ef1\u00a0\u00e1n. L\u01b0u\u00a0\u00fd c\u00e1c gi\u00e1 tr\u1ecb n\u00e0y ph\u1ea3i theo tr\u00ecnh t\u1ef1 th\u1eddi gian.<\/li>\n<\/ul>\n<p><strong>Guess<\/strong>:\u00a0s\u1ed1 %\u00a0\u01b0\u1edbc l\u01b0\u1ee3ng g\u1ea7n v\u1edbi k\u1ebft qu\u1ea3 c\u1ee7a\u00a0IRR, th\u01b0\u1eddng m\u1eb7c\u00a0\u0111\u1ecbnh l\u00e0 10%. Khi h\u00e0m\u00a0IRR ra k\u1ebft qu\u1ea3 <a href=\"http:\/\/blog.ezworkapp.com\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html\">#NUM!<\/a> th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 th\u1eed thay\u00a0\u0111\u1ed5i gi\u00e1 tr\u1ecb Guess\u00a0\u0111\u1ec3 xem h\u00e0m\u00a0IRR c\u00f3 t\u00ednh ra k\u1ebft qu\u1ea3 hay kh\u00f4ng.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-407.gif\" title=\"ex101_92019-nho-407\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25088\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-irr-cua-du-an-theo-tung-nam-1024x257-1.png\" width=\"800\" height=\"201\" title=\"tinh-irr-cua-du-an-theo-tung-nam-1024x257-1\"><\/p>\n<p>Trong b\u1ea3ng t\u00ednh tr\u00ean ta c\u00f3:<\/p>\n<ul>\n<li>Chi ph\u00ed\u00a0\u0111\u1ea7u t\u01b0 ban\u00a0\u0111\u1ea7u c\u1ee7a d\u1ef1\u00a0\u00e1n l\u00e0 68.000 =&gt; Khi x\u00e9t trong\u00a0IRR th\u00ec gi\u00e1 tr\u1ecb n\u00e0y ph\u1ea3i mang d\u1ea5u\u00a0\u00e2m, v\u00ec\u00a0\u0111\u00f3 l\u00e0 kho\u1ea3n ti\u1ec1n ph\u1ea3i chi ra<\/li>\n<li>L\u1ee3i nhu\u1eadn h\u00e0ng n\u0103m c\u1ee7a d\u1ef1\u00a0\u00e1n l\u00e0 c\u00e1c s\u1ed1 d\u01b0\u01a1ng =&gt; Khi x\u00e9t trong\u00a0IRR th\u00ec gi\u00e1 tr\u1ecb n\u00e0y mang d\u1ea5u d\u01b0\u01a1ng, v\u00ec\u00a0\u0111\u00f3 l\u00e0 kho\u1ea3n ti\u1ec1n thu v\u1ec1<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">IRR c\u1ee7a n\u0103m th\u1ee9 1 =\u00a0IRR(J4:J5) = -80%<\/p>\n<p style=\"padding-left: 30px\">IRR\u00a0c\u1ee7a n\u0103m th\u1ee9 2 =\u00a0IRR(J4:J6) = -42%<\/p>\n<p style=\"padding-left: 30px\">IRR\u00a0c\u1ee7a n\u0103m th\u1ee9\u00a03 =\u00a0IRR(J4:J7) = -17%<\/p>\n<p style=\"padding-left: 30px\">IRR\u00a0c\u1ee7a n\u0103m th\u1ee9\u00a04 =\u00a0IRR(J4:J8) = -2%<\/p>\n<p style=\"padding-left: 30px\">IRR\u00a0c\u1ee7a n\u0103m th\u1ee9\u00a05 =\u00a0IRR(J4:J9) = 7%<\/p>\n<p>Nh\u01b0 v\u1eady sau 5 n\u0103m, d\u1ef1\u00a0\u00e1n n\u00e0y c\u00f3 t\u00ednh kh\u1ea3 thi khi\u00a0IRR l\u00e0 s\u1ed1 d\u01b0\u01a1ng.<\/p>\n<p>Nh\u01b0ng n\u1ebfu chi ph\u00ed s\u1eed d\u1ee5ng v\u1ed1n (l\u00e3i su\u1ea5t chi\u1ebft kh\u1ea5u) l\u00e0 10% th\u00ec sau 5 n\u0103m\u00a0IRR v\u1eabn ch\u01b0a\u00a0\u0111\u1ea1t t\u1ef7 l\u1ec7\u00a0k\u1ef3 v\u1ecdng. Do\u00a0\u0111\u00f3 trong th\u1eddi gian ho\u1ea1t\u00a0\u0111\u1ed9ng gi\u1ea3\u00a0\u0111\u1ecbnh l\u00e0 5 n\u0103m th\u00ec d\u1ef1\u00a0\u00e1n ch\u01b0a kh\u1ea3 thi (NPV v\u1eabn &lt;0)<\/p>\n<p>Do v\u1eady\u00a0\u0111\u1ec3\u00a0\u0111\u00e1nh gi\u00e1 t\u00ednh kh\u1ea3 thi c\u1ee7a 1 d\u1ef1\u00a0\u00e1n hay 1 kho\u1ea3n\u00a0\u0111\u1ea7u t\u01b0, ch\u00fang ta c\u1ea7n ph\u1ea3i\u00a0\u0111\u00e1nh gi\u00e1 c\u1ea3 2 y\u1ebfu t\u1ed1 <a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-ham-pv-trong-excel-de-tinh-toan-hieu-qua-cua-cac-phuong-dau-tu.html\">NPV<\/a> v\u00e0\u00a0IRR.<\/p>\n<p>N\u1ebfu qu\u00e3ng th\u1eddi gian x\u00e1c\u00a0\u0111\u1ecbnh\u00a0c\u00e1c k\u1ef3\u00a0kh\u00f4ng\u00a0\u0111\u1ec1u th\u00ec ch\u00fang ta s\u1ebd c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tinh-loi-suat-dong-tien-khong-dinh-ky-bang-ham-tai-chinh-xirr.html\">h\u00e0m XIRR<\/a>. H\u00e0m\u00a0IRR ch\u1ec9 s\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c khi th\u1eddi gian c\u00e1c k\u1ef3 t\u00ednh\u00a0to\u00e1n l\u00e0 b\u1eb1ng nhau.<\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1c ki\u1ebfn th\u1ee9c v\u1ec1 t\u00e0i ch\u00ednh, ph\u00e2n t\u00edch d\u1ef1 \u00e1n, c\u00e1c h\u00e0m\u00a0excel trong t\u00e0i ch\u00ednh, m\u1eddi c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u th\u00eam c\u00e1c b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-ham-pv-trong-excel-de-tinh-toan-hieu-qua-cua-cac-phuong-dau-tu.html\">\u1ee8ng d\u1ee5ng h\u00e0m PV trong Excel \u0111\u1ec3 t\u00ednh to\u00e1n hi\u1ec7u qu\u1ea3 c\u1ee7a c\u00e1c ph\u01b0\u01a1ng \u00e1n \u0111\u1ea7u t\u01b0<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/excel-voi-tai-chinh-ham-pmt-tinh-tien-thanh-toan-hang-ky-cho-khoan-vay.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m PMT t\u00ednh s\u1ed1 ti\u1ec1n thanh to\u00e1n h\u00e0ng k\u1ef3 cho kho\u1ea3n vay trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-rate-ham-tinh-lai-suat-trong-excel.html\">H\u00e0m RATE, H\u00e0m t\u00ednh l\u00e3i su\u1ea5t trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/mo-hinh-tai-chinh-financial-model-la-gi.html\">M\u00f4 h\u00ecnh t\u00e0i ch\u00ednh (Financial Model) l\u00e0 g\u00ec<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-407.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4928,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4927","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=4927"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4927\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4928"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}