Excel 2007: Financial Analysis
Offered By: LinkedIn Learning
Course Description
Overview
Provides a basic fluency in corporate finance, enabling users to grasp the meaning behind the calculations.
Syllabus
Introduction
- Welcome
- Using the exercise files
- Disclaimer
- Separating inputs and formulas
- Avoiding common mistakes
- Tracing formula precedents and dependents
- Evaluating Excel formulas step by step
- Tracking income and expenses using an Excel table
- Creating a Pivot Table from table data
- Pivoting a Pivot Table
- Filtering a Pivot Table
- Adding Pivot Table columns to enhance data analysis
- Tracking cash flow using a Pivot Chart
- Reading a corporate financial statement
- Introducing common-sizing strategies for analyzing financial statements
- Creating common-sized income statements
- Creating common-sized balance sheets
- Calculating percentage changes in financial statements
- Calculating earnings per share
- Calculating return on equity and return on assets
- Calculating gross profit margin and net profit margin
- Calculating the current ratio and quick ratio
- Calculating the average collection period
- Calculating inventory turnover
- Calculating the equity ratio
- Calculating the debt ratio
- Calculating the times interest earned ratio
- Calculating simple interest and compound interest
- Applying nominal versus effective interest rates (APR versus APY)
- Calculating the number of days between events
- Computing the future value of an investment
- Calculating present value
- Calculating net present value
- Calculating internal rate of return
- Calculating NPV and IRR for uneven input periods (XNPV and XIRR)
- Projecting future results using the Forecast function
- Performing quick forecasts using the Fill handle
- Adding a trendline to a chart
- Introducing amortization
- Calculating payments on a fully amortized loan
- Calculating payments on a partially amortized loan (balloon payments)
- Calculating interest and principal components of loan repayments
- Introducing depreciation
- Calculating straight line depreciation
- Calculating declining balance depreciation
- Calculating double declining balance depreciation
- Introducing bonds and bond terminology
- Calculating a bond's yield
- Calculating the value of zero coupon bonds
- Pricing bonds to be offered to investors
- Goodbye
Taught by
Curt Frye
Related Courses
Evaluación de Decisiones EstratégicasDiplomadas Ingenieria Industrial UC via NovoEd Основы корпоративных финансов (Fundamentals of Corporate Finance)
Higher School of Economics via Coursera Analyse Financière
First Finance Institute via First Business MOOC 财务会计概论(中文版)
University of Pennsylvania via Coursera Principles of Valuation: Time Value of Money
University of Michigan via Coursera