How do I find the loan amount from my payment in Excel?

N

New Plaza

I am building a cost analysis and I know what I can afford for a monthly
payment but I need to know what the total loan amount would be for that
payment. EX:

20 year amortized
7.5% Interest
$1,526 monthly payment

???? Total loan would be?
 
F

Fred Smith

You want to calculate present value, as in:

=pv(7.5%/12,20*12,-1526)

It will show you can support a $190K loan.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating interest due on late loan payments 1
Interest payment 2
Loan Amount 1
Calculate the annual payment for a $4,000 loan, 3%, 3 years, 2
Looking for Compounding Interest Loan Template 1
Variable interest rate loan calculations- PLEASE HELP!!! 1
identifying the next working day after weekends and/or holidays 2
How do I use Excel 2007 to determine late payment amounts 3

Top