Write a version of the present value function with two interest rates, one for positive cash flows
Question:
Write a version of the present value function with two interest rates, one for positive cash flows and another for negative cash flows. The function should be written for use in a worksheet, and accept both column and row ranges as parameters. The function declaration line should be:
Function MyPV(CF As Variant, PositiveR As Double, _NegativeR As Double) As Double
Transcribed Image Text:
A BC D E F 1 MYPV IN ACTION 2 PositiveR 3 NegativeR 10%| -100 G 5% 100 =MYPV(C2:E2,$B$2,$B$3) -100 -100 -248.6852 <-- =MYPV(C3:E3,$B$2,$B$3) 100 86.17762|<-- =MYPV(C4:E4,$B$2,$B$3) 100 100 272.3248 <-- 4 -100 100 -63 <-- =MYPV(C2:C4,$B$2,$B$3)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 54% (11 reviews)
Heres an example of a present value function with two interest rates one for positive cash flows and ...View the full answer
Answered By
Monette Taban
I am currently studying Computer Science Engineering, Due to my interest in programming languages and coding, I am interesetd on Technology so I search about it read about different types of technologies, I think my this habbis will help me to solve problems of students and that is why I am signing as a question answer expert.
0.00
0 Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
The following game is a version of the Prisoners Dilemma, but the payoffs are slightly different than in Table. Prisoners Dilemma in Normal Form a. Verify that the Nash equilibrium is the usual one...
-
Write Prolog rules to define a version of the member predicate that will generate all members of a list during backtracking, but without generating duplicates. Note that the cut and\+ based versions...
-
A version of the dice game "craps" is played in the following manner. A player starts by rolling two balanced dice. If the roll (the sum of the two numbers showing on the dice) results in a 7 or 11,...
-
Find the struggles faced by business (printed t-shirts) with suppliers? Explain what would be the communication plan for each stakeholder and how you'll implement the decision you have taken?
-
A French corporation plans to invest in Thailand to develop a local subsidiary to promote its French products. The creation of this subsidiary should help boost its exports from France. The Thai baht...
-
Swinn Company manufactures bicycles. Materials are added at the beginning of the production process, and conversion costs are incurred uniformly. Production and cost data for the month of May are as...
-
Compare and contrast the main features of ordinary shares with those of preference shares.
-
Assume that on January 2, 2012, Barrett of Nebraska purchased fixtures for $8,200 cash, expecting the fixtures to remain in service for five years. Barrett has depreciated the fixtures on a...
-
IKIBAN INCORPORATED Comparative Balance Sheets. At June 30 Assets Cash Accounts receivable, net Prepaid expenses Inventory Total current assets Equipment Accumulated depreciation-Equipment Total...
-
A thick steel sheet of area 400 cm2 is exposed to air near the ocean. After a one-year period it was found to experience a weight loss of 375 g due to corrosion. To what rate of corrosion, in both...
-
The bank in exercise 5 changed its bonus policy and now offers the interest rate increase based on the following table. Rewrite Bank1FV(CF, r, n) to reflect this change. A D E BANK2FV IN ACTION...
-
Write a future value version of the function in exercise 7. Function MyPV(CF As Variant, PositiveR As Double, _NegativeR As Double) As Double A BC D E F 1 MYPV IN ACTION 2 PositiveR 3 NegativeR 10%|...
-
The small West African nation of Equatorial Guinea is designated as an upper middle-income country by the World Bank, with a GNI per capita of more than $7,000 when measured in U.S. dollars....
-
Little sister Arya Stark decides she wants to pursue a career in real estate like the men in her family. Her approach, however, will be different. She vows to view market conditions clearly and...
-
Submit at least 300 word typed self-evaluation in essay form. Please do not submit answers to questions like a survey. Rather, demonstrate critical thinking by providing analysis and evaluation of...
-
The budgeted costs for Connor Company for direct materials, direct production labor and direct distribution labor are $40, $8 and $12, respectively. The vice-president is deeply satisfied with the...
-
Give three examples of how Philippe Crosby used the principles of "quality is free" to drive organizational changes resulting in better market performance. Explain how each example resulted in...
-
A lossless transmission line is 80 cm long and operates at a frequency of 600 MHz. The line parameters are L = 0.25 pH/m and C = 100 pF/m. Find the characteristics impedance, the phase constant, and...
-
Remember to insert units when writing your answers. For following Exercises, complete the chart. 1. 2. Tons Pounds Object Ounces Statue of Liberty-weight of copper sheeting 100 Statue of...
-
Show, if u(x, y) and v(x, y) are harmonic functions, that u + v must be a harmonic function but that uv need not be a harmonic function. Is e"e" a harmonic function?
-
Compare Walmart and Amazon's business models and business strategies.
-
What role does information technology play in each of these businesses? How is it helping them refine their business strategies?
-
Will Walmart be successful against Amazon.com? Explain your answer.
-
Summative Assessment [due Day 7) Saved The following information is available to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July 31 a. On July 31, the...
-
ABC Holdings plans to sell 60,000 units, each unit consisting of a RM1,000 debenture and 15, 7-year warrants. Each warrant allows the holder to purchase one common-share at RM30. If the stock price...
-
Chelsea is a single mother living in California with her four-year-old daughter, Kelsey. In 2022, Chelsea earned $28,000 from her job. She also received a small inheritance from her late grandmother...
Study smarter with the SolutionInn App