You are working at a retail establishment that sells numerous things in bulk. Customers that buy a lot on a consistent basis get larger discounts. Also, your costs are constantly changing and you get discounts if you order more. You want to create a sheet that allows you to quickly change things so you can print off a current sheet to give fast quotes over the phone for different quantities of an item to your different customers.

15. NEW PROBLEM. Directly below the table you just created, I want you to recreate the same table only this time use the FV command and the Excel 2-way function. You should first create the PV, FV, PMT, RATE, N, M cells. Begin labeling in A9 and go down. Fill in the inputs accordingly. To recreate the 2-way table, please put it directly to the right of the PV, FV etc. values. You will need to move the Years label. Move it to the bottom of that column. (Note, it does not matter what your starting input values are other than the initial $100,000.) Create the table.

16. Finally, starting in cell A17, you want to find out what would be the value of a house you can buy at different interest rates, if you pay $900 per month on the loan. You will get a 30 year loan paid monthly. Do a 1-way table to see how interest rates affect the value. Start the PV, FV, PMT cells at A17 going down.

17. Start the interest rates at 2.75% in cell D17 and increase by a quarter percent to the right in row 17. 18. Finish the table using the Excel table function