Please show how to enter this in excel - QUESTION 1: 27 YEARS AGO, THE AVG. HOME
Question:
Please show how to enter this in excel -
QUESTION 1:
27 YEARS AGO, THE AVG. HOME SALE PRICE IN YOUR HOMETOWN WAS $89,503. TODAY THE AVG. SALE PRICE OF HOUSE IS $414,868. WHAT IS THE AVG. ANNUAL RATE OF CHANGE IN THE PRICE OF HOUSES OVER THIS TIME PERIOD? ( YOU SHOULD CALCULATE THE COMPOUND GROWTH RATE IN THIS PROBLEM).
QUESTION 2:
If you invest $27,688 today at the interest rate of 9.94 percent, compounded daily, how much money will you have in your savings account in 11 years?
Round he answer to two decimal places.
QUESTION 3:
For the next 8 years, you decide to place $3,619 in equal year-end deposits into a savings account earning 8.34 percent per year. How much money will be in the account at the end of that time period?
Round he answer to two decimal places.
QUESTION 4:
You have accumulated some money for your retirement. You are going to withdraw $97,151 every year at the beginning of the year for the next 16 years starting from today. How much money have you accumulated for your retirement? Your account pays you 11.28 percent per ear, compounded annually. To answer this question, you have to find the present value of these cash flows.
Round he answer to two decimal places.