Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 20, 2024

The Maybe Pay Life Insurance Co. is trying to sell you an investment policy that will pay you and your heirs $25,000 per year forever.

The Maybe Pay Life Insurance Co. is trying to sell you an investment policy that will pay you and your heirs $25,000 per year forever. If the required return on this investment is 7.2 percent, how much will you pay for the policy?

I know the answer is 347222.22, but can someone explain how to find the answer using a "Finance" formula in Microsoft Excel?

PV=C/r $25,000 / 0.072

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

Handbook Of Financial Planning And Control

Authors: Robert P. Greenwood

3rd Edition

0566083728, 978-0566083723

More Books

Students also viewed these Finance questions

Question

★★★★★

At December 31, 2006, the following information (in thousands) was available for sunglasses manufacturer Oakley, Inc.: ending inventory $155,377; beginning inventory $119,035; cost of goods sold...

Answered: 1 week ago

Question

★★★★★

Write a program that produces the following figure (which vaguely resembles a textbook) as its output using nested for loops. Use a class constant to make it possible to change the size of the figure...

Answered: 1 week ago

Question

★★★★★

Describe a situation in which the stated values of an organization are in apparent conflict with the values implicit in management behavior.

Answered: 1 week ago

Question

★★★★★

The following are selected 2012 transactions of Oveius Corporation. Jan. 1 Purchased a small company and recorded goodwill of $150,000. Its useful life is indefinite. May 1 Purchased for $90,000 a...

Answered: 1 week ago

Question

★★★★★

A company just paid a dividend of $1.10 per share. The consensus forecast of financial analysts is a dividend of $1.60 per share next year, $2.50 per share two years from now, and $2.50 per share in...

Answered: 1 week ago

Question

★★★★★

Need an explanation to this statistics question The General Social Survey asks respondaents to rate their political views on a seven-point scale, where 1 = extremely liberal, 4 = moderate, and 7 =...

Answered: 1 week ago

Question

★★★★★

Explain the importance of staffing in business organisations

Answered: 1 week ago

Question

★★★★★

What are the types of forms of communication ?

Answered: 1 week ago

Question

★★★★★

Explain the process of MBO

Answered: 1 week ago

Question

★★★★★

What is the H-C-H bond angle in a methane molecule? [A] 120 [B] 75 [C] 109.5 [D] 150

Answered: 1 week ago

Question

★★★★★

3. Communication of White Identity. Go to the website http://stuffwhitepeoplelike .com/. This website parodies the stereotypes of white people, and by extension, the stereotyping of other groups....

Answered: 1 week ago

Question

★★★★★

g. What do your findings suggest about the power of the media and their effect on identity formation and intercultural communication? (Think about avowal, ascription, and interpellation.)

Answered: 1 week ago

Question

★★★★★

7. Understand the challenges of multilingualism.

Answered: 1 week ago

Previous Question Next Question