home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Glitch Apple Disk Collection
/
2014.glitch.apple.collection.zip
/
indexed
/
VISICALC.DSK
/
AVERAGE.VC.txt
next >
Wrap
Text File
|
2014-09-09
|
5KB
|
243 lines
>BJ90:" All rights reserved.
>BJ89:" Software Arts, Inc.
>BJ88:" Copyright (c) 1984
>BJ86:" ** END **
>BJ84:"tion on using VisiCalc.
>BJ83:"material for more informa-
>BJ82:"See the included reference
>BJ81:"suit your specific needs.
>BJ80:"easily change this model to
>BJ79:"use of VisiCalc. You can
>BJ78:"model demonstrates a typical
>BJ77:" This income averaging
>BJ76:"schedule comes into view.
>BJ75:"right arrow key until the
>BJ74:"key (;), then press the
>BJ73:"by pressing the semicolon
>BJ72:"cursor to the upper window
>BJ71:"used in this model, move the
>BJ70:"To see the schedule as it is
>BK69:".
>BJ69:"model off the visible screen
>BJ68:"schedule is included in this
>BJ67:"returns filed jointly. The
>BJ66:"standard rate schedule for
>BJ65:"were computed using the
>BJ64:"the tax by income averaging
>BJ63:" Both the regular tax and
>BJ62:"the amount of tax you owe.
>BJ61:"income averaging will reduce
>BJ60:"of $75. You now know that
>BJ59:"that this is a tax savings
>BJ58:"is $10859. Cell B13 shows
>BJ57:"computed by income averaging
>BJ56:"you can see that the tax
>BJ55:" By looking at cell B12,
>BJ53:" 1982 income: 39900 ->
>BJ52:" 1981 income: 36000 ->
>BJ51:" 1980 exemptions: 2 ->
>BJ50:" 1980 income: 34800 ->
>BJ49:" 1979 exemptions: 2 ->
>BJ48:" 1979 income: 31500 ->
>BJ46:"input data as shown below.
>BJ45:" Now enter the rest of the
>BJ44:"B11, to be $10934.
>BJ43:"regular tax, shown in cell
>BJ42:"automatically computed the
>BJ41:" Notice that the model
>BJ39:/FR"Enter: 47300 ->
>BJ37:"ter the indicated value.
>BJ36:"the upper window as you en-
>BJ35:"1983 as shown below. Watch
>BJ34:"ter the taxable income for
>BJ33:"the right arrow key and en-
>BJ32:"column at right by pressing
>BJ31:"first move the cursor to the
>BJ30:" To solve this problem,
>BJ29:"the amount of tax you owe.
>BJ28:"come averaging will reduce
>BJ27:"You would like to see if in-
>BJ26:"income of $47300 in 1983.
>BJ25:"spouse had a joint taxable
>BJ24:" Example: You and your
>BJ23:"ues in column B above.
>BJ22:"matically display these val-
>BJ21:"text. The model will auto-
>BJ20:"column to the right of this
>BJ19:"1979 through 1983 in the
>BJ18:"taxable income for the years
>BJ17:"problem, you will enter the
>BJ16:"tion. To solve the sample
>I16:.5
>H16:109400
>G16:109400
>F16:109400
>E16:38702
>D16:109400
>BJ15:"be used in the tax computa-
>I15:.48
>H15:85600
>G15:85600
>F15:85600
>E15:27278
>D15:85600
>BJ14:"screen contains variables to
>I14:.44
>H14:60000
>G14:60000
>F14:60000
>E14:16014
>D14:60000
>BJ13:" The upper window of your
>I13:.4
>H13:45800
>G13:45800
>F13:45800
>E13:10334
>D13:45800
>B13:/F$+B11-B12
>A13:/FR" Tax savings =
>BJ12:"solve a sample problem.
>K12:"ions.)
>J12:" to instuct
>I12:.35
>H12:35200
>G12:35200
>F12:35200
>E12:6624
>D12:35200
>B12:/F$@IF(B10<3000,@NA,M11+(4*(M11-N11)))
>A12:/FR"Tax by averaging =
>BJ11:"Follow these instructions to
>N11:+N8+(N10*(K7-N9))
>M11:+M8+(M10*(.2*K8+K7-M9))
>L11:/FR"TAX
>K11:" return
>J11:" (Press ; to
>I11:.3
>H11:29900
>G11:29900
>F11:29900
>E11:5034
>D11:29900
>B11:/F$+O8+(O10*(B8-O9))
>A11:/FR"Regular tax =
>BJ10:"ly using income averaging.
>O10:@LOOKUP(B8,H3...H16)
>N10:@LOOKUP(K7,H3...H16)
>M10:@LOOKUP(.2*K8+K7,H3...H16)
>L10:/FR"BRACKET
>I10:.26
>H10:24600
>G10:24600
>F10:24600
>E10:3656
>D10:24600
>B10:/F$+K8
>A10:/FR"Averageable income =
>BJ9:"married couple filing joint-
>O9:@LOOKUP(B8,F3...F16)
>N9:@LOOKUP(K7,F3...F16)
>M9:@LOOKUP(.2*K8+K7,F3...F16)
>L9:/FR"BASE INC
>I9:.23
>H9:20200
>G9:20200
>F9:20200
>E9:2644
>D9:20200
>BJ8:"to compute the tax owed by a
>O8:@LOOKUP(B8,D3...D16)
>N8:@LOOKUP(K7,D3...D16)
>M8:@LOOKUP(.2*K8+K7,D3...D16)
>L8:/FR"BASE TAX
>K8:+B8-K7
>J8:/FR"Ave.Inc. =
>I8:.19
>H8:16000
>G8:16000
>F8:16000
>E8:1846
>D8:16000
>B8:/F$@IF(@ISERROR(BK39),0,BK39)
>A8:/FR"1983 Taxable income =
>BJ7:"how VisiCalc (R) can be used
>O7:/FR"1983
>N7:/FR"LINE 26
>M7:/FR"LINE 24
>K7:.3*(B2+B4+B6+B7-(1000*(B3+B5)))
>J7:/FR"Total =
>I7:.17
>H7:11900
>G7:11900
>F7:11900
>E7:1149
>D7:11900
>B7:/F$@IF(@ISERROR(BK53),0,BK53)
>A7:/FR"1982 Taxable income =
>BJ6:" This model demonstrates
>I6:.15
>H6:7600
>G6:7600
>F6:7600
>E6:504
>D6:7600
>B6:/F$@IF(@ISERROR(BK52),0,BK52)
>A6:/FR"1981 Taxable income =
>BJ5:"to see more text.
>I5:.13
>H5:5500
>G5:5500
>F5:5500
>E5:231
>D5:5500
>B5:@IF(@ISERROR(BK51),0,BK51)
>A5:/FR"# of exemptions =
>BJ4:" Press the down arrow key
>I4:.11
>H4:3400
>G4:3400
>F4:3400
>E4:0
>D4:3400
>B4:/F$@IF(@ISERROR(BK50),0,BK50)
>A4:/FR"1980 Taxable income =
>I3:0
>H3:0
>G3:0
>F3:0
>E3:0
>D3:0
>B3:@IF(@ISERROR(BK49),0,BK49)
>A3:/FR"# of exemptions =
>BJ2:" ** INCOME AVERAGING **
>I2:/FR"BRACKET
>H2:/FR"INCOME
>G2:/FR"BASE
>F2:/FR"INCOME
>E2:/FR"TAX
>D2:/FR"INCOME
>B2:/F$@IF(@ISERROR(BK48),0,BK48)
>A2:/FR"1979 Taxable income =
>A1:/GCC23
>B1:/GCC11
>C1:/GCC6
>D1:/GCC9
>E1:/GCC8
>F1:/GCC9
>G1:/GCC10
>J1:/GCC12
>K1:/GCC7
>BI1:/GCC1
>BJ1:/GCC28
>BK1:/GCC8
/W1
/GOR
/GRA
/GPL
/XH14
/GC9
/X-/X>A1:>A1:;/GC9
/X>BI1:>BI1:/TV
/X-/X>BI1:>BJ2: