Forum Discussion

gtsui1108's avatar
gtsui1108
Copper Contributor
May 05, 2024

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  

 

 

Resources