Category : Lotus and other Spreadsheets
Archive   : LTSTIPS3.ZIP
Filename : LOTUSINV.WKS


'/


ÿ


ÿ"
H\A'ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0
ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿ ÿÿÿÿÿÿÿÿ$
%ò&ò'((
LB)
'*ÿÿÿÿÿÿÿÿ-µ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
#ÿ'Return On Investment Sectionÿ'Initial Cash Outlay
ÿ
Èÿ

'Period 01ÿ
'Period 02ÿ
'Period 03ÿ
'Period 04ÿ
'Period 05ÿ
'Period 06ÿ
'Period 07ÿ
'Period 08ÿ
'Period 09ÿ

'Period 10ÿ'Sum Of Cash Outflows
ÿ

ÿ
ÿ
ÿ
ÿ
ÿ
ÿ
ÿ
ÿ 
ÿ
ÿ 'Sum Of Cash Inflows
ÿ

ÿ
ÿ d
ÿ 2
ÿ 2
ÿ F
ÿ Z
ÿ d
ÿ <
ÿ
ÿ

' --------ÿ
' --------ÿ
' --------ÿ
' --------ÿ
' --------ÿ
' --------ÿ
' --------ÿ
' --------ÿ
' --------ÿ

' --------ÿ'Net Cash Flow!ÿ
ÀlÀ
€þ¿
€ý¿

€ú¿
ÿ4À
€þ¿
€ý¿
ÿY@
€þ¿
€ý¿
ÿI@
€þ¿
€ý¿
ÿI@
€þ¿
€ý¿
ÿ€Q@
€þ¿
€ý¿
ÿ€V@
€þ¿
€ý¿
ÿY@
€þ¿
€ý¿
ÿ N@
€þ¿
€ý¿
ÿ
>@
€þ¿
€ý¿
ÿ'Cumulative Cash Flowÿ
ÀlÀ
€ÿ¿ÿ@oÀ
ÿ¿€
€ÿ¿ ÿÀbÀ
ÿ¿€
€ÿ¿ ÿYÀ
ÿ¿€
€ÿ¿ ÿIÀ
ÿ¿€
€ÿ¿ ÿ4@
ÿ¿€
€ÿ¿ ÿ€[@
ÿ¿€
€ÿ¿ ÿ@j@
ÿ¿€
€ÿ¿ ÿ àp@
ÿ¿€
€ÿ¿ ÿ
Àr@
ÿ¿€
€ÿ¿ "ÿ'Estimated Rate of Return(%)
²
333333Ó?%ÿ'Calculated Rate of Return(IRR)±
ӁÚjÉëÆ?
÷¿ÿ¿÷¿ü¿€ü¿Y=ÿ'/WGC10~/WCS30~/WGFC2~{GOTO}B18~/RFP~~{GOTO}K19~/RFP1~~.ÿ
'Set column widths and worksheet formats-ÿ'{GOTO}F7~Return On Investment Section~ ÿ
'Title.ÿ'{GOTO}A9~Initial Cash Outlay{RIGHT}{?}~ ÿ
'Input initial cash outlay«ÿ '{GOTO}B11~Period 01{RIGHT}Period 02{RIGHT}Period 03{RIGHT}Period 04{RIGHT}Period 05{RIGHT}Period 06{RIGHT}Period 07{RIGHT}Period 08{RIGHT}Period 09{RIGHT}Period 10~ÿ
'Column headings?ÿ!'{GOTO}A12~Sum Of Cash Outflows{RIGHT}{?}~/Cb12~c12..k12~Yÿ
!'Input the row/column where the total cash inflows from all investments are located>ÿ"'{GOTO}A13~Sum Of Cash Inflows{RIGHT}{?}~/Cb13~c13..k13~Zÿ
"'Input the row/column where the total cash outflows from all investments are located+ÿ#'{GOTO}B14~ --------~/Cb14~c14..k14~ÿ
#'UnderscoreOÿ$'{GOTO}A15~Net Cash Flow{RIGHT}+B13-B12-B9{RIGHT}+C13-C12~/Cc15~d15..k15~ ÿ
$'Compute the net cash flowOÿ%'{GOTO}A16~Cumulative Cash Flow{RIGHT}+B15{RIGHT}+B16+C15~/Cc16~d16..k16~#ÿ
%'Compute cumulative cash flow7ÿ&'{GOTO}A18~Estimated Rate of Return(%){RIGHT}.30~]ÿ
&'Input best estimate of what the computed rate of return will be (30% is default value)Mÿ''{GOTO}A19~Calculated Rate of Return(IRR)~{GOTO}K19~@IRR(B18,B15..K15)~ÿ
''Compute the real IRR