{"id":12252,"date":"2025-01-15T07:46:49","date_gmt":"2025-01-15T07:46:49","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-ham-fv-trong-excel-de-tinh-gia-tri-tuong-lai-cua-mot-khoan-dau-tu\/"},"modified":"2025-01-15T07:46:49","modified_gmt":"2025-01-15T07:46:49","slug":"huong-dan-su-dung-ham-fv-trong-excel-de-tinh-gia-tri-tuong-lai-cua-mot-khoan-dau-tu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-ham-fv-trong-excel-de-tinh-gia-tri-tuong-lai-cua-mot-khoan-dau-tu\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m FV trong Excel \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a m\u1ed9t kho\u1ea3n \u0111\u1ea7u t\u01b0"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><strong>H\u00e0m FV s\u1ebd t\u00ednh gi\u00e1 tr\u1ecb t\u1ea1i m\u1ed9t th\u1eddi \u0111i\u1ec3m t\u01b0\u01a1ng lai n\u00e0o \u0111\u00f3 m\u00e0 c\u00e1c nh\u00e0 \u0111\u1ea7u t\u01b0 s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c khi h\u1ecd \u0111\u1ea7u t\u01b0 m\u1ed9t k\u1ef3 hay nhi\u1ec1u k\u1ef3 v\u1edbi l\u00e3i su\u1ea5t kh\u00f4ng \u0111\u1ed5i.<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p h\u00e0m FV: <strong>FV(Rate,Nper,Pmt,Pv,Type)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Trong \u0111\u00f3:<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Rate:<\/strong> t\u1ef7 l\u1ec7 l\u00e3i su\u1ea5t m\u1ed7i k\u1ef3 (t\u00ednh theo th\u00e1ng, qu\u00fd, n\u0103m).<\/li>\n<li><strong>Nper:<\/strong> t\u1ed5ng s\u1ed1 k\u1ef3 chi tr\u1ea3.<\/li>\n<li><strong>Pmt:<\/strong> s\u1ed1 ti\u1ec1n chi tr\u1ea3 trong m\u1ed7i k\u1ef3, c\u1ed1 \u0111\u1ecbnh trong su\u1ed1t giai \u0111o\u1ea1n \u0111\u1ea7u t\u01b0.<\/li>\n<li><strong>Pv:<\/strong> gi\u00e1 tr\u1ecb \u0111\u1ea7u t\u01b0 ban \u0111\u1ea7u. N\u1ebfu \u0111\u1ec3 tr\u1ed1ng th\u00ec Pv=0<\/li>\n<li><strong>Type:<\/strong> =1 n\u1ebfu s\u1ed1 ti\u1ec1n tr\u1ea3 \u0111\u1ea7u k\u1ef3,=0 n\u1ebfu s\u1ed1 ti\u1ec1n tr\u1ea3 cu\u1ed1i k\u1ef3.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>Ch\u1ee9c n\u0103ng:<\/strong> <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-fv-trong-excel-de-tinh-gia-tri-tuong-lai-cua-mot-khoan-dau-tu.html\">H\u00e0m FV<\/a> t\u00ednh gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a m\u1ed9t kho\u1ea3n \u0111\u1ea7u t\u01b0 d\u1ef1a v\u00e0o t\u1ed5ng s\u1ed1 chu k\u1ef3, ti\u1ec1n tr\u1ea3 v\u00e0 l\u00e3i su\u1ea5t c\u1ed1 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5: <\/strong>B\u1ea1n mu\u1ed1n ti\u1ebft ki\u1ec7m m\u1ed9t s\u1ed1 ti\u1ec1n trong v\u00f2ng 1 n\u0103m. B\u1ea1n g\u1eedi 10 tri\u1ec7u v\u00e0o t\u00e0i kho\u1ea3n ti\u1ebft ki\u1ec7m v\u1edbi l\u00e3i su\u1ea5t 6%\/n\u0103m (0.5% th\u00e1ng). C\u1ee9 \u0111\u1ea7u m\u1ed7i th\u00e1ng b\u1ea1n g\u1eedi v\u00e0o t\u00e0i kho\u1ea3n 1 tri\u1ec7u trong v\u00f2ng 12 th\u00e1ng. H\u00e3y t\u00ednh xem trong t\u00e0i kho\u1ea3n c\u1ee7a b\u1ea1n s\u1ebd c\u00f3 bao nhi\u1ec1u ti\u1ec1n sau khi k\u1ebft th\u00fac 12 th\u00e1ng?<strong><br \/>\n<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1c b\u1ea1n c\u1ea7n ch\u00fa \u00fd ph\u00e2n bi\u1ec7t 2 tr\u01b0\u1eddng h\u1ee3p sau:<\/p>\n<p style=\"text-align: justify\"><strong>Tr\u01b0\u1eddng h\u1ee3p 1:<\/strong> S\u1ed1 ti\u1ec1n g\u1ed1c g\u1eedi t\u1eeb \u0111\u1ea7u k\u1ef3 tr\u01b0\u1edbc, s\u1ed1 ti\u1ec1n g\u1eedi th\u00eam b\u1eaft \u0111\u1ea7u t\u1eeb k\u1ef3 ti\u1ebfp theo. Khi \u0111\u00f3 Type=0 (\u1edf \u0111\u00e2u, \u0111\u1ea7u k\u1ef3 ti\u1ebfp theo l\u00e0 cu\u1ed1i c\u1ee7a k\u1ef3 tr\u01b0\u1edbc).<\/p>\n<p style=\"text-align: justify\">Ta th\u1ef1c hi\u1ec7n nh\u01b0 sau: =FV(6%\/12,12,-1000000,-10000000,0) \u2192 K\u1ebft qu\u1ea3: \u00a022,952,340.49<\/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\/2025\/01\/ex101_92019-nho-373.gif\" title=\"ex101_92019-nho-373\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3689 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/fv2.gif\" width=\"600\" height=\"292\" title=\"fv2\"><\/p>\n<p style=\"text-align: justify\"><strong>Tr\u01b0\u1eddng h\u1ee3p 2:<\/strong> S\u1ed1 ti\u1ec1n g\u1ed1c g\u1eedi t\u1eeb \u0111\u1ea7u k\u1ef3 tr\u01b0\u1edbc, s\u1ed1 ti\u1ec1n g\u1eedi th\u00eam g\u1eedi v\u00e0o c\u00f9ng \u0111\u00e0u th\u00e1ng v\u1edbi ti\u1ec1n g\u1ed1c. Khi \u0111\u00f3 Type=1.<\/p>\n<p style=\"text-align: justify\">Ta th\u1ef1c hi\u1ec7n nh\u01b0 sau: =FV(6%\/12,12,-1000000,-10000000,1)\u00a0\u2192 K\u1ebft qu\u1ea3: 23,014,018.30<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3690 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/fv3.gif\" width=\"600\" height=\"333\" title=\"fv3\"><\/p>\n<p style=\"text-align: justify\">Ch\u00fac c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel t\u1ea1i nh\u00e0<\/a> v\u1edbi c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\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\/2025\/01\/ex101_92019-nho-373.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12253,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12252","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\/12252","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=12252"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12252\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12253"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}