Your 2020 Summer Games Package InclusionsPersonalized meet and greet upon your arrivalYour choice of first class accommodations in TokyoFull Breakfast DailyEvent day experiencesOptions for event transportationTokyo Welcome KitPersonalized itinerary Summer Games Commemorative Gift packagesHotel Transfers Upon ArrivalOnsite hosts and local assistanceExpert travel and concierge Your-Service DeskAll taxes and service charges2020 Summer Games Optional Add-Ons & PossibilitiesThere are numerous optional add-ons and possibilitiesyou may want to consider adding to your Summer GamesExperience. From day tours to spa treatments or dinnerreservations, it is your experience to customize. Optionaladd-ons and possibilities include:ɾɾ Hotel room upgradesɾɾ Private transfers (sedan, limousine, luxury motor coach)ɾɾ Private guides for tours and transportationɾɾ Day Toursɾɾ Excursionsɾɾ Pre and/or Post Tokyo extensionɾɾ Airfare (economy, first class, private jet)Summer Games Package RatesThe rates below are based on a travel package including six nights in your choice of first class accommodations, round-trip airport transfers, personalized meet-and-greet upon arrival in Tokyo, daily breakfast, your preferred event day experiences, 24/7 onsite host services and more. However, you can completely customize your package to make it perfect for you.Hotel Package Room Type Package FromHyatt Centric Ginza Tokyo Standard Room $8,545Hyatt Centric Ginza Tokyo Deluxe Room $9,495Hilton Tokyo Executive Room $9,425Hilton Tokyo Executive Junior Suite $10,675Hilton Tokyo Executive Tower Suite $11,795Park Hyatt Tokyo Park Room $13,025Park Hyatt Tokyo Park Deluxe Room $15,105Park Hyatt Tokyo Presidential Suite Call for ratesFour Seasons Hotel Tokyo at Marunouchi Deluxe King Room $17,845Four Seasons Hotel Tokyo at Marunouchi Suites Call for rates*Rates are per person in USD based on double occupancy. Single occupancy rates are available. Triple and Quad occupancy may be available. A 25% deposit is required to secure your package. Second 25% deposit is due April 1, 2019. Third 25% deposit is due October 1, 2019. Final balance will be due April 1, 2020. Availability and pricing subject to change prior to booking
The box office accepts cash, Visa, MasterCard, American Express and Discover cards.
Tickets are available via telephone at 1-866-7-BOK-CTR
Hours are Tue-Fri 11am-3pm. Evening, weekend and holiday hours vary according to event schedules.
BOK Center strives to create a great experience for all guests. BOK Center under guidance and direction from the Americans with Disabilities Act has fully accessible restrooms, drinking fountains, counters and more to assist guests with disabilities. Accessible tickets/seating and wheelchair accessible seats are available in all price levels. One companion ticket may be purchased with each wheelchair accessible ticket. Please indicate when purchasing tickets if you require accessible seating. Tickets can be purchased at BOK Center box office during box office hours or through ticketmaster.com. Patrons with disabilities may be dropped off on West 3rd Street between Denver Avenue and Frisco Avenue by the south entrance to BOK Center and the Box Office. Some events at BOK Center may have the City of Tulsa Police Department directing traffic to and from BOK Center. When an event calls for this, Disabled Guests may be directed to 1st and Denver by a Tulsa Police Officer. Sign Interpreters: BOK Center can provide sign language interpretation for guests that need assistance. Requests for this service must be received three weeks prior to the event. Seating will be reserved for the patron and one companion using this service in Section 120. For details, please email us at info@asmtulsa.com or call BOK Center at 918-894-4200. Wheelchair Assistance: BOK Center offers wheelchair service for guests who may need assistance to and from their seats. Guest Services attendants will be on site to assist. Wheelchair assistance is provided on a first-come, first-served basis. Due to the limited number of wheelchairs available, they may not be borrowed or rented as seating during an event. If wheelchair assistance is necessary during an event, please notify the nearest staff member.
Cash, Money Order, AMEX, MC, VISA, Personal Check (must be received 10 days prior to event).
Will Call is located on the southwest corner of the stadium on the corner of Brush & Beacon Street outside Gate A. (This location may change depending on event. Please call 313-262-2000 with any questions) Ford Field Address: 2000 Brush St. Detroit, MI 48226
General Information: 313-262-2000 Ticket Information: 313-262-2002 Accessible Seating Ticket Information: 313-262-2167 Event Information: 313-262-2003 (press option 5) Detroit Lions Pro Shop: 313-262-2200 guestservices@detroitlions.com
Monday - Friday: 10:00 AM - 6:00 PM Located at Gate G off St. Antoine 2000 Brush St. Suite 200 Detroit, MI 48226
Wheelchair accessible seating is available at the box office at 313-262-2167. Policy: One companion for each wheelchair patron allowed in wheelchair designated seating areas.
The Box Office accepts Cash, Visa, MasterCard, American Express, and Discover.
Will Call tickets can be picked up 2 hours prior to the event at the Box Office. Customers will need their Confimation Number and Photo Identification.
For information on events call (313) 887-8500.
The Box Office hours are typically Monday through Friday from 10:00 AM to 2:00 pm.
Please call the box office at (313) 887- 8500
Tickets left at the box office for collection may be picked up on the day, during the hour before the performance starts. Please take the credit card used to make the booking and the Ticketmaster booking reference number as proof of purchase.
Ticketmaster UK: 0870 154 40 40, International: 00 44 161 385 3500
Monday - Saturday 10:00 - 18:00 and occasionally on Sunday.
Infra red hearing system with no deposit required. For special needs seating please call 0844 412 4648. Disabled toilet situated in the rear Stalls with ground level access There is no limit to the amount of Guide Dogs (within reason of course)
Mastercard, Visa (credit and debit), Switch/Maestro, cash. (AMEX and cheques not accepted.)
Collect tickets from the Aldwych Theatre box office on the day of the show an hour before the start of the performance. Take the credit card used to make the booking and Ticketmaster reference number with you. The cardholder will be required to sign for proof of purchase.
General Bookings: 0345 200 7981 (9am to 6pm, Monday to Friday and 10am to 6pm, Saturday to Sunday) Groups of 10+: 0345 0130 602 (10am to 5.30pm, Monday, Wednesday to Friday)
Monday, Wednesday and Friday: 4pm to 7.45pm Thursday and Saturday: midday to 7.45pm Sunday: midday to 3.45pm
Customers with access needs need to book direct through ALDWYCH ACCESS on 020 7836 5537 (option 2) or by e-mail aldwych.access@nederlander.co.uk For more information about d/Deaf and disabled access at the theatre, please visit nederlander.co.uk/access.
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