Excel what-if Price sensitivity table not working

Copper Contributor

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  



2 Replies

@gtsui1108 See attached!

Thank you very much Riny! I can see where it goes wrong now. Didn't expect to be that easy.