Trying to reverse fx to achive total loan amount available if payment,
interest rate and amortization is known.
Thanks.
Trying to reverse fx to achive total loan amount available if payment,
interest rate and amortization is known.
Thanks.
If, by amortization, you mean the number of payments, then the Present Value
(PV) function should take care of it.
"Kevin." wrote:
> Trying to reverse fx to achive total loan amount available if payment,
> interest rate and amortization is known.
> Thanks.
I was unable to get that working. Here is the factor I am trying to determine:
total monthly payment: known - $2165
amortization: known: known - 25 years
interest rate: known - 5%
Starting loan amount: x-formula to calculate, should be approx $372245.00
If you can help, it would be appricated.
Thanks
"bpeltzer" wrote:
> If, by amortization, you mean the number of payments, then the Present Value
> (PV) function should take care of it.
>
> "Kevin." wrote:
>
> > Trying to reverse fx to achive total loan amount available if payment,
> > interest rate and amortization is known.
> > Thanks.
Be sure that each entry refers to a common period. In your case, we'll use
months. The interest rate, PER MONTH is 5%/12, the number of months is 25*12
and the payment is 2165. When I enter =PV(5%/12, 25*12, 2165), I get
($370,345).
Either ignore the minus sign, or set the payments as -2165. It's a matter
of cash inflows vs outflows.
"Kevin." wrote:
> I was unable to get that working. Here is the factor I am trying to determine:
> total monthly payment: known - $2165
> amortization: known: known - 25 years
> interest rate: known - 5%
>
> Starting loan amount: x-formula to calculate, should be approx $372245.00
>
> If you can help, it would be appricated.
> Thanks
>
> "bpeltzer" wrote:
>
> > If, by amortization, you mean the number of payments, then the Present Value
> > (PV) function should take care of it.
> >
> > "Kevin." wrote:
> >
> > > Trying to reverse fx to achive total loan amount available if payment,
> > > interest rate and amortization is known.
> > > Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks