- Required Monthly Payment = $ _______________
- 1/12 of the required monthly payment = $ _______
- By adding this 1/12 to the required payments, the Jeffersons plan to pay
$ ______each month.
- Number of years to pay off loan = ___________________________
| Thomas Family | Jefferson Family |
| 1/12th of Monthly Payment Monthly Payment + Extra 1/12th Rates Annuity Amount in 360 Months Rates Annuity Amount in 360 Months |
| 0% | | 0% | |
| 1% | | 1% | |
| 2% | | 2% | |
| 3% | | 3% | |
| 4% | | 4% | |
| 5% | | 5% | |
| 6% | | 6% | |
| 7% | | 7% | |
| 8% | | 8% | |
File Edit View Insert Format Tools AutoSave OFF Insert Draw Page Layout Formulas Data Window Help Activity & Comparing Mortgages Student Financial T Data Review View Tell me Conditional Formatting 2 Format as Table Alignment Number Cell Styles Verdana 10 ' ' A % B I U fx Mini Financial Calculators B D E F G H 3 K Mini Financial Calculators nd boxes are the outputs based on the given inputs above the box. Do not type in the shaded b APR 6.00% Compounds 12 Present Value 0.00 Payment 43.00 Years 30 Future Value: 0431045 APR Compounds Present Value Payment Future Value Years 7.25% 12 175000.00 -1293.29 D 23.5 APR 10.00% Compounds 12 Payment -25 Present Value -250.00 45 Investment Interesti270.401.09 Years APR Compounds Present Value Future Value Years Payment: 9.00% 12 60000 0 30 42222 APR Compounds Future Value Payment Year's Present Valuer 8.25% 12 0.00 -300.00 10 $2445932 12 Compounds Payment -482.77 Present Value 60000.00 Years 30 Debt Interest: 61.13.70722001 APR Compounds Effective Yield 5.46% 4 APY Compounds Nominal Yield 5.57% 4 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(FS/F6, F8, F7F9/12 Debt Interesti 16"1518+17 Paymenti -PMT(C13/C14,C17C14,C15, C16) Present Value PV(F13/F14,F17"F14,F16,F15) Investment Interesti -FV[113114,117114,115,116)+115*114 117-116 Effective Vield: -F22*((1+F21)^(1/F22)-1) Nominal Yield: -F22((1+F21)^(1/422)-1) + Financial ToolBoxes Why the Negative Ject destination and press ENTER or choose Peate File Edit View Insert Format Tools AutoSave OFF Insert Draw Page Layout Formulas Data Window Help Activity & Comparing Mortgages Student Financial T Data Review View Tell me Conditional Formatting 2 Format as Table Alignment Number Cell Styles Verdana 10 ' ' A % B I U fx Mini Financial Calculators B D E F G H 3 K Mini Financial Calculators nd boxes are the outputs based on the given inputs above the box. Do not type in the shaded b APR 6.00% Compounds 12 Present Value 0.00 Payment 43.00 Years 30 Future Value: 0431045 APR Compounds Present Value Payment Future Value Years 7.25% 12 175000.00 -1293.29 D 23.5 APR 10.00% Compounds 12 Payment -25 Present Value -250.00 45 Investment Interesti270.401.09 Years APR Compounds Present Value Future Value Years Payment: 9.00% 12 60000 0 30 42222 APR Compounds Future Value Payment Year's Present Valuer 8.25% 12 0.00 -300.00 10 $2445932 12 Compounds Payment -482.77 Present Value 60000.00 Years 30 Debt Interest: 61.13.70722001 APR Compounds Effective Yield 5.46% 4 APY Compounds Nominal Yield 5.57% 4 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(FS/F6, F8, F7F9/12 Debt Interesti 16"1518+17 Paymenti -PMT(C13/C14,C17C14,C15, C16) Present Value PV(F13/F14,F17"F14,F16,F15) Investment Interesti -FV[113114,117114,115,116)+115*114 117-116 Effective Vield: -F22*((1+F21)^(1/F22)-1) Nominal Yield: -F22((1+F21)^(1/422)-1) + Financial ToolBoxes Why the Negative Ject destination and press ENTER or choose Peate
