Category : Lotus and other Spreadsheets
Archive   : POWERWKS.ZIP
Filename : NPV.WKS

N/





ÿq H
ACCUM AGENDABEEP

BLANKCALCCASHFLOW

CLEARMSG

COPYRIGHT

COPYRIGHT_P1



DISFACTSÿÿDISRATESDOWNCOL

DUMMYERASE
%
%GRAPH00GRAPHOPT;;GRAPHTYPE 9 9INPUT  MENUNCASH

NDISC

NPVSPDNUMS PRINTAAPTEMPRESULTS))SCROLL ) )SCROLLCOL))SETCOUNT

SETSKIP 0 0TEMP



TESTDATA\0\B\I

\M


ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ 0
 5
ÿÿÿÿ ÿÿÿÿ# ÿÿÿÿ ÿÿÿÿÿÿÿÿ$
%ò&ò'((
LB)
'*ÿÿÿÿÿÿ-µ


 ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ
CASH FLOW VALUES Period Number $ Cash Flow Cum Cash Flow qq
ÿ\=ÿ
\=ÿ\=ÿ\=ÿ\=
ÿ'\M: ÿ'BEEP:ÿ'DOWNCOL:
ÿ '\I: ÿ
'TEMP:+ÿ'To end, press ctrl-break then alt-I.ÿ'CLEARMSG:
ÿ
'NPV?ÿ

' Copyright (c) 1984, Wildfire Technology Inc.ÿ
'{home}/XMmenu~ÿ
'//{esc}ÿ
'{?}{down}ÿ
'{home}/XMinput~

'?ÿ
' Copyright (c) 1984, Wildfire Technology Inc.ÿ
'/REa6~/REd6.e11~ÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-
ÿ'/XR
ÿ'/XGi2~
ÿ'/XR)ÿ
' Net Present Value Calculator ÿ'MENU:ÿ\=ÿ
\=ÿ\=ÿ\=ÿ\= ÿ'Input ÿ'Blankÿ'Calcÿ 'Results ÿ
'Graph ÿ'Print
ÿ 'Agendaÿ
'Quit   Dÿ'Input periods per year, cash flow values, and discount rates.!ÿ'Blank out all input areas.ÿ'Calculate resultsÿ 'Display results..ÿ
'Plot graphs of cashflow and/or results.#ÿ'Print input data and results,ÿ 'Return to worksheet selection agenda. ÿ
'Exit to 1-2-3 READY mode.ÿ'Periods/Year: 
  
ÿ'/XG\i~ÿ'/XMblank~ÿ'/XGcalc~ÿ '/XMresults~ÿ
'/GOTS{?}~QQÿ'/XGprint~ÿ '/XMagenda~
ÿ
'{home}ÿ"Accumulated  ÿ
'/XMgraph~ÿ"Period Numberÿ
"Cashflow Valueÿ"Cashflow  
ÿ'INPUT:ÿ\-ÿ\- "
¢   ÿ 'Cashflowÿ 'Periods/Yrÿ 'DiscRateÿ 'Quit ÿ 'In cashflow value column: "

¢


'ÿ
'Enter cashflow values per period(ÿ
'Enter number of periods per year.&ÿ
'Enter annual discount rate (%).ÿ
'Return to main menu.ÿ
'AGENDA:#ÿ
' - Cash Inflows are POSITIVE "
 ¢ÿ'{home}{goto}b10~)ÿ'/XNNo. of Periods per Year: ~temp~ÿ'{home}{goto}d15~ÿ '/XCclearmsg~ ÿ'No
ÿ 'Yes$ÿ' - Cash Outflows are NEGATIVE "
¢ ÿ "% Discountÿ "Net Presentÿ '/RUa6~/Cl1~a6~/RUa6~\ÿ '/XI(temp<=0)#or#temp<>@int(temp)~/XCbeep~/XLPeriods must be >0 & Integer~temp~/XGf12~ÿ '/RUa6~/Cl1~a6~/RUa6~ÿ '/XMmenu~8ÿ 'Do not leave this worksheet; Return to main menu.>ÿ 'Leave this worksheet; Go to worksheet selection agenda.ÿ ' - Period 0 is NOW "

¢
ÿ
"Rate (p.a.) ÿ
"Value'ÿ
'/RUd6.e11~/Co9.p14~d6~/RUd6.e11~ÿ
'/RUb7~/Ctemp~b7~'ÿ
'/RUd6.e11~/Co9.p14~d6~/RUd6.e11~ÿ
'/XMmenu~ÿ
'/FRagenda~ÿ
\-ÿ
\- "
 ¢  ¢ÿ'/XGdowncol~ÿ'/XMinput~ÿ'/XGdowncol~ "
 ¢  ¢ÿ'\0: \B: "
 ¢  ¢
ÿ'BLANK:+ÿ'{home}/WGPD/DFa10.a310~0~1~300~/WGPE "
 ¢  ¢ ÿ'No
ÿ'Yes%ÿ'/RUb7~/RUb10.b310~/RUd15.d310~ "
 ¢  ¢.ÿ'Do not erase data. Return to main menu.(ÿ'Erase all input data and results.ÿ'/RUncash~/REncash~ "
 ¢  ¢ÿ'/XMmenu~ÿ'{goto}b7~/re~ÿ'/RUndisc~/REndisc~ "
 ¢  ¢'ÿ'{goto}b10~/RE{end}{down}{right}~
ÿ'/XG\m~ "
 ¢  ¢.ÿ'{goto}d15~/RE{end}{down}{right}{right}~ "
 ¢  ¢ÿ'/XMmenu~ "
 ¢  ¢ "
 ¢  ¢ ÿ'CALC:ÿ'TESTDATA:
ÿ
'NCASH: "
 ¢  ¢ÿ'/XCtestdata~Jÿ'/XIb7=0~/XCbeep~/XLZero periods per year not allowed.~temp~/XMmenu~

 "
 ¢  ¢Cÿ'/XIncash=@count(b10.b310)#AND#ndisc=@count(d15.d315)~/XGg39~Zÿ'/XI@count(b10.b11)<2~/XCbeep~/XLFewer than 2 cashflow values entered.~temp~/XMmenu~
ÿ
'NDISC: "
 ¢  ¢ÿ'/XCsetcount~/XCerase~Oÿ'/XI@count(d15.d16)=0~/XCbeep~/XLNo discount rates entered.~temp~/XMmenu~

 "
 ¢  ¢(ÿ'/XCclearmsg~{home}{pgdn}{goto}a9~
ÿ'/XRÿ
'SETCOUNT: "
 ¢  ¢:ÿ'{goto}a10~/RNCpdnums~{bs}.{right}{end}{down}{left}~ÿ
'{goto}ncash~ "
 ¢  ¢,ÿ'{right}/RNCcashflow~{bs}.{end}{down}~%ÿ
'@count(b10.b310)~{edit}{calc}~ "
 ¢  ¢6ÿ'{right}/RNCaccum~{bs}.{left}{end}{down}{right}~ÿ
'{goto}ndisc~ "
¢  ¢ 2ÿ '/RUaccum~+{up}+{left}~/Cc10~accum~/RPaccum~%ÿ
'@count(d15.d315)~{edit}{calc}~ "
! ¢! ! ¢!ÿ!'{goto}d15~
ÿ
!'/XR "
" ¢" " ¢"§ÿ"'/XI@count(d15.d16)>1~/RNCdisrates~{bs}.{end}{down}~{right}/RNCnpvs~{bs}.{left}{end}{down}{right}~{right}/RNCdisfacts~{bs}.{left}{left}{end}{down}{right}{right}~ "
# ¢# # ¢#\ÿ#'/XI@count(d15.d16)=1~/RNCdisrates~{bs}~{right}/RNCnpvs~{bs}~{right}/RNCdisfacts~{bs}~ "
$ ¢$ $ ¢$Sÿ$'/RUdisfacts~(1+0.01*{left}{left})^(1/$b$7)~/Cf15~disfacts~/RPdisfacts~{left}
ÿ
$'ERASE: "
% ¢% % ¢%Dÿ%'/RUnpvs~@NPV({right}-1,$cashflow)*{right}~/Ce15~npvs~/RPnpvs~+ÿ
%'/RUc10.c310~/REc10.c310~/RPc10.c310~ "
& ¢& & ¢&ÿ&'{home}{calc}/XMmenu~+ÿ
&'/RUe15.f315~/REe15.f315~/RPe15.f315~ "
' ¢' ' ¢'
ÿ
''/XR "
( ¢( ( ¢(ÿ('RESULTS:ÿ('SCROLLCOL:ÿ ('SCROLL: "
) ¢) ) ¢)ÿ)'Cashflow
ÿ)'NPVÿ)'Quitÿ)'/WTHÿ )'Down ÿ
)'Upÿ)'Quit "
* ¢* * ¢*4ÿ*'Display cashflow figures and column headings.Jÿ*'Display discount rates and net present values with column headings.ÿ*'Return to main menu.ÿ*'/XMscroll~ÿ *'Scroll down one screen.ÿ
*'Scroll up one screen.ÿ*'Return to results menu. "
+ ¢+ + ¢+.ÿ+'{home}{pgdn}{goto}a7~{down}{down}{down}>ÿ+'{home}{pgdn}{goto}a13~{right}{right}{right}{down}{down}
ÿ+'{home}
ÿ +'{pgdn}
ÿ
+'{pgup}ÿ+'/WTC "
, ¢, , ¢,*ÿ,'/XI@count(b10.b27)>17~/XGscrollcol~*ÿ,'/XI@count(d15.d33)>18~/XGscrollcol~ÿ,'/XMmenu~ÿ ,'/XMscroll~ÿ
,'/XMscroll~ÿ,'/XMresults~ "
- ¢- - ¢-ÿ-'/XMresults~ÿ-'/XMresults~ "
. ¢. . ¢. "
/ ¢/ / ¢/
ÿ/'GRAPH:ÿ /'SETSKIP: "
0 ¢0 0 ¢0ÿ0'Cashflow
ÿ0'NPVÿ0'Typeÿ 0'Optionsÿ
0'Quit ÿ 0'/GOSS "
1 ¢1 1 ¢19ÿ1'Display Graph of cashflow and cumulative cashflow.+ÿ1'Display graph of Net Present Values.ÿ1'Set type of graph..ÿ 1'Set color or monochrome display option.ÿ
1'Return to main menu. 1'1 "
2 ¢2 2 ¢2"ÿ2'/GXpdnums~Acashflow~Baccum~ÿ2'/GXdisrates~Anpvs~RBQÿ2'/XMgraphtype~ÿ 2'/XMgraphopt~ÿ
2'/XMmenu~
ÿ 2'~QQ/XR "
3 ¢3 3 ¢3.ÿ3'OLA{esc}Cash Flow~LB{esc}Cum Cash Flow~!ÿ3'OLA{esc}Net Present Value~ "
4 ¢4 4 ¢4?ÿ4'TF{esc}CASH FLOW VALUES~TX{esc}Period Number~TY{esc}$~QQDÿ4'TF{esc}NET PRESENT VALUE~TX{esc}Discount Rate~TY{esc}NPV $~QQ "
5 ¢5 5 ¢5Pÿ5'{goto}setskip~{down}@MAX(1,@INT(@COUNT(cashflow)/5)){calc}~{edit}{home}'~Pÿ5'{goto}setskip~{down}@MAX(1,@INT(@COUNT(disrates)/5)){calc}~{edit}{home}'~ "
6 ¢6 6 ¢6ÿ6'/XCsetskip~ÿ6'/XCsetskip~ "
7 ¢7 7 ¢7ÿ7'/GVQÿ7'/GVQ "
8 ¢8 8 ¢8ÿ8'/XMgraph~ÿ8'/XMgraph~ÿ 8'GRAPHTYPE: "
9 ¢9 9 ¢9ÿ 9'Line
ÿ
9'Barÿ9'Scatter "
: ¢: : ¢:ÿ:'GRAPHOPT:ÿ :'Display a line graph.ÿ
:'Display a bar chart.ÿ:'Display a scatter chart. "
; ¢; ; ¢; ÿ;'Color
ÿ;'B&Wÿ ;'/GTLOFGBQQVQ
ÿ
;'/GTBVQÿ;'/GTLOFGSQQVQ "
< ¢< < ¢<ÿ<'Display graph in color.#ÿ<'Display graph in monochrome.ÿ <'/XMgraph~ÿ
<'/XMgraph~ÿ<'/XMgraph~ "
= ¢= = ¢=ÿ='/GOCQVQÿ='/GOBQVQ "
> ¢> > ¢>ÿ>'/XMgraph~ÿ>'/XMgraph~ "
? ¢? ? ¢? "
@ ¢@ @ ¢@
ÿ@'PRINT: "
A ¢A A ¢A-ÿA'{home}/RUcopyright_p1~/REcopyright_p1~ "
B ¢B B ¢B)ÿB'/XLAlign Paper, Press Enter.~temp~ "
C ¢C C ¢C*ÿC'{goto}b10~{end}{down}{right}{right} "
D ¢D D ¢DÿD'/RNCdummy~{bs}.{down}~ "
E ¢E E ¢E%ÿE'/XI@count(dummy)>1~{end}{down} "
F ¢F F ¢FÿF'{right} "
G ¢G G ¢G8ÿG'/PPR{bs}.{left}{left}{left}{left}{end}{up}{down}~ "
H ¢H H ¢HÿH'OBRa1.a9~Q "
I ¢I I ¢I
ÿI'GPQ ¢J6ÿJ'{home}/Ccopyright~copyright_p1~/RPcopyright_p1~ ¢KÿK'/XMmenu~ ¢L ¢M ¢N