Hi All:

I'm aware of the PMT Excel function, but how would I set up a formula knowing only two variables?

1. Assuming I know how much per month one can pay in total, and

2. The percent interest rate

... I need the total amount that can be financed.

Example:

A. $3,900 maximum per month

B. 5.00% interest rate

C. = x (the amount to be financed)

Thank you!

EDR

I'm aware of the PMT Excel function, but how would I set up a formula knowing only two variables?

1. Assuming I know how much per month one can pay in total, and

2. The percent interest rate

... I need the total amount that can be financed.

Example:

A. $3,900 maximum per month

B. 5.00% interest rate

C. = x (the amount to be financed)

Thank you!

EDR

## Comment