Financial Modeling in Excel - DCF Valuation Model of Apple
Perform financial analysis, forecasting, business valuation techniques and financial modeling for company Apple Inc.
4.60 (189 reviews)
8 068
students
8.5 hours
content
Sep 2024
last update
$59.99
regular price
What you will learn
Understand the fundamentals of financial modeling. Learn how to read and interpret annual reports.
Master techniques for forecasting revenue. Calculate and understand cost sheet elements. Link cost sheet data to income statement.
Learn Earnings Per Share (EPS) calculations. Understand computing weighted average shares.
Explore components of the balance sheet. Calculate net working capital. Understand the cash conversion cycle. Learn to forecast accounts receivable.
Build accurate assumptions for balance sheet forecasting.
Forecast capital expenditures. Use a waterfall for depreciation forecasting. Calculate the ending net property, plant, and equipment.
Understand common stock and retained earnings. Learn techniques for forecasting dividends.
Forecast other current and non-current liabilities. Learn to forecast long-term debt. Understand interest expense calculations.
Link debt components accurately. Handle circular references effectively. Understand the mechanics of Discounted Cash Flow (DCF) valuation.
Model the cost of debt. Calculate Weighted Average Cost of Capital (WACC). Understand weighted average interest rates.
Grasp the concept of WACC. Understand time value of money. Calculate risk-free rate, beta, and equity risk premium. Determine market value of equity and debt.
Explore concepts of Free Cash Flow to the Firm (FCFF) and Free Cash Flow to Equity (FCFE). Learn calculations for FCFF.
Understand NPV calculations. Calculate target share price. Perform sensitivity analysis. Explore the relation between growth rate and valuation.
Understand exit options. Gain additional insights into valuation.
Students will have a comprehensive understanding of financial modeling techniques, enabling them to create robust and accurate financial models
Loading charts...
Related Topics
5260950
udemy ID
08/04/2023
course created date
17/04/2023
course indexed date
Bot
course submited by