I work in a research role for a CRE firm. I work with excel to analyze market trends but I do not get much exposure to RE financial concepts and modeling. Looking for a credible course that will give me that exposure.

 

Consider CCIM - Financial Analysis for Commercial Investment Real Estate (CI 101)

Introduction to the CCIM Cash Flow Model. Learn to apply the CCIM Cash Flow Model to make your investment decisions based on wise investment fundamentals. Some of the concepts you will explore include IRR, NPV, Cap Rate, Capital Accumulation, and the Annual Growth Rate of Capital.

Good luck!

 
Best Response

I wouldn't say REFM courses are fantastic but it's a great resource, no doubt. REFM has tons of material to look at. Kahr Real Estate has his Columbia lectures on Vimeo and Argus and excel courses along with random material. BIWS REIT modeling is OK and you can read the lectures versus listen to them (personal preference).

I just read that your company would pay so REFM, BIWS, Kahr, Realogic , etc all have ARGUS and Excel courses that are good. I prefer Kahr but that was awhile ago. Only REFM has online development and acquisition modeling with course material. BIWS is REIT Modeling. Kahr and Realogic are in person.

MIT has some of their real estate courses online for free but not what you're looking for.

There is also appraisal institute courses that had classes everywhere, webinars, on demand classes. I always wanted to take a construction class from there or Fundamentals of Separating Real Property, Personal Property and Intangible Business Assets. Might not be terrible

 

To contextualize my statement about REFM classes being fantastic: If you go pour over the free materials and move onto the paid material bootcamps 1-3 and get say 3 other classes on acq and development. Learn how to take them apart and put them together - you are going to be in substantially better excel modeling shape than if left to your own devices cobbling together skills from here and there. For $500-$600, with student pricing, you can make a very solid holistic dent in getting from 0 to 1 in your excel for RE acumen.

 
BakersDozen:

To contextualize my statement about REFM classes being fantastic: If you go pour over the free materials and move onto the paid material bootcamps 1-3 and get say 3 other classes on acq and development. Learn how to take them apart and put them together - you are going to be in substantially better excel modeling shape than if left to your own devices cobbling together skills from here and there. For $500-$600, with student pricing, you can make a very solid holistic dent in getting from 0 to 1 in your excel for RE acumen.

This is definitely a good strategy to approach the REFM classes. I took a similar approach and definitely learned alot.

That being said, in-person classes will add an element you can't get from learning online. If you're employer is giving you the time to do an in-person class, I would go that route, whether its through REFM, Khar, etc.

 

If I buy the REFM classes on my Mac, can I move them over to my PC (or vice-versa) or to other computers/onto an external hard drive? Sorry if this sounds like a dumb question, but I don't want to spend a couple hundred dollars on these classes and then find out I'm tied to working on them from one computer. Thanks.

 

Molestias corrupti quasi perferendis quo omnis deleniti. Vel sequi a eum architecto iusto. Id est quis laborum eum possimus sit in.

Totam fuga voluptatem veniam itaque aut. Architecto alias optio aut ratione aut id. Assumenda doloremque eius quod eos ea. Veniam corporis soluta possimus facilis dicta error corrupti. Animi sit dicta est vel quam quia quos.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
kanon's picture
kanon
98.9
9
bolo up's picture
bolo up
98.8
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”