{"id":1876,"date":"2026-09-20T21:06:17","date_gmt":"2026-09-20T21:06:17","guid":{"rendered":"https:\/\/1phantram.com\/blog\/cach-tao-bang-tinh-lai-kep-bang-excel\/"},"modified":"2026-09-20T21:06:17","modified_gmt":"2026-09-20T21:06:17","slug":"cach-tao-bang-tinh-lai-kep-bang-excel","status":"publish","type":"post","link":"https:\/\/1phantram.com\/blog\/cach-tao-bang-tinh-lai-kep-bang-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p b\u1eb1ng Excel t\u1eeb A-Z"},"content":{"rendered":"<p>L\u00e3i k\u00e9p l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap gia t\u0103ng t\u00e0i s\u1ea3n theo th\u1eddi gian. Vi\u1ec7c t\u1ef1 t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p b\u1eb1ng Excel kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 b\u1ea3n ch\u1ea5t c\u1ee7a n\u00f3 m\u00e0 c\u00f2n cho ph\u00e9p t\u00f9y ch\u1ec9nh c\u00e1c bi\u1ebfn s\u1ed1 theo nhu c\u1ea7u c\u00e1 nh\u00e2n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n t\u1eebng b\u01b0\u1edbc, t\u1eeb c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n \u0111\u1ebfn vi\u1ec7c x\u00e2y d\u1ef1ng m\u1ed9t b\u1ea3ng t\u00ednh tr\u1ef1c quan v\u00e0 chuy\u00ean nghi\u1ec7p.<\/p><h2>C\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p trong Excel (H\u00e0m FV)<\/h2><p>Excel cung c\u1ea5p m\u1ed9t h\u00e0m m\u1ea1nh m\u1ebd v\u00e0 ti\u1ec7n l\u1ee3i \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a m\u1ed9t kho\u1ea3n \u0111\u1ea7u t\u01b0 d\u1ef1a tr\u00ean l\u00e3i su\u1ea5t c\u1ed1 \u0111\u1ecbnh: h\u00e0m <strong>FV<\/strong> (Future Value &#8211; Gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai). C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t c\u1ee7a h\u00e0m FV l\u00e0: <code>=FV(rate, nper, pmt, [pv], [type])<\/code>.<\/p><ul><li><strong>rate<\/strong>: L\u00e3i su\u1ea5t m\u1ed7i k\u1ef3 (v\u00ed d\u1ee5: l\u00e3i su\u1ea5t n\u0103m 8%, t\u00ednh theo th\u00e1ng th\u00ec rate = 8%\/12).<\/li><li><strong>nper<\/strong>: T\u1ed5ng s\u1ed1 k\u1ef3 thanh to\u00e1n (s\u1ed1 th\u00e1ng ho\u1eb7c s\u1ed1 n\u0103m \u0111\u1ea7u t\u01b0).<\/li><li><strong>pmt<\/strong>: S\u1ed1 ti\u1ec1n g\u00f3p th\u00eam \u0111\u1ec1u \u0111\u1eb7n m\u1ed7i k\u1ef3 (n\u1ebfu kh\u00f4ng c\u00f3, nh\u1eadp 0).<\/li><li><strong>pv<\/strong>: Gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i, s\u1ed1 v\u1ed1n ban \u0111\u1ea7u (n\u1ebfu l\u00e0 kho\u1ea3n \u0111\u1ea7u t\u01b0, nh\u1eadp s\u1ed1 \u00e2m).<\/li><li><strong>type<\/strong>: Th\u1eddi \u0111i\u1ec3m thanh to\u00e1n (0 = cu\u1ed1i k\u1ef3, 1 = \u0111\u1ea7u k\u1ef3, th\u01b0\u1eddng \u0111\u1ec3 m\u1eb7c \u0111\u1ecbnh 0).<\/li><\/ul><h3>V\u00ed d\u1ee5 minh h\u1ecda v\u1edbi h\u00e0m FV<\/h3><p>Gi\u1ea3 s\u1eed b\u1ea1n \u0111\u1ea7u t\u01b0 100 tri\u1ec7u \u0111\u1ed3ng (PV) v\u1edbi l\u00e3i su\u1ea5t 7%\/n\u0103m trong 10 n\u0103m, kh\u00f4ng g\u00f3p th\u00eam h\u00e0ng th\u00e1ng. C\u00f4ng th\u1ee9c s\u1ebd l\u00e0: <code>=FV(7%, 10, 0, -100000000)<\/code>. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 kho\u1ea3ng <strong>196,715,135 VN\u0110<\/strong>. L\u01b0u \u00fd, s\u1ed1 v\u1ed1n ban \u0111\u1ea7u nh\u1eadp \u00e2m \u0111\u1ec3 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 d\u01b0\u01a1ng th\u1ec3 hi\u1ec7n s\u1ed1 ti\u1ec1n b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c trong t\u01b0\u01a1ng lai.<\/p><h2>H\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc t\u1ea1o b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p<\/h2><p>\u0110\u1ec3 c\u00f3 c\u00e1i nh\u00ecn tr\u1ef1c quan theo t\u1eebng n\u0103m, b\u1ea1n n\u00ean x\u00e2y d\u1ef1ng m\u1ed9t b\u1ea3ng t\u00ednh chi ti\u1ebft. Quy tr\u00ecnh th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p><ol><li><strong>Thi\u1ebft l\u1eadp c\u00e1c \u00f4 tham s\u1ed1 \u0111\u1ea7u v\u00e0o:<\/strong> T\u1ea1o m\u1ed9t khu v\u1ef1c ri\u00eang \u0111\u1ec3 nh\u1eadp: S\u1ed1 v\u1ed1n ban \u0111\u1ea7u, L\u00e3i su\u1ea5t h\u00e0ng n\u0103m, S\u1ed1 n\u0103m \u0111\u1ea7u t\u01b0, S\u1ed1 ti\u1ec1n g\u00f3p th\u00eam h\u00e0ng n\u0103m (n\u1ebfu c\u00f3).<\/li><li><strong>T\u1ea1o c\u1ea5u tr\u00fac b\u1ea3ng t\u00ednh:<\/strong> L\u1eadp m\u1ed9t b\u1ea3ng v\u1edbi c\u00e1c c\u1ed9t: N\u0103m, S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3, Ti\u1ec1n l\u00e3i ki\u1ebfm \u0111\u01b0\u1ee3c, Ti\u1ec1n g\u00f3p th\u00eam (n\u1ebfu c\u00f3), T\u1ed5ng s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3.<\/li><li><strong>\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c cho h\u00e0ng \u0111\u1ea7u ti\u00ean:<\/strong><ul><li>S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 n\u0103m 1 = V\u1ed1n ban \u0111\u1ea7u.<\/li><li>Ti\u1ec1n l\u00e3i = S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 * L\u00e3i su\u1ea5t.<\/li><li>T\u1ed5ng s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 = S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 + Ti\u1ec1n l\u00e3i + Ti\u1ec1n g\u00f3p th\u00eam.<\/li><\/ul><\/li><li><strong>Sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c n\u0103m ti\u1ebfp theo:<\/strong> S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 n\u0103m sau ch\u00ednh l\u00e0 T\u1ed5ng s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 c\u1ee7a n\u0103m tr\u01b0\u1edbc. K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng cho \u0111\u1ebfn n\u0103m cu\u1ed1i c\u00f9ng.<\/li><\/ol><h3>B\u1ea3ng t\u00ednh l\u00e3i k\u00e9p m\u1eabu (5 n\u0103m \u0111\u1ea7u)<\/h3><table><thead><tr><th>N\u0103m<\/th><th>S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 (VN\u0110)<\/th><th>Ti\u1ec1n l\u00e3i (7%\/n\u0103m)<\/th><th>T\u1ed5ng s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 (VN\u0110)<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>100,000,000<\/td><td>7,000,000<\/td><td>107,000,000<\/td><\/tr><tr><td>2<\/td><td>107,000,000<\/td><td>7,490,000<\/td><td>114,490,000<\/td><\/tr><tr><td>3<\/td><td>114,490,000<\/td><td>8,014,300<\/td><td>122,504,300<\/td><\/tr><tr><td>4<\/td><td>122,504,300<\/td><td>8,575,301<\/td><td>131,079,601<\/td><\/tr><tr><td>5<\/td><td>131,079,601<\/td><td>9,175,572<\/td><td>140,255,173<\/td><\/tr><\/tbody><\/table><h2>\u01afu nh\u01b0\u1ee3c \u0111i\u1ec3m so v\u1edbi d\u00f9ng c\u00f4ng c\u1ee5 online<\/h2><p>Vi\u1ec7c s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh l\u00e3i k\u00e9p c\u00f3 nh\u1eefng \u0111i\u1ec3m kh\u00e1c bi\u1ec7t r\u00f5 r\u1ec7t so v\u1edbi c\u00e1c c\u00f4ng c\u1ee5 t\u00ednh online.<\/p><h3>\u01afu \u0111i\u1ec3m c\u1ee7a Excel<\/h3><ul><li><strong>Linh ho\u1ea1t v\u00e0 t\u00f9y bi\u1ebfn cao:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft k\u1ebf b\u1ea3ng t\u00ednh theo \u00fd mu\u1ed1n, th\u00eam c\u00e1c k\u1ecbch b\u1ea3n &#8216;what-if&#8217; (v\u00ed d\u1ee5: thay \u0111\u1ed5i l\u00e3i su\u1ea5t, ng\u1eebng g\u00f3p ti\u1ec1n gi\u1eefa ch\u1eebng).<\/li><li><strong>Kh\u00f4ng c\u1ea7n k\u1ebft n\u1ed1i internet:<\/strong> L\u00e0m vi\u1ec7c m\u1ecdi l\u00fac, m\u1ecdi n\u01a1i v\u00e0 l\u01b0u tr\u1eef c\u1ee5c b\u1ed9.<\/li><li><strong>Hi\u1ec3u s\u00e2u b\u1ea3n ch\u1ea5t:<\/strong> Qu\u00e1 tr\u00ecnh t\u1ef1 x\u00e2y d\u1ef1ng gi\u00fap b\u1ea1n n\u1eafm v\u1eefng c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng c\u1ee7a l\u00e3i k\u00e9p.<\/li><li><strong>T\u00edch h\u1ee3p v\u1edbi d\u1eef li\u1ec7u kh\u00e1c:<\/strong> C\u00f3 th\u1ec3 k\u1ebft n\u1ed1i b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p v\u1edbi k\u1ebf ho\u1ea1ch t\u00e0i ch\u00ednh t\u1ed5ng th\u1ec3 c\u1ee7a b\u1ea1n.<\/li><\/ul><h3>Nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a Excel<\/h3><ul><li><strong>C\u1ea7n ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n:<\/strong> \u0110\u00f2i h\u1ecfi ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i bi\u1ebft s\u1eed d\u1ee5ng Excel v\u00e0 c\u00f4ng th\u1ee9c.<\/li><li><strong>T\u1ed1n th\u1eddi gian thi\u1ebft l\u1eadp ban \u0111\u1ea7u:<\/strong> So v\u1edbi vi\u1ec7c ch\u1ec9 c\u1ea7n nh\u1eadp s\u1ed1 v\u00e0o website.<\/li><li><strong>D\u1ec5 m\u1eafc l\u1ed7i th\u1ee7 c\u00f4ng:<\/strong> N\u1ebfu c\u00f4ng th\u1ee9c sai, k\u1ebft qu\u1ea3 s\u1ebd kh\u00f4ng ch\u00ednh x\u00e1c.<\/li><li><strong>Giao di\u1ec7n \u00edt tr\u1ef1c quan h\u01a1n:<\/strong> C\u00e1c c\u00f4ng c\u1ee5 online th\u01b0\u1eddng c\u00f3 bi\u1ec3u \u0111\u1ed3 \u0111\u1eb9p v\u00e0 d\u1ec5 chia s\u1ebb ngay.<\/li><\/ul><h2>L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi t\u00ednh l\u00e3i k\u00e9p b\u1eb1ng Excel<\/h2><p>Trong qu\u00e1 tr\u00ecnh t\u1ef1 t\u1ea1o b\u1ea3ng t\u00ednh, m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn c\u00f3 th\u1ec3 x\u1ea3y ra \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn k\u1ebft qu\u1ea3.<\/p><h3>L\u1ed7i v\u1ec1 \u0111\u01a1n v\u1ecb t\u00ednh (l\u00e3i su\u1ea5t v\u00e0 k\u1ef3 h\u1ea1n)<\/h3><p>\u0110\u00e2y l\u00e0 l\u1ed7i ph\u1ed5 bi\u1ebfn nh\u1ea5t. N\u1ebfu b\u1ea1n nh\u1eadp l\u00e3i su\u1ea5t 8% cho k\u1ef3 h\u1ea1n n\u0103m nh\u01b0ng s\u1ed1 k\u1ef3 (<code>nper<\/code>) l\u1ea1i nh\u1eadp l\u00e0 s\u1ed1 th\u00e1ng (v\u00ed d\u1ee5 120 th\u00e1ng cho 10 n\u0103m) th\u00ec k\u1ebft qu\u1ea3 s\u1ebd sai l\u1ec7ch nghi\u00eam tr\u1ecdng. Lu\u00f4n \u0111\u1ea3m b\u1ea3o <strong>rate<\/strong> v\u00e0 <strong>nper<\/strong> c\u00f9ng \u0111\u01a1n v\u1ecb th\u1eddi gian (c\u00f9ng theo n\u0103m ho\u1eb7c c\u00f9ng theo th\u00e1ng).<\/p><h3>Qu\u00ean nh\u1eadp s\u1ed1 \u00e2m cho d\u00f2ng ti\u1ec1n ra<\/h3><p>Trong h\u00e0m FV, c\u00e1c kho\u1ea3n b\u1ea1n b\u1ecf ra (nh\u01b0 v\u1ed1n \u0111\u1ea7u t\u01b0 ban \u0111\u1ea7u <code>pv<\/code>) c\u1ea7n \u0111\u01b0\u1ee3c nh\u1eadp l\u00e0 s\u1ed1 \u00e2m \u0111\u1ec3 th\u1ec3 hi\u1ec7n \u0111\u00f3 l\u00e0 d\u00f2ng ti\u1ec1n ra. N\u1ebfu nh\u1eadp s\u1ed1 d\u01b0\u01a1ng, k\u1ebft qu\u1ea3 s\u1ebd ra s\u1ed1 \u00e2m, g\u00e2y nh\u1ea7m l\u1eabn.<\/p><h3>Sai logic trong b\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng<\/h3><p>Khi x\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh theo t\u1eebng k\u1ef3, l\u1ed7i th\u01b0\u1eddng n\u1eb1m \u1edf vi\u1ec7c tham chi\u1ebfu \u00f4 kh\u00f4ng ch\u00ednh x\u00e1c. V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c t\u00ednh &#8216;S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3&#8217; n\u0103m th\u1ee9 2 kh\u00f4ng \u0111\u01b0\u1ee3c tham chi\u1ebfu \u0111\u1ebfn &#8216;T\u1ed5ng s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3&#8217; n\u0103m th\u1ee9 1. H\u00e3y ki\u1ec3m tra k\u1ef9 c\u00e1c c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch t\u00ednh th\u1eed m\u1ed9t v\u00e0i d\u00f2ng b\u1eb1ng tay.<\/p>\n<h2>M\u1edf r\u1ed9ng \u1ee9ng d\u1ee5ng: C\u00e1c t\u00ecnh hu\u1ed1ng t\u00ednh l\u00e3i k\u00e9p n\u00e2ng cao<\/h2>\n<p>Sau khi \u0111\u00e3 n\u1eafm v\u1eefng c\u00e1ch t\u1ea1o b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p c\u01a1 b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng nguy\u00ean l\u00fd n\u00e0y v\u00e0o nhi\u1ec1u k\u1ecbch b\u1ea3n t\u00e0i ch\u00ednh ph\u1ee9c t\u1ea1p h\u01a1n trong \u0111\u1eddi s\u1ed1ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh:<\/p>\n<ul>\n<li><strong>K\u1ebf ho\u1ea1ch \u0111\u1ea7u t\u01b0 \u0111\u1ecbnh k\u1ef3 bi\u1ebfn \u0111\u1ed5i:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n d\u1ef1 \u0111\u1ecbnh m\u1ed7i n\u0103m t\u0103ng s\u1ed1 ti\u1ec1n g\u00f3p th\u00eam l\u00ean 10% so v\u1edbi n\u0103m tr\u01b0\u1edbc. B\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t c\u1ed9t ri\u00eang bi\u1ec7t cho <em>&#8220;S\u1ed1 ti\u1ec1n g\u00f3p th\u00eam h\u00e0ng n\u0103m&#8221;<\/em> v\u1edbi c\u00f4ng th\u1ee9c nh\u00e2n d\u1ea7n, sau \u0111\u00f3 s\u1eed d\u1ee5ng s\u1ed1 ti\u1ec1n thay \u0111\u1ed5i n\u00e0y trong c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3.<\/li>\n<li><strong>\u0110\u1ea7u t\u01b0 m\u1ed9t l\u1ea7n v\u00e0 r\u00fat ti\u1ec1n \u0111\u1ecbnh k\u1ef3 (FIRE &#8211; \u0110\u1ed9c l\u1eadp t\u00e0i ch\u00ednh ngh\u1ec9 h\u01b0u s\u1edbm):<\/strong> B\u1ea1n c\u00f3 m\u1ed9t kho\u1ea3n ti\u1ec1n l\u1edbn ban \u0111\u1ea7u v\u00e0 mu\u1ed1n r\u00fat m\u1ed9t s\u1ed1 ti\u1ec1n c\u1ed1 \u0111\u1ecbnh h\u00e0ng n\u0103m \u0111\u1ec3 chi ti\u00eau. L\u00fac n\u00e0y, s\u1ed1 ti\u1ec1n g\u00f3p th\u00eam h\u00e0ng k\u1ef3 s\u1ebd l\u00e0 s\u1ed1 \u00e2m (d\u00f2ng ti\u1ec1n ra). B\u1ea1n c\u1ea7n theo d\u00f5i xem v\u1edbi l\u00e3i su\u1ea5t k\u00e9p hi\u1ec7n t\u1ea1i, s\u1ed1 ti\u1ec1n g\u1ed1c \u0111\u00f3 s\u1ebd k\u00e9o d\u00e0i \u0111\u01b0\u1ee3c trong bao nhi\u00eau n\u0103m.<\/li>\n<li><strong>T\u00ednh l\u00e3i k\u00e9p v\u1edbi l\u00e3i su\u1ea5t thay \u0111\u1ed5i theo t\u1eebng giai \u0111o\u1ea1n:<\/strong> Trong d\u00e0i h\u1ea1n, l\u00e3i su\u1ea5t \u0111\u1ea7u t\u01b0 hi\u1ebfm khi c\u1ed1 \u0111\u1ecbnh. B\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft k\u1ebf b\u1ea3ng t\u00ednh c\u00f3 nhi\u1ec1u giai \u0111o\u1ea1n, m\u1ed7i giai \u0111o\u1ea1n \u00e1p d\u1ee5ng m\u1ed9t m\u1ee9c l\u00e3i su\u1ea5t kh\u00e1c nhau (v\u00ed d\u1ee5: 5 n\u0103m \u0111\u1ea7u 8%\/n\u0103m, 5 n\u0103m sau 6%\/n\u0103m).<\/li>\n<\/ul>\n\n<h3>So s\u00e1nh k\u1ebft qu\u1ea3: H\u00e0m FV vs B\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng<\/h3>\n<p>Vi\u1ec7c so s\u00e1nh k\u1ebft qu\u1ea3 t\u1eeb hai ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c nhau l\u00e0 b\u01b0\u1edbc <strong>ki\u1ec3m tra ch\u00e9o<\/strong> quan tr\u1ecdng \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ea3ng so s\u00e1nh chi ti\u1ebft gi\u1eefa vi\u1ec7c d\u00f9ng h\u00e0m FV v\u00e0 t\u1ea1o b\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng chi ti\u1ebft t\u1eebng n\u0103m.<\/p>\n<table>\n<thead>\n<tr>\n<th>Ti\u00eau ch\u00ed<\/th>\n<th>S\u1eed d\u1ee5ng H\u00e0m FV<\/th>\n<th>B\u1ea3ng T\u00ednh Th\u1ee7 C\u00f4ng (T\u1eebng k\u1ef3)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>M\u1ee5c \u0111\u00edch ch\u00ednh<\/strong><\/td>\n<td>T\u00ednh nhanh t\u1ed5ng gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai t\u1ea1i m\u1ed9t th\u1eddi \u0111i\u1ec3m c\u1ee5 th\u1ec3.<\/td>\n<td>Theo d\u00f5i chi ti\u1ebft di\u1ec5n bi\u1ebfn s\u1ed1 d\u01b0, l\u00e3i su\u1ea5t, ti\u1ec1n g\u00f3p qua t\u1eebng k\u1ef3.<\/td>\n<\/tr>\n<tr>\n<td><strong>\u0110\u1ed9 chi ti\u1ebft<\/strong><\/td>\n<td>Ch\u1ec9 cho ra k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng.<\/td>\n<td>Hi\u1ec3n th\u1ecb \u0111\u1ea7y \u0111\u1ee7 qu\u00e1 tr\u00ecnh ph\u00e1t tri\u1ec3n c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0 theo th\u1eddi gian.<\/td>\n<\/tr>\n<tr>\n<td><strong>Linh ho\u1ea1t<\/strong><\/td>\n<td>Kh\u00f3 \u0111i\u1ec1u ch\u1ec9nh n\u1ebfu c\u00e1c bi\u1ebfn s\u1ed1 (nh\u01b0 s\u1ed1 ti\u1ec1n g\u00f3p) thay \u0111\u1ed5i theo t\u1eebng n\u0103m.<\/td>\n<td>D\u1ec5 d\u00e0ng t\u00f9y ch\u1ec9nh cho c\u00e1c k\u1ecbch b\u1ea3n ph\u1ee9c t\u1ea1p, bi\u1ebfn \u0111\u1ed9ng.<\/td>\n<\/tr>\n<tr>\n<td><strong>Ki\u1ec3m tra &amp; G\u1ee1 l\u1ed7i<\/strong><\/td>\n<td>Kh\u00f3 ph\u00e1t hi\u1ec7n l\u1ed7i n\u1ebfu nh\u1eadp sai tham s\u1ed1.<\/td>\n<td>D\u1ec5 d\u00e0ng ki\u1ec3m tra t\u1eebng d\u00f2ng, ph\u00e1t hi\u1ec7n sai s\u00f3t trong logic t\u00ednh to\u00e1n.<\/td>\n<\/tr>\n<tr>\n<td><strong>Ph\u00f9 h\u1ee3p nh\u1ea5t cho<\/strong><\/td>\n<td>\u01af\u1edbc t\u00ednh nhanh, so s\u00e1nh c\u00e1c ph\u01b0\u01a1ng \u00e1n \u0111\u1ea7u t\u01b0 \u0111\u01a1n gi\u1ea3n.<\/td>\n<td>L\u1eadp k\u1ebf ho\u1ea1ch t\u00e0i ch\u00ednh c\u00e1 nh\u00e2n chi ti\u1ebft, minh b\u1ea1ch v\u00e0 d\u1ec5 hi\u1ec3u.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>L\u1eddi khuy\u00ean: H\u00e3y s\u1eed d\u1ee5ng <strong>c\u1ea3 hai ph\u01b0\u01a1ng ph\u00e1p<\/strong> song song. D\u00f9ng h\u00e0m FV \u0111\u1ec3 c\u00f3 con s\u1ed1 t\u1ed5ng nhanh ch\u00f3ng, sau \u0111\u00f3 d\u00f9ng b\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng \u0111\u1ec3 ki\u1ec3m ch\u1ee9ng l\u1ea1i k\u1ebft qu\u1ea3 c\u1ee7a n\u0103m cu\u1ed1i c\u00f9ng. N\u1ebfu hai s\u1ed1 li\u1ec7u kh\u1edbp nhau, b\u1ea1n c\u00f3 th\u1ec3 ho\u00e0n to\u00e0n tin t\u01b0\u1edfng v\u00e0o m\u00f4 h\u00ecnh c\u1ee7a m\u00ecnh.<\/p>\n\n<h3>Nh\u1eefng sai l\u1ea7m tinh vi c\u1ea7n tr\u00e1nh khi t\u1ef1 x\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh<\/h3>\n<p>Ngo\u00e0i c\u00e1c l\u1ed7i c\u01a1 b\u1ea3n v\u1ec1 \u0111\u01a1n v\u1ecb, vi\u1ec7c x\u00e2y d\u1ef1ng m\u1ed9t m\u00f4 h\u00ecnh l\u00e3i k\u00e9p ph\u1ee9c t\u1ea1p c\u00f3 th\u1ec3 m\u1eafc ph\u1ea3i nh\u1eefng sai s\u00f3t kh\u00f3 nh\u1eadn ra ngay l\u1eadp t\u1ee9c.<\/p>\n<h4>Sai l\u1ec7ch v\u1ec1 th\u1eddi \u0111i\u1ec3m t\u00ednh l\u00e3i v\u00e0 g\u00f3p ti\u1ec1n<\/h4>\n<p>\u0110\u00e2y l\u00e0 l\u1ed7i ph\u1ed5 bi\u1ebfn nh\u1ea5t. B\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh r\u00f5: Ti\u1ec1n l\u00e3i \u0111\u01b0\u1ee3c t\u00ednh <em>cu\u1ed1i k\u1ef3<\/em> hay <em>\u0111\u1ea7u k\u1ef3<\/em>? S\u1ed1 ti\u1ec1n b\u1ea1n g\u00f3p th\u00eam \u0111\u01b0\u1ee3c th\u00eam v\u00e0o <em>tr\u01b0\u1edbc khi t\u00ednh l\u00e3i cho k\u1ef3 \u0111\u00f3<\/em> hay <em>sau khi k\u1ef3 \u0111\u00f3 k\u1ebft th\u00fac<\/em>? M\u1ed9t b\u1ea3ng t\u00ednh cho k\u1ebft qu\u1ea3 r\u1ea5t kh\u00e1c n\u1ebfu b\u1ea1n nh\u1ea7m l\u1eabn gi\u1eefa &#8220;g\u00f3p ti\u1ec1n \u0111\u1ea7u n\u0103m&#8221; v\u00e0 &#8220;g\u00f3p ti\u1ec1n cu\u1ed1i n\u0103m&#8221;. H\u00e3y nh\u1ea5t qu\u00e1n m\u1ed9t logic t\u1eeb \u0111\u1ea7u \u0111\u1ebfn cu\u1ed1i.<\/p>\n<h4>B\u1ecf qua y\u1ebfu t\u1ed1 l\u1ea1m ph\u00e1t trong k\u1ebf ho\u1ea1ch d\u00e0i h\u1ea1n<\/h4>\n<p>M\u1ed9t kho\u1ea3n ti\u1ec1n 5 t\u1ef7 sau 30 n\u0103m c\u00f3 gi\u00e1 tr\u1ecb mua s\u1eafm kh\u00e1c xa so v\u1edbi 5 t\u1ef7 \u1edf hi\u1ec7n t\u1ea1i. Nhi\u1ec1u ng\u01b0\u1eddi h\u00e0o h\u1ee9ng v\u1edbi con s\u1ed1 tuy\u1ec7t \u0111\u1ed1i l\u1edbn t\u1eeb l\u00e3i k\u00e9p m\u00e0 qu\u00ean \u0111i s\u1ef1 b\u00e0o m\u00f2n c\u1ee7a l\u1ea1m ph\u00e1t. \u0110\u1ec3 c\u00f3 c\u00e1i nh\u00ecn th\u1ef1c t\u1ebf, b\u1ea1n n\u00ean t\u1ea1o th\u00eam m\u1ed9t c\u1ed9t t\u00ednh <strong>&#8220;Gi\u00e1 tr\u1ecb th\u1ef1c&#8221; (Real Value)<\/strong> b\u1eb1ng c\u00e1ch chi\u1ebft kh\u1ea5u t\u1ed5ng gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai theo t\u1ef7 l\u1ec7 l\u1ea1m ph\u00e1t d\u1ef1 ki\u1ebfn.<\/p>\n<h4>\u00c1p d\u1ee5ng l\u00e3i su\u1ea5t kh\u00f4ng th\u1ef1c t\u1ebf<\/h4>\n<p>Vi\u1ec7c l\u1ea1c quan qu\u00e1 m\u1ee9c v\u1edbi m\u1ed9t m\u1ee9c l\u00e3i su\u1ea5t cao c\u1ed1 \u0111\u1ecbnh trong 20-30 n\u0103m (v\u00ed d\u1ee5 15%\/n\u0103m) s\u1ebd d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 \u1ea3o. Thay v\u00e0o \u0111\u00f3, h\u00e3y s\u1eed d\u1ee5ng nhi\u1ec1u k\u1ecbch b\u1ea3n (<em>Scenario Analysis<\/em>): l\u1ea1c quan (l\u00e3i su\u1ea5t cao), trung b\u00ecnh v\u00e0 th\u1eadn tr\u1ecdng (l\u00e3i su\u1ea5t th\u1ea5p). \u0110i\u1ec1u n\u00e0y cho b\u1ea1n m\u1ed9t ph\u1ea1m vi k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 x\u1ea3y ra, gi\u00fap l\u1eadp k\u1ebf ho\u1ea1ch v\u1eefng ch\u1eafc h\u01a1n.<\/p>\n\n<h3>M\u1eb9o v\u00e0 th\u1ee7 thu\u1eadt \u0111\u1ec3 l\u00e0m ch\u1ee7 b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p<\/h3>\n<p>\u0110\u1ec3 t\u0103ng t\u1ed1c v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ngay nh\u1eefng m\u1eb9o nh\u1ecf sau \u0111\u00e2y.<\/p>\n<ul>\n<li><strong>S\u1eed d\u1ee5ng Data Table cho ph\u00e2n t\u00edch \u0111\u1ed9 nh\u1ea1y:<\/strong> Thay v\u00ec thay \u0111\u1ed5i th\u1ee7 c\u00f4ng l\u00e3i su\u1ea5t hay s\u1ed1 ti\u1ec1n g\u00f3p \u0111\u1ec3 xem k\u1ebft qu\u1ea3, h\u00e3y d\u00f9ng t\u00ednh n\u0103ng <strong>Data Table (B\u1ea3ng D\u1eef li\u1ec7u)<\/strong> trong Excel. B\u1ea1n c\u00f3 th\u1ec3 l\u1eadp t\u1ee9c th\u1ea5y \u0111\u01b0\u1ee3c t\u1ed5ng gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai thay \u0111\u1ed5i th\u1ebf n\u00e0o khi l\u00e3i su\u1ea5t bi\u1ebfn \u0111\u1ed9ng t\u1eeb 5% \u0111\u1ebfn 12%, ho\u1eb7c khi s\u1ed1 ti\u1ec1n g\u00f3p h\u00e0ng th\u00e1ng thay \u0111\u1ed5i.<\/li>\n<li><strong>T\u1ea1o c\u00e1c \u00f4 nh\u1eadp li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean (Named Range):<\/strong> Thay v\u00ec tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 r\u1eddi r\u1ea1c nh\u01b0 B2, C3, h\u00e3y \u0111\u1eb7t t\u00ean cho ch\u00fang nh\u01b0 &#8220;LaiSuatNam&#8221;, &#8220;TienGopHangThang&#8221;, &#8220;SoNam&#8221;. C\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd tr\u1edf n\u00ean r\u00f5 r\u00e0ng h\u01a1n: <code>=FV(LaiSuatNam\/12, SoNam*12, -TienGopHangThang, -TienGocBanDau)<\/code>. \u0110i\u1ec1u n\u00e0y gi\u00fap ki\u1ec3m so\u00e1t v\u00e0 ch\u1ec9nh s\u1eeda m\u00f4 h\u00ecnh d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u.<\/li>\n<li><strong>Li\u00ean k\u1ebft v\u1edbi Google Sheets \u0111\u1ec3 c\u1eadp nh\u1eadt m\u1ecdi l\u00fac m\u1ecdi n\u01a1i:<\/strong> N\u1ebfu b\u1ea1n mu\u1ed1n theo d\u00f5i v\u00e0 ch\u1ec9nh s\u1eeda k\u1ebf ho\u1ea1ch tr\u00ean c\u1ea3 \u0111i\u1ec7n tho\u1ea1i v\u00e0 m\u00e1y t\u00ednh, h\u00e3y t\u1ea1o b\u1ea3ng t\u00ednh tr\u00ean Google Sheets. C\u00e1c h\u00e0m c\u01a1 b\u1ea3n nh\u01b0 FV ho\u00e0n to\u00e0n t\u01b0\u01a1ng th\u00edch. B\u1ea1n c\u00f3 th\u1ec3 chia s\u1ebb b\u1ea3ng t\u00ednh v\u1edbi ng\u01b0\u1eddi th\u00e2n \u0111\u1ec3 c\u00f9ng l\u1eadp k\u1ebf ho\u1ea1ch t\u00e0i ch\u00ednh gia \u0111\u00ecnh.<\/li>\n<li><strong>D\u00f9ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c m\u1ed1c quan tr\u1ecdng:<\/strong> H\u00e3y thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n (<em>Conditional Formatting<\/em>) \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng t\u00f4 m\u00e0u d\u00f2ng khi s\u1ed1 d\u01b0 v\u01b0\u1ee3t qua m\u1ed9t ng\u01b0\u1ee1ng m\u1ee5c ti\u00eau (v\u00ed d\u1ee5: 1 t\u1ef7, 5 t\u1ef7). \u0110i\u1ec1u n\u00e0y t\u1ea1o \u0111\u1ed9ng l\u1ef1c tr\u1ef1c quan v\u00e0 gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng theo d\u00f5i ti\u1ebfn \u0111\u1ed9.<\/li>\n<\/ul>\n\n<h3>G\u00f3c nh\u00ecn th\u1ef1c t\u1ebf: T\u1eeb b\u1ea3ng t\u00ednh Excel \u0111\u1ebfn h\u00e0nh \u0111\u1ed9ng c\u1ee5 th\u1ec3<\/h3>\n<p>S\u1ee9c m\u1ea1nh th\u1ef1c s\u1ef1 c\u1ee7a b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p kh\u00f4ng n\u1eb1m \u1edf nh\u1eefng con s\u1ed1, m\u00e0 n\u1eb1m \u1edf <strong>s\u1ef1 thay \u0111\u1ed5i trong t\u01b0 duy v\u00e0 h\u00e0nh vi t\u00e0i ch\u00ednh<\/strong> m\u00e0 n\u00f3 mang l\u1ea1i.<\/p>\n<blockquote>\n<p>Khi b\u1ea1n nh\u00ecn th\u1ea5y r\u00f5 r\u00e0ng r\u1eb1ng ch\u1ec9 c\u1ea7n b\u1eaft \u0111\u1ea7u v\u1edbi 5 tri\u1ec7u \u0111\u1ed3ng m\u1ed7i th\u00e1ng, ki\u00ean tr\u00ec trong 30 n\u0103m v\u1edbi l\u00e3i su\u1ea5t 10%\/n\u0103m, b\u1ea1n s\u1ebd c\u00f3 m\u1ed9t gia t\u00e0i h\u01a1n 11 t\u1ef7 \u0111\u1ed3ng, b\u1ea1n s\u1ebd c\u00f3 \u0111\u1ed9ng l\u1ef1c \u0111\u1ec3 <em>b\u1eaft \u0111\u1ea7u ngay h\u00f4m nay<\/em> ch\u1ee9 kh\u00f4ng ph\u1ea3i ch\u1edd \u0111\u1ee3i.<\/p>\n<\/blockquote>\n<p>B\u1ea3ng t\u00ednh gi\u00fap b\u1ea1n tr\u1ea3 l\u1eddi c\u00e1c c\u00e2u h\u1ecfi th\u1ef1c t\u1ebf: &#8220;N\u1ebfu t\u00f4i t\u0103ng s\u1ed1 ti\u1ec1n ti\u1ebft ki\u1ec7m h\u00e0ng th\u00e1ng l\u00ean th\u00eam 1 tri\u1ec7u, t\u00f4i s\u1ebd v\u1ec1 h\u01b0u s\u1edbm \u0111\u01b0\u1ee3c bao nhi\u00eau n\u0103m?&#8221;, &#8220;T\u00e1c \u0111\u1ed9ng c\u1ee7a vi\u1ec7c b\u1eaft \u0111\u1ea7u \u0111\u1ea7u t\u01b0 mu\u1ed9n 5 n\u0103m l\u00e0 l\u1edbn c\u1ee1 n\u00e0o?&#8221;. N\u00f3 bi\u1ebfn nh\u1eefng kh\u00e1i ni\u1ec7m tr\u1eebu t\u01b0\u1ee3ng v\u1ec1 ti\u1ec1n b\u1ea1c th\u00e0nh m\u1ed9t l\u1ed9 tr\u00ecnh s\u1ed1 h\u00f3a, \u0111o l\u01b0\u1eddng \u0111\u01b0\u1ee3c. H\u00e3y coi b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n nh\u01b0 m\u1ed9t &#8220;b\u1ea3n \u0111\u1ed3 kho b\u00e1u&#8221; c\u00e1 nh\u00e2n, n\u01a1i b\u1ea1n ch\u00ednh l\u00e0 ng\u01b0\u1eddi v\u1ebd ra con \u0111\u01b0\u1eddng v\u00e0 ki\u00ean tr\u00ec \u0111i theo n\u00f3, v\u1edbi s\u1ef1 tr\u1ee3 gi\u00fap \u0111\u1eafc l\u1ef1c c\u1ee7a s\u1ee9c m\u1ea1nh l\u00e3i k\u00e9p.<\/p>\n<h2>Ph\u00e2n T\u00edch Chi Ti\u1ebft C\u00e1c Th\u00e0nh Ph\u1ea7n Trong M\u00f4 H\u00ecnh L\u00e3i K\u00e9p<\/h2>\n<p>\u0110\u1ec3 x\u00e2y d\u1ef1ng m\u1ed9t b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p m\u1ea1nh m\u1ebd v\u00e0 linh ho\u1ea1t, vi\u1ec7c hi\u1ec3u r\u00f5 t\u1eebng th\u00e0nh ph\u1ea7n v\u00e0 c\u00e1ch ch\u00fang t\u01b0\u01a1ng t\u00e1c l\u00e0 v\u00f4 c\u00f9ng quan tr\u1ecdng. M\u1ed9t m\u00f4 h\u00ecnh t\u1ed1t kh\u00f4ng ch\u1ec9 cho ra k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng m\u00e0 c\u00f2n cho ph\u00e9p b\u1ea1n ph\u00e2n t\u00edch \u0111\u1ed9 nh\u1ea1y v\u00e0 t\u00e1c \u0111\u1ed9ng c\u1ee7a t\u1eebng y\u1ebfu t\u1ed1.<\/p>\n\n<h3>B\u1ea3ng Ph\u00e2n T\u00edch \u0110\u1ed9 Nh\u1ea1y C\u1ee7a L\u00e3i Su\u1ea5t V\u00e0 Th\u1eddi Gian<\/h3>\n<p>M\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng m\u1ea1nh m\u1ebd nh\u1ea5t c\u1ee7a Excel l\u00e0 kh\u1ea3 n\u0103ng t\u1ea1o b\u1ea3ng ph\u00e2n t\u00edch \u0111\u1ed9 nh\u1ea1y (Data Table). B\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng quan s\u00e1t s\u1ef1 thay \u0111\u1ed5i c\u1ee7a s\u1ed1 ti\u1ec1n t\u01b0\u01a1ng lai khi l\u00e3i su\u1ea5t v\u00e0 th\u1eddi gian \u0111\u1ea7u t\u01b0 bi\u1ebfn \u0111\u1ed9ng.<\/p>\n<table>\n<thead>\n<tr><th>L\u00e3i Su\u1ea5t\/N\u0103m<\/th><th>5 N\u0103m<\/th><th>10 N\u0103m<\/th><th>15 N\u0103m<\/th><th>20 N\u0103m<\/th><th>25 N\u0103m<\/th><\/tr>\n<\/thead>\n<tbody>\n<tr><td>6%<\/td><td>1.338.230 VN\u0110<\/td><td>1.790.848 VN\u0110<\/td><td>2.396.558 VN\u0110<\/td><td>3.207.135 VN\u0110<\/td><td>4.291.871 VN\u0110<\/td><\/tr>\n<tr><td>8%<\/td><td>1.469.328 VN\u0110<\/td><td>2.158.925 VN\u0110<\/td><td>3.172.169 VN\u0110<\/td><td>4.660.957 VN\u0110<\/td><td>6.848.475 VN\u0110<\/td><\/tr>\n<tr><td>10%<\/td><td>1.610.510 VN\u0110<\/td><td>2.593.742 VN\u0110<\/td><td>4.177.248 VN\u0110<\/td><td>6.727.500 VN\u0110<\/td><td>10.834.706 VN\u0110<\/td><\/tr>\n<tr><td>12%<\/td><td>1.762.342 VN\u0110<\/td><td>3.105.848 VN\u0110<\/td><td>5.473.566 VN\u0110<\/td><td>9.646.293 VN\u0110<\/td><td>17.000.064 VN\u0110<\/td><\/tr>\n<\/tbody>\n<\/table>\n<p><em>Gi\u1ea3 \u0111\u1ecbnh s\u1ed1 ti\u1ec1n g\u1ed1c ban \u0111\u1ea7u l\u00e0 1.000.000 VN\u0110, kh\u00f4ng c\u00f3 g\u00f3p th\u00eam h\u00e0ng k\u1ef3. B\u1ea3ng tr\u00ean minh h\u1ecda r\u00f5 r\u00e0ng s\u1ee9c m\u1ea1nh c\u1ee7a vi\u1ec7c k\u1ebft h\u1ee3p l\u00e3i su\u1ea5t cao v\u00e0 th\u1eddi gian d\u00e0i.<\/em><\/p>\n\n<h3>Quy Tr\u00ecnh 5 B\u01b0\u1edbc Ki\u1ec3m Tra V\u00e0 X\u00e1c Minh B\u1ea3ng T\u00ednh<\/h3>\n<p>Sau khi x\u00e2y d\u1ef1ng xong b\u1ea3ng t\u00ednh, \u0111\u1eebng v\u1ed9i tin v\u00e0o k\u1ebft qu\u1ea3. H\u00e3y tu\u00e2n th\u1ee7 quy tr\u00ecnh ki\u1ec3m tra sau \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c:<\/p>\n<ol>\n<li><strong>Ki\u1ec3m tra \u0111\u01a1n v\u1ecb \u0111\u1ed3ng nh\u1ea5t:<\/strong> \u0110\u1ea3m b\u1ea3o l\u00e3i su\u1ea5t v\u00e0 k\u1ef3 h\u1ea1n ph\u00f9 h\u1ee3p (v\u00ed d\u1ee5: l\u00e3i su\u1ea5t n\u0103m v\u1edbi s\u1ed1 k\u1ef3 t\u00ednh theo n\u0103m). S\u1eed d\u1ee5ng Data Validation \u0111\u1ec3 gi\u1edbi h\u1ea1n gi\u00e1 tr\u1ecb nh\u1eadp v\u00e0o.<\/li>\n<li><strong>X\u00e1c minh v\u1edbi ph\u00e9p t\u00ednh th\u1ee7 c\u00f4ng:<\/strong> Ch\u1ecdn m\u1ed9t v\u00e0i k\u1ef3 ng\u1eabu nhi\u00ean, t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 \u0111\u1ec3 so s\u00e1nh v\u1edbi k\u1ebft qu\u1ea3 Excel.<\/li>\n<li><strong>Ki\u1ec3m tra t\u00ednh logic c\u1ee7a d\u00f2ng ti\u1ec1n:<\/strong> S\u1ed1 ti\u1ec1n g\u00f3p th\u00eam (n\u1ebfu c\u00f3) ph\u1ea3i \u0111\u01b0\u1ee3c c\u1ed9ng v\u00e0o \u0111\u00fang th\u1eddi \u0111i\u1ec3m \u0111\u1ea7u k\u1ef3 ho\u1eb7c cu\u1ed1i k\u1ef3 nh\u01b0 \u0111\u00e3 thi\u1ebft l\u1eadp trong h\u00e0m FV.<\/li>\n<li><strong>Th\u1eed nghi\u1ec7m v\u1edbi c\u00e1c k\u1ecbch b\u1ea3n bi\u00ean:<\/strong> Nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1eb7c bi\u1ec7t nh\u01b0 l\u00e3i su\u1ea5t 0%, th\u1eddi gian 0 k\u1ef3, ho\u1eb7c s\u1ed1 ti\u1ec1n g\u1ed1c b\u1eb1ng 0 \u0111\u1ec3 xem b\u1ea3ng t\u00ednh c\u00f3 x\u1eed l\u00fd h\u1ee3p l\u00fd hay b\u00e1o l\u1ed7i.<\/li>\n<li><strong>So s\u00e1nh ch\u00e9o v\u1edbi c\u00f4ng c\u1ee5 \u0111\u1ed9c l\u1eadp:<\/strong> S\u1eed d\u1ee5ng m\u1ed9t m\u00e1y t\u00ednh l\u00e3i k\u00e9p online uy t\u00edn ho\u1eb7c m\u1ed9t file Excel m\u1eabu kh\u00e1c \u0111\u1ec3 nh\u1eadp c\u00f9ng m\u1ed9t b\u1ed9 s\u1ed1 li\u1ec7u v\u00e0 so s\u00e1nh k\u1ebft qu\u1ea3.<\/li>\n<\/ol>\n\n<h2>M\u00f4 H\u00ecnh H\u00f3a K\u1ecbch B\u1ea3n \u0110\u1ea7u T\u01b0 \u0110\u1ecbnh K\u1ef3 Linh Ho\u1ea1t<\/h2>\n<p>Trong th\u1ef1c t\u1ebf, vi\u1ec7c \u0111\u1ea7u t\u01b0 th\u01b0\u1eddng kh\u00f4ng c\u1ed1 \u0111\u1ecbnh. B\u1ea1n c\u00f3 th\u1ec3 t\u0103ng d\u1ea7n s\u1ed1 ti\u1ec1n g\u00f3p theo th\u1eddi gian, ho\u1eb7c c\u00f3 nh\u1eefng kho\u1ea3n g\u00f3p b\u1ea5t th\u01b0\u1eddng. Excel cho ph\u00e9p b\u1ea1n m\u00f4 ph\u1ecfng nh\u1eefng t\u00ecnh hu\u1ed1ng ph\u1ee9c t\u1ea1p n\u00e0y.<\/p>\n\n<h3>V\u00ed D\u1ee5: K\u1ebf Ho\u1ea1ch \u0110\u1ea7u T\u01b0 V\u1edbi L\u1ed9 Tr\u00ecnh T\u0103ng Ti\u1ec1n G\u00f3p<\/h3>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n b\u1eaft \u0111\u1ea7u v\u1edbi 5 tri\u1ec7u VN\u0110\/th\u00e1ng, v\u00e0 cam k\u1ebft t\u0103ng s\u1ed1 ti\u1ec1n g\u00f3p th\u00eam 10% m\u1ed7i n\u0103m. L\u00e3i su\u1ea5t k\u1ef3 v\u1ecdng l\u00e0 12%\/n\u0103m (t\u01b0\u01a1ng \u0111\u01b0\u01a1ng 1%\/th\u00e1ng). L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n c\u00f3 \u0111\u01b0\u1ee3c sau 15 n\u0103m?<\/p>\n<p>Gi\u1ea3i ph\u00e1p l\u00e0 x\u00e2y d\u1ef1ng m\u1ed9t b\u1ea3ng t\u00ednh chi ti\u1ebft theo th\u00e1ng, v\u1edbi m\u1ed9t c\u1ed9t ri\u00eang cho &#8220;S\u1ed1 ti\u1ec1n g\u00f3p trong k\u1ef3&#8221;. C\u1ed9t n\u00e0y s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng t\u0103ng 10% m\u1ed7i khi b\u01b0\u1edbc sang n\u0103m m\u1edbi (sau 12 k\u1ef3). C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 t\u00ednh s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 s\u1ebd l\u00e0: <code>=S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 * (1 + L\u00e3i su\u1ea5t) + S\u1ed1 ti\u1ec1n g\u00f3p trong k\u1ef3<\/code>. C\u00e1ch ti\u1ebfp c\u1eadn th\u1ee7 c\u00f4ng n\u00e0y cho b\u1ea1n c\u00e1i nh\u00ecn r\u00f5 r\u00e0ng v\u1ec1 d\u00f2ng ti\u1ec1n m\u1ed7i th\u00e1ng, m\u1eb7c d\u00f9 h\u01a1i d\u00e0i d\u00f2ng.<\/p>\n\n<h3>S\u1eed D\u1ee5ng H\u00e0m FV K\u1ebft H\u1ee3p V\u1edbi C\u00e1c H\u00e0m Kh\u00e1c Cho K\u1ecbch B\u1ea3n Ph\u1ee9c T\u1ea1p<\/h3>\n<p>\u0110\u1ed1i v\u1edbi c\u00e1c k\u1ecbch b\u1ea3n c\u00f3 quy t\u1eafc, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m FV v\u1edbi c\u00e1c h\u00e0m logic. V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh cho tr\u01b0\u1eddng h\u1ee3p ch\u1ec9 g\u00f3p ti\u1ec1n trong 10 n\u0103m \u0111\u1ea7u, sau \u0111\u00f3 \u0111\u1ec3 ti\u1ec1n t\u1ef1 sinh l\u00e3i trong 5 n\u0103m cu\u1ed1i, b\u1ea1n c\u00f3 th\u1ec3 chia th\u00e0nh 2 ph\u00e9p t\u00ednh:<\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> T\u00ednh gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai sau 10 n\u0103m g\u00f3p ti\u1ec1n \u0111\u1ecbnh k\u1ef3: <code>=FV(l\u00e3i su\u1ea5t\/12, 10*12, -s\u1ed1_ti\u1ec1n_g\u00f3p_h\u00e0ng_th\u00e1ng, -s\u1ed1_ti\u1ec1n_g\u1ed1c, 0)<\/code>.<\/li>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> L\u1ea5y k\u1ebft qu\u1ea3 t\u1eeb B\u01b0\u1edbc 1 l\u00e0m s\u1ed1 ti\u1ec1n g\u1ed1c <strong>m\u1edbi<\/strong>, t\u00ednh gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai sau 5 n\u0103m ti\u1ebfp theo <strong>kh\u00f4ng g\u00f3p th\u00eam<\/strong>: <code>=FV(l\u00e3i su\u1ea5t\/12, 5*12, 0, -s\u1ed1_ti\u1ec1n_g\u1ed1c_m\u1edbi, 0)<\/code> ho\u1eb7c \u0111\u01a1n gi\u1ea3n l\u00e0 <code>=s\u1ed1_ti\u1ec1n_g\u1ed1c_m\u1edbi * (1 + l\u00e3i su\u1ea5t\/12)^(5*12)<\/code>.<\/li>\n<\/ul>\n<p>Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y \u0111\u00f2i h\u1ecfi b\u1ea1n ph\u1ea3i hi\u1ec3u r\u00f5 logic t\u1eebng giai \u0111o\u1ea1n v\u00e0 x\u00e2u chu\u1ed7i ch\u00fang l\u1ea1i m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/p>\n\n<h2>T\u00edch H\u1ee3p Y\u1ebfu T\u1ed1 L\u1ea1m Ph\u00e1t V\u00e0o M\u00f4 H\u00ecnh<\/h2>\n<p>M\u1ed9t thi\u1ebfu s\u00f3t ph\u1ed5 bi\u1ebfn trong nhi\u1ec1u b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p l\u00e0 b\u1ecf qua y\u1ebfu t\u1ed1 l\u1ea1m ph\u00e1t. Con s\u1ed1 &#8220;tuy\u1ec7t \u0111\u1ed1i&#8221; b\u1ea1n c\u00f3 trong t\u01b0\u01a1ng lai s\u1ebd c\u00f3 s\u1ee9c mua kh\u00e1c v\u1edbi ng\u00e0y h\u00f4m nay. \u0110\u1ec3 c\u00f3 c\u00e1i nh\u00ecn th\u1ef1c t\u1ebf, b\u1ea1n c\u1ea7n t\u00ednh \u0111\u1ebfn <strong>l\u00e3i su\u1ea5t th\u1ef1c<\/strong>.<\/p>\n\n<h3>C\u00f4ng Th\u1ee9c T\u00ednh L\u00e3i Su\u1ea5t Th\u1ef1c<\/h3>\n<p>L\u00e3i su\u1ea5t th\u1ef1c ph\u1ea3n \u00e1nh s\u1ee9c t\u0103ng tr\u01b0\u1edfng th\u1ef1c s\u1ef1 c\u1ee7a \u0111\u1ed3ng ti\u1ec1n sau khi \u0111\u00e3 lo\u1ea1i tr\u1eeb l\u1ea1m ph\u00e1t. C\u00f4ng th\u1ee9c x\u1ea5p x\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0:<\/p>\n<blockquote><p>L\u00e3i su\u1ea5t th\u1ef1c \u2248 L\u00e3i su\u1ea5t danh ngh\u0129a &#8211; T\u1ef7 l\u1ec7 l\u1ea1m ph\u00e1t k\u1ef3 v\u1ecdng<\/p><\/blockquote>\n<p>V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n \u0111\u1ea7u t\u01b0 v\u1edbi l\u00e3i su\u1ea5t 10%\/n\u0103m, nh\u01b0ng l\u1ea1m ph\u00e1t trung b\u00ecnh d\u1ef1 ki\u1ebfn l\u00e0 4%\/n\u0103m, th\u00ec l\u00e3i su\u1ea5t th\u1ef1c ch\u1ec9 c\u00f2n kho\u1ea3ng 6%. B\u1ea1n n\u00ean t\u1ea1o m\u1ed9t \u00f4 nh\u1eadp li\u1ec7u ri\u00eang cho &#8220;T\u1ef7 l\u1ec7 l\u1ea1m ph\u00e1t k\u1ef3 v\u1ecdng&#8221; v\u00e0 m\u1ed9t \u00f4 t\u00ednh &#8220;L\u00e3i su\u1ea5t th\u1ef1c&#8221;. Sau \u0111\u00f3, s\u1eed d\u1ee5ng ch\u00ednh <strong>l\u00e3i su\u1ea5t th\u1ef1c<\/strong> n\u00e0y l\u00e0m \u0111\u1ea7u v\u00e0o cho h\u00e0m FV ho\u1eb7c b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n. K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd l\u00e0 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai theo s\u1ee9c mua hi\u1ec7n t\u1ea1i, gi\u00fap b\u1ea1n h\u00ecnh dung r\u00f5 h\u01a1n v\u1ec1 gi\u00e1 tr\u1ecb th\u1ef1c c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0.<\/p>\n\n<h3>B\u1ea3ng So S\u00e1nh Gi\u00e1 Tr\u1ecb Danh Ngh\u0129a V\u00e0 Gi\u00e1 Tr\u1ecb Th\u1ef1c<\/h3>\n<table>\n<thead>\n<tr><th>Th\u1eddi Gian<\/th><th>Gi\u00e1 Tr\u1ecb T\u01b0\u01a1ng Lai (Danh Ngh\u0129a)<\/th><th>Gi\u00e1 Tr\u1ecb Hi\u1ec7n T\u1ea1i (Theo S\u1ee9c Mua)<\/th><th>Ghi Ch\u00fa<\/th><\/tr>\n<\/thead>\n<tbody>\n<tr><td>Sau 10 n\u0103m<\/td><td>2.593.742 VN\u0110<\/td><td>1.751.316 VN\u0110<\/td><td>L\u00e3i su\u1ea5t 10%, L\u1ea1m ph\u00e1t 4%<\/td><\/tr>\n<tr><td>Sau 20 n\u0103m<\/td><td>6.727.500 VN\u0110<\/td><td>3.066.737 VN\u0110<\/td><td>G\u1ed1c 1.000.000 VN\u0110, kh\u00f4ng g\u00f3p th\u00eam<\/td><\/tr>\n<tr><td>Sau 30 n\u0103m<\/td><td>17.449.402 VN\u0110<\/td><td>5.386.909 VN\u0110<\/td><td>S\u1ee9c mua ch\u1ec9 b\u1eb1ng ~1\/3 gi\u00e1 tr\u1ecb danh ngh\u0129a<\/td><\/tr>\n<\/tbody>\n<\/table>\n<p>Vi\u1ec7c b\u1ed5 sung g\u00f3c nh\u00ecn n\u00e0y bi\u1ebfn b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n t\u1eeb m\u1ed9t c\u00f4ng c\u1ee5 t\u00ednh to\u00e1n \u0111\u01a1n thu\u1ea7n th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 ho\u1ea1ch \u0111\u1ecbnh t\u00e0i ch\u00ednh c\u00e1 nh\u00e2n chuy\u00ean nghi\u1ec7p, gi\u00fap \u0111\u1eb7t ra m\u1ee5c ti\u00eau t\u00e0i ch\u00ednh th\u1ef1c t\u1ebf h\u01a1n.<\/p>\n<hr>\n<p>B\u1eb1ng c\u00e1ch \u0111\u00e0o s\u00e2u v\u00e0o ph\u00e2n t\u00edch \u0111\u1ed9 nh\u1ea1y, x\u00e2y d\u1ef1ng quy tr\u00ecnh ki\u1ec3m tra, m\u00f4 h\u00ecnh h\u00f3a c\u00e1c k\u1ecbch b\u1ea3n linh ho\u1ea1t v\u00e0 \u0111\u1eb7c bi\u1ec7t l\u00e0 t\u00edch h\u1ee3p y\u1ebfu t\u1ed1 l\u1ea1m ph\u00e1t, b\u1ea1n \u0111\u00e3 n\u00e2ng c\u1ea5p \u0111\u00e1ng k\u1ec3 b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p c\u1ee7a m\u00ecnh. Nh\u1eefng b\u01b0\u1edbc ti\u1ebfn n\u00e0y kh\u00f4ng ch\u1ec9 c\u1ee7ng c\u1ed1 \u0111\u1ed9 tin c\u1eady c\u1ee7a k\u1ebft qu\u1ea3 m\u00e0 c\u00f2n m\u1edf ra kh\u1ea3 n\u0103ng \u1ee9ng d\u1ee5ng r\u1ed9ng r\u00e3i trong c\u00e1c t\u00ecnh hu\u1ed1ng t\u00e0i ch\u00ednh ph\u1ee9c t\u1ea1p c\u1ee7a \u0111\u1eddi s\u1ed1ng.<\/p>\n<h2>Ph\u00e2n T\u00edch K\u1ebft Qu\u1ea3 V\u00e0 \u0110\u01b0a Ra Quy\u1ebft \u0110\u1ecbnh \u0110\u1ea7u T\u01b0<\/h2>\n<p>Sau khi \u0111\u00e3 x\u00e2y d\u1ef1ng xong b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p, b\u01b0\u1edbc quan tr\u1ecdng kh\u00f4ng k\u00e9m l\u00e0 ph\u00e2n t\u00edch k\u1ebft qu\u1ea3 \u0111\u1ec3 \u0111\u01b0a ra c\u00e1c quy\u1ebft \u0111\u1ecbnh t\u00e0i ch\u00ednh s\u00e1ng su\u1ed1t. Excel kh\u00f4ng ch\u1ec9 d\u1eebng l\u1ea1i \u1edf vi\u1ec7c cho ra m\u1ed9t con s\u1ed1 t\u01b0\u01a1ng lai, m\u00e0 c\u00f2n l\u00e0 c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 b\u1ea1n &#8220;n\u00f3i chuy\u1ec7n&#8221; v\u1edbi c\u00e1c k\u1ecbch b\u1ea3n \u0111\u1ea7u t\u01b0 c\u1ee7a m\u00ecnh.<\/p>\n\n<h3>Di\u1ec5n Gi\u1ea3i C\u00e1c Ch\u1ec9 S\u1ed1 T\u1eeb B\u1ea3ng T\u00ednh<\/h3>\n<p>M\u1ed9t b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p ho\u00e0n ch\u1ec9nh s\u1ebd cung c\u1ea5p cho b\u1ea1n m\u1ed9t lo\u1ea1t ch\u1ec9 s\u1ed1 quan tr\u1ecdng:<\/p>\n<ul>\n<li><strong>T\u1ed5ng gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai (FV)<\/strong>: \u0110\u00e2y l\u00e0 m\u1ee5c ti\u00eau cu\u1ed1i c\u00f9ng, cho bi\u1ebft b\u1ea1n s\u1ebd c\u00f3 bao nhi\u00eau ti\u1ec1n v\u00e0o th\u1eddi \u0111i\u1ec3m k\u1ebft th\u00fac.<\/li>\n<li><strong>T\u1ed5ng s\u1ed1 ti\u1ec1n g\u1ed1c \u0111\u00e3 \u0111\u1ea7u t\u01b0<\/strong>: T\u1ed5ng c\u1ed9ng s\u1ed1 ti\u1ec1n b\u1ea1n \u0111\u00e3 b\u1ecf ra qua c\u00e1c k\u1ef3. So s\u00e1nh con s\u1ed1 n\u00e0y v\u1edbi FV s\u1ebd th\u1ea5y r\u00f5 s\u1ee9c m\u1ea1nh c\u1ee7a l\u00e3i k\u00e9p.<\/li>\n<li><strong>T\u1ed5ng l\u00e3i k\u00e9p t\u00edch l\u0169y<\/strong>: Ch\u00ednh l\u00e0 ph\u1ea7n ch\u00eanh l\u1ec7ch gi\u1eefa FV v\u00e0 t\u1ed5ng ti\u1ec1n g\u1ed1c. \u0110\u00e2y l\u00e0 ph\u1ea7n l\u1ee3i nhu\u1eadn th\u1ef1c s\u1ef1 do ti\u1ec1n c\u1ee7a b\u1ea1n t\u1ea1o ra.<\/li>\n<li><strong>T\u1ef7 l\u1ec7 l\u00e3i k\u00e9p\/t\u1ed5ng g\u1ed1c<\/strong>: M\u1ed9t ch\u1ec9 s\u1ed1 r\u1ea5t \u00fd ngh\u0129a, cho bi\u1ebft m\u1ed7i \u0111\u1ed3ng v\u1ed1n b\u1ecf ra \u0111\u00e3 &#8220;\u0111\u1ebb&#8221; \u0111\u01b0\u1ee3c bao nhi\u00eau \u0111\u1ed3ng l\u00e3i. Khi th\u1eddi gian d\u00e0i, t\u1ef7 l\u1ec7 n\u00e0y c\u00f3 th\u1ec3 v\u01b0\u1ee3t xa 100%, ch\u1ee9ng t\u1ecf l\u00e3i sinh ra l\u00e3i \u0111\u00e3 v\u01b0\u1ee3t m\u1eb7t s\u1ed1 v\u1ed1n ban \u0111\u1ea7u.<\/li>\n<\/ul>\n<p>Vi\u1ec7c theo d\u00f5i s\u1ef1 thay \u0111\u1ed5i c\u1ee7a c\u00e1c ch\u1ec9 s\u1ed1 n\u00e0y qua t\u1eebng n\u0103m trong b\u1ea3ng t\u00ednh s\u1ebd gi\u00fap b\u1ea1n c\u00f3 \u0111\u1ed9ng l\u1ef1c duy tr\u00ec k\u1ebf ho\u1ea1ch \u0111\u1ea7u t\u01b0 d\u00e0i h\u1ea1n.<\/p>\n\n<h3>X\u00e2y D\u1ef1ng Bi\u1ec3u \u0110\u1ed3 Tr\u1ef1c Quan H\u00f3a L\u1ed9 Tr\u00ecnh T\u0103ng Tr\u01b0\u1edfng<\/h3>\n<p>M\u1ed9t b\u1ee9c tranh \u0111\u00e1ng gi\u00e1 ng\u00e0n con s\u1ed1. H\u00e3y s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng bi\u1ec3u \u0111\u1ed3 (Chart) trong Excel \u0111\u1ec3 minh h\u1ecda s\u1ef1 ph\u00e1t tri\u1ec3n c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0:<\/p>\n<ul>\n<li><strong>Bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng (Line Chart)<\/strong>: Th\u1ec3 hi\u1ec7n \u0111\u01b0\u1eddng cong t\u0103ng tr\u01b0\u1edfng c\u1ee7a t\u1ed5ng gi\u00e1 tr\u1ecb t\u00e0i kho\u1ea3n qua t\u1eebng n\u0103m. \u0110\u01b0\u1eddng cong n\u00e0y th\u01b0\u1eddng c\u00f3 \u0111\u1ed9 d\u1ed1c t\u0103ng d\u1ea7n theo th\u1eddi gian \u2013 d\u1ea5u hi\u1ec7u r\u00f5 r\u00e0ng c\u1ee7a l\u00e3i k\u00e9p.<\/li>\n<li><strong>Bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng (Stacked Column Chart)<\/strong>: Ph\u00e2n t\u00e1ch r\u00f5 r\u00e0ng ph\u1ea7n ti\u1ec1n g\u1ed1c v\u00e0 ph\u1ea7n l\u00e3i k\u00e9p t\u00edch l\u0169y trong t\u1ed5ng gi\u00e1 tr\u1ecb m\u1ed7i n\u0103m. B\u1ea1n s\u1ebd th\u1ea5y r\u00f5 qua th\u1eddi gian, c\u1ed9t &#8220;l\u00e3i k\u00e9p&#8221; ng\u00e0y c\u00e0ng chi\u1ebfm t\u1ef7 tr\u1ecdng l\u1edbn h\u01a1n.<\/li>\n<\/ul>\n<p>Nh\u1eefng bi\u1ec3u \u0111\u1ed3 n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n d\u1ec5 hi\u1ec3u m\u00e0 c\u00f2n l\u00e0 c\u00f4ng c\u1ee5 tuy\u1ec7t v\u1eddi \u0111\u1ec3 tr\u00ecnh b\u00e0y k\u1ebf ho\u1ea1ch t\u00e0i ch\u00ednh v\u1edbi ng\u01b0\u1eddi th\u00e2n ho\u1eb7c \u0111\u1ed1i t\u00e1c.<\/p>\n\n<h3>Thi\u1ebft L\u1eadp Ng\u01b0\u1ee1ng C\u1ea3nh B\u00e1o V\u00e0 M\u1ee5c Ti\u00eau T\u00e0i Ch\u00ednh<\/h3>\n<p>Excel c\u00f3 th\u1ec3 tr\u1edf th\u00e0nh &#8220;tr\u1ee3 l\u00fd&#8221; nh\u1eafc nh\u1edf b\u1ea1n. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n (Conditional Formatting):<\/p>\n<ul>\n<li>T\u00f4 m\u00e0u \u00f4 t\u1ed5ng gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai (FV) th\u00e0nh xanh l\u00e1 khi n\u00f3 \u0111\u1ea1t ho\u1eb7c v\u01b0\u1ee3t m\u1ed9t m\u1ee5c ti\u00eau t\u00e0i ch\u00ednh c\u1ee5 th\u1ec3 b\u1ea1n \u0111\u1eb7t ra (v\u00ed d\u1ee5: 1 t\u1ef7 VN\u0110, 3 t\u1ef7 VN\u0110).<\/li>\n<li>\u0110\u00e1nh d\u1ea5u c\u1ea3nh b\u00e1o (m\u00e0u v\u00e0ng\/\u0111\u1ecf) n\u1ebfu b\u1ea1n \u0111i\u1ec1u ch\u1ec9nh gi\u1ea3m s\u1ed1 ti\u1ec1n g\u00f3p \u0111\u1ecbnh k\u1ef3 ho\u1eb7c l\u00e3i su\u1ea5t k\u1ef3 v\u1ecdng, khi\u1ebfn k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng r\u01a1i xu\u1ed1ng d\u01b0\u1edbi m\u1ed9t ng\u01b0\u1ee1ng an to\u00e0n n\u00e0o \u0111\u00f3.<\/li>\n<\/ul>\n<p>Vi\u1ec7c n\u00e0y bi\u1ebfn b\u1ea3ng t\u00ednh t\u1eeb m\u1ed9t c\u00f4ng c\u1ee5 t\u00ednh to\u00e1n th\u1ee5 \u0111\u1ed9ng th\u00e0nh m\u1ed9t b\u1ea3n \u0111\u1ed3 h\u00e0nh tr\u00ecnh t\u00edch c\u1ef1c, lu\u00f4n ch\u1ec9 cho b\u1ea1n th\u1ea5y b\u1ea1n \u0111ang \u1edf \u0111\u00e2u so v\u1edbi \u0111\u00edch \u0111\u1ebfn.<\/p>\n\n<hr>\n\n<h2>B\u1ea3o M\u1eadt, L\u01b0u Tr\u1eef V\u00e0 Chia S\u1ebb B\u1ea3ng T\u00ednh<\/h2>\n<p>B\u1ea3ng t\u00ednh l\u00e3i k\u00e9p th\u01b0\u1eddng ch\u1ee9a th\u00f4ng tin t\u00e0i ch\u00ednh c\u00e1 nh\u00e2n nh\u1ea1y c\u1ea3m. Qu\u1ea3n l\u00fd n\u00f3 m\u1ed9t c\u00e1ch an to\u00e0n v\u00e0 hi\u1ec7u qu\u1ea3 l\u00e0 \u0111i\u1ec1u c\u1ea7n thi\u1ebft.<\/p>\n\n<h3>B\u1ea3o V\u1ec7 D\u1eef Li\u1ec7u V\u00e0 C\u00f4ng Th\u1ee9c Quan Tr\u1ecdng<\/h3>\n<p>\u0110\u1ec3 tr\u00e1nh nh\u1eefng ch\u1ec9nh s\u1eeda ngo\u00e0i \u00fd mu\u1ed1n l\u00e0m h\u1ecfng m\u00f4 h\u00ecnh, h\u00e3y s\u1eed d\u1ee5ng t\u00ednh n\u0103ng B\u1ea3o v\u1ec7 (Protect) c\u1ee7a Excel:<\/p>\n<ol>\n<li>Ch\u1ec9 \u0111\u1ec3 c\u00e1c \u00f4 nh\u1eadp li\u1ec7u (nh\u01b0 s\u1ed1 ti\u1ec1n g\u1ed1c, l\u00e3i su\u1ea5t, s\u1ed1 k\u1ef3, ti\u1ec1n g\u00f3p \u0111\u1ecbnh k\u1ef3) \u1edf tr\u1ea1ng th\u00e1i c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda (Unlocked).<\/li>\n<li>Kh\u00f3a (Lock) t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n.<\/li>\n<li>V\u00e0o <strong>Review &gt; Protect Sheet<\/strong>, \u0111\u1eb7t m\u1ed9t m\u1eadt kh\u1ea9u (n\u1ebfu c\u1ea7n) \u0111\u1ec3 ng\u0103n ng\u01b0\u1eddi kh\u00e1c thay \u0111\u1ed5i c\u1ea5u tr\u00fac b\u1ea3ng t\u00ednh. B\u1ea1n v\u1eabn c\u00f3 th\u1ec3 nh\u1eadp s\u1ed1 li\u1ec7u v\u00e0o c\u00e1c \u00f4 \u0111\u00e3 m\u1edf kh\u00f3a.<\/li>\n<\/ol>\n\n<h3>Chi\u1ebfn L\u01b0\u1ee3c L\u01b0u Tr\u1eef V\u00e0 Sao L\u01b0u<\/h3>\n<ul>\n<li><strong>L\u01b0u tr\u1eef \u0111\u00e1m m\u00e2y<\/strong>: L\u01b0u file l\u00ean OneDrive, Google Drive ho\u1eb7c iCloud. \u01afu \u0111i\u1ec3m l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 truy c\u1eadp t\u1eeb m\u1ecdi n\u01a1i v\u00e0 d\u1ec5 d\u00e0ng chia s\u1ebb. H\u00e3y \u0111\u1ea3m b\u1ea3o b\u1ea1n b\u1eadt t\u00ednh n\u0103ng l\u1ecbch s\u1eed phi\u00ean b\u1ea3n (version history) \u0111\u1ec3 c\u00f3 th\u1ec3 kh\u00f4i ph\u1ee5c n\u1ebfu c\u00f3 s\u1ef1 c\u1ed1.<\/li>\n<li><strong>Sao l\u01b0u c\u1ee5c b\u1ed9<\/strong>: Lu\u00f4n gi\u1eef m\u1ed9t b\u1ea3n copy trong \u1ed5 c\u1ee9ng m\u00e1y t\u00ednh ho\u1eb7c USB. M\u1ed9t m\u1eb9o nh\u1ecf l\u00e0 \u0111\u1eb7t t\u00ean file c\u00f3 ch\u1ee9a ng\u00e0y th\u00e1ng (VD: <em>Bang_Tinh_Lai_Kep_20241027.xlsx<\/em>) m\u1ed7i khi l\u01b0u m\u1ed9t phi\u00ean b\u1ea3n m\u1edbi quan tr\u1ecdng.<\/li>\n<\/ul>\n\n<h3>Chia S\u1ebb V\u00e0 H\u1ee3p T\u00e1c Tr\u00ean C\u00f9ng M\u00f4 H\u00ecnh<\/h3>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n c\u00f9ng l\u1eadp k\u1ebf ho\u1ea1ch v\u1edbi v\u1ee3\/ch\u1ed3ng ho\u1eb7c c\u1ed1 v\u1ea5n t\u00e0i ch\u00ednh, Excel cho ph\u00e9p chia s\u1ebb:<\/p>\n<ul>\n<li>Tr\u00ean c\u00e1c n\u1ec1n t\u1ea3ng \u0111\u00e1m m\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 m\u1eddi ng\u01b0\u1eddi kh\u00e1c c\u00f9ng ch\u1ec9nh s\u1eeda file.<\/li>\n<li>S\u1eed d\u1ee5ng <strong>Comments<\/strong> \u0111\u1ec3 th\u1ea3o lu\u1eadn, \u0111\u1eb7t c\u00e2u h\u1ecfi tr\u1ef1c ti\u1ebfp tr\u00ean c\u00e1c \u00f4 d\u1eef li\u1ec7u.<\/li>\n<li>B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3n copy &#8220;ch\u1ec9 \u0111\u1ecdc&#8221; (Read-Only) \u0111\u1ec3 chia s\u1ebb r\u1ed9ng r\u00e3i m\u00e0 kh\u00f4ng lo b\u1ecb thay \u0111\u1ed5i.<\/li>\n<\/ul>\n\n<hr>\n\n<h2>K\u1ebft lu\u1eadn<\/h2>\n<p>T\u1ef1 tay x\u00e2y d\u1ef1ng m\u1ed9t b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p b\u1eb1ng Excel l\u00e0 m\u1ed9t tr\u1ea3i nghi\u1ec7m gi\u00e1 tr\u1ecb v\u01b0\u1ee3t xa kh\u1ecfi vi\u1ec7c c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t con s\u1ed1. N\u00f3 bu\u1ed9c b\u1ea1n ph\u1ea3i hi\u1ec3u r\u00f5 t\u1eebng th\u00e0nh ph\u1ea7n c\u1ea5u th\u00e0nh n\u00ean s\u1ef1 t\u0103ng tr\u01b0\u1edfng t\u00e0i ch\u00ednh c\u1ee7a m\u00ecnh: v\u1ed1n ban \u0111\u1ea7u, k\u1ef7 lu\u1eadt g\u00f3p ti\u1ec1n \u0111\u1ecbnh k\u1ef3, l\u00e3i su\u1ea5t k\u1ef3 v\u1ecdng v\u00e0 y\u1ebfu t\u1ed1 then ch\u1ed1t \u2013 th\u1eddi gian. B\u1ea3ng t\u00ednh tr\u1edf th\u00e0nh m\u1ed9t m\u00f4 h\u00ecnh \u0111\u1ed9ng, n\u01a1i b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m nghi\u1ec7m m\u1ecdi gi\u1ea3 \u0111\u1ecbnh, h\u00ecnh dung r\u00f5 r\u00e0ng t\u01b0\u01a1ng lai v\u00e0 quan tr\u1ecdng nh\u1ea5t, bi\u1ebfn c\u00e1c m\u1ee5c ti\u00eau t\u00e0i ch\u00ednh t\u1eeb m\u01a1 h\u1ed3 th\u00e0nh nh\u1eefng con s\u1ed1 c\u1ee5 th\u1ec3, c\u00f3 l\u1ed9 tr\u00ecnh. H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n nh\u1ea5t, tinh ch\u1ec9nh v\u00e0 m\u1edf r\u1ed9ng d\u1ea7n theo nhu c\u1ea7u. S\u1ee9c m\u1ea1nh th\u1ef1c s\u1ef1 n\u1eb1m \u1edf s\u1ef1 ch\u1ee7 \u0111\u1ed9ng v\u00e0 hi\u1ec3u bi\u1ebft m\u00e0 qu\u00e1 tr\u00ecnh n\u00e0y mang l\u1ea1i, gi\u00fap b\u1ea1n t\u1ef1 tin h\u01a1n tr\u00ean h\u00e0nh tr\u00ecnh l\u00e0m ch\u1ee7 t\u00e0i ch\u00ednh c\u00e1 nh\u00e2n.<\/p>\n\n<hr>\n\n<h2>C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p (FAQ)<\/h2>\n\n<h3>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh l\u00e3i k\u00e9p khi l\u00e3i su\u1ea5t thay \u0111\u1ed5i theo t\u1eebng giai \u0111o\u1ea1n?<\/h3>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n kh\u00f4ng th\u1ec3 d\u00f9ng m\u1ed9t h\u00e0m FV duy nh\u1ea5t. C\u1ea7n x\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng theo t\u1eebng k\u1ef3. T\u1ea1i m\u1ed7i h\u00e0ng (k\u1ef3), b\u1ea1n nh\u1eadp l\u00e3i su\u1ea5t \u00e1p d\u1ee5ng cho k\u1ef3 \u0111\u00f3 v\u00e0o m\u1ed9t c\u1ed9t ri\u00eang. C\u00f4ng th\u1ee9c t\u00ednh l\u00e3i ph\u00e1t sinh trong k\u1ef3 s\u1ebd = (S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 + Ti\u1ec1n g\u00f3p trong k\u1ef3) * (L\u00e3i su\u1ea5t k\u1ef3 \u0111\u00f3 \/ S\u1ed1 k\u1ef3 g\u1ed9p trong n\u0103m). Sau \u0111\u00f3 c\u1ed9ng l\u00e3i n\u00e0y v\u00e0o s\u1ed1 d\u01b0 \u0111\u1ec3 t\u00ednh s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3, v\u00e0 s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 n\u00e0y s\u1ebd l\u00e0 s\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 c\u1ee7a k\u1ef3 ti\u1ebfp theo.<\/p>\n\n<h3>T\u00f4i mu\u1ed1n d\u1eebng g\u00f3p ti\u1ec1n sau m\u1ed9t s\u1ed1 n\u0103m nh\u01b0ng v\u1eabn \u0111\u1ec3 ti\u1ec1n ti\u1ebfp t\u1ee5c sinh l\u00e3i \u0111\u1ebfn h\u1ebft th\u1eddi h\u1ea1n, th\u00ec m\u00f4 h\u00ecnh th\u1ebf n\u00e0o?<\/h3>\n<p>B\u1ea1n c\u1ea7n thi\u1ebft k\u1ebf b\u1ea3ng t\u00ednh c\u00f3 hai giai \u0111o\u1ea1n. Giai \u0111o\u1ea1n 1: C\u00f3 d\u00f2ng ti\u1ec1n g\u00f3p \u0111\u1ecbnh k\u1ef3 (s\u1eed d\u1ee5ng \u0111\u1ed1i s\u1ed1 <code>pmt<\/code> trong h\u00e0m FV ho\u1eb7c c\u1ed9t ti\u1ec1n g\u00f3p trong b\u1ea3ng th\u1ee7 c\u00f4ng). Giai \u0111o\u1ea1n 2: Kh\u00f4ng c\u00f3 d\u00f2ng ti\u1ec1n g\u00f3p (<code>pmt = 0<\/code>). B\u1ea1n c\u00f3 th\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb \u0111\u1ea1t \u0111\u01b0\u1ee3c \u1edf cu\u1ed1i giai \u0111o\u1ea1n 1, sau \u0111\u00f3 d\u00f9ng ch\u00ednh s\u1ed1 ti\u1ec1n \u0111\u00f3 l\u00e0m <code>pv<\/code> (gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i) \u0111\u1ec3 t\u00ednh ti\u1ebfp l\u00e3i k\u00e9p cho giai \u0111o\u1ea1n 2 v\u1edbi s\u1ed1 k\u1ef3 c\u00f2n l\u1ea1i.<\/p>\n\n<h3>L\u00e0m sao \u0111\u1ec3 t\u00edch h\u1ee3p y\u1ebfu t\u1ed1 ph\u00ed qu\u1ea3n l\u00fd ho\u1eb7c thu\u1ebf v\u00e0o b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p?<\/h3>\n<p>\u0110\u1ec3 m\u00f4 h\u00ecnh g\u1ea7n v\u1edbi th\u1ef1c t\u1ebf nh\u1ea5t, b\u1ea1n n\u00ean t\u1ea1o th\u00eam m\u1ed9t c\u1ed9t &#8220;Ph\u00ed\/Thu\u1ebf h\u00e0ng k\u1ef3&#8221;. M\u1ee9c ph\u00ed n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1 ti\u1ec1n c\u1ed1 \u0111\u1ecbnh ho\u1eb7c m\u1ed9t t\u1ef7 l\u1ec7 % tr\u00ean s\u1ed1 d\u01b0. C\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 s\u1ebd tr\u1edf th\u00e0nh: <strong>S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 + Ti\u1ec1n g\u00f3p + L\u00e3i ph\u00e1t sinh &#8211; Ph\u00ed\/Thu\u1ebf<\/strong>. Vi\u1ec7c tr\u1eeb \u0111i chi ph\u00ed n\u00e0y s\u1ebd cho b\u1ea1n c\u00e1i nh\u00ecn th\u1ef1c t\u1ebf v\u1ec1 l\u1ee3i nhu\u1eadn r\u00f2ng.<\/p>\n\n<h3>T\u00f4i n\u00ean ch\u1ecdn chu k\u1ef3 g\u1ed9p l\u00e3i (nh\u1eadp k\u1ef3\/n\u0103m) l\u00e0 h\u00e0ng th\u00e1ng, h\u00e0ng qu\u00fd hay h\u00e0ng n\u0103m?<\/h3>\n<p>Nguy\u00ean t\u1eafc l\u00e0 chu k\u1ef3 g\u1ed9p l\u00e3i ph\u1ea3i \u0111\u1ed3ng b\u1ed9 v\u1edbi chu k\u1ef3 g\u00f3p ti\u1ec1n v\u00e0 l\u00e3i su\u1ea5t b\u1ea1n c\u00f3. N\u1ebfu b\u1ea1n g\u00f3p ti\u1ec1n h\u00e0ng th\u00e1ng v\u00e0 ng\u00e2n h\u00e0ng t\u00ednh l\u00e3i h\u00e0ng th\u00e1ng, h\u00e3y \u0111\u1eb7t <code>nper<\/code> (t\u1ed5ng s\u1ed1 k\u1ef3) = s\u1ed1 n\u0103m * 12, v\u00e0 <code>rate<\/code> (l\u00e3i su\u1ea5t\/k\u1ef3) = l\u00e3i su\u1ea5t n\u0103m \/ 12. Vi\u1ec7c g\u1ed9p l\u00e3i th\u01b0\u1eddng xuy\u00ean h\u01a1n (th\u00e1ng so v\u1edbi n\u0103m) s\u1ebd cho k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng cao h\u01a1n m\u1ed9t ch\u00fat do ti\u1ec1n l\u00e3i \u0111\u01b0\u1ee3c th\u00eam v\u00e0o g\u1ed1c \u0111\u1ec3 t\u00ednh l\u00e3i cho k\u1ef3 sau s\u1edbm h\u01a1n.<\/p>\n\n<h3>Khi n\u00e0o th\u00ec n\u00ean d\u00f9ng h\u00e0m FV v\u00e0 khi n\u00e0o n\u00ean d\u00f9ng b\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng?<\/h3>\n<p>H\u00e0m <code>FV<\/code> l\u00e0 c\u00f4ng c\u1ee5 ho\u00e0n h\u1ea3o cho c\u00e1c t\u00ednh to\u00e1n nhanh, m\u1ed9t l\u1ea7n, v\u1edbi c\u00e1c gi\u1ea3 \u0111\u1ecbnh c\u1ed1 \u0111\u1ecbnh (l\u00e3i su\u1ea5t kh\u00f4ng \u0111\u1ed5i, ti\u1ec1n g\u00f3p \u0111\u1ec1u \u0111\u1eb7n). B\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng (t\u00ednh l\u00e3i t\u1eebng k\u1ef3) v\u01b0\u1ee3t tr\u1ed9i khi b\u1ea1n c\u1ea7n linh ho\u1ea1t: l\u00e3i su\u1ea5t thay \u0111\u1ed5i, l\u1ecbch g\u00f3p ti\u1ec1n kh\u00f4ng \u0111\u1ec1u (c\u00f3 th\u00e1ng g\u00f3p nhi\u1ec1u, th\u00e1ng g\u00f3p \u00edt), mu\u1ed1n theo d\u00f5i chi ti\u1ebft s\u1ed1 d\u01b0 v\u00e0 l\u00e3i su\u1ea5t t\u1eebng k\u1ef3, ho\u1eb7c mu\u1ed1n t\u00edch h\u1ee3p th\u00eam c\u00e1c y\u1ebfu t\u1ed1 ph\u1ee9c t\u1ea1p nh\u01b0 ph\u00ed, thu\u1ebf.<\/p>\n\n<h3>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ki\u1ec3m tra ch\u00e9o \u0111\u1ed9 ch\u00ednh x\u00e1c c\u1ee7a b\u1ea3ng t\u00ednh t\u1ef1 t\u1ea1o?<\/h3>\n<p>C\u00f3 ba c\u00e1ch \u0111\u01a1n gi\u1ea3n: 1) <strong>So s\u00e1nh v\u1edbi c\u00f4ng c\u1ee5 online uy t\u00edn<\/strong>: Nh\u1eadp c\u00f9ng th\u00f4ng s\u1ed1 v\u00e0o m\u1ed9t m\u00e1y t\u00ednh l\u00e3i k\u00e9p tr\u00ean c\u00e1c website t\u00e0i ch\u00ednh \u0111\u1ec3 \u0111\u1ed1i chi\u1ebfu k\u1ebft qu\u1ea3. 2) <strong>T\u00ednh th\u1eed m\u1ed9t v\u00e0i k\u1ef3 \u0111\u1ea7u b\u1eb1ng tay<\/strong> \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o logic c\u00f4ng th\u1ee9c \u0111\u00fang. 3) <strong>Ki\u1ec3m tra t\u00ednh h\u1ee3p l\u00fd<\/strong>: K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng ph\u1ea3i l\u1edbn h\u01a1n t\u1ed5ng s\u1ed1 ti\u1ec1n g\u1ed1c b\u1ecf ra. N\u1ebfu l\u00e3i su\u1ea5t d\u01b0\u01a1ng m\u00e0 k\u1ebft qu\u1ea3 nh\u1ecf h\u01a1n, ch\u1eafc ch\u1eafn c\u00f3 l\u1ed7i trong c\u00f4ng th\u1ee9c ho\u1eb7c logic.<\/p>\n\n<h3>T\u00f4i c\u00f3 th\u1ec3 d\u00f9ng b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p n\u00e0y \u0111\u1ec3 l\u1eadp k\u1ebf ho\u1ea1ch tr\u1ea3 n\u1ee3 g\u1ed1c l\u1eabn l\u00e3i kh\u00f4ng?<\/h3>\n<p>Ho\u00e0n to\u00e0n c\u00f3 th\u1ec3. Nguy\u00ean l\u00fd l\u00e3i k\u00e9p c\u0169ng ch\u00ednh l\u00e0 nguy\u00ean l\u00fd c\u1ee7a kho\u1ea3n vay tr\u1ea3 g\u00f3p. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m <code>PMT<\/code> \u0111\u1ec3 t\u00ednh s\u1ed1 ti\u1ec1n ph\u1ea3i tr\u1ea3 \u0111\u1ecbnh k\u1ef3 cho m\u1ed9t kho\u1ea3n vay. Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh b\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng: coi s\u1ed1 ti\u1ec1n vay ban \u0111\u1ea7u l\u00e0 &#8220;s\u1ed1 d\u01b0 \u00e2m&#8221;, m\u1ed7i k\u1ef3 b\u1ea1n tr\u1ea3 m\u1ed9t kho\u1ea3n (l\u00e0 d\u00f2ng ti\u1ec1n ra, nh\u1eadp s\u1ed1 d\u01b0\u01a1ng) v\u00e0 s\u1ed1 d\u01b0 s\u1ebd b\u1ecb t\u00ednh l\u00e3i (l\u00e3i su\u1ea5t vay). M\u1ee5c ti\u00eau l\u00e0 \u0111\u01b0a s\u1ed1 d\u01b0 v\u1ec1 0 sau m\u1ed9t s\u1ed1 k\u1ef3 nh\u1ea5t \u0111\u1ecbnh.<\/p>\n\n<script type=\"application\/ld+json\">{\"@context\":\"https:\/\/schema.org\",\"@type\":\"FAQPage\",\"mainEntity\":[{\"@type\":\"Question\",\"name\":\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh l\u00e3i k\u00e9p khi l\u00e3i su\u1ea5t thay \u0111\u1ed5i theo t\u1eebng giai \u0111o\u1ea1n?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n kh\u00f4ng th\u1ec3 d\u00f9ng m\u1ed9t h\u00e0m FV duy nh\u1ea5t. C\u1ea7n x\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng theo t\u1eebng k\u1ef3. T\u1ea1i m\u1ed7i h\u00e0ng (k\u1ef3), b\u1ea1n nh\u1eadp l\u00e3i su\u1ea5t \u00e1p d\u1ee5ng cho k\u1ef3 \u0111\u00f3 v\u00e0o m\u1ed9t c\u1ed9t ri\u00eang. C\u00f4ng th\u1ee9c t\u00ednh l\u00e3i ph\u00e1t sinh trong k\u1ef3 s\u1ebd = (S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 + Ti\u1ec1n g\u00f3p trong k\u1ef3) * (L\u00e3i su\u1ea5t k\u1ef3 \u0111\u00f3 \/ S\u1ed1 k\u1ef3 g\u1ed9p trong n\u0103m). Sau \u0111\u00f3 c\u1ed9ng l\u00e3i n\u00e0y v\u00e0o s\u1ed1 d\u01b0 \u0111\u1ec3 t\u00ednh s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3, v\u00e0 s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 n\u00e0y s\u1ebd l\u00e0 s\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 c\u1ee7a k\u1ef3 ti\u1ebfp theo.\"}},{\"@type\":\"Question\",\"name\":\"T\u00f4i mu\u1ed1n d\u1eebng g\u00f3p ti\u1ec1n sau m\u1ed9t s\u1ed1 n\u0103m nh\u01b0ng v\u1eabn \u0111\u1ec3 ti\u1ec1n ti\u1ebfp t\u1ee5c sinh l\u00e3i \u0111\u1ebfn h\u1ebft th\u1eddi h\u1ea1n, th\u00ec m\u00f4 h\u00ecnh th\u1ebf n\u00e0o?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"B\u1ea1n c\u1ea7n thi\u1ebft k\u1ebf b\u1ea3ng t\u00ednh c\u00f3 hai giai \u0111o\u1ea1n. Giai \u0111o\u1ea1n 1: C\u00f3 d\u00f2ng ti\u1ec1n g\u00f3p \u0111\u1ecbnh k\u1ef3 (s\u1eed d\u1ee5ng \u0111\u1ed1i s\u1ed1 pmt trong h\u00e0m FV ho\u1eb7c c\u1ed9t ti\u1ec1n g\u00f3p trong b\u1ea3ng th\u1ee7 c\u00f4ng). Giai \u0111o\u1ea1n 2: Kh\u00f4ng c\u00f3 d\u00f2ng ti\u1ec1n g\u00f3p ( pmt = 0 ). B\u1ea1n c\u00f3 th\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb \u0111\u1ea1t \u0111\u01b0\u1ee3c \u1edf cu\u1ed1i giai \u0111o\u1ea1n 1, sau \u0111\u00f3 d\u00f9ng ch\u00ednh s\u1ed1 ti\u1ec1n \u0111\u00f3 l\u00e0m pv (gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i) \u0111\u1ec3 t\u00ednh ti\u1ebfp l\u00e3i k\u00e9p cho giai \u0111o\u1ea1n 2 v\u1edbi s\u1ed1 k\u1ef3 c\u00f2n l\u1ea1i.\"}},{\"@type\":\"Question\",\"name\":\"L\u00e0m sao \u0111\u1ec3 t\u00edch h\u1ee3p y\u1ebfu t\u1ed1 ph\u00ed qu\u1ea3n l\u00fd ho\u1eb7c thu\u1ebf v\u00e0o b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\u0110\u1ec3 m\u00f4 h\u00ecnh g\u1ea7n v\u1edbi th\u1ef1c t\u1ebf nh\u1ea5t, b\u1ea1n n\u00ean t\u1ea1o th\u00eam m\u1ed9t c\u1ed9t \\\"Ph\u00ed\/Thu\u1ebf h\u00e0ng k\u1ef3\\\". M\u1ee9c ph\u00ed n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1 ti\u1ec1n c\u1ed1 \u0111\u1ecbnh ho\u1eb7c m\u1ed9t t\u1ef7 l\u1ec7 % tr\u00ean s\u1ed1 d\u01b0. C\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 s\u1ebd tr\u1edf th\u00e0nh: S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 + Ti\u1ec1n g\u00f3p + L\u00e3i ph\u00e1t sinh - Ph\u00ed\/Thu\u1ebf . Vi\u1ec7c tr\u1eeb \u0111i chi ph\u00ed n\u00e0y s\u1ebd cho b\u1ea1n c\u00e1i nh\u00ecn th\u1ef1c t\u1ebf v\u1ec1 l\u1ee3i nhu\u1eadn r\u00f2ng.\"}},{\"@type\":\"Question\",\"name\":\"T\u00f4i n\u00ean ch\u1ecdn chu k\u1ef3 g\u1ed9p l\u00e3i (nh\u1eadp k\u1ef3\/n\u0103m) l\u00e0 h\u00e0ng th\u00e1ng, h\u00e0ng qu\u00fd hay h\u00e0ng n\u0103m?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Nguy\u00ean t\u1eafc l\u00e0 chu k\u1ef3 g\u1ed9p l\u00e3i ph\u1ea3i \u0111\u1ed3ng b\u1ed9 v\u1edbi chu k\u1ef3 g\u00f3p ti\u1ec1n v\u00e0 l\u00e3i su\u1ea5t b\u1ea1n c\u00f3. N\u1ebfu b\u1ea1n g\u00f3p ti\u1ec1n h\u00e0ng th\u00e1ng v\u00e0 ng\u00e2n h\u00e0ng t\u00ednh l\u00e3i h\u00e0ng th\u00e1ng, h\u00e3y \u0111\u1eb7t nper (t\u1ed5ng s\u1ed1 k\u1ef3) = s\u1ed1 n\u0103m * 12, v\u00e0 rate (l\u00e3i su\u1ea5t\/k\u1ef3) = l\u00e3i su\u1ea5t n\u0103m \/ 12. Vi\u1ec7c g\u1ed9p l\u00e3i th\u01b0\u1eddng xuy\u00ean h\u01a1n (th\u00e1ng so v\u1edbi n\u0103m) s\u1ebd cho k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng cao h\u01a1n m\u1ed9t ch\u00fat do ti\u1ec1n l\u00e3i \u0111\u01b0\u1ee3c th\u00eam v\u00e0o g\u1ed1c \u0111\u1ec3 t\u00ednh l\u00e3i cho k\u1ef3 sau s\u1edbm h\u01a1n.\"}},{\"@type\":\"Question\",\"name\":\"Khi n\u00e0o th\u00ec n\u00ean d\u00f9ng h\u00e0m FV v\u00e0 khi n\u00e0o n\u00ean d\u00f9ng b\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"H\u00e0m FV l\u00e0 c\u00f4ng c\u1ee5 ho\u00e0n h\u1ea3o cho c\u00e1c t\u00ednh to\u00e1n nhanh, m\u1ed9t l\u1ea7n, v\u1edbi c\u00e1c gi\u1ea3 \u0111\u1ecbnh c\u1ed1 \u0111\u1ecbnh (l\u00e3i su\u1ea5t kh\u00f4ng \u0111\u1ed5i, ti\u1ec1n g\u00f3p \u0111\u1ec1u \u0111\u1eb7n). B\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng (t\u00ednh l\u00e3i t\u1eebng k\u1ef3) v\u01b0\u1ee3t tr\u1ed9i khi b\u1ea1n c\u1ea7n linh ho\u1ea1t: l\u00e3i su\u1ea5t thay \u0111\u1ed5i, l\u1ecbch g\u00f3p ti\u1ec1n kh\u00f4ng \u0111\u1ec1u (c\u00f3 th\u00e1ng g\u00f3p nhi\u1ec1u, th\u00e1ng g\u00f3p \u00edt), mu\u1ed1n theo d\u00f5i chi ti\u1ebft s\u1ed1 d\u01b0 v\u00e0 l\u00e3i su\u1ea5t t\u1eebng k\u1ef3, ho\u1eb7c mu\u1ed1n t\u00edch h\u1ee3p th\u00eam c\u00e1c y\u1ebfu t\u1ed1 ph\u1ee9c t\u1ea1p nh\u01b0 ph\u00ed, thu\u1ebf.\"}},{\"@type\":\"Question\",\"name\":\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ki\u1ec3m tra ch\u00e9o \u0111\u1ed9 ch\u00ednh x\u00e1c c\u1ee7a b\u1ea3ng t\u00ednh t\u1ef1 t\u1ea1o?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"C\u00f3 ba c\u00e1ch \u0111\u01a1n gi\u1ea3n: 1) So s\u00e1nh v\u1edbi c\u00f4ng c\u1ee5 online uy t\u00edn : Nh\u1eadp c\u00f9ng th\u00f4ng s\u1ed1 v\u00e0o m\u1ed9t m\u00e1y t\u00ednh l\u00e3i k\u00e9p tr\u00ean c\u00e1c website t\u00e0i ch\u00ednh \u0111\u1ec3 \u0111\u1ed1i chi\u1ebfu k\u1ebft qu\u1ea3. 2) T\u00ednh th\u1eed m\u1ed9t v\u00e0i k\u1ef3 \u0111\u1ea7u b\u1eb1ng tay \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o logic c\u00f4ng th\u1ee9c \u0111\u00fang. 3) Ki\u1ec3m tra t\u00ednh h\u1ee3p l\u00fd : K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng ph\u1ea3i l\u1edbn h\u01a1n t\u1ed5ng s\u1ed1 ti\u1ec1n g\u1ed1c b\u1ecf ra. N\u1ebfu l\u00e3i su\u1ea5t d\u01b0\u01a1ng m\u00e0 k\u1ebft qu\u1ea3 nh\u1ecf h\u01a1n, ch\u1eafc ch\u1eafn c\u00f3 l\u1ed7i trong c\u00f4ng th\u1ee9c ho\u1eb7c logic.\"}},{\"@type\":\"Question\",\"name\":\"T\u00f4i c\u00f3 th\u1ec3 d\u00f9ng b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p n\u00e0y \u0111\u1ec3 l\u1eadp k\u1ebf ho\u1ea1ch tr\u1ea3 n\u1ee3 g\u1ed1c l\u1eabn l\u00e3i kh\u00f4ng?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Ho\u00e0n to\u00e0n c\u00f3 th\u1ec3. Nguy\u00ean l\u00fd l\u00e3i k\u00e9p c\u0169ng ch\u00ednh l\u00e0 nguy\u00ean l\u00fd c\u1ee7a kho\u1ea3n vay tr\u1ea3 g\u00f3p. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m PMT \u0111\u1ec3 t\u00ednh s\u1ed1 ti\u1ec1n ph\u1ea3i tr\u1ea3 \u0111\u1ecbnh k\u1ef3 cho m\u1ed9t kho\u1ea3n vay. Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh b\u1ea3ng t\u00ednh th\u1ee7 c\u00f4ng: coi s\u1ed1 ti\u1ec1n vay ban \u0111\u1ea7u l\u00e0 \\\"s\u1ed1 d\u01b0 \u00e2m\\\", m\u1ed7i k\u1ef3 b\u1ea1n tr\u1ea3 m\u1ed9t kho\u1ea3n (l\u00e0 d\u00f2ng ti\u1ec1n ra, nh\u1eadp s\u1ed1 d\u01b0\u01a1ng) v\u00e0 s\u1ed1 d\u01b0 s\u1ebd b\u1ecb t\u00ednh l\u00e3i (l\u00e3i su\u1ea5t vay). M\u1ee5c ti\u00eau l\u00e0 \u0111\u01b0a s\u1ed1 d\u01b0 v\u1ec1 0 sau m\u1ed9t s\u1ed1 k\u1ef3 nh\u1ea5t \u0111\u1ecbnh.\"}}]}<\/script>\n\n","protected":false},"excerpt":{"rendered":"<p>B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u1ea1o b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p trong Excel t\u1eeb \u0111\u1ea7u, s\u1eed d\u1ee5ng h\u00e0m FV v\u00e0 c\u00f4ng th\u1ee9c th\u1ee7 c\u00f4ng&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":1875,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"C\u00e1ch t\u1ea1o b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p b\u1eb1ng Excel t\u1eeb A-Z","rank_math_description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u1ea1o b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p trong Excel b\u1eb1ng h\u00e0m FV v\u00e0 c\u00f4ng th\u1ee9c th\u1ee7 c\u00f4ng. Bao g\u1ed3m v\u00ed d\u1ee5 minh h\u1ecda, \u01b0u nh\u01b0\u1ee3c \u0111i\u1ec3m v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p.","rank_math_focus_keyword":"c\u00e1ch t\u1ea1o b\u1ea3ng t\u00ednh l\u00e3i k\u00e9p b\u1eb1ng Excel","footnotes":""},"categories":[2],"tags":[],"class_list":["post-1876","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-phan-tram"],"_links":{"self":[{"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/posts\/1876","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/comments?post=1876"}],"version-history":[{"count":0,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/posts\/1876\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/media\/1875"}],"wp:attachment":[{"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/media?parent=1876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/categories?post=1876"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/tags?post=1876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}