jagomart
digital resources
picture1_Spreadsheet For Expenses 32872 | Financialreporttemplate2022


 164x       Filetype XLS       File size 0.49 MB       Source: www.igb.illinois.gov


File: Spreadsheet For Expenses 32872 | Financialreporttemplate2022
sheet 1 table of contents combo box detail in hidden columns vag illinois gaming board monthly financial information licensee name enter company name current reporting month year table of contents ...

icon picture XLS Filetype Excel XLS | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Table of Contents
















Combo Box detail in hidden columns V..AG

















ILLINOIS GAMING BOARD














Monthly Financial Information














































Licensee Name:
Enter Company name



















































Current Reporting Month:

Year:




























TABLE OF CONTENTS

























Go To Print










I. Income Statement……………………………………………………..

















II. Operating Expenses…………………………………………..

















III. Statement of Cash Flows………………………………………………

















IV. Balance Sheet…………………………………………………

















V. Statements of Changes in Stockholder's Equity or……………..


















Statements of Changes in Partner's Equity








































PRINT ALL STATEMENTS…………………………………………………





































































































































































































Sheet 2: Directions
Illinois Gaming Board





Directions for the Monthly Financial Report





File Conventions








(1) The Monthly Financial Report should reflect the results of activity for the month to be reported on



as entered to the Table of Contents.







(2) The report is to be received by the Gaming Board no later than the last gaming date of the following month.



Example: Financial activity from July 1 to July 31 is to be delivered no later than August 31.







(3) The preferred method of transmission is by the internet medium and should be sent to the following



internet address:






Cynthia.Thomas@illinois.gov











If anything needs to be sent via regular mail it can be sent to the following address:










Attn: Cindy Thomas




Illinois Gaming Board




801 South Seventh St., Suite 400-South




Springfield, IL 62703










(4) The worksheets are protected, therefore the cells are read-only except for fields requiring data entry.



Do not alter the structure or format of the file. Doing so may corrupt the macros or formulas.



If additional fields are required, contact Cindy Thomas for assistance.







(5) Line items requiring an explanation must describe activity for the current reporting month only.



Space has been provided for notes at the bottom of the financial statements or in fields



adjacent to the figures.







(6) The "Income Statement", "Operating Expenses" and "Cash Flows" schedules require cumulative figures



for the current year. The "Income Statement" schedule requires cumulative year-to-date figures



for the prior year as well. Worksheets to the right of the required data have been provided to assist



in the preparation of the schedules. These worksheets are required as part of the monthly submissions



to the Gaming Board.







(7) Figures entered are to be posted to the dollar and not truncated.



Example: $1,500,750 should be entered as such and not rounded to $1,501



Sheet 3: Income Statement

































































Results of Operations (Income Statement)

































THIS WORKSHEEK IS INTENDED TO ASSIST THE LICENSEE IN PREPARING THE REQUIRED YEAR-TO-DATE INFORMATION.












































THIS WORKSHEET IS REQUIRED TO BE COMPLETED IN ORDER TO REPORT THE YEAR-TO-DATE INFORMATION.






























IT IS NOT A REQUIREMENT FOR SUBMISSION TO COMPLETE THESE FIELDS.


































% Change
2022
2021
% Change




































































2022
2021
From Prior
YTD thru
YTD thru
From Prior

2022





























2021
































January
December
Month
January
January
Year






January
February
March
April
May
June
July
August
September
October
November
December
Total






January
February
March
April
May
June
July
August
September
October
November
December
Total
Revenues
















Revenues






























Revenues





























Casino Operations
















Casino Operations






























Casino Operations





























Table Games………………………………………………………….

0
0

0
0




Table Games………………………………………………………….

0
0
0
0
0
0
0
0
0
0
0
0
0



Table Games………………………………………………………….

0
0
0
0
0
0
0
0
0
0
0
0
0


Electronic Gaming Devices……………………………………………….

0
0

0
0




Electronic Gaming Devices……………………………………………….

0
0
0
0
0
0
0
0
0
0
0
0
0



Electronic Gaming Devices……………………………………………….

0
0
0
0
0
0
0
0
0
0
0
0
0


Master Sports Wagering ……………………..

0
0

0
0




Master Sports Wagering...…………………..

0
0
0
0
0
0
0
0
0
0
0
0
0



Master Sports Wagering……………………..

0
0
0
0
0
0
0
0
0
0
0
0
0


Total Gaming Revenues………………………………………………….

0
0

0
0




Total Gaming Revenues………………………………………………….

0
0
0
0
0
0
0
0
0
0
0
0
0



Total Gaming Revenues………………………………………………….

0
0
0
0
0
0
0
0
0
0
0
0
0

Hotel Revenues……………………………………………………..







0
0



Hotel Revenues……………………………………………………..


























0


Hotel Revenues……………………………………………………..


























0

Food & Beverage………………………………………………………….


0
0

0
0



Food & Beverage………………………………………………………….


0
0
0
0
0
0
0
0
0
0
0
0
0


Food & Beverage………………………………………………………….


0
0
0
0
0
0
0
0
0
0
0
0
0

Other (Explain)…………………………………………………..


0
0

0
0



Other ………………………………….……………………………..


0
0
0
0
0
0
0
0
0
0
0
0
0


Other ………………………………….……………………………..


0
0
0
0
0
0
0
0
0
0
0
0
0


Total Revenues…………………………………………………………….

0
0

0
0




Total Revenues…………………………………………………………….

0
0
0
0
0
0
0
0
0
0
0
0
0



Total Revenues…………………………………………………………….

0
0
0
0
0
0
0
0
0
0
0
0
0

Less: Promotional Allowances………………………………………………..


0
0

0
0



Less: Promotional Allowances………………………………………………..


0
0
0
0
0
0
0
0
0
0
0
0
0


Less: Promotional Allowances………………………………………………..


0
0
0
0
0
0
0
0
0
0
0
0
0


Net Revenues…………………………………………………………………..

$0
$0

$0
$0




Net Revenues…………………………………………………………………..

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0



Net Revenues…………………………………………………………………..

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0















































0






























0
Operating Expenses (From Supplemental Statements)………….



0
0

0
0


Operating Expenses ……………………………………………..………….



0
0
0
0
0
0
0
0
0
0
0
0
0

Operating Expenses ……………………………………………..………….



0
0
0
0
0
0
0
0
0
0
0
0
0













































































Related Party Expenses

(Exclusive of Interest)













Related Party Expenses

(Exclusive of Interest)



























Related Party Expenses

(Exclusive of Interest)


























Management Fees - Contractual……………………………….


0
0

0
0



Management Fees - Contractual……………………………….


0
0
0
0
0
0
0
0
0
0
0
0
0


Management Fees - Contractual……………………………….


0
0
0
0
0
0
0
0
0
0
0
0
0

Corporate Allocations……………………………….……………….


0
0

0
0



Corporate Allocations……………………………….……………….


0
0
0
0
0
0
0
0
0
0
0


0


Corporate Allocations……………………………….……………….


0
0
0
0
0
0
0
0
0
0
0
0
0

Other (Explain)………………………………………………...…….




0

0
0



Other………………………………………………...…….


0
0
0
0
0
0
0

0
0
0
0
0


Other………………………………………………...…….


0
0
0
0
0
0
0
0


0
0
0
0


Total Related Party Expenses………………………………………………..

0
0

0
0




Total Related Party Expenses………………………………………………..

0
0
0
0
0
0
0
0
0
0
0
0
0



Total Related Party Expenses………………………………………………..

0
0
0
0
0
0
0
0
0
0
0
0
0
















































































EBITDA…………………………………………………………………………



0
0

0
0


EBITDA…………………………………………………………………………



0
0
0
0
0
0
0
0
0
0
0
0
0

EBITDA…………………………………………………………………………



0
0
0
0
0
0
0
0
0
0
0
0
0

















































































Depreciation and Amortization………………………………………………..


0
0

0
0



Depreciation and Amortization………………………………………………..


0
0
0
0
0
0
0
0
0
0
0
0
0


Depreciation and Amortization………………………………………………..


0
0
0
0
0
0
0
0
0
0
0
0
0

Interest
















Interest






























Interest





























Income…………………………………………………….

0
0

0
0




Income…………………………………………………….




















0


0



Income…………………………………………………….

0






















0


(Expense)………………………………………………………

0
0

0
0




(Expense)………………………………………………………

0
0
0
0
0
0
0
0
0


0


0



(Expense)………………………………………………………

0
0
0
0
0
0
0
0








0


Income - Related Parties………………………………………….

0
0

0
0




Income - Related Parties………………………………………….

0
0
0
0
0
0
0
0
0


0


0



Income - Related Parties………………………………………….

0
0
0
0
0
0
0
0








0


(Expense - Related Parties)…………………………………..

0
0

0
0




(Expense - Related Parties)…………………………………..

0
0
0
0
0
0
0
0
0
0
0


0



(Expense - Related Parties)…………………………………..

0
0
0
0
0
0
0
0
0
0
0
0
0



Total Interest (Net)……………………………………
0
0

0
0





Total Interest (Net)……………………………………
0
0
0
0
0
0
0
0
0
0
0
0
0




Total Interest (Net)……………………………………
0
0
0
0
0
0
0
0
0
0
0
0
0

















































































Income Tax (Expense) Benefit……………………………


0
0

0
0



Income Tax (Expense) Benefit……………………………


0
0
0
0
0
0
0
0
0
0
0
0
0


Income Tax (Expense) Benefit……………………………


0
0
0
0
0
0
0
0
0
0
0
0
0
















































































Income From Continuing Operations……………………………………..



0
0

0
0


Income From Continuing Operations……………………………………..



0
0
0
0
0
0
0
0
0
0
0
0
0

Income From Continuing Operations……………………………………..



0
0
0
0
0
0
0
0
0
0
0
0
0

















































































Extraordinary Gain (Loss) - (Explain)……………………………


0
0

0
0



Extraordinary Gain (Loss) …………………...……………………………


0
0
0
0
0
0
0
0
0
0
0
0
0


Extraordinary Gain (Loss) …………………...……………………………


























0

Other (Explain)…………………………………………………………………..


0
0

0
0



Other …………………………………………………………………..


0
0
0
0
0
0
0
0
0
0
0
0
0


Other …………………………………………………………………..


























0
















































































Net Earnings (Loss)……………………………………………………………



$0
$0

$0
$0


Net Earnings (Loss)……………………………………………………………



$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Net Earnings (Loss)……………………………………………………………



$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0



























































































2022








































































2022
2021


YTD thru



































































Capital Expenditures



January
December


January





Capital Expenditures












































































































































Land & Improvements………………………………………………….



0
0


0





Land & Improvements………………………………………………….



0
0
0
0
0
0
0
0
0
0
0
0
0































Riverboat, Dock & Improvements…………………………………………



0
0


0





Riverboat, Dock & Improvements…………………………………………



0
0
0
0
0
0
0
0
0
0
0
0
0































Buildings & Improvements……………………………………………..



0
0


0





Buildings & Improvements……………………………………………..



0
0
0
0
0
0
0
0
0
0
0
0
0































Furniture, Fixtures & Equipment……………………………………………….



0
0


0





Furniture, Fixtures & Equipment……………………………………………….



0
0
0
0
0
0
0
0
0
0
0
0
0































Lease Improvements………………………………………………



0
0


0





Lease Improvements………………………………………………



0
0
0
0
0
0
0
0




0
0
0
















































































































Total Capital Expenditures…………………………………………


$0
$0


$0






Total Capital Expenditures…………………………………………


$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0















































































































































































































































































Note(s): Current Month Activity Only















































































(1)
































































(2)
































































(3)
































































(4)
































































The words contained in this file might help you see if this file matches what you are looking for:

...Sheet table of contents combo box detail in hidden columns vag illinois gaming board monthly financial information licensee name enter company current reporting month year go to print i income statement hellip ii operating expenses iii cash flows iv balance v statements changes stockholder s equity or partner all directions for the report file conventions should reflect results activity be reported on as entered is received by no later than last date following example from july delivered august preferred method transmission internet medium and sent address cynthiathomas illinoisgov if anything needs via regular mail it can attn cindy thomas south seventh st suite springfield il worksheets are protected therefore cells readonly except fields requiring data entry do not alter structure format doing so may corrupt macros formulas additional required contact assistance line items an explanation must describe only space has been provided notes at bottom adjacent figures quot schedules requi...

no reviews yet
Please Login to review.