How to Calculate Loan Amount From Payment

How you can Calculate Amount Borrowed From Payment

You are able to calculate what amount borrowed you are able to borrow from the loan provider in line with the rate of interest, term from the loan and also the obligations you’d have the ability to make. The borrowed funds amount may be the present worth of the allowance, the stream of obligations that’ll be made around the loan. Learn to calculate the borrowed funds amount according to obligations using three different techniques: Microsoft Stand out, financing amount calculator and also the amount borrowed formula.

Difficulty: Moderate

Instructions

Things You Will Need

Mircosoft Stand out

Calculator

1)Use Stand out to calculate the borrowed funds amount according to obligations made. Inside a cell, go into the formula =PV(rate of interest,payment periods,payment amount). For instance, if you’re making $4,500 monthly obligations on 30-year loan by having an rate of interest of seven percent, the formula could be =PV(.07/12,12*30,-4500), which provides a worth of $676,384.06.

2)Utilizing a loan-amount calculator (see Assets), go into the annual interest payment, the amount of several weeks the borrowed funds is perfect for, the lower payment, if any, and also the payment per month amounts. Click the “Calculate Amount BorrowedInch button to discover the borrowed funds amount. Using our example previously mentioned, enter 7, 360, and 4,500 within the particular fields. The resulting amount borrowed is $676,384.06.

3)Make use of the formula PV=(C/(i/12)) x (1-(1/(1+(i/12))^n)), where

C= payment

i = rate of interest

n = loan term

Using our example previously mentioned, PV=(4500/(.07/12)) x (1-(1/(1+(.07/12))^360)) = $676,384.04