Basic Invoice Self Employed

Document Sample
Basic Invoice Self Employed Powered By Docstoc
					Excel Presentation Files
Provided by:
Jim Colville, CPA
858-682-9668

Additional files and updates at:

www.JimColvilleCPA.com

        This file shows the VLOOKUP function used in various scenarios and
        provides basic instruction on the command.

        See the Excel Solutions section of the website for full length / in-depth instruction.

        http://www.JimColvilleCPA.com
       A         B          C        D       E      F       G            H
 1 VLookup
 2
 3
 4                      Commission Table                 Cell D15:
                                                  =VLOOKUP(D14,CommTable,
 5                         250.00    0.00%
                                                             2)
 6                         500.00    2.50%
 7                       1,000.00    5.00%
 8                       2,500.00   10.00%                Cell D16:
 9                       5,000.00   12.50%                =D14*D15
10                       7,500.00   15.00%
11                      10,000.00   20.00%
                                                        The Range Name
12
                                                          CommTable
13                                                          C5:D11
14         Sales Amount           1,234.00
15         Commission Rate           5.00%
16         Commission Amount         61.70
17
18
19
20
21
22
23
24
25
26
27
28
29
30




                     99b4ecaf-435c-4d2e-b639-21761f8adcea.xls
       A           B           C          D          E           F
 1 VLookup, Cash Bonus
 2
 3                         Commission Table-Cash Bonus
 4                                       Regular COD/Cash
 5                             250.00       0.00%   0.50%
 6                             500.00       2.50%   3.00%
 7                          1,000.00        5.00%   5.50%
 8                          2,500.00       10.00%  10.50%
 9                          5,000.00       12.50%  13.00%
10                          7,500.00       15.00%  15.50%
11                         10,000.00       20.00%  20.50%
12
13
14         Sales Amount                 1,234.00
15         Commission rate                  5.50%
16         Commission Amount                67.87
17         Enter 0 for terms, 1 for Cash    1
18
19
20
21
                                     Cell D15:
22                =VLOOKUP(D14,CommTableCash,1+D16+
23                                       1)
24
25
26                              The Range Name
27                              CommTableCash
28                                   C5:E11
29
30
                   This example expands the basic feature. The




        99b4ecaf-435c-4d2e-b639-21761f8adcea.xls
        A          B          C         D         E         F         G        H
 1
 2                                 Sales Log
 3
 4   Customer              Invoice   Invoice Amount of Commission Commission
 5   Name       SalesRep   Number      Date    Invoice    Rate      Amount
 6   Jones      Mary         345-67 8/23/1994 1,234.00    5.00%      61.70
 7   Brown      Harry        345-7658/26/1994 4,562.98   10.00%     456.30
 8   Harrison   Sally        435-87 8/21/1994 26,478.90  20.00% 5,295.78
 9   Maxwell    Margo        435-6758/13/1994 1,456.00    5.00%      72.80
10   Mitchell   Bill         645-54 8/18/1994 8,543.00   15.00% 1,281.45
11
12
13
14
15
16
17
18
19
20
21
                                  Cell F6:
22                         =VLOOKUP(E6,CommTable,2
23                                   )
24
25
26




                  99b4ecaf-435c-4d2e-b639-21761f8adcea.xls
     A                       B                         C           D     E       F
1        Tax Return
2
3        Salary                                $ 30,000
4        Interest                                   456
5        Dividends                                  479
6        Self-Employed Income (loss)                  0
7        Partnership Income (loss)                 (838)
8        Other Income                             1,000
 9         GROSS INCOME                            31,097
10
11       IRA Contribution                              2,000
12       Moving expenses                                   0
13       Alimony Payments                                  0
14        Total deductions from gross income           2,000
15        ADJUSTED GROSS INCOME                    29,097
16
17       Total excess itemized deductions          12,097
18       Total exemptions                           4,000
19        TAXABLE INCOME                       $ 13,000
20
21
22
23        TAX                                  $       1,261
24
25       Marginal tax rate                         16%
26
27
28
29
30
31           TAXABLE INCOME                        $ 13,000            =C15-C17-C18
32
33           TAX                                   $       1,261       =TaxLookedUp
34
35




                      99b4ecaf-435c-4d2e-b639-21761f8adcea.xls
           A             B          C          D          E          F         G   H
1                                         Tax Table
2                              Married Individuals-Schedule Y
3
4                            Joint Returns and Surviving Spouses
5
                     Taxable                             of the
 6                    Income                 % on       Amount
 7                      Over       Pay      Excess       Over         Tax
 8                           0          0          0%           0       0.00
 9                       3,400          0        11%       3,400 1,056.00
10                       5,500       231         12%       5,500 1,131.00
11                       7,600       483         14%       7,600 1,239.00
12                     11,900      1,085         16%     11,900 1,261.00
13                     16,000      1,741         18%     16,000 1,201.00
14                     20,200      2,497         22%     20,200      913.00
15                     24,600      3,465         25%     24,600      565.00
16                     29,900      4,790         28%     29,900        58.00
17                     35,200      6,274         33%     35,200 (1,052.00)
18                     45,800      9,772         38%     45,800 (2,692.00)
19                     60,000     15,168         42%     60,000 (4,572.00)
20                     85,600     25,920         45%     85,600 (6,750.00)
21                    109,400     36,630         49% 109,400 ########
22                    162,400     62,600         50% 162,400 ########
23
24      Taxable Income            13,000
25
26            Tax                  1,261
27
28      Marginal tax rate         16%
29
30
31
32                                           Cell C24
33                                        =TaxableInc
34
35
36                                            Cell C26
                                    =VLOOKUP(D38,TaxTable,
37
                                                  5)
38
39
40
41
42 Tax Rates - This is an educational exercise to learn Excel features.




                     99b4ecaf-435c-4d2e-b639-21761f8adcea.xls

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:122
posted:1/6/2011
language:English
pages:6
Description: Basic Invoice Self Employed document sample