Course Description:
Organizations need to make business decisions more quickly and accurately than ever before. Basing these decisions on data and Best Practice analysis techniques and less on gut feel or
Course Topics:
There are no prerequisites for this Course. Basic familiarity with MS Excel or a similar tool is recommended.
Learning Goals:
as well as identify and manage opportunities where data-based decisions can be used to change the way you do business.
Who can Attend?
you will learn to use data analytics to create actionable recommendations
Cash, American Express, Visa, MasterCard, Discover. ATM machines are located in Chase Square.
Pick-up tickets anytime the day of the show during box office hours (see above). Customers must present the actual credit card used to place the order and a picture ID. MSG cannot accept third party or “drop offs” from individual patrons.
General Info: (212) 465-MSG1 (6741) or (212) 247-4777 Knicks Information: 1(877) NYK-DUNK. Rangers Fan Line: (212) 465-4459. Liberty Hotline: (212) 564-WNBA (9622). Season Subscriptions: (212) 465-6073. Disabled Services: (212) 465-6034 Guest Relations: (212) 465 - 6225 Group Sales: (212) 465-6100 Lost and Found: (212) 465-6299
Monday - Saturday: 10:00am to 6:00pm **Tickets are not on-sale at the Box Office on the first day an event goes on-sale** The Box Office will be open at 10:00am daily or 90 minutes before the 1st performance of the day, whichever is earlier and will stay open until 8:00pm or 30 minutes after the last performance of the day begins, whichever is later. Sunday – Closed If an event takes place on Sunday, Box Office will open 90 minutes before the event start time and remain open 1 hour after event start time for Will Call and tickets sales for the evening's event only.
MSG WHEELCHAIR AND TRANSFER SEATING POLICY: Wheelchair and Transfer seating is reserved exclusively for patrons with accessible needs and their companions. Accessible seating is intended for use by an individual with a mobility disability or other disability who requires the accessible features of accessible seating due to a disability, and that individual's companions. Madison Square Garden (MSG) reserves the right to investigate potential misuse of accessible seating and to take all appropriate action against individuals who fraudulently obtain tickets for accessible seating. While tickets for accessible seating legitimately purchased for the use of an individual with disability may be transferred to another individual under the same terms and conditions applicable to other tickets, in the event such ticket is transferred to a non-disabled individual, MSG reserves the right to transfer that individual to other available seating TO ORDER WHEELCHAIR AND TRANSFER SEATING: Tickets for people with accessible needs, subject to availability, may be purchased in several ways: 1) Call Ticketmaster at 866-858-0008 2) Call MSG's Disabled Services Department at (212)465-6115. 3) Visit Madison Square Garden's Box Office (see box office hours above) 4) Order Online with Ticketmaster (select your event from the list to the left) For additional information regarding accessibility at Madison Square Garden or to request any other accommodations, please call MSG's Disabled Services Department at (212) 465-6115 any weekday between 9:30am-4:30pm ET. Service Animals Pets are not permitted at Madison Square Garden. MSG has very specific policies related to service and emotional support animals. Please visit www.thegarden.com to obtain more information for admitting your animal. Assistive listening devices (ALDAs) are available upon request. Please visit the Guest Experience Office across from section 117 for assistance. There is no charge for this service, however some form of identification will be requested and returned to you, once the device is checked back in. Wheelchair Storage: For patrons who wish to transfer to a seat from their wheelchair, we will store your mobility device at the Guest Experience Office. You will receive a claim check for your device. Wheelchair Escorts to Seats: Patrons with mobility impairments who do not have access to a wheelchair may request a wheelchair to transport the individual to/from their seat, free of charge. Please be aware that our personnel cannot remain with you during the event, nor will they allow you to remain in or keep the wheelchair for the duration of the event. In the event a patron requires the use of a wheelchair for the duration of the event, we recommend bringing your own wheelchair or other mobility device. The escort pick-up area is located on the South (toward 31st) side of Chase Square at elevator alcove. Please allow for extra so that you may be accommodated prior to the event start. Simply ask a Guest Experience Representative or a MSG Security Guard for assistance. Elevators: Public elevators are available for use by guests with disabilities and service every seating level
Construct a robust real estate financial model from scratch and use it to assess the financial risk and return profile of an investment, income-producing real estate asset.
This course is aimed at banking and lending analysts for real estate, investment surveyors, real estate finance professionals and property consultants seeking a best practice approach to building robust real estate financial models.
Delegates will learn to construct valuation models and discounted cash flow models for single-tenant and multi-tenant buildings and perform sensitivity analysis for the investment decision. Delegates will also learn real estate finance fundamentals which will enhance their property investment analysis and underwriting processes.
Who should attend this course:
The Real Estate Investment and Financial Modelling in Excel courses are suitable for anyone seeking to develop their modelling skills. From entry-level graduates, APC candidates to experienced professionals and modellers, the fundamentals and techniques taught in our courses will help anyone improve their financial modelling expertise and reduce modelling errors.
Details
Duration: 2 daysLocation: LondonCPD Hours: 12Level: BasicMaximum number of delegates: 6
Content
Day 1
Best practices in financial models
Simple tips to help you become an efficient financial modeller
How to avoid errors and present your models in a persuasive way
Property yields
Defining term and reversionary yields
Calculating the equivalent yield
Value calculation using conventional valuation methods
Build your cash flow from scratch
Inputs: passing rent, estimated rental value, initial and exit yields, market growth, review cycles and most importantly, target returns
Outputs: internal rate of return, net present value and worth
Annual and quarterly discounted cash flows: modelling purchase price, passing rent, rent reviews, exit rent and exit price
Gearing: adding senior debt “bullet” loan
Analyse the results
The maximum bidding price
Data tables & sensitivity analysis
Risk visualisation (charts)
Case study: single-tenant office building in the UK
Day 2
Dating the cash flow
The dating problem
Intermediate calculations
Rent Forecast
Modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Modelling hypothetical second leases: void period, rent free and estimated rental values
Time-varying rental growth
Net Operating Income Forecast
Modelling capital expenditure for refurbishment and operating costs (letting fees, void costs, empty rates)
Logic Functions
Investment decision
Sensitivity tables
Risk versus return analysis
Case study: multi-tenant office building in the UK
The Box Office accepts cash, MasterCard, Visa, Discover, and American Express. NO CHECKS.
Will Call orders can be picked up on the night of the event only, after 5:00 pm or two hours prior to the event, unless special arrangements are made. Customers must have their order number, a picture ID, and the actual credit card used to place the order.
Heritage Bank Center - (513) 421-4111
The Box Office is open for the public on sale of all events at the building as well as- Mon-Fri: 10:00 am - 5:00 pm Sat-Sun: Open at 12:00 noon or two hours prior to the event start time on event days only. The Box Office will close at half time the last game of the day. The Box Office will close at intermission (or when the main act goes on stage for a concert). The Box Office is located on the Plaza Level at the west end of the building facing the Ohio River and Great American Ballpark. If entering at street level, take the elevator to the 4th floor.
Heritage Bank Center is handicap accessible. Seating is available at the Box Office and through the Ticketmaster Charge-by-Phone number.
Do you have a business that you created a Facebook business page for but have no resources to create your own website? Have you created a rudimentary website for your business on one of the free platforms that you know is not doing what it needs to AND you’re worried about the fact that you don’t own your own content? Do you know the next right step is a website but just the idea totally overwhelms you?
This online Bootcamp will run on September 12th, 19, 26th and October 3rd from 10am – 12pm
Cost: $79 nonmember, $45 Member
This 4-part online Bootcamp delivers a robust curriculum to get you digitally literate so your business idea can thrive. All participants will also receive a host of free products and in-kind support through ongoing webinar, live Q & A calls, and one on one consultations. No prior web creation experience needed.
Learn more and register here:http://e-jedi.org/event/build-an-effective-website-for-your-businesssept/
CashCheckAmExVisaMC
Pick up tickets 1 hour prior to show. Customers must present the actual credit card used to place the order and a photo ID.
(212) 586-6510
Monday - Wednesday 10am - 8pm Thursday - Saturday 10am - 8:30pm
Learn About Scrum
Scrum is an Agile framework for completing complex projects. Scrum originally was formalised for software development projects, but it works well for any complex, innovative scope of work. The possibilities are endless. The Scrum framework is deceptively simple.
Faced with a complex project? Use Scrum to improve teamwork, communications, and speed. See how!
Audience Profile
Anyone interested in knowing more about SCRUM & Agile can take up this course and exam for free.
Prerequisites
There is no formal prerequisite for this course.