Suppose a share was priced at price P 0 at time 0, and suppose that at time
Question:
Suppose a share was priced at price P 0 at time 0, and suppose that at time 1 it will be priced P1. Then the continuously compounded return is defined as return = In(P1/P0). Implement this function in VBA. There are two ways to do this: You can use Worksheetfunction.Ln or the VBA function Log.
Transcribed Image Text:
A В C D 18 Exercise 3 19 20 PO P1 110 200 0.693147181<-- =Exercise3(A22,B22) 110 200 0.693147181 <-- =Exercise3a(A24,B24) 21 100 0.09531018 <-- =Exercise3(A21,B21) 100 100 22 23 0.09531018 <-- =Exercise3a(A23,B23) 24 100
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 71% (7 reviews)
ANSWER Here is a VBA function that calculates the continuously c...View the full answer
Answered By
Brian Kiprono
Taking part in public speeches, blogging, writing essays
0.00
0 Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
There are two ways of combining candidates' assessment scores so that they can be compared with one another. Discuss the multiple hurdles approach and the compensatory approach. Which approach to...
-
There are two ways to become an EA. Briefly explain what they are and give the subpart and section references in Circular 230 where the details of becoming an EA are found.
-
Suppose an otitis-prone family is defined as one in which at least three siblings of five develop otitis media in the first 6 months of life. What proportion of five-sibling families is otitis prone...
-
help me with questions 10, 11 and 12 to answer them for practiceolin data structures Given the following linked list definitions: struct listRec! string name; listRec *link, ;: nodeType *begin; Code...
-
A U.S. company has issued floating-rate notes with a maturity of 10 years, an interest rate of six-month LIBOR plus 25 basis points, and total face value of $10 million. The company now believes that...
-
Jack moved to Singapore and considering living in Singapore for 7-10 yrs. Given the low interest rates, she considers buying a condo and starts comparing her options. She is interested in a place...
-
Refer to Exercise 9. Can you reject H0 at the = 0.01 level? State a conclusion. Exercise 9 Two suppliers of machine parts delivered large shipments. A simple random sample of 150 parts was chosen...
-
Community Bank would like to increase the number of customers who use payroll direct deposit. Management is considering a new sales campaign that will require each branch manager to call each...
-
The existing 10 year, 6% bonds are trading in the market at $900. The corporate tax rate is 32%. Calculate the interest rate of the new bonds. What is the after-tax interest rate for the new bonds?
-
The March 31, 2020, adjusted trial balance for Amusement Park Repair is shown below with accounts in alphabetical order. Debit Credit Accounts payable $ 31,000 Accounts receivable $ 48,000...
-
Write a VBA function for f(x) = ?2x 2 + 2x. Note that there are two ways to do this: The first is to use the VBA function Sqr. The second is to use the VBA operator ? ? ?. We suggest you try both. A...
-
A bank offers different yearly interest rates to its customers based on the size of the deposit in the following way: For deposits up to 1,000, the interest rate is 5.5% For deposits from 1,000 and...
-
Lumina Co. was organized on April 1, 2014. The company prepares quarterly financial statements. The adjusted trial balance amounts at June 30 are shown below. (a) Determine the net income for the...
-
C) Enter the expression w +5w +1:
-
Find the arclength of the curve r(t) = (-2 sint, 5t, -2 cost), -2t2
-
Problem 4 A thin, flexible, unstretchable loop of string has mass per length . It is set spinning with angular frequency 2 in a gravitationless vacuum in such a way that it forms a stable circle of...
-
Primare Corporation provided the following data for last month's manufacturing operations. Purchases of raw materials Indirect materials used in production Direct labor Manufacturing overhead applied...
-
If f(x) = x + 2x - 1 and g(x) = 2x - 3, find each of the following functions. (a) fog (b) gof (c) gogog
-
Refer to Problems 34 and 35. a. In each case, consult the appropriate graphs to decide whether using the Wilcoxon signed-rank test is reasonable for performing a hypothesis test for the mean of the...
-
Which of the following raises the credibility of areport? Which of the following raises the credibility of a report? Multiple Choice avoiding predictions avoiding the use of cause-effect statements...
-
Should managers inform employees that their web behavior is being monitored? Or should managers monitor secretly? Why or why not?
-
Compare the business models and core competencies of Google, Apple, and Facebook.
-
Why is mobile computing so important to these three firms? Evaluate the mobile strategies of each firm.
-
Powell Company began the Year 2 accounting period with $18,000 cash, $60,200 inventory, $49,400 common stock, and $28,800 retained earnings. During Year 2, Powell experienced the following events:...
-
Consider the following matrix A: 1 A = -22 -22 3 Use MATLAB to find the eigenvalues of matrix A. The command in MATLAB is [V,D]=eig(A). Where V is the matrix of eigenvalues and D is the matrix of...
-
a. What is the profitability index for the set of cash flows if the relevant discount rate is 11 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g.,...
Study smarter with the SolutionInn App