• 517K Members
• 6,018 Online
• 616K Conversations

New Contributor

# Formula to work backwards from repayments to find capital

I am looking for a formula that will give me the amount borrowed when the monthly repayment is know.

So the variables that I know are the monthly repayment, the length of the loan (in either months or years) and the interest rate.

I want to be able to put the monthly repayment in say cell A1, the length of loan (in months) in A2, and the interest rate % in A3. From this information I want to know how much the initial amount borrowed will be.

3 Replies

# Re: Formula to work backwards from repayments to find capital

Excel allows you to calculate the present value with this formula:

=PV(A3/12,A2,-A1)

# Re: Formula to work backwards from repayments to find capital

That is brilliant. Thank you

# Re: Formula to work backwards from repayments to find capital

You're welcome!

Related Conversations
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies