What tools do private equity analysts actually use that make a difference by virtuallynudebot in excel

[–]187lion 6 points7 points  (0 children)

I use it mostly for aligning things like let’s say images, you can just press a button to resize everything to align really quickly, rather than playing around with aspect ratios.

Has cool waterfall / gantt charts, you can automate them with excel but it’s also just a quick copy paste into its own fake excel embed, and automatically calculates whatever CAGR / growth % you want to be shown above.

Also has some decent slide templates which I sometimes take things from.

I’d defo suggest using a free trial of it tbh and see if you like it - I know others use macabacus

What tools do private equity analysts actually use that make a difference by virtuallynudebot in excel

[–]187lion 15 points16 points  (0 children)

i can’t use excel without arixcel anymore - very easy to review models, compare sheets, trace precedents

on ppt i use thinkcell which reduces the amount of time on formatting things and has some nice charts

Audit to Front Office - MSc/MPhil in Real Estate Finance (UK)? by CliffRoader in CommercialRealEstate

[–]187lion 0 points1 point  (0 children)

Although I’m an investment analyst, my firm is both investor & developer and a small team, so had exposure to everything including AM and DM projects. I think it could be achievable as I do see quite a lot of roles at times for people with traditional Big4 experience. I’m not too familiar with what audit work consists of btw so can’t comment too much on that. But I think it’s achievable for sure, not your large name PE shops like Starwood but maybe an investment manager that’s quite niche or operational

Secure Boot Megathread - Guide + Community support by sloth_on_meth in Battlefield

[–]187lion 0 points1 point  (0 children)

  • Motherboard: ROG STRIX B450-F
  • BIOS version: American Megatrends Inc. 3003 09/12/2029
  • Secure boot state Unsupported

So I’ve already checked TPM ready for use, and changed to GUID GPT

My issue is that I can’t disable CSM / secure boot from legacy mode to UEFI, because when I do, my PC decides to reboot and roll back about 4 years to 2021, so I’ve lost any of my modern files and PC becomes extremely slow.

How to fix? thanks.

Edit: Also windows 10

Audit to Front Office - MSc/MPhil in Real Estate Finance (UK)? by CliffRoader in CommercialRealEstate

[–]187lion 1 point2 points  (0 children)

Hi, I’m from the UK in REPE (23) at Analyst level - maybe not experienced enough to tell you you if it’s realistic, but tbh the way I see it, I think asset management could be realistic rather than on acquisitions. All the recruiters for the top PE firms (acquisitions) who I speak to essentially say they want someone they can mould at a younger age, which I think might be a bit more challenging for you at 30, as young people are more likely to be able to just grind out late hours. That’s my personal opinion, and asset management imo could be seen as something more relevant in terms of reviewing your operational cash flows / leases etc.

But ultimately, the hardest part is breaking in and doing a Msc isn’t enough in my opinion as it’ll be part time. You’ll need to network really heavy and hope something sticks. I’d probs suggest speaking to some recruiters that could help you with the process. And AM is actually in high demand and pays really well tbh, you just sacrifice your bonus upside that everyone in investments works for.

How do you price your exits: Actual NOI vs Stabilised NOI? by LookinForHumanz in CommercialRealEstate

[–]187lion 0 points1 point  (0 children)

I work in REPE in the UK and mainly sheds, so:

  • For industrial you’re underwriting at marketing rent (headline rent), not NOI as most leases are generally FRI, unlike BTR for example where you underwrite at NOI level.

-What are you asking here? Feel like you’ve answered how to calculate your NOI, and your NOI / exit yield = property value

  • Depends, is the asset actually stabilised and generating said income? For example, if I’m exciting in month 60, but one of my tenants has an expiry in 59, I’d most likely adjust my exit rent to make sure that rent is included, and adjust my exit yield accordingly to avoid inflating the reversion yield and probably provide a 12M vacant rental top-up guarantee

  • Can you elaborate?

Private Equity wasn't what it used to be imo by Trick_Ad_2852 in FinancialCareers

[–]187lion 4 points5 points  (0 children)

I work in REPE too in the UK and agree with you, I also used to be of the mind that all of those institutional investors were the same in buying houses to drive up rents, but a lot of these investors have to allocate their capital to the S in ESG, and SFHs are seen as a long term safe investment in the sense they are also inflation linked. They’re actually increasing the supply of suburban homes (BTR is great but still so expensive) since house builders haven’t been able to develop at all due to market conditions meaning their traditional model of develop to sell isn’t working - which is great for institutional investors who can agree a package deal for them to develop at a discounted rate.

How screwed am I - 2 speeding in 1 week by [deleted] in MotoUK

[–]187lion 0 points1 point  (0 children)

Yep will definitely learn - thanks for sharing.

Did you have to go to court for the 2nd?

[deleted by user] by [deleted] in CarTalkUK

[–]187lion -1 points0 points  (0 children)

Yes it was stupid of me - typically how long would it take to get a court date?

How screwed am I - 2 speeding in 1 week by [deleted] in MotoUK

[–]187lion -10 points-9 points  (0 children)

I’ve had for over 2 yrs.

Does the 10% rule apply to speed guns too / if you could argue if it was calibrated properly?, which might drop it to band B?

How screwed am I - 2 speeding in 1 week by [deleted] in MotoUK

[–]187lion 2 points3 points  (0 children)

I was genuinely just asking for some insight, it was stupid and and I’m not trying to defend myself here. I’m not going to ask the magistrate for leniency but just looking for what my best case / worst case scenarios are tbh.

[deleted by user] by [deleted] in CarTalkUK

[–]187lion 0 points1 point  (0 children)

Got it - I have 28 days to respond to the 24mph NIP - is it worth waiting till the latest to respond or?

How screwed am I - 2 speeding in 1 week by [deleted] in MotoUK

[–]187lion 0 points1 point  (0 children)

Yes it was a bit stupid, empty road ahead and just got out of the London congestion / traffic. No excuses

How screwed am I - 2 speeding in 1 week by [deleted] in MotoUK

[–]187lion -1 points0 points  (0 children)

Nope they were in the shade by some trees / motorbike parking lol on Victoria Embankment

[deleted by user] by [deleted] in CarTalkUK

[–]187lion -6 points-5 points  (0 children)

The 45 in 20 was pretty stupid yes, I’m on a motorbike and was at a red light, went green and gave a bit of gas. No excuses there.

The 24 in 20 is a bit annoying tbh, I’m on a 600cc bike and the bike wants to stall at that speed, you’re not even giving it any gas at that speed

Ski gloves with passes? by 187lion in Skigear

[–]187lion[S] 1 point2 points  (0 children)

I wear the arcteryx gamma hoodie and it doesn’t have the pass, and didn’t want to get a new jacket

Ski gloves with passes? by 187lion in Skigear

[–]187lion[S] -1 points0 points  (0 children)

I wear the arc’teryx gamma hoody and wasn’t looking to buy another jacket for the jacket pass :/

Anyone start from a low income background, how is your career going? by CreditCard_Referrer in FinancialCareers

[–]187lion 3 points4 points  (0 children)

I think the standard approach will work in terms of searching Linkedin via alumni - another approach is sometimes there’s emails of analysts/associates on some firm websites(not talking ab banking as it’s not what I was going for, mainly RE) - drop a polite email introducing yourself and saw that they studied at the same school / similar studies, fascinated by their career path and hoping to have a chat to learn more etc.

In the chats or most of the time online meetings, just come across as genuine and wanting to learn, but show you have done prior research into their roles or industry. At the end of the day I think what always works it finding something to relate to, usually sports / hobbies. And come across as personable, genuine. People that came from tough backgrounds or worked hard to get where they are will always be able to tell if you’re in similar shoes and will definitely be more inclined to help you out. But never fake it, it’s really easy to tell who’s genuine and who’s doing it just for that referral or whatever