I've got an upcoming modeling exam for an analyst position at CBRE GI. It's a writing sample, an excel model, and an argus model crammed into a 3 hour window. I'm good on the argus and the writing, just don't really know what I should study for the excel portion. Any advice would be greatly appreciated!
| +23 | SWF/Pension Funds in RE | 3 | 5d |
| +20 | To the veterans: What was institutional dev actually like during the last bull run? | 8 | 23h |
| +18 | Probability of S2 recap returning equity | 9 | 5h |
| +16 | Development vs. REPE pay gap | 8 | 1d |
| +14 | PGIM Real Estate Equity Opinions? | 9 | 2d |
| +11 | PRE MBA IB back to IB | 5 | 2d |
| +11 | Reneging - What should I do? | 5 | 1d |
| +10 | JD/LLM career path to REPE advice | 4 | 23h |
| +10 | Going into RE Entrepreneurship before FT REPE experience. | 1 | 1d |
| +9 | How do I break into a family office role | 0 | 4h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
you're going to get your cash flows from argus, therefore once you drop that into excel you'll need to build out your debt and calculate return numbers, so focus on exporting from argus into excel, getting that export into a cash flows table, building out debt, and calculating IRR/EMx/Profits/etc...
when you say "building out debt" do you mean an amortization table? also, do you think I'll have to do a waterfall for the outputs (IRR, EMx, profits)?
doubt it, but prepared just in case for a waterfall and yes amortization tables that flow into the deal cash flows
.
.
Have the same opportunity as OP. Does anyone here have more insight into CBRE GI? Spoke with a few people on the team but still have some questions about what the group an the position looks like. Core, core +, or opportunistic?
May I ask your credentials? Like how many years experience? Target school?
For a data point, I have 5 years experience at a known company and went to a “target” school, but could get beat out for any number of reasons
Can I ask why you're applying to an analyst position w 5 years of experience? Would imagine it would be a pay cut for you
Of course - better aligns with my interests and the type of work I enjoy.
Do the amortization table. It should take you 3-5 minutes.
Omnis nostrum rerum ullam molestias repudiandae eaque. Earum voluptatem iusto sit veritatis. Porro ut et et natus eum nisi. Sed perspiciatis nostrum eum facilis. Dicta ut quia voluptatem et inventore qui eum eos. Consequatur aperiam quos necessitatibus cupiditate officia velit cumque. Ut possimus quisquam accusamus aut.
Vel ea sit soluta aut cumque. Qui nihil itaque quod et quae qui dolorum. Id sequi natus enim incidunt nemo. Labore vel repellendus eum architecto facere. Veniam quod voluptates et impedit.
Et placeat perferendis quia consequuntur ipsam quas aut quos. Cum amet asperiores quibusdam temporibus maxime non quisquam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...