Go to Main Content

Ramapo College Information System



Catalog Entries


Fall 2021
Dec 06,2022
Transparent Image
Information Select the Course Number to get further detail on the course. Select the desired Schedule Type to find available classes for the course.

This is an Excel-intensive course in which we build and analyze a corporate financial model: a 3-statement model (i.e. income statement, cash flow statement, and balance sheet). The course has several key objectives: * Learn how to build integrated financial models * Understand the sensitivity of the model's key drivers * Develop efficient models with the use of Excel's financial functions and shortcuts * Use best practices in the construction of prolessional models * Analyze the model‘s key assumptions and the resulting output The course equips students with a deep understanding of the construction and analysis of a corporate financial model so that they can better identify the key drivers of corporate value and perform sensitivity analysis on these drivers. It offers useful guidelines and best practices in financial modeling and it exposes students to the complexity and subjectivity involved with integrating and projecting financial metrics.
0.000 TO 4.000 Credit hours
0.000 TO 4.000 Lecture hours

Levels: Undergraduate
Schedule Types: Hybrid, Lecture, Lecture/Online, Online Course

Finance Department

Return to Previous New Search XML Extract
Transparent Image
Skip to top of page