PMT function
i am doing a spreadsheet 4 a gym. i need to use a PMT function to find the monthly payment the customer needs to pay. there is a fee for the membership, a deposit is paid initially, and the interest rate is 4.75% annual of the amount to be paid. but when i do this i get a negative figure, which means that the customer needs 2 pay -£'s a month in order to pay the amount they owe after they have paid there deposit, this cannot be correct. please help -- joemoran7 |
PMT function
The PMT function always returns the answers as a minus figure, even though
technically it isn't. You haven't done your formula wrong - this is just how it works. "joemoran7" wrote: i am doing a spreadsheet 4 a gym. i need to use a PMT function to find the monthly payment the customer needs to pay. there is a fee for the membership, a deposit is paid initially, and the interest rate is 4.75% annual of the amount to be paid. but when i do this i get a negative figure, which means that the customer needs 2 pay -£'s a month in order to pay the amount they owe after they have paid there deposit, this cannot be correct. please help -- joemoran7 |
All times are GMT +1. The time now is 06:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com