Information Sheet Project Overview: Throughout the semester, you will be working on an application based scenario on how to apply the course learning goals. All projects will be submitted through Excel. The "Info Sheet" (where you're now) will be the landing page for all of the information to complete each Learning Goal Project. Make sure to keep up with the schedule for the due dates and review the rubrics to make sure you know how each Project will be graded. Let's get started! Unit 2: Borrowing - Using Your Future Income Today LG4-Understand the concept of borrowing and how it relates to consumer credit TVM QUESTIONS Q4 Total Dinner Cost $165.25 Credit Card Interest Rate 18.50% Monthly Payment $25.00 Q5 Total Amazon Credit Card Debt $725.15 Amazon Card Interest Rate 22.00% Minimum Monthly Payment $35.00 Q6 Total Weekend Trip $750.00 Credit Card Interest Rate 15.00% Goal to payoff in months 6 PFI 2301: Personal Financial Literacy LG4 Project Q1 Focus on YOU! Research a credit card that you think would be appropriate for college students. To find credit cards go to http :/lwww.creditcards.com/. Student Credit Card (Name of the Card) APR Grace Period Annual Fee Find 2 Other Fees/Associated Costs Explanation for Card Selection (min. 25 words) Q2 Q3 Application Time! Jessica is a revolving credit card user, which means she doesn't pay off the balance in full each month. Research a credit card if she were to have excellent credit, and one credit card if she were to have poor credit. Explain selecting that particular card, include concepts from the course materials. To find credit cards go to hittp :/iwww.creditcards .com/. Excellent Credit (Name of the Card) APR Grace Period Annual Fee Find 2 Other Fees/Associated Costs Explanation for Card Selection (min. 25 words) Poor Credit (Name of the Card) APR Grace Period Annual Fee Find 2 Other Fees/Associated Costs Explanation for Card Selection (min. 25 words) Application Time! Jessica informs you about the following spending moments she has had. Complete the following TVM questions (Q4-Q6) Follow the steps below. Jessica treated of all her friends to dinner. She has already spent her excess cash a) Solving For? b) Which input is c) Compounding Q4 from her paycheck, so she decides to put it on a credit card and pay for it later. (select from negative? (type TVM Number (select from RATE NPER PMT PV FV How long will it take to pay for this purchase? dropdown) input(s) below) dropdown) Mirror the numbers over from the "Info Sheet" Excel tab. (type zeros where needed) #N/A Purchased new outdoor furniture on Amazon this month. If she makes the a) Solving For? b) Which input is c) Compounding minimum payment per month, how long will it take to pay for this shopping (select from negative? (type TVM Number (select from RATE NPER PMT PV FV spree? dropdown) input(s) below) dropdown) Mirror the numbers over from the "Info Sheet" Excel tab. (type zeros where needed) N/A Spontaneous weekend trip with friends. If she wants to pay this trip off in less a) Solving For? b) Which input is c) Compounding 06 (select from negative? (type TVM |Number (select from RATE NPER PMT PV FV then a year, what will the monthly payment be? dropdown) input(s) below) dropdown) Mirror the numbers over from the "Info Sheet" Excel tab. (type zeros where needed)Q7 Q8 Q9 Q10 What does this tell you about credit card usage? How could this impact Jessica's credit report/score? (min. 25 words) What is the risk of using a credit card? (min. 25 words) When is using a credit card a good thing? (min. 25 words) How can you use a credit card responsibly? (min. 25 words)