Best way to take the weighted average total net leverage for a group of investments (companies) based on the amount invested per company in comparison to the total dollar amount invested?

Essentially, we want the leverage number to be weighted based on its materiality to the total amount invested.

like
Posting as :
works at
You are currently posting as works at

Something like SUMPRODUCT(leverage , investment) / investment?

Some options could be:
•Try ChatGPT
•Make a pivot table and reference that
•Make a data table and reference that
•Make your calculations on power query
•Use VBA to run your formulas once and hardcode the values into cells, then add a button on your workbook to run the macro.
•Try “rubber ducky debugging”

Related Posts

Trying to open an account on TreasuryDirect to buy i bonds, and I am required to get an authorized certifying officer to sign a form to complete the process to open an account. Anyone know what that is? I went to my bank and asked, they don’t think they can sign it 🧐

like

For a 2-year associate now tasked with senior-like roles such as reviewing and training, does anyone have advice on how to review individual hnw tax returns?

like

I survived 7/15! I prepped and filed 757 tax returns except mine. Time to celebrate with another Lemon Drop

Post Photo
likeupliftingfunnyhelpful

Anyone have any luck selling a condo in chicago using Redfin? The 1% fee for listing is attractive compared to the standard 6% with an agent. Are there extra fees with RedFin that I should be aware of? Looking to sell as quickly as possible so weighing the options and just starting to interview agents and look around for the best way to get my place listed.

like

So what percentage of your income do you spend on housing?

Post Photo
like

Hii sharks 🦈🦈🦈🦈

Can anyone of you please help in calculating how much will be my income tax per month(I am availing the Old tax regime)? Different IT calculators show different figures, not sure which is correct :(

And as for the interest amount in the Savings Account and Fixed Deposits, do both fall under "Income from Interest"? Or under "Other Income"? Or does Interest amount in Savings account fall under "Interest from Deposits - 80TTA"?

The figures are given in the screenshot 👇🏻

Post Photo
like

What is the present value of a government pension? How does one calculate it? Trying to get a sense of weather it's worth moving over to Federal.

like

There’s a debit card that I’ve been using for the past 4 years and it beats out some of the cash back credit cards. It’s the Cash app debit card. I haven’t heard people talk about it in the card community and it could save people a bit of money - 10% cash back. I posted about it on my Instagram HerMillennialMoney if you want to learn my tips and tricks with the care.

like

Anyone have a good PE specialist financial advisor?

like

Who does your taxes? Need a recommend. Thanks.

like

I am a traditional reservist so I never really used military benefits before, but could use advice here.

I am currently renting and my lease is not up until October 2021, however I found a good deal on a home and scheduled to close in June 2021.

My landlord will not work with me to end the lease early, so it looks like I will have to double up on rent and mortgage through the summer.

If I went on active duty orders, can I use those orders to break my lease early without penalty?

like

How much money do you have saved up?😳

like

What’s the most you would feel comfortable spending on rent in BH/WeHo for a 1bed at $250k TC and no debt?

likesmart
like

Joining D soon as manager. Can we use Interactivebroker for stock trading?

like

Any recommendations for best balance transfer card? Like zero APR for 15-18 months and no fee? Also nice to have points or cash bonus

like

For those of you who made your first million in net worth, what did you do next?

like

People worrying today should read books on trading psychology! Not being patronizing- it will help you in the future, not just for investments but for doing better in life!

like

Don’t mix Investment and Insurance.
Buy term insurance in your early age.
Invest mix mode equity and debt .
Ping me for invest and insurance help.
Also get discount price for insurance

like

turns out me and my wife underpaid taxes by 12k. Anyone else getting a nasty end of year surprise?

like

More Posts

Looking for a cleaner! Preferably l
Not to expensive

like

Guys, Anyone know the diff between S&P global, S&P global market intelligence and S&P global capital IQ.

Also, please tell me how it makes difference to a employee (developer)

Hi fishes,
Iam a production support engineer (ETL,JAVA)with 5 years experience and 8LPA. Iam planning to switch my career. Will salesforce be a good choice for me? Please suggest.

@LTIMindtree is offering me onsite opportunity but asking me to work in India 6 months before they actually send me on-site. Is that how it goes ? Also what would be the salary in this case? If anyone has idea it would be great.

likesmart

I’d like to make it a tradition to attend the Presidential Inauguration whenever possible.

Can anyone who has attended before (or lives in DC) offer any suggestions or tips for going: where to stay, how long to go, what to do, etc.

likefunny

Any Capgemini H1B US employees here…
What is the standard procedure to resign? The recommended notice period is 2 weeks but any indirect penalty if you don’t do so?
Capgemini

like

Anyone have any tips or material on effective storytelling to leadership? I have to present an analysis and recommendation to a VP and really need to put together a good story. Thanks!

like

Any freelance ADs want to help my team turn a social hot mess into the social hotness? Post books below or private message me.

Anyone women lawyers here interested in a local get together? New to the area & looking to meet friends, which is hard enough as a busy attorney, and got even harder with pandemic /WFH life. I brought this up in the women lawyers bowl and there were several 🐠🐠 in the Bay area looking to connect!

like
like

New joiner. What should I get with my $250 wfh stipend? I already have standing desk, dual monitor, portable monitor, and good headset, not too sure what else I need, but it’s free money. Thanks.

like

Conflict of interest.
Can a company find out if you start to work for another company? Also, is it really a conflict of interest if you work for both companies in the same position, but the companies are in a different field (e.g. pharmaceutical and social media)?

like

How many hikes are there in Wipro every year?

like

Hi fishes,

Trust everyone is well !
I'm actively looking for a suitable opportunity ( Senior QA Automation Tester) in Singapore which can provide Visa sponsorship as well.
By any chance, does anyone have references in Singapore? I would be available immediately to join the organisation.

References will play an important role in the case of Foreigners in Singapore.
Thanks in advance.

like

I'm a part of PXT team, is it right to apply for diff roles internally at this time?

like

I selected godrej arospace company as IT deputy manager. What do you think is it good for career growth. Plz suggest and my salary band 'O'. what do u think guys

What is the way to get job offer from abroad? Is there are resume is so important to get offer call?

like

What Exactly Happens in the Year End Review, Citi ? going to have mine soon so asking to know what to expect from it.

like

For those who have passed the CIPM exam, what is it like (and how does it compare to the CIPP/US exam)?

Additional Posts in Excel Genius

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

What are your top Excel ninja tricks? Ones that few people know...

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

How long did it take you to become good at excel? Like fast?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal