My apologies if this is vague but trying to do an interest expense analysis which includes three different forms of debt. Any suggestions on how to show this? Each is tied to a different rate

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

Each instrument has its own debt schedule (beginning of period, repayment, end of period, interest payment). Total interest payment is then sun of parts.

likehelpful

Agree with above, you can do one tab for each debt schedule and then a summary tab which sums the interest for each period by adding the components on each support tab.

Agree with the above and then you can also do a weight average blended interest rate if you want one clean number

I have a calculator that can help with this. PM me and I can send it over to you.

Related Posts

Is life insurance a priority to anyone at the moment, and if so why is life insurance important to you?

It can be impossible to deal with financial losses due to declining health or unforeseen circumstances by not having life insurance. In these cases, the solution to your debts (that can affect the financial stability of you or your loved ones) may fall within the category of life insurance.

Post Photo
like

Working on a take-home case study for a direct lender, I was given a public company take-private scenario and build a model around it, want to get you guys thoughts on whether I should include a few pages on historical financials?

like

The amount of froth in this bowl the last week is making me want to throw all my on-chain models out the window and sell my bags. People here posting about “gains are so easy” “I’m going to be rich” “should I sell my 401k to buy ethereum?” “Anyone long API3?” “I bought link at 30 and it dumped to 29, should I sell?”. Froth meter is at an 8/10, just like October 2017.

like

Hello all! Is anyone working contracts/per
diem under an LLC? I'm interested in
getting started along with my full time
job

likesmart

Can we reimburse internet bill in Verizon ? How much and where should we look for it?

likesmart

I’m looking for recommendations for a bench top bandsaw. I’m willing to invest in a nicer one down the line, but right now I want to keep it under $300. I mostly see Powertec, Shop Fox, or Wen. There is a $375 Grizzly I’d consider if it’s way better than the others. Any thoughts?

Question regarding tax saving -
I had bought medical insurance for my my parents and I on 17 Feb 2022 with 38K premium. Can I add this deduction in FY22-23 tax declaration.
PS - I have to show proof of payment by Jan 2023 and the next premium won't be paid before Feb. So how do I use this insurance for tax savings?

like

I am 29F and earning 13LPA. I have been working for 4 years of which 3.5 years I had very low pay and close to 0 savings. I have been able to save 6L now.

My investments below:
* Elss funds - 2 (total 1.5L annually)
* Large cap mutual funds - 6 (total 40K sip per month) current portfolio of 4L
* FDs - 2 of 25K each
*Medical insurance - company provided

Can someone advice if this is a good investment plan for future? What can I do better? Do I need another Insurance? Where else to invest?

likehelpful

I just got this month salary and there was income tax in deduction, for last few months there wasn't anything of that sort.

How frequent does income tax deducts - one time(yearly), quarterly, half year or monthly?

like

Any great personal finance/investment books to read? Or even YouTubers/Podcasters

Really looking into expanding my investment horizons — particularly about learning about how to allocate my investment portfolio. Also, always nice to learn about better ways to save and cutback.

like

Does HSBC support certifications like CFA, FRM? Do they reimburse it?

Is there any benefit in PwC India when a person travels to client location within india. May be on deputation for 2-3months. Is there any extra perks, accommodation given along with travel expense? KPMG India Deloitte India

like

Freelance creatives, how do you get medical/dental coverage and insurance (assuming you're not relying on a partner with coverage)? Or do you pay out of pocket for each expense?

like

Hi All,
I am a new joiner to TCS. My wife is pregnant (4 months completed). Can I claim her delivery expense. Please advise.

like

Does Infosys reimburse Internet bills for resources who are working from home??

Also does they provide any extra miney to setup home office, like for chairs & tables?

Trying to save up for a down payment on an investment property. Would it make sense to remove my 401K contribution for about 6 months to gain an extra $4K or is that stupid? I’m 23 and have no experience, just wanted opinions

like

Hi guys, I have got an offer from Verizon. Role: MTS-3. Package: 21Lakhs (Fixed) + 12% Variable pay + 45 days of monthly salary as relocation expense + 50,000 joining bonus. YOE: 5.6 Years. Does the package look fine or shall I negotiate further?

Hello guys ,



I ordered office chair a week back under well being subsidy it is delayed again for 3 days so meantime can I submit the expense before delivery or we need to wait and submit only once it is delivered?
Can anyone respond.

like

In MBB / T2 market in SEA what would be the net take home ( in USD post tax w/o adjusting to cost of living) relatively to each other . My sense is that if we take Singapore of index of 100% of net income for the level than:
1) Indonesia 70%
2) Malaysia 80%
3) Thailand 75%
4) Philippines 65%

like

Best way to redeem UR points? If answer is travel, how do you know you're getting a good deal?

like

More Posts

Thoughts on moving from M&A Consulting to Investor relations at a public company (not fundraising for a fund)? Thinking mostly about finding a balance between an interesting job and having a life.

I've seen consulting is not a traditional background there; anyone made/tried to make the jump?

like

Anyone have experience or perspective on whether or not real estate investments are a good hedge vs inflation?

like

Please help him with referrals.

Correction: TC 51.3 has 15% variable.
Experience: 11 years (Marketing & Brand Manager)

Location: Bengaluru, Karnataka

#mba #marketing #branding #layoff

Post Photo

How to frame answers in a lateral interview with a direct competitor for why leaving? Don’t want to sound negative about current firm, but real answers are culture-related

like

Wondering if Adobe actually pays 75LPA CTC for computer scientist position for 4 yoe?
People in my city are promoting this for their son to get better "rishta" and one can imagine what my parents are feeling about me :)

funnylike

How has the interview experience been for people appearing for roles with the People Advisory practice of EY GDS?

like

What’s the least amount of time you’ve stayed at a job before leaving and why? Was it ever an issue in the future?

like

Are there any executives out there who have recently negotiated with their CEO for an updated compensation package? I know I'm being underpaid as a CFO who has also handled all of the HR responsibilities for the past 3 years. Currently at $130K with $30K bonus at the end of the year. I don't take the insurance through the company either. Currently no 401K match program available.

A few alts are managing to move against the tide atm, though, at least... QSP, AST, MTH, RHOC.

like

What hybrid firms out there do both restructuring advisory and principal distressed investing? Know there’s a few from posts on here but having trouble finding names

like

Is there anyone who have been in the same organization for more than 5/6 years??

like

Have an offer at ZS for Manager and IQVIA as Engagement Manager. What would be better in terms of growth in future?

like

Just realized I’m going to eke out UA Plat on 17 flown segs this year. Efficiency at its finest.

like

Is anyone else trying to buy a condo or townhouse? I’m targeting a 2BR in LP/Old Town and am struggling...everything decent is snatched up super quick; haven’t fallen in love with anything I’ve seen. If anyone is having luck can you shoot over some recommendations or maybe a good realtor? Also need to be out of my apartment by 6/31 so time is running out. Should I just hold off buying or try to stick it out?

like

What's the easiest way to crack into tech coming from consulting? Do I need inside connections? Can my background translate? FWIW I do have tech experience

likesmart

Recently, we are seeing 2Cr+ packages being offered to IITs fresh graduates.

I'm wondering
What are the special skills IITians possess that they are par from even 10-15Yoe in other companies while being freshers only?

What work will they do at such companies that they are being offered this much?

What non-IITians with experience should do to get similar salaries?

While I'm aware that ~$100K is average to good salary for fresh graduates in US but some companies offering similar in India!

like

How’s the Montreal office? Visiting tomorrow from NYC. I’m in Brain, DM if you want to holler :)

like

Is there a legal way for an international student in the US to earn money on the side?

like

What are your policies on cameras in Zoom calls? My weekly meetings feel like I'm just monologuing in front of my team.

like

Omg is anyone watching ? Use this thread and for those who are not don’t read bc I’m gonna post SPOILERS

like

Additional Posts in Finance

Has anyone taken the CAIA exam recently? Currently studying for lvl 1 but not too much commentary out there.

like

My $10,000 bonus came down to $6,200 after deductions. Does that sound right, almost 40% withheld?

like

My fishbowl love score is 546, and I'm really amused because I'm pretty sure that if you guys & ladies had met me IRL you wouldn't have even considered talking to me 😅 thanks folks.

like

Where are some of the best places to recruit research analysts for a hedge fund? Dont want to give out alot of info here -- but what web pages and other sources do people use?

like

What value does CFA add if you’re on the technology and/or Risk Management side of finance? Specifically unsecured lending.

FWIW, I already have an MBA. I’m just contemplating the CFA to boost my resume.

like

Will the pandemic actually lead to permanent changes in business continuity/operational risk management, or will companies fall back into their old ways after this is done?

like

[Expats] How many of you have requested an absentee ballot?

like

Whats a reasonable amount of time to put towards studying for series 63? I passed my 7 two years ago and am now just getting around to it

like

Does Citi usually drag their feet with the offer process? I received an offer two Fridays ago and the recruiter went to the hiring manager with my salary request. They countered my salary request last Tuesday and I countered back in between both numbers (only a $5000) differential. I reached out to the recruiter yesterday and she said she would get back to me very soon. Wanted to make sure I’m not in jeopardy of losing this offer for negotiating? TIA

like

If you could work for anyone on the street, who would it be?

like

I literally can't remember the last time I went grocery shopping. It must have been years...

like

Good morning let’s have a beautiful Thursday. Here is my question I want to somehow break into Asset Management and I am having a hard time doing it. I have 1-2 YOE and Finra Licenses SIE-6-63. In all honesty I just want a better pay and avoid taking calls all day, I’m fine with a few calls a day but back to back calls is exhausting. Thanks for any tips!

like

When overwhelmed with workload/too much activities on your plate given by multiple people, how do you guys phrase the communication n respectfully decline new task to minimize negative perceptions?

I think my MD got to where he is now based solely on flattery and politics.

like

Anyone know any good book recommendations that help improve your financial analysis skills?

like

I'm addicted to my phone and social media. Need serious intervention/help. Suggestions?

like

Junior bankers in NYC — are y’all even allowed to get tired? Are you legit productive 90% or more of your day, EVERY day?

like

For new hire who’s struggling, will going back to office actually makes things better and easier?

like

What are some side-hustles you do in your free time?

like

How did you know when it was time for a change in your career?

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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