Please explain this in paragraph form to help me understand the concept in your own words. I will check to see if you copy and pasted from google, in that case I would give the answer a thumbs down.
Look at the valuation model for bonds. What determines the value of a bond? How would you value this using time value of money and Excel?