EasyAce Excel Training
Lecture 7 - Dynamic Charts
Lecture 8 - Pivot Table
EasyAce Excel Training - Lecture 7
Objectives
1.
2.
1.
2.
Period
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Iphone
Blackberry
382,004
364,204
222,520
181,176
507,399
867,96
24
25
26
Morning Afternoon Night
Morning Afternoon Night
Morning Afternoon Night
Arrival
MarynissenCasino?, Light show Gorge Trail,Golden Lotu
Pack, Leave
http:/mar https:/www.niagarafallstourism.chttps:/www.fallsviewcasinoresort.com/dining/business/golde
ACTSC 221
Written Assignment
Working individually or in pairs, students will write a 2-3 page (1.5 spaced) article on a personal financial
planning topic from the list below. The article will be written to explain the topic to a lay person, and would be
s
ACTSC 221
Quiz #6
Note: Numerical answers are rounded to 2 decimal places. Coupon rates and interest rates
are expressed in annual nominal rates.
1. Find the value of a 5-year bond with a 7% coupon paid semi-annually trading with a
yield to maturity of i(
ACTSC 221
Quiz #1
Note: Numerical answers are rounded to 2 decimal places.
1. Joe invests $1,000 for 4 years at an interest rate of 10% compounded annually. If Sam
invests the same amount also for 4 years, at what rate of simple interest does Sams
investm
ACTSC 221
Written Assignment #1
Case Study 1
Emily wants to buy a new car for $25,300, including all fees and taxes. Nows a good time
to buy, claims the salesman, were offering 4 year loans at 5.9%. Even if you have the
cash, youre better off borrowing. E
ACTSC 221
Quiz #2
Note: Numerical answers are rounded to 2 decimal places.
1. What is the price of a 30-day Government of Canada T-Bill if the rate is quoted at
2.2%? Assume a face value of $1,000.00.
(A) $998.17
(D) $998.21
(B) $998.19
(E) none of the ab
ACTSC 221
Written Assignment #3
Question 1
Pizza Pizza is planning to open a new outlet in the math building, since we all know mathies
love pizza. The details of the project are as follows:
The initial cost of the project will be $1 million. Assume this
ACTSC 221
Quiz #3
Note: Numerical answers are rounded to 2 decimal places.
1. What are the monthly payments on a $10,000 5-year loan if interest rates are i(12) =
6%?
(A) $193.33
(D) $2,373.96
(B) $197.83
(E) none of the above
(C) $618.76
2. Suppose you b
ACTSC 221
Quiz #5
Note: Numerical answers are rounded to 2 decimal places. Round up all payments to
the nearest penny unless otherwise stated.
1. John borrowed $10,000 for his new car. He plans to repay the loan with monthly
payments over 5 years. Suppose
ACTSC 221
Written Assignment #2
1. Tommy and Timmy Twintz want to establish a scholarship that makes two payments
every year. They want the first payment of $5,000 to go to the very first freshman
who arrives on campus. The second payment of $20,000 will
ACTSC 221
Quiz #7
Note: Numerical answers are rounded to 2 decimal places.
1. A company is considering two projects, A and B. Assume the cost of capital for the
firm is 5% and both projects cost $30,000. If the cash flows from the projects are as
follows,
ACTSC 221
Quiz #4
Note: Numerical answers are rounded to 2 decimal places.
1. What are the monthly payments on a $10,000 5-year loan if interest rates are i(2) = 6%?
(A) $192.59
(D) $194.11
(B) $192.99
(E) none of the above
(C) $193.33
2. John purchased a
EasyAce Excel Training
Lecture 7 - Dynamic Charts
Lecture 8 - Pivot Table
EasyAce Excel Training - Lecture 7
Objectives
1.
2.
1.
2.
Period
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Iphone
Blackberry
382,004
364,204
222,520
181,176
507,399
867,96
EasyAce VBA Training
ng
EasyAce VBA Training - Lecture 1
Objectives
1. Enable Macro and Developer's Tool
2. Macro Recording
3. VBE Interface
4. Sub and Function
5. Variables
6. Objects
7.
8. If Statement
9. Select Case
1. Enable Macro and Developer's Too
ACTSC 221
Review for Final Exam
Be aware of simple interest and how it differs from compound interest
Know how to calculate accumulated and discounted value for a single payment using a variety of rates and
compounding periods (including continuous compou
6.1: Terminology
6.2: Purchase Price to Yield a Given
Investment Rate to Maturity
Terminology:
F=Face Value: The value that the bond is issued at by the Company
P=Price or Market Price: The price of the bond in the market (set by supply and
demand forces)
5.1: Amortization of a Debt
What is Amortization?
A loan is repaid with payments of
R over a given term.
Each payment can be divided into
a part that repays the interest and
a part that repays part of the
outstanding principal.
Initially, most of the paym
Section 4.1 General
Annuities
If the compounding
frequency of the rate and
the frequency of the
deposits or withdrawals
dont match, then this is a
GENERAL ANNUITY
(as opposed to simple)
Two ways to handle this:
1) Do a rate change to match the
two frequen
3.1: Definitions
3.2: Accumulated Value of
Simple Ordinary Annuities
Annuity: a financial instrument that pays
you (usually) a set amount each period for a
set period of time
The flip side is true as well. We can view
situations were we pay into a fund or
EasyAce VBA Training
ng
EasyAce VBA Training - Lecture 1
Objectives
1. Enable Macro and Developer's Tool
2. Macro Recording
3. VBE Interface
4. Sub and Function
5. Variables
6. Objects
7.
8. If Statement
9. Select Case
1. Enable Macro and Developer's Too
EasyAce Excel Training
Lecture 3 - Data Validation
Lecture 4 - Advanced Data Analysis
EasyAce Excel Training - Lecture 3
Objectives
1. Data Validation
2. Conditional Formating
1. Data Validation
2. Conditional Formating
lecture
Objectives
Alt + D + L => D