60.1K

Verified Solution

Link Copied!

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 original problem is provided in photo-

the answers to this problem is

A)= 200,450

B) = 1,076.06

C)= 1,201.80

please help me figure out which calculators to use and where to put the #'s

ty!!

I just need to know where to put the numbers given in the problem into the calculators given-

the calculators he has given us already have the formula to calculate the answer.

thanks- if you cant do that please dont answer

You want to buy a $211,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan for the rest. a) How much is the loan amount going to be? $ b) What will your monthly payments be if the interest rate is 5%? $ c) What will your monthly payments be if the interest rate is 6%? $ 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

Answer & Explanation Solved by verified expert

See Answer