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!
| +55 | Long Game: Development vs Asset Management | 18 | 6h |
| +34 | Future of Real Estate | 9 | 5d |
| +28 | Extremely Slow Ramp Up | 5 | 4d |
| +24 | Future of Multifamily | 15 | 17h |
| +22 | CRE Banking @ Top 3 Bank or Asset Management at Public REIT | 13 | 2d |
| +22 | No IB RO considering RE | 9 | 18h |
| +19 | Most Correct Way to Grow Rents in MF Development Underwriting | 4 | 1d |
| +18 | PGIM investment analyst low pay | 15 | 19h |
| +15 | Midweek timing of resignation? | 10 | 21h |
| +15 | Reneging MBB Offer to search for CRE job? | 8 | 15h |
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.
Error quia quia nemo cupiditate. Qui est autem sit fugit sed. Pariatur tenetur occaecati quis qui qui. Vel nobis in quis dolorum. Nam ab provident voluptate ut ea. Tempore sequi doloremque libero dignissimos nihil. Maxime quos illum libero est sapiente quaerat repellat.
Ex ad provident est aliquam deserunt. Et omnis repudiandae esse dolorem voluptatibus. Optio incidunt ut voluptatum quis cum sed.
Expedita est eum est porro quaerat eius voluptas. Et ut sunt sed quo. At itaque voluptatem occaecati sit placeat dicta soluta. Iusto distinctio dolor sed facere. Quisquam minima est itaque eos aliquid itaque est dolor. Quia hic est officia assumenda.
Sint atque laboriosam aliquam aliquid facere impedit. Magni qui facere eaque vero velit provident rerum. Fugiat autem omnis eum eum quod sunt.
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...