Loading...

Course Description

The objective of this course is to introduce students to the current practices in financial modeling and data analysis. Students will learn how to manipulate financial data and how to perform analysis using various analytical tools. This hands-on course provides the skills to apply the theories, concepts, and tools to develop spreadsheet knowledge that is used for effective financial analysis and decision-making. Students will learn how to build their own interactive financial model “from scratch” to practice blending finance, accounting, and Excel skills. In addition, this course focuses on developing spreadsheet skills for financial statement analysis and forecasting, stock and bond valuation, target capital structure estimation and capital budgeting. Particular emphasis is placed on the discounted cash-flow analysis as well as simple and multiple regressions.

Course Objectives

Upon completion of this course, the successful student should able to:

  • Evaluate balance sheet, income statement, and statement of cash flows relationships.
  • Build a quick discounted cash flow (DCF) analysis.
  • Build simple models for financial statement analysis and forecasting.
  • Create working capital, depreciation and capital expenditure schedules.
  • Perform sensitivity analysis to match expected financial performance.
  • Utilize strategies for creating a reliable financial model.

Notes

This course is an open enrollment course. No application is required and registration is available by clicking "Add to Cart." Current students must register with their Georgetown NetID and password. New students will be prompted to create an account prior to registration.

Course Prerequisites

There are two pre-requisites for the course:

  • The course is taught using Microsoft Excel. Students must bring a laptop computer with Microsoft Excel to class. Students should have a working knowledge of Microsoft Excel. 
  • This is an intermediate course in finance. Students are expected to have a basic understanding of core financial concepts. Students who have not completed academic coursework in finance or do not have the requisite professional experience must complete Principles of Finance (XCPD-684) before enrolling in the course. Students without basic knowledge of financial concepts must receive permission from the instructor to enroll in the course.

Applies Towards the Following Certificates

Loading...

Enroll Now - Select a section to enroll in

Type
Class
Days
F
Time
6:30PM to 9:30PM
Dates
Nov 13, 2020 to Nov 20, 2020
Type
Class
Days
Sa
Time
9:00AM to 4:00PM
Dates
Nov 14, 2020 to Nov 21, 2020
Schedule and Location
Contact Hours
18.0
Course Tuition
Tution non-credit $1,055.00
Section Notes

Welcome to the Flex Learning Experience - Real-time learning using live Zoom video conferencing— mirroring a more traditional classroom with regular interaction, - engaging activities, and the dynamic exploration of topics and concepts.

  • Dynamic exploration of topics, ideas and concepts with the instructor and students in the class
  • Interact regularly and frequently with your instructors and other students
  • Comparable level of accountability and engagement as classroom attendance
  • Lectures, discussions, and presentations occur at a specific hour
  • Face-to-face discussion, individual guidance, speed and immediacy to synchronous online learning
  • Immediate feedback - encouraging quick feedback on ideas, and support consensus and decision making
  • Pacing - encouraging students to keep up-to-date and provide a discipline to learning
  • Spontaneity - making it easy to add new ideas to the conversation, brainstorming or decision making
  • Familiarity - simulating a more traditional face-to-face environment
Type
Class
Days
F
Time
6:30PM to 9:30PM
Dates
Apr 09, 2021 to Apr 16, 2021
Type
Class
Days
Sa
Time
9:00AM to 4:00PM
Dates
Apr 10, 2021 to Apr 17, 2021
Schedule and Location
Contact Hours
18.0
Course Tuition
Tution non-credit $1,055.00
Section Notes

Welcome to the Flex Learning Experience - Real-time learning using live Zoom video conferencing— mirroring a more traditional classroom with regular interaction, - engaging activities, and the dynamic exploration of topics and concepts.

  • Dynamic exploration of topics, ideas and concepts with the instructor and students in the class
  • Interact regularly and frequently with your instructors and other students
  • Comparable level of accountability and engagement as classroom attendance
  • Lectures, discussions, and presentations occur at a specific hour
  • Face-to-face discussion, individual guidance, speed and immediacy to synchronous online learning
  • Immediate feedback - encouraging quick feedback on ideas, and support consensus and decision making
  • Pacing - encouraging students to keep up-to-date and provide a discipline to learning
  • Spontaneity - making it easy to add new ideas to the conversation, brainstorming or decision making
  • Familiarity - simulating a more traditional face-to-face environment

 

Required fields are indicated by .