Excel what-if Price sensitivity table not working
I am trying to conduct a price sensitivity analysis in excel. The project is to calculate how much do I need to save to repay student loan. So my sensitivity table consists of 2 variables: (i) future salary and (ii) my saving ratio after deducting necessary expenses, and the output was my monthly net repayment to student debt.
However, the monthly net repayment to student loan in the sensitivty table is negative, and I clearly don’t figure out where I go wrong after checking tons of youtube videos.
Do someone know how to solve this? Thank you very much!
Financial planning – student loan.xlsx
I am trying to conduct a price sensitivity analysis in excel. The project is to calculate how much do I need to save to repay student loan. So my sensitivity table consists of 2 variables: (i) future salary and (ii) my saving ratio after deducting necessary expenses, and the output was my monthly net repayment to student debt. However, the monthly net repayment to student loan in the sensitivty table is negative, and I clearly don’t figure out where I go wrong after checking tons of youtube videos. Do someone know how to solve this? Thank you very much! Financial planning – student loan.xlsx Read More