Related Posts
Hi fishes,
Why TCS is so rude and self proclaimed kinda. I declined TCS offer last year as they were giving very less CTC. Now I got interviewed again with TCS and cleared all the rounds but they are not reactivating my ibegin portal for document upload since I rejected them last year...in this way u think they will never ever reactivate my profile.
Tata Consultancy
Have my interview with UBS pune for Java 9 years experienced.
What would be the interview process and anything specific I should prepare for?
HR has said first will be pen and paper coding round, so what kind of problems can I expect?UBS Business Solutions (India) Private LimitedUBS Business Solutions (India) Private Limited
Can anyone at Amex share my resume in their team to directly start the rounds of interview? I have tried for referrals through linkedIn and did not recieve any call from the HR.
29th Apr is my last working day in my current organization.
Tech stack: SQL, Tableau, Python, Excel, Powerpoint with more than 4 years of experience. Currently have an offer of 23 LPA fixed. Fixed anything above this or equal to would work. American Express American Express India Campus American Express Global Business Travel
More Posts
Additional Posts in Asset / Investment Management
I tutor for cfa if anyone needs help.
Has anyone taken the CAIA ? Any tips ?
New to Fishbowl?
unlock all discussions on Fishbowl.






Look on youtube RE model how to’s and mimic those step by step but with your case study and assumptions. Your model doesn’t have to be perfect, it just has to have the right “thinking” behind it such as why rents are increasing the way they are, returns analysis (IRR, Cash on Cash, Total Profits). Most importantly make sure you add a waterfall analysis as thats where the real cash is made in RE. Most of the time these take home models are meant to show the interviewer that you know the principles of RE and how it works, demonstrate your excel abilities, and presentation skills. The model doesn’t have to be perfect, the fine tuning comes after you get the job.
Start simple - build a annual cash flow then trend it (construction funding + negative carry cash flow) then lease-up followed by stabilization. Run all the debt and return metrics
If you still have time after this simple model (mostly straight-line), build a two tier JV waterfall. Pro-rata ownership (ex. 95/5) for the first hurdle to 10% leveraged IRR, then 90/10 (or a different split) thereafter. This should be enough to demonstrate your thinking and excel skill. Feel free to PM