
|
|
Specifying total number of payment periods in the annuity. </> and <*> are accepted as divide and multiply respectively. Eg for 2 years loan, total payment periods is entered as 2*12 |
|
|
Specifying interest rate per period. </> and <*> are accepted as divide and multiply respectively. Eg 5% annual interest rate, interest per month is entered as 5/12 |
|
|
Specifying present value, or the lump-sum amount that a series of future payments is worth right now |
|
|
Specifying future value or cash balance you want after you've made the final payment |
|
|
Specifying payment made each period and cannot change over the life of the annuity |
|
|
Specifies the period and must be in the range 1 to NPer for loan calculations. </> and <*> are accepted as divide and multiply respectively. Eg for 2 years loan, total payment periods is entered as 2*12. Or specifies reinvest interest rate for MIRR calculation. </> and <*> are accepted as divide and multiply respectively. Eg 5% annual interest rate, interest per month is entered as 5/12 |
|
|
Specifies a series of cash flows (payment or income), must
contain at least one positive value and one negative value to calculate the
MIRR or IRR. The cash flow entries will be re-format after executing the
calculation. This entry box will be brought up by clicking |
|
|
|
|
Calculate the payment for an annuity based on periodic, fixed payments and a fixed interest rate |
|
|
Calculate the future value of an annuity based on periodic, fixed payments and a fixed interest rate |
|
|
Calculate the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate |
|
|
Calculate the interest rate per period for an annuity |
|
|
Calculate the number of periods for an annuity based on periodic, fixed payments and a fixed interest rate |
|
|
Calculate the outstanding loan from period 1 to Per |
|
|
Calculate cumulative interest pay on a loan from period 1 to Per |
|
|
Calculate cumulative principal pay on a loan from period 1 to Per |
|
|
Calculate the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate |
|
|
Calculate the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate |
|
|
Calculate the net present value of an investment based on a series of periodic cash flows (payments and receipts) and a discount rate |
|
|
Calculate the modified internal rate of return for a series of periodic cash flows (payments and receipts) |
|
|
Calculate the internal rate of return for a series of periodic cash flows (payments and receipts) |
|
|
Calculate the effective annual interest rate |
|
|
Calculate the annual nominal interest rate |
|
|
|
Clear all entries in financial calculation |
|
|
Bring up Cash Flow entry box |
|
|
Specifies payments are due. |