How can I change my personal loan EMI date. To calculate what your mortgage payments will be type the payment or PMT function into a spreadsheet. PMTB4B5B3B5-B2 and you will see that the monthly payment is 129720 as shown above.
Use cell locations from this worksheet to define each argument of the.
On the Mortgage worksheet use the data provided to enter a formula in cell B6 to calculate the principal of the loan that will be required to purchase the house. PMT rate nper pv. Use cell locations from this worksheet to define each argument of the. Multiply this by 12 to get the actual APR so type RATE48 -7608 2300 012 to get the answer youre looking for.