John has three credit cards that he uses to pay his bills. He currently has a balance of $1,000, $2,000, and $4,000 on each card respectfully. He racks up roughly $1,000 of charges on all three cards combined each month, and can right now afford to pay $1,100/month toward his credit card bills. Each credit card has different APRs (Annual Percentage Rates), monthly/annual fees, cash back rewards, and transfer fees. John wants to ultimately have the least amount of credit card debt over the next five years. Some potential options he has are the following: Consider consolidating his balances onto one credit card that has a lower APR or better benefits. Keep in mind it costs money to transfer balances, and having less credit cards may help/hurt your credit score. Consider selling some of his stock investments (that are making roughly 5% rate of return) throughout the next 5 years to help increase his monthly contribution toward the credit card bill. Try to save more money and pay more per month toward the bill Continue with the status quo, but funnel most of his $1,100/month toward the card with the highest APR. Many other combinations of choices. I want you to pick a real world problem that YOU care about. It could be credit card related, stock market related, saving accounts, mortgages, card payments, etc. I want you to take this complex problem, analyze it, and come up with a financial goal related to the problem. You should then investigate 3-5 potential options of decisions you can make to reach your goal. Ultimately, you should pick the best solution to head toward your goal. Feel free to DEFINITELY use this project to analyze something that you have been meaning to look into that you never had the time or knowledge. If you are uncomfortable sharing actual numbers relating to your financial situation, which I COMPLETELY understand, please feel free to use fake numbers. If you use fake or real values, I won't know (or care about) the difference anyway. Topics You Must Cover in Project Time Value of Money Drawing Cash Flow Diagrams Some combination of P/F, F/P, A/P, P/A, F/A, A/F, and/or gradient factors Nominal and Effective Interest Rates Using Excel