PMT function does that. It won't lay out the schedule, but you get the numbers. You need to pay careful attention to the interest rate as the function uses the periodic rate (eg. monthly if you are doing monthly payments). Here's a simple example laid out so you can switch between annual and monthly, and even between lease (payments in advance need a 1 in the last variable for the formula) and loan. |