Question: How could I model this in excel so I could see the Present Value for each year in a separate cell? If you purchase a

How could I model this in excel so I could see the Present Value for each year in a separate cell?

If you purchase a 20-year annuity for $100,000, and if it is "fairly priced" and if the payments are based on 5% per year, how much will the annuity pay you per year for each of the next 20 years?

By hand math, I've found the payments per year to be 3,116.

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!

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

I am wondering if anyone has corrected solutions to fnce 300 assignments 1 2 and 3. I am concered about my answers and would love to compare. Pretty sure on my answers for 1 and 2 mainly interested...

I have an assignment for Finance Management: Payback Periods, Net Present Value, Internal rate of return , NPV, Equivalent Annual Annuity, Estimation CF, Capital Rationing. Please see excel...

Financial Analysis Exercise #1 (100 Points) This exercise will require both a written and Excel spreadsheet component. It is critical to demonstrate the appropriate Excel skills. There are 10 mini...

Can anyone solve the answers from the given document givenbelow? I really need help. MY FINAL LITERALLY IS KNOCKING AT THE DOOR. Name_________________________________ Student...

1. A bank is paying interest at a 5% annual rate on deposits. If you invest 10,000 and the bank compounds interest daily (i.e., 365 times per year), which of the following shows how much you will...

SOMEONE PLEASE HELP ME GIVE ALL THE ANSWERS!!!!! MY EXAM IS ON 13th MORNING! SO PLEASEEEEE!!!!! 2. An investment is expected to pay the following: C 1 = $2,300, C 2 = $2,600, C 3 = $2,900, and then...

Can someone help me with this? I need it by tomorrow chapter 2 Issues in Accounting for Corporate Debt and Equity istockphoto Learning Objectives Be able to articulate the advantages and...

There are various types of accounting changes, each of which is required to be reported differently. Required: 1. What type of accounting change is a change from the sum-of-the-years'-digits method...

Chrs NT makes specialty son dirs. M the end of 2015, Chns NT had total assets of $520 000 and liabilies totaling $330 000. Requirements Write the frw's accounting equation and label each amount as a...

27. Annual starting salaries for college graduates with degrees in business administration are generally expected to be between $30,000 and $45,000. Assume that a 95% confidence interval estimate of...

what are the pors and cons of 360 degree proformance appraisals and feedback?

5. List three of what you would call your core values. For each of these core values, answer the following questions. a. What is the purpose of this value in your life? b. How does this value affect...

3. What values would you say are your core values?

12. Think of a situation where you felt particularly powerless. It must be a real event that you remember relatively well. Try to think back. What was it you imagined just before you felt powerless...