Financial Calculator Overview

 

Screen Shot

 

 

Entry Boxes

 

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 . The entry box will automatically disappear. The number on the top right corner specifies the present line number

 

 

 

Command Buttons

 

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.