Safari
Reflect in ePor!olio Print
Investment Calculato
Spreadsheet Assignment
1
Task: View this topic
CM
out of
10
Investment
Calculato
Spreadsheet
Assignment 1
You may choose to complete you
mathematical calculations by hand and
scan or take images to upload to the
dropbox. To help your teacher review you
work, please try to submit your calculations
as a single file document (preferably as a
pdf). If you aren’t sure how to do this,
please contact your teacher for assistance.
Important
When answering questions in a
mathematics course always be sure to
use the following guidelines to help you
do your best:
Provide full solutions, showing all of
your steps.
!
Make sure that there is one step o
idea per line.
!
Use one equal sign per line.!
Make sure that equal signs line up
vertically.
!
Don’t use self-developed short form
notations.
!
You are going to create a spreadsheet that
will have two functions:
1. Allow a user to input a regular payment,
an interest rate and a period of
investment, and will output the future
value, the total interest earned, the
monthly contribution and the average
interest earned per year.
2. Allow a user to input a desired future
value, an interest rate and a period of
investment, and will output the amount
of regular contribution you would need
to make, as well as total interest earned,
the monthly contribution and the interest
earned per year.
The chart will end up looking like this:
Given Output
R i n FV
Interest
Earned
Monthly
Contribution
Interest
Earned
pe
Yea
$ XXXXXXXXXX%1.00 $1000$1000$0.00$0.00$83.33$83.33$0.00$0.00
Given Output
i n FV R
Interest
Earned
Monthly
Contribution
Interest
Earned
pe
Yea
1.00%1.00 $1000$1000$1000$0.00$0.00$83.33$83.33$0.00$0.00
The grey cells are titles and don’t get
changed.
!
The white cells with black text are input
cells, where the user inputs values.
!
The white cells with (the last
ow under the Output heading) are
output cells. They are calculated values.
! red textred text
Note
You will need to develop formulae to
calculate each of the outputs. Remembe
that in Microsoft Excel, you will need to
start all calculations with an equal sign
(=). Instead of inputting numbers o
variables in your equations, you can refe
to cells that already have values in them.
So for example, if you want cell F6 to
display the value of cell A1 squared,
multiplied by the value of cell B3, you
would type in F6.=A1^2*B3
Note
To do exponents, you need to use the
sign.
^
You may need to use parentheses fo
certain functions. For example, if you
want to calculate the value of
…you would need to write it as
.
=
(A1+A2)^A3/(B1-B2)
Review the tutorial in the earlier lesson
about Microsoft Excel if any of this seems
unfamiliar. Also, watch the short video
elow that illustrates how the finished
product should function.
" Annuities Spreadsheet
Note that the cells representing , ,
Interest earned, monthly contribution and
interest earned per year should be
formatted as "accounting" cells; the cell
epresenting should be formatted as a
percent; and the cell representing n should
e formatted as a number.
R FV
i
If you have completed the assignment
properly, you will need to enter values into
the input boxes to avoid "division by zero"
e
ors in the output boxes (in
particular, can never be zero).i
Submit this assignment to the dropbox. This
assignment will be evaluated for a grade that
will contribute to your overall final grade in this
course.
Listen
Ac"vity Details
XXXXXXXXXX, 9:28 PM
Page 1 of 1
Safari
Reflect in ePor!olio Print
Investment Calculato
Spreadsheet Assignment
2
Task: View this topic
CM
out of
32
Investment
Calculato
Spreadsheet
Assignment 2
You may choose to complete you
mathematical calculations by hand and
scan or take images to upload to the
dropbox. To help your teacher review you
work, please try to submit your calculations
as a single file document (preferably as a
pdf). If you aren’t sure how to do this,
please contact your teacher for assistance.
Important
When answering questions in a
mathematics course always be sure to
use the following guidelines to help you
do your best:
Provide full solutions, showing all of
your steps.
!
Make sure that there is one step o
idea per line.
!
Use one equal sign per line.!
Make sure that equal signs line up
vertically.
!
Don’t use self-developed short form
notations.
!
If you have created a functional
spreadsheet in Part 1, then this part should
e relatively easy. All you need to do is put
values into your input boxes, and examine
the outputs. If you have not created a
functional spreadsheet in Part 1, you can
still complete the assignment using
equations in "the old fashioned way", but it
may be considerably more difficult.
1. Before you enter any values, make a
guess as to which of the following will
esult in the investment of the greatest
value. In other words, will you make
more money if: (1 mark each)
you invest $2000 per year for twenty
years at 2% interest you invest
$2500 per year for twenty years at 1%
interest?
!
oro
you invest $5000 per year for ten years
at 3% interest you invest $2000 pe
year for twenty years at 4% interest?
!
oro
you invest $2000 per year for five years
at 4% interest you invest $2000 pe
year for four years at 8% interest?
!
oro
you invest $2000 per year for twenty
years at 5% interest you invest
$2000 per year for twenty–one years at
4% interest?
!
oro
2. Using the spreadsheet (or any othe
means), determine the future value of
each of the investments described
above and record these. For each
choice, which option will make you more
money? (2 marks each)
3. Were the results what you expected?
Comment on how your predictions
compared to the outcome in each case.
(2 marks each)
4. Suppose that you want to make
$ XXXXXXXXXXthrough regula
investments. How much would you need
to contribute each year if:
a. The interest rate was 2% and you
invested for 20 years? (1 mark)
. The interest rate was 4% and you
invested for 10 years? (1 mark)
c. The interest rate was 4% and you
invested for 20 years? (1 mark)
d. The interest rate was 10% and you
invested for 20 years? (1 mark)
5. Determine an interest rate less than
15%, a period of investment greate
than two years, and a regular payment
that will result in the total amount of
interest you earn being equal to the total
amount of money you put in? (
) (3 marks)
Fo
example, under what conditions will you
have a future value of $ XXXXXXXXXX, having
earned $ XXXXXXXXXXinterest?
6. Do some research to find an
investment, like a GIC or a Canada
Savings Bond, that features a fixed rate
of compound interest. Report on what
that interest rate is. If you were to
contribute $5000 for five years, how
much interest would you earn over that
period of time? What if you contributed
$10 000 for 5 years? Do you think that it
would be worth investing your money in
this way? Why or why not? (5 marks)
(There are no right or wrong answers here,
ut you will be awarded for showing that
you have given the question some serious
thought and considered your options
carefully.)
Submit this assignment to the dropbox. This
assignment will be evaluated for a grade that
will contribute to your overall final grade in this
course.
Listen
Ac"vity Details
XXXXXXXXXX, 9:29 PM
Page 1 of 1
Safari
Reflect in ePor!olio Print
Caffeine Consump"on
Assignment
Task: View this topic
CM
out of
28
Caffeine
Consumption
Assignment
You may choose to complete you
mathematical calculations by hand and
scan or take images to upload to the
dropbox. To help your teacher review you
work, please try to submit your calculations
as a single file document (preferably as a
pdf). If you aren’t sure how to do this,
please contact your teacher for assistance.
Important
When answering questions in a
mathematics course always be sure to
use the following guidelines to help you
do your best:
Provide full solutions, showing all of
your steps.
!
Make sure that there is one step o
idea per line.
!
Use one equal sign per line.!
Make sure that equal signs line up
vertically.
!
Don’t use self-developed short form
notations.
!
When you drink coffee, tea, or hot
chocolate, or eat a chocolate bar, you
ody abso
s chemicals from these foods,
including caffeine. The amount of caffeine
in your bloodstream follows an exponential
pattern over time.
The highest level of caffeine in the
loodstream occurs 15 min to 45 min afte
drinking a beverage or eating a food with
caffeine. Then the level of caffeine begins
to fall.
The following graph shows the caffeine
level in the bloodstream of Peter, over time.
Peter is an adult smoker who has
consumed a cup of coffee (250 mL). The
coffee contains 125 mg of caffeine that
peaks in his bloodstream shortly afte
consumption. The graph starts at the time
when the caffeine level peaks (i.e.,
when the caffeine level peaks).
1. Using the graph, determine the amount
of caffeine in Peter's bloodstream afte
4.5 h. (1 mark)
2. Using the graph, determine when Pete
will have 20 mg of caffeine in his
system. (1 mark)
3. The time it takes for half of the original
amount of caffeine to remain in the
loodstream is called the half-life. Use
the graph to determine the half-life of
caffeine in Peter's bloodstream. Show
your work on the graph.
The half-life from the graph is:
________________. (2 marks)
The length of the half-life of caffeine is
affected by a number of factors, including
age. The following data shows the half-life
of caffeine for a variety of factors.
Factor Half-life
Adult non-smoker 5.5 h
Adult smoker 3.5 h
Woman who is six months
pregnant
10 h to
18 h
Newborn baby 100 h
8-month-old baby 4 h
6-year-old to 10-year-old
child
2 h to
3 h
Model
An appropriate model for the amount
of caffeine in a person’s bloodstream is
or
where
is the amount of caffeine in the
loodstream in mg,
! y
is the initial amount of caffeine
in mg,
! c
is the half-life of the caffeine in
the bloodstreams in hours,
! h
is the number of hours the
caffeine has been in the
loodstream.
! t
4. Jenny is an adult and does not smoke.
She also consumes a cup of coffee
(250 mL)