I figured it out... since the PMT function puts out a negative number I just
changed the PV in the equation to a negative number. Two negatives equal a
positive.

Thanks again!

Larry Hughes

323.228.2736 cell

"Tom Ogilvy" wrote:

Look at the PMT (Payment) function in Excel help.

there are a series of related functions associated with PMT. In the help
click on the See also Link. The PV (present Value) formula help actually has
the "master" formula for these functions and provides greater detail.

--
Regards,
Tom Ogilvy



"Larry Hughes" wrote:

I'm a Home Loan Officer in Los Angeles and I'm creating a Finance sheet for
some realtors I work with for there open houses and I'm looking to give
examples of payments.

So what I need is the formula of the Loan Amortization of a 30 year fixed
loan. Is there documentation on it that breaks it down sot that know how to
apply it with my sheet?

Larry Hughes
Progressive Loan Funding

(323) 228-2736 cell