WebQuest
Exponentials & Logarithms - Financial Planning
Process
Step 1:
Watch the following video on choosing the right savings account.
Answer the following questions:
- Why is higher interest better for a savings account?
- What are some pros/cons to online only banks?
- What are some pros/cons to brick and mortar banks?
- Why is a mobile app so important for a bank?
- What is a money market account? What are the draw backs?
Research the following banks and list the interest rate, and fees for each.
Bank | Interest Rate | Fees |
Of those, pick 5 that you feel are the "best" and then create a formula for each account and fill in the following table, you will have 5 different tables. Use logs, and solving exponential's to solve correctly. (See attached link for help).
Formula Used: __________________________________________________________
Years\Initial Amount Deposited | $100 | $500 | $1000 |
5 Years | |||
10 Years | |||
20 Years |
Using your tables from above, create a graph that displays all the banks and their various different levels. Use your formulas to project the amount of money earned past 20 years. (If you need help, see attached file on how to create a graph using excel).
Of the 5 banks, pick one bank that you will acquire. Be sure to give your reasons as to why you picked the bank you picked. And from that bank develop a 10 year plan after opening the account and how you will use the account to benefit your financially.
Create a powerpoint file displaying all your findings, making sure to include all charts, graphs, and formulas used.
Attachments
-
How to create a graph in Excel
Description: Link to video of how to create a graph in excel.
-
Help Solving Using Logs
Description: Link to help solve exponential models.
-
Example Word Problems.
Description: Examples of exponential word problems.
The Public URL for this WebQuest:
http://zunal.com/webquest.php?w=405992
WebQuest Hits: 406
Save WebQuest as PDF