020314210 FINANCIAL MODELING ( 3 Crd.Hrs )

Pre-Requisites : 020313110, 110411000

The purpose of this course to provide the students with background to some problems in corporate finance that are highly numerically intensive, such as the introduction to basic financial calculation using excel. Almost all of the applications discussed center on variations of the discounted cash flow method, the cost of capital, the rate at which corporate cash flow is discounted to arrive at enterprise value, how to build pro forma modules which simulate the cooperate income statement and balance sheet pro forma models are the heart of many corporate finance applications, including business plans, credit analysis and valuations. The models require a mixture of finance accounting and excel. Use pro forma to do a valuation of a firm financial analysis of leasing, financial analysis of leveraged lease arrangement.