![]() ![]() This row is for the formulas that you want to use. interest rates that you want to substitute in the input cell down the column E as follows −Īs you observe, there is an empty row above the Interest Rate values. You can see that the cells in column C are named as given in the corresponding cells in column D. Set the calculations for EMI, Cumulative Interest and Cumulative Principal with the Excel functions – PMT, CUMIPMT and CUMPRINC respectively. Name the cells containing the values, so that the formulas will have names instead of cell references. Let us understand these steps in detail − Step 1: Set the required background Analysis with One-variable Data TableĪnalysis with one-variable Data Table needs to be done in three steps − You also might be interested in knowing the amount of interest and Principal that is paid in the second year. You want to know the monthly payments (EMI) for varied interest rates. ![]() There is a loan of 5,000,000 for a tenure of 30 years. You will understand this with the help of an example. In other words, with a one-variable Data Table, you can determine how changing one input changes any number of outputs. One-variable Data TablesĪ one-variable Data Table can be used if you want to see how different values of one variable in one or more formulas will change the results of those formulas. For details, refer to the chapter – What-If Analysis with Scenario Manager in this tutorial. If you have more than two variables in your analysis problem, you need to use Scenario Manager Tool of Excel. A Data Table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. With a Data Table in Excel, you can easily vary one or two inputs and perform What-if analysis. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |