Q. You want a housing loan for construction of a house. Estimated construction cost is Rs. 20 lakhs. You can contribute Rs. 4 lakhs from your own savings and remaining you need to get it financed from a bank @ 8% per annum for 10 years

2. The monthly installment as per the above conditions is not suitable and does not fit in your budget. The maximum what you can pay is Rs. 18000 per month. You are ready to increase the payment period. Find the payment period that fits your budget (assuming all conditions remain same).

3. But in reality, finance companies offer different conditions for different situations. You want to evaluate multiple options as per following conditions:

Company Rate Period

ABC Finance 9.0% 5 years

ABC Finance 8.75% 7 years

ABC Finance 8.25% 10 years

Sun Finance 9.1% 56 months

Sun Finance 8.7% 80 months

Do the what-if analysis to find the best possible option.

If you can share the steps for the what if analysis, would be great!!

Thanks so much!