DOLLARFR Function in Excel: Decimal Prices to Fractions
DOLLARFR is the reverse of DOLLARDE: 1.125 with fraction 16 becomes 1.02 (1 and 2/16).
Read article →Financial
Excel Financial functions explained with syntax, examples and common mistakes.
STOCKHISTORY Function in Excel: Historical Share Prices
STOCKHISTORY Function in Excel: Historical Share Prices
STOCKHISTORY fetches daily, weekly or monthly prices for a stock or currency pair into a spill range.
Read article →DOLLARDE Function in Excel: Fractional Prices to Decimals
DOLLARDE Function in Excel: Fractional Prices to Decimals
DOLLARDE converts prices quoted in fractions (like 1 and 2/16) into decimals — still seen in some bond and commodity feeds.
Read article →ISPMT Function in Excel: Interest on Equal-Principal Loans
ISPMT Function in Excel: Interest on Equal-Principal Loans
ISPMT calculates interest for a loan where the principal is repaid in equal parts (not an EMI). Note the period argument starts at 0.
Read article →DURATION Function in Excel: How Sensitive a Bond Is to Rates
DURATION Function in Excel: How Sensitive a Bond Is to Rates
DURATION returns Macaulay duration in years. Roughly, a bond with duration 7 loses about 7% in price if rates rise 1% — which is…
Read article →NOMINAL Function in Excel: Effective Rate Back to Nominal
NOMINAL Function in Excel: Effective Rate Back to Nominal
NOMINAL reverses EFFECT: it tells you the quoted annual rate behind an effective yield.
Read article →PRICE Function in Excel: Bond Price From Its Yield
PRICE Function in Excel: Bond Price From Its Yield
PRICE returns a bond’s price per 100 face value. When market yield rises above the coupon, price falls below 100 — the see-saw every…
Read article →ACCRINT Function in Excel: Interest Earned Since Last Coupon
ACCRINT Function in Excel: Interest Earned Since Last Coupon
ACCRINT calculates interest that has built up on a bond — the amount a buyer pays the seller on top of the quoted price.
Read article →YIELD Function in Excel: Bond Yield From Its Price
YIELD Function in Excel: Bond Yield From Its Price
YIELD is the reverse of PRICE: what annual return you lock in if you buy at today’s price and hold to maturity.
Read article →VDB Function in Excel: Depreciation for Any Span
VDB Function in Excel: Depreciation for Any Span
VDB returns declining-balance depreciation between any two periods and, by default, switches to straight-line when that gives more — as many tax rules expect.
Read article →SYD Function in Excel: Sum-of-Years’ Digits Depreciation
SYD Function in Excel: Sum-of-Years’ Digits Depreciation
SYD is another accelerated method, gentler than DDB. For a 5-year life the fractions are 5/15, 4/15, 3/15 and so on.
Read article →DDB Function in Excel: Double-Declining Depreciation
DDB Function in Excel: Double-Declining Depreciation
DDB front-loads depreciation: more in early years, less later. It suits laptops and vehicles that lose value fast.
Read article →