Please explain the following calculations in excel!!!

You have accumulated $1,277,240 for your retirement. How much money can you withdraw for the next 18 years in equal annual end-of-the-year cash flows if you invest the money at a rate of 13.14 percent per year, compounded annually?

Round the answer to two decimal places.

Answer:

174,456.77

(188,227.55)

PV of a single amount

Question 2

0 / 1 point

If you want to have $462,413 in 7 years, how much money should you put in a savings account today? Assume that the savings account pays you 6.7 percent and it is compounded annually.Round the answer to two decimal places

Answer:

156,060.93

(293,683.20)

PV mixed stream

Question 3

0 / 1 point

You have just received an endowment and placed this money in a savings account at an annual rate of 12.16 percent. You are going to withdraw the following cash flows for the next five years.

End of year

1.$3,234

2.$9,845

3.$6,764

4.$3,502

5.$1,098

How much is the endowment that you received?

Round the answer to two decimal places.

Answer:

32,543.6

(18,334.80)

RRR

Question 4

0 / 1 point

Assume that the inflation rate during the last year was 2.28 percent. US long-term bonds had the nominal rates of return of 5.34 percent. What is the real rate of return for a US long-term bond?

Round the answer to two decimal places in percentage form.(Write the percentage sign in the "units" box)

Answer:

6.69

(2.99)

(%)

FV of ordinary annuity non-annually

Question 5

0 / 1 point

You are going to save money for your sons education. You have decided to place $3,204 every half year at the end of the period into a saving account earning 11.03 percent per year, compounded semi-annually for the next 8 years. How much money will be in the account at the end of that time period?

Round the answer to two decimal places.

Answer:

28,074.65

(79,047.09)

Number of Periods

Question 6

0 / 1 point

Cooling Tools, Inc. is currently producing 698 of small refrigerators per month but the companys CEO plans to increase production at a rate of 9.36 percent per month until the firm is producing 5,293 of refrigerators per month. How many months will this take?

Round the answer to two decimal places.

Answer:

(22.64)

Annuity due

Question 7

0 / 1 point

You have decided to place $597 in equal deposits every month at the beginning of the month into a savings account earning 6.51 percent per year, compounded monthly for the next 10 years. The first deposit is made today. How much money will be in the account at the end of that time period?

Round the answer to two decimal places.

Answer:

(101,137.36)

Present Value of ordinary annuity

Question 8

0 / 1 point

You have accumulated some money for your retirement. You are going to withdraw $69,276 every year at the end of the year for the next 16 years. How much money have you accumulated for your retirement? Your account pays you 3.93 percent per year, compounded annually. To answer this question, you have to find the present value of these cash flows.

Round the answer to two decimal places.

Answer:

(811,408.84)

Interest or compound growth rate

Question 9

0 / 1 point

4 years ago, Marias annual salary was $31,209. Today, she earns $89,994. What was the average annual growth rate of Maria's salary?

Round the answer to two decimal places in percentage form.(Write the percentage sign in the "units" box)

Answer:

(30.31)

(%)

FV ordinary annuity

Question 10

0 / 1 point

What is the accumulated sum of the following stream of payments?

$2,695 every year at the end of the year for 4 years at 8.15 percent, compounded annually.

Round the answer to two decimal places.

Answer:

(12,170.92)

FV single amount

Question 11

0 / 1 point

To what amount will the following investment accumulate?

$19,258, invested today for 31 years at 16.97 percent, compounded monthly.

Round the answer to two decimal places.

Answer:

(3,575,198.71)

Question 12

0 / 1 point

What is the present value of a $308 perpetuity discounted back to the present at 11.33 percent.

The answer should be calculated to two decimal places.

Answer:

(2,718.45)

PV of ordinary annuity non-annually

Question 13

0 / 1 point

What is the present value of the following annuity?

$2,566 every half year at the end of the period for the next 7 years, discounted back to the present at 15.36 percent per year, compounded semiannually.

Round the answer to two decimal places.

Answer:

(21,553.64)

EAR

Question 14

0 / 1 point

You are considering an investment that has a nominal annual interest rate of 14.78 percent, compounded semiannually. Therefore, the effective annual rate, or EAR (annual percentage yield) is_____.

Round the answer to two decimal places in percentage form.(Write the percentage sign in the "units" box)

Answer:

(15.33)

(%)

PMT (non-annually)

Question 15

0 / 1 point

A commercial bank will loan you $28,339 for 5 years to buy a car. The loan must be repaid in equal monthly payments at the end of the month. The annual interest rate on the loan is 7.68 percent of the unpaid balance. What is the amount of the monthly payments?

Round the answer to two decimal places.

Answer:

(570.28)