Cash, American Express, Mastercard, & Visa.
Will Call is located at the Box Office.
Box Office Telephone: 323-468-1770
The Pantages Box Office opens daily at 10am. NO ONE UNDER THE AGE OF 5 ADMITTED
There is no elevator in the Pantages Theatre. Disabled seating is reserved for the exclusive use of the disabled patron and their companion. The purchase or use of disabled seating locations by non-disabled individuals is strictly prohibited and may result in ejection and/or forfeiture of the ticket price.
Cash, American Express, Mastercard, & Visa.
Will Call is located at the Box Office.
Box Office Telephone: 323-468-1770
The Pantages Box Office opens daily at 10am. NO ONE UNDER THE AGE OF 5 ADMITTED
There is no elevator in the Pantages Theatre. Disabled seating is reserved for the exclusive use of the disabled patron and their companion. The purchase or use of disabled seating locations by non-disabled individuals is strictly prohibited and may result in ejection and/or forfeiture of the ticket price.
Members of the Sanibel-Captiva Art League are proud to present their 45th Annual Juried Art Show (“Exploration”) in concert with the Art Council of SW Florida. This eclectic, multi-media exhibit will occupy the Dunham Family Gallery of BIG ARTS at 900 Dunlop Rd. in Sanibel, from December 17, 2020, through January 31, 2021. Hours for viewing are Tu-F, 10-4pm, and Sundays, 9-1pm. The gallery show will also be available as a virtual exhibit starting December 21, 2020.
Each year, the Annual Juried Show features innovative art works with subjects both abstract and representational, covering themes both unusual and familiar. Working in a variety of media, including two- and three-dimensional pieces, some of the best artists in Florida have produced works to delight and intrigue the viewer. Plan to explore this exceptional exhibit of original art created by members of the San-Cap Art League and the Art Council of SW Florida.
Educator, writer, popular presenter, juror and artist Barbara Anderson Hill is the judge for this show. A resident of Sanibel during the 1970s and 80s, Hill was one of the founders of BIG ARTS. She owned and operated a pottery school on the island and was adjunct professor at Edison Community College, now Florida Southwestern. Hill has held numerous key positions at art and cultural institutions including grants and major gifts manager for the John and Mabel Ringling Museum of Art, Sarasota, and executive director of the Edison-Ford Winter Estates Foundation, Fort Myers.
For more information about “Exploration,” visit BIGARTS.org and SanCapArt.org.
Crypto.com Arena does not accept Will Call drop off. Alternate Will Call Procedure (Alternate Pick Up) If a person (other than the person ordering and paying for the tickets) is picking up a Will Call order, the Alternate Pick-Up's name MUST be on the account. To add the name of an alternate pick-up to the account, the original purchaser must contact Ticketmaster Customer Service at 1-800-745-3000, verify their account information and request the addition an alternate pick-up.
213-742-7340
Box office is located on North side of building at 11th and South Figueroa. Box office hours are 10am to 6pm, Monday through Saturday. It is open extended hours on event day. Phone: 213-742-7340 SUMMER HOURS Closed Saturdays and Sundays unless there is an event, the box office will open at 9am on Saturdays or 10am on Sundays only if there is an event. The box office will have extended hours on all event days.
Feiern Sie Silvester am Fernsehturm im Haus Ungarn auf 1400qm Eventfläche und einer 180° Balkonterrasse!Erleben Sie Silvester im Haus Ungarn direkt am Fernsehturm in Berlin und freuen Sie sich auf einen eindrucksvollen Blick auf dieses Wahrzeichen, das Rote Rathaus und die Marienkirche durch die Glaspanorama Front innen oder von der Balkonterrasse. Genießen Sie alle Getränke wie Bier, Wein, Sekt und Longdrinks inklusive. Das Haus Ungarn bietet mit seiner modernen Einrichtung die passende Location für eine "High Class" Silvesterparty in gehobenen Ambiente auf unglaublichen 1400m² Eventfläche. Feiern Sie im Kinosaal und der modernen Empfangshalle mit zahlreichen Sitzmöglichkeiten. Moderne Lichteffekte und eine 4-Punkt Beschallung bieten auf zwei Tanzflächen die perfekte Grundlage für einen grandiosen Silvesterabend in Berlin 2019/2020. Verschiedene Live-Djs und ein Special Act lassen keinen Musikwunsch offen und sorgen für eine grandiose Silvesteratmosphäre. Gold- und Platingäste genießen ein Fingerfood Buffet in einer abgetrennten Premiumlounge. Die Balkonterrasse am Fernsehturm bietet Ihnen und Ihren Freunden zu Silvester in Berlin einen grandiosen 180-Grad-Blick auf das pulsierende Zentrum der Stadt. Feiern Sie Ihren Jahreswechsel "High Class" direkt am Fernsehturm in Berlin!Beginn der Silvesterparty:31.12.2019Platin Ticket Einlass ab 19:00 Uhr Gold Ticket Einlass ab 22:00 UhrMusik auf 2 Floors:Disco Classics, Charts, Pop, Party, Dance, House, R'n'B,Pop, Dance, House & R’n’B im ClubfloorSilvester Specials im Haus Ungarn:*Silvester feiern direkt im Herzen Berlins mit Blick auf den Fernsturm*2 Dancefloors & hauseigene Balkonterrasse*180-Grad-Ausblick auf den Alexanderplatz*diverse Lounges & Sitzmöglichkeiten*Open Bar die ganze Nacht (Getränke sind inklusive)19:00 bis 22:00 Uhr Stehbüffet (limitiert und nur mit Platin Ticket)Einlass ab 18 JahrenGold Frühbucher Ticket (inkl. Getränke) im VVK ab 59,-Platin Frühbucher Ticket (inkl. Getränke + Stehbüffet) im VVK ab 99,- → Die Ticketkontingente sind stark beschränkt und werden mit der Zeit teurer. Early Bird Tickets sind Frühbucher Tickets. Sie unterscheiden sich nicht im Leistungsumfang zu anderen Tickets. Je länger sie warten desto teurer werden eventuell die Tickets.Rückblick Silvester Fingerfood Buffet (Platin Tickets):www.silvester-party-berlin.de/silvester-fernsehturm-haus-ungarn-berlin
Tickets gibt es online auf www.silvester-party-berlin.de/silvester-fernsehturm-haus-ungarn-berlin oder an jeder bekannten Theaterkasse deutschlandweit in Kooperation mit Eventim.Veranstalter:Haus Ungarn Gastro GmbH, Köpenickerstr. 16-17, 10997 BerlinLocation Standort in Berlin:EventlocationHaus Ungarn Karl-Liebknecht-Str. 9, 10178 Berlinwww.silvester-party-berlin.de/silvester-fernsehturm-haus-ungarn-berlinEmpfohlen von www.silvesterparty.de!
Course Description:
Our financial modelling course provides a sound understanding of both the principles of financial modelling and the practical application of these to real-world situations by using Excel to build financial models.
The course builds upon the financial modelling principles and practices learned, to apply these to company or project valuations. In this, participants improve their mastery of valuation principles and concepts, and learn how to apply these in real-life situations.
Finally, participants will receive training in how to both detect and prevent errors from occurring.
Excel is the tool of choice for most financial modellers so before we start building financial models, it’s critical that we have a good understanding of the key functions and tools in Excel that can help us build models that are robust, easy-to-use, and flexible.
Here are just some of the areas we cover in our in-depth, hands-on workshop:
● Working with large data sets
● Summarising and aggregating data
● Extracting data that matches criteria using flexible formulas
● Error handling
● Ways of improving structure
● Techniques for keeping formulas consistent yet flexible
● Combining and splitting cells according to the content they contain
● Advanced techniques for creating automatically expanding charts and ranges
● Introduction to macros & when to use these
● We then apply and practise these functions during the remainder of the course.
Course Topics:
Bring Your Models!
Everyone’s models are different. As such, participants are encouraged to bring along their own financial models to obtain assistance, ideas, guidance and suggestions from the trainer in private.This is a key step in applying the concepts learned on the course to improve real-life models so please take the opportunity to draw on the trainer’s experience and expertise!
COURSE OUTLINE
Course Overview, Objectives & Introductory Concepts
● Financial modelling concepts: Aims, design, structure and development
● Corporate finance and valuation concepts
● Introductory Concepts
● Cash vs Profit
● Time Value of Money
● Cost of Capital
● Risk, return & value
● Scenario Analysis
Financial Forecasting & Analysis
● Common difficulties, problems and limitations with financial analysis
● Defining the decision
● Availability of information
● Defining model scope
● Knowing the limitations of financial analysis
● Information overload
● Financial Forecasting
● What is it?
● Steps involved
● Best practices & financial modelling standards
Financial Decision Making & Evaluation
● Common financial / investment decisions
● Understanding the Time Value of Money concept
● Understanding Discounted Cash Flows
● Evaluation of different methodologies (including NPV, IRR, Payback Period)
● Introduction to valuation concepts including NPV
● Identifying & dealing with IRR difficulties
Valuation tools and methodologies
● Reviewing valuation concepts
● Valuation methodologies (including evaluation of different methodologies)
● Dealing with common valuation issues
● Compare & contrast alternative valuation methods to know when to apply each
Discounted Cash flow
● Overview of DCF methodology
● The role of Cash Flow Forecasts
● Cost of Capital
Ratios and Key Performance Metrics
● Performing a Ratio Analysis
● Understanding Profitability Ratios
● Interpreting Liquidity and Solvency Ratios
Financial Modelling & Forecasting in Excel
● Overview & Objectives
● Defining the scope of your model
● Objectives: What are the aims of the model?
● Understanding model limitations
● Development and structuring
● Planning the financial model
● Ensuring the model structure matches the objectives
● Incorporating best practice techniques into your models
● Compare a selection of best practice guidelines/standards
Structuring the Cash Flow Model
● Setting Up the Work Book & structure
● Time scale
● Separate business areas
● Timing and frequency formats
● Data Sources
● Managing the Input Section
● Building the Calculation Section
● Building the C/Flow Forecast
● Line by line build-up of cash flows
● Cap Ex and Op Ex
● Presenting Model Outputs
● Key Financials
● Summary of model data
● Dashboards & Graphs
● Valuations & terminal values
Integrated 3-way Financial Models
● Balance sheet, Income statement, cash flow
● Dealing with interest circularity
● Using ratios to produce financial forecasts
● Debugging a 3-way model
Debt and Capital Structuring
● Typical Bank Covenants & Ratios
● The Importance of Capital Management
● Why it is important (cost of debt vs equity)
● Defining your optimal capital structure
● The Effect of Capital Structure
● Understanding its effects on risk
Sensitivities & Scenario Management
● Sensitivity
● Identifying key variables for sensitivity
● Building in sensitivities
● Displaying the results of sensitivity analysis
● Scenarios
● How to run multiple sets of inputs through a single calculation engine
● Building, managing and extending a scenario manager that is far better than Excel’s
● Introduction to Monte Carlo simulation: how to apply these techniques in practical ways to real-life financial models
Best Practice Reporting, Review and Presentation
● Checking outputs for consistency
● Techniques for building checks & balances
● Model audit & review
● Automated spreadsheet auditing software tools: role, purpose & limitations, demonstration
● Documentation
● Use of financial modelling software: when is it useful or not useful?
Course Features:
What you get from this course:
Understand how Power BI builds on the functionality of Excel’s native tools, such as PivotTables, slicers and key analytical functions.
Be able to import data from a variety of electronic sources and relate them quickly to deliver key information in minutes not weeks.
Utilise best practice database design, realising the power of the Data Model by using LOOKUP lists and efficient database design.
Provides an introduction to Power BI’s Data Analysis Expressions (DAX) language
Certification:
Once after the training you receive course completion certificate from Mangates
Who Can Attend?
Pre-requisites
Although not mandatory, attendees will get a lot more out this course if they complete some online training in Excel functions before attending.
Who should attend?
● Business & Finance Analysts
● Finance Managers
● Investment Managers
● Investment Analysts
● CFO’s
● Financial Modellers
● Project Managers
● Project Accountants
● Investment & Corporate Bankers
● Corporate Finance Managers
● Finance Professionals
● Accountants
Accepts: cash, Visa, Mastercard, Discover, American Express
Located at main box office on Centennial Olympic Park Drive. Available for pickup beginning 1 1/2 hours prior to event. Closing time will vary by event. PLEASE BRING A PICTURE ID, THE ACTUAL CREDIT CARD USED TO PURCHASE THE TICKETS, AND YOUR ORDER NUMBER.
404-878-3000 - State Farm Arena Box Office 1-866-715-1500 - Atlanta Hawks
The Box Office is open on event days and for the first day of all on-sales. (Hours will vary based upon the events and time of on-sales).
Accessible seating is available in throughout the arena in various price categories. Seating for the sight/hearing impaired available in the lower level. All accessible seating is subject to availability. All levels of the Arena are accessible by elevator and escalator.
Cash, Visa, MC
Will Call may be picked up at the Venue, day of show, 3 hours prior to show time. Proper I.D. and confirmation number will be required
915-231-1100
MON-FRI 9AM – 5PM / SAT-SUN EVENT DAY ONLY