Showing results:
Displaying 51 - 100 of 380
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,...
pre vs. post money valuation? purchase price? so confused!
hi team... 1st scenario: assume I am a buyer assessing a potential target. this potential target had a recent financing round and you can see both the pre and post money valuation from the round... which metric (pre or post) would be more relevant for helping me, the buyer, determine how much i...
Optimal Excel Options / Settings?
What are the optimal excel settings / options when setting up a fresh computer? Some standard ones: Ensure Iterative Calculations are set to "Automatic except for data tables" & Maximum Iterations set to 100 (Should be default) [
LBO: equity value = EV?
hi guys. doing an LBO right now and trying to understand some things. in my example, it seems as though equity purchase price = EV. what about debt, cash? are there some basic mechanics / concepts I'm not understanding here? thank you very much
financeable EBITDA vs... EBITDA? what is the difference?
hey guys - what's the difference between financeable EBITDA and.... non financeable EBITDA? and what are the differences in the calcs? been reviewing some buyside / LBO / lender model materials and keep seeing this term "financeable ebitda" thanks all!
EBITDA bridges: easy question
hi team. i'm looking at an EBITDA bridge right now and I am confused. on the lefthand side, we start with Q3 2020 LTM EBITDA. On the far right side, the bridge ends at full year 2020A EBITDA. In between obviously there are a bunch of steps. How can you bridge from Q3 2020 LTM EBITDA to full year...
Excel toolkit for Financial Modeling
looked into the forum but didn't see a thread about this (might have missed one so sorry if its a repeat post). Trying to break into IB and so teaching myself financial modeling. Taking the WSP courses and they talk up their "Boost" toolkit for excel which is no longer available. Anyone know of any...
Excel, is that the best tool?
Why do investment banks still use Excel for modeling? What are the current tools to build pitchbooks and presentations?
30 Minute Excel Assessment at Boutique Bank
I am preparing for a Super Day at a small boutique bank in the rocky mountain area. Their Super Day consists of 45 minutes to present the case study. 45 minutes for lunch, and a 30 minute Excel assessment. Being that the Excel Assessment is only 30 minutes, what should I prepare for so that I can be...
Excel Question
Does anyone know if you can / how to reference a a number from cell A into a string of text in cell B? Example: Cell A has: 7% We want Cell B to reference that number in the middle of a sentence, ie: The cap rate used is 7% (Cell A). So that any time the number in Cell A is changed it'll update in...
Comparing text strings in Excel
Hey y'all! Would anyone please assist with this issue I've run into? Is it possible to compare text strings in two different cells within Excel? Pretty much I want Excel to compare text strings in two separate columns and check if the values match up - think strings like "Timmy, Bob, John" and in...
Social Media to follow for Excel/PPT skills?
I recently saw an excel IG account that had a lot of excel basics... was wondering if anyone knew any accounts marketed more for higher level users (i.e. one for people looking to get into IB/PE). I would love to learn more macros and keyboard shortcuts and think that an account like that could help...
Excel Lambda Function - Do you use it?
Anyone here use the Lambda function in excel? If so, what are your favorite examples that have been your "works of art"? Have you created your own functions under the Name Manager tool? Show off your wizardry!
PC/Mac?
I'm finally making the switch from Mac to a PC, as I'll be using excel extensively in IB -- wanting to make it easier on myself with shortcuts. Does anyone suggest a PC laptop they prefer? Something a bit light or at least not super large. I like to carry my laptop around. I've been out of the PC...
Interest in buyside growth modeling guide and example (from an analyst)?
I want to know if people in the community would be interested in a really tactical guide and example of what modeling looks like on the buyside. Before I joined the buyside five years ago, I was very intimidated by the unknown and especially by financial modeling. What did modeling look on the...
Found this great free financial modeling lesson on Reddit
Hey Everyone, I came across a Reddit post containing a great financial modeling platform and just wanted to share it with the rest of you. You can find the post by searching up modelmaster on the Financial Careers subreddit or searching the title "Hands on Financial Modeling Practice (Free for...
Best Excel Resources For Getting Better With Large Amounts Of Data And Scalable Logic?
I need to practice and improve the logic around how I structure models with large amounts of disorganized data, particularly when drilling down into customer cohort data. Can I get some recommendations? I didn't come from an IB background, more the BD side of Corp Dev, so my modeling skills aren't...
Excel test at a Credit Ratings Agency tomorrow
I have an Excel test for an Analyst position in a Structured Finance team at a Credit Ratings Agency tomorrow. Does anyone have any idea what I can expect?
M1 mac Excel Compaitablitiy
Hi All, I have been working in IB PE industry from 2020. I have been using Windows specifically Razer Blade for most of my work. But currently I'm interested in buying M1 mac for battery life and performance Usage:Mostly excel - LBO, VBA some RE and Presentations in Power Point. Research thesis -...
Financial modeling test for interview with a VC fund
Scored an investment analyst interview at a mid sized VC fund. I have experience in building a 3-statement model and DCF in my corporate finance stint. Any resources where I can practice a 1+ hour financial modeling test online? Even better if there are solutions available to check my work
Annual Rental Growth Rate Question
Hi Guys, I was hoping someone could help me with writing my formula for rental growths. I have a Y1 price per sqft. with Y1, Y2, Y3 growth rates alongside varying occupancy rates. I am trying to project out monthly cashflows but have now confused myself on how to proceed... I was doing =SUM(Rent Psf...
Notice period
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 cancelled thread
Excel Keyboard Shortcuts Really That Necessary?
I'm doing training for deal advisory internship rn, doing ib internship this next winter also. We're watching an Excel tutorial and the guy is only using keyboard shortcuts to do everything. Is it really that necessary to use the shortcuts? Does it save you that much time in IB grinding endless...
Institutional Modeling Formula (STUMPED)
All - I'm working on valuing/developing a model for institutional-sized multi-family deals. I need to create a formula that pulls the average rent for the 5 most recent leases signed for that given floorplan. For example for 1BD/1BAv1 I need to find those floorplans and then find the 5 most recent...
first year analyst needs excel help
i am a first year analyst who just started at a middle market bank and am struggling with excel. i didn't have an internship and thought i was decently familiar with excel, but have started the job and feel behind compared to other fy analysts. are there any resources/courses i can use to catch up?...
I Built a Screenshot to Excel Converter...
Have been working on a website called Grabsheet ( www.grabsheet.com ) for the past several months with some friends who currently/did work in finance. We now have a few hundred users and have been getting some great feedback so far. Background: We noticed that a decent amount of our time initially...
Marginal contribution to risk
Does anyone have any guidance on building an attribution model (MCTR)? Keep getting caught up in the formulas and can’t figure out how to build this out.
Excel 365 - Data table not refreshing
When using "Automatic except for Data Table" setting and hitting F9, my Excel (Office 365 ver) no longer refreshes the numbers. It only does if I put the settings back to "Automatic" Anyone experiencing same problem and know how to fix? p.s. I miss Excel 2016
Screen shot to excel converter
TLDR; Built a website that takes images of tables and converts them into formatted Excel files in under a minute. Have been working on a website called Grabsheet (grabsheet (.) com ) for the past several months with some friends who work in finance/consulting. We noticed that a decent amount of our...
Real Estate Fund Modeling
What the best method for modeling a FOF hypothetical? A) utilize the the 1, 3, and 5 yr average net return of the underlying operators or B) utilize assumptions of cash flow based on prefs and estimated appreciation of the underlying assets? i've modeled both methods and with A (using net return)...
Building Interest Rate Swap Model
Hi I am trying to move to a Rate Sales Role and am trying to build a swap model. I have set it so NPV=0 at inception if both side pay on the same dates. I know however, one side pays semiannual and one side pays quarterly so my model isn't correct with my solved for swap rate. Can anyone help with...
What can I automate to make monkey's lives easier?
Analysts who do a lot of Excel modeling: what's a common inefficiency that could be automated/has been automated that could/did make your job easier? Trying to brainstorm ideas for a VBA/Python programming project.
Using complex excel function in financial modelling (Accounting, M&A, LBO, Valuation)
Hey monkeys, I am training in excel and I was wondering by this question: When do we use for instance "index-match" or "sum-product function" in financial statements, DCF, LBO or even a Merger Model. Could you please give some real-life example ? Thanks,
Naming Cells in Excel -- Good or Bad?
Hi All, Wondering if naming cells (ie. "Lease_Start", "Rent_Growth"), etc. in Excel is considered a a good or bad practice to pick up? Pros: Seems helpful to show what info you're referencing to, especially in those long IF statements. You don't need to worry about locking cells (big advantage)...
Excel Question
Whats up guys, I'm wondering if it is at all possible to import a sheet from one excel model to another and keep all the formulas without importing the ["name of sheet"] brackets from the previous book, just keep the formulas themselves. Appreciate any help.
How do traders & analysts use models created by researchers/quants in your workplace.
Hey all, I'm new here. I have a lot of experience in Excel and am developing some add-ins to help the finance community, specifically how analysts/traders can leverage models produced by researchers/data scientists/quants. So I was wondering - inside your companies how do your traders use models...
Mac Os for IB..software and apps recommended?
Hi everyone, Firm I'm working has decided to adopt the bring your own device policy for laptops as well. As a MacBook owner, I'm a bit thoughtful on what's best to do. Sell the MacBook and buy a Windows laptop so that I can use all the shortcuts or try sticking with MacBook and using Office on it,...
Looking for live tutor for PERE modeling
Hi All - Looking for a tutor to walk through basic excel based modeling for industrial real estate assets. I have enrolled in a few courses to learn the basics but would love to connect with someone one-on-one via zoom to review and walk through a few case study models that I have. Happy to discuss...
Calculating Weighted Avg Lease Term: Weigh by Size or Rent?
Hi, I did some basic research and couldn't find a consensus. Do you usually calculate weighted average lease terms by weighing each lease by size (SF) or rent ($)? It's my first time doing a rollover analysis so I'm not familiar.
Excel and PowerPoint Macros and Add-Ins review
It looks like there's a new post every 6 months or so discussing everyone's favorite macros and plugins, so I figured I'd consolidate my notes on this and share them here. Hopefully, it's somewhat helpful for those either entering their internships (especially in the boutique space where you may not...
Investment Bank Switching to G Suite
Hi all, My shop (boutique IB), is considering switching to G Suite. Obviously, all the junior bankers are revolting given that Google Sheets is not compatible with Cap IQ and FactSet. Accordingly, they are meeting us halfway by transitioning Outlook to Gmail. I'm trying to think of some major...
AIG excel test
AIG Global Real Estate Excel test? I have next week, looks to be an hour and a half. Has anyone taken it recently?
Excel Plugins
Hey all, I'm currently taking a break from banking to focus on my health, and I'm working part-time at the government doing some corporate finance. Do you guys know any good excel plugins that will help me audit a model? I previously used FactSet and Capital IQ, but unfortunately, we don't have that...
Shortcut for track dependents that spell out Cell location?
Hi guys: Sorry to ask such a beginner level question, but I was wondering if anyone knows that the Excel short cut for Track Dependents that allows me to see the SPELLED-OUT cell locations are please? Ctrl+] just shows me the dependent cells greyed out, but it's hard to track those not on the same...
best 2019 online Excel learning for complex stuff
best 2019 online Excel learning for complex stuff, easily and quickly - - free or minimum cost
Microsoft Office 2016 Upgrade
Our office just updated from Office 2010 to 2016 (and Windows 10 as well) and it's turning out to be a sh*tshow so far. Have any of you gone through the upgrade and care to share some tips / shortcuts for powerpoint and excel? For example I can't tab through the formatting pane in the new...
Wall Street Prep Exams 2019
I am taking the exams but before I do I was wondering if anyone had insight on the format and difficulty of them. Thanks
Can you use your target company's own cash to fund a leveraged buyout?
I am looking at this M&A model, and it says that a certain percentage of the cash used in the leverage buyout is coming from the target companies own balance sheet. What is the logic behind this? How can you use a company's own money to buy itself?
Can someone help me understand what a few things represent in this M&A model?
I am trying to understand this model, but there are a few components for which i am not sure what the values are supposed to represent. I'll just attach a screenshot of the model with the parts I don't understand circled in red. I can also send you the excel file if this would make answering the...
or Want to Sign up with your social account?