I have a final round coming up and I was told that they will want me to pull a data set from excel like for example rental properties for 12 months and then write a research report on it...
How would I do that. Would I make a pivot table in excel and export it to word and then right an executive summary as to why it's an attractive offer?
I really haven't the slightest idea
Thanks!
| +24 | Hotel Recruiters | 14 | 1d |
| +15 | Rate Hikes | 5 | 1h |
| +15 | Senior Living Modeling Help | 5 | 10h |
| +12 | Leaving Self-employment for Commercial Real Estate Brokerage | 2 | 3d |
| +9 | REPE Analyst Firm Advice | 1 | 18h |
| +7 | KeyBank RE Underwriting | 6 | 3d |
| +3 | What are the best undergrad schools for placing in real estate finance? | 7 | 1h |
| +3 | LIHTC Syndicator Comp | 0 | 2h |
| +3 | BGO REPE LDN | 1 | 11h |
| +3 | Overtime approval | 5 | 1d |
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 think they mean make some charts and paste into excel, but would need exact language as you can link between excel to word. I doubt that is their intention though. I wouldn't use pivot tables, more sophisticated way is to avoid them and use sumproducts, sumifs etc...
Thanks, but wouldn't I need a graph to represent the financial assumption? A pivot table would be that chart?
What do you mean by sumproduct and sumifs? Isn't that just addition?
-D
It is more a question of whether they will look at your excel spreadsheet or not. Pivot tables are more prone to error imo because they require a refresh, while sumproducts, sumifs etc.... .do not. Plus easier to add multiple filters and better for building databases. Really depends what purpose is....
Thanks wish I had more info
https://www.reoworkout.com/pdf/property/info119_4.pdf
I'm going to base my writing like this.
Est ratione natus nemo rerum eveniet. Debitis neque quam saepe est. Veritatis laboriosam tempore libero placeat recusandae aut totam.
Aut eligendi enim repellendus sint sed. Sequi sit repellat fuga culpa eos.
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...