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
Introduction to Financial Statements in Power BIDataCamp Financial Analysis for Startups
Yonsei University via Coursera تحليل أداء الشركة باستخدام النسب
Coursera Project Network via Coursera Corporate Financial Statement Analysis
LinkedIn Learning Corporate Financial Statement Analysis
LinkedIn Learning