1 Hr excel test coming up. Im expecting being asked to construct a basic cash flow model (prob multifam) either by giving me assumptions, or going off an OM. Prob a debt table as well to get to levered/unlevered irr . Thoughts?
| +38 | Where are free agents signing? | 19 | 10h |
| +31 | Laughable Job Posting | 11 | 13h |
| +31 | What Is Your Backup Plan? | 17 | 1h |
| +28 | Future of Real Estate | 8 | 13m |
| +25 | AvalonBay Equity Residential Merger discussion | 10 | 2m |
| +16 | Extremely Slow Ramp Up | 1 | 1d |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 1d |
| +10 | Dynex | 5 | 3h |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 2d |
| +6 | Heitman - Chicago | 7 | 10m |
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.
I would expect all of that on the instructions sheet for the test, but what you can get done in an hour will depend on the scenario they give. Realistically these Excel tests are to see if you are detailed, not faking your Excel skills, and have a clue about the Excel modeling for the industry. Without knowing your Excel ability, focus on making a model with inputs that flow throughout the workbook into cashflow and returns.
Omnis quidem qui rerum aspernatur cumque. Ut rerum nihil ut rerum non. Alias officia reiciendis doloribus sint.
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...