Excel PMT Function Question - Help!!

[amann23]

I am very familiar with the PMT Function and use it all the time at
work.

However, I now need to do the opposite...I know the monthly payment and
want to solve for the value of the loan.

To give a quick explanation...I am in Real Estate Development. In most
cases, we take the construction loan, the interest rate, and length of
loan (30 years, 12 payments per year) and use this data to solve for
the monthly payment.

However, when converting a construction loan to a permanent loan in
certain scenarios, the bank requires a certain Debt Service Coverage
Ratio. In this scenario, I solve for the monthly/annual payment and
must calculate the new, permanent loan value. How do I do this in
Excel?

Help!!

Thanks very much! I am stumped!

 

[Bernard Liengme]

Have you tried to use Solver?

 

[Harlan Grove]

Have you tried to use Solver?

Wouldn't the PV function be the first option?