Question: please answer using excel and explain 5) You are offered an investment that will pay you $1,000 per year for 20 years. How much should

please answer using excel and explain

5) You are offered an investment that will pay you $1,000 per year for 20 years. How much should you be willing to pay for this annuity if you can earn a rate of 8.5% per year on similar investments? In this case we need to solve for the present value of this annuity since that is the amount that you would be willing to pay today. Use Excel's =PV(RATE,NPER,PMT,[FV],[TYPE]) function. 3 RATE is 8.5%, NPER is 20 , PMT is $1,000, and TYPE is 0 since payments are made at the end of the period. If the [type] argument is omitted, it takes on the default value of 0

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!

please answer using excel and explain 14) You are offered an investment that will pay the following cash flows at the end of each of the next five years: How much would you be willing to pay for this...

please answer using excel and explain 18) You are offered an investment that will pay the following cash flows at the end of each of the next five years at a cost of $800. What is the MIRR if the...

please answer using excel and explain 16) You are offered an investment that will pay the following cash flows at the end of each of the next five years at a cost of $800. What is the Net Present...

please answer using excel and explain 11) You are offered an investment that will cost $975 and will pay you interest of $80 per year for the next 10 years. The investment will pay $1,000 at the end...

please solve using Excel and explain thank you 2) You are planning to send your daughter to college in 20 years. You estimate that you will need $100,000 at that time to pay for tuition, room, and...

Please explain in EXCEL You are offered an investment that will pay an annual payment for 20 years. The first payment one year from today will be $125,000 and will increase at the inflation rate. The...

please show the excel reference Problem #1: You are offered an investment that will pay you $2400 CAD [to be entered into cell B1] per year for 12 years [to be entered into cell B2]. You can earn a...

Using financial formulas in Excel, answer the following problems in a single Excel worksheet. Round to the nearest dollar. You must turn in an Excel document. 5. You decide that you need $50,000 in 5...

A conservative financing approach to working capital will result in all permanent net operating working capital being financed using long-term securities. T/F GE is a manufacturing firm that sells on...

1) Nebraska Mattress Company is considering the purchase of land and the construction of a new plant. The land, which would be bought immediately (at t=0 ), has a cost of $100,000 and the building,...

MINITAB was used to fit the complete second-order model E(y) = Î²0 + Î²1x1 + Î²2x2 + Î²3x1x2 + Î²4x12 + Î²5x22 To n = 39 data points....

Develop a frame for the population of each of the following research projects. a. Measuring the job satisfaction of all union employees in a company. b. Conducting a telephone survey in Utica, New...

7-9 Suppose that the original estimates given in the preceding problem are accurate. However, there is reason to believe that, if alternative X is selected, it will be succeeded at the end of its...

8. An electrical store records the following information. Under 21 21 -45 Over 45 TOTAL Satellite 48 23 19 90 Terrestrial 28 21 11 60 Cable 21 43 86 150 TOTAL 97 87 116 300 a. What is the probability...

List three characteristics of a high-performance work system in a healthcare organization. Be specific. How can HRM play a role in this process?

Do you think physicians should have unions? Why or why not?

Discuss the different types of due process approaches. What experiences have you had with these approaches?