Showing results:
Displaying 101 - 150 of 251
Help with 3-Statement Model Test
A friend sent me an old modelling test he had to complete for a BB a few years ago so that I could practice but I am having trouble with it (Balance Sheet wont Balance, not sure if margin assumptions are right). Would anyone be willing to take a look and see where I am messing up or what I should...
Health Insurance Model (UNH)
Does anybody know how to properly value health insurance companies? Trying to build a model for UNH but getting caught up in how different the health insurance income statements are. Any insight would be helpful.
Financial Modeling for Private Equity and Equity Research
Hello, I am doing my masters in Finance and for now we learned Financial Statement Modeling and some M&A modeling. If I want to work in equity (not sure if I prefer equity research or private equity), what should I know?, can you recommended me a course that could help me to learn what I need?. ( I...
What would it take for you to give up Excel?
Interested to know under what circumstances people would consider shifting from Excel to something else. Google Sheets currently doesn't have the same level of features as Excel, but there are obvious advantages in terms of things like collaboration. Some aspects of Excel are seriously frustrating...
Financial Models to Know?
Hey guys, I'm currently a senior in college and am currently applying to Investment Analyst jobs at companies that deal with public-companies. I'm wondering what some key financial models are that someone in an entry-level position should be able to produce in Excel. Also, what are some more...
NEED YOUR HELP - LBO timing for modeling tasks - technical matters
Hi guys, Need your help on LBO modeling timings. Not a standard job, a pretty big one. To put it short - from your practice, how long can it take to complete a big modeling job (if we disregard any other outside factors like management etc). I would appreciate your thoughts. It's the first time I'm...
Web-based Financial modeling platform
I'm writing this post for critical feedback from the analyst community. My background is investment principal for family office and ex-analyst for an EdTech VC Fund. As an investment professional, I always felt that new economy business models (SaaS, Mobile Apps, Video Streaming, Online Marketplace,...
Help with Financial Statement Modeling (Balance Sheet is not Balancing)
Was practicing FSM on a random company after taking WSP FSM lesson. Seemed pretty straight forward since it is mostly assumptions but I have no idea why my Projection Years are not balancing even though all the items are either projected with a growth rate or straight lined. Can anyone please take a...
Non-Financial Entrepreneurial CEO needs help troubleshooting Cash Flow/Balance Sheet in my model
I am a "P&L" girl. I have built a very sophisticated scenario based projections model for an online business that I've been using for over two decades, since my company built LasVegas dot com. I'm very confident of the P&L side of my model. Since our business is pre-revenue, I have put our actuals...
How reputable is Linkedin Learning's Financial Modeling Foundations course?
UVA provides us with LinkedIn Learning for free and I found this financial modeling course https://www.linkedin.com/learning/financial-model… taught by Michael McDonald. I was wondering if anyone has taken this course and could give their opinion on it. Also, while on the topic of LinkedIn...
Opinions on REFM or BIWS RE course?
I wanted to get peoples opinions on both of these courses. I have done some research online and found that these two were the most recommended. * Is one superior than the other in regards to total content? * Which one is better for learning to underwrite commercial investment properties? * What are...
Future Debt Funding for TI/LCs and CapEx on Value Add Deals
Im looking at a deal that involves future debt funding for TI/LCs and CapEx. Lender is obligated to pay call it 50% of future TI/LC's and CapEx up to $10MM, upon which the Sponsor is on the hook for the remaining TI/LCs and CapEx, total cost is $15MM. $10MM Lender funded and $5MM Sponsor. Assuming...
Financial Model Tutoring
I always considered my real strength in modeling to be dumbing down financial concepts and educating non-finance people how to understand the models they're looking at. Because of that I've been contemplating the idea of tutoring students aspiring for careers in finance but I'm unsure exactly where...
Modeling Test?
I have a second round interview coming up for an IB analyst position. All I know from the recruiter is that it will be an hour long technical interview with the associate and that it will involve testing my modeling skills and knowledge- DCF , LBO etc. I am assuming this involves a modeling test but...
Equity reconciliation
So I'm working through a 3 statement model that projects out over 5 years. I had to do a model in the interview today and he gave me another model to take home and complete to discuss tomorrow AM . I have completed forecasting out the AR and Inventory but I'm lost on how to balance out the equity...
VERY Basic Financial Modeling Question Regarding Time 0 Cash Flows and Initial Investment
I need a small favor. I have a very basic question about discounted cash flow modeling. I think I know the answer, and it is probably obvious, but I have been thinking about it so much that I have confused myself. This issue is very important to a financial model I have created for the acquisition...
FP&A Modeling Test
Hello WSO Family, I have a last round interview with two high up individuals next week at a SaaS company in Dallas and they are asking me for a one-hour modeling test. I am not sure what to expect. The position would be part of the FP&A/Strategy division at a fast-paced company. What to expect? Not...
Corporate Finance Institute FMVA Certification?
Monkeys, Has anyone taken the CFI FMVA certification and if so what are you thoughts on the quality of its content? From what I have found it seems to be top shelf. Cheers & SB's in advance. MM
Out of the industry, confused, broke; but in love
Hello, I am a graduate of International Relations and American History from a liberal research university in Europe. Came to the US as a Green Card holder. Have been living in Boston for 2 years now. I am 26. I am pursuing to get Mathematical Finance degree. First, I didn't know what I wanted....
Preparing for Deloitte/PwC Valuation and Business Modeling Interview/Case Study
Hi All - I have 2 interviews, one with Deloitte for their Valuation & Business Modeling team and one for PwC for their Deal - Valuations team. (Both in Dubai, UAE). I have been invited to do a case study for Deloitte - Valuation & Business Modeling. Does anyone know what this case study could look...
Financial Analysis Independent Contractor
I am seriously considering offering my professional services as an Independent Contractor or Consultant. The good news is I have significant practical experience doing a wide range or financial analysis and financial modeling for a number of commercial companies in the Washington DC Metro area. I am...
"Canonical" financial model examples to build mental models
I want to get better at recognizing and modelling issues in different kinds of businesses, and while some are reasonably straightforward (e.g., businesses driven off reasonably clear P x Q like industrials, software, or retail/restaurants), there are some that get trickier, like ones that are based...
Energy Asset Valuations
Hello Everybody, I received a job offer from a firm in NYC that invests in energy assets. They work on all stages, developing, financing and trading and distributing from the asset. They primarily purchase gas power plants and oil fields. My primary responsibility would be to work on asset...
Best Training for Incoming Financial Analysts?
What is the best training for an incoming financial analyst, starting a summer internship or full-time job in finance?
Wall Street Prep vs Udemy: Financial Modeling Certification on Resume
Hello everyone, I’m someone who is 2.5 yrs out of college that has been working in Digital Marketing. My degree & interests lie in Finance however, and I’m preparing to apply to Corporate Finance/FP&A roles across startups and F500 companies. Sometimes these roles look for someone with...
How to value running brick plant?
If one company/individual wants to buyc a brick plant/(Or the company/individual wants to sell its brick plant), how can they value the brick plant? What kind of financial model they can use?
How to Stress Test a Financial Model?
One of the projects that I've been assigned to in my MM PE internship is to run a stress test on the financial model provided by the investment bank we hired for an exit of a portfolio company. I was wondering if anyone has any experience on this and has any guidance on how to go about essentially...
FMVA Certification?
Detailed income statement projection model
I’m curious to get everyone’s opinion on the amount of detail surrounding your income statement projections. Specially, what goes in to your revenues & expense build?
Looking for Advanced Excel Financial Modeling Course Specifically for Equity Deals
Hi all. I'm looking for an online (self-study or guided) course in Excel financial modeling specifically for equity deals. It's for a consultant with very limited time, so I don't want him to have to filter through a bunch of other stuff in a financial modeling course to get to the equity deal stuff...
Wall Street Prep financial modeling course
I am selling a financial modeling course from Wall Street Prep. The course includes: Valuation, DCF Modeling , Trading & Transaction Comps Modeling, Accretion/Dilution (M&A) Modeling, Advanced LBO Modeling, Excel 2003/2007 cheat sheets, and instruction manual from Wall Street Prep . Price is $200.
How Long Should It Take You to Build DCF Financial Model?
Given these parameters: -Data is already available (copy-paste to excel or import) -Supporting schedules are the following: Debt, Working Cap., Depreciation, PPE -Reports and analysis for revenue growth assumptions available -IS items are projected based on Rev. (except Interest and Dep.) -BS items...
Assume straight line for non-material BS line items in Financial model?
Can I assume either a fixed value (i.e. most recent year value) or as % of revenue / COGS for balance sheet items with minimal material impact (i.e. less than 5% of assets / revenue, etc)? Usually they're either, "other assets / liabilities" or more specific items such as "accrued retirement...
Best computer for equity research?
Guys I’m new to the forum. I’m looking for a PC. And only a PC. I know there are tons of options out there, but here’s what it’s come down to: Lenovo P51 Lenovo Carbon X1 Dells XPS15 The computer will be used for business uses including modeling, word processing and other related functions....
Analysis and Valuation Models - Build with a template model or build from scratch?
Each company and each analysis is different, however, the "bare-bones" fundamentals are the same for DCF , Comps, precedent transactions, etc. So with that, do you guys build models and valuations from scratch (as in format, labels, sheets, cells, everything) or do you use a generic bare-bones...
Perfect Earnings Prediction? I’ll Pass.
How much would you be willing to pay for a model that perfectly predicted the earnings of the companies in your portfolio? According to Professors Feng Gu and Baruch Lev of SUNY Buffalo and NYU Stern –not much. In their recent article, “Time to Change Your Investment Model”, published in the...
Get a desktop or laptop set up for financial modeling at home?
Hey team. I'm a first year associate, working on getting extra reps in and considering a set up at home. Would anyone recommend purchasing a full desktop (large screen) set up or a laptop (14 inch screen, considering the Lenovo ThinkPad X1 Carbon)? If so, does anyone have any recommendations on...
Modeling Apparel Retailers
I am building a financial model for apparel retailers and are faced with the following challenge: How do I forecast growth rates in the current environment? At present, mall traffic is declining, online retailers like Amazon are aggressively moving into the space and in the case of many apparel...
Help a monkey out with some modeling basics
Hello WSO, This will be my first WSO post and I will start by screaming for some help :). I have read a lot about equity research and now I want to put it in practice myself. With some help from the Martin Shkreli lessons (Legend) I made this: https://drive.google(dot)com/open?id=0By7ANhp6HBO… I...
New to Argus (AE) - Best Practices
I am new to CRE and just started working as an analyst for a REPE firm. I have never used Argus before but started using it today. I have a lot of questions and am hoping someone on WSO can help me out. I am working for a small firm in the Midwest and am the only analyst (only person that has an...
Bottoms-up Financial Modeling Help
Background: I do FP&A for a mid-stage tech startup. I have developed a complex, but sound, financial model forecasting revenues/cost of revenue from a bottoms-up approach for over 500 customers. Problem: The model can get very confusing with all of its tabs (roughly 15) that pull data (to support...
WSO financial modeling course
Hey all, Has anybody here bought WSO's financial modeling course? I can't post the link, but it's their main $425 shindig. If so, was it worth it? For some context, I'm recruiting this fall but have limited experience in hefty financial modeling. ( MBB consultant, shocker). Thanks, any input...
How beneficial is Martin Shkreli's course for a novice? (Financial Modeling/Valuation)
I'll be attending college in the fall and wanted to get a head start and learn financial modeling and valuing companies. Are Martin Shkreli's videos on YouTube ( ) a good resource for me to learn modeling and valuating a company? It seems to be helping and I am understanding what he says and I...
Intern for financial modeling for a new fund
Family office in Midtown East looking for summer intern for excel modeling. Must be proficient potential job offer afterwards.
Need to learn financial modeling and accounting
In a month I will be interning at a small investment firm and need to know how to how to do different valuations for stocks. I am currently a high school senior and to be frank I don't have a clue what am I doing. Where should I start in order be able to create models for stock valuations? Any help...
DCF in School vs. DCF in Banking
So far, we've learned the basics of DCF 's and all the concepts behind them. However, this is my first time in a higher level finance class that requires us to build a full model for a private company. Although I've done quick models where the information was all given to us, I've been completely...
Investment Banking Prep
Hi I'm looking for help in learning how to create a valuation for a company using excel. I want to know how to create a DCF valuation particularly.
Financial Modeling Certification
Given the importance in finance (especially investment banking), what is more recognizable and valued within the industry: Wall Street Prep training or a certification like the CFMS (Certified Financial Modeling Specialist)? Any other financial modeling self studies or ideas greatly appreciated!
What rule governs accuracy of reporting completed acquisitions
To create PF statements, you need new lines. But for a PF company disclosing completed transactions in the most recent period, do you just record the data as is, as if they're regular historically? What do I need to look at to complete statements with transactions in their last reported periods?
Using pen and paper during mental model interview
Hi I am wondering if you get asked about xyz item impact on three statements, can you ask for pen and paper to draw down your logic and calculation? How would this impact your interviewer's view on your quant skill? Thanks
or Want to Sign up with your social account?