This worksheet just might make calculating things like loan payments, the amount that could be borrowed, the interest rate, etc. a little easier than the HP-12C calculator, with Reverse Polish Notation, you have been holding onto for the last 30 years.
Their are five inputs to the calculator:
- Cash Flow (Payment)
- Number of Cash Flows
- Present Value (PV)
- Future Value (FV)
(Their is a sixth input, periods per year, but that is normally something known and not usually solved for)
In all the examples, the yellow cells are input cells.
It is assumed that the cash flows start at the end of the periods (as is true for most loans), but if you wish the cash flows to start at the beginning of the periods, check the box in the upper left hand corner of the sheet.
If you have the first three, you can solve for both the PV and FV: