GSAM AIMS VS LASALLE INVESTING ANALYST
What would you choose between doing GSAM AIMS (secondaries, primaries, co-investments) and LaSalle Investment Analyst role (Direct investing)?
GSAM
- higher base
- brand name
LaSalle
- Direct Investing
- Maybe better exit opportunities (?)
GS better name and definitely better exit ops even considering the difference in roles
GSAM and it's not even close
Can anyone please share what does this mean
model, in excel, a portfolio of amortizing loans and calculate key profitability metrics? What can one expect in this modelling interview?
Bruh how desperate are you spamming this everywhere?? What if it’s loans that get paid back over time and you need to calculate the moic and irr of the portfolio?
I am! Is it possible you can help what and how can I proceed
Proceed with what? Is this a modeling quiz?
assume each loan has an amortization rate. So if 10%, then a $100 loan will be paid down by $10 each year. Starting balance year 0 is 100, year 2 is 90 and so on. For the fist year take the average of starting and ending balance (100 and 90) = 95 times coupon is income for that year. Roll all this forward to maturity where loan is paid off
your irr starts with -100, ongoing values for coupon, and then ending balance for last year (50 if 5 years). It should be in the ballpark of your coupon. They may ask you to thrown an oid on there. So if your oid is 2% then the irr math is the same, except your day 1 outflow is -98
Thanks so much!
.
Et neque totam eum vitae similique. Sint sapiente qui consequuntur iusto quo. Quas minima provident in rerum nobis qui et. Ratione ut aut autem laborum. Est doloribus maiores veritatis aut minima qui autem.
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...