Explore BrainMass

Explore BrainMass

    Bond Interest Rates and Excel Formulas

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Corporate triple A bond interest rates for 12 consecutive months follow.

    Month Bond Interest
    1 9.5
    2 9.3
    3 9.4
    4 9.6
    5 9.8
    6 9.7
    7 9.8
    8 10.5
    9 9.9
    10 9.7
    11 9.6
    12 9.6

    a. Develop three-month and four-month moving averages for this time series. Does the three-month or four-month moving average provide the better forecast? Explain.

    b. What is the moving average forecast for the next month?

    © BrainMass Inc. brainmass.com October 2, 2022, 5:36 am ad1c9bdddf
    https://brainmass.com/statistics/central-tendency/bond-interest-rates-excel-formulas-475261

    SOLUTION This solution is FREE courtesy of BrainMass!

    Please see the attachment for solution.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    © BrainMass Inc. brainmass.com October 2, 2022, 5:36 am ad1c9bdddf>
    https://brainmass.com/statistics/central-tendency/bond-interest-rates-excel-formulas-475261

    Attachments

    ADVERTISEMENT