Question: Please show how you did this in excel? 25 26 An investment promises to pay the cash flows listed below at the end of each

Please show how you did this in excel? 25 26 An

Please show how you did this in excel?

25 26 An investment promises to pay the cash flows listed below at the end of each of the corresponding years. The market interest rate is 12.99% compounded annually. What is the current price of this security? 27 28 28 Year Cash Flow 29 Answer 1 1494 30 2 1569 31 3 1594 32 1719 33 5 1869 34 6 1894 85 7 2119 36 4

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 all and explain how to find the answers. This is a quiz that I have already taken and did not do well on. I just need someone to explain so that I can see where I went wrong. QUESTION 1...

please help Final Case Project 2 3 Suppose a beverage company is considering adding a new product line. 4 Currently the company sells apple juice and they are considering selling a fruit drink. 5 The...

Please complete part f and prepare a statement of cash flows. Thank you! A Debit Credit Journal Entries Date Account title & explanation 202X 01-Jan Cash Preferred stock paid in Capital in Excess of...

11. You have just graduated and have decided to purchase a brand new sports car to enjoy your newfound freedom. Your local credit union will provide financing for 60 months at a 9 percent annual...

Question 1: Complete parts below. You borrow $120,000 today at an interest rate of 7%. The loan is set up as a 6-year loan, with equal annual payments of $21,000 at the end of each year. What will be...

Part II: PROBLEMS Compute a final numerical answer for each of the following problems. You should work out your solutions on loose leaf paper, however, I may or may not collect your worked out...

# What is the Present Value PV if: Future Value = $2351 Interest rate=0.12 Number of periods = 18 Do not round intermediary calculations. Use full precision of your calculator or excel. Round final...

# What is the Present Value PV if: Future Value = $2351 Interest rate = 0.12 Number of periods = 18 Do not round intermediary calculations. Use full precision of your calculator or excel. Round final...

pleaas dont answer if youre not going go answer all of them 22. Assume that a gallon of milk costs $3.50 today. If the average annual inflation rate over the past 35 years was 2.75% p.2., what did a...

PLEASE SHOW THE WORK 9. A friend who owns a perpetuity that promises to pay $1,000 at the end of each year, forever, comes to you and offers to sell you all of the payments to be received after the...

MedLine Equipment Corporation specializes in the manufacture of medical equipment, a field that has become increasingly competitive. Approximately two years ago, Ben Harrington, president of MedLine,...

A point on the rim of a flywheel with radius 1.50 ft has a linear velocity of 30.0 ft/s. Find the time for it to complete 4p rad.

The equity section of a Statement of Financial Position is presented below. Preferred stock, $100 par $12,000,000 Common stock, $5 par 10,000,000 Paid-in capital in excess of par 18,000,000 Retained...

Using the data below, what is the simple exponential smoothing forecast for the 3rd week where =0.3? Week Time Series Value 1 2.00 2 2.00 3 2.00 4 8.00

8. Based on the model in Fig. 10.2 in this chapter, analyse yourself and find out which cell you would place yourself in. Let another person in the group analyse you. Did he/she choose the same cell...

9. Take four examples from your own everyday life where someone has tried to influence you. Which of the seven influencing techniques mentioned above were used? Did they use any other influencing...

10. First test yourself and then let another member of the group test you in relation to the following questions. If deviations occur, discuss why this might be. What can the results of this test be...