What excel formulas do syndicated loans analyst use? Or atleast should know

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

PMT
FV
RATE
NPER
PPMT
IPMT
CUMPRINC
CUMIPMT
XLOOKUP (apologies folks, couldn’t resist…)

likefunny

Thanks!

like

I learnt from this. Thanks

like

No problem, bud - here to help

Related Posts

Roth vs Traditional 401k, thoughts?

like

Which accounts have you opened for investment? ROTH or traditional? Any benefit over having one or the other? And any preference on where should I open one?

like

Looking for a lawyer for get prenup done. Any recommendations will be helpful

likefunny

Pre-approved for a home but the rate lock expired and now we have to re apply. My husband lets me know his credit score dropped 111 points because of credit card utilization. Even if we get it below 30% ( which we can) not sure it will quickly reflect. I also added him as an authorized user on a high limit credit card I have. Any other suggestions besides trading him in lbs

like

Frustrated by paying so much tax!

like

Is the opportunity cost of living in a “luxury” apartment worth it? Say $1500/month. For context, 100k salary living in Chicago and really not sure what my budget should be. No debt or other major expenses.

like

Hi fishes, could any one help me on how to withdraw of money and how much can be withdrawn ?

like

For those who work in Manhattan, do any of you live in Hoboken or Jersey City? Want to move to the area but want to be able to save money on rent for a little then move to the city.

like

Thoughts on Transfix? Anyone invested?

like

If I’m a Real Estate Agent buying my own property, can I negotiate the Buyers Agent commission to be 0% instead of being paid the buyers commission? Essentially converting what would be Income into Cost Savings for tax purposes?

like
like

Hoping to earn rental income. Any good advice or resources on getting started? What’s your experience been like? Thanks for sharing in advance!

like

So if I short a position in my rollover Ira- and buy different stocks. I won’t pay taxes on it?

like

25 and a year into having a brokerage account. How does one build a strong portfolio? I’m currently doing well based on stock picks but understand that it’s really just luck based on this rollercoaster year. Holding for the LT

like

Is there a calculator that I can put in all my investments and see how it works out in 50 years? I know each brokerage has their own projection thing, but just wondering if there are any other tools where i could combine everything?

Anyone have a carry payout model they can share? Trying to build a few scenarios

like

Can someone tell me where should I put my money, Roth or traditional? Should I also contribute to hsa? How do I max out all contributions and benefits?

like

Which credit card do you think is the best for ME consultants?

like

NRF matched Millbank in TX yesterday

like

More Posts

Happy Monday! Heads be rollin today 🙃

like

Advice on taking and passing the SPHR exam?

likehelpful

Is a 900k net worth for a single person at almost 40 good or terrible? I see posts from our US counterparts on net worth and salary and feel so behind yet we have such a high COL in Toronto.

like

Mercedes-Benz Research & Development India If I like a girl in office, Can I approach her directly or via social media or via teams?Tata Consultancy Infosys EY KPMG Mercedes-Benz Research & Development India Volvo

likefunny

Has anyone used an online accountant/back end company to manaage all of your invoices, billing, taxes, etc?

I’m debating using Collective or Bench but would love real reviews.

like

How's the policy in the natwest in terms of return to office. How many days it is compulsory to visit office. Is there any work from home policy there?

like

Hi, any inputs for how the interview case study round for a solutioning domain @fractal.ai is?

like

Hi all,

Does anyone here work for
Capital One please ?
I need referral for a role.
I’m happy to share my CV and discuss .

Thanks in anticipation !

Need all opinions I can get. Interviewing at a place, and there are a few flags. (Details in 1st comment)

like

My office location is in Marathahalli and offices are starting from Jan. I am shifting from Mumbai to Bangalore due to work demand. I will be moving with family. What would be the ideal location for me to search flat. I prefer gated community with amenities inside as I have small kid and can take her in the park than going out. How would the rent be? One of my friend has a flat in Ecity gated society with 25k rent. Where can I search for similar society within commutable distance. This is 20+km

like

Is direct lending/private credit technically buy side?

like

Will switching from kpmg into industry before I apply for MBA hurt me? I'll m considering a role in IT risk but I don't want my resume to look weak when I apply to b-scbool

like

Any book recommendations to gift my cousin sister? She studied (masters) psychology and is a trained classical dancer.

like

In the beginning of my career I absconded 1 company who had 3 years bond and I worked there for 5 months. My pf account is created for that company and it has been closed with reason cessation (short service). After that I worked in 1 company for 6 years and since January I'm working in TCS. Should I mention my first company experience. So far I'm not mentioning it anywhere.
Please help me out with this
Requesting you to like the post even if ur not able to help so that it reaches to more poeple

like

How do I measure what I'm "worth" in the market? I know YOE play a role, but I don't know how to measure based on perf or whatnot. What makes one person worth more than another for the same role?

like

Hi There, I’m a Senior freelance Digital PM/Producer based out of Toronto, Canada. I figure with remote work being the norm now, there would be more opportunity to collaborate with US agencies. Has anyone had the experience of doing this? I know some agencies have strict hiring protocol but I am incorporated. Any advice would help! Thank you

like

Going to take my shot on here:
Does anyone know the name of this Chinese restaurant connected to a run down hotel in DC? Supposed to be one of the few authentic places.
Best Chinese food ever.

like

White fuzzy mold all over my pothos' soil. What's going on and how do I fix it? Already lost 2 leaves and I'm assuming this mold is the cause.

like
like

I have to support my family financially. Usually my mom cooks for the family so groceries only cost $1200/month. However, my mom is abroad for 2 months so it’s just my siblings and they can’t cook so they’ve been using my card for doordash. I think there are days when they spend $100+/day. It’s frustrating because my mom already told them the daily budget repeatedly. I’ll go bankrupt at that rate. However, it’s not like I can take my card back since I don’t want them to starve…

likesmart

Additional Posts in Finance

Do you wear a suit to work every day? How formal is your office?

like

Has anyone seen Doctor Strange yet? Thinking about going to the cinema for the first time in years :)

like

Working in Risk Management, looking into the FRM exams. Does anyone have any insight or advice?

like

Two missed calls from our fearless leader. Either this is social engineering or I’m more important than I thought I was

Post Photo
like

If you were offered a partner position now, but it required working until a typical retirement age (65 y/o), would you do it?

like

Has anyone done the GARP Financial Risk and Regulation course? Was it educational? Did you do the FRM after?

How can I wear a backpack without wrinkling the shoulders of my dress shirt? Iron every night and they get wrinkled as soon as I put my backpack on.

like

I am investing as a beginner. What is a good company to start a brokerage account with ? Fidelity, Ameri E Trade, ML? I’m looking to put my money in index funds.

like

what happens if you don’t pay back sign on bonus and leave before clawback period?

like

Stuck at the airport, my flight has been delayed -- it's going to be one long and shitty night.

like

Has anyone else turned down a tech job for banking? It was a hard decision but ultimately, I decided that the experience and training I'll get here is second to none. Hope I don't regret this decision

like

Hello!
I'm italian, 26 yo and currently working in France as financial analyst.
Work environment is great, friendly and multicultural but I don't like the job at all.
Personal life is not so nice since I manage to see my family and gf every 30/45 days only. Colleagues have their own lives and at the end we don't hang out much.
My dilemma is:
A) going back to Italy at a lower salary with less growth opps but better personal life or
B) Switching my job here and hold on

What would you do?

Thx! :)

like

The Monday struggles are real.

like

Best GMAT study plan?

like

Is this the end of days for our love affair with cryptocurrencies?

like

Another week of models and bottles... And by that I mean excel models and bottles of 5 hour energy

likefunny

Any one work for anyone work for LPL Financial that could share their experience with the company? Looking at roles within the firm and curious to see how flexible they are with remote work and starting salaries for AVP

like

Anyone hear of JHB Search?

like

What's your morning commute reading material?

like

How do you lead a morally fulfilling life while being in this industry? I’ve been battling with this question as of late.

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