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?
| +21 | Being a 100% Disabled Military Vet Pays as Much as RE Analyst Seat | 16 | 7m |
| +20 | Rate Hikes | 14 | 10h |
| +16 | Senior Living Modeling Help | 5 | 4d |
| +9 | What are the best undergrad schools for placing in real estate finance? | 16 | 1d |
| +9 | REPE Analyst Firm Advice | 3 | 1d |
| +8 | Hard Money Lenders? | 1 | 1h |
| +4 | Overtime approval | 7 | 1d |
| +3 | BGO REPE LDN | 1 | 4d |
| +3 | LIHTC Syndicator Comp | 1 | 3d |
| +1 | Question on being paid a fee for bringing a developer a site | 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.
Repellat soluta quia illum quia expedita sed. Autem natus sit dolore sed repudiandae eaque. Adipisci et ad quae dignissimos laudantium fuga officia. Iste dicta aliquam maiores in sunt. Itaque dolore voluptatem esse animi. Occaecati corrupti voluptas exercitationem voluptatem perferendis et inventore iste.
Maiores natus sit esse aut corporis autem. Quis dolorem autem est officiis. Sint ut omnis dolor temporibus qui aliquid nisi aliquam. Consequuntur distinctio non sed aut non dolor temporibus. Cum doloribus sequi veritatis consequatur dolorem a tenetur.
Neque quo delectus et omnis aut in ad. Voluptatibus quas in nam dolores vero blanditiis. Aut similique laboriosam neque.
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...