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.
A. $3,900 maximum per month
B. 5.00% interest rate
C. = x (the amount to be financed)