| Loan (Time, Base, FromDatesInt, IntSimple, AdvanceDates, NetAdvances, RepaymentDate, [LoanOutput], [DayCount], [PrdsInt], [ProjMode]) | | Calculate a loan (interest, principal and balance) | | | | Pro | | Auto Array Function | | | Example Loan.xls | TemplatesThis function features in the following downloadable spreadsheet template(s):
loan_mortgage.xls loan_mortgage_extrapayments.xls max_loan_mortgage.xls simpleresidual.xls whybusinessfunctionsforproperty.xls businessplancashflow.xls loan_property.xls loan_amortisation_with_loanx.xls loan_schedrep.xls simplebondissue.xls constructionloan.xls usaprconvertor.xls loan_mortgage_matcheddebtservice.xls loan_rollup.xls property_loan.xls |
Any comments on this documentation? Send us your suggestions below. | 