Question: i need help plugging the numbers into the GIVEN EXCEL sheet i have in the pictures- i have to use the sheet that is given

i need help plugging the numbers into the GIVEN EXCEL sheet i have in the pictures- i have to use the sheet that is given to me and I am having problems- if you could help me plug in my numbers to get the answers that would be great !! please do not give me how to come up with the answers- i just need to know how how to plug them in to the excel to get that answer
the answer to this problem is 5,423.67 - please tell me what #'s to plug into the given excel in the pictures
i need help plugging the numbers into the GIVEN EXCEL sheet i
have in the pictures- i have to use the sheet that is
given to me and I am having problems- if you could help

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 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 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!