Financial Modeling Best Practices – Part 2

The following video is borrowed from our BusinessTraining.com platform and was originally recorded for our investment banking training program. Financial modeling is fundamental to a career in investment banking so we’ve enlisted the help of investment banking veterans to help us create high-quality free content on this important topic.  Here is the second of a two part series on financial modeling best practices.  To watch part one of this series, click here.


Video Transcript/SummaryThe strategies and tips provided within this video module include:

  1. Coming soon.

I hope that this video has shown you some important financial modeling best practices.  To watch part one of this series, click here.

Your friends here at https://investmentcertifications.com

Basic Financial Modeling – Part 3 of 3

Below is a free-to-watch video module on basic financial modeling.  A financial model is a tool used to forecast a business’s results and is designed to be able to evaluate multiple scenarios.  Investment bankers are expected to be experts in financial modeling.  This video is three of three video modules in our series: Basic Financial Modeling.  Click here for part one of this series.  Click here for part two.

This video was taken from our Certified Investment Banking Associate (CIBA) program which is the investment banking certification and training program hosted on our BusinessTraining.com platform.



Video Transcript Summary of Basic Financial Modeling
:

  • The following are the final steps in the process for creating a basic financial model:
    • Setup debt and interest schedule including: interest rates, beginning balances, new borrowing, amortization of new or existing borrowing, and ending balances and interest amounts.
    • Link interest to IS.  Continue IS forecast through bottom line.
    • Link debt balances to balance sheet.
    • Input line of credit borrowing repayment calculation on cash flow statement and link its activity to debt schedule.
    • Finally, link ending cash from cash flow statement to top of balance sheet, calculate interest earned on cash on income statement.  
This is part three of our series on basic financial modeling.  Click here for part one of this series.  Click here for part two.  

Your friends here at https://investmentcertifications.com