Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want to know how to calculate the PV (Present value) of interest payment for a bond using the excel method, please giving the following

I want to know how to calculate the PV (Present value) of interest payment for a bond using the excel method, please giving the following example to help:

FV of bond = 10,000,000

Total no. of periods = 40

Coupon interest rate per period = 3.8%

Market interest rate per priod = 4.2%

The present value of prinicpal is easy = PV ( rate 0.042, Nper 40, pmt 0, fv 10,000,000)

Can you help me with the equation using excel for present value for interest payment?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Top Accounting And Auditing Issues For 2023

Authors: CCH Tax Law Editors

1st Edition

0808059335, 978-0808059332

More Books

Students also viewed these Accounting questions

Question

a sin(2x) x Let f(x)=2x+1 In(be)

Answered: 1 week ago