I am working on my modeling skills and while I have learned a lot from Macabacus and the two Josh’s ibanking book and some guides, I am still struggling with constructing a fully integrated 3-statement model. My main sources of confusion stem from three areas.

1) The first is in constructing the debt schedule. I think I am getting close but one of the biggest things I don’t understand is how to you differentiate between short-term and long-term debt. For instance, if I have a company with a simple bank loan that is amortized on a b-annual or quarterly basis, a portion of that loan is always going to be moving from long-term to short-term liabilities. How exactly do I go about modeling that out?

Hey guys,
Half way through my MBA, and have only taken 1 finance course. Need to start learning stuff on my own if I want to get anywhere in life. Is it possible to learn financial modeling for free? Or is it worthwhile paying for that prep course offered here on WSO.
Please keep in mind I'd like to "learn by doing" so that it sticks.
Also want to become an excel ninja but I'm assuming I can find that material on the web.

Thanks!

I'm looking for a financial modeling course to do at home in the evenings, and I have noticed that most of what's available out there tends to lay on the lbo/merger side of things.

So wondering if anyone knows a good one to prepare for roles in fundamental long term investing (value-style).

Many thanks!

Struggling to model this revolver in. We have it set to draw down if cash gets low, so the min function works. But, I also need it to draw down a few months out when a new CapEx project occurs.

Right now, the line item in the CFF is linked to a term loan (which I want to be drawn down secondarily) and draws and immediately pays out for construction in progress, in CFI. I cannot figure out how to link the revolver in without messing up the existing min function in borrowing (repayment) line item of the balance sheet.

Any ideas? I realize this may not have been the best explanation, but I can try and expand upon it if anyone thinks they need a bit more clarification.

Hey everyone, this is my first post so bear with me.

I am in the process of switching careers and am currently studying for the June CFA level 1 (I am getting started early). I have a few friends that work in fixed income trading. They said that the ability to construct financial models on excel is pretty much a necessity. I have experience using statistical programs like SPSS, SAS and STATA, but not much with excel.

I am tasked with predicting the likelihood that a security (variable annuity) will reach a certain value within a certain amount of time. I would like to be able to say that I am 90 percent certain that the value will at least be x in 2 years, 3 years etc. I am a new consultant for a securities consulting firm and am trained as a lawyer, so I haven't take any math classes since getting my undergrad in econ. Please answer as if you're talking to a young child or a golden retriever.

.

Guys,

I'm trying to hone my modeling skills, anyone know where i could find free modeling case study questions?

Any and all help is welcome, tthanks

guys,
i was hoping you could give me a few insights on calibrating my financial model, whats the best way to go about it? How do you guys on the street go about it?

Hey guys. Had a friend ask me to help me out learning how build a financial model. What I built was / is really basic, but think it's a good first model to get going on for beginners.

Feel free to post any questions beneath, will try to get to them if I can. Good luck and happy modeling!

Here's the link: http://www.mediafire.com/view/?yiqui3k2zh2e73a

I'm looking into a position that is based off financial modeling for a project. I'm familiar with corporate financial modeling/valuation, however I'm wondering if someone here has experience in project financial modeling.

How does project and corporate financial modeling differ? I've heard that project financial modeling can often be more challenging than corporate, does that hold true? Finally, can anyone suggest any good books/online courses for project financial modeling or related topics?

Note: This project is under a large corporation and will likely not need external financing, if that makes a difference.

Thanks

I'm looking into a position that is based off financial modeling for a project. I'm familiar with corporate financial modeling/valuation, however I'm wondering if someone here has experience in project financial modeling.

How does project and corporate financial modeling differ? I've heard that project financial modeling can often be more challenging than corporate, does that hold true? Finally, can anyone suggest any good books/online courses for project financial modeling or related topics?

Note: This project is under a large corporation and will likely not need external financing, if that makes a difference. And I posted this in I-Banking because I thought this crowd would have the most modeling experience.

Thanks

Hi Everyone,

I have taken courses on financial modelling and read books on how to create models. I spend alot of time practising but because I'm currently not working I don't get feedback on if my work is good or crappy.

I'm thinking there must be people out there who try to model and do valuations on firms but do not work in funds yet want feedback. Is there any sites you suggest that allow me to post a excel model and get feedback? Most of the sites I see(seekingalpha, sumzero,etc..) allow people to only post research and not the number crunching behind it. Any ideas?

Recently i got an internship in a consulting firm dedicate to get loans to small business. My responsability will be principal prepare financial projections. What can i do to learn an little more before i start on the internship.

I have been working in audit at a Big4 firm for the last 2 years and have started to look at opportunities in a more finance-oriented role. As I go through requirements for financial analyst-type positions, I'm seeing that most obviously require some experience with financial modeling. While I have self taught myself basic modeling, working in audit does not really give us the opportunity to learn, or at least demonstrate experience with modeling. My question is: how can I address this requirement when applying to positions that list this under required experience?

Any former Big4 care to share how they addressed their lack of modeling experience on their resume/cover letters when moving into finance/analyst roles?

I have some IB exp but for some reason, modeling/valuation wasn't part of the job :/

I've read some threads on here about what books to read, and i'll end up picking up Rosenbaum's book, Investment Banking: Valuation, Leveraged Buyouts, and Mergers and Acquisitions

From what i understand though, i would need to read and practice using something else that goes more into detail. I want to go into the interview and do at least a decent job with a blank excel and 10k

Are there any other books i should read after rosenbaum's to learn and practice and get proficient at the case studies they'll throw at me in the interview?

Thanks guys

I have looked around and found a few books about financial modeling but I was wondering if there are any books that are critical (or thought of as so) for current students to read before any internships or jobs. I'd rather get any suggestions straight from the people that are where I want to be than a suggested reading list.

Thanks in advance!

I work at a small firm and they offered to pay for me to take a financial modeling course of some kind since we don't really have any structured training.

I go to NYC quite a bit so I was thinking maybe attending a Training the Street workshop or some kind there, is that the best option? I am looking for like a 2 day crash course into excel/modeling.

I work in a small PE type of shop, so looking for something with that focus.

Hi everyone,

Kind of desperate here and couldn't find this in the search option, does anyone here know where I can find sample revenue models use for revenue planning, or any material related to it?

thanks!

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 a good reference would be huge. I really appreciate your help.

My assignment is due Friday, so time is of the essence.

Thanks!

Any courses you recommend? I know im young but this can help me get into college (seriously, there are competitions for this).

I apologize if this has already been covered in a previous thread, but what do you guys think are best financial modeling educational materials---which books, videos, or learning guides should I be looking at?

Thanks very much

A couple analysts who are currently in training asked me for advice. Since they didn't have a summer internship in banking, they are worried about already being behind. My advice is not to worry too much. The two-year analyst experience is not a sprint. It is a marathon and a particularly long one. You will have plenty of time to prove yourself. However, I do advise you to take the following things to heart before you start:

Take a lot of notes
One of the key elements to becoming a successful monkey is to take as many notes as possible. Write everything down! Anytime you get a piece of advice write it down. You get the point.

Organize your notes

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 opportunities.

For Khar Real Estate, it would be an in-person course that would cost $850. On the other hand, the Real Estate Financial Modeling class provides a "certificate" of proof after passing some type of examination and is only $400.

What do you guys think? This question is especially geared towards those real estate professionals with experience reviewing analyst/intern resumes.

Thanks for any advice!

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 have a constraint to pay down all of the debt and interest by year 3. We have made assumptions as to the sale prices per acre of each of the lots in each of the bucket. bucket one has about 3 lots and bucket B has about 7 and derived the cashflows and the debt paydown schedule.

We want to figure out what is the minimum price per acre for each of the lots we can afford to sell at to be able to paydown the debt by the end of year 3 as stipulated.

A bit of background: I'm currently at a junior associate level at the PE fund of mid-market investment bank. My current role is very operationally heavy, and I essentially act as a financial director at one of our portfolio companies. This is not a very exciting position, as while the level responsibility is good, it essentially boils down to taking care of a lot of admin-type work to make sure the company's project is progressing, our lenders are happy, and there is money in the bank account.

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.

I noticed that BIWS and Wall Street Prep are the only two offering videos/guides in this area, but the prices seemed pretty steep. For those who have gone through the BIWS/Wall Street Prep package for oil and gas:

1) Is it worth it? ($250 for BIWS and $500 for Wall Street Prep)
2) Which one is better?
3) Are there any other resources besides these?

http://www.mergersandinquisitions.com/industry-spe...
http://www.slideshare.net/hfbe/oil-and-gas-company...

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 choosing the correct amount of cells in a row for both the date and the input values. I do not know macros, so I was wondering if there was another way of doing this? Thanks