Payment + interest = what total amount borrowed?

**vill** · 06-19-2018, 11:02 AM

Hi guys, can't seem to figure, how could we calculate:

Monthly debt payments = 1000 per month (A2)
Monthly interest on debt = 3% (A3)

A formula in A4 to tell us 'what is total debt amount borrowed' ?

Is there a simple formula to this?

Thanking in advance!

**alansidman** · 06-19-2018, 11:24 AM

How long are the repayments made, ie. How many months to full payment. With that information, you would use the =PV function.

https://www.techonthenet.com/excel/formulas/pv.php

**vill** · 06-19-2018, 11:57 AM

That was it, alansidman, thank you!!!!!

Payment + interest = what total amount borrowed?

LinkBack

Thread Tools

Rate This Thread

Display

Payment + interest = what total amount borrowed?

Re: Payment + interest = what total amount borrowed?

Re: Payment + interest = what total amount borrowed?

Thread Information

Users Browsing this Thread

Similar Threads

Fill down principal payment & interest payment formulas in Excel

FV to calculate total interest earn for monthly payment

Calculating Interest Rate for Total Interest Paid, Loan Amount and No. of Monthly Payments

Tracking monthly payments and reducing the total by the amount of each payment.

Excel 2007 : Interest only amortization schedule with changing interest rate and extra payment option?

Loan amount fx if interest rate, payment and amortization know

Payment formula problem..:total financed amount

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions