|
|
| | 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) |
tryin98
Activity5ACaseStudyofPayingExtraPrincipalonaMortgageStudentFinancialToolboxes.xls
