Overview

CALCULATE NET TOTAL RETURN ON BOND INVESTMENT DENOMINATED IN ANY CURRENCY,

broken-down by trading gains (realized & unrealized), foreign exchange gains (realized & unrealized), interest received & accrued, fees paid. For fixed rate and zero-coupon bonds.

Suppose you invest  €10.000 to buy a bond denominated in USD at a price of 125 and the exchange rate USD/EUR is 0,80 (Euros for 1 Dollar), by converting your €10.000  into $12.500 (10.000/0,80) you will be able to buy $10.000 face value ($10000*125/100).

Suppose you sell your bond at a price of $130, generating $13.000, and in the meantime Euro appreciated vis-à-vis the Dollar, the exchange rate now being 0,70. Your sale proceeds converted to Euro will generate €9.100 (13.000*0,70). Since you originally invested €10.000, you realize a net capital loss of €900.

Now let’s see where this comes from:

  • realized Trading Gain of $500 [(10000 * ($130-$125)] which converted at 0,70 will generate €350
  • realized Forex Loss of €1.250 [($12.500*(0,80-0,70)]
  • in net terms you realized a capital loss of €900 (1.250-350)

 

Now, suppose the bond you invested in - expiring say July 7, 2030 - pays a coupon of 3% twice a year, on Jan. 7 and July 7. If you bought the bond say on March 10, 2019 and sold it on Jun 3, 2020, in addition to sales proceeds of $13.000, you will get a net interest income of $370,68 [or €259,48 (370,68*0,70)], composed as follows:

  • -$50,96 interest paid at purchase on March 10, 2019 from last coupon date of Jan. 7, 2019 ($10000*3%*62days)/365)
  • $148,77 coupon received on July 7, 2019 ($10000*3%*181days)/365)
  • $151,23 coupon received on Jan 7, 2020 ($10000*3%*184days)/365)
  • $121,64 interest received at sale on Jun 3, 2020 from Jan.7, 2020 ($10000*3%*148days)/365)

 

As a result, your total return on investment (ROI) will be:

  • -6,41% in Euros (-900,00+259,48)/10.000)*100
  • +6,97% in USD (500.00+370,68/12.500*100)
Reviews Add a review
No reviews yet

More From Domenico Cristarella

Browse our top rated business templates. See All
PREPAID EXPENSE & UNEARNED INCOME CALCULATOR
146
9
THE MODEL CALCULATES MONTHLY AMORTIZATION FOR PREPAID EXPENSES AND/OR UNEARNED INCOME, GENERATING RELEVANT ACCOUNTING ENTRIES. Prepaid expenses represent expenditures that have been…
ANALYTICAL RETURN ON INVESTMENT (ROI) CALCULATOR
394
45
This tool calculates return of an investment denominated in any currency, split between Realized and Unrealized and further dissected into…
FINANCIAL MANAGEMENT SYSTEM
599
51
FULLY FLEDGED ACCOUNTING AND FINANCIAL MANAGEMENT PACKAGE FOR PRIVATE INVESTORS, SMALL FINANCIAL SERVICE BUSINESSES AND PROFESSIONALS A comprehensive tool to…
DEPRECIATION SCHEDULE CALCULATOR
613
43
CALCULATE DEPRECIATION OF AN ASSET USING 4 OF THE MOST POPULAR DEPRECIATION METHODS. Fully editable version available. This excel tool will calculate the…
EFFECTIVE NET YIELD TO MATURITY CALCULATOR
498
33
CALCULATE THE EFFECTIVE NET YIELD-TO-MATURITY (OR TO SALE DATE) OF A BOND, KEEPING PRICE VOLATILITY AND INTEREST RATE RISK UNDER…
AMORTISED DEBT REPAYMENT SCHEDULE CALCULATOR
465
65
CALCULATE THE AMORTIZATION SCHEDULE OF A MORTGAGE OR CONSUMER LOAN, EITHER AT FIXED OR VARIABLE INTEREST RATE OR BOTH (most online…
See All