Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Financial< Previous | Next > 

 

Basic

 
Expand

 -

Getting Started

Step By Step

 -

Financial Terminology

Step By Step

 -

Interest Rates

Step By Step

 -

Monthly Deposits

Step By Step

 -

Loan Repayments

Step By Step

 -

Loan Repayments - Breakdown


 

Worksheet Functions

 
GoTo

 -

DB - Returns the depreciation of an asset using the fixed-declining balance method.

GoTo

 -

DDB - Returns the depreciation of an asset using the double declining balance method.

GoTo

 -

FV - Returns the future value of an investment over a period of time.

GoTo

 -

IPMT - Returns the interest paid for a given period of an investment.

GoTo

 -

IRR - Returns the percentage return (or loss) of an initial investment.

GoTo

 -

ISPMT - The interest paid during a specific period of an investment.

GoTo

 -

MIRR - Returns the modified internal rate of return for a series of periodic cash flows.

GoTo

 -

NPER - Returns the number of periods for an investment.

GoTo

 -

NPV - Returns the net present value of an investment.

GoTo

 -

PMT* - Returns the payment for a loan with constant payments and fixed interest.

GoTo

 -

PPMT - Returns the payment on the principal for a given period for an investment.

GoTo

 -

PV - Returns the present value of an investment.

GoTo

 -

RATE - Returns the interest rate per period of an annuity.

GoTo

 -

SLN - Returns the straight-line depreciation of an asset for one period.

GoTo

 -

SYD - Returns the depreciation of an asset using the sum of years method.

GoTo

 -

VDB - Returns the depreciation of an asset using a variable declining method.


 

Advanced

 
More Details

 -

Advanced Financial Functions

More Details

 -

Advanced Technqiues

More Details

 -

Office Online

More Details

 -

Knowledge Base


 

Related Topics

 
GoTo

 -

Functions

GoTo

 -

Database


 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top