Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 24, 2024

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

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Finance Markets, Investments, And Financial Management

Authors: Ronald W. Melicher, Edgar A. Norton

17th Edition

1119561175, 978-1119561170

More Books

Students also viewed these Finance questions

Question

★★★★★

How much energy must be transferred as heat for a reversible isothermal expansion of an ideal gas at 132oC if the entropy of the gas increases by 46.0 J/K?

Answered: 1 week ago

Question

★★★★★

Answered: 1 week ago

Question

★★★★★

appreciate how classic models of job design can be applied in practice;

Answered: 1 week ago

Question

★★★★★

Jacobs, owner of a farm, entered into a contract with Earl Walker in which Walker agreed to paint the buildings on the farm. As authorized by Jacobs, Walker acquired the paint from Jones with the...

Answered: 1 week ago

Question

★★★★★

The accounting records of Wall's China Shop reflected the following balances as of January 1, Year 2. The following five transactions occurred in Year 2 : 1. First purchase (cash): 150 units $155 2....

Answered: 1 week ago

Question

★★★★★

Dong and Chen are a married couple with four dependent children under the age of 17. Their adjusted gross income is $222,800.00, and they plan to take the standard deduction. Calculate their total...

Answered: 1 week ago

Question

★★★★★

Consider a firm with an EBITDA of $1,100,000 and an EBIT of $1,000,000. The firm finances its assets with $4,550,000 debt (costing 8.3 percent, all of which is tax deductible) and 203,000 shares of...

Answered: 1 week ago

Question

★★★★★

Control: On a monthly basis, the financial analyst performs the reconciliation of the AR subledger system to the general ledger. All reconciling items in excess of US$15,000 are investigated and...

Answered: 1 week ago

Question

★★★★★

TB Problem Qu. 9-402 (Static) Hislop Tech is a for-profit vocational... Hislop Tech is a for-profit vocational school. The school bases its budgets on two measures of activity (i.e., cost drivers),...

Answered: 1 week ago

Question

★★★★★

An analysis of the transactions made by Blossom & Co., a certified public accounting firm, for the month of August is shown below. The expenses were $550 for rent, $3,800 for salaries and wages, and...

Answered: 1 week ago

Question

★★★★★

A company plans to configure a vessel's journey in Dynamics 365 Supply Chain Management by using the landed cost functionality. The company needs to track the details of each step of the journey...

Answered: 1 week ago

Question

★★★★★

Q1.a). Pizza hut is considering opening a new outlet in Baner area of Pune city. To set up the outlet, discuss which operative functions should the human resource department focus on. Discuss with...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Previous Question Next Question