Be aware that these video clips
use Windows Media Player. Click on the hyperlink and, depending on your
connection speed, you may need to wait a few moments.
| Title |
Price
|
Video
Clip
(Windows Media Player) |
Rate
(NEW)
Calculate the interest RATE charged on a constant annuity cash flow.Excel Help File Description:
Returns the interest rate per period of an annuity. RATE is calculated
by iteration and can have zero or more solutions. If the successive
results of RATE do not converge to within 0.0000001 after 20
iterations, RATE returns the #NUM! error value. |
FREE |
Rate
(2 min) |
 |
Internal Rate of Return/ IRR (NEW)
Calculate the Internal Rate of Return of a series of cash flowsExcel Help File Description:
Returns the internal rate of return for a series of cash flows
represented by the numbers in values. These cash flows do not have to
be even, as they would be for an annuity. However, the cash flows must
occur at regular intervals, such as monthly or annually. The internal
rate of return is the interest rate received for an investment
consisting of payments (negative values) and income (positive values)
that occur at regular periods. |
FREE |
IRR
(2 min) |
|
Net Present Value/ NPV
(NEW)
Calculate the Net Present Value of a series of cash flows.Excel Help File Description:
Calculates the net present value of an investment by using a discount
rate and a series of future payments (negative values) and income
(positive values). |
FREE |
NPV
(3 min) |
|
Calculate the Compound Annual Growth Rate
(CAGR) using Excel (NEW)
Use the RATE function to calculate the CAGR |
FREE |
CAGR
(2 min) |
|
PMT
The PMT function calculates the required repayment amount to
amortise (pay off) a debt or loan based on the original capital
amount, interest charged and term of the loanExcel Help File Description:
Calculates the payment for a loan based on constant payments and a
constant interest rate
|
FREE |
|
|
CUMIPMT & CUMPRINC
The CUMIPMT and CUMPRINC functions allow you calculate the total
interest or capital (principal) paid between any two periods without
having to build an amortization table.Excel Help File Description:
Returns the cumulative interest paid (or principal paid) on a loan
between start period and end period. If this function is not
available, and returns the #NAME? error, install and load the Analysis
ToolPak add-in (follow this link
to learn how).
|
FREE |
|
|
|
Quote of the page:
Opportunities multiply as they are seized- Sun- Tzu (The Art of War)
|
|
|
Have you heard about Spreadsheet
Professional??
Find out more on the
Spreadsheet Professional
pages |
Do you like what you see. Tell your friends. If you have a
training coordinator
at your organisation tell them that there is free excel training available
at this site.
