iRealtee OS Glossary

Amortization Schedule

An amortization schedule distributes your total loan repayment across fixed installments. Here's how the calculation works for Philippine real estate transactio...

Amortization Schedule

Amortization schedule is a table that details each periodic payment on an amortizing loan, showing the breakdown of principal and interest across the loan term. In Philippine real estate, this schedule serves as the foundation for computing equity payments and monthly installments on property purchases.

Key Components

  • Principal payment - The portion of each installment that reduces the original loan balance
  • Interest payment - The cost of borrowing, calculated on the remaining balance
  • Payment date - The scheduled due date for each installment
  • Outstanding balance - The remaining amount owed after each payment
  • Total payment - The fixed monthly amount covering both principal and interest

How it Works

An amortization schedule distributes your total loan repayment across fixed installments. Here's how the calculation works for Philippine real estate transactions:

  1. Determine the loan amount. This is your Total Contract Price (TCP) minus the down payment or equity portion.
  2. Set the interest rate and term. Philippine banks typically offer rates between 6-12% per annum with terms of 5-30 years for housing loans.
  3. Calculate the monthly payment. The formula uses the principal, interest rate, and number of months to produce a fixed monthly installment.
  4. Generate the schedule. Each row shows how much goes to interest versus principal. Early payments are interest-heavy; later payments reduce principal faster.

You can use the Payment Schedule feature in the Sales Wizard to generate these computations automatically for various financing schemes like bank financing, in-house financing, or Pag-IBIG Fund loans.

Pros & Cons

Pros:

  • Provides transparency on total interest cost over the loan term
  • Helps buyers budget with predictable monthly payments
  • Allows comparison between different financing options (shorter term vs. lower monthly)

Cons:

  • Front-loaded interest means slow equity buildup in early years
  • Prepayment penalties may apply if you pay ahead of schedule
  • Variable rate loans may render the schedule inaccurate over time

Real-World Application

In Philippine real estate sales, the amortization schedule is integrated directly into the Sales Wizard computation engine. When an agent encodes a reservation, the system automatically generates schedules for different payment schemes:

  • In-house financing - Developer-financed terms with typically higher interest rates but faster approval
  • Bank financing - Lower rates through partner banks, requiring income documentation
  • Pag-IBIG financing - Government-subsidized rates for qualified members

The Payment Tracking module then monitors actual payments against the schedule, flagging delinquencies and computing penalties as defined in the Accounts Receivable configuration.

  • Equity - The initial down payment portion before the amortization period begins
  • Total Contract Price - The full purchase amount from which the loan is derived
  • Interest Rate - The annual percentage applied to compute the interest portion

References

Looking for another term? Browse the full glossary.

Back to Glossary