This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

Map Time and Bond Cash Flows

This example shows how to use the Financial Toolbox™ and Spreadsheet Link™ software to compute a set of cash flow amounts and dates, given a portfolio of five bonds with known maturity dates and coupon rates. It is included in the Spreadsheet Link product. To run it:

  1. Start Excel®, Spreadsheet Link, and MATLAB® sessions.

  2. Navigate to the folder matlabroot\toolbox\exlink\.

  3. Open the file ExliSamp.xls

  4. Execute the example as needed.

    Note   This example requires Financial Toolbox, Statistics and Machine Learning Toolbox™, and Optimization Toolbox™.

  1. Click the Sheet6 tab on ExliSamp.xls. The worksheet for this example appears.

  2. Make A18 the active cell. Press F2, then Enter to execute the Spreadsheet Link function that transfers the column vector Maturity to the MATLAB workspace.

  3. Make A19 the active cell to transfer the column vector Coupon Rate to the MATLAB workspace.

  4. Make A20 the active cell to transfer the settlement date to the MATLAB workspace.

  5. Execute the functions in cells A23 and A24 to enable the Financial Toolbox software to compute cash flow amounts and dates.

  6. Now execute the functions in cells A27 through A29 to transform the dates into a cell array of character vectors.

  7. Execute the functions in cells A32 through A34 to transfer the data to the Excel worksheet.

  8. Finally, execute the function in cell A37 to display a plot of the cash flows for each portfolio item.

  9. When you finish the example, close the figure window.

Was this topic helpful?