lease payment calculator

%3CLINGO-SUB%20id%3D%22lingo-sub-879978%22%20slang%3D%22en-US%22%3Elease%20payment%20calculator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879978%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20set%20up%20an%20excel%20file%20that%20calculates%20the%20payment%20per%20month%20on%20a%20Fair%20Market%20Value%20lease.%20Can%20somebody%20please%20direct%20me%20to%20a%20function%20in%20excel.%26nbsp%3B%20Thanks%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-879978%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880441%22%20slang%3D%22en-US%22%3ERe%3A%20lease%20payment%20calculator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880441%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20Can%20Solve%20this%20using%20SUM%20IF%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DSUMIFS%20(sum_range%2C%20range1%2C%20criteria1%2C%20%5Brange2%5D%2C%20%5Bcriteria2%5D%2C%20...)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880526%22%20slang%3D%22en-US%22%3ERe%3A%20lease%20payment%20calculator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880526%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416575%22%20target%3D%22_blank%22%3E%40xl-user%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20Excel%20two%20built-in%20functions%2C%20Future%20Value%20FV()%20and%20Present%20Value%20PV()%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fpv-function-23879d31-0e02-4321-be01-da16e8168cbd%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fpv-function-23879d31-0e02-4321-be01-da16e8168cbd%3C%2FA%3E.%20Perhaps%20the%20latest%20one%20is%20more%20close%20to%20FMV%20lease.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880530%22%20slang%3D%22en-US%22%3ERe%3A%20lease%20payment%20calculator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880530%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416575%22%20target%3D%22_blank%22%3E%40xl-user%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20order%20to%20calculate%20monthly%20lease%20payments%20in%20excel%2C%20you%20can%20use%26nbsp%3B%3CSTRONG%3E%3CSPAN%3EPMT(rate%2C%20nper%2C%20pv%2C%20%5Bfv%5D%2C%20%5Btype%5D)%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Efunction.%3C%2FP%3E%3CP%3EFor%20more%20specific%20solution%20you%20need%20to%20share%20sample%20data%20with%20complete%20parameters.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I want to set up an excel file that calculates the payment per month on a Fair Market Value lease. Can somebody please direct me to a function in excel.  Thanks !

 

3 Replies
Highlighted

Hi!

 

You Can Solve this using SUM IF formula.

 

=SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], ...)

Highlighted

@xl-user 

In Excel two built-in functions, Future Value FV() and Present Value PV() https://support.office.com/en-us/article/pv-function-23879d31-0e02-4321-be01-da16e8168cbd. Perhaps the latest one is more close to FMV lease.

Highlighted

Hi @xl-user 

 

In order to calculate monthly lease payments in excel, you can use PMT(rate, nper, pv, [fv], [type])

function.

For more specific solution you need to share sample data with complete parameters.

Thanks

Tauqeer