Question: 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

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 the present at 9.21 percent per year, compounded annually?

Many thanks!

regards

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!

Q:

2. Use Table 12-2 to answer the following questions: a. Annuity Payment Payment Frequency Time Period (years) Nominal Rate (%) Interest Compounded Present Value of the Annuity $6,000 every year 20 4...

Q:

Question 2(4 points) The function of the capital accounts of a commercial bank is to: Question 2 options: meet bank reserve requirements provide funds for real estate loans provide a cushion for...

Q:

2. For the following questions use table 12-2 to fill in the information (Round your answer to the nearest cent.) : a. Annuity Payment Payment Frequency Time Period (years) Nominal Rate (%) Interest...

Q:

Tesla is planning to produce an all-electric family car and expects the following cash flows (in $ million) at the end of each year: Year 0 1 2 3 4 5 Cash flow -110 10 20 40 80 90 The required return...

Q:

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Q:

First, complete page one of the worksheet first by closely following the directions of each question. Much of the assignment is subjective based on your own financial goals, but the math is objective...

Q:

Hello. I'm looking for some help completing my finance project. (10% total course grade) There are quite a few questions. (40 total) I can check the answers one time before submitting. Hoping for...

Q:

Demonstrate your understanding of financial concepts by completing the following problems. Where appropriate, show or explain your work. You may use Excel to work on the problems. Problem 1....

Q:

First, complete page one of the worksheet first by closely following the directions of each question. Much of the assignment is subjective based on your own financial goals, but the math is objective...

Q:

5. In the space below the table, enter three journal entries: -- January 1, 2021, to record the issuance of the bonds; -- June 30, 2021, to record the first semiannual interest payment; and --...

Q:

Compute the actuarial present value of a 10-year term life insurance issued to a person aged 20 with benefit of 20,000 payable at the time of death if survival follows a constant force of mortality...

Q:

What price would you pay for a corporate bond with a face value of $500 000, maturing in 7 years and paying 7.00 per cent per annum coupons semi-annually, if current market yields for this type of...

Q:

bubble sort program in python

Q:

The coronavirus Covid-19 pandemic has changed the way businesses operate and created new and structural challenges in various industries. With these changes have come new opportunities to adapt and...

Q:

1. What do I want to achieve?

Q:

3. To understand a method for achieving personal communication mastery.

Q:

3. What is my goal?