plug in a different term length (number of monthly payment periods). In cell D2, the PMT function plugs in the interest rate 3.75%/12, 360 months, and a $225,000 loan, and calculates a $1,042.01 monthly payment.
Use a two-variable test to see how different values of two variables in a formula will change the results. For example, you can test different combinations of interest rates and number of monthly payment periods to calculate a mortgage payment.
In this live workbook, cell C3 contains the payment formula, =PMT($B$3/12,$B$2,B4), which uses two variable cells, B2 and B3. In cell C2, the PMT function plugs in the interest rate 3.875%/12, 360 months, and a $225,000 loan, and calculates a $1,058.03 monthly payment.
Dessert (100g serving)CaloriesFat (g)Carbs (g)Protein (g)Frozen yoghurt1596244Ice cream sandwich2379374.3Eclair26216246Cupcake3053.7674.3Gingerbread35616493.9
|
Dessert (100g serving) |
Calories |
Fat (g) |
Carbs (g) |
Protein (g) |
|---|---|---|---|---|
|
Frozen yoghurt |
159 |
6 |
24 |
4 |
|
Ice cream sandwich |
237 |
9 |
37 |
4.3 |
|
Eclair |
262 |
16 |
24 |
6 |
|
Cupcake |
305 |
3.7 |
67 |
4.3 |
|
Gingerbread |
356 |
16 |
49 |
3.9 |
Price:
Send Inquiry
Send Inquiry
