Annuities Introduction
Annuity
An annuity is defined as a series of equal dollar payments made for a specified number of years at regular intervals. They are a fundamental concept in finance, especially in areas like retirement planning, loan amortization, and investing.
Ordinary Annuity
If the payments occur at the end of each period, the annuity is classified as an ordinary annuity. Unless explicitly stated otherwise, when the term "annuity" is used, it typically refers to an ordinary annuity.
Annuity Due
If the payments occur at the beginning of each period, the annuity is an annuity due. An annuity due can be conceptualized as an ordinary annuity where all the payments have been shifted forward by one year.
Ordinary Annuity vs. Annuity Due Visual Representation
graph TD
subgraph Ordinary Annuity
A[PMT] --> B[PMT]
B --> C[PMT]
C --> D[...]
D --> E[PMT]
end
subgraph Annuity Due
F[PMT] --> G[PMT]
G --> H[PMT]
H --> I[...]
I --> J[PMT]
end
A -.-> 0(Time 0)
A -- Payment at end of Period 1 --> 1(Time 1)
B -- Payment at end of Period 2 --> 2(Time 2)
C -- Payment at end of Period 3 --> 3(Time 3)
F -- Payment at beginning of Period 1 --> 0(Time 0)
G -- Payment at beginning of Period 2 --> 1(Time 1)
H -- Payment at beginning of Period 3 --> 2(Time 2)
style 0 fill:#fff,stroke:#fff,stroke-width:0px
style 1 fill:#fff,stroke:#fff,stroke-width:0px
style 2 fill:#fff,stroke:#fff,stroke-width:0px
style 3 fill:#fff,stroke:#fff,stroke-width:0px
Ordinary Annuity Timeline: Payments (PMT) occur at times t=1,2,3,extetc.
graph LR
0(0) --> 1[PMT]
1 --> 2[PMT]
2 --> 3[PMT]
Annuity Due Timeline: Payments (PMT) occur at times t=0,1,2,extetc.
graph LR
0[PMT] --> 1[PMT]
1 --> 2[PMT]
2 --> 3[PMT]
Future Value of an Ordinary Annuity (FVAn)
Example: Calculating Future Value of a 3-year Ordinary Annuity
Consider a three-year ordinary annuity with $400 payments at an annual interest rate of 5%.
Cash Flow Breakdown and Accumulation at End of Year 3:
Payment 1 (at end of Year 1): Accrues interest for 2 years. Value at Year 3 = 400imes(1.05)2=441.00
Payment 2 (at end of Year 2): Accrues interest for 1 year. Value at Year 3 = 400imes(1.05)1=420.00
Payment 3 (at end of Year 3): Accrues interest for 0 years. Value at Year 3 = 400imes(1.05)0=400.00
Total Future Value (FVA3) at the end of Year 3 = 441.00+420.00+400.00=1,261.00
FVAn Equation Solution
The future value of an ordinary annuity can be calculated using the formula:
FVAn=PMTimesrac(1+r)n−1r
Applying this to the example:
FVA<em>3=400imesrac(1+0.05)3−10.05 FVA</em>3=400imesrac(1.157625)−10.05
FVA<em>3=400imesrac0.1576250.05 FVA</em>3=400imes(3.1525)=1,261.00
FVAn Financial Calculator Solution
For a three-year ordinary annuity of $400 at 5%:
N = 3 (Number of periods)
I/Y = 5 (Interest rate per year)
PMT = −400 (Payment amount, entered as negative for cash outflow)
PV = 0 (Present value, initially zero for an annuity FV calculation)
FV = 1,261.00 (Computed Future Value)
Future Value of an Annuity Due (FVA(Due)n)
Example: Calculating Future Value of a 3-year Annuity Due
Consider a three-year annuity due with $400 payments at an annual interest rate of 5%.
Cash Flow Breakdown and Accumulation at End of Year 3:
Payment 1 (at beginning of Year 1 / Time 0): Accrues interest for 3 years. Value at Year 3 = 400imes(1.05)3=463.05
Payment 2 (at beginning of Year 2 / Time 1): Accrues interest for 2 years. Value at Year 3 = 400imes(1.05)2=441.00
Payment 3 (at beginning of Year 3 / Time 2): Accrues interest for 1 year. Value at Year 3 = 400imes(1.05)1=420.00
Total Future Value (FVA(Due)3) at the end of Year 3 = 463.05+441.00+420.00=1,324.05
Relationship with Ordinary Annuity
Annuity due future value can also be found by multiplying the ordinary annuity future value by (1+r):
FVA(Due)<em>n=FVA</em>nimes(1+r)
Using the previous example: 1,261.00imes(1+0.05)=1,261.00imes1.05=1,324.05
FVA(Due) Equation Solution
The future value of an annuity due can be calculated using the formula:
FVA(DUE)n=PMTimesrac(1+r)n−1rimes(1+r)
Applying this to the example:
FVA(DUE)<em>3=400imesrac(1.05)3−10.05imes(1.05) FVA(DUE)</em>3=400imes(3.1525)imes(1.05)=1,324.05
FVA(Due) Financial Calculator Solution
For a three-year annuity due of $400 at 5%:
N = 3
I/Y = 5
PMT = −400
PV = 0
FV = 1,324.05
Note: When working with Annuity Due, set the financial calculator to [BGN] mode by pressing [2nd] [BGN] [2nd] [SET]. The [BGN] indicator will appear on the top right corner of the screen.
Present Value of an Ordinary Annuity (PVAn)
Example: Calculating Present Value of a 3-year Ordinary Annuity
Consider a three-year ordinary annuity with $400 payments if the discount rate is 5%.
Cash Flow Breakdown and Discounting to Year 0:
Payment 1 (at end of Year 1): Discounted for 1 year. Value at Year 0 = 400imes(1.05)−1=380.95
Payment 2 (at end of Year 2): Discounted for 2 years. Value at Year 0 = 400imes(1.05)−2=362.81
Payment 3 (at end of Year 3): Discounted for 3 years. Value at Year 0 = 400imes(1.05)−3=345.54
Total Present Value (PVA3) at Year 0 = 380.95+362.81+345.54=1,089.30
PVA Equation Solution
The present value of an ordinary annuity can be calculated using the formula:
PVAn=PMTimesrac1−rac1(1+r)nr
Applying this to the example:
PVA<em>3=400imesrac1−rac1(1.05)30.05 PVA</em>3=400imesrac1−0.863837590.05
PVA<em>3=400imesrac0.136162410.05 PVA</em>3=400imes(2.723248)=1,089.30
PVAn Financial Calculator Solution
For a three-year ordinary annuity of $400 at 5%:
Present Value of an Annuity Due (PVA(Due)n)
Example: Calculating Present Value of a 3-year Annuity Due
Consider a three-year annuity due with $400 payments if the discount rate is 5%.
Cash Flow Breakdown and Discounting to Year 0:
Payment 1 (at beginning of Year 1 / Time 0): Value at Year 0 = 400imes(1.05)0=400.00
Payment 2 (at beginning of Year 2 / Time 1): Discounted for 1 year. Value at Year 0 = 400imes(1.05)−1=380.95
Payment 3 (at beginning of Year 3 / Time 2): Discounted for 2 years. Value at Year 0 = 400imes(1.05)−2=362.81
Total Present Value (PVA(DUE)3) at Year 0 = 400.00+380.95+362.81=1,143.76
Relationship with Ordinary Annuity
Annuity due present value can also be found by multiplying the ordinary annuity present value by (1+r):
PVA(Due)<em>n=PVA</em>nimes(1+r)
Using the previous example: 1,089.30imes(1+0.05)=1,089.30imes1.05=1,143.76
PVA(Due) Equation Solution
The present value of an annuity due can be calculated using the formula:
PVA(DUE)n=PMTimesrac1−rac1(1+r)nrimes(1+r)
Applying this to the example:
PVA(DUE)<em>3=400imesrac1−rac1(1.05)30.05imes(1.05) PVA(DUE)</em>3=400imes(2.723248)imes(1.05)=1,143.76
PVA(Due) Financial Calculator Solution
For a three-year annuity due of $400 at 5%:
N = 3
I/Y = 5
PMT = −400
FV = 0
PV = 1,143.76
Note: Ensure the financial calculator is in [BGN] mode. If it’s not, set it by pressing [2nd] [BGN] [2nd] [SET]. This will show [BGN] on the screen.
Annuity Examples Using Financial Calculator
Example 1: Finding Future Value of an Annuity Due (FVA(Due))
Problem: If you deposit $500 at the beginning of each year for the next 5 years in a savings account paying 6% interest, how much will you have at the end of year 5?
Solution Steps:
Since deposits are made at the beginning of each year, set the financial calculator to [BGN] Mode.
Input:
N = 5
I/Y = 6
PV = 0
PMT = −500
Compute FV <br>ightarrow FV = 2,987.66
Example 2: Finding Number of Periods (N)
Problem: Suppose you decide to make end-of-year deposits of $1,200 per year. Assuming you earn 6% annually, how long would it take to reach your $10,000 goal?
Solution Steps:
Since deposits are end-of-year, the calculator should be in [END] mode (default).
Input:
I/Y = 6
PMT = −1,200
PV = 0
FV = 10,000
Compute N <br>ightarrow N = 6.96 years
Example 3: Finding Payment Amount (PMT) - Two-Step Problem
Problem: You will start making 35 deposits of $3,000 per year in your Individual Retirement Account (from t=1 to t=35). With the money accumulated at t=35, you will then buy a retirement annuity of 20 years with equal yearly payments from a life insurance company (payments from t=36 to t=55). If the annual rate of return over the entire period is 8%, what will be the annual payment of the retirement annuity?
Solution Steps:
This problem involves two annuities.
Step 1: Find the Future Value (FV) of the 35-payment accumulation annuity (from t=1 to t=35) at t=35.
Input:
N = 35
I/Y = 8
PV = 0
PMT = −3000
**Output: FV = 516,950.41
*This FV at t=35 becomes the PV for the next annuity stream.*
Step 2: Find the PMT of the 20-payment retirement annuity (from t=36 to t=55).
Input:
N = 20
I/Y = 8
PV = −516,950.41 (This is the amount available at t=35 that needs to be paid out; entered as negative because it's conceptually an initial outlay to fund the annuity)
FV = 0 (The annuity is exhausted after 20 years)
**Output: PMT = 52,652.54
Example 4: Finding Interest Rate (I)
Problem: You lend your friend $100,000. He will pay you $13,000 per year for ten years. What is the interest rate you are charging your friend?
Solution Steps:
Input:
N = 10
PV = −100,000 (The initial loan outflow)
PMT = 13,000 (The annual payment received)
FV = 0 (The loan balance is zero at the end)
**Output: I/Y = 5.0787
Perpetuities
Definition
A perpetuity is a special type of annuity that continues forever, meaning the payments are expected to last indefinitely.
Examples of Perpetuities
British Consol: A historical type of perpetual bond issued by the British government.
Preferred Stock: Often pays a fixed dividend indefinitely, making it a form of perpetuity.
Present Value of a Perpetuity
The present value (PV) of a perpetuity is given by the formula:
PVPerpetuity=racPMTr
Where:
PMT = The constant dollar amount provided by the perpetuity each period.
r = The annual interest (or discount) rate.
More formally, this can be represented as an infinite sum: PV{Perpetuity} = }This formula simplifies the infinite series: $
Examples: Perpetuity Calculation
Find the Annual Cash Flow (PMT)
Problem: Suppose the value of a perpetuity is $38,900 and the discount rate is 12% p.a. What must be the annual cash flow from this perpetuity?
Solution: Using the formula PMT=PVimesr
PMT=38,900imes0.12=4,668
Find the Required Rate of Return (r)
Problem: An asset that generates $890 per year forever is priced at $6,000. What is the required rate of return?
Solution: Using the formula r=racPMTPV
r = rac{890}{6,000} = 0.148333 ext{ or } 14.83 ext{%}
Uneven Cash Flows
Types of Uneven Cash Flow Problems
There are two main categories of problems involving uneven cash flows:
Annuity plus additional initial/final payment: These problems can often be solved using the standard Time Value of Money (TVM) Worksheet on a financial calculator, sometimes by separating the annuity component from the lump sum.
Irregular cash flows: These involve cash flows that do not follow a repeating pattern. For such problems, the Cash Flow (CF) Worksheet on a financial calculator is typically used.
Present Value of Uneven Cash Flows
The present value of a series of uneven cash flows is calculated by discounting each individual cash flow back to time zero and summing them up. The formula is:
PVCF<em>N=racCF</em>1(1+r)1+racCF<em>2(1+r)2+ext…+racCF</em>N(1+r)N= ext{ }(1+r)^{t}</p><ul><li><p>CF_t=Thecashflowattimet.</p></li><li><p>r = The annual interest (or discount) rate.
BAII Plus Cash Flow Worksheet - Explained
For handling irregular cash flows, the BAII Plus financial calculator has a specific Cash Flow Worksheet.
Key Function Buttons:
[CF]: Used to access the Cash Flow Worksheet and to input the initial cash flow (CF0).
[C0n]: Represents the amount of the nth cash flow. You cycle through cash flows by pressing the down arrow after entering a C0n.
[F0n]: Stands for the frequency of the nth cash flow. This is used if a particular cash flow amount repeats for a number of periods consecutively.
[I]: Used within the NPV/IRR worksheet to enter the annual interest (or discount) rate.
[NPV]: Used to access the Net Present Value (NPV) Worksheet and compute NPV.
[IRR]: Used to access the Internal Rate of Return (IRR) Worksheet and compute IRR.
Clearing the Worksheet: To clear all variables in the Cash Flow Worksheet, press [CF], and then [2nd] [CLR WORK].
Example 1: Uneven Cash Flows - Calculating Net Present Value (NPV)
Problem: An asset promises the following cash flows: $5,000 at the end of each of the first three years, $7,000 at the end of each of the following four years, and $9,000 at the end of each of the following five years. If your required rate of return is 10%, how much is this asset worth to you (i.e., what is its Present Value)?
Solution Steps (using Financial Calculator):
Enter Cash Flows:
Press [CF] to access the Cash Flow Worksheet.
Enter CF0 = 0 (assuming no initial outlay, if it's a valuation). Then press [ENTER] and the down arrow.
C01 = 5,000,F01=3 (for 3 years of $5,000). Press [ENTER] and the down arrow after each.
C02 = 7,000,F02=4 (for 4 years of $7,000). Press [ENTER] and the down arrow after each.
C03 = 9,000,F03=5 (for 5 years of $9,000). Press [ENTER] and the down arrow after each.
Compute NPV:
Press [NPV].
Enter I = 10 (for 10% interest rate). Press [ENTER].
Press the down arrow.
Press [CPT] (Compute) NPV
ightarrow ∗∗NPV=46,612.68
Example 2: Uneven Cash Flows - Calculating Internal Rate of Return (IRR)
Problem: You lend your friend $100,000. He will pay you $12,000 per year for ten years and a balloon payment of $50,000 at t=10.Whatistheinterestrateyouarechargingyourfriend?</p><p><strong>SolutionSteps(usingFinancialCalculator):</strong></p><ol><li><p><strong>EnterCashFlows:</strong></p><ul><li><p>Press<strong>[CF]</strong>toaccesstheCashFlowWorksheet.</p></li><li><p>Enter<strong>CF0=-100,000</strong>(Theinitialloangiven,anoutflow).Press<strong>[ENTER]</strong>andthedownarrow.</p></li><li><p>C01=12,000,F01=9 (for 9 years of $12,000 payments). Press [ENTER] and the down arrow after each.
C02 = 62,000,F02=1 (This is the 10th year payment: $12,000 annuity payment + $50,000 balloon payment). Press [ENTER] and the down arrow after each.
Compute IRR:
Press [IRR].
Press [CPT] (Compute) IRR
ightarrow ∗∗IRR=8.6543</p></li></ul></li></ol><p><strong>AlternativeSolutionusingTVMWorksheet(applicablebecauseballoonpaymentsimplifiestheunevencashflowtoaknownFV):</strong></p><ol><li><p><strong>Input:</strong></p><ul><li><p><strong>N</strong>=10</p></li><li><p><strong>PV</strong>=-100,000</p></li><li><p><strong>PMT</strong>=12,000</p></li><li><p><strong>FV</strong>=50,000</p></li></ul></li><li><p>∗∗Output:I/Y=8.6543</p></li></ol><h4id="b1ee6e69−0e12−48f1−86ad−110d8a3793c0"data−toc−id="b1ee6e69−0e12−48f1−86ad−110d8a3793c0"collapsed="false"seolevelmigrated="true">Semi−AnnualandOtherCompoundingPeriods</h4><h5id="6363ba02−5bd8−48ac−a4d1−92fd782010eb"data−toc−id="6363ba02−5bd8−48ac−a4d1−92fd782010eb"collapsed="false"seolevelmigrated="true">Compounding</h5><p>Compoundingreferstotheabilityofanassettogenerateearnings,whicharethenreinvestedtogeneratetheirownearnings.It′stheprocessofearningreturnsonpreviousreturns.</p><ul><li><p><strong>AnnualCompounding:</strong>Interestisaddedtotheprincipalonceayear.</p></li><li><p><strong>Semi−annualCompounding:</strong>Interestisaddedtotheprincipaltwiceayear.</p></li><li><p><strong>ContinuousCompounding:</strong>Interestisaddedtotheprincipalconstantlyandateveryinstant.</p></li></ul><p><strong>ImpactofCompoundingFrequency:</strong>Thefuturevalue(FV)ofalumpsumwillalwaysbelargerifinterestiscompoundedmoreoften,assumingthestatedinterestrateremainsconstant.Thisisbecauseearlierreinvestmentopportunitiesallowearningstogeneratefurtherearningsoveralongerduration.</p><h5id="1310088d−5f2f−4044−84b8−f3d13b13fa82"data−toc−id="1310088d−5f2f−4044−84b8−f3d13b13fa82"collapsed="false"seolevelmigrated="true">CompoundingFrequency(M)</h5><p>Sayingthatthecompoundingperiodislessthanoneyearisequivalenttosayingthatthefrequencyofcompounding(M)ismorethanonceperyear.</p><tablestyle="min−width:50px;"><colgroup><colstyle="min−width:25px;"><colstyle="min−width:25px;"></colgroup><tbody><tr><thcolspan="1"rowspan="1"style="text−align:left;"><p>CompoundingPeriod</p></th><thcolspan="1"rowspan="1"style="text−align:left;"><p>CompoundingFrequency(M)</p></th></tr><tr><tdcolspan="1"rowspan="1"style="text−align:left;"><p>Annual</p></td><tdcolspan="1"rowspan="1"style="text−align:left;"><p>1</p></td></tr><tr><tdcolspan="1"rowspan="1"style="text−align:left;"><p>Semi−annual</p></td><tdcolspan="1"rowspan="1"style="text−align:left;"><p>2</p></td></tr><tr><tdcolspan="1"rowspan="1"style="text−align:left;"><p>Quarter</p></td><tdcolspan="1"rowspan="1"style="text−align:left;"><p>4</p></td></tr><tr><tdcolspan="1"rowspan="1"style="text−align:left;"><p>Month</p></td><tdcolspan="1"rowspan="1"style="text−align:left;"><p>12</p></td></tr><tr><tdcolspan="1"rowspan="1"style="text−align:left;"><p>Day</p></td><tdcolspan="1"rowspan="1"style="text−align:left;"><p>365</p></td></tr></tbody></table><h4id="1d6adb6d−5b9a−48d9−806f−b8d28829cf00"data−toc−id="1d6adb6d−5b9a−48d9−806f−b8d28829cf00"collapsed="false"seolevelmigrated="true">NominalInterestRate</h4><h5id="2eadd6e4−6810−43c1−8cb4−ece1e102bfac"data−toc−id="2eadd6e4−6810−43c1−8cb4−ece1e102bfac"collapsed="false"seolevelmigrated="true">DefinitionofNominalInterestRate(r_{NOM})</h5><p>Thenominalinterestrateisalsoknownasthesimplerate(r_{SIMPLE}),quotedrate,annualpercentagerate(APR),orstatedrate.Itisanannualratethatignorestheeffectsofcompoundingwithintheyear.</p><h5id="820bd255−228d−45e9−8c0f−4e873ed34da7"data−toc−id="820bd255−228d−45e9−8c0f−4e873ed34da7"collapsed="false"seolevelmigrated="true">KeyCharacteristics</h5><ul><li><p>r_{NOM}istypicallystatedincontracts.</p></li><li><p>Whenr_{NOM}isquoted,thecompoundingfrequency(e.g.,compoundedquarterly,compoundeddaily)<strong>must</strong>bespecifiedtoprovideclarityonhowinterestisactuallycalculated.</p></li><li><p><strong>Examples:</strong></p><ul><li><p>8r_{PER})</h4><h5id="8f4baaf6−a793−4478−9bb6−53823ddc6073"data−toc−id="8f4baaf6−a793−4478−9bb6−53823ddc6073"collapsed="false"seolevelmigrated="true">DefinitionofPeriodicRate(r_{PER})</h5><p>Theperiodicrateistheamountofinterestcharged(orearned)eachcompoundingperiod.Thiscouldbemonthly,quarterly,semi−annually,etc.,dependingonthestatedcompoundingfrequency.</p><h5id="9b796eca−aa53−4d67−a3b0−49557049fd95"data−toc−id="9b796eca−aa53−4d67−a3b0−49557049fd95"collapsed="false"seolevelmigrated="true">Formula</h5><p>Theperiodicrateiscalculatedbydividingthenominalratebythenumberofcompoundingperiodsperyear:<br>r{PER} = rac{r{NOM}}{M}<br>WhereMisthenumberofcompoundingperiodsperyear(e.g.,M=4forquarterly,M=12formonthlycompounding).</p><h5id="6b39be56−00d9−46a5−b5a0−f73277b69433"data−toc−id="6b39be56−00d9−46a5−b5a0−f73277b69433"collapsed="false"seolevelmigrated="true">Examples</h5><ul><li><p>For8r_{PER} = 8 ext{%} / 4 = 2 ext{%}perquarter.</p></li><li><p>For8r_{PER} = 8 ext{%} / 12 = 0.666… ext{ %} ext{ or } 0.667 ext{%}permonth.</p></li></ul><h4id="91e190f9−61d2−48bf−bc85−4723edd0b24e"data−toc−id="91e190f9−61d2−48bf−bc85−4723edd0b24e"collapsed="false"seolevelmigrated="true">EffectiveAnnualRate(rEAR)</h4><h5id="2a041d72−ec30−4900−898f−89cc2c67f8f5"data−toc−id="2a041d72−ec30−4900−898f−89cc2c67f8f5"collapsed="false"seolevelmigrated="true">DefinitionofEffectiveAnnualRate(r_{EAR})</h5><p>Theeffectiveannualrate,alsoknownastheequivalentannualrate,istheactualannualrateofreturnearnedorpaidonaninvestmentorloan,takingintoaccounttheeffectofcompoundingoveraone−yearperiod.Itistheratethatwouldproducethesamefuturevalueunderannualcompoundingaswouldmorefrequentcompoundingatagivennominalrate.</p><h5id="0a95260b−973a−4d92−8227−333b220eeb6c"data−toc−id="0a95260b−973a−4d92−8227−333b220eeb6c"collapsed="false"seolevelmigrated="true">Purpose</h5><p>Toaccuratelycompareinvestmentsorloanswithdifferentcompoundingintervals,itisessentialtoconverttheirnominalratestotheireffectiveannualrates(r_{EAR}).</p><h5id="92dba79c−4cec−4f78−96b6−62becacf4b78"data−toc−id="92dba79c−4cec−4f78−96b6−62becacf4b78"collapsed="false"seolevelmigrated="true">RelationshipbetweenNominalandEffectiveRate</h5><p>Theformulatocalculatetheeffectiveannualratefromanominalrateandcompoundingfrequencyis:<br>r{EAR} = (1 + rac{r{NOM}}{M})^M - 1<br>WhereMisthenumberofcompoundingperiodsperyear.</p><h5id="20c8f4fe−d2cf−4e32−bcb2−b4b8dba0da51"data−toc−id="20c8f4fe−d2cf−4e32−bcb2−b4b8dba0da51"collapsed="false"seolevelmigrated="true">Computingr_{EAR}Example</h5><p><strong>Problem:</strong>Whatistheeffectiveannualreturn(EAR)foraninvestmentthatpays12r{NOM} = 0.12andM = 12r{EAR} = (1 + rac{0.12}{12})^{12} - 1<br>r{EAR} = (1 + 0.01)^{12} - 1r{EAR} = (1.01)^{12} - 1<br></p><p><strong>Solution(usingFinancialCalculatorICONVWorksheet):</strong></p><ol><li><p>Press<strong>[2nd][ICONV]</strong>toaccesstheworksheet.</p></li><li><p>Enter<strong>NOM=12</strong>,thenpress<strong>[ENTER]</strong>andthedownarrow.</p></li><li><p>Enter<strong>C/Y=12</strong>(formonthlycompounding),thenpress<strong>[ENTER]</strong>andthedownarrow.</p></li><li><p>Press<strong>[CPT]</strong>(Compute)<strong>EFF</strong>
ightarrow <strong>EFF=12.68</strong></p></li></ol><h5id="b053cf99−870a−488e−8dbc−1038e03bbd27"data−toc−id="b053cf99−870a−488e−8dbc−1038e03bbd27"collapsed="false"seolevelmigrated="true">VariationofEffectiveReturnwithCompoundingIntervals</h5><p>Foraconstantnominalrate(e.g.,1010.00 ext{%}</p></li><li><p><strong>EAR(Semi−annualCompounding):</strong>10.25 ext{%}</p></li><li><p><strong>EAR(QuarterlyCompounding):</strong>10.38 ext{%}</p></li><li><p><strong>EAR(MonthlyCompounding):</strong>10.47 ext{%}</p></li><li><p><strong>EAR(DailyCompounding−365days):</strong>10.52 ext{%}</p></li></ul><h4id="03ffb85d−daf5−45b9−b5a2−26a242b2042b"data−toc−id="03ffb85d−daf5−45b9−b5a2−26a242b2042b"collapsed="false"seolevelmigrated="true">WhenIsEachRateUsed?</h4><p>Understandingwhentouseeachtypeofinterestrateiscrucialforaccuratefinancialcalculations.</p><ul><li><p><strong>NominalInterestRate(r_{NOM}):</strong></p><ul><li><p>Usedincontractsandquotedbybanks/brokers.</p></li><li><p><strong>Notgenerallyuseddirectlyincalculationsorshownonfinancialtimelines(unlessM=1).</strong></p></li></ul></li><li><p><strong>PeriodicRate(r_{PER}):</strong></p><ul><li><p><strong>Alwaysusedincalculationswhendealingwithnon−annualcompounding.</strong></p></li><li><p>Isreflectedonspecificcompoundingperiodtimelines.</p></li><li><p><strong>IfM=1(annualcompounding),thenr{NOM} = r{PER} = r_{EAR}</strong>.</p></li></ul></li><li><p><strong>EffectiveAnnualRate(r_{EAR}):</strong></p><ul><li><p><strong>Usedtocomparereturnsoninvestmentsorcostsofloansthathavedifferentpayment/compoundingfrequenciesperyear.</strong>Itprovidesastandardizedannualcomparison.</p></li><li><p><strong>Usedincalculationswhenannuitypaymentsdonotmatchthecompoundingperiods.</strong>Insuchcases,ther_{EAR}isoftenusedtoensureconsistencyoveranannualperiod.</p></li></ul></li></ul><h4id="e1ce129f−2875−4234−ba82−2482fc7cf096"data−toc−id="e1ce129f−2875−4234−ba82−2482fc7cf096"collapsed="false"seolevelmigrated="true">FindingPVandFVwithNon−AnnualPeriods</h4><p>Whencompoundingoccursmorefrequentlythanannually,theformulasforPVandFVmustincorporatetheperiodicrate(r_{PER})andthetotalnumberofcompoundingperiods(M imes N).</p><h5id="3b68a282−797b−433f−9566−06b3a2af760f"data−toc−id="3b68a282−797b−433f−9566−06b3a2af760f"collapsed="false"seolevelmigrated="true">FutureValue(FV)Formula</h5><p>FV = PV imes ext{ }(1 + rac{r}{M})^{M imes N} = PV imes (1 + r_{PER})^{M imes N}</p><h5id="8b53761b−e907−41ba−b4df−6825e6918ccd"data−toc−id="8b53761b−e907−41ba−b4df−6825e6918ccd"collapsed="false"seolevelmigrated="true">PresentValue(PV)Formula</h5><p>PV = rac{FV}{(1 + rac{r}{M})^{M imes N}} = rac{FV}{(1 + r_{PER})^{M imes N}}</p><p>Where:</p><ul><li><p>N=numberofyears</p></li><li><p>M=frequencyofcompoundingperyear</p></li><li><p>r=nominalinterestrateperannum(r_{NOM})</p></li><li><p>r{PER}=periodicinterestrate(i.e., rac{r{NOM}}{M})
Example 1: Compounding - Future Value
Problem: What is the FV of $100 after 3 years under 10% semi-annual compounding? What about quarterly compounding?
Solution (Semi-annual compounding):
r_{NOM} = 10 ext{%},M = 2,N = 3years.</p></li><li><p>r_{PER} = 10 ext{%} / 2 = 5 ext{%}</p></li><li><p>Totalperiods=M imes N = 2 imes 3 = 6</p></li><li><p>FV = 100 imes (1 + 0.05)^6 = 100 imes (1.3400956) = 134.01</p></li></ul><p><strong>Solution(Quarterlycompounding):</strong></p><ul><li><p>r_{NOM} = 10 ext{%},M = 4,N = 3years.</p></li><li><p>r_{PER} = 10 ext{%} / 4 = 2.5 ext{%}</p></li><li><p>Totalperiods=M imes N = 4 imes 3 = 12</p></li><li><p>FV = 100 imes (1 + 0.025)^{12} = 100 imes (1.3448888) = 134.49</p></li></ul><p><strong>AlternativeSolution(usingTVMWorksheet):</strong></p><ol><li><p><strong>Semi−annualcompounding:</strong></p><ul><li><p><strong>N</strong>=3 imes 2 = 6</p></li><li><p><strong>I/Y</strong>=10 / 2 = 5</p></li><li><p><strong>PV</strong>=-100</p></li><li><p><strong>PMT</strong>=0</p></li><li><p><strong>ComputeFV</strong>
ightarrow <strong>FV=134.01</strong></p></li></ul></li><li><p><strong>Quarterlycompounding:</strong></p><ul><li><p><strong>N</strong>=3 imes 4 = 12</p></li><li><p><strong>I/Y</strong>=10 / 4 = 2.5</p></li><li><p><strong>PV</strong>=-100</p></li><li><p><strong>PMT</strong>=0</p></li><li><p><strong>ComputeFV</strong>
ightarrow <strong>FV=134.49
Example 2: Compounding - Present Value of an Annuity
Problem: What’s the PV of a 3-year $100 annuity, if the quoted interest rate is 10%, compounded semi-annually?
Solution (by discounting individual cash flows):
The periodic rate r_{PER} = 10 ext{%} / 2 = 5 ext{%}</p></li><li><p>Theannuitypaymentsareannual,butcompoundingissemi−annual.</p></li><li><p>Thismeanseachannualpaymentmustbediscountedusingtheperiodicrateandrespectivetotalcompoundingperiods.</p></li><li><p>Note:Whentheannuitypaymentsareannualbutcompoundingismorefrequent,onecommonapproachistofindtheeffectiveannualrate(EAR)firstfortheinterestrate,thenusethatEARwithannualpayments.Anotherapproach,whichismorecomplexandlessintuitivefor<em>annual</em>paymentswithsub−annualcompoundingisasshownintherawcalculation,explicitlyusingcompoundingperiodsforeachannualpayment:<br>PV = rac{100}{(1.05)^2} + rac{100}{(1.05)^4} + rac{100}{(1.05)^6}<br>PV = 100(1.05)^{-2} + 100(1.05)^{-4} + 100(1.05)^{-6}<br>PV = 100(0.907029) + 100(0.822702) + 100(0.746215)<br>PV = 90.7029 + 82.2702 + 74.6215 = 247.59</p></li></ul><p><strong>AlternativeSolution(usingTVMWorksheetwithEAR):</strong><br>Thisisgenerallythepreferredapproachwhenpaymentfrequencydiffersfromcompoundingfrequency.</p><ol><li><p><strong>Step1:Findtheannualeffectiverate(EAR)forthe10EAR = (1 + rac{0.10}{2})^2 - 1 = (1.05)^2 - 1 = 1.1025 - 1 = 0.1025 ext{ or } 10.25 ext{%}</p></li><li><p><strong>Step2:UsetheEARandtreatthecashflowsasanordinaryannuitytosolveforPV.</strong></p><ul><li><p><strong>N</strong>=3</p></li><li><p><strong>I/Y</strong>=10.25</p></li><li><p><strong>PMT</strong>=-100</p></li><li><p><strong>FV</strong>=0</p></li><li><p><strong>ComputePV</strong>
ightarrow <strong>PV=247.59
Example 3: Compounding - Car Loan (Find Stated and Effective Rates)
Problem: You have decided to buy a car whose price is $45,000. The dealer offers to finance the entire amount and requires 60 monthly payments of $950 per month. What are the yearly stated and effective interest rates for this financing?
Solution Steps:
This is a monthly compounding problem.
Find the periodic (monthly) rate using the TVM Worksheet.
N = 60(60monthlypayments)</p></li><li><p><strong>PV</strong>=45,000(Theloanamountreceivedbyyou,soenteredaspositiveinitialinflow)</p></li><li><p><strong>PMT</strong>=-950(Themonthlypaymentoutflow)</p></li><li><p><strong>FV</strong>=0(Loanisfullypaidoff)</p></li><li><p><strong>ComputeI/Y</strong>
ightarrow <strong>I/Y=0.8103</strong>(Thisistheperiodic<strong>monthly</strong>rate,inpercent,i.e.,0.8103 ext{%}permonth)</p></li></ul></li><li><p><strong>Calculatetheannualnominalrate(r{NOM}).</em></strong><em><br>r{NOM} = ext{Periodic Rate} imes M = 0.8103 ext{%} imes 12 = 9.7236 ext{%}</p></li><li><p><strong>Calculatetheeffectiveannualrate(r{EAR}).</em></strong><em><br>r{EAR} = (1 + ext{Periodic Rate})^{M} - 1 = (1 + 0.008103)^{12} - 1<br>r_{EAR} = (1.008103)^{12} - 1 = 1.10168 - 1 = 0.10168 ext{ or } 10.168 ext{%}</p></li></ol><h5id="1b922ac1−b126−4b0e−bc6f−b9cf82de8567"data−toc−id="1b922ac1−b126−4b0e−bc6f−b9cf82de8567"collapsed="false"seolevelmigrated="true">Example4:Compounding−DoublingAccountBalance(FindNinYears)</h5><p><strong>Problem:</strong>Thestatedinterestrateforabankaccountis77 / 2 = 3.5(Periodicsemi−annualrate)</p></li><li><p><strong>PV</strong>=-1(Initialdeposit,outflow)</p></li><li><p><strong>PMT</strong>=0</p></li><li><p><strong>FV</strong>=2(Targetfuturevalue)</p></li></ul></li><li><p><strong>ComputeN</strong>
ightarrow <strong>N=20.15</strong>(Thisisthe<strong>numberofsemi−annualcompoundingperiods</strong>.)</p></li><li><p><strong>Convertcompoundingperiodstoyears.</strong><br>SinceNrepresentssemi−annualperiods,divideby2togetyears:<br>Years = 20.15 / 2 = 10.08$$ years.
Therefore, it takes approximately 10.08 years to double the account balance.