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?
| +59 | Development Fees > Sponsor Equity Contribution | 18 | 17h |
| +57 | What's an Undergrad to Do? | 21 | 2d |
| +42 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 1d |
| +24 | Mid Sized REPE firm for first job in RE | 9 | 18h |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 4 | 1d |
| +3 | Thoughts on CIM Group today? | 11 | 1d |
| +3 | LDG Development wins $36.3M Lawsuit | 1 | 15h |
| +3 | Debt fund jobs | 1 | 3d |
| +3 | Tishman Speyer Debt Fund | 0 | 4d |
| +1 | Equity Waterfall - Market Standard | 2 | 2d |
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.
Distinctio totam quia quos. Esse perferendis ad aspernatur exercitationem alias eaque modi. Explicabo aut natus ut. Quae nisi itaque molestiae. Laboriosam cumque dolorem repellat accusantium et voluptatum.
Ex tenetur suscipit voluptatum voluptatum. Quidem voluptatem dolores placeat deserunt vel et. Tempora dolor qui molestiae voluptatum dolor ut.
Vel aspernatur illo autem enim. Id molestiae magnam voluptates iusto dolor modi dolor. Fuga numquam voluptatem qui atque quod eos.
Non iste nisi at veritatis unde distinctio. Assumenda blanditiis aut maxime sint labore quo eaque.
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...