home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Glitch Apple Disk Collection
/
2014.glitch.apple.collection.zip
/
indexed
/
VISICALC.DSK
/
CARLOAN80.VC.txt
< prev
next >
Wrap
Text File
|
2014-09-09
|
5KB
|
203 lines
>BJ81:" All rights reserved.
>BJ80:" Software Arts, Inc.
>BJ79:" Copyright (c) 1984
>BJ77:" ** END **
>BJ75:"using VisiCalc.
>BJ74:"for more information on
>BJ73:"included reference material
>BJ72:"additional months.) See the
>BJ71:"expand the table to include
>BJ70:"needs. (For example, you can
>BJ69:"model to suit your specific
>BJ68:"You can easily change this
>BJ67:"a typical use of VisiCalc.
>BJ66:" This car loan model shows
>BJ65:"table comes into view.
>BJ64:"key until the rest of the
>BJ63:"then press the down arrow
>BJ62:"ing the semicolon key (;),
>BJ61:"to the left window by press-
>BJ60:"table, first move the cursor
>BJ59:"the loan. To see the entire
>BJ58:"to date for each month of
>BJ57:"paid and outstanding balance
>BJ56:"table that shows the amount
>BJ55:" This model also includes a
>BJ54:"cell D10, will be $229.26.
>BJ53:"monthly payments, shown in
>BJ52:"the car loan is $4875. The
>BJ51:"can see that the amount of
>BJ50:" By looking at cell D9, you
>BJ48:"Interest rate: enter 11.9 ->
>BJ47:/FR"Term of loan: enter 24 ->
>BJ46:/FR"Down payment: enter 4500 ->
>BJ44:"input data as shown below.
>BJ43:"Now enter the rest of the
>BJ42:"D2 in the window at left.
>BJ41:"entered also appears in cell
>BJ40:" Notice that the value you
>E39:"tions
>D39:/F$"o instruc
>C39:/F$"return t
>B39:"ss ; to
>A39:" Pre
>BJ38:/FR"enter: 9375 ->
>D38:/F$+D37-D10
>C38:/F$+D10*B38
>B38:@IF(D4=0,0,B37+1)
>BJ37:"value.
>D37:/F$+D36-D10
>C37:/F$+D10*B37
>B37:@IF(D4=0,0,B36+1)
>BJ36:"screen as you enter the
>D36:/F$+D35-D10
>C36:/F$+D10*B36
>B36:@IF(D4=0,0,B35+1)
>BJ35:"the left window of your
>D35:/F$+D34-D10
>C35:/F$+D10*B35
>B35:@IF(D4=0,0,B34+1)
>BJ34:"car as shown below. Watch
>D34:/F$+D33-D10
>C34:/F$+D10*B34
>B34:@IF(D4=0,0,B33+1)
>BJ33:"and enter the price of the
>D33:/F$+D32-D10
>C33:/F$+D10*B33
>B33:@IF(D4=0,0,B32+1)
>BJ32:"using the right arrow key
>D32:/F$+D31-D10
>C32:/F$+D10*B32
>B32:@IF(D4=0,0,B31+1)
>BJ31:"to the column at right by
>D31:/F$+D30-D10
>C31:/F$+D10*B31
>B31:@IF(D4=0,0,B30+1)
>BJ30:"first move the cursor over
>D30:/F$+D29-D10
>C30:/F$+D10*B30
>B30:@IF(D4=0,0,B29+1)
>BJ29:" To solve this problem,
>D29:/F$+D28-D10
>C29:/F$+D10*B29
>B29:@IF(D4=0,0,B28+1)
>BJ28:"ment be?
>D28:/F$+D27-D10
>C28:/F$+D10*B28
>B28:@IF(D4=0,0,B27+1)
>BJ27:"much will each monthly pay-
>D27:/F$+D26-D10
>C27:/F$+D10*B27
>B27:@IF(D4=0,0,B26+1)
>BJ26:"terest rate of 11.9%. How
>D26:/F$+D25-D10
>C26:/F$+D10*B26
>B26:@IF(D4=0,0,B25+1)
>BJ25:"loan is 24 months at an in-
>D25:/F$+D24-D10
>C25:/F$+D10*B25
>B25:@IF(D4=0,0,B24+1)
>BJ24:"ing $9375. The term of the
>D24:/F$+D23-D10
>C24:/F$+D10*B24
>B24:@IF(D4=0,0,B23+1)
>BJ23:"$4500 is made on a car cost-
>D23:/F$+D22-D10
>C23:/F$+D10*B23
>B23:@IF(D4=0,0,B22+1)
>BJ22:" Example: A down payment of
>D22:/F$+D21-D10
>C22:/F$+D10*B22
>B22:@IF(D4=0,0,B21+1)
>D21:/F$+D20-D10
>C21:/F$+D10*B21
>B21:@IF(D4=0,0,B20+1)
>BJ20:"to see more text.
>D20:/F$+D19-D10
>C20:/F$+D10*B20
>B20:@IF(D4=0,0,B19+1)
>BJ19:" Press the down arrow key
>D19:/F$+D18-D10
>C19:/F$+D10*B19
>B19:@IF(D4=0,0,B18+1)
>BJ18:"umn D in the left window.
>D18:/F$+D17-D10
>C18:/F$+D10*B18
>B18:@IF(D4=0,0,B17+1)
>BJ17:"display these values in col-
>D17:/F$+D16-D10
>C17:/F$+D10*B17
>B17:@IF(D4=0,0,B16+1)
>BJ16:"model will automatically
>D16:/F$+D15-D10
>C16:/F$+D10*B16
>B16:@IF(D4=0,0,B15+1)
>BJ15:"the right of this text. The
>D15:/F$+D11-D10
>C15:/F$+D10*B15
>B15:@IF(D4=0,0,1)
>BJ14:"ter values in the column to
>D14:/FR"BALANCE
>C14:/FR"PAID
>B14:/FR"MONTH
>BJ13:"sample problem, you will en-
>BJ12:"the car loan. To solve the
>D12:/F$@IF(D5=0,0,D11-D9)
>C12:/FR"t paid =
>B12:"Total in
>BJ11:"used in the calculation of
>D11:/F$+D10*D4
>C11:/FR"paid =
>B11:"Total $
>BJ10:"screen shows variables to be
>D10:/F$@IF(D5=0,0,D9*(G5/(1-((1+G5)^-D4))
>C10:/FR"paym't =
>B10:"Monthly
>BJ9:" The left window of your
>D9:/F$@IF(D3=0,0,D2-D3)
>C9:/FR"f loan =
>B9:"Amount o
>BJ8:"a sample problem.
>D8:@IF(D2=0,0,+D3/D2*100)
>C8:/FR"ment % =
>B8:"Down pay
>BJ7:"these instructions to solve
>BJ6:"ments of a car loan. Follow
>BJ5:"to compute the monthly pay-
>G5:+D5/100/12
>F5:/FR"%/MO =
>D5:@IF(@ISERROR(BK48),0,BK48)
>C5:"t rate =
>B5:/FR"Interes
>BJ4:"how VisiCalc (R) can be used
>D4:@IF(@ISERROR(BK47),0,BK47)
>C4:" loan =
>B4:/FR"Term of
>BJ3:" This model demonstrates
>D3:/F$@IF(@ISERROR(BK46),0,BK46)
>C3:"yment =
>B3:/FR"Down pa
>BJ2:" ** CAR LOAN **
>D2:/F$@IF(@ISERROR(BK38),0,BK38)
>C2:"f car =
>B2:/FR"Price o
>A1:/GCC4
>B1:/GCC8
>C1:/GCC8
>D1:/GCC9
>E1:/GCC5
>F1:/GCC9
>G1:/GCC5
>BI1:/GCC4
>BJ1:/GCC28
>BK1:/GCC8
/W1
/GOR
/GRA
/GPL
/XV37
/GC9
/X-/X>A1:>A1:;/GC8
/X>BI1:>BI1:/TV
/X-/X>BI1:>BJ2: