Question: hi! I need help using the PROVIDED excel sheet to calculate my answer. please help me figure out which calculator to use and where to

hi! I need help using the PROVIDED excel sheet to calculate my answer. please help me figure out which calculator to use and where to put the given info in the excel sheet-
i have to use the excel sheet that is given so please do not send me a new excel..
the answers to this problem is A) $135.97
B) = 342,891.81
please help me figure out which calculators to use and where to put the #'s
ty!! hi! I need help using the PROVIDED excel sheet to calculate my
answer. please help me figure out which calculator to use and where
to put the given info in the excel sheet- i have to

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 Suppose you want to have $400,000 for retirement in 35 years. Your account earns 9% interest compounded monthly. a) How much would you need to deposit in the account each month? $ b) How much interest will you earn? $

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!