Is there a formula in Excel to calculate a loan amount?
Check the PV function. You'd set the FV argument to 0, and multiply the
result by -1. Also, be sure to adjust the rate and term to match the
payments (ex: if you are using the MONTHLY payment amount, your rate would be
the annual rate/12 and the term would be the number of years * 12).
--Bruce
"DTOLLEN" wrote:
Is there a formula in Excel to calculate a loan amount if you give the rate,
payment and term?
|