Visa, MasterCard, Discover, American Express
Will Call is located at the Ticketmaster Box Office on the North Side of the Arena located between Gates 3 & 4. Valid ID required to pick up Will Call Tickets
Miami HEAT & Arena Event Sales Information: • Miami HEAT Season Tickets & Partial Plans (786) 777 HOOP • Miami HEAT Group Tickets (786) 777 DUNK • Miami HEAT Premium Seats (Courtside/Flagship/Suites/Loges) (786) 777 4320 • Arena Event Suite Sales (786) 777 1000 • Group Ticket & Fundraising Opportunities for Arena Family Shows (786) 777 4FUN (4386)
Kaseya Center (formerly known as Miami-Dade Arena) will only be open on event days. Arena Box Office Information (786) 777-1250
This is an accessible venue.
The Sterling Style Academy is a U.S. based, internationally recognized training institution, with a proven track record for producing highly credible and influential image consultants, personal stylist and personal shoppers from the U.S., Europe, Latin America, the Middle East, Africa, and Asia. Having trained renown pioneers within the industry that span 6 continents, we provide you with a truly global perspective on how to start a business with no additional investment to generating income within your first month after training.
If you are motivated with the ambition to succeed, we’ll help you formulate a unique business that incorporates your distinct skill sets with personal styling and personal shopping. From creating online boutiques to helping fashion designers and fashion bloggers diversify their skill sets, we help you identify your passion and your purpose to brand you in the marketplace.
We’ll teach you the techniques to becoming your own Personal Brand which is essential in order to become an influential entrepreneur and much more!
Please visit the following link to find out more about our 5 Day Personal Stylist and Personal Shopper course curriculum: https://sterlingstyleacademy.com/personal-shopper-stylist-training-programs/3-day-short-courses-new-york-london-dubai/
Location to be disclosed upon registration for the program.
YOU MAY SEE OTHER COURSES WITH SIMILAR CURRICULUM BUT IT'S OUR INTERNATIONALLY PROVEN METHODS OF TRAINING AND ADVISING STUDENTS ON HOW TO CREATE THEIR BUSINESSES THAT SETS US APART FROM OTHER PROGRAMS. WE TEACH YOU THE SCIENTIFIC ASPECTS TO STYLE AND THE FORMULA FOR ENTREPRENURIAL SUCCESS.
If you have any more questions about our training program after reviewing the link on our website, please email us directly at info@sterlingstyleacademy.com.
IF YOU'D LIKE TO BECOME A CERTIFIED FASHION AND STYLE CONSULTANT, TRY OUR eCERTIFICATION PROGRAM FOR AN INVESTMENT OF US$997. Details can be found here: https://sterlingstyleacademy.com/image-consultant-personal-shopper-personal-stylist-ecourses-teleclasses/
Cash and All Major Credit Cards
MUST HAVE PHOTO I.D. & CREDIT CARD USED TO PURCHASE TICKETS WHEN PICKING UP WILL CALL TICKETS
702-693-6143 1-855-234-7469 Group Sales (20+)
Opens one hour prior to the first show and closes a half hour after the last show.
To better accommodate your needs the box office has requested that special seating accommodations be solicited through their representatives
WILL CALL OPENS ONE HOUR PRIOR TO SHOW. PURCHASING CREDIT CARD REQUIRED TO PICK UP TICKETS - WILL CALL IS LOCATED AT THE MAIN BOX OFFICE ON THE BROAD STREET SOUTH SIDE OF THE CTR.
THE CENTER IS EQUIPPED WITH ELEVATORS AND ACCESSIBLE SEATING IS AVAILABLE. FOR INFORMATION ON ACCESSIBLE SEATING, PLEASE CALL (215) 389-9571. TELECOMMUNICATION DEVICE FOR THE DEAF,(TDD) CALL (215) 389-9599
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
Let's meet worldwide every first day of the month to share our love for Webtalk, the new social media, and invite our neighbours, friends and the passers-by to join!
Click here to see a list of all events worldwide. Learn more about Webtalk here.
If you are already in Webtalk, come and meet other Webtalkers, share your passion for Webtalk, exchange the latest tips and tricks, and come to invite the passers-by to join your team!
If you are not yet in Webtalk, or don't even know what Webtalk is about, use this day to discover the platform, create your account, write your first post and start inviting your fellow friends/family/colleagues or even the passers-by to join in your team!
The only rule is: BE CREATIVE!
If you are an artist, you can show your passion for Webtalk by organizing a happening!
If you are a musician, why not play a song about Webtalk?
Picnics are welcome too.
Don't forget to take pictures of the event to publish on Webtalk and other social media! Send us your pictures so we can publish them on our feed!
Please note that this event is self-organized. As a participant, you are the co-organizer of your own event.
This event is brought to you by the Webtalk Stars Team and webtk.co, your ticket to Webtalk. You can meet the Webtalk Stars Team on Webtalk.
New: read the story of Amara and how she overcomes the Facebook of her time in #Analog2030, the new science fiction discovery of the year.
#webtalk2019 #webtalk2020 #webtalkstars #deletefacebook #deletelinkedin #deleteinstagram
All valid debit and credit cards as well as the digital payment wallets Apple Pay and Google Pay
The box office is Open Event Days Only starting 3 hours prior to event time. Will call tickets may be picked at the AT&T Center Box Office. Policies for will call for each event may vary.
(210) 444-5870
Open Event Days Only. Open 3 hours prior to event time. All AT&T Center event tickets can also be purchased at www.ticketmaster.com or the Ticketmaster App.
AT&T Center is an accessible venue. Accessible seating tickets can be purchased online at www.ticketmaster.com or the Ticketmaster App. A limited number of accessible seating tickets can be purchased at the AT&T Center Box Office, Open Event Days Only, opens 3 hours prior to event time. Certified service animals for guests with disabilities are welcome at the AT&T Center and must remain on leash or in a harness. If interpretive services are needed, please contact a Fan Experience coordinator at 210-444-5140 a minimum of three weeks prior to the event so appropriate accommodations can be made. Interpreters are provided free of charge, but event tickets are required prior to scheduling.
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.