| 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?
|
| |
