Now you may want to do an analysis to see what number of monthly payments suits your condition, and how would the monthly payment vary based on it. The following formula is used to calculate the Monthly Payment: =PMT(B2/12,B3,B1) The Monthly Payment value is calculated based on these three variables (it is in red as it is an outflow of money). In the above data set, we have the Loan Amount, Interest Rate, and Number of Monthly payments. Suppose you have a data set as shown below: When to use One Variable Data Table in Excel If you want to change two variables, use two variable data table, or Scenario Manager. One variable Data Table in Excel is most suited in situations when you want to see how the final result changes when you change one of the input variables. ![]() ![]() Watch Video – One-Variable Data Table in Excel Other articles in the Data Analysis series:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |