Identify the Excel formula used to calculate the present value of the three-year, $100 face value, 9% bond paying $95.11 with a 11% return. (Round answer to 2 decimal places, e.g. 52.75.) Present value $ 159.30

Financial Accounting Intro Concepts Meth/Uses
14th Edition
ISBN:9781285595047
Author:Weil
Publisher:Weil
Chapter11: Notes, Bonds, And Leases
Section: Chapter Questions
Problem 16E
icon
Related questions
Question
None
Identify the Excel formula used to calculate the present value of the three-year, $100 face value, 9% bond paying $95.11 with a
11% return. (Round answer to 2 decimal places, e.g. 52.75.)
Present value $
159.30
Transcribed Image Text:Identify the Excel formula used to calculate the present value of the three-year, $100 face value, 9% bond paying $95.11 with a 11% return. (Round answer to 2 decimal places, e.g. 52.75.) Present value $ 159.30
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Rate Of Return
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College