EasyManuals Logo

Sharp Zaurus ZR-5700 User Manual

Sharp Zaurus ZR-5700
529 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #354 background imageLoading...
Page #354 background image
91
PV(rate, nper, pmt,
fv
,
type
)
Computes the present value for a fixed payment
pmt made for the number of periods nper, at a
fixed interest rate. It assumes the future value to
be 0 if
fv
is omitted, assumes the payments are
made at the end of the periods if
type
is 0 or
omitted, and at the beginning of the month if
type
is 1.
Example: PV(7.5%,20,-10000) returns
101944.91.
PV(0.08/12,12*20, -500, 10000,1) returns
58145.95.
RATE(nper, pmt, pv,
fv
,
type
,
guess
)
Computes the periodic interest rate required for a
fixed payment pmt made for the number of periods
nper to have the present value pv. It assumes that
the future value to be 0 if
fv
is omitted. It assumes
payments to be made at the end of the periods if
type
is 0 or omitted, and at the beginning of the
periods if
type
is 1.
guess
is as a starting approxi-
mation to the expected result; it is assumed to be
10% if omitted.
Example: RATE(48, -200, 8000) returns 0.77%.
The annual rate would be 0.77%*12 which is
9.2%. RATE (60, -700, 100000, -140000, 1, 1%)
returns 0.0117 (or 1.17%).
SLN(cost, salvage, life)
Computes the straight-line depreciation of an
asset, acquired at cost, with the specified life and
estimated final salvage value. It spreads the rate
of depreciation evenly among all periods.
Example: SLN(30000, 7500, 10) returns 2250.
SYD(cost, salvage, life, per)
Calculates the sum-of-the-years depreciation for
an asset, acquired at cost, with specified life and
estimated final salvage, for the specified period
per.
Example: SYD(30000, 7500, 10, 1) returns
4090.91.

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the Sharp Zaurus ZR-5700 and is the answer not in the manual?

Sharp Zaurus ZR-5700 Specifications

General IconGeneral
BrandSharp
ModelZaurus ZR-5700
CategoryOrganizer
LanguageEnglish

Related product manuals