Online Financial Modeling, Investment Banking, Excel Training

REIT FINANCIAL MODELING-MODEL ONLY!

Package: $750

Real Estate Investment Trust financial projection modeling (more)
Please read this important note on non-video based (note)

MODEL ONLY, NO VIDEO INSTRUCTION OR SLIDES
Our REIT Model is not yet available in our streaming-video online format; however, we do make it available for purchase. You will receive access to the fully constructed REIT model and blank template WITHOUT ANY VIDEO INSTRUCTIONS OR SLIDES to guide you through the course. We anticipate rolling out our online REIT course towards late 2011, early 2012. At that point, you will receive full access for 6 months once it’s online; however, we provide no guarantees on exact timing. Your order and purchase of the REIT - Model Only course implies that you agree and acknowledge this. No refunds or credits provided.

Overview of Courses
Real Estate Investment Trusts take a different life of their own by aggregating all the real estate investments and development projects the REIT manages and owns. The individual line items per property are not as relevant as everything in totality. The process of quantifying construction-in-progress, acquisitions and new development starts on the overall REIT entity to arrive at a solid set of projections is the goal in our REIT module.

NOTE:
Our REIT Model is not yet available in our streaming-video online format; however, we do make it available for purchase. The REIT Model starts at $750 USD (see below), which includes access to our Core Model online class, completed industry model and an optional half hour consultation with Hamilton Lin, CFA, our President & Founder, after you have reviewed the model. See details below:

1) ONLINE ACCESS
Our REIT Model builds upon our Advanced Financial Model - Core Model online course. The "Core Model" builds the fully integrated model but is not REIT- specific (actually it uses a retail company with base-case accounting). Below are the following purchase options for our REIT-specific courses:

Completed, standalone REIT model (Model)*: $750
Model + 1 month online access to Core Model: $900
Model + 6 month online access to Core Model: $1,000
Optional Consultation to review model: $500 for half hour (see below)
* Model also includes any relevant industry overview slides.

2) INTERACTIVE, EXCEL-BASED MODELING
The above referenced "Core Model" course is excel-based modeling. Pls see http://www.wstselfstudy.com/package3.html for more information. Click on video learning platform and product demo links to learn more. Note: Basic excel skills are required (and sufficient) as the Core Model course will get you up to speed on Excel shortcuts and model building best practices very quickly.

3) TIME TO COMPLETION
The Core Model is about a full day of work. You can break up the course however you like, based on your free time - an hour here and there, etc. Hence, we allow for different duration options based on your timing and availability. Add to that the amount of time it takes you to go thru the completed industry specific model supplied to you.

4) CONSULTATION
Hamilton Lin, CFA is our President and Founder. He is all over youtube (search for wall st training). He personally constructed the industry specific models. The consultation would be done via conference call at a mutually convenient time to be arranged after completion of the Core Model online course and going through the industry specific model.

To order, contact us specifying which industry-specific model and option you are interested in.

5) RESTRICTIONS
The REIT Model cannot be used by more than one person. By placing an order and purchasing the Model, you agree not to distribute the model and to use it only for personal usage. You agree to our Terms of Use, http://www.wstselfstudy.com/reitmodel.html

REIT Financial Modeling (MODEL ONLY!)

($750)

MODEL ONLY, NO VIDEO INSTRUCTION OR SLIDES
Our REIT Model is not yet available in our streaming-video online format; however, we do make it available for purchase. You will receive access to the fully constructed REIT model and blank template WITHOUT ANY VIDEO INSTRUCTIONS OR SLIDES to guide you through the course. We anticipate rolling out our online REIT course towards the end of 2010, beginning of 2011. At that point, you will receive full access for 6 months once it’s online; however, we provide no guarantees on exact timing. Your order and purchase of the REIT - Model Only course implies that you agree and acknowledge this. No refunds or credits provided.

Course Goals & Overview:
Build a fully integrated, scalable, REIT financial model including detailed build-up by internal growth, acquisitions, dispositions, and new development. Consolidate the various business assumptions with Consolidating Income Statement which flows through to the rest of the financial statements. Integrate income statement projections with a self-balancing balance sheet, an automated cash flow statement and the balancing cash flow sweep schedule. Learning objectives include: build detailed, fully integrated, quarterly REIT financial projection model; model various real estate acquisition volume scenarios; incorporate dispositions and relevant adjustments to financials; integrate new development and construction-in-progress assumptions.

Course Sections:
REITs, REIT Terminology and REIT Market:

Overview of REITs, terminology and legal structure (ie UPREIT)

REIT profitability and performance metrics including FFO, AFFO, straight-lining and FAS 141

Acquisitions:

Model out future quarterly projected acquisition volume based on historical trends

Estimate revenue, expenses, margins and NOI

Calculate associated estimated depreciation expense

Dispositions:

Model out future quarterly projected dispositions based on historical trends

Estimate revenue, expenses, margins and NOI

Estimate gross proceeds, gain/loss, net book and change to accumulated depreciation

New Development:

Model out future quarterly projected development starts and completions

Estimate revenue, expenses, margins and NOI

Calculate net change to development properties, construction in process and investments

Income Statement:

Consolidate acquisitions, dispositions & development figures into Consolidating Income Statement

Calculate revenue and NOI including rental revenue and real estate expenses

Calculate total expenses down to EBITDA, Net Income, FFO and EPS

Balance Sheet, Cash Flow Statement and Sweep:

Project investments, CIP, land under development and all asset and liability balances

Calculate CFO (including working capital), CFI and CFF items specific to REITs

Build cash flow sweep to capture any shortfalls / build-up in cash to balance the entire model

Build interest schedule to fully integrate the model

Incorporate capitalized interest expense estimates, convertible notes and share repurchases

What are circular references, why should they be avoided and how to get around them

Prerequisites:

Accounting & Financial Statements Integration

Basic Financial Modeling

Advanced Financial Modeling – Core Model

Video Length / Estimated Total Course Time:
5 hours / 7 hours

Individual Course Price:

$750

Click here to register now!