:: Reference:: Payments family:: MkPmts
[Categories][Families][Data Types][Variables][Topics]
MkPmts (Time, Base, PmtDates, Pmts)
Make several Payments
Pro
Auto Array Function
Features
...Pmts...Payments
Whats good or unique about it

There"s nothing remarkable about this function except that it works and there is no equivalent without lots of IF statements! This is a real building block for budgets and business plans, where you want to chuck a load of payments and dates into your model and let the function take care of the scheduling.

Example
MkPmts.xls  
Templates
This function features in the following downloadable spreadsheet template(s):
reallysimpleleaseanalysis.xls  loan_mortgage_extrapayments.xls  finance_lease.xls  simplecashflow.xls  simpproj.xls  whybusinessfunctionsforproperty.xls  businessplancashflow.xls  loan_property.xls  simpledcfanalysis.xls  spreadingcapex.xls  loan_schedrep.xls  loan_rollup.xls  dcfleaseappraisal.xls  uktakeover.xls  accrec.xls  

Any comments on this documentation? Send us your suggestions below.

Your Email Address (required)
Subject
Message
See Also

MkPmtsSF

MkPmtsPer

MkPmtsPerGrow

MkPmtsPerFcst

PVMkPmts

MatchPmts

570