This preview shows page 1. Sign up to view the full content.
4e8e65d05aff0db6435b7ce0b90b3dafa51bac92.xlsx
Future Value of a Single Sum
Interest Rate per Period (i%)
5.00%
Number of Periods (n)
8
Present Value (PV)
$150,000.00
1.47746
Future Value (FVF)
$221,618.32
Present Value of a Single Sum
Interest Rate per Period (i %)
8.00%
Number of Periods (n)
3
Future Value (FV)
$2,000.00
Factor = (1+r)n
0.79383
Future Value (PVF)  (B7*B9)
$1,587.66
Future Value of an Annuity (Ordinary)
Interest Rate per Period (i %)
8.00%
Number of Periods (n)
3
Future Value (FV)
$2,000.00
Factor = (1+r)n
3.24640
Future Value (PVFOA)  (B7*B9)
$6,492.80
Present Value of an Annuity (Ordinary)
Determining Loan Payments
Interest Rate per Period (i %)
12.00%
Interest Rate per Period (i %)
5.00%
Number of Periods (n)
5
Number of Periods (n)
6
Payments (in the future)
$6,000.00
Payments
$1,970.17
Present Value Factor
[(1 1/(1+i)n) / I]
3.60478
Present Value Factor = (1 1/(1+i)n) / i
5.07569
Present Value (PVFOA)
$21,628.66
Present Value  Amount owed today.
$10,000.00
Present Value of an Annuity (Due)
This is the end of the preview. Sign up
to
access the rest of the document.
 Spring '09
 HILTON

Click to edit the document details