Home

Calculating a loan deposit based on the monthly payment

Drakon
Occasional Visitor

Hello all,

 

Using the PV function, I can estimate the cost of a loan if I know the amount of money being borrowed, the term, and the interest rate. This will give the monthly payments of the loan.

 

What I now want to do is calculate what deposit would be required on a loan if I know what the monthly payment, term, and interest rate is. How can this be done with Excel formulae?

Related Conversations