Free Model-Formatting Course

Summary This is not a financial modeling course like the one that is offered at Wall Street Prep, Investment Banking Institute or Analyst Exchange. Mod Note Not WSO competing products. Rather this is a series of free tutorials that help modelers on best practices on how to do modeling (formatting, structure, setting up).

I completed the 30 days challenge and I can definitely see that my modeling skills have improved a lot. Would highly recommend “experienced” Monkeys to tried it out. Once again, it does not teach you modeling. It is more focused on best practices on setting the cells, formatting and building a structure to make your modeling easier and standardized across the banks.

F1F9Academy 31 Days Challenge
Main Page: http://www.f1f9academy.com/free-31-day-financial-modelling-course
Day 1: http://www.f1f9academy.com/31days/welcome
Day 2: http://www.f1f9academy.com/31days/excel-productivity
Day 3: http://www.f1f9academy.com/31days/column-structure
Day 4: http://www.f1f9academy.com/31days/formula-construction
Day 5: http://www.f1f9academy.com/31days/row-totals
Day 6: http://www.f1f9academy.com/31days/formula-consistency
Day 7: http://www.f1f9academy.com/31days/F11-quick-chart
Day 8: http://www.f1f9academy.com/31days/customising-the-f11-quick-chart
Day 9: http://www.f1f9academy.com/31days/heading-columns
Day 10: http://www.f1f9academy.com/31days/inputs
Day 11: http://www.f1f9academy.com/31days/fast-format-macros
Day 12: http://www.f1f9academy.com/31days/assignment-part-1
Day 13: http://www.f1f9academy.com/31days/assignment-part-2
Day 14: http://www.f1f9academy.com/31days/errors-in-financial-modelling
Day 15: http://www.f1f9academy.com/31days/calculation-blocks
Day 16: http://www.f1f9academy.com/31days/navigating-using-links
Day 17: http://www.f1f9academy.com/31days/daisy-chains
Day 18: http://www.f1f9academy.com/31days/copying-links
Day 19: http://www.f1f9academy.com/31days/assignment-revisited
Day 20: http://www.f1f9academy.com/31days/copying-calculation-blocks
Day 21: http://www.f1f9academy.com/31days/row-anchoring-in-calculation-blocks
Day 22: http://www.f1f9academy.com/31days/placeholders
Day 23: http://www.f1f9academy.com/31days/listing-placeholders
Day 24: http://www.f1f9academy.com/31days/timing-flags
Day 25: http://www.f1f9academy.com/31days/cross-worksheet-links
Day 26: http://www.f1f9academy.com/31days/paste-link
Day 27: http://www.f1f9academy.com/31days/advanced-productivity-paste-link
Day 28: http://www.f1f9academy.com/31days/advanced-productivity-shortcut-macros
Day 29: http://www.f1f9academy.com/31days/modelling-balances
Day 30: http://www.f1f9academy.com/31days/template-sheet
Day 31: Link to the seminar, useless

Previous post: http://www.wallstreetoasis.com/forums/nyssa-equity-research-initiation-…
NYSSA IRC Timeline: http://www.box.com/s/1cef775bf8f209f27078
NYSSA IRC Previous Year Winner NYU on PVH: http://www.box.com/s/a086141839effba4c25e
NYSSA IRC Judging Criteria (Presentation): http://www.box.com/s/9163f162c5eb145298d8
NYSSA IRC BITS Report: http://www.box.com/shared/p1n6t7vggi
NYSSA IRC BITS Model: http://www.box.com/s/c4a49d276c687078b3da
NYSSA IRC BITS Presentation: http://www.box.com/s/a85867fc5e429f3ff859
NYSSA IRC BITS Presentation Q&A: http://www.box.com/s/ecb1963a5bab5a3f3489
Quick Overview on Valuation: http://www.box.com/s/810cdfb62535f3081456
Equity Research Analyst Handbook: http://www.box.com/s/95be1f229c51661b9cd9

Another useful post: http://www.wallstreetoasis.com/forums/personal-development-0

To keep you guys motivated http://www.wallstreetoasis.com/forums/get-motivated-move-forward

15% Off wall st. prep Financial Modeling Training Click Here

 

I've been on this full course ( 2 days in person), for which this "challenge" (did it in a day like a baawss) is the intro course and i wouldn't wholly recommend it. They teach a very unique style of modelling which isn't very transferable.

"After you work on Wall Street it’s a choice, would you rather work at McDonalds or on the sell-side? I would choose McDonalds over the sell-side.” - David Tepper
 
Oreos:
I've been on this full course ( 2 days in person), for which this "challenge" (did it in a day like a baawss) is the intro course and i wouldn't wholly recommend it. They teach a very unique style of modelling which isn't very transferable.

I get MS for offering an opinion on a course which people seem to be interested in and which I have (on the firms money of course) completed, wow what has this site come to....

"After you work on Wall Street it’s a choice, would you rather work at McDonalds or on the sell-side? I would choose McDonalds over the sell-side.” - David Tepper
 
Oreos:
I've been on this full course ( 2 days in person), for which this "challenge" (did it in a day like a baawss) is the intro course and i wouldn't wholly recommend it. They teach a very unique style of modelling which isn't very transferable.

These courses are expensive ! What was the actual content of it ? what about the average age of the class?

 
Best Response
16rl:
Oreos:
I've been on this full course ( 2 days in person), for which this "challenge" (did it in a day like a baawss) is the intro course and i wouldn't wholly recommend it. They teach a very unique style of modelling which isn't very transferable.

These courses are expensive ! What was the actual content of it ? what about the average age of the class?

The course we had was in-house so can't say really opine on the normal clientele.

Content was from scratch modelling, with a focus on project finance. They teach a very individual style of modelling. they use A LOT of rows for the reason that EVERY (and i mean every) calculation has to have its constituents above it in a "calculation block", (you will never see SUM(A6,A45, A50) it'll be SUM(A51:A53) with A6 etc. copied) this does made reading models easy, no finding where things are from (which lets be honest isn't hard anyway) as all the parts are there for you, however this is time consuming and makes the models huge with a lot of repeated information. This approach is implemented with IFs (i.e. no nested IFs) which further increase the rows of superfluous calcs. in favour of easy reading.

They also insist on having spaces between every thing in your formulas (e.g. IF(A1=1,1,0) would be IF ( A1 = 1 , 1 , 0 )) which gets very boring, very quickly.

But the major disadvantage of this approach is that when you're teaching novices this method they become stumped when they're shown a normal model (so any model that you're sent from any other firm). They'll have no idea what they're looking at so, and this is where their business model comes into it's own, you can pay them to take the model apart and put it back in the way that you're able to read it. sounds wonderful, but what happens when you don't have time, when you move firms to a company who doesn't subscribe...you're fucked.

They also fail to use real world case studies on the course which I think is pivotal to the success of modelling courses.

"After you work on Wall Street it’s a choice, would you rather work at McDonalds or on the sell-side? I would choose McDonalds over the sell-side.” - David Tepper
 

The links to the days does not work for me, if you could kindly PM them, it would be greatly appreciated. Also, for someone with no modeling experience, would this be beneficial?

The difference between successful people and others is largely a habit - a controlled habit of doing every task better, faster and more efficiently.
 

Sit voluptate tenetur sunt ratione. Non laboriosam tempora ad nostrum magnam non illo. Iusto odio et dolorem sit dignissimos impedit et. Quae nihil distinctio quas voluptates inventore. Ea aperiam enim voluptatum voluptas qui ipsum autem officiis.

Velit neque iusto eligendi non aut nobis consequatur. Aliquam aut rerum sed fugit omnis. Itaque dolores et voluptates hic earum aut ea.

 

Ut perspiciatis inventore quidem debitis sed cum sunt. Voluptatum autem molestias similique tempore accusantium natus. Perspiciatis dolores pariatur excepturi occaecati eveniet nisi quod quisquam.

Illo magnam magnam ut est. Quibusdam ex quos blanditiis doloremque ducimus nemo similique sequi. Expedita laborum delectus non natus cupiditate doloribus reprehenderit. Omnis adipisci aut nisi ut enim neque reiciendis. Et cupiditate natus illo corporis qui. Quas autem officia tempore sed nostrum sit molestiae.

Ullam id dolores qui commodi aliquam tempora. Unde doloribus pariatur beatae ea qui ut. Architecto quia optio in tenetur voluptas quas.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”