The model forecasts the firm’s financial statements for five years and then discounts it projected dividends to estimate the value of the stock

• The model uses publicly available information and private insights about the firm to forecast its financial statement and subsequent growth rates
• Created pro forma financial statements using the percent of sales method
• Balanced Income Statement, Balance Sheet and calculated earnings per share, Issued stock and bonds
• Applied discounted cash flow framework to the dividends
• Estimated stock value using projected Dividend per share and Free Cash Flow to Equity (FCFE) per share

Financial Analytics: Income statement, balance sheet, depreciation, retained earnings, process for issuing bonds and common stock, leveraging and deleveraging common stock beta, valuation of stock