Excel provides 50 functions to perform financial calculations yet most of these functions have limited functionality. For instance,NPV function in Excel calculates net present value for cash flows with end of period payments using discrete compounding of interest. It does not permit finding NPV for cash flows with start of period payments. All of the financial functions in Excel assume that interest is discounted or compounded discretely as in per period discounting. Yet a large number of financial applications require continuous compounding of interest. And there are a good number of financial functions that are not available in Excel; for instance, there aren't any financial functions in Excel to calculate payback period, discounted payback period, profitability index, benefits to costs ratio, net future value.
| Qty. |
Product Description |
Price |
Action |
| 1 |
23 Functions TADXL Lite Add-in for Excel 2007/2010/2011 |
$9 |
|
| 1 |
31 Functions TADXL Biz Add-in for Excel 2007/2010/2011 |
$14 |
|
| 1 |
41 Functions TADXL Diff Add-in for Excel 2007/2010/2011 |
$19 |
|
| System Requirement: MS Windows XP, Windows 7, Windows Vista & other Windows Server OS |
2Checkout.com is an authorized retailer for ThinkAndDone.com
|
TADXL Lite
We at thinkanddone.com have addressed these limitations in Excel by providing you TADXL Excel add-in for finance. The TADXL add-in provides new financial functions that you can type in to a worksheet cell and it extends the functionality of existing financial functions. All financial functions in TADXL add-in permit you to select type of periodic payments whether start of period or end of period. TADXL add-in also lets you select from either discrete or continuous compounding of interest. As of current, TADXL Lite has been made available to our web users that contains commonly used financial functions. TADXL Lite Add-in for Excel includes 23 functions that may be placed in 3 different categories. TADXL Lite includes 5 TVM functions, 8 capital budgeting functions and 10 interest rate factor functions.
TVM Functions in TADXL Add-in
| Function |
Description |
| tadFV |
Excel function to calculate compound amount for a lump sum investment or a series of annuity payments. It permits you to specify whether interest is compounded discretely or compounded continuously. |
| tadNPER |
Excel function to calculate number of periods required to repay a loan, mortgage, annuity, pension fund. It permits you to specify whether interest is compounded discretely or compounded continuously. |
| tadPMT |
Excel function to calculate lump-sum or payment amount of an annuity with start of period payments, and annuity with end of period payments. It permits you to specify whether interest is compounded discretely or compounded continuously. |
| tadPV |
Excel function to calculate principal of a loan, mortgage, and market value of securities such as bonds. It permits you to specify whether interest is compounded discretely or compounded continuously. |
| tadRATE |
Excel function to calculate interest rate paid on a loan, mortgage, lease, savings account, yield to maturity YTM, yield to call YTC and other forms of periodic interest. It permits you to specify whether interest is compounded discretely or compounded continuously. |
Investment Analysis Functions in TADXL Add-in
| Function |
Description |
| tadBCR |
Excel function to calculate benefits to costs ratio (B/C ratio) from a series of payments (negative amounts) and series of receipts (positive amounts). The cash flows are discounted at a discount rate called weighted average cost of capital. You can select from either discrete or continuous compounding of interest. |
| tadDPP |
Excel function to calculate discounted payback period from a series of a cash flows where the first cash flow reflects an initial cost. The cash flows are discounted at the WACC or weighted average cost of capital to represent their present value. It lets you specify whether series of payment are made at start of period or at end of period. You can select from either discrete or continuous compounding of interest. |
| tadIRR |
Excel function to calculate internal rate of return from a series of payments (negative amount) and series of receipts (positive amounts). At least one of the cash flows must be negative and at least of the cash flows must be negative. You can select from either discrete or continuous compounding of interest. |
| tadMIRR |
Excel function to calculate adjusted or modified internal rate of return from a series of mixed cash flows. Positive cash flows represent receipts that are compounded at the reinvestment rate. Negative amounts represent costs discounted at the finance rate. Unlike IRR, you can always calculate MIRR given that at least one of the cash flows is negative and one is positive. It lets you specify whether series of payment are made at start of period or at end of period. You can select from either discrete or continuous compounding of interest. |
| tadNFV |
Excel function to calculate net future value or compound amount from a series of uneven cash flows. It lets you specify whether series of payments are made at start of period or at end of period. You can select from either discrete or continuous compounding of interest. |
| tadNPV |
Calculates net present value of stream of cash flows that make either start of period or end of period payments. It lets you specify whether series of payment are made at start of period or at end of period. You can select from either discrete or continuous compounding of interest. |
| tadPI |
Excel function to calculate profitability index from a series of cash flows where the positive cash flow represent receipts and the negative cash flows represent payments. The cash flows are discounted at the weighted average cost of capital. You can select from either discrete or continuous compounding of interest. |
| tadPP |
Excel function to calculate payback period from a series of mixed cash flows where the first cash flow represents the initial cost. It lets you specify whether series of payment are made at start of period or at end of period. You can select from either discrete or continuous compounding of interest. |
Interest factors functions in TADXL Add-in
| Function |
Description |
| tadCAF |
Excel function to calculate compound amount factor of $1 at an interest rate of i% for n number of periods. You can specify whether interest is compounded discretely or continuously. |
| tadCRF |
Excel function to calculate capital recovery factor of $1 at an interest rate of i% for n number of periods. You can specify whether interest is compounded discretely or continuously. |
| tadFVIF |
Excel function to calculate FVIF or future value interest factor of $1 at an interest rate of i% for n number of periods. You can specify whether interest is compounded discretely or continuously. |
| tadFVIFA |
Excel function to calculate FVIFA or future value interest factor of ordinary annuity that makes payments of $1 at an interest rate of i% for n number of periods. You can specify whether interest is compounded discretely or continuously. |
| tadFVIFAD |
Excel function to calculate FVIFAD or future value interest factor of annuity due that makes payments of $1 at an interest rate of i% for n number of periods. You can specify whether interest is compounded discretely or continuously. |
| tadPVIF |
Excel function to calculate PVIF or present value interest factor of $1 at an interest rate of i% for n number of periods. You can specify whether interest is compounded discretely or continuously. |
| tadPVIFA |
Excel function to calculate PVIFA or present value interest factor of an ordinary annuity that makes payments of $1 at an interest rate of i% for n number of periods. You can specify whether interest is compounded discretely or continuously. |
| tadPVIFAD |
Excel function to calculate PVIFAD or present value interest factor of annuity due that makes payments of $1 at an interest rate of i% for n number of periods. You can specify whether interest is compounded discretely or continuously. |
| tadPWF |
Excel function to calculate present worth factor of $1 at an interest rate of i% for n number of periods. You can specify whether interest is compounded discretely or continuously. |
| tadSFF |
Excel function to calculate sinking fund factor of $1 at an interest rate of i% for n number of periods. You can specify whether interest is compounded discretely or continuously. |
TADXL Biz
TADXL Biz is the incremental version providing 8 more functions to the existing 23 functions contained in TADXL Lite. The 8 new functions in TADXL Biz relate to analyzing investments when cash flows are not periodic and occur on irregular dates. MS Excel only has 2 of these functions namely XIRR and XNPV and even these two functions are bit limited as interest is assumed to be compounded discretely. With TADXL Biz, you get 8 new functions to analyze investments with irregular cash flows. Have a look at the following brief description of the 8 functions contained in TADXL Biz Excel add-in for finance.
Investment Analysis Functions in TADXL Biz Add-in
| Function |
Description |
| tadXBCR |
Excel function to calculate benefits to costs ratio (B/C ratio) from series of payments (negative amounts) and series of receipts (positive amounts) that are not periodic. The cash flows are discounted at a discount rate called weighted average cost of capital. You can select from either discrete or continuous compounding of interest. |
| tadXDPP |
Excel function to calculate discounted payback period from a series of a cash flows that are not periodic where the first cash flow reflects an initial cost. The cash flows are discounted at the WACC or weighted average cost of capital to represent their present value. You can select from either discrete or continuous compounding of interest. |
| tadXIRR |
Excel function to calculate internal rate of return from a series of payments (negative amount) and series of receipts (positive amounts) that are not periodic. At least one of the cash flows must be negative and at least of the cash flows must be negative. You can select from either discrete or continuous compounding of interest. |
| tadXMIRR |
Excel function to calculate adjusted or modified internal rate of return from a series of mixed cash flows that are not periodic. Positive cash flows represent receipts that are compounded at the reinvestment rate. Negative amounts represent costs discounted at the finance rate. Unlike IRR, you can always calculate MIRR given that at least one of the cash flows is negative and one is positive. You can select from either discrete or continuous compounding of interest. |
| tadXNFV |
Excel function to calculate net future value or compound amount from a series of uneven cash flows that are not periodic. You can select from either discrete or continuous compounding of interest. |
| tadXNPV |
Calculates net present value of stream of cash flows that are not periodic. You can select from either discrete or continuous compounding of interest. |
| tadXPI |
Excel function to calculate profitability index from a series of cash flows where the positive cash flow represent receipts and the negative cash flows represent payments that are not periodic. The cash flows are discounted at the weighted average cost of capital. You can select from either discrete or continuous compounding of interest. |
| tadXPP |
Excel function to calculate payback period from a series of mixed cash flows that are not periodic where the first cash flow represents the initial cost. You can select from either discrete or continuous compounding of interest. |
TADXL Diff
TADXL Diff is the next step from previous version of TADXL providing 10 more functions to the existing 31 functions contained in TADXL Biz. The 10 new functions in TADXL Diff relate to analyzing investments when series of cash flows are discounted or compounded at different discount rates. Excel only permits calculation of NPV using a single rate yet in a good number of financial applications annuity payments may be discounted at different rates. A prime example of this relates to variable rate mortgages where rates on loan are different from one year to the next. Here TADXL Diff provides the solution with it's 10 new functions that permit discounting of cash flows at different rates. There are 5 functions in TADXL that not only permit use of different discount rates but also let you calculate financial metrics for irregular cash flows. See the list of functions in TADXL Diff listed in the following table.
Investment Analysis Functions in TADXL Diff Add-in
| Function |
Description |
| tadDRBCR |
Excel function to calculate benefits to costs ratio (B/C ratio) from a series of payments (negative amounts) and series of receipts (positive amounts). The series of cash flows may be discounted using different discount rates. You can select from either discrete or continuous compounding of interest. |
| tadDRDPP |
Excel function to calculate discounted payback period from a series of a cash flows where the first cash flow reflects an initial cost. The series of cash flows may be discounted using different discount rates to represent their present value. It lets you specify whether series of payment are made at start of period or at end of period. You can select from either discrete or continuous compounding of interest. |
| tadDRNFV |
Excel function to calculate net future value or compound amount from a series of uneven cash flows. The series of cash flows may be compounded using different discount rate. It lets you specify whether series of payments are made at start of period or at end of period. You can select from either discrete or continuous compounding of interest. |
| tadDRNPV |
Calculates net present value of stream of cash flows that make either start of period or end of period payments. The series of cash flows may be discounted using different discount rates. It lets you specify whether series of payment are made at start of period or at end of period. You can select from either discrete or continuous compounding of interest. |
| tadDRPI |
Excel function to calculate profitability index from a series of cash flows where the positive cash flow represent receipts and the negative cash flows represent payments. The series of cash flows may be discounted using different discount rates. You can select from either discrete or continuous compounding of interest. |
| tadDRXBCR |
Excel function to calculate benefits to costs ratio (B/C ratio) from series of payments (negative amounts) and series of receipts (positive amounts) that are not periodic. The series of cash flows may be discounted using different discount rates. You can select from either discrete or continuous compounding of interest. |
| tadDRXDPP |
Excel function to calculate discounted payback period from a series of a cash flows that are not periodic where the first cash flow reflects an initial cost. The series of cash flows may be discounted using different discount rates to represent their present value. You can select from either discrete or continuous compounding of interest. |
| tadDRXNFV |
Excel function to calculate net future value or compound amount from a series of uneven cash flows that are not periodic. The series of cash flows may be compounded using different discount rate. You can select from either discrete or continuous compounding of interest. |
| tadDRXNPV |
Calculates net present value of stream of cash flows that are not periodic. The series of cash flows may be discounted using different discount rates. You can select from either discrete or continuous compounding of interest. |
| tadDRXPI |
Excel function to calculate profitability index from a series of cash flows where the positive cash flow represent receipts and the negative cash flows represent payments that are not periodic. The series of cash flows may be discounted using different discount rates. You can select from either discrete or continuous compounding of interest. |