Receipts Detail by BudCrain

VIEWS: 31 PAGES: 3

									Sales Tax "Triple Flip" Revenue/Receivable Calculations
Cash Receipts Data
July 2004 to September 2005
                                                                                                                                                                                                                                                                   12 Months
                                        Source: State of California - Board of Equalization                                                                                                                                         Source:                       July to June
                                        "Statement of Tax Distribution"                                                                                                                                                             County ERAF Fund              Point of Sale

                                         Jul 04   Aug 04        Sep 04        Oct 04    Nov 04        Dec 04        Jan 05     Feb 05       Mar 05        Apr 05    May 05       Jun 05        Jul 05    Aug 05       Sep 05           Jan 05        May 05

A Statement Date                          7/12      8/9          9/15           10/8      11/8        12/14          1/7         2/x        38,434.00      4/12      5/10         6/16          7/12      8/9          9/16
B Cash Receipt Date                       7/21      8/18         9/24          10/20     11/18        12/24          1/19       2/17        38,441.00      4/20      5/18          6/x          7/20      8/17          9/x

    Settlement Period
C    (Vendor's reporting date to                                5-14 to                               8-13 to                              11-13 to                             2-12 to                               5-13 to
     State, not point of retail sale)                            8-12                                 11-12                                  2-11                                5-12                                  8-11

D    (Memo: corresponding                                       Apr to                                July to                               Sept to                              Jan to                               Apr to
     months of retail sales)                                    June                                   Aug                                   Dec                                  Mar                                  June

E Total Tax (100%)                                           2,759,401.24                          2,823,735.34                          2,665,315.59                         2,817,528.46                         2,955,459.03                                   11,262,038.42

F State deduction (25%)                                                   -                         (705,933.84)                          (666,328.90)                         (704,382.12)                         (738,864.76)                                  (2,815,509.62)

G (Subtotal) Local tax (75%)                -          -     2,759,401.24         -           -    2,117,801.50         -          -     1,998,986.69         -         -     2,113,146.34         -         -     2,216,594.27              -              -      8,446,528.80

H Prior Advances
  (Sum of three prior months)                                (2,430,500.00)                        (2,155,000.00)                        (1,945,400.00)                       (1,621,400.00)                       (2,000,600.00)                                 (7,722,400.00)

I   Adjusted cost of admin                                     (17,313.32)                           (17,687.68)                           (15,942.40)                          (18,855.24)                          (17,732.32)                                     (70,217.64)

J   Balance                                 -          -       311,587.92         -           -      (54,886.18)        -          -        37,644.29         -         -       472,891.10         -         -       198,261.95              -              -        653,911.16

    Current Advance
K    Board of Equalization              769,700   949,000      646,500.00     646,500   862,000      584,700.00     584,700    776,000     486,400.00     486,400   648,600     600,200.00     600,200   800,200     586,600.00
L    County ERAF                                                                                                                                                                                                                    1,187,780.50   1,187,780.50    2,375,561.00

M    (Vendor's reporting date to        6-12 to    7-15 to      8-13 to       9-15 to   10-15 to     11-13 to       12-14 to   1-14 to      2-12 to       3-12 to   4-14 to      5-13 to       6-14 to   7-15 to      8-12 to
     State, not point of retail sale)    7-14       8-12         9-14         10-14      11-12        12-13          1-13       2-11         3-11          4-13      5-12         6-13          7-14      8-11          9-x

N    (Memo: corresponding
     month of retail sales)               May       June         July          Aug       Sept          Oct            Nov       Dec          Jan           Feb       Mar          Apr           May       June         July

O Total payment (cash receipt)          769,700   949,000      958,087.92     646,500   862,000      529,813.82     584,700    776,000     524,044.29     486,400   648,600   1,073,091.10     600,200   800,200     784,861.95     1,187,780.50   1,187,780.50
Sales Tax "Triple Flip"
End of Year Receivable Analysis

Note: For Fund-Level Financial Statements
 "Modified Accrual"
                                                                                  Availability Assumption

                                                                        60 Days          90 Days        7-12 Months

       6/30/04 Receivable
             Board of Equalization:
                  7/04 Receipt/Advance                                 769,700.00        769,700.00           769,700.00
                  8/04 Receipt/Advance                                 949,000.00        949,000.00           949,000.00
                  9/04 Quarterly Settlement                                              311,587.92           311,587.92
                                                                      1,718,700.00     2,030,287.92         2,030,287.92


       6/30/05 Receivable
             Board of Equalization:
                  7/05 Receipt/Advance                                 600,200.00        600,200.00           600,200.00
                  8/05 Receipt/Advance                                 800,200.00        800,200.00           800,200.00
                  9/05 Quarterly Settlement                                              198,261.95           198,261.95
                                                                      1,400,400.00     1,598,661.95         1,598,661.95

            County ERAF Fund:
                Portion of Jan 06
                Advance for FY 04-05
                Point of Sale Revenue
                      Calculation:
                          100% - 12 months           11,262,038.42
                          25% - 12 months             2,815,509.61
                          Less County ERAF advance   (2,375,561.00)
                                                                                                              439,948.61
                                                                                                                     -
                                                                      1,400,400.00     1,598,661.95         2,038,610.56
Sales Tax "Triple Flip"
Annual Revenue Analysis

Note: For Fund-Level Financial Statements
 "Modified Accrual"
                                                                                    Availability Assumption

                                                                      60 Days              90 Days            7-12 Months

FY 04-05

           Board of Equalization - Monthly Advances
                      Month of Receipt       Month of Retail Sale
                      September              July                      646,500.00           646,500.00           646,500.00
                      October                August                    646,500.00           646,500.00           646,500.00
                      November               September                 862,000.00           862,000.00           862,000.00
                      December               October                   584,700.00           584,700.00           584,700.00
                      January                November                  584,700.00           584,700.00           584,700.00
                      February               December                  776,000.00           776,000.00           776,000.00
                      March                  January                   486,400.00           486,400.00           486,400.00
                      April                  February                  486,400.00           486,400.00           486,400.00
                      May                    March                     648,600.00           648,600.00           648,600.00
                      June                   April                     600,200.00           600,200.00           600,200.00
                      July                   May                       600,200.00           600,200.00           600,200.00
                      August                 June                      800,200.00           800,200.00           800,200.00
                                                                     7,722,400.00         7,722,400.00         7,722,400.00

           Board of Equalization - Quarterly Settlements
            Note: Net of Admin costs
                      September 2004                                  311,587.92                   -                   -
                      December                                        (54,886.18)           (54,886.18)         (54,886.18)
                      March                                            37,644.29             37,644.29           37,644.29
                      June                                            427,891.10            427,891.10          427,891.10
                      September 2005                                         -              198,261.95          198,261.95
                                                                      722,237.13            608,911.16          608,911.16

           County ERAF Fund
                    January 2005                                     1,187,780.50         1,187,780.50         1,187,780.50
                    May                                              1,187,780.50         1,187,780.50         1,187,780.50
                    January 2006
                     (Portion accrued at 6/05)                                -                    -             439,948.61
                                                                     2,375,561.00         2,375,561.00         2,815,509.61


           Annual Revenue                                           10,820,198.13        10,706,872.16        11,146,820.77

								
To top