Folks,
The attached file relates to the exercise on What-If-Analysis: Data Table where I am asked to calculate various payments, total payments and total interest for years 1 - 5.
I agree with the calculations for those in blue and white. In other words it is exactly what was expected. However, the values in orange, well I have no idea how they were calculated. I used both 2016 and 2019 (separate machine) and got the same results.
The range names were set up correctly and the value required (year) is correct. Please advise.
This is a great question.
As the name of the feature What-If-Analysis does exactly what is meant to say.
For your “values in orange”: These are the values cells B7, Total Payments and B8, Total Interest will take based of the values=Years in column F (F15 through F19) which represent the number of Years (B4) may have.
If you change B4's value, Years, to be 1 in the original model (PLEASE TRY) the calculated results in B7, Total Payments and B8, Total Interest will take the values $92,456 and $62,456 – the exact values you see to the right of the "1" of cell F15 in cells H15 and I15.
If you try to change B4's value, Years, to the be 2, you will see the values to the right of the 2 in F16 in H16 and I16
In other words, the Data-Table of the What-If-Analysis calculates these values repeatedly, for 1, 2, 3, 4 and 5 Years. Try it yourself. It eliminates the need to recalculate the original model to to our What-Could-Happen if I change it repeatedly.
If you change one the cell in column F (Try F15) to have the value of 10 - it will display the values that the original model will take for 10 years.
Thank you.
Isaac
