Question: help with putting into excel. What is the present value of the following annuity? $1,765 every quarter year at the end of the quarter for

help with putting into excel. What is the present value of the following annuity?

$1,765 every quarter year at the end of the quarter for the next 9 years, discounted back to the present at 14.66 percent per year, compounded quarterly?

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!

Need help plugging this into excel. What is the present value of the following annuity? $4,844 every year at the end of the year for the next 11 years, discounted back to the present at 6.33 percent...

Need help with the following problem with the formula in excel. What is the present value of the following annuity? $4,991 every year at the end of the year for the next 8 years, discounted back to...

Please help me find the formula. What is the present value of the following annuity? $4,798 every year at the end of the year for the next 14 years, discounted back to the present at 11.13 percent...

Question 1 (1 point) For the next 4 years, you decide to place $970 in equal year-end deposits into a savings account earning 3.38 percent per year. How much money will be in the account at the end...

Please explain using excel 1. You placed $8,584 in a savings account today that earns an annual interest rate of 11.96 percent, compounded semiannually. How much will you have in this account at the...

1) What is the accumulated sum of the following stream of payments? $1,010 every year at the end of the year for 9 years at 6.71 percent, compounded annually. Round the answer to two decimal places....

What is the present value of the following annuity? $2,148 every year at the end of the year for the next 8 years, discounted back to the present at 16.35 percent per year, compounded annually? Round...

You have decided to place $683 in equal deposits every month at the beginning of the month into a savings account earning 6.15 percent per year, compounded monthly for the next 3 years. The first...

13.For the next 5 years, you decide to place $1,252 in equal year-end deposits into a savings account earning 6.62 percent per year. How much money will be in the account at the end of that time...

6. How many years will the following take? $980 to grow to $24,368 if invested at 14.92 percent, compounded annually. Round the answer to two decimal places. 7. You have decided to place $683 in...

Zoogle has the following selected data ($ in millions): Net sales .............. $24,651 Net income ............. 6,620 Operating cash flows ........ 9,326 Total assets, beginning ....... 41,768...

6. Show that (a) lim(1/n + 7) = 0; (b) lim(n/n + 2) = 2; (c) lim(n/n + 1) = 0; (d) lim(-1)nn/n2 + 1) = 0: 7. Let xn := 1/ln(n + 1) for n N. (a) Use the definition of limit to show that lim(xn) = 0....

A mature firm with well - established products and substantial market share will probably offer low base pay and benefits but high incentives. Group startsTrue or False

Discuss why a company's purchase of an affiliate's bonds from an outside entity constitutes a constructive retirement of debt from the consolidated viewpoint.

Steele Corporation has the following information for January, February, and March: January February March Units produced 10,000 10,000 10,000 Units sold 7,000 8,500 10,500 Production costs per unit...

Calculate the mass, in grams, of CUCI, (MW = 134.452 g/mol) required to prepare 100.0 mL of a 2.02 %w/v Cu?+ (MW = 63.546 g/mol) solution. %3D mass of CuCl,:

Calculate the mass, in grams, of CuCl, (MW = 134.452 g/mol) required to prepare 100.0 mL of a 2.02 %w/v Cu?+ (MW = 63.546 g/mol) solution. %3D mass of CuCl,:

A solution is made by mixing 30.0 mL30.0 mL of ethanol, C2H60,C2H6O, and 70.0 mL70.0 mL of water. Assuming ideal behavior, what is the vapor pressure of the solution at 20 C?20 C? The relevant values...

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Is the employer-employee relationship essentially contractual"? If tt is, what are the implications of this for business ethics?

Is privacy an employee right? Explain why or why not If it is a righ~ give examples of employer actions or policies that would violate this right.

How serious is the danger posed by employee d111g use? Oo you agree that there are important limits to the "prevention of harm argument for drug testing?