Summary of Financial Ratios
Valuation Ratios:
NI
Average # of Shares Outstanding
Dividends
DPS =
Average # of Shares Outstanding
Price
P E =
EPS
Price
Price
P B=
=
Equity per Share Equity/Average # Sh
10-1
Budgetary Planning
CHAPTER 10
Budgetary PlannING
Summary of Questions by Objectives and Blooms Taxonomy
Item
SO
BT
Item
SO
BT
Item
1
1
1
1
1
1
K
C
C
C
C
K
2
2
2
3
2
2
3
3
3
3
2
2
2
2
3
2
2
2
3
3
Future Value of a Lump Sum
Objective:
Calculate the FV of a lump sum at the end of every year for the next 20 years.
Illustrate the difference between simple interest and compound interest.
Author
Dat
Financial Modeling I: Assignment #1 Fall 2017
Notes:
1. You should submit your assignment electronically using the drop-box on the D2L
page for the course.
2. Every student should submit their own ind
capital spending - Additions to NWC
OCF = Net Income + Depn + Interest Paid (1) O
CF = EBIT + Depn Taxes
Net Capital Spending = Net Fixed Assets End Ne
t Fixed Assets Beg + Depn
Additions to NWC = NWC
capital spending - Additions to NWC
OCF = Net Income + Depn + Interest Paid (1) O
CF = EBIT + Depn Taxes
Net Capital Spending = Net Fixed Assets End Ne
t Fixed Assets Beg + Depn
Additions to NWC = NWC
BUSI 3705U
Legal Environment of Business
Sample Review Questions
Multiple Choice Question
1. The ability to exclude others from using
technology arises from which of the
following:
a. Copyright
b. Ind
BUSI 3705U
Legal Environment of Business
Sample Review Questions
Multiple Choice Question
Correction
1. The ability to exclude others from using
technology arises from which of the
following:
a. Copyr
Future Value of a Lump Sum
Objective:
Calculate the FV of a lump sum at the end of every year for the next 20 years.
Illustrate the difference between simple interest and compound interest.
Author
Dat
Boolean Comparisions and Truth Tables
1
0
0
Excel represents TRUE internally with the number 1 and FALSE with 0
1
0
0
Truth Table for logical AND
p
q
1
1
0
0
AND
1
0
1
0
p
1
0
0
0
q
1
1
0
0
multiplica
vlookup
Looking up values in a table
e.g. #1 Assigning a grade - Approximate Match
Mark
Notes:
To use vlookup for an approximate match table should be exclusive and exhaustive
and listed in ascending
Amortization Table
Objective:
Create an amortization table for a N year loan.
Calculate the interest and principal components of each payment
Illustrate automating a tables length and data validation
Finding Required Rate of Return
Objective:
Problem:
Simple TVM problem used to demonstrate the use of goal seek and solver
You plan to deposit $5,000 into an account every year for the next 10 years t
Boolean Comparisions and Truth Tables
1
0
0
Excel represents TRUE internally with the number 1 and FALSE with 0
1
0
0
Truth Table for logical AND
p
q
1
1
0
0
AND
1
0
1
0
p
1
0
0
0
q
1
1
0
0
multiplica
Fairmont Moulding Systems Inc.
Company Name
Ticker
Latest Fiscal year end date
Income Statement
Fiscal year
Fiscal year end date
Fairmont Moulding Systems Inc.
FMS
9/29/2014
Units
2010A
9/29/2010
2011
Boolean Comparisions and Truth Tables
1
0
1
0
Excel represent TRUE internally with the number 1 and FALSE with 0
1
0
0
1
1
1
0
1
Truth Table for logical AND
p
q
1
1
0
0
AND
1
0
1
0
p
1
0
0
0
q
1
1
0
0
Boolean Comparisions and Truth Tables
1
0
0
Excel represents TRUE internally with the number 1 and FALSE with 0
1
0
0
Truth Table for logical AND
p
q
1
1
0
0
AND
1
0
1
0
p
1
0
0
0
q
1
1
0
0
multiplica
BUSI 3705U
Legal Environment of Business
Sample Review Questions
Multiple Choice Question
1. The ability to exclude others from using
technology arises from which of the
following:
a. Copyright
page 4
Three Stage DDM
Dividend at (:D
Included (2)
High Growth Rate
High Growth Period (years)
Stable Growth Rate
Stable Growth Rate starts in period:
Required Return
Value cfstock [14)]
Year
auNt-
Boolean Comparisions and Truth Tables
Excel represent TRUE internally with the number 1 and FALSE with 0
Truth Table for logical AND
p
q
TRUE
TRUE
FALSE
FALSE
AND
p
TRUE
FALSE
TRUE
FALSE
q
TRUE
TRUE
F