JZ Finance is a library of various useful financial functions to generate various schedules, tables and analysis using one simple formula This library is written using Excel built-in formulas and lambda functions to hide the complexities of combining multiple excel functions.
JZ Finance consists of below categories of functions:
- Full Schedules
JZ.Loan_Scheduleto generate a full loan amortization schedule for any loan. User can select which columns to display and in what order (For details: Click here)
- Single Data Point
Demo file is available in demo folder that demonstrates how to use this function
- Get Excel Labs add-in from https://aka.ms/get-afe
- On Home tab in Excel, click on Excel Lab
- Click on Modules
- Click on Import from URL button
- Enter this URL https://gist.github.com/jahanzaibriaz/ee2752fc71a5f6eb11aa0cb897486f39
- In any cell, enter "=JZ.Loan_Schedule(12%, 60, 100000)"
JZ Finance is MIT licensed.
You could open an issue.
JZ.LOAN_SCHEDULE: generate the full loan schedule, selected columns, selected rows or individual data point. It takes following aruments