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 # Shares
Dividends
Payout =
Net Income
EPS=
Profitability R
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
Date
Version
Akshay Gulrajani
9/8/2015
1
Inputs:
Present V
BondPricingUsingtheZeroCouponYieldCurve
Par Value
Spot and Forward Yield Curves as of Wednesday, July, 31 2013
$100
Zero Coupon Spot Rates (per annum (semi)
Maturity (years)
Annual Coupon Rate (%/yr)
Coupon Payment Frequency
Coupon per period
Remaining Co
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. Industrial design
c. Trademark
d. Patents
Multiple Choice
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. Copyright
b. Industrial design
c. Trademark
d. Patents page
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 437
b. Industrial design
c. Trademark
d. Patents
Multipl
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
AP
AP
AP
AP
AP
AP
AP
AP
AP
AP
AP
AP
AP
AP
AP
AP
AP
AP
A
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
Date
Version
Akshay Gulrajani
9/8/2015
2
Notes:
If you for
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
multiplication
1
1
0
0
1
0
0
0
Truth Table for logical OR
p
q
1
1
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
multiplication
1
1
0
0
1
0
0
0
Truth Table for logical OR
p
q
1
1
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 order (smallest to largest)
=vl + [Tab]
VLOOKUP(B8,$G$8
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
Mike Inglis
September 9, 2015
3
Author:
Date:
Version #
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 to pay for
your education. Your education will cost $20,
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
multiplication
1
1
0
0
1
0
0
0
Truth Table for logical OR
p
q
1
1
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
2011A
9/29/2011
Sales
Cost of Goods Sold
Gross Profit
Resea
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
multiplication
1
1
0
0
1
0
0
0
Truth Table for logical
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-Io
Vlodel
$2.00
No
12. 0%
3.00
5.0%
4
1
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
FALSE
FALSE
multiplication
TRUE
FALSE
TRUE
FALSE
Truth T
Amortization Table
Objective:
Create an amortization table for a 20 year loan.
Calculate the interest and principal components of
each payment
Mike Inglis
September 4th, 2012
Interest
1
Author:
Date:
Version #:
and Principal Components of an Amortized Loa
vlookup
Looking up values in a table
e.g. #1 Assigning a grade - Approximate Match
Grade
Using nested IF's
F
A
B
C
D
Mark
Notes:
To use vlookup for an approximate match table should be exclusive and exhaustive
and listed in ascending order (smallest to la
Mort age Calculat or:
T h u rs d a y, Au g u s t 0 7, 20 14
I n p u ts :
Principa l
I nterest Ra te % per yea r compounded semi-a nnua lly)
Effective Annua l Ra te (EAR)
Amortiz a tion Period (30 yea rs or less)
F u n c ti o n s
effec t
no mi na l
$ 10 0