Tutorial 9.
Discounted Cash-Flow Analysis
What you will learn:
1. How to estimate the depreciation of an asset and calculate cash flows
2. How to create an after-tax cash flow table
3. How to estimate
Tutorial 2.
Present Values
What you will learn:
1. How to find the present value of an annuity
2. How to write formulas with relative and absolute references
3. How to copy formulas
4. How to use a ta
Tutorial 12.
Stock Returns and Variance
What you will learn:
1. How to estimate stock returns
2. How to estimate stock return standard deviation
3. How to work with historical data
Fill out the cells
$
$
Tutorial 13.
Covariance and Correlation
What you will learn:
1. How to find the covariance of historical data data sets
2. How to find the correlation between two historical data sets
Fill out the
Tutorial 3.
Present Values of Uneven Cash Flows
What you will learn:
1. How to find the present value of uneven cash flows
2. How to use the Excel Wizard
3. How to write formulas
Fill out the cells wi
Tutorial 7.
Bond Valuation
What you will learn:
1. How to estimate the present value of a bond
2. How to estimate the present value of a bond using the Excel Wizard
3. How to estimate the YTM or IRR
F
Tutorial 10.
NPV & IRR Investment Criteria
What you will learn:
1. How to find the Internal Rate of Return
2. How to compare a project's IRR with it's NPV
3. How to write formulas and enter values int
Tutorial 4.
Future Values of Cash Flows
What you will learn:
1. How to find the future value of cash flows
2. How to use the Excel Wizard
3. How to write formulas
Fill out the cells with boxes around
Tutorial 11.
Capital Structure
What you will learn:
1. How to estimate the effect of financial leverage
2. How to write formulas in a complex table
Fill out the cells with boxes around them like this
Tutorial 8.
Stock Valuation
What you will learn:
1. How to estimate the present value of a share of common stock
2. How to estimate the present value of a share of common stock with constant dividends
Tutorial 6.
Calculating Loan Payments and Loan Amortization
What you will learn:
1. How to find yearly payments
2. How to find monthly loan payments
3. How to use an amortization table
Fill out the ce
Tutorial 5.
Future Values of Uneven Cash Flow Stream
What you will learn:
1. How to find the future value of uneven cash flow streams
2. How to use an Excel table
3. How to write formulas and enter va
Sample Memo Format / Template
TO:
FROM:
DATE:
SUBJECT:
First Sentence: Reason for the communication
Body of the memo: Any Instructions, information, or reflections
Closing Sentence: What is required o