Forum Discussion
gtsui1108
May 05, 2024Copper Contributor
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
- Riny_van_EekelenPlatinum Contributor
- gtsui1108Copper ContributorThank you very much Riny! I can see where it goes wrong now. Didn't expect to be that easy.