Home

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
xl-user
New Contributor

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

Hi!

 

You Can Solve this using SUM IF formula.

 

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

@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.

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

 

 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies