Chapter 15, Problem 4P

Using Excel, create a table that shows the relationship between the interestearned and the amount deposited, as shown. we will first create the dollar amount column and the interest row, as shown . Next we will type into cell B3 the formula = $A3*B$2. We can now use the Fill command to copy the formula in other cells, resulting in the table as shown. Note that the dollar sign before A3 means column A is to remain unchanged in the calculations when the formula is copied into other cells. Also note that the dollar sign before 2 means that row 2 is to remain unchanged in calculations when the Fill command is used.

Write each known variable’s value as it appears in the calculator and use a question mark for the missing variable.  Then, in the space provided write the missing variable’s value, as it appears in the calculator.  Finally, write your final answer in context, with units, as a complete sentence.  Use a TVM Solver is necessary. Daniel plans on making monthly payments into an account that earns 3.5% compounded monthly. If he wants $15,000 in 20 years, what do his payments need to be?   N _____________    I%_____________                              Missing Variable Value_______________________    PV_____________    PMT____________ Context Sentence:    FV______________    P/Y_____________    C/Y_____________

ing annuities. The first payment in these annuities is made at the end of Year 1, so they are ordinary annuities. Do not round intermediate calculations. Round your answers to the nearest cent. (Notes: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in many situations, to see how changes in input variables affect the output variable. Also, note that you can leave values in the TVM register, switch to Begin Mode, press FV, and find the FV of the annuity due.) a. $600 per year for 10 years at 6%. $ b. $300 per year for 5 years at 3%. $ c. $600 per year for 5 years at 0%. $ d. Now rework parts a, b, and c assuming that payments are made at the beginning of each year; that is,…