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 with boxes around them like this =>
Enter your name in
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 the Net Present Value of operating cash flow
Fill out
$
$
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 cells with boxes around them like this =>
$
$
$
$
$
En
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 table
5. How to set up data for a chart
Fill out the cell
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
Fill out the cells with boxes around them like this =>
E
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 with boxes around them like this =>
Enter your name in th
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 into an Excel table
Fill out the cells with boxes around t
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 them like this =>
Enter your name in this box =>
Proble
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 =>
Enter your name in this box =>
Tutorial 11 - Capital
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
3. How to estimate the present value of a share of com
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 cells with boxes around them like this =>
Enter your name
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 values into an Excel table
Fill out the cells with boxes
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 of the reader e.g. Confirmation, answers or
feedback