{"id":12405,"date":"2025-01-15T08:34:16","date_gmt":"2025-01-15T08:34:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-tai-chinh-va-cach-su-dung-cac-ham-tai-chinh-trong-excel-full\/"},"modified":"2025-01-15T08:34:16","modified_gmt":"2025-01-15T08:34:16","slug":"ham-tai-chinh-va-cach-su-dung-cac-ham-tai-chinh-trong-excel-full","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-tai-chinh-va-cach-su-dung-cac-ham-tai-chinh-trong-excel-full\/","title":{"rendered":"H\u00e0m t\u00e0i ch\u00ednh v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00e0i ch\u00ednh trong Excel, Full"},"content":{"rendered":"
\n
\n
\n
\n

B\u00e1ch nh\u1edb ng\u00e0y c\u00f2n l\u00e0 sinh vi\u00ean ng\u00e0nh t\u00e0i ch\u00ednh, B\u00e1ch kh\u00e1 th\u00edch th\u00fa v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb th\u1eddi gian c\u1ee7a ti\u1ec1n, t\u00ednh l\u00e3i c\u1ee7a kho\u1ea3n vay, t\u00ednh l\u00e3i th\u1ef1c c\u1ee7a kho\u1ea3n vay tr\u1ea3 g\u00f3p \u2026 l\u00fac \u0111\u00f3 B\u00e1ch b\u1ecb cho\u00e1ng ng\u1ee3p tr\u01b0\u1edbc s\u1ef1 k\u1ef3 di\u1ec7u c\u1ee7a Excel. Tuy nhi\u00ean khi \u0111i h\u1ecdc th\u00ec c\u0169ng ch\u1ec9 \u0111\u01b0\u1ee3c c\u00e1c th\u1ea7y c\u00f4 chia s\u1ebb m\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n nh\u01b0 NPV, PV, FV ch\u1ee9 ch\u01b0a \u0111\u01b0\u1ee3c h\u1ecdc nhi\u1ec1u c\u00e1c h\u00e0m kh\u00e1c do \u0111\u00f3 khi \u0111i l\u00e0m B\u00e1ch v\u1eabn ph\u1ea3i t\u1ef1 h\u1ecdc v\u00e0 t\u00ecm hi\u1ec3u tr\u00ean Internet, \u0111\u00f4i khi c\u00f2n qu\u00ean c\u00e1ch s\u1eed d\u1ee5ng. Nay r\u1ea3nh B\u00e1ch ng\u1ed3i t\u1ed5ng h\u1ee3p v\u00e0 chia s\u1ebb l\u1ea1i v\u1edbi c\u00e1c b\u1ea1n, B\u00e1ch hy v\u1ecdng b\u00e0i vi\u1ebft gi\u00fap \u00edch ph\u1ea7n n\u00e0o \u0111\u00f3 cho nhu c\u1ea7u c\u1ee7a c\u00e1c b\u1ea1n.<\/p>\n

B\u00e1ch s\u1eafp x\u1ebfp theo A \u2013 Z nh\u00e9.<\/p>\n

ACCRINT (issue, first_interest, settlement, rate, par, frequency, basis, calc_method)<\/strong>: T\u00ednh l\u00e3i t\u00edch l\u0169y cho m\u1ed9t ch\u1ee9ng kho\u00e1n tr\u1ea3 l\u00e3i \u0111\u1ecbnh k\u1ef3.<\/p>\n

ACCRINTM (issue, settlement, rate, par, basis)<\/strong>:\u00a0T\u00ednh l\u00e3i t\u00edch l\u1ef9 cho m\u1ed9t ch\u1ee9ng kho\u00e1n tr\u1ea3 l\u00e3i theo k\u1ef9 h\u1ea1n.<\/p>\n

AMORDEGRC (cost, date_purchased, first_period, salvage, period, rate, basis)<\/strong>: T\u00ednh kh\u1ea5u hao trong m\u1ed7i t\u00e0i kh\u1ecfn k\u1ebf to\u00e1n t\u00f9y theo th\u1eddi h\u1ea1n s\u1eed d\u1ee5ng c\u1ee7a t\u00e0i s\u1ea3n. (S\u1eed d\u1ee5ng trong h\u1ec7 th\u1ed1ng k\u1ebf to\u00e1n ki\u1ec3u Ph\u00e1p).<\/p>\n

AMORLINC (cost, date_purchased, first_period, salvage, period, rate, basis)<\/strong>: T\u00ednh kh\u1ea5u hao trong m\u1ed7i t\u00e0i kho\u1ea3n k\u1ebf to\u00e1n (S\u1eed d\u1ee5ng trong h\u1ec7 th\u1ed1ng k\u1ebf to\u00e1n ki\u1ec3u Ph\u00e1p).<\/p>\n

COUPDAYBS (settlement, maturity, frequency, basis)<\/strong>:\u00a0T\u00ednh s\u1ed1 ng\u00e0y k\u1ec3 t\u1eeb \u0111\u1ea7u k\u1ef3 t\u1edbi ng\u00e0y k\u1ebft to\u00e1n.<\/p>\n

COUPDAYS (settlement, maturity, frequency, basis)<\/strong>:\u00a0T\u00ednh s\u1ed1 ng\u00e0y trong k\u1ef3 l\u00e3i bao g\u1ed3m c\u1ea3 ng\u00e0y k\u1ebft to\u00e1n.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

COUPDAYSCN (settlement, maturity, frequency, basis)<\/strong>:\u00a0T\u00ednh s\u1ed1 ng\u00e0y t\u1eeb ng\u00e0y k\u1ebft to\u00e1n t\u1edbi ng\u00e0y t\u00ednh l\u00e3i k\u1ebf ti\u1ebfp.<\/p>\n

COUPNCD (settlement, maturity, frequency, basis)<\/strong>: Tr\u1ea3 v\u1ec1 m\u1ed9t con s\u1ed1 th\u1ec3 hi\u1ec7n ng\u00e0y thanh to\u00e1n l\u00e3i l\u1ea7n tr\u01b0\u1edbc, tr\u01b0\u1edbc ng\u00e0y k\u1ebf to\u00e1n.<\/p>\n

COUPNUM (settlement, maturity, frequency, basis)<\/strong>: T\u00ednh s\u1ed1 l\u1ea7n l\u00e3i su\u1ea5t ph\u1ea3i tr\u1ea3 trong kho\u1ea3ng t\u1eeb ng\u00e0y k\u1ebft to\u00e1n \u0111\u1ebfn ng\u00e0y \u0111\u00e1o h\u1ea1n.
\nCOUPPCD (settlement, maturity, frequency, basis)<\/strong>: Tr\u1ea3 v\u1ec1 m\u1ed9t con s\u1ed1 th\u1ec3 hi\u1ec7n ng\u00e0y thanh to\u00e1n l\u00e3i l\u1ea7n tr\u01b0\u1edbc, tr\u01b0\u1edbc ng\u00e0y k\u1ebft to\u00e1n.<\/p>\n

CUMIPMT (rate, nper, pv, start_period, end_period, type)<\/strong>: T\u00ednh l\u1ee3i t\u1ee9c t\u00edch l\u0169y ph\u1ea3i tr\u1ea3 \u0111\u1ed1i v\u1edbi kho\u1ea3n vay trong kho\u1ea3ng th\u1eddi gian gi\u1eefa start_period v\u00e0 end_period.<\/p>\n

CUMPRINC (rate, nper, pv, start_period, end_period, type)<\/strong> :\u00a0Tr\u1ea3 v\u1ec1 ti\u1ec1n v\u1ed1n t\u00edch l\u0169y ph\u1ea3i tr\u1ea3 \u0111\u1ed1i v\u1edbi kho\u1ea3n vay trong kho\u1ea3ng th\u1eddi gian gi\u1eefa start_period v\u00e0 end_period.<\/p>\n

DB (cost, salvage, life, period, month)<\/strong>: T\u00ednh kh\u1ea5u hao cho m\u1ed9t t\u00e0i s\u1ea3n s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p s\u1ed1 d\u01b0 gi\u1ea3m d\u1ea7n theo m\u1ed9t m\u1ee9c c\u00f3 \u0111\u1ecbnh trong m\u1ed9t kho\u1ea3ng th\u1eddi gian x\u00e1c \u0111\u1ecbnh.<\/p>\n

DDB (cost, salvage, life, period, factor)<\/strong>: T\u00ednh kh\u1ea5u hao cho m\u1ed9t t\u00e0i s\u1ea3n s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p s\u1ed1 d\u01b0 gi\u1ea3m d\u1ea7n k\u00e9p, hay gi\u1ea3m d\u1ea7n theo m\u1ed9t t\u1ef7 l\u1ec7 n\u00e0o \u0111\u00f3, trong m\u1ed9t kho\u1ea3ng th\u1eddi gian x\u00e1c \u0111\u1ecbnh.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n

DISC (settlement, maturity, pr, redemption, basis)<\/strong>: T\u00ednh t\u1ef7 l\u1ec7 chi\u1ebft kh\u1ea5u c\u1ee7a m\u1ed9t ch\u1ee9ng kho\u00e1n.<\/p>\n

DOLLARDE (fractional_dollar, fraction)<\/strong>:\u00a0Chuy\u1ec3n \u0111\u1ed5i gi\u00e1 dollar \u1edf d\u1ea1ng ph\u00e2n s\u1ed1 sang gi\u00e1 dollar \u1edf d\u1ea1ng th\u1eadp ph\u00e2n.<\/p>\n

DOLLARFR (decimal_dollar, fraction)<\/strong>:\u00a0Chuy\u1ec3n \u0111\u1ed5i gi\u00e1 dollar \u1edf d\u1ea1ng th\u1eadp ph\u00e2n s\u1ed1 sang gi\u00e1 dollar \u1edf d\u1ea1ng ph\u00e2n s\u1ed1.<\/p>\n

EFFECT (nominal_rate, npery)<\/strong>: T\u00ednh l\u00e3i su\u1ea5t th\u1ef1c t\u1ebf h\u00e0ng n\u0103m, bi\u1ebft tr\u01b0\u1edbc l\u00e3i su\u1ea5t danh ngh\u0129a h\u00e0ng n\u0103m v\u00e0 t\u1ed5ng s\u1ed1 k\u1ef3 thanh to\u00e1n l\u00e3i k\u00e9p m\u1ed7i n\u0103m.<\/p>\n

FV (rate, nper, pmt, pv, type)<\/strong>: T\u00ednh gi\u00e1 tr\u1ecb k\u1ef3 h\u1ea1n (t\u01b0\u01a1ng lai) c\u1ee7a kho\u1ea3n\u00a0\u0111\u1ea7u t\u01b0 d\u1ef1a tr\u00ean vi\u1ec7c chi tr\u1ea3 c\u1ed1 \u0111\u1ecbnh theo k\u1ef3 v\u00e0 l\u00e3i su\u1ea5t c\u1ed1 \u0111\u1ecbnh.<\/p>\n

FVSCHEDULE (principal, schedule)<\/strong>: T\u00ednh gi\u00e1 tr\u1ecb k\u1ef3 h\u1ea1n c\u1ee7a m\u1ed9t v\u1ed1n ban \u0111\u1ea7u sau khi \u00e1p d\u1ee5ng m\u1ed9t chu\u1ed7i c\u00e1c l\u00e3i su\u1ea5t k\u00e9p (t\u00ednh gi\u00e1 tr\u1ecb k\u1ef3 h\u1ea1n cho m\u1ed9t \u0111\u1ea7u t\u01b0 c\u00f3 l\u00e3i su\u1ea5t thay \u0111\u1ed5i).<\/p>\n

INTRATE (settlement, maturity, investment, redemption, basis)<\/strong>: T\u00ednh l\u00e3i su\u1ea5t cho m\u1ed9t ch\u1ee9ng kho\u00e1n \u0111\u1ea7u t\u01b0 to\u00e0n b\u1ed9.<\/p>\n

IPMT (rate, per, nper, pv, fv, type)<\/strong>: Tr\u1ea3 v\u1ec1 kho\u1ea3n thanh to\u00e1n l\u00e3i cho m\u1ed9t \u0111\u1ea7u t\u01b0 d\u1ef1a tr\u00ean vi\u1ec7c chi tr\u1ea3 c\u1ed1 \u0111\u1ecbnh theo k\u1ef3 v\u00e0 d\u1ef1a tr\u00ean l\u00e3i su\u1ea5t kh\u00f4ng \u0111\u1ed5i.<\/p>\n

IRR (values, guess)<\/strong>: T\u00ednh l\u1ee3i su\u1ea5t n\u1ed9i h\u00e0m cho m\u1ed9t chu\u1ed7i c\u00e1c l\u01b0u \u0111\u1ed9ng ti\u1ec1n m\u1eb7t \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1edfi c\u00e1c tr\u1ecb s\u1ed1.<\/p>\n

ISPMT (rate, per, nper, pv)<\/strong>: T\u00ednh s\u1ed1 ti\u1ec1n l\u00e3i \u0111\u00e3 tr\u1ea3 t\u1ea1i m\u1ed9t k\u1ef3 n\u00e0o \u0111\u00f3 \u0111\u1ed1i v\u1edbi m\u1ed9t kho\u1ea3n vay c\u00f3 l\u00e3i su\u1ea5t kh\u00f4ng \u0111\u1ed5i, sau khi tr\u1eeb s\u1ed1 ti\u1ec1n g\u1ed1c ph\u1ea3i tr\u1ea3 cho k\u1ef3 \u0111\u00f3.<\/p>\n

MDURATION (settlement, maturity, coupon, yld, frequency, basis)<\/strong>: T\u00ednh th\u1eddi h\u1ea1n Macayley s\u1eeda \u0111\u1ed5i cho ch\u1ee9ng kho\u00e1n d\u1ef1a tr\u00ean \u0111\u1ed3ng m\u1ec7nh gi\u00e1 $100.<\/p>\n

MIRR (values, finance_rate, reinvest_rate)<\/strong>: T\u00ednh t\u1ef7 su\u1ea5t doanh l\u1ee3i n\u1ed9i t\u1ea1i trong m\u1ed9t chu\u1ed7i lu\u00e2n chuy\u1ec3n ti\u1ec1n m\u1eb7t theo chu k\u1ef3.<\/p>\n

NOMINAL (effect_rate, npery)<\/strong>: T\u00ednh l\u00e3i su\u1ea5t danh ngh\u0129a h\u00e0ng n\u0103m, bi\u1ebft tr\u01b0\u1edbc l\u00e3i su\u1ea5t th\u1ef1c t\u1ebf v\u00e0 c\u00e1c k\u1ef3 t\u00ednh l\u00e3i k\u00e9p m\u1ed7i n\u0103m.<\/p>\n

NPER (rate, pmt, pv, fv, type)<\/strong>: T\u00ednh s\u1ed1 k\u1ef3 h\u1ea1n \u0111\u1ec3 tr\u1ea3 kho\u1ea3n vay trong \u0111\u1ea7u t\u01b0 d\u1ef1a tr\u00ean t\u1eebng chu k\u1ef3, s\u1ed1 ti\u1ec1n tr\u1ea3 v\u00e0 t\u1ef7 su\u1ea5t l\u1ee3i t\u1ee9c c\u1ed1 \u0111\u1ecbnh.\n<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n

NPV (rate, value1, value2, \u2026):<\/strong> T\u00ednh hi\u1ec7n gi\u00e1 r\u00f2ng c\u1ee7a m\u1ed9t kho\u1ea3n \u0111\u1ea7u t\u01b0 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng\u00a0t\u1ef7 su\u1ea5t sinh l\u1eddi k\u1ef3 v\u1ecdng v\u00e0 c\u00e1c kho\u1ea3n thu nh\u1eadp h\u00e0ng k\u1ef3.\n<\/p>\n<\/div>\n<\/div>\n

\n
\n

ODDFPRICE (settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, basis)<\/strong>: T\u00ednh gi\u00e1 tr\u1ecb tr\u00ean m\u1ed7i \u0111\u1ed3ng m\u1ec7nh gi\u00e1 $100 c\u1ee7a ch\u1ee9ng kho\u00e1n c\u00f3 k\u1ef3 \u0111\u1ea7u ti\u00ean l\u1ebd (ng\u1eafn h\u1ea1n hay d\u00e0i h\u1ea1n).<\/p>\n

ODDFYIELD (settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, basis)<\/strong>: Tr\u1ea3 v\u1ec1 l\u1ee3i nhu\u1eadn c\u1ee7a m\u1ed9t ch\u1ee9ng kho\u00e1n c\u00f3 k\u1ef3 t\u00ednh l\u00e3i \u0111\u1ea7u ti\u00ean l\u00e0 l\u1ebb (ng\u1eafn h\u1ea1n hay d\u00e0i h\u1ea1n).<\/p>\n

ODDLPRICE (settlement, maturity, last_interest, rate, yld, redemption, frequency, basis)<\/strong>: T\u00ednh gi\u00e1 tr\u1ecb tr\u00ean m\u1ed7i \u0111\u1ed3ng m\u1ec7nh gi\u00e1 $100 c\u1ee7a ch\u1ee9ng kho\u00e1n c\u00f3 k\u1ef3 t\u00ednh l\u00e3i phi\u1ebfu cu\u1ed1i c\u00f9ng l\u00e0 l\u1ebb (ng\u1eafn h\u1ea1n hay d\u00e0i h\u1ea1n).<\/p>\n

ODDLYIELD (settlement, maturity, last_interest, rate, pr, redemption, frequency, basis)<\/strong>: T\u00ednh l\u1ee3i nhu\u1eadn c\u1ee7a ch\u1ee9ng kho\u00e1n c\u00f3 k\u1ef3 cu\u1ed1i c\u00f9ng l\u00e0 l\u1ebb (ng\u1eafn h\u1ea1n hay d\u00e0i h\u1ea1n).<\/p>\n

PMT (rate, nper, pv, fv, type)<\/strong>: T\u00ednh ti\u1ec1n ph\u1ea3i tr\u1ea3 \u0111\u1ed1i v\u1edbi kho\u1ea3n vay c\u00f3 l\u00e3i su\u1ea5t kh\u00f4ng \u0111\u1ed5i v\u00e0 chi tr\u1ea3 \u0111\u1ec1u \u0111\u1eb7n<\/p>\n

PPMT (rate, per, nper, pv, fv, type)<\/strong>: T\u00ednh kho\u1ea3n v\u1ed1n thanh to\u00e1n trong m\u1ed9t k\u1ef3 h\u1ea1n \u0111\u00e3 cho \u0111\u1ed1i v\u1edbi m\u1ed9t kho\u1ea3n \u0111\u1ea7u t\u01b0, trong \u0111\u00f3 vi\u1ec7c chi tr\u1ea3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n \u0111\u1ec1u \u0111\u1eb7n theo \u0111\u1ecbnh k\u1ef3 v\u1edbi m\u1ed9t l\u00e3i su\u1ea5t kh\u00f4ng \u0111\u1ed5i.<\/p>\n

PRICE (settlement, maturity, rate, yld, redemption, frequency, basis)<\/strong>: T\u00ednh gi\u00e1 tr\u1ecb ch\u1ee9ng kho\u00e1n tr\u00ean \u0111\u1ed3ng m\u1ec7nh gi\u00e1 $100, thanh to\u00e1n l\u1ee3i t\u1ee9c theo chu k\u1ef3.<\/p>\n

PRICEDISC (settlement, maturity, discount, redemption, basis)<\/strong>: T\u00ednh gi\u00e1 tr\u1ecb tr\u00ean \u0111\u1ed3ng m\u1ec7nh gi\u00e1 $100 c\u1ee7a m\u1ed9t ch\u1ee9ng kho\u00e1n \u0111\u00e3 chi\u1ebft kh\u1ea5u.<\/p>\n

PRICEMAT (settlement, maturity, issue, rate, yld, basis):<\/strong> T\u00ednh gi\u00e1 tr\u1ecb tr\u00ean \u0111\u1ed3ng m\u1ec7nh gi\u00e1 $100 c\u1ee7a m\u1ed9t ch\u1ee9ng kho\u00e1n ph\u1ea3i thanh to\u00e1n l\u00e3i v\u00e0o ng\u00e0y \u0111\u00e1o h\u1ea1n.<\/p>\n

PV (rate, nper, pmt, fv, type)<\/strong>: T\u00ednh gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i c\u1ee7a m\u1ed9t kho\u1ea3n \u0111\u1ea7u t\u01b0.<\/p>\n

RATE (nper, pmt, pv, fv, type, guess)<\/strong>: T\u00ednh l\u00e3i su\u1ea5t m\u1ed7i k\u1ef3 trong m\u1ed9t ni\u00ean kim.<\/p>\n

\n

\u0110\u1eebng b\u1ecf l\u1ee1: T\u00e0i li\u1ec7u\u00a0h\u1ecdc excel 2016<\/a><\/p>\n<\/blockquote>\n

REVEICED (settlement, maturity, investment, discount, basis)<\/strong>: T\u00ednh s\u1ed1 ti\u1ec1n nh\u1eadn \u0111\u01b0\u1ee3c v\u00e0o k\u1ef3 h\u1ea1n thanh to\u00e1n cho m\u1ed9t ch\u1ee9ng kho\u00e1n \u0111\u1ea7u t\u01b0 to\u00e0n b\u1ed9.<\/p>\n

SLN (cost, salvage, life)<\/strong>: T\u00ednh chi ph\u00ed kh\u1ea5u hao (theo ph\u01b0\u01a1ng ph\u00e1p \u0111\u01b0\u1eddng th\u1eb3ng) c\u1ee7a m\u1ed9t t\u00e0i s\u1ea3n trong m\u1ed9t k\u1ef3.<\/p>\n

SYD (cost, salvage, life, per)<\/strong>: T\u00ednh kh\u1ea5u hao theo gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a t\u00e0i s\u1ea3n trong \u0111\u1ecbnh k\u1ef3 x\u00e1c \u0111\u1ecbnh.<\/p>\n

TBILLEQ (settlement, maturity, discount)<\/strong>: T\u00ednh l\u1ee3i nhu\u1eadn t\u01b0\u01a1ng \u1ee9ng v\u1edbi tr\u00e1i phi\u1ebfu cho tr\u00e1i phi\u1ebfu kho b\u1ea1c.<\/p>\n

TBILLPRICE (settlement, maturity, discount)<\/strong>: T\u00ednh gi\u00e1 tr\u1ecb \u0111\u1ed3ng m\u1ec7nh gi\u00e1 $100 cho tr\u00e1i phi\u1ebfu kho b\u1ea1c.\n<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n

TBILLYIELD (settlement, maturity, pr)<\/strong>: T\u00ednh l\u1ee3i nhu\u1eadn cho tr\u00e1i phi\u1ebfu kho b\u1ea1c.<\/p>\n

XIRR (values, dates, guess)<\/strong>: T\u00ednh l\u1ee3i su\u1ea5t n\u1ed9i h\u00e0m cho m\u1ed9t lo\u1ea1t l\u01b0u \u0111\u1ed9ng ti\u1ec1n m\u1eb7t kh\u00f4ng \u0111\u1ecbnh k\u1ef3.<\/p>\n

XNPV (rate, values, dates)<\/strong>: T\u00ednh t\u1ef7 gi\u00e1 r\u00f2ng cho m\u1ed9t d\u00e3y l\u01b0u \u0111\u1ed9ng ti\u1ec1n m\u1eb7t kh\u00f4ng \u0111\u1ecbnh k\u1ef3.<\/p>\n

YIELD (settlement, maturity, rate, pr, redemption, frequency, basis):<\/strong> T\u00ednh l\u1ee3i nhu\u1eadn \u0111\u1ed1i v\u1edbi ch\u1ee9ng kho\u00e1n tr\u1ea3 l\u00e3i theo \u0111\u1ecbnh k\u1ef3.<\/p>\n

YIELDDISC (settlement, maturity, pr, redemption, basis)<\/strong>: T\u00ednh l\u1ee3i nhu\u1eadn h\u00e0ng n\u0103m cho ch\u1ee9ng kho\u00e1n \u0111\u00e3 chi\u1ebft kh\u1ea5u.<\/p>\n

YIELDMAT (settlement, maturity, issue, rate, pr, basis)<\/strong>: T\u00ednh l\u1ee3i nhu\u1eadn h\u00e0ng n\u0103m c\u1ee7a ch\u1ee9ng kho\u00e1n tr\u1ea3 l\u00e3i v\u00e0o ng\u00e0y \u0111\u00e1o h\u1ea1n.<\/p>\n

Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c h\u00e0m t\u00e0i ch\u00ednh B\u00e1ch t\u1ed5ng h\u1ee3p l\u1ea1i \u0111\u1ec3 c\u00e1c b\u1ea1n \u0111\u01b0\u1ee3c bi\u1ebft. Hy v\u1ecdng nh\u1eefng h\u00e0m n\u00e0y gi\u00fap c\u00e1c b\u1ea1n gi\u1ea3i quy\u1ebft c\u00e1c d\u1eef li\u1ec7u tr\u00ean Excel nhanh h\u01a1n, hi\u1ec7u qu\u1ea3 cao h\u01a1n.<\/p>\n

Ngo\u00e0i ra, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 h\u1ecdc nh\u1eefng h\u00e0m, c\u00f4ng c\u1ee5 c\u00f9ng c\u00e1c \u1ee9ng d\u1ee5ng kh\u00e1c tr\u00ean Excel m\u00e0 kh\u00f4ng c\u1ea7n t\u1edbi c\u00e1c l\u1edbp h\u1ecdc hay c\u1ed1 \u0111\u1ecbnh th\u1eddi gian, m\u00e0 h\u1ecdc \u0111\u01b0\u1ee3c t\u1ea1i nh\u00e0 v\u00e0 h\u1ecdc v\u00e0o th\u1eddi gian b\u1ea1n r\u1ea3nh.\u00a0To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c Excel m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/a><\/p>\n

\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12406,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12405","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\/12405","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=12405"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12405\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12406"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}