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 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 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 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
EXCEL ASSIGNMENT FALL 2015
Using the Excel Assignment F15 spreadsheet, follow
the instructions below for each chapter. Omit any
references to printing your spreadsheets.
Rename the file to include your name.
Example: Jill Smith Excel Assignment F15
Chapte
CHAPTER 5- VALUING STOCKS
1.
A stock paying $5 in annual dividends sells now for $80 and has an expected return of
14%. What might investors expect to pay for the stock one year from now?
A)
$82.20
B)
$86.20
C)
$87.20
D)
$91.20
Answer: B Difficulty: Mediu
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 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 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 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
Week 7: Working Capital Management and Financial Planning - Discussion
Industry Approaches to Working Capital Financing (graded)
I really enjoy class Discussions and think they are a great way to learn the material in our courses. But
one thing that kind
Sales Mix Variance
Definition
Sales Mix Variance measures the change in profit or contributionattributable to the variation in the
proportion of the different products from the standard mix.
Topic Contents:
1. Definition
2. Formula
3. Explanation
4. Examp
Explain what non-financial factors might affect the Restoque and comercios Brazil
companys future value and success. The non-financial factors might include whether the
company:
a. Provides quality goods or services and has strong pipeline of future produ
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
1. Explain what non-financial factors might affect the Restoque and comercios
Brazil companys future value and success. The non-financial factors might
include whether the company:
a. Provides quality goods or services and has strong pipeline of future pr
Week 4: Stocks and Bonds - Discussion
Market Value of a Stock Versus DDM Value (graded)
I really enjoy class Discussions and think they are a great way to learn the material in our courses. But
one thing that kind of bothers me is that we all start off wi
Week 4: Stocks and Bonds - Discussion
Differences in YTM of Real Life Bonds (graded)
I really enjoy class Discussions and think they are a great way to learn the material in our courses. But
one thing that kind of bothers me is that we all start off with
Your Preference for Working Capital Management Policy (graded)
I really enjoy class Discussions and think they are a great way to learn the material in our courses. But
one thing that kind of bothers me is that we all start off with the same discussion pr
Week 6:
The Role of Financial Managers in Ethical Corporate Governance (graded)
I really enjoy class Discussions and think they are a great way to learn the material in our courses. But
one thing that kind of bothers me is that we all start off with the s
Sales Mix Variance
Definition
Sales Mix Variance measures the change in profit or contributionattributable to the variation in the
proportion of the different products from the standard mix.
Topic Contents:
1. Definition
2. Formula
3. Explanation
4. Examp
$
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 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
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 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 =>
Enter your name in th
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