Hi Assad,

Sure, I can help you with that!

For both Fixed Annual Interest Rate and Reducing Balance Annual Interest Rate, you can use the PMT function in Excel to calculate the installment per month or per year basis.

Here are the steps to calculate the installment per month basis for Fixed Annual Interest Rate:

1. Open a new Excel sheet and enter the following information in cells A1 to A4:
   A1: Principal Amount: 800,000
   A2: Annual Interest Rate: 5.9%
   A3: Loan Term (Years): 20
   A4: Installment Frequency: 12 (since we want to calculate the installment per month)
   
2. In cell A5, enter the following formula:
   Formula:

   =PMT(A2/12,A3*12,-A1) 

   This formula uses the PMT function to calculate the installment per month basis. The arguments in the function a
   - A2/12: This calculates the monthly interest rate by dividing the annual interest rate by 12.
   - A3*12: This calculates the total number of payments by multiplying the loan term in years by 12 (since we want to calculate the installment per month).
   - -A1: This is the present value of the loan, which is negative since it represents a cash outflow.
   
3. Press Enter to calculate the installment per month basis, which should be -5,361.44.

Now, let's move on to the Reducing Balance Annual Interest Rate calculation:

1. Enter the same information in cells A1 to A4 as before.
   
2. In cell A5, enter the following formula:
   Formula:

   =PMT(A2/12,A3*12,A1*(1+A2/12)^A3*12) 

   This formula uses the PMT function to calculate the installment per month basis. The arguments in the function a
   - A2/12: This calculates the monthly interest rate by dividing the annual interest rate by 12.
   - A3*12: This calculates the total number of payments by multiplying the loan term in years by 12 (since we want to calculate the installment per month).
   - A1*(1+A2/12)^A3*12: This is the present value of the loan, which is multiplied by the factor (1+monthly interest rate)^total number of payments. This formula takes into account the reducing balance of the loan.
   
3. Press Enter to calculate the installment per month basis, which should be -5,361.44.

That's it! You can use the same formulas to calculate the installment per year basis by changing the installment frequency in cell A4 to 1.[/list]