By distilling key information regarding cash flow levels and risks, financial modeling helps decision-makers make informed choices based on data analytics that move their firms forward. In this course, learn how to build financial models that can be used in corporate finance, investment banking, commercial banking, and portfolio management. Professor Michael McDonald covers financial statement models, investment banking models, M&A models, buyout models, and DCF models—all using Microsoft Excel. Throughout the course, Michael includes exercises—together with downloadable exercise files—that can provide you with a practical understanding of these key topics.
Learn More- Seek Your Pathways
- Explore Academics
- Anthropology
- Communication
- Economics
- Journalism
- Landscape Architecture
- Legal Studies
- Managerial Economics
- Political Science
- Public Policy
- Environmental & Natural Resource Economics
- Social Thought & Political Economy (STPEC)
- Sociology
- Sustainable Community Development
- SBS Exploratory Track
- Minors, Certificates, and More
- SBS 4+1 Accelerated Masters Programs
- Explore Careers
- What are Career Communities?
- Advertising / Public Relations / Marketing
- Business / Entrepreneurship / Management / Consulting
- Health / Research / Education / Culture
- Environment / Natural Resources / Sustainability
- Finance / Investment / Real Estate / Insurance
- Government / Public Policy / International Relations
- Law / Legal Services / Criminology / Forensics
- Media / Journalism / Entertainment
- Non-Profit / Social Justice / Activism
- Technology / Data / Analytics
- Our Diverse Communities
- What Are Diverse Communities?
- SBS RISE: Remedying Inequity through Student Engagement
- Black, Indigenous & Students of Color
- First Generation Students
- International Students
- LGBTQIA+ Students
- Student Athletes
- Students with Disabilities
- Students with Financial Need
- Transfer Students
- Veterans
- Women in the Workforce
- Post-Grad Planning
- Who We Serve
- How do I?
- Complete Academic/Degree Tasks
- Apply for Scholarships and Awards
- Declare an SBS Major
- Meet with an Academic Advisor
- Meet with an Academic Dean
- Suggest New Courses
- Petition for Late Add
- Petition for Pass/Fail
- Withdraw from a Class/Petition for Late Withdrawal
- Petition for Course Credit Overload
- Release Academic Information (FERPA)
- Withdraw from the University
- Explore Majors, Experiential, and Professional Pathways
- Apply for Funding for Internships, Study Abroad, Research, and other High-impact Opportunities
- Assess My Skills and Interests
- Explore Majors
- Find an Undergraduate Research Opportunity
- Get Involved on Campus
- Learn about Different Career Paths
- Study Abroad
- Take Courses through the Five Colleges
- Domestic Exchange
- Get Career Ready
- Apply for Scholarships to Support Research or Internships
- Develop My Job Search Skills & Strategy
- Look for Internships and Jobs
- Meet with a Career Advisor
- Negotiate an Offer
- Network and Connect with Mentors
- Prepare a Resume and Cover Letter
- Prepare for/Navigate a Career Fair
- Prepare for an Interview
- Register an Internship for Credit
- Write a Personal Statement for Graduate School
- Complete Academic/Degree Tasks