Create a macro function to estimate the Macaulay duration. calculate Macaulay duration is by using the following
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a macro function to estimate the Macaulay duration.
Transcribed Image Text:
calculate Macaulay duration is by using the following formula: D 1 + r + [Nx (c −r)]) cx [(1+r)N − 1] + r) 1+" _1 }-(-/-) where c is the coupon rate per period. The Macaulay duration is usually expressed in annual terms. To convert it to an annual duration, divide the Macaulay duration by the number of coupon payment periods per year. calculate Macaulay duration is by using the following formula: D 1 + r + [Nx (c −r)]) cx [(1+r)N − 1] + r) 1+" _1 }-(-/-) where c is the coupon rate per period. The Macaulay duration is usually expressed in annual terms. To convert it to an annual duration, divide the Macaulay duration by the number of coupon payment periods per year.
Expert Answer:
Answer rating: 100% (QA)
Heres a macro function in VBA to estimate the Macaulay duration vba Copy Function MacaulayDurationc ... View the full answer
Related Book For
Financial Analysis with Microsoft Excel
ISBN: 978-1285432274
7th edition
Authors: Timothy R. Mayes, Todd M. Shank
Posted Date:
Students also viewed these finance questions
-
A private health care entity charges a group of uninsured patients $5 million for various services and applies implicit price concessions to this portfolio of patients. Therefore, the health care...
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
Using the data for Adobe Systems Inc. (Nasdaq: ADBE), presented below: a. Calculate the ratio of each years' data to the previous year for each of the above items for Adobe. For example, for the year...
-
The portfolio of stock that comprises the ASX200 index is currently worth $5000. The continuously compounded interest rates on Australian government bonds is 1.5% per annum for each of the next five...
-
Uxmaiz Corporation had only one job in process during May-Job X32z- and had no finished goods inventory on May 1. Job X32Z was started in April and finished during May. Data concerning that job...
-
Eddie's Bar and Restaurant Supplies expects its revenues and payments for the first part of the year to be: Seventy percent of the firm's sales are on credit. Past experience shows that 40 percent of...
-
Briefly explain the accounting and reporting for loss contingencies.
-
On January 1, Vince Corporation purchased a 25% equity in Morelli Corporation for $180,000. At December 31, Morelli declared and paid a $60,000 cash dividend and reported net income of $200,000....
-
Prepare a multistep income statement for the year ending December 31, 2021. Round answers to the nearest whole number. (26 marks) Holister Electric Inc. Income Statement For the Year Ended December...
-
Valley Pizzas owner bought his current pizza oven two years ago for $9,000, and it has one more year of life remaining, lie is using straight-line depreciation for the oven. He could purchase a new...
-
The records for Tiger Corp. show these data for 2026: Financial income before tax is $945,000. Tax-exempt interest of $12,000 was received from a municipal bond investment. Life insurance premiums...
-
DrugStop Pharmacy Inc. opened in May 2012 as part of theEasyDrugs group of pharmacies. The company offers a variety ofservices including consultations, prescription delivery, homecareand diabetic...
-
2x 2 Given f(x) = x+2x-3 Part: 0 / 5 Part 1 of 5 (a) Write the domain of fin interval notation. The domain of the function in interval notation is
-
Construct a chronological or functional style resume for yourself using what you've learned in chapter 13 and in the COBE Career Center Presentations. Please pattern after COBE Examples. Do not use a...
-
Income statement information for Einsworth Corporation follows: Sales $306,000 Costs of Goods Sold $73,440 Gross Profit $232,560 Write a vertical analysis of the income statement for Einsworth...
-
Absolute Advantage is about specialization Comparative Advantage is about opportunity cost Total resources available for China and the US = 800 each Terms of trade (TT) are 10,000 Wheat for 10...
-
Security Returns if State of Probability of State Occurs Economy State of Economy Roll Ross Bust -12% 13% Boom 30 6 0.20 0.80 Calculate the standard deviations for Roll and Ross by filling in the...
-
Use critical values to test the null hypothesis H0: 1 2 = 20 versus the alternative hypothesis H0: 1 2 20 by setting a equal to .10, .05, .01, and .001. How much evidence is there that the...
-
Telluride Tours is currently evaluating two mutually exclusive investments. After doing a scenario analysis and applying probabilities to each scenario, it has determined that the investments have...
-
Your five-year-old daughter has just announced that she would like to attend college. The College Board has reported that the average cost of tuition, room, board, and other expense at public...
-
Camp and Fevurly Financial Planners have forecasted revenues for the first six months of 2015, as shown in the following table. The firm collects 60% of its sales immediately, 39% one month after the...
-
Baerg & Vetzel, a public accounting firm, were the auditors of South-Western Development, Inc., a real estate company that owned several shopping centres in southwest ern Ontario. It was...
-
A partner in your public accounting firm has asked you to explain to a group of juniors the importance of engagement letters and the importance of following up unusual or unexplained items discovered...
-
Marino Rossi, a public accountant, audited the finan cial statements of Newfoundland Rugs Ltd. Cooke, the pres ident of Newfoundland Rugs, told Rossi that the company was planning a private placement...
Study smarter with the SolutionInn App