EasyManuals Logo

Sinclair QL User Manual

Sinclair QL
422 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 #323 background imageLoading...
Page #323 background image
•
•
•
You
should calculate the
net
present value
of
the income and compare
If
with
the
sum
you
are asked
to
pay
[A1]
"flow
[A2] 0
[A3]
10000
[M]
co
l=a3*1.1
[rows
4
to
12]
[A14]
npv(flow.14,12)
[rows
2
to
12J
The result
is
shown
in
Figure
6.6
A
B
1
f
low
2
0.00
3
10000.00
4
11000.00
5
12100.00
6
13310.00
7
14641.00
8
16105.10
9
17715.61
10
19487.17
11
21435.89
12
23579.48
13
14
75088.51
Figure
6,6
Net
present
val,ue
The
net
present
value
(in
cell
A14)
of
the
cash
flow
from
the
shop
is
more
than
the
asking
price,
so
you
should go ahead.
The
first
item
in
the
list
is
for
period
zero,
the
second
is
for period
one,
and
so
on.
This
is
consistent with
the
assumption, made by the function, that
the
returns
are
received
at
the
end
of
each period.
You
therefore
have
to
wait
for
one period before
you
obtain
any return on your
investment.
In
a
real
situation
of
this type
you
would probably work
on
a monthly
basis,
rather than
on
twelve month periods.
PI()
Returns the value of the mathematical constant
7t.
RAD(n)
Takes
an
angle, measured
in
degrees, and converts
it
to
the same angle
in
radians.
REPT(text,n)
This
function
will
fill
the
current
cell
with
n copies
of
the
first
character
of
the
given
text.
For
example, .
rept
("*",5)
[will
put
five
asterisks
in
the current
cellJ
rept("abc".3)
[makes three repetilions
of
'\3"J.
ROW()
Returns the number
of
the current
row.
SGN(n)
Returns
+1,
-1, or
0,
depending
on
whether
the
argument
is
positive,
negative or zero
SIN(n)
Returns the value
of
the
sine
of
the
specified (radian)
angle.
STR(n,type,dp)
num:= n
Iype:= n
dp:=
n
Converts a number. num,
to
the
equivalent
text
string.
Type
indicates
the
form
of
the
converted string
as
follows;
odecimal (floating point)
1 exponential, or scientific, notation
2
integer.
~
general format
12/84
Reference
47

Table of Contents

Other manuals for Sinclair QL

Preview: Service Manual
Service Manual45 pages
Preview: Beginner's Guide
Beginner's Guide135 pages

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the Sinclair QL and is the answer not in the manual?

Sinclair QL Specifications

General IconGeneral
ProcessorMotorola 68008
Clock Speed7.5 MHz
RAM128 KB (expandable to 640 KB)
ROM48 KB
Operating SystemSinclair QDOS
Release Year1984
StorageMicrodrive tape loop
Graphics256x256 pixels, 8 colors
PortsRS-232, ROM cartridge
SoundBeeper (internal speaker)

Related product manuals