Net Present Value

Gallery

Source Code

    2 REM "NET PRES V"
    4 PRINT " VARIABLES: ": PRINT 
    5 PRINT "B   TOTAL DISCOUNTED PROFITS"
    6 PRINT "B(I)  PROFIT FOR PERIOD I"
    7 PRINT "C(I)   DISCOUNTED PROFIT FOR PER       I"
    8 PRINT "C   INITIAL COST OF PROJECT--       line 900"
    9 PRINT "D(I)   EXPENSES FOR PERIOD I--         line--920"
   10 PRINT "DD   TOTAL DISCOUNTED EXPENSES"
   11 PRINT "E(I)   DISCOUNTED EXP FOR PER I"
   12 PRINT "R(I)   REVENUES FOR PERIOD I--         line 910"
   13 PRINT "RO RESIDUAL VALUE OF PROJECT--         line 930"
   14 PRINT "S(I)   DISCOUNTED REV FOR PER I"
   15 PRINT "T   DISCOUNT RATE--                 line 930"
   16 PRINT "V   EST DURATION OF PROJECT--       line 900"
   17 PRINT "VR   DISCOUNTED RESIDUAL VALUE"
   18 PAUSE 340: CLS 
   19 DEF FN A(X)=INT (100*X+.5)/100
   20 PRINT : PRINT 
   30 PRINT " NET PRESENT VALUE AND"
   40 PRINT "INTERNAL RATE OF RETURN"
   45 PRINT "-------------------------------"
   50 PRINT : PRINT 
   55 READ C,V
   60 PRINT "INITIAL COST OF THE INVESTMENT? ";C
   70 PRINT 
   80 PRINT "ESTIMATED DURATION OF PROJECT? ";V
   90 DIM R(V): DIM D(V): DIM B(V): DIM C(V): DIM E(V): DIM S(V)
  100 PRINT 
  110 PRINT "PERIODIC INCOME FROM PROJECT:"
  120 FOR I=1 TO V
  125 READ R(I)
  130 PRINT "--PERIOD #";I;TAB ( 15);R(I)
  150 NEXT I: PRINT 
  160 PRINT "EXPENSES FORECAST:"
  170 FOR I=1 TO V
  175 READ D(I)
  180 PRINT "--PERIOD #";I;TAB ( 15);D(I)
  200 NEXT I: PRINT 
  205 READ RO,T
  210 PRINT "RESIDUAL VALUE OF THE INVESTMENT? ";RO
  220 PRINT 
  230 PRINT "RATE OF RETURN ON INVESTMENT? (%) ";T
  240 REM     PRINT OUTPUT
  250 PRINT : PRINT 
  260 PRINT "FORECASTS:"
  270 GO SUB 850
  280 GO SUB 870
  290 GO SUB 850
  300 FOR I=1 TO V
  310 LET B(I)=R(I)-D(I)
  320 PRINT TAB ( 2);I;TAB ( 8);R(I);TAB ( 15);D(I);TAB 22;B(I)
  330 NEXT I
  340 GO SUB 850
  350 PRINT : PRINT : PRINT 
  360 REM  PRESENT VALUE
  370 PRINT "PRESENT VALUE: "
  380 GO SUB 850
  390 GO SUB 870
  395 LET P$="(PRES VAL)"
  400 PRINT TAB ( 2);P$;TAB ( 12);P$;TAB ( 22);P$
  410 GO SUB 850
  420 LET B=0: LET RR=0: LET DD=0
  430 FOR I=1 TO V
  440 LET S(I)=R(I)*(1+T/100)^(-I)
  450 LET E(I)=D(I)*(1+T/100)^-I
  460 LET C(I)=S(I)-E(I)
  470 LET B=B+C(I)
  480 LET RR=RR+S(I)
  490 LET DD=DD+E(I)
  500 PRINT TAB ( 2);FN A(I);TAB ( 7);FN A(S(I));
  505 PRINT TAB ( 15);FN A(E(I));TAB ( 24);FN A(C(I))
  510 NEXT I
  520 GO SUB 850
  530 LET VR=RO*(1+T/100)^(-V-1)
  540 PRINT "PRESENT VALUE OF RESIDUAL = ";
  550 PRINT TAB ( 25);FN A(VR)
  560 GO SUB 850
  570 REM  PRINT OUTPUT
  580 PRINT : PRINT 
  590 PRINT "RESULTS OF THE ANALYSIS:"
  595 PRINT 
  600 GO SUB 850
  610 PRINT "NET PRESENT VALUE OF CASH-FLOW"
  620 PRINT "(INCLUDING RESIDUAL VALUE)"
  630 PRINT TAB ( 15);" = ";TAB ( 25);FN A(B+VR-C)
  640 GO SUB 850
  650 PRINT "PROFITABILITY INDEX = ";
  660 PRINT TAB ( 25);INT (10000*((RR+VR)/(DD+C))+.5)/100;"%"
  670 REM CALCULATE INTERNAL RATEOF RETIURN
  680 FOR O=0 TO 100 STEP 0.5
  690 LET X=0
  700 FOR I=1 TO V
  710 LET X=X+B(I)*(1+O/100)^-I
  720 NEXT I
  730 LET X=X+RO*(1+O/100)^(-V-1)-C
  740 IF X<=O THEN GO TO 760
  750 NEXT O
  760 GO SUB 850
  770 PRINT "INTERNAL RATE OF RETURN = ";
  780 PRINT TAB (31);FN A(O);"%"
  790 GO SUB 850
  800 PRINT : PRINT 
  810 PRINT "PERFORM SENSITIVITY ANALYSIS BY "
  820 INPUT "MODIFYING THE RATE OF RETURN?(Y/N) ";C$
  830 IF C$="Y" THEN PRINT "Input a new rate": INPUT T: GO TO 220
  835 GO TO 840
  840 STOP 
  850 PRINT "-------------------------------"
  860 RETURN 
  870 PRINT "PER EXPECTED ESTIMATED EXPECTED"
  880 PRINT "    REVENUES EXPENSES  PROFITS"
  890 RETURN 
  900 DATA 18000,5
  910 DATA 5000,5500,5500,5000,5000
  920 DATA 100,1000,1200,1500,1500
  930 DATA 8000,12