2020. It’s coming! The mythical strategic horizon for a generation of trend watchers is upon us \o/ Except it brings on difficult questions. Are robots taking over our jobs? Is social media shaping toxic behaviors? Will millennials ever stop buying avocado toasts?! Join our top analysts in Bangkok on Friday, 8 November and you’ll leave empowered to launch better innovations in 2020 and beyond!
cash, visa, MC,
LOCATION : For the New Orleans Saints, Tulane University Football, and the Sugar Bowl, will call is located at Gate A, ground level on Poydras St. For any other event, Will Call is located at Gate F, second level up the ramp. HOURS : For New Orleans Saints 3 hours before the game All others 2 hours prior to the event.
(504) 587-3822 - General (504) 731-1700 - New Orleans Saints Ticket Office (504) 587-3805 - Parking (504) 587-3800 - Recording (504) 587-3663 - Switchboard
Mon-Fri 9:00am - 4:30pm
This is an accessible venue.
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
Il corso di formazione per conseguire il diploma di Insegnante di Balli di Gruppo è suddiviso in due livelli di preparazione: Primo livello: Maestro Bronzo e Argento (Abilitazione all'insegnamento del Choreographic Team); Secondo livello: Maestro Oro (Qualifica di specializzazione di Insegnante Choreographic Team). FINALITÀ: La finalità del percorso professionale di Maestro Bronzo Argento Oro è quella di creare una figura di Insegnante di Balli di Gruppo con un notevole bagaglio di competenze tecniche della disciplina che lo renderà professionista del settore.
Tale formazione professionale consentirà ai partecipanti di conseguire, previo esame finale, il diploma e il tesserino di Insegnante in Choreographic Team rilasciato da ASC, ente di promozione sportiva riconosciuto CONI e valido per l’insegnamento in tutti i centri sportivi, associazioni, scuole di ballo e danza. Diploma valido ai fini delle agevolazioni fiscali per l’attività Sportiva Dilettantistica (L. 342/2000).
I diplomi rilasciati danno la possibilità di esercitare la professione di Insegnante di Balli di Gruppo.
I corsi di formazione sono a NUMERO CHIUSO.
DATE: Il prossimo corso di formazione Maestro Bronzo e Argento si svolgerà nelle seguenti date:
- 8 FEBBRAIO 2020 (dalle ore 10:30 alle 18)
- 29 FEBBRAIO 2020 (dalle ore 10:30 alle 18)
- 21 MARZO 2020 (dalle ore 10:30 alle 13:30; a seguire esami in sede).
PROPEDEUTICITA':
Per accedere al corso ORO bisogna aver superato l'esame di MAESTRO BRONZO e ARGENTO.
PREREQUISITI:
Buono studio pregresso della Danza o del Ballo. Predisposizione all’insegnamento.
PROGRAMMA: Saranno trattati tutti gli argomenti del corso di formazione Balli di Gruppo che saranno visionabili anche nel testo di preparazione che verrà fornito ai corsisti il primo giorno del corso: - Balli sociali e coreografici;
- Teoria musicale;
- Composizione coreografica;
- Terminologia tecnica dei passi e dei movimenti; -Laboratorio di anatomia, riscaldamento muscolare e stretching; - figura dell’insegnante di ballo;
- normative fiscali.
DOCENTI:
- ROSSELLA GIULIA BUCCI
- NORMA MARIANI
I nostri Docenti svolgono attività di tutoraggio 7 giorni su 7 a tutti i frequentanti dei corsi di formazione che dovessero avere bisogno di un supporto tecnico della disciplina oggetto di studio.
DOVE: I corsi di formazione si svolgono presso l’A.S.C. DANZA in via Gregorio XI 211 a Roma. MODALITÀ D'ISCRIZIONE: Per iscriversi al corso di formazione (posti a numero chiuso) bisogna richiedere la disponibilità tramite l'apposito modulo sul sito dell'A.S.C. DANZA comunicando il proprio nome cognome e recapito telefonico e la tipologia di corso scelto. Da quel momento, il corsista avrà cinque giorni di tempo per ufficializzare l'iscrizione, inviando il modulo di iscrizione cartaceo e la copia del pagamento della quota di iscrizione. ESAME FINALE: Al termine del percorso formativo sarà verificata l'abilità tecnica e didattica di ogni aspirante maestro attraverso un esame di fine corso che si svolgerà l'ultimo giorno del corso di formazione. COSTI E CERTIFICAZIONI: Le quote comprendono:
- Materiali di studio;
- Corso negli incontri prestabiliti;
- Diploma ASC riconosciuto coni, previo superamento dell’esame finale,
- Tesserino tecnico personale di Maestro Choreographic Team;
- Quota associativa all'ente di promozione sportiva per la stagione in corso;
- Iscrizione all'albo nazionale insegnanti danza sportiva ASC.
MAESTRO BRONZO E ARGENTO
550 Euro (suddivisa in 150 Euro all’atto dell’iscrizione da versare entro 15 giorni dall’inizio del corso salvo disponibilità di posti, 200 Euro da saldare presso la segreteria il primo incontro del corso e i restanti 200 euro da saldare presso la segreteria il secondo incontro del corso).
MAESTRO ORO
300 Euro (suddivisa in 150 Euro all’atto dell’iscrizione da versare e 150 Euro da saldare presso la segreteria il primo incontro del corso oro.
COSA PORTARE:
- 2 fototessere cartacee da consegnare in segreteria dell’A.S.C. DANZA il primo giorno del corso;
- Abbigliamento e calzature idonee per la lezione di balli di gruppo.
N.B. Le dispense e i materiali di studio verranno consegnati il primo giorno del corso di formazione e sono compresi nelle quote di iscrizione.
DOVE SIAMO e COME RAGGIUNGERCI
Via Gregorio XI 211– 00166 Roma (oppure entrata secondaria a Via Giovanni Andreucci 20).
CONTATTI: Rispondiamo ai recapiti telefonici ed email tutti i giorni dal lunedì al venerdì dalle ore 9.30 alle 21.30 ed il sabato e la domenica dalle 10 alle 18. Maggiori informazioni sono disponibili sul sito ufficiale dell’A.S.C. DANZA.
Visa, MasterCard, American Express, Discover & Cash.
Will Call begins 2 1/2 hours prior to event.
615-565-4200. Fax is 615-565-4212. For CMA Festival Info, please call 1-800-CMAFEST
8:30AM - 5:00PM Monday - Friday.
This is an accessible venue: All Patrons in Wheelchairs Must Purchase Accessible Seating. For CMA Music Festival: Please contact CMA at 800-262-3378 for accessible seats.
Cash; Check up to $100.00 w/Mass. Driver License; AMEX; Visa; MC; Discover; Diners Club
Pick up tickets starting 2 hours prior to event time. Customer must present the actual credit card used to place order and a photo I.D.
General Info Number:(617) 624-1000 Group Sales (only!): (617) 624-1805/1806 Bruins (617) 624-BEAR (Groups = 25+) Celtics (617) 523-3030 (Groups = 20+) Please do not contact Group Sales regarding sold out games!
TD Garden - Boston | Tickets, Schedule, Seating Chart, Directions (ticketmaster.com) The box office will open 2 hours prior to an event and remain open until one hour after the event begins. Please note the TD Garden Box Office does not sell tickets at the public on sale. All tickets should be purchased via www.ticketmaster.com *Hours subject to change
This is an accessible venue.
Cash, Visa, MC, AMEX & Discover. No Checks accepted at Box Office
Will Call is located at main Box Office. Customers can pick up any time/day prior to event
(518) 487-2000
Box Office is located on the Market Street side of the venue. From Labor Day to Memorial Day - Hours M-F 10AM -6PM & Sat 10AM - 2PM Summer Hours (from Memorial Day to Labor Day) - Hours : M-Th 10AM - 5PM Closed Fri-Sun
This is an accessible venue. Venue is Accessible from Pearl Street Level with escalators and elevators to the concourse level. Venue parking in Times Union Center Garage (behind venue) is accessible via walkway on the 3rd floor of garage.