Use Excel or Google Open Source Spreadsheet for this problem: You own a 15 year bond that has a face value of $4,000 and pays 6% a year in interest, once a year, at the end of the year. Five years after buying it, the interest rate increases to 8%. You do not want to wait 10 more years to get your principle of $4,000 back because you really need the money, so you decide to sell it on the open market. 1. How much can you sell it for? Please show me your Present Value formula. 2. Would it be a capital loss or gain and how much? How much is the capital gain or loss? Edit View Insert Format Tools Table