Figuring out bond return in excel, assignment help

User Generated

fynz18

Business Finance

Description

Hi,

I have two bonds that I want to figure out the return in excel to make it easy for me. I attached the bond details and screen shot of the answer of the returns. I just need that data to be in excel sheet. Can you calculate the bond return in excel. Let me know if you have any questions. Thanks!  

Unformatted Attachment Preview

Price Buy Date Sell Date 8.30.16 10.27.16 Yield 122.416 118.31 Total Return Coupon 1.28 1.83 -16.469 Maturity 5% 12.15.30 Coupon Freq Semi-Annual Price Buy Date 01.06.15 Sell Date 10.27.16 Yield 117.343 119.308 Total Return 2.55 1.635 5.042 Coupon 5% Maturity Coupon Freq 11.15.28 Semi-Annual
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi there!Attached is the Excel file you initially posted, but updated with a line-by-line item of how I arrived at the bond total return.It's very tricky business. Please feel free to ask any q...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags