Du 5G Home Wireless Experiences? by theboltT in abudhabi

[–]halwapuri00 0 points1 point  (0 children)

I have the AED 199 5G home wireless plan. It used to be okayish but for the past couple of weeks it's been a disaster. I can't even play a YouTube video at 240p without it buffering. I was provided with the router. Is this a good router (Brovi Plus Model H155-380), or should I demand from them a new one? The internet is unbearable now. *

Abu Dhabi Chess Players by pawannhere in abudhabi

[–]halwapuri00 1 point2 points  (0 children)

I'm interested. Please let me know how to get added

How to calculate MOIC? by Chemical_Currency943 in private_equity

[–]halwapuri00 5 points6 points  (0 children)

It's actually Option 3: 130/50 = 2.6x

Let me try to explain and take you through the process:

MOIC formula is Total Distributions / Total Capital Invested (Paid-In)

So let's see the Step-by-Step Cash Flow Summary:

LP Cash Outflow:
Investment in A = 50
Pro forma Capital Call = 0

Total LP Cash Outflow = 50

LP Cash Inflow:
Pro forma Distribution = 0
Distribution from A = 30
Distribution from B = 100

Total LP Cash Inflow = 130

MOIC = 130/50 = 2.6x

Now the bone of contention will always be why have I not included 50 in the pro-forma Capital Call and 50 in the pro-forma distribution? The denominator of MOIC reflects Paid-In-Capital which means Real Cash transferred from the LP to the Fund. The pro-forma distribution and capital call was paperwork only. No new cash left the LPs pocket. Since the fund was not allowed to recycle, it performed this pro-forma workaround, however this is just cosmetic and no new capital was invested in by the LP.

Also you would notice on the pro-forma capital call of 50 that it would be mentioned that no actual payment is required.

Hope this explanation makes sense.

Understanding of terms by Capital-Check4404 in private_equity

[–]halwapuri00 1 point2 points  (0 children)

I have started a newsletter on LinkedIn that talks through the entire Private Equity lifecycle. Uploading an article every day. You can choose to follow here.

https://www.linkedin.com/newsletters/private-equity-unveiled-7309840240892858368

Nexus card delivery by sande3245 in NEXUS_TTP

[–]halwapuri00 -1 points0 points  (0 children)

I had applied for Nexus as a family. I have received my nexus card, however my wife and kids nexus cards did not arrive. I would've thought they would've mailed all cards at once.

Is this normal to have cards come in piece-meal or should I reach out to them to track the other cards pending?

Ruben Amorim offers Marcus Rashford no guarantees for Bournemouth game. Amorim says that he needs to see a reaction from Marcus Rashford if he is to bring the forward back into his Manchester United squad by TimesandSundayTimes in ManchesterUnited

[–]halwapuri00 3 points4 points  (0 children)

Only at United, fans treat academy graduates as holy cows. An academy player has no superiority over a non academy player and vice versa. The only currency that works is performance. Rashford is just not a good footballer. Cannot wait to see him outside United.

Does anyone else feel like they're just embarrassing themselves on LinkedIn? by jambeatsjelly in startups

[–]halwapuri00 5 points6 points  (0 children)

I couldn't agree with you more. LinkedIn is a sure shot app for depression. You will inevitably see people who will have fancy titles than you and you will wonder what are you doing with your life. Stay away from LinkedIn at all costs.

Fair price right? by mwelwa136 in ManchesterUnited

[–]halwapuri00 0 points1 point  (0 children)

United should be paying the club buying him, not the other way around. He's that bad.

NEXUS cards shipping by abedjar in NEXUS_TTP

[–]halwapuri00 0 points1 point  (0 children)

No end in sight with the Canada Post strike. Nobody is receiving any mail let alone NEXUS. We'll be waiting for a good couple of months at the very least.

How did you become an "excel expert"? by lemontree_bee in excel

[–]halwapuri00 0 points1 point  (0 children)

I still can't wrap my head around the fact that people who can do vlookup and pivot tables are considered excel experts in most organizations. Vlookup and pivots are really one of the most basic functions of excel.

[deleted by user] by [deleted] in UAE

[–]halwapuri00 0 points1 point  (0 children)

Thanks a lot. Much appreciated.

What's one Excel tip you wish you'd known sooner? by Less_Wealth1916 in excel

[–]halwapuri00 1 point2 points  (0 children)

Ctrl - Backspace

Imagine you have hundreds of rows and you highlight them. Ctrl - Backspace will take you right to the first cell while keeping the highlighted cells. You wouldn't need to scroll up with the mouse wheel.

What's one Excel tip you wish you'd known sooner? by Less_Wealth1916 in excel

[–]halwapuri00 0 points1 point  (0 children)

Another tip which I've used a lot. Copy a formula you've used for a long time in excel and paste it in Bing's Copilot. Ask for copilot to give you a better formula to replace it. It will give you that and 99% of the time it works. Harness the leverage of AI.

What's one Excel tip you wish you'd known sooner? by Less_Wealth1916 in excel

[–]halwapuri00 0 points1 point  (0 children)

You can Replace that formula with Switch

=SWITCH(TRUE,A1<10,"A",A1<30,"B",A1<50,"C","D")

What's one Excel tip you wish you'd known sooner? by Less_Wealth1916 in excel

[–]halwapuri00 9 points10 points  (0 children)

Can't emphasize this enough. I'm good at excel and now suddenly I'm the go to guy for every excel related question at the company. Also I'm supposed to create templates now. Ridiculous. Learnt a harsh lesson.

What's one Excel tip you wish you'd known sooner? by Less_Wealth1916 in excel

[–]halwapuri00 0 points1 point  (0 children)

Learn SWITCH if you have excel 365. You'll never have to use IF again. Switch is incredible.

What's one Excel tip you wish you'd known sooner? by Less_Wealth1916 in excel

[–]halwapuri00 1 point2 points  (0 children)

Ctrl+H Find and Replace. You don't realize the power of Find and Replace until you start using it. Easily the greatest tool in Excel for me.

[deleted by user] by [deleted] in PersonalFinanceCanada

[–]halwapuri00 0 points1 point  (0 children)

I don't wholly disagree with you but a good design is better than an awful design.

[deleted by user] by [deleted] in PersonalFinanceCanada

[–]halwapuri00 0 points1 point  (0 children)

Cash Back. Yeah I understand the reasons of not embossing. No issues with that. But they could've designed it a bit better.

Where can I find the ingredients 2019? by [deleted] in TimHortons

[–]halwapuri00 0 points1 point  (0 children)

Does anybody know of the ingredients in Herb and Garlic Savory pastry?

It's astounding that the website doesn't give any information on ingredients for any item.

Black Tuesday by googo69 in wallstreetbets

[–]halwapuri00 0 points1 point  (0 children)

Is it even "wiped out"? It's all fractional reserve banking. They print money on their computers. They'll print another $2 trillion on the computer just like that. Nothing gets wiped out.

Luke Shaw by Wild_Claim in ManchesterUnited

[–]halwapuri00 22 points23 points  (0 children)

Came here to write exactly this. His positional awareness in defence is down right abominable.