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 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
FINA3313-005 Homework1 Fall 2015
FINA3313-005 Homework 1
Chapter 01 Goals and Governance of the Corporation
True / False Questions
1
The liability of sole proprietors is limited to the amount of their investment in the company.
True False
2
The separation
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 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 =>
mortization
Ent
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 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 =>
Cash Flows
Enter your
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
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 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 dividend
3. How to estimate the present value of a share of comm
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
Chapter 01 Goals and Governance of the Corporation
What is business finance about? Investment and Financing Decisions.
Types of business organization and their characteristics
-Sole Proprietor, General Partnership, Corporation (Know their advantages/disad
Welcome to the TIME VALUE of MONEY TUTORIAL !
What you need to know:
1. The next worksheet has a review of finance and Excel basics.
2. The problem worksheet is the tutorial sheet you must solve, print, and hand in.
3. Credit is given only for the printed
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 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 =>
Xavier
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 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 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 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
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
Welcome to the TIME VALUE of MONEY TUTORIAL !
What you need to know:
1. The next worksheet has a review of finance and Excel basics.
2. The problem worksheet is the tutorial sheet you must solve, print, and hand in.
3. Credit is given only for the printed
$
$
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 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 =>
Xavier Krone
Tutorial