Goal Seek in Excel

Situation: You want to buy a house and the lender offers loan on at RM 500,000 over 20 years. With this, you can find out how much your payback per month using all those calculators on the net.

However, what if you set your budget to pay RM 1,300 instalment 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, enrol with us http://www.excel.my/

Upcoming Excel Basic to Advance on 7-8 June and 13-14 July 2017.

Contact info@mu.my or 03-80116639.

Find out more at https://www.mu.my

 

Share This Post

Share on facebook
Facebook
Share on twitter
Twitter