Showing results:
Displaying 301 - 350 of 380
Formula on excel
Hello, I have the principle, pmt and rate. I am looking at an amortization table, how can i find the term. would this be the right formula NPER(rate,pmt,pv)
New York City WSO Meetup
Anthony and I met up the other day and had a few drinks prior to both of us running off to other engagements and I was playing with the idea of setting up a meet up/happy hour of WSO individuals in NYC .. potentially @ The Galway Hooker.. if we can get a group of people interested I can go ahead and...
excel help
Hey guys, I am working with comps in excel and have 3 years of FYE data, for each year I also have margin numbers for each IS/ BS item in the adjacent column. The last column to the right, closest to the most recent FYE numbers I have percent change column most recent year #s over the year before...
Monkey needs urgent help
I am no excel whiz kid.......so to make a long story short. Downloaded some data from a database and excel dates are in 2 formats..... mm /dd/yyyy & mm-dd-yyyy. Tried to apply the =Text( A1, "mm/dd/yyy") formula did not help. Tried the : format cells----->custom-----> .....etc, did not work Looked...
Energy Banking Help: Type Curve Model
Attempting to split DCF to build in pricing for wet gas (separate dry gas from NGLs) and dry gas. Anyone have any model templates for this? Flying blind without an older analyst...
Best Free Excel Plugins
Anyone have an opinion on what Excel plug-ins add the most value for powering through a model? I've looked into Simple Shortcuts, Smart Shortcuts and Macabacus Macros but looking for outside opinions.
Excel Resources
Even though I got plently of programming experience, I've never used Excel much, at least not the way quants would. Any resources/tutorials you would recommend on this? Thank you
MacBook Pro + Bootcamp + External Keyboard = Excel Bliss?
So the age-old issue for those of us who can make sweet music on Excel in a PC world but who want a Mac for everything else... Excel does not work with a Mac keyboard for reasons that only bankers and consultants seem to understand. That said, if you plug in a PC keyboard (or Bluetooth one) will a...
Anyone have an example of a financial model?
I've never had an internship but I always read on here about people building models in Excel. What do these things look like? How did you learn to build them? Any classes I can take in school to learn?
Necessary Intern Skills?
Hi all, So I was just proved wrong in a previous topic for my opinion that interns should have baseline Excel skills, financial knowledge, and an ability to work quickly and effeciently without asking too many questions when given an analytical task by a FT analyst. They are new kids on the block...
Terrible summer interns? You judge.
A current analyst and have some terrible summer interns? A current intern and see some in your class doing terribly? Not a few of my friends have told me recently they have less than capable coffee-runners around. Not that they're bad at getting coffee. It's when they've handled the coffee-running...
Is my associate a fake?
So our subject in question apparently has 3 years of bulge bracket IB experience under his belt, and we just took him on as a 1st year associate. However, he seems rather clueless on quite a few things which leads me to wonder about how legitimate his experience was - Some highlights include: - Uses...
sighBanking
It's 3:30 in the morning and I am still at the office. So...I feel like writing this post. This poem is for all future analysts trying to get into investment banking. From the outside it seems like we are all Gekko, the truth is... "sighBanking" by SuitedWolf no suits, no shoes no deals, no wheels...
Automatically Draw on a Revolver in Excel
I'm building a model and am trying to have it so the company automatically draws on their revolver if the cash balance dips negative. For example, if in Q4 their cash goes negative, I want the model to automatically draw on the revolver to get cash back to zero. However, this seems to cause a...
Office 2003 to 2007
I know there are various posts on here about the differences between 2003 and 2007, but has anyone ever made the switch while in banking? I'm going from a bank that uses 2003 to a bank that uses 2007 and I want to hear what others have to say about he switch. I consider myself pretty solid with...
Excel Macro/Shortcuts for a Mac computer
So before I get absolutely lit up for asking this- I need to preface that this is my personal computer and not to be used for any serious work!! That said, I have a new Mac and would like to be able to at least create some quick models for personal investments etc - but as many of you know, Excel...
HELP with LBO model (adjusting BS pro forma)
I'm building an lbo model as an exercise on a restaurant company and my pro forma Balance Sheet does not balance. It's got to have something to do with my M&A And Finance adjustments, but I've checked, and re-checked everything and to me it looks okay... but obviously I'm missing something. I know...
Excel Macro Help - Trying to create either a function or macro
I am at my wits end trying to create either a function or a macro to import data from one worksheet to another. I have total sales for a SKU on one worksheet and on another worksheet, I have the same SKU's but in a different order and cannot readjust the order. In the second worksheet I want it to...
Excel, VBA practice projects
I've been learning some excel 2007, vba, and powerpont. The problem is that i'm learning primarily from books, and I need things to apply my new skilsl to for them to really stick. I'm already working on optimizing all of the spreadsheets I use in my everyday life. Anyone have ideas for clever...
Excel Help - Please
Hey, I have an excel sheet of roughly 1000 numbers. This sheet will come to me monthly, most the time with the same numbers, but different information. Each number corresponds to something. I am wondering how to create an excel sheet or template so that when I open this excel sheet, the 1000 numbers...
Where Can I Get Excel 2003
Just got a new computer. This Excel 2010 business is a little ridiculous. I want '03 back, it's way better/easier/makes more sense. No idea where my Office '03 disc is that I used for my old laptop. Any tips? Do I have to buy '03? Does MSFT even sell '03 anymore?
HOW TO WRITE THIS TASK IN A RESUME
Okay so I wrote two VBA programs that cut the process time from about 10 minutes to less than 2 minutes (well more like less than 1 minute)... But how do I write this (quantitatively) on my resume and not risk sounding douchey- I mean you wouldn't say I cut down the original process time by 500%...
How to modify a protected cell? (Excel 2002)
I am using a template from someone else. I want to change the formula for a particular cell but when I try to change under the Tools and the Protection menu, it keeps asking for a password I do not know. How do I fix this?
Excel "IF" question
stuck at work...... i have three dates. Date A, Date B, and Date Y I take the difference of the EARLIER of Date A or Date B, from Date Y. help? I thought I could use IF(A
How to Copy Exact Formula in Excel (without Changing Reference)
Anyone know the shortcut for copying the formula in a cell to another cell without the reference changing (and without using the $ to anchor it)? I've seen someone do it but I forgot what the keys were. How to copy a fomula in excel This can be done simply by going to the paste special menu and...
London GS office 2007 or 2003?
Anyone know for sure? have they updated??
IPO Valuation (Comparable Analysis)
Hey, I'm interning for a VC right now and my supervisor asked me to create a spreadsheet with IPOs that are relevant to the fund (same industry, geography etc.). He's gone for a few days and I'd rather not pester him with silly intern questions so I hope some of you maight be able to help me out. 1)...
Excel Hero
Friend in PE sent me this. Thought you monkeys would enjoy. Make sure you keep the cursor in the text box. http://www.excelhero.net/
Excel challenge
I have a large model that depends mostly on two parameters. The results are displayed in 3 different ways on 3 different sheets, each revealing/highlighting a different aspect. I would like to allow the user to change the two parameters on any one of the 3 output sheets - whichever one he is looking...
excel & powerpoint version used in Hong Kong BB
Dear all, Anyone knows what version of Excel and Powerpoint are major BBs in Hong Kong currently using? Say GS , MS, BAML ? Thank you very much!
Trade Floor with IM Firm...Was told to be the man in Excel...Suggestions?
I landed an internship this summer in IM on the trade floor. My interviewers stressed the importance of Microsoft Excel . Specifically, being able to handle large amounts of data using VLookups, Macros, Bloomberg Integration, Modeling, etc... Can anyone throw some ideas out in regard to what...
Excel Count Function Question
Does anyone know how to use an Excel count function to count the number of cells between two values that I could specify?
Prove it! Excel - taken it?
Anybody here taken the Prove it! Excel test? I have to take one (I think it's the advanced one) and I'm wondering if anything particular will trip me up. Also, I've completed Breaking Into Wall Street's Excel course...is that good prep?
Portfolio Return Question
Where can I find a template for portfolio return? I'm looking for one that can do Time Weighted Return and Money Weighted Return. My 401K, IRA, and Brokerage accounts have hopped around 5-6 different fund managers / brokerage firms in the past 2 years and I just want to aggregate all of the activity...
chained to excel?
hi everyone. i'm curious just how much time IB analysts and associates spend at the computer? i had a pretty bad accident over spring break that has rendered most of my right hand useless from neuropathy (currently using speech recognition technology). would this be a problem in an associate role?...
Excel Help - Interview coming up
Hey Guys, I did a search and couldn't find exactly what I was looking for. I have an interview coming up and theres going to be an excel test. They said it would be over just the basics and no modeling or anything like that. I have at least some experience with Excel , but not much finance related....
Financial Modeling in Consulting?
I'm interested in the Breaking into Wall Street Program - is the skillset gained from this program applicable to consulting / strategy? IE will learning this be relevant / useful for FT recruiting for consulting? There's personal interest but I want to know if there would be more productive uses of...
Excel Question - help - nested IF function
So in a model I am building I have a function to pay down the LOC with excess cash flow over a certain minimum cash threshold. However, I can't figure out how to do this while also incorporating a function that will stop paying down the LOC once it reaches $0 to avoid a negative balance on the line....
Financial Model Template - Monetizing a social network website through ad revenue
Hey, I am looking for a financial projection model for monetizing an online community through advertising and other revenue streams. Has anyone come across a template or has done a model using revenue from advertising / affiliate programs? Having trouble showing how this revenue will look. Feel like...
How many hours a day do you use Microsoft Excel?
What's your role? (Analyst/Associate/VP/MD, etc... Include what kind of division if you wish) and, How many hours a day do you spend working in Excel ?
Quick (and hopefully simple) Excel Question
Hope someone can help me out with this. Let's say that I have data that goes left to right... C1, C2, C3, C4...C998, C999, etc. How do I quickly reverse the data and make it go C999, C998...C4, C3, etc? In this example, the data is not alphabetical so I can't just use data->sort.
Macabacus excel macros
The website is unresponsive every time i try to download, actually the entire site has been acting odd lately, so would someone mind sending me the latest (2.4) version for 2007 excel, I would like to try it out. Thanks.
When building a model, do you prefer to have IS, BS, CF on one sheet or separately?
To current analysts (or former summer analysts): When you build a model, do you personally prefer to have IS, CF, and BS all on one sheet (vertically listed) or separately on three different tabs? What are pros and cons to these approaches.
Slow Excel Model
I just got handed off a model and its running very slow. Simple tasks such as moving from page to page causes the model to 'stall' for a few seconds. Any advice on how to fix this?
Excel skills - one year later
What is your experience when it comes to improving the speed and accuracy of excel modeling? One year after starting as a BB analyst, I find that my excel skills still leave much to be desired. I am: (a) not as quick in excel modeling as I would like to be; (b) I still have difficulty setting up...
Are we using excel 2007 yet?
Hey, Trying to get up to speed for my future work. I plan to learn some advanced excel stuff, including vba. I was just wondering if excel 2007 has been/ will be widely adopted by the bb banks, consulting firms, etc, or if it looks as if we're going to skip this generation of microsoft office....
Very Quick (I Promise) Excel Question
Apologies if there's something I'm completely missing, but is it possible to format a percent so that it shows up in bp format? For example, could I type in 2.5% and have it show up as 250 bps?
Excel Question - Self-referencing if statements
Has anyone else had a problem with their self-referencing if statements where the cell returns a #Value even after being "filled" with a value and the conditions change? I'll assume that the people that are qualified to answer this question don't need a deeper explanation.
Trading Support Analyst Excel VBA requirement
What kind a skill set in Excel and VBA is required for trading support analyst? Are there any functions in Excel that are heavily used? Also any methods in VBA that an analyst should be aware of?
URGENT: Sending a CapIQ project to a potential employer
Hey all, Just got off of a phone interview with a firm, and they'd like me to send some previous work. I have a Comps project that was automated to CapIQ. I don't have CapIQ on my computer, and all the cells say "#NAME?" as a result. The people I will be sending it to have CapIQ. Will they see the...
or Want to Sign up with your social account?