Application Time! 1) You will type the TVM inputs in the table provided from the "Info Sheet". 2) Mirror the inputs from the "Info Sheet" to the TVM cells provided. 3) Within the TVM cells, if needed, compound. 4) In the lote: NPER * Note: RATE= % / Compounding # "ANSWER' cell show us your TVM calculation. Compounding # Goal 1: Opened an account with $1500, with the hope to have a total of $2500 saved in an Compounding Number RATE NPER PMT PV FV ANSWER emergency fund within one year (no additional payments). (select from dropdown) What would the quarterly interest rate be needed to reach this goal? 4 #N/A Goal 2: A credit card balance of $2000 with an 15% rate. The goal is to pay off the credit card by the unding Number RATE NPER PMT PV FV ANSWER end of the year. (future is a $0 balance) from dropdown) What would be the monthly payment to reach this goal? 12 #N/A Goal 3: Student loan balance of $18,000 at 6.5% and making $425 monthly payments. (future is a $0 152 unding Number RATE NPER PMT PV FV ANSWER balance) 365 from dropdown) How many months will it take to complete this goal? #N/A Goal 4: Save $15000 in an account with 15% for a down payment on a home in 6 years. (no Compounding Number RATE NPER PMT PV FV ANSWER additional payments (select from dropdown) How much must be deposited today in the account to reach this goal? #N/A Goal 5: Open a Roth IRA at 5% for 20 years and contribute $1500 on a semi-annual basis. Compounding Number RATE NPER PMT PV FV ANSWER (select from dropdown) What is the potential balance of this account in 20 years? #N/A