Simple way of calculating monthly amortization.
Price 800,000
DP 350,000
"Loan Amount
(Price minus DP)" 450,000
Interest rate (example lang) 4.5% per annum (or 0.045)
Terms (in years, example lang) 5 years (or 60 months)
"Interest
(Rate x Years x Loan Amount)" 101,250
"Total amount to be paid
(Loan amount plus Interest)" 551,250
"Montly amortization
(Total amount divided by no. of months)" 9,187.5