{"id":1581,"date":"2020-04-07T04:00:00","date_gmt":"2020-04-07T04:00:00","guid":{"rendered":"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/?page_id=1581"},"modified":"2020-06-06T23:56:22","modified_gmt":"2020-06-07T03:56:22","slug":"wall-street-prep","status":"publish","type":"page","link":"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/wall-street-prep\/","title":{"rendered":"Wall Street Prep"},"content":{"rendered":"\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"232\" class=\"wp-image-1649\" src=\"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/wp-content\/uploads\/sites\/2\/2020\/04\/logo-wsp-1.jpg\" alt=\"\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote has-text-align-left is-style-large is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p>From the Wall Street Prep team, a big thanks to the Bowdoin College Finance Society for hosting and allowing us the opportunity! We hope everyone found it valuable!<\/p>\r\n<cite><strong>-Andrew Federico: Wall Street Prep Senior Instructor<\/strong><\/cite><\/blockquote>\r\n\r\n\r\n<hr \/>\r\n\r\n\r\n<p>Get the edge you need to land a top investment banking, private equity, or corporate finance internship or job. Be prepared for interviews, internships and hitting the desk full-time by getting a head start with\u00a0Wall Street\u2019s Financial Modeling Workshop specifically designed for undergraduates. Open to students of all class years.\u00a0This session will introduce participants to Excel and the fundamentals of 3 statement modeling. Participants will learn how to forecast the 3 financial statements, balance a model, and handle issues related to circularities. Best practices will be incorporated throughout the course.<\/p>\r\n\r\n\r\n\r\n<p>Workshop participants will gain 12-month access to Wall Street Prep\u2019s Excel &amp; Financial Statement Modeling online courses following the Workshop.<\/p>\r\n\r\n\r\n\r\n<p><strong>Excel and modeling fundamentals:<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Optimal excel settings<\/li>\r\n<li>Key shortcuts<\/li>\r\n<li>Formula construction<\/li>\r\n<li>Matrix integrity<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>3 statement modeling:<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Steps to building a model<\/li>\r\n<li>Income statement construction<\/li>\r\n<li>Supporting calculations and debt schedule<\/li>\r\n<li>Balance sheet and cash flow statement construction<\/li>\r\n<li>Balancing the model<\/li>\r\n<li>Understanding circular references and building a circ breaker<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>Corporate Valuation<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Valuation Fundamentals<\/li>\r\n<li>Trading Comparables Analysis<\/li>\r\n<li>Transaction Comparables Analysis<\/li>\r\n<li>Discounted Cash Flow Analysis<\/li>\r\n<li>LBO\u00a0Valuation<\/li>\r\n<li>Advanced Valuation Methodologies and Analyses<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>Financial Modeling and Excel<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Introduction to Excel and 3 Statement Forecasting<\/li>\r\n<li>Real Company Modeling<\/li>\r\n<li>Cash Sweep Modeling<\/li>\r\n<li>Modeling from the Ground Up<\/li>\r\n<li>Checking and Editing a Model<\/li>\r\n<li>Advanced Excel Features I, II<\/li>\r\n<\/ul>\r\n<hr \/>\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p>\u201cOur on-campus boot camps and online Student Passport program\u00a0bridge the gap between academic training and on-the-job expectations to prepare\u00a0students for life on the desk.\u201d<\/p>\r\n<cite>-Wall Street Prep<\/cite><\/blockquote>\r\n<blockquote><br \/><hr \/><\/blockquote>\r\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; &nbsp; From the Wall Street Prep team, a big thanks to the Bowdoin College Finance Society for hosting and allowing us the opportunity! We hope everyone found it valuable! -Andrew Federico: Wall Street Prep Senior Instructor Get the edge you need to land a top investment banking, private equity, or corporate finance internship or [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":1647,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"class_list":{"0":"post-1581","1":"page","2":"type-page","3":"status-publish","4":"has-post-thumbnail","6":"entry"},"_links":{"self":[{"href":"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/wp-json\/wp\/v2\/pages\/1581","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/wp-json\/wp\/v2\/comments?post=1581"}],"version-history":[{"count":0,"href":"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/wp-json\/wp\/v2\/pages\/1581\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/wp-json\/wp\/v2\/media\/1647"}],"wp:attachment":[{"href":"https:\/\/students.bowdoin.edu\/bowdoin-college-finance-society\/wp-json\/wp\/v2\/media?parent=1581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}