Showing results:
Displaying 201 - 250 of 250
3 statement financial model template
Dear all, I got past my second round interview for equity research associate position, and they have sent me an assignment to do. I was wondering if anyone had a dynamic 3 statement financial model that they would be so kind as to let me see. I want to make sure that I am doing everything right, and...
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...
Oil and Gas Modeling - Resources?
I have an interview coming up with a BB in their oil and gas group. I have gone through all the oil and gas modeling 101 guides and sample videos. I think I have a good basic understanding of the all different things that flow into an O&G valuation.
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...
Waterfall / Promote modeling
I have been trying to model this and am having trouble. Any help in terms of how to tackle this (a template or thought process) will be appreciated Investor 90% $18,000 Sponsor 10% $2,000 Initial Equity $20,000 IRR Investor Sponsor Hurdle 3 12% 100% 0% Hurdle 4 18% 85% 15% Hurdle 5 22% 80% 20% Final...
Valuating Capital Requirements
Since I am far from quantitatively inclined my tolerance for highly quantitative approaches to finance is low. Naturally, during the derivate driven whirlwind of the last decade I missed out on many an opportunity to add an extra zero . I don't have an regrets in this regard. You can only play with...
How to model a smartphone app financials?
hey guys, needed a huge favor. I am trying to model the financials for a smartphone app (income statement and balance sheet ) similar to the google appson the smart phone but only exclusive for the public transport industry. I have no idea where to start i.e. how does the revenue and cost-structure...
Financial Modeling help - Urgent
So I have an interview for a Real estate investment position, had the phone interview and it went well so got an in person interview for this friday. Now I get an email asking me to send them a financial model that I have built, created, or worked on so that the managers can speak to me about it. So...
Review of financial models
I don't know how many people here have to review huge financial models quite frequently (rather than create them). For my last transaction I was reviewing a lot of financial models on very short timelines - my usual "system" is to go line by line through the financial statement and trace precedents...
BIG 4 Case Study
I am being considered for a position within a Big 4's TAS Business Modeling group. I was recently emailed a case study to complete. I was wondering if anyone has worked on their case studies before and their thoughts on it. This case study appears to be heavily focused on accounting.
Valuing debt tranches
I've got slight problem here, having brainfreeze on how to value debt tranches. I've got 3 tranches of debt: 1. 150mm RCF - effective interest rate 3.61% ( trading at 90) expires 2014 2. 150mm TLA - effective interest rate 10.5% (trading at 95) expires 2014 3. 75mm PIK - effective interest rate 15%...
Financial Modeling Best Practices: Color Conventions
Hi guys, What are color conventions that you guys follow to make your financial models idiot proof? There are so many links and assumptions that I am finding it difficult to standardize. Right now I have: assumptions=blue Hard coded inputs= blue with a background color Drivers such as '% of...
Weekend Wars: Qualitative vs. Quantitative
About two years ago, I had a fascinating market related conversation with the son of a high ranking Chinese Communist Party member who had recently finished a top 5 MBA program stateside. He was celebrating all over town and the entourage grew by the bottle. By the time I bumped into him, the next...
General Modeling Question
So a lot of people on this website talk about modeling, and building LBO and Merger models etc. However, when i had my summer analyst job at a boutique this summer, the firm used a standard model over and over for M&A , LBO , etc. Of course, there were certain situations in which it had to be...
differences between modeling normal retail/tech companies and financial firms
ok so i know the basics are that you obviously can't use EBIT while valuing a bank because it excludes interest expense/income which is where a bank gets a majority of its money from, so you could do like a dividend discount model, project out the financial statements find out how much money they...
interview question - modeling exp?
What kinds of things you should talk about when an interview asks you about your modeling experience?
modeling for natural resources companies
Hi guys, Just got staffed on a minerals company deal in China and was wondering if anyone could share any insight that you may have with respect to modeling or valuation of such companies? I'm a generalist first year analyst so I don't really know what's going on yet but based on what I see so far...
Project Finance model template
Anyone have a project finance model or template that I can see for practice for an interview? If its agriculture / farming project and development related, it would be great. However, any good project finance model / template would do. Thanks for the help!
Financial Model please!
I know this maybe asking for a lot, but can anyone send me a fully built out financial model ?!? I remember doing one in college but I can't find that one and I'm wanting to polish my skills. You don't have any idea how much I would appreciate this favor!!!! You don't have to post on this thread,...
One page financial overview for an internship
I'm being asked to do a one page financial overview of a company for an internship interview process. I'm not quite sure what needs to be included in a one page financial overview.. help appreciated. thanks
Making Financial Models - Questions
To you guys who are in investment banking, what's the point of making a full blown comparable companies model? Several online resources state enterprise value, equity value , key metrics/ratios, and multiples. So, what's the point of starting from scratch or using an already made model and...
How much financial modeling do I need to know?
I am currently working my way through BIWS (fantastic course btw), and I am now up to LBO valuation. I often hear about kids being asked about basic accounting, projection models, DCF analysis , and multiples. However, I have not heard anything about merger models and LBO questions in interviews....
Building an Operating Model - Negative Historical Revenue
I am relatively new to modeling and working on an assignment. Hoping some experienced banking analysts can help me out with this problem. I have been asked to do an analysis on a company and all I have is an I/S and B/S with 3 years historical info ( year end 2008, 2009, 2010). I also have Q1 2010...
Adkins Matchett Toy (AMT Training)
Does anyone know anything about the financial modeling training program offered by Adkins, Matchett and Toy? I am not sure as to why, their training program is so expensive (something like $10,000 dollars). Has anyone taken their course before? I can't seem to find any information about them on the...
Sports/Talent Agency Model?
I am supposed to model a sports agency. Any idea on good place to start?
pre-made discounted cash flow model service
Hey guys, I was given a class project (high school) to try and come up with a entrepreneurial idea. The focus was on some sort of small business idea on a high school level (babysitting, dog care etc.), but I don't really have any interest in that kind of work. Instead, I came up with the idea of...
Equity Research Associate without Financial Modeling Skills
Hi all -- I've had a couple of informal interviews and a formal interview in equity research in healthcare. I know the space well but lack financial modeling expertise. I know this is a basic question, but I couldn't find something with the search option. Can someone please explain what financial...
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
Modeling: Plus/Minus/Less and parentheses
This has been bugging me for ages. Assume CapEx is $1,000. Which version is correct? Version 1 Tax-Adjusted EBIT.......xxx Less/Minus: CapEx....1,000 Version 2 Tax-Adjusted EBIT......xxx Less/Minus: CapEx...(1,000) Version 3 Tax-Adjusted EBIT....xxx CapEx.......................1,000 Version 4...
IBI Training vs The Analyst Exchange vs IB Career Path
Has anyone heard of the IB Career Path??? http://www.ibcareerpath.com/ The first program I found was the Investment Banking Institute, but they have only the seminar program, then I found out about the Analyst Exchange, which you have the opportunity to do an internship guaranteed for 4 weeks. Then...
more linking the statement fun stuff
alright so im working through linking these statements and my next issue: Securities lending payable is an investing activity (outflow) Securities lending is listed under current liabilities Should I list this payable in changes in operating assets and liabilities or link it (beginning lending...
When should I learn financial modeling?
I just got back from an interview with a boutique private equity firm for a sophomore summer internship . About 2 weeks ago I talked with a VP on the phone and we got along well, and I made it clear that I do not know how to do financial modeling (I noted that I know the basic process of a DCF and I...
Private Equity Finance Institute - Scam? Reviews?
So I'm looking to catch up to speed to transition my career from sales to become more of the analyst role. A friend suggested I take some courses on financial modeling , learning how to create valuation models on excel. Of course, I can go and pick up several books, but like many, I need some...
Life Insurance Company Excel Model
I am trying to build Life Insurance Company excel model. It would be very helpful if some one can give me an example excel model of life insurance company. Please suggest any website from where i can download the model.
Rewenable Energy Banker - NEED HELP
Seeking some insight into Renewable Energy sector. I roughly have 3 years of experience working for a Boutique/Middle Market bank in the Consumer Products sector; However, now I am independent consultant and I have been contracted by individual to create a model for a start-up renewable energy -...
Self study VBA
Any good sources to bring up my proficient quickly. My intern boss told me that there will be a programming aspect, specifically vba, and that I will be working heavily in creating client friendly financial models with macros. I have advanced modeling in finance with excel and vba by mary stauton...
Analyst & Modeling in M&A/LBO/etc
Hi Guys, I am sure that this query would be putting many of the elite members here off given that it is a very traditional question having been answered numerous times in the past, but I being a newbie in this industry seek some advice and understanding of activities an Analyst would undertake. So...
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 Modeling Creation
I'm trying to create a financial model that I can use, so that all I have to do is input the necessary data so that I can get an idea of valuation. I do go through and read 10-Ks and make the necessary adjustments to interest expense, current liabs, etc. Any one know of any good resources other than...
Macabacus
Found a good site having detailed M&A and LBO modeling tutorials for free, just wanted to share http://macabacus.com/
Will part-time financial modeling experience help get into i-banking?
I'm 2 years out of college, working in financial services, not i-banking; want to get an MBA from a top school, then pursue a career in i-banking. I have no experience in i-banking, and have heard from people that an MBA may not make up for this when I'm interviewing down the line. I'll be competing...
Which Financial Modeling book?
Hi guys, I was wondering which Financial Modeling book is the best to learn and practice from it for basic to more advanced bankers? I was thinking about this one: http://www. amazon.com...
Finanical Modeling/ Financial Statement Analysis Interview Questions
Hello All, I have been out of the finance interviewing game for a while, I am a 2nd year analyst at a boutique IB . Need some help preparing for a technical interview I will hopefully be having soon - can anyone here help me with questions on financial modeling , financial statement analysis and...
Operis and other modeling firms
Is anyone here familiar with Operis or any other financial modeling training firms? How are the exit options from these firms? What can one expect from the day to day tasks? What are the hours/salary like?
Interview modeling/valuation exercise
Hello I have a banking interview soon and I was told that I will be given a modeling/valuation exercise to test me - I am a 2nd yr analyst in banking but I have never heard of this kind of interviewing before. Has anyone gone through a similar interview, if so what did you get? how was it and how...
Financial model necessary for LBO model?
Hi, In a couple of weeks I'll work at a small PE firm in Europe. I hope you guys can give me advice. Your opinion is truly appreciated. Thanks! 1) Is it necessary to build a detailed financial model before the LBO model? I've ordered the Wallstreet prep package. The LBO model is pretty...
Modeling question - Tax schedule?
Hi everyone, I was curious to know what are the line items encountered in a "Tax Schedule" in a financial model ? How is it constructed? Also, is it common to have this "Tax Schedule" tab in a financial model or not? Relevant for all circumstances??? Thanks for your help.
excel test
My interviewer wants me to take a 2 hour long excel test. I've done financial modeling training before, but I don't know what to expect. What test is going to take me two hours? do they expect me to make a model on the spot? Has anyone taken one this long before?
What is the best financial modeling training program?
Can anyone recommend the most ideal financial modeling training course - (assuming it will be self-taught)? Without price being an issue - I am looking for a single program or a combination which will be the most practical and appreciated by the Bulge Brackets and Larger PE Shops who have analyst...
or Want to Sign up with your social account?