Bozhao Wang
This hands-on course focuses on the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards.
The course material includes model design, logic, construction, financial concepts and accounting treatment.
During the seminar, participants will build a model that includes a forecast of a company’s income statement, cash flow statement and balance sheet.
Skills / Knowledge
- Design a clear and logical financial model
- Discuss the need for a model to serve as a marketing tool
- Create clearly defined inputs and assumptions
- Connect strings of data to create assumptions and footnotes
- Use switches to create effective scenarios and value drivers
- Forecast and build-up a company’s revenues and expenses
- Design and incorporate a company’s income statement, balance sheet and cash flow statement
- Construct all necessary schedules
- Use Lookup functions within the model to effectively extract information
- Properly incorporate Senior Term Debt with an amortizing repayment schedule
- Create a robust Bank Operating Line (or Revolving Credit Facility)
- Design and incorporate a cash sweep for a company’s Bank Operating Line
- Balance the company’s balance sheet
Issued on
February 22, 2023
Expires on
Does not expire
Job Insights
These are the most common job titles and employers with the most open positions related to this credential.
Showing results for United States.