I am having a hard time plugging these into excel- our professor wants us to USE excel to grab the answer- the excel sheet i have given is what they prvide us and we are suppose to plug the #'s in to get the answers- however I must be doing something wrong..

i have the answers figured out but I do not have the excel part- can someone please help me figure out where to plug in the numbers into what calculators?! thanks

Annunity Payout Mortgage Payments Present Value Interest Rate Term (years) Compounding periods $ 320,243.29 8% 25 1 Present Value Interest Rate Term (years) Compounding periods $187,500.00 3.75% 23.54975292 12 Payment $30,000.00 Payment $1,000.00 Annuity Investment Payments Savings Accounts $ Future Value Interest Rate Number of Years $300,000.00 10% 30 Present Value Payment Interest Rate Compounding periods Term (years) 500.00 $50 2.20% 12 Payments $132.71 5 Payment $3,726.24 Compount Interest Calculation Simple Interest Calculation $ $ 500.00 50.00 Present Value (Principal) $3,000.00 Interest Rate 6% Number of Years 20 2% Present Value Payments Interest Rate Term (years) Compounding periods Future Value 5 12 Future Value $6,600.00 $3,726.24 Jim deposits $3000 in an account with an APR of 2.96% interest compounded daily and wants to know what the balance will be in 20 years. Use Excel to determine how much will Jim have in the account in 20 years? (Use 365 days in 1 year.) TA