| Method
of viewing various situations in a formula. For example, in Microsoft
Excel, a user has the ability of performing a what-if evaluation by
placing various different values into a cell and comparing the
results. As seen in the below examples, using a spreadsheet
program, a user could quickly manipulate the interest rate and
determine what a monthly payment is.
Example One:
| Mortgage amount: |
$100,000 |
| Term: |
30 Years |
| Interest rate: |
12.000% |
| Monthly Payment: |
$1,028.61 |
Example Two:
| Mortgage amount: |
$100,000 |
| Term: |
30 Years |
| Interest rate: |
8.000% |
| Monthly Payment: |
$733.76 |
Also see: Formula
|
|
| Resolved |
Were you able to locate the answer to your questions? |
|
|
