Showing results:
Displaying 1 - 50 of 378
Software that dynamically aggregates multiple Excel financial models into one
I came across a bottleneck in excel. I've been trying to use it to aggregate sometimes 50+ financial models into one dynamic model. This is a situation where there is a HoldCo at the top that has many subsidiaries that each have their own financial models. I need something that will combine all of...
Favorite excel shortcut and its application in modeling/other finance applications
Alright, fellow spreadsheet aficionados, gather 'round for a tale of financial finesse and shortcut sorcery! Picture this: you're knee-deep in the labyrinth of Excel, navigating cells like a seasoned adventurer. Amidst the chaos, there it is – the mythical Ctrl + Shift + $! This arcane combination...
Tasked w/ creating an Economic Trends/Forecast Excel Sheet
Intern here, manager wants me to make an excel sheet to forecast and show economic trends. There is stuff on YouTube but I wanted to see if anyone has done something similar for their job or personal use. Any recommendations or sources I should check out?
CAP IQ Formula Question
Coming from FactSet, and our firm is looking to change to Cap IQ. Is there a way to pull a formula for the Percent Discount or Premium paid in an ECM Offering. For Example - a Registered Direct Offering priced at a 20% discount to market close of the previous day?
IB Computer Nerds. Using Linux on my personal computer?
I really have no need for Windows other than to practice modeling on Excel. I'm personally tired of it. Most at-home-work is done via Virtual Machine right? Can I get by running just Linux on my own machine? Yes, I know I can dual-boot. Somewhat related. If you get approval from the IT homies, will...
Advice for the first 90 days @ BBH
Here we go, so I have gotten my foot in the door at a traditional finance shop with a long history of servicing investors. I am working in Client Services and have been wondering what the best way to tackle the first 90 days. I'd like to take excel courses to boost my skills and study for the SIE to...
Call and Potential Interview at CRE/Debt Fund
Long story short, I graduated last year and have been working for a construction services company. Very unhappy, company hasn’t followed through on their promises, and I’m making a move. Using a connection I have, I am scheduling a call next week with the MM capital group/debt fund and I was...
Free Course Recommendations for Excel Modelling and Valuation
Hello, eager college freshman here trying to learn how to master excel for IB and all the like that would be helpful in applying to and working in IB. I know WSO academy have these, but as a college student, would prefer to complete it for free. Any recommendations and suggestions would be greatly...
Useful Shortcuts
What are shortcuts that you think are super useful(default excel, FS, ppt..) but are too long/easy to get wrong? Any examples are much appreciated.
Laptop Recommendations for Excel Prep
Currently looking into buying a windows laptop for practice with excel for an upcoming internship. I already have a MacBook pro, so I don't want to spend too much money and likely won't be doing anything on it except excel. Does anybody have recommendations for something reasonably priced but can...
simple LBO question: taxes and interest expense?
hi team... i am confused. scenario below: Tax rate = 40% EBIT = $150 Interest expense = $100 Every template LBO model I see would calculate taxes by taking $150 - 100 = $50 * 40%... However, I am also seeing online that interest expense is not fully tax deductible... that there is a 30% limit of...
Rant: "Modelling" Junkies
FFS To any analyst and associate who needs to hear this: A model is NOT supposed to be a software. Unless you are working on a large, complex, multi-billion $ transaction with various moving parts, standardised xls files constantly feeding through, huge portfolio of projects/assets (and often even...
Training the Street Turbo Macros
Does anyone have the Turbo Macros of Training the Street? Can't find them online. Would highly appreciate any help.
Why does entry level "Investment banking analyst" pay twice as much as entry "Financial Analyst"? $150k vs $75k
When you are a entry level "Investment banking analyst", you are just doing work using Microsoft Excel mostly and you are paid about $150k. But when you are a "Financial Analyst", the jobs requires you to be an "Microsoft Excel Expert" and you are also just doing Excel mostly but the pay is half at...
AI Modeling in Commercial Real Estate
Has anyone found any AI tools that have helped them build out CRE Excel spreadsheets faster, easier, and more accurately? I've played around with a few add-ins but they're pretty cumbersome and take about the same time to develop a formula as just inputting it yourself. I am happy to dig into any...
How To Model Interest Reserve Drawdown
So, my question revolves around drawing down an interest reserve dynamically. Let's say we have in one cell an interest reserve of $XM. I also have a negative cash flowing asset that needs to draw upon the interest reserve when there are negative shortfalls due to debt service. At some point, the...
Does this annoy you?
I was wondering if you are one of those people who now and then (or frequently) has to match similar data in two excel spreadsheets. Like, you get two spreadsheets with basically the same data in it but with different name, formats etc. And now you want to merge both documents into on but removing...
cash free debt free basis? who pays off pre-transaction debt?
hello team. i am confusing myself badly and would appreciate your help here. example: Buyer offers seller $1B TEV, cash-free debt-free basis. Seller has $200M of existing debt on the business and $100M in cash. So prior to or at close, seller uses the $100M of cash to pay down debt to now $100M. but...
What excel advice do you have for a visually impaired investment banker?
I am a new IB analyst 1 at a BB investment bank. I have a disability that impacts my vision, making me slow on excel. What tips do y’all have to speed up/automate as much as possible? I’m a good coder so if you have any VB or macros functions you use that would be great.
Excel on Mac bootcamp
Does anyone know whether it is remotely possible to run Windows-version of Excel on a Mac? Have always been a fan of Apple especially recently that the macbook series has gotten way more advanced in terms of processing power with the introduction of M1 and M2
Scenario Analysis
Hello fellow monkeys This is rather ignorant of me, but has anyone used excel scenario manager to manage and display multiple scenarios simultaneously? I'm having to either run and paste every scenario (there are a LOIT of them) or have self-referencing sticky cells which randomly don't update and...
Learning Excel Basics
Soon to be freshman here. I’m going to study finance and I know excel is an extremely important tool for pretty much everything. How did everyone on the forum learn their excel basics and what’s the most effective way to get everything down before I learn about modeling?
Dream Excel Update
Full Disclosure: Most of my work/background is in c++ or python, so please excuse any typos in the hypothetical excel equations. Oftentimes on anything remotely advanced, the formulas used in a cell of excel can get very long and cumbersome to read, even if you wrote it yourself. The colored "()"...
Excel question - staying in the same area to select two cells
I need Excel help from qualified monkeys. I don't know if this is the right forum, but here we go. Is there a way to stay in the same area when you want to reference another cell nearby? I think it is best explained with an example. Say you have a long vertical model. At the bottom of the model,...
I got into Investment Banking, now what?
Hey everyone, I received an offer for the graduate program in IB in Europe! Which books/preparation would you recommend me to further prepare for this position (structured products)? My profile is not pure finance (More Quant.). I'm reading C. Hull but it's not enough. Which laptop (2.500-3.500€)...
Is there an *quick* way to consolidate multiple years of Quickbooks P&Ls?
I'm a first-year analyst in a downstream energy/convenience retail coverage group. Many of our clients are medium-sized (50 - 500 site) gas station chains throughout the country. Every gas station has its own P&L, and we consolidate them into a "master" P&L for every deal. The problem is that many...
13 Week Cash Flow Forecast model
Hi, I have purchased the 13 cash flow forecasting course by WSO. On the personal cash flow forecast there is a formula to allocate expense in the correct weekly time period. No matter what I do with cell refencing, It seem to not be pulling values through, any ideas why? =IF(AND('Assumptions...
Logitech MX Master 3S Mouse
So, I made what has to have been the nerdiest purchase of my life the other day and grabbed myself a Logitech MX Master 3S mouse. For the uninitiated, this is a mouse with a built-in thumb wheel for horizontal scrolling and customizable buttons that you can assign Excel shortcuts to (discussed at...
Tips for pasting from excel to Powerpoint?
I keep pasting stuff from excel into power point and I choose "keep source formatting" but I still need to reformat in PPT. Its frustrating because everything is formatted so nicely in excel but PPT it gets all messed up. Do you guys embed? What are your methods?
Best way to build charts, tables and graphs
Do you guys think it is more efficient to build the charts,tables and graphs you will use on ppt in excel or in ppt itself?
Debt Corkscrew Calc
At its simplest, this ought to be: balance brought forward +drawdown -repayment +interest = ending bal The concept of repayment is that you never model more repayment more than the amount of loan that is accrued in that period. So if you have capability to repay $1m, but the loan /drawdown during...
Wealth management basic template
Hello to all I am new to this community so I wanted to ask the more experienced people here where I can get my hands on a basic wealth management/net worth management template on MS Excel. I am looking for nothing advanced or sophisticated. Just a basic sheet would do. I hope you can help. Thanks.
LaSalle Special Situations modelling (London)
Looking to apply to LaSalle Debt and Special Situations team in London as an Analyst. Does anyone have any knowledge on what level of modelling they require and what they include on their modelling tests? Thanks!
Does this look bad on an interview modeling test?
Let's say your company is hiring for an Analyst position. As part of the interview process, as is customary, you give the top handful of candidates a modeling case study in Excel. Here is my question... Would you view it positively , negatively , or neutrally if a candidate reformatted the raw data...
Excel Model Clunkiness - Compare statistics
Hey guys Thought this could be a relevant topic. I have a pretty decent computer, less than a year old and pretty good specs, 32GB ram. It is such a pain to run through my model, its laggy and takes like 3 minutes to iterate after every save. the workbook statistics are Sheets: 15 Cells with Data:...
what is management ebitda? same as reported ebitda?
what does "management ebitda" mean? have seen that come up a few times. is that just the same as reported ebitda? and not adjusted ebitda? thanks so much team!!
Tips to model faster?
Does anyone have any tips to model even faster? Any lesser known pro tips you've discovered, e.g., for modeling tests? I'm already using all the alt- keyboard shortcuts of course, and I'm completing most of my practice tests fast enough but would love to have more time to spare / check my work
backing into purchase price by looking at balance sheet? help needed
hi team - is this possible? looking at a balance sheet of a PE backed portco (recently acquired) and trying to figure out what the purchase price was. long-term debt is $200M Total stockholder equity is $500M.... of that $500M, $10M is common stock and $490M is additional paid-in capital To back...
Feeling like I'm behind as a freshman
Good evening everyone! This is my first post on WSO. I'm currently a freshman at the Kelley School of Business at Indiana University. Coming here, I thought investment banking was going to be a niche interest - but boy was I wrong. It seems like everyone and their mother wants to become a banker and...
Intro to me
I'm currently a full time carer but with over 30 years of IT experience. I'm looking to reskill for when I can rejoin the world of work and this looks like a really useful course to get some Excel skills.
Excel Formatting Classes
Anyone know any good excel formatting classes? Not looking for modeling/data analysis classes. A class that focuses on presenting information clearly and how to make charts pop. Thanks!
Do IB training programs in banks actually make you disconnect your mouse?
Saw this claim in the CFI FMVA course wasn't sure if its true. Regardless, how important is it really to know how to use excel with just keyboard shortcuts? Does it improve efficiency that much or is it just a flex to be able to not touch your keyboard?
TAM vs. whitespace opportunity?
hi guys - what exactly is the difference here? is whitespace a subset of TAM? so if TAM is $1B, whitespace might be $100M that's actually serviceable to a Company? from what i understaND, TAM is the total revenue opportunity assuming 100% market share. so is whitespace the portion of that pie that...
Why do we still have NPV / IRR vs XNPV / XIRR?
The question that always lingered without anyone finding the solution: NPV does a limited function of XNPV IRR does a limited function of XIRR Why has Excel not got rid of NPV / IRR function? Are they useful for anything?
Excel hacks / tools you can't live without (Real Estate)
Previously worked in RE IBD where Macabacus was king. Currently working in London at a real estate fund, dynamic role across various asset classes and strategies in the cap stack, but the IT department not allowing me to run external programs, so stopped using since moving. Just found WST Macros...
Excel on Mac Air 13 M1. How is running?
Hello everybody, I have to change my laptop and was intent on buying a Mac Air 13 M1, for reasons I am not here to list. However, one thing I wouldn't want to give up is the flexibility and operability of Excel. I have recently joined an M&A boutique where I certainly have a computer running on...
where to find ARR of public companies?
hi everyone - is ARR listed out somewhere on financial statements for public cos? i only see total revenue. is there a way to look at 10-k, 10q, etc. and figure out ARR if it's not explicitly stated? thanks so much!
How to Calculate Unit Rents From By The Bed Rent Roll
All - we're looking at a student deal that has rents broken out by the bed, I'm looking to condense it into a by the unit rent. I have unit #', market rents, and actual rents. Any ideas for combining the by-the-bed rents into one unit rent? (Each of the units is split differently (1, 2, 3, 4,...
Easy questions on arr and run rate
Hi guys. Easy questions below. 1. what’s the difference between annual recurring revenue and run rate? Aren’t these basically the same? 2. I don’t understand when I’m looking at a CIP when they say “projecting 2023 run rate revenue of $10m.” Why wouldn’t you just say 2023 revenue of...
Minimising errors in models and formulas
Hey all, As an analyst, there's a natural expectation that the work you produce be error-free (or as devoid of errors as possible) As I've done my own models/looked at others, I've realised that there are occasional issues that have an impact on output e.g. formulas don't reference the right cells,...
or Want to Sign up with your social account?