12-2
Using the Finance Solver
combined amount earns interest at a certain rate.
Financial calculations involving compound interest
include savings accounts, mortgages, pension funds,
leases, and annuities.
Time Value of Money (TVM) calculations, as the name
implies, make use of the notion that a dollar today will be
worth more than a dollar sometime in the future. A dollar
today can be invested at a certain interest rate and
generate a return that the same dollar in the future cannot.
This TVM principle underlies the notion of interest rates,
compound interest and rates of return.
TVM transactions can be represented by using
cash flow
diagrams
. A cash flow diagram is a time line divided into
equal segments representing the compounding periods.
Arrows represent the cash flows, which could be positive
(upward arrows) or negative (downward arrows),
depending on the point of view of the lender or borrower.
The following cash flow diagram shows a loan from a
borrower's
point of view:
On the other hand, the following cash flow diagram
shows a load from the
lender's
point of view:
In addition, cash flow diagrams specify
when
payments
occur relative to the compounding periods: at the
beginning
of each period or at the
end
. The Finance
Solver application provides both of these payment
modes: Begin mode and End mode. The following cash
Present value (PV)
(Loan)
Money
received is
a positive
number
Money
paid out is
a negative
number
Equal periods
1
2
3
4
5
(PMT)
Future value
(FV)
Equal payments
Payment
(PMT)
Payment
(PMT)
Payment
(PMT)
Payment
(PMT)
}
}
}
}
}
FV
Equal payments
1
2
3
4
5
}
}
}
}
PMT
}
PMT
PMT
PMT
PMT
Equal periods
PV
Loan
}
hp40g+.book Page 2 Friday, December 9, 2005 1:03 AM
Summary of Contents for 40gs
Page 10: ...hp40g book Page x Friday December 9 2005 1 03 AM ...
Page 64: ...hp40g book Page 22 Friday December 9 2005 1 03 AM ...
Page 80: ...hp40g book Page 4 Friday December 9 2005 1 03 AM ...
Page 86: ...hp40g book Page 4 Friday December 9 2005 1 03 AM ...
Page 100: ...hp40g book Page 4 Friday December 9 2005 1 03 AM ...
Page 126: ...hp40g book Page 22 Friday December 9 2005 1 03 AM ...
Page 182: ...hp40g book Page 28 Friday December 9 2005 1 03 AM ...
Page 274: ...hp40g book Page 22 Friday December 9 2005 1 03 AM ...
Page 303: ...Step by Step Examples 16 29 hp40g book Page 29 Friday December 9 2005 1 03 AM ...
Page 304: ...hp40g book Page 30 Friday December 9 2005 1 03 AM ...
Page 314: ...hp40g book Page 10 Friday December 9 2005 1 03 AM ...
Page 330: ...hp40g book Page 16 Friday December 9 2005 1 03 AM ...
Page 392: ...hp40g book Page 44 Friday December 9 2005 1 03 AM ...
Page 420: ...hp40g book Page 22 Friday December 9 2005 1 03 AM ...
Page 428: ...hp40g book Page 8 Friday December 9 2005 1 03 AM ...
Page 444: ...hp40g book Page 16 Friday December 9 2005 1 03 AM ...