A Particular Amortization Method

[homevestors]

Hello,

How can I create a formula in excel to determine a "maximum mortgage o
$51,645" by just plugging in the monthly payment, the rate, and th
term?

::$361/month at 7.5% on a 30 year amortization equals a maximu
mortgage of- $51,645-:

 

[Mike Middleton]

homevestors -

=PV(0.075/12,30*12,-361)

- Mike

"homevestors" <[email protected]>
wrote in message
news:[email protected]...

 

[homevestors]

That is so awesome! Thank you very much!