quote for 5 assignments
Safari Reflect in ePor!olio Print Investment Calculator Spreadsheet Assignment 1 Task: View this topic CM out of 10 Investment Calculator Spreadsheet Assignment 1 You may choose to complete your mathematical calculations by hand and scan or take images to upload to the dropbox. To help your teacher review your 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 or 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 per Year $10001.00%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 per Year 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 row 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. Remember that in Microsoft Excel, you will need to start all calculations with an equal sign (=). Instead of inputting numbers or variables in your equations, you can refer 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 for 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 below 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 representing should be formatted as a percent; and the cell representing n should be 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" errors 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 2020-11-03, 9:28 PM Page 1 of 1 Safari Reflect in ePor!olio Print Investment Calculator Spreadsheet Assignment 2 Task: View this topic CM out of 32 Investment Calculator Spreadsheet Assignment 2 You may choose to complete your mathematical calculations by hand and scan or take images to upload to the dropbox. To help your teacher review your 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 or 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 be 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 result 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? ! oror you invest $5000 per year for ten years at 3% interest you invest $2000 per year for twenty years at 4% interest? ! oror you invest $2000 per year for five years at 4% interest you invest $2000 per year for four years at 8% interest? ! oror you invest $2000 per year for twenty years at 5% interest you invest $2000 per year for twenty–one years at 4% interest? ! oror 2. Using the spreadsheet (or any other 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 $1 000 000 through regular 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) b. 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 greater 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) For example, under what conditions will you have a future value of $1 000 000, having earned $500 000 interest? 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, but 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 2020-11-03, 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 your mathematical calculations by hand and scan or take images to upload to the dropbox. To help your teacher review your 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 or 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, your body absorbs 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 bloodstream occurs 15 min to 45 min after 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 after 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 after 4.5 h. (1 mark) 2. Using the graph, determine when Peter 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 bloodstream 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 bloodstream 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 bloodstream. ! t 4. Jenny is an adult and does not smoke. She also consumes a cup of coffee (250 mL)