Mr Sultan al Hadrami is planning to construct his own house. He is planning to construct the house in a phased manner. At present he is working with Oman Air and is earning salary RO 12000 every year . The Cost of Construction of the house is RO 50,000 if the construction is completed in one year. However if the construction is done in parts, the cost of contrition will increase and may go up to 60000 if completed in six years. Mr Sultan is seeking your advice on the two option.

Option A- Take a loan from bank for RO 50,000 now and construct the house in one year The loan will be for 6 years with interest on the loan @ 8%p.a. The amount of the loan could be repaid in monthly installments.

Option B Construct the house in parts ( without loan ) In this option Mr Sultan expects to save RO 900 every month. At the end of each year he will used his saving and construct some part of the house. So in this way he will take six years to complete the House. The interest on saving will be @ 6%p.a..

You are required to evaluate the above two options and suggest a) The total amount to be paid in Option A b) The total amount to be saved and used in construction in Option B

Note :need solve in Microsoft Excel