How do you calculate a monthly mortgage payment by hand?

I know there are online payment calculator, but I’m trying to make a calculator Excel spreadsheet and I need to know the equations used to obtain the results. For example, the calculation of the monthly payment of a $ 220,000 loan over 30 years with interest at 5.5%.

Register New Account
Reset Password