Question: please show work or how to do this in excel. What is the present value of the following annuity? $3,218 every half year at the

please show work or how to do this in excel.

please show work or how to do this in excel. What is

What is the present value of the following annuity? $3,218 every half year at the end of the period for the next 8 years, discounted back to the present at 8.62 percent per year, compounded semiannually Round the answer to two decimal places

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 show work. Or at least how you would calculate the annuities. 7. Present value of annuities and annuity payments Aa Aa The present value of an annuity is the sum of the discounted value of all...

Ch 25 - Capital Investment Problem (25 points) A company is looking into investing in the purchase of a new equipment for \$ \\$ 260,000 \$. The equipment is expected to have a 5 year life with no...

Week 6 Discussion Board. Please utilize the resources provided to answer the discussion board question. 500 words or less from the students point of view without citing resources. Discussion Rubric...

I am looking for help in question 2B and 2C. Displayed below is the full question with my progress thus far. Please show work. Thank you! You should use the Excel Template provided to answer the five...

1. What is the future value of $100 in 5 years at an 8% annual interest rate? Please show the timeline. 2. What is the present value of $150 that you are supposed to receive in 3 years at a 5.5%...

You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company...

Please show work as well if you can, thank you. . Appendix B Specimen Financial Statements: The Procter & Gamble Company Once each year, a corporation communicates to its stockholders and other...

the present value of a perpetuity of 6500 paid at the end of each year plus the present value of a perpetuity of 8500 paid at the end of every 5 years is equal to the present value of annuity of k...

1 A renewable energy electricity supply technology has the following characteristics: Capital cost ($) Annual operating cost ($) Lifetime (years) Salvage value ($) Annual electricity supplied (MWh)...

Please show work step by step and not on excel 7. The NPV and payback period What information does the payback period provide? Suppose you are evaluating a project with the expected future cash...

1. Consider the impact that this job crisis might have on the long-term organizational commitment of the younger generation. Can you make an argument that the crisis could have long term effects on...

2. Determine the surface area of the figure shown below. (5 marks) 2.0 m 1.6 m 2.4 m 3.0 m

A bond issued by Air Express of the United Kingdom trades over - the - counter in the United States. In which type of market is it traded? Question 3 options: a domestic market an external market a...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".