Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community
Ask the community for help and clear up your study doubts
University Rankings
Discover the best universities in your country according to Docsity users
Free resources
Our save-the-student-ebooks!
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
1 / 4
Related documents
Partial preview of the text
Download Bond Calculator - excel and more Schemes and Mind Maps Business in PDF only on Docsity! QD Bond Calculation Inputs Par Value of Bonds (FV) $ 1,000.00 Coupon 12.00% Coupons per year 1 Years to Maturity 19 Yield r 7.00% Outputs Coupon Payment (PMT or C) $ 120.00 = coupon * par value of bonds/coupons per year # periods (nper) or T 19 = coupons per year * years to maturity Yield (r) 7.00% =yield r/coupons per year PV of Annuity (Coupons) $1,240.27 =PV(r, nper,pmt)*-1 PV of Lump Sum (Maturity) $ 276.51 =face or maturity value/(1+r)^T where T is nper Price of Bond $ 1,516.78 = coupon * par value of bonds/coupons per year =face or maturity value/(1+r)^T where T is nper
Copyright © 2024 Ladybird Srl - Via Leonardo da Vinci 16, 10126, Torino, Italy - VAT 10816460017 - All rights reserved