Purpose

Return value

Syntax

=RRI(nper,pv,fv)
  • nper - Number of periods.
  • pv - Present value of investment.
  • fv - Future value of investment.

Using the RRI function

The RRI function returns an equivalent interest rate for the growth of an investment. For example, to use RRI to calculate equivalent annual compound interest for a 1000 investment worth 1200 after five years you can use a formula like this:

=RRI(5,1000,1200) // returns 0.037137289

In the example shown, the formula in G6 is:

=RRI(B11,C6,C11)

Purpose

Return value

Syntax

=SLN(cost,salvage,life)
  • cost - Initial cost of asset.
  • salvage - Asset value at the end of the depreciation.
  • life - Periods over which asset is depreciated.

Using the SLN function

The Excel SLN function returns the depreciation of an asset for one period, calculated with a straight-line method. The calculated depreciation is based on initial asset cost, salvage value, and the number of periods over which the asset is depreciated.

For example, for an asset with an initial cost of $10,000, a useful life of 5 years, and a salvage value of $2,000:

=SLN(10000,2000,5) // returns $1600

In the example shown, the formula in C6, copied down, is:

=SLN(cost,salvage,life)

where named ranges are defined as follows:

cost = G4
salvage = G5
life = G6