Mini Financial Calculators
(Shaded boxes are the outputs based on the given inputs above the box. Do not type in the shaded boxes.)
APR 6.00% APR 7.25% APR 10.00%
Compounds 12 Compounds 12 Compounds 12
Present Value 0.00 Present Value 175000.00 Payment -25
Payment 43.00 Payment -1293.29 Present Value -250.00
Years 30 Future Value 0 Years 45
Future Value: ($43,194.15) Years: 23.5 Investment Interest: $270,401.09
APR 9.00% APR 8.25% Compounds 12
Compounds 12 Compounds 12 Payment -482.77
Present Value 60000 Future Value 0.00 Present Value 60000.00
Future Value 0 Payment -300.00 Years 30
Years 30 Years 10 Debt Interest: ($113,797.20)
Payment: ($482.77) Present Value: $24,459.32
APR 5.46% APY 5.57%
Compounds 4 Compounds 4
Effective Yield: 5.57% Nominal Yield: 5.46%
The formulas in the gray boxes are not cell-protected. Should you accidentally lose their information, refer to the items below.
You can copy and paste any of the formulas back into the gray boxes. Don’t forget to drop the quote mark in front of the = sign.
Future Value: =FV(C5/C6,C6*C9,C8,C7)
Years: =(NPER(F5/F6,F8,F7,F9))/12
Debt Interest: =I6*I5*I8+I7
Payment: =PMT(C13/C14,C17*C14,C15,C16)
Present Value: =PV(F13/F14,F17*F14,F16,F15)
Investment Interest: =FV(I13/I14,I17*I14,I15,I16)+I15*I14*I17+I16
Effective Yield: =F22*((1+F21)^(1/F22)-1)
Nominal Yield: =F22*((1+F21)^(1/F22)-1)
Why the Negative
Rules of Thumb:
1. Notice that present value and future value are typically opposite in sign.
2. Use the “Inflow-Outflow” way of thinking: Inflow is money coming in and outflow is money “out-the-door”.
3. If all else fails, try changing the sign of any of the inputs to see how it affects the result and act accordingly.
4. Don’t get “burned” by the negative or lack of a negative in the financial formulas. Always consider its role.