Showing results:
Displaying 251 - 300 of 380
Khar Real Estate vs. REFM course? Which one is more respected?
I am very interested in getting an internship at a REIT , REIB or REPE firm this upcoming summer, so I wanted to try to distinguish myself from other candidates by taking a real estate Excel modeling course. In some other posts on this forum, I found these two websites that offer training...
Financial Modeling: Minimum sale price to be able to pay down Debt by year 3
So I wanted to see if there is an efficient way to model this: I have a schedule of cashflows that is connected to a schedule of sales for various parcels of real estate. the parcels of real estate are broken out in 3 buckets with bucket one being all sold by year 2, bucket two by year three. We...
Learning VBA for Banking
I'm considering using part of the summer before b-school to learn VBA. Anyone have any experience with using VBA in banking? Is it useful at all? It's a skill I've always wanted to have and will probably plunk down the time if it is remotely relevant to my future career ambitions.
Excel Sum Formula Showing Zero
I got an excel with a simple sum equation, but if I go into it (F2) then press ENTER, then it turns into 0. It clearly can't be 0 because I actually see the cells it's trying to sum up and it's not 0. At first, I thought it's because I had it on manual calculation, but it's not. It's on automatic...
excel shortcut question
Let's say I am looking at the following formula in a cell: =('Page 1'!I282)*('Page 2'!A100). If I want to see the precedent, I hit CTRL + [. But this will only take me to the first term. How can I see the second term without hitting F5 & pasting in 'Page 2'!A100? Is there a way to determine which...
IRR calculation: have excel IRR function choose the amount of cells depending on the projection years input box
I am trying to create a template that I can use for certain type of modeling to automate things. One of the things I need in there is an IRR calculation. I have currently set it up that the dates populate off the projection year input cell. However, I'm not sure how to automate the IRR function from...
Errrrrday when I work in excel
If I build a model and everything balances: If there’s #DIV/0!: If the model #REFs out: Models & Bottlez: www.wheninfinance.tumblr.com
Analyze Bond Yields with Excel
Hey, I got a project for a course that requires me to analyze changes in US 5-year bond yields over the past year. I have to use Excel to conduct statistical analysis and do up some graphs, any suggestions what sort of things I should be looking for/doing? Thanks.
Fixed Income Excel Spreadsheets Urgently Needed
Hi everyone! I am joining an in-house corporate finance team where I will be doing traditional corporate finance staff... The problem is that previously I have been more focused on the equity side of things ( DCF modelling, business development, investments, equity valuations) and now I will have...
Finance guy makes incredibly detailed dating spreadsheet
Probably didn't even need a mouse Incredibly Detailed, Incredibly Creepy Spreadsheet Of His Match.com Prospects Let's call this guy, oh, "Dave." Dave is a financial services employee in New York. Dave goes on Match.com, and meets women, and sometimes goes on dates with them. Then Dave goes home and...
Question about Canadian Risk Factors for the Financial Sector
Hi, I am beginning my major class in Finance and we have to choose a Sector, find industry specific data that relates to that sector, and then run regressions and make an assessment of our findings... Since the financial sector is key in Canada, I thought it would be interesting and more relevant...
Complex Task in Excel
Having exhausted many other options, I have turned to the resident Excel monkeys to see if any of you could help with this project I have to do. I have two spreadsheets, both with lists of names of companies. The first spreadsheet has about 4000 company names and the second has about 9000. The one...
Excel Test - PWC
I have an interview coming up, which includes a 15 minute Excel test. I am told that if I dont pass the excel test, there will be no interview. Now, I am OK on Excel but I'm not feeling too great about the interview. Anyone have any tips on how to improve on Excel? Or what consists of these...
Does this count as modelling?
Just wondering should I talk about a certain aspect of my job in interviews. I work with distressed companies and as part of this we keep very up to date cash book models. A company could have dozens of bank accounts and these models track all outstanding cheques and lodgments and transfers...
SB here: running Parallels - how to disable "control+option" dropping excel
Hi guys, I'm running Parallels and have Excel 2007 running on Windows 7. When I hit control+option (alt), 2 keys, on their own, the mouse leaves the active window and turns to the black Mac cursor. How do I disable this from happening? Any idea what shortcut this is supposed to be? Can't find it on...
What is considered a model?
Sorry to disappoint anyone but I am talking about excel models here. How do you define what is a model? Is it just something that allows you to input some variables and spits out a forecast outcome? For example, if I created a excel template that allows user to input predicted cashflow and...
It's all about the money...who knew?
I realize that this is a finance forum but, as has become my custom, I usually like to write about sports. To that end, if someone can explain to me how you suspend Terrelle Pryor for the first FIVE games of next season (knowing he could easily declare for the draft, thus negating the punishment...
Learning VBA in 2 weeks.
How to Learn VBA programming Just get your hands dirty and do it. As long as you know how coding works, it should be easy. Make some simply exercises for yourself. Start off by recording marcos of what you are doing and seeing what the code looks like. Then learn logical operators (if then else etc)...
Excel football field template
Has anyone found online?
Intern Analyst Advice M&A
Hey guys/girls I was a summer analyst at BoAML in IBD in London last year and didn't get an offer. I have managed to secure another internship at CS also in IBD after I graduate. My main problem was being slow at excel and powerpoint, could someone recommend a good guide for me to buy and practice?...
Mac Excel Vs. Window Excel
What are the major differences in the 2 products (mac vs windows for excel)? Is it possible to run regression on mac? I want to use it for financial modeling , running regression, finding correlations and other finance/ trading related business . Suggestions and thoughts? Would like to hear from...
Real Estate PE Interview Modeling Test
Just got through 2 rounds of interviews with a REPE firm, and was told to expect an in-home excel modeling test sometime next week. One of the analysts there said the test would take about 4 hours to complete. Given the length and RE nature of the test, I was wondering what the test might possibly...
Should I leave my current position for a Valuation firm?
Hello all, I currently work for one of the major oil companies. I've been working in a credit analyst role for a year now straight out of undergrad. I've been networking and I've managed to network well with a senior managing director at a Valuation firm that happens to do IB deals as well. The guy...
VBA for Excel, Useful or a waste of my time?
Hey boys, I am a senior at a non-target and I just received an offer from a well-known middle market. Very excited about the offer. Now my focus is standing out amongst my analyst class. In school I took a CS class which taught me some basic VBA for excel. I am wondering if you guys think it would...
Weekend Wars: Sell side vs. Buy side
The dream and desolation of the high finance world. Which path to the upper crust of middle-class suburban boredom do I take? Do I jump to the buy side? Do I stick it out in this simian hell of pitch books and Excel? Which is really right for me? A friendly look in the rearview at how simply the...
Excel Help - Struggling to work around this problem
Struggling to work around this problem I have in Excel at the moment, any help will be greatly appreciated! Basically I have a list of company names and wish to categorize them using a formula. Theres about 20 different companies but only 5 sections I want to split them into. I could easily manually...
Excel Question - Crtl + alt + tab issue?
Has anyone resolved the control + alt + tab issue in newer version of Windows? It is supposed to indent cells, and has always worked fine in older versions of Windowns, but Vista and Windows 7 have an issue with doing this. Have 2 computers, both running Windows 7 and Excel 2010 - works on one but...
Excel assessment test...?!
Hey everyone, I have a supderday coming up with one of the big 4 for transactions. HR told me that there will be an excel assessment test. Anybody know what it is? Has anyone taken one before? What should I expect? It would be really helpful if you guys could shed some light. Thanks
Excel Question - Joining two cells
I'm trying to join two cells that have the top and bottom EBITDA multiples into one cell that will show the range: So for example, if cell A1 is showing 7.0x and cell A2 is showing 8.0x, I want cell A3 to show 7.0x - 8.0x. I've tried using =A1&"x - "&A2&"x", but I can't get the .0 zeros to show...
Excel Course - Trying to decide
I'm trying to decide between the Excel courses offered by Wall Street Prep and Breaking into Wall Street. BIWS is much more expensive so I'm guessing the material is more detailed. I'm pretty much a beginner at Excel and want to improve to intermediate or advance. If anyone has done either course, I...
Excel 2007 Question
Running through model that has a sheet which needs to be protected. However, there are hidden rows that I would like for the other user to be able to toggle (unhide, hide) with that [+] button. How can I allow him to do this while the sheet is protected? Tried Ctrl+1, P to see if I can unlock that...
Excel sample data
Hi guys, Just practicing some excel and looking for some sample data. What I found on google is crap (not much data). Any help, please? Thanks.
The Microsoft Excel World Champion Is a 15-Year-Old English Girl
Yup; This just about does it. After plugging away another nine hours into Excel, I can proudly say that I'm not her. [quote] Rebecca, who is 15, was one of 228,000 competitors from 57 countries. She beat 78 students in the final round. Competitors were required to perform timed tests to demonstrate...
Moody's AC
Hi guys, I am new here. Was just wondering if anyone ever had an assessment centre with moody's and knows what they are all about? It's in the London office for a sub-sovereign role. I know I'll have an interview plus two exercises. One will be an excel exercise the other more of a reading exercise....
Favorite Excel Function?
What's your favorite Excel function? I'm partial to EOMONTH.
Morgan Stanley Equity Research Associate Computer Exam
Just got an interview for tomorrow at Morgan Stanley for an Equity Research Associate position. After my two interviews I will be given a one hour computer exam that will test my excel abilities apparently. Does anyone have any experience with this test or any ideas what can be tested on this? Any...
anything besides excel
do traders use anything else besides excel? wouldn't access be more of use given how much information is out there and how big a database could get?
How to get good at Microsoft Office
Hey guys, So I have an interview coming up in about a week and apparently I am going to be grilled hard on excel, power point and word. I have above basic knowledge about all these platforms through my uses of them in college and such but I want to get better and be more advanced in all three. So my...
Do we need to know excel? Also, training week
Hi all, About to start a BB S&T internship next week and am starting to get a little worried, primarily about what I'm expected to know. Of course, other than following the markets/news, do they assume any technical knowledge on our part? I know that for IBD , excel is the backbone to analyst work,...
Boutique 2nd round interview modeling test
Hey guys. I did a search but didn't really find what I was looking for. I know there are people who are gonna bag on me for that...but... I have the interview on monday. I was notified today that it is going to involve an excel/modeling test that is going to be about 3 hrs long. I know that they are...
Excel Practice Problems
So you guys have been really awesome with me! I'm finishing my last week of job search and I have a final round " Excel test" with a fund of hedge funds. What kinds of skills would I need? I can do pivottables, lookups, macros and VBA scripts... is there anything else I need to know? Does anyone...
What does the term "modeling" exactly mean?
If an interviewer asks me if I know how to "model" - what does this entail exactly?
Cholesky Decomposition in Vba help
Hey guys, Has anyone done a Cholesky/ variance decomposition before? I am currently doing a project- the idea is to find out the correlation between different stock markets, incorporating directionality. I know how to get the correlation like through normal regression methods, but am clueless about...
Sopranos -- Paulie explains EBITDA
Found this thought it was really funny.
Return Analysis
I was curious if anyone has an excel model that would be able to compute a Return analysis for the founders and an investor into a new company. I am looking for the returns for equity invested as a private equity/ vc /angel, etc. type Thanks in advance
Model DIV's out when closing out
I know I posted a similar topic the other day, but now the situation has gotten a little stranger... My model is fine, I can refresh, F9, everything without having any issues. I save it down as a new version and have no issues. However, as soon as I click "X" to exit out of Excel , a large portion...
Excell formula for counting the spread between prices
Hey guys, Does anyone know what function to input into excel cell so that it can count in 32? for example: I am buying at 99-02/32 and selling at 100-02+ (100-02.5/32) what function can i use on excel to calculate the spread?
Help! #DIV/O! all over my model!
Hey everyone, working on my lbo model and all of the sudden I have #DIV/O! errors all over. Does anyone know why this happens or an easy way to figure out where the error is coming from or how to fix it? I really don't want to have to start over from the previous version. Excel 2007 in case that...
Industry Analysis - PE interview
I have an interview with a small PE fund and they ask me to do a "brief industry analysis" of my choosing. I have three days to do this. Anyone know what this entails or what I am suppose to include in this? tytyty
Public Finance--What do you do in excel?
If there are no DCF , comps , or lbo models , what do public finance analysts do in excel? I assume that the focus on financing means financing models. Do these have any specific names? Any other duties of analysts in public finance would be great too. Thx
or Want to Sign up with your social account?