Goal Seek in Excel
Situation: You want to buy a house and the lender offer loan on at RM 500,000 over 20 years. With this you can find out how much your pay back per month using all those calculators on the net.
But what if you set your budget to pay RM 1,300 installment per month. So based on mortgage rate, how much worth of house you can afford for RM 1,300 per month?
Goal Seek allows you to analyses the best value for you to achieve your desired goal.
Want to learn more about Goal Seek in Excel, enroll with us http://www.excel.my/
Upcoming Excel Basic to Advance on 7-8 June and 13-14 July 2017.
Contact info@excel.my or 03-80116639.
Find out more at http://www.excel.my