Question: Using Visual Basic for Applications (VBA), and only the input data given below, create a macro in Excel that calculates the Macauley's Duration for

Using Visual Basic for Applications (VBA), and only the input data given below, create a macro in Excel that calculates the Macauley's Duration for the given bond using a For Next loop. The inputs for the macro code should be restricted to the data in green below: $ 69 69 69 69 69 69 9.38 9.38 $ 9.38 $ 9.38 $ 9.38 $1,009.38 Cash Flow $ Time Period Price = Asked yield 1 2 3 456 2.345 Problem #4 (20 points) PV of Cash Flow 9.27 9.16 9.05 8.95 8.84 941.19 986.4610 For the same bond, create a separate macro that calculates the Modified Duration. For this problem you may use only the information in green above, as well as the Macauley's Duration you calculate in Problem #3.

Step by Step Solution

★★★★★

3.43 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Here is the VBA code to calculate Macauleys Duration and Modified Duration for the given bond us... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A furniture manufacturer specializes in wood tables. The tables sell for $95 per unit and incur $40 per unit in variable costs. The company has $3,000 in fixed costs per month. Prepare a contribution...

List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...

what is the average thermal velocity of an electron at 373K

Provide a brief discussion of database connection using the JDBC API, which includes: a. Two popular methods used to establish a connection b. Operational procedure to establish a connection c. How...

Because Natalie has had such a successful first few months, she is considering other opportunities to develop her business. One opportunity is the sale of fine European juicing machines. The owner of...

The following are observations associated with independent random samples from three normal distributions having equal variances and respective means 1 , 2 , 3 . Compute the F-statistic that is...

Do you think that boundaryless work is primarily advantageous for employees or are there potential disadvantages for employees as well?

Sam owns a small apartment building (this is the only rental building Sam owns). During the year Sam incurs the following expenditures: Item Amount Replace roof and roof underlying structure because...

bank account, you open a portfolio and invest the money. For simplicity, assume that the annual return is 9% and the principal investment is $5000. Write a pseudocode and a C++ program that prompts...

This project will test your understanding of the Sage 50 Accounting application and your ability to apply the features of this application. You will be using many of the skills that you have acquired...

Richmond Company is considering eliminating one of its products, product A, which costs $60,000 a year to produce but only provides $55,000 in revenues. Careful analysis shows that two-thirds of the...

One way to determine the trend of a data set is to find ______________________. Question 36 options: a) percentage of non-overlapping data b) the split middle line of progress c) percentage of...

The annual salaries for 5 randomly selected people: Diana: $154,500 Clark: $76,000 Lois: $119,350 Bruce: $2,350,000,000 Barry: $68,000 Which would be the best measure of central tendency for this...

Your clients expect a 10% return on investment for podcast and a 15% ROI for TV ads. How would you calculate the expected profit for a client who invests $5500 on a podcast ad and $10,000 for a TV ad

Describe in detail the three main assumptions for parametric testing.

Which information is required to calculate the Total Amount of Insurance Needed in the Financial Needs Analysis (FNA) section? i. Death Amount, Passive Income, Mortgage Balance ii. Mortgage Balance,...

Krogers bonds mature in 10 years, have a face value of $1,000, and make an annual coupon interest payment of $50. The market requires an interest rate of 6% on these bonds. What is the current market...

The manager of a local convenience store is expanding his line of small toy items. To price these new items, the manager is looking at the prices being charged by competing retailers in his area. For...

List some benefits of such collaboration.

"There are some people who want to kill animals like the lions and cheetahs. We would like to teach them, there are not many left," says WildTrack officials. The more we can study their behavior, the...

List some benefits of enterprise chatbots.

Refer to the Baseball 2012 data. Compute the mean number of home runs per game. To do this, first find the mean number of home runs per team for 2012. Next, divide this value by 162 (a season...

Assume a binomial probability distribution with n 5 50 and p 5 .25. Compute the following: a. The mean and standard deviation of the random variable. b. The probability that x is 15 or more. c. The...

A study of the checkout lines at the Safeway Supermarket in the South Strand area revealed that between 4 and 7 p.m. on weekdays there is an average of four customers waiting in line. What is the...