Create the following macro: Create a function that accepts four user inputs: (1) a cash flow...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create the following macro: Create a function that accepts four user inputs: (1) a cash flow amount; (2) a discount rate; (3) the number of periods; and (4) an indicator for which TVM calculation to compute (we call this the 'operation'). Name the function 'My_TVM' If the argument (operation) supplied by the user in cell C19 is the letter "P", then the function should compute and return the Present Value of the lump sum cash flow amount. If the argument (operation) supplied by the user in cell C19 is the letter "F", then the function should compute and return the Future Value of the lump sum cash flow amount. If the argument (operation) supplied by the user in cell C19 any value OTHER THAN a "P" or "F" then the function should return the numeric value -9999. NOTE: functions return values to the cell from which they are called. I have include numeric data for use in cells C16:C18 - call the MY_TVM function from cell D21 Cash Flow Amou Discount Rate Number of perio 200 5% 3 Enter the letter 'P' to find the present value of the lump sum cash flow; enter the letter 'F' to find the future value of the lump sum cash flow Operation F Call the My_TVM function here: *Your function should contain NO Cells or Range commands. ... ensure you pass in the data as arguments within the function () * Your function should contain a nested IF structure ** Ensure you save your Excel file as macro-enabled Create the following macro: Create a function that accepts four user inputs: (1) a cash flow amount; (2) a discount rate; (3) the number of periods; and (4) an indicator for which TVM calculation to compute (we call this the 'operation'). Name the function 'My_TVM' If the argument (operation) supplied by the user in cell C19 is the letter "P", then the function should compute and return the Present Value of the lump sum cash flow amount. If the argument (operation) supplied by the user in cell C19 is the letter "F", then the function should compute and return the Future Value of the lump sum cash flow amount. If the argument (operation) supplied by the user in cell C19 any value OTHER THAN a "P" or "F" then the function should return the numeric value -9999. NOTE: functions return values to the cell from which they are called. I have include numeric data for use in cells C16:C18 - call the MY_TVM function from cell D21 Cash Flow Amou Discount Rate Number of perio 200 5% 3 Enter the letter 'P' to find the present value of the lump sum cash flow; enter the letter 'F' to find the future value of the lump sum cash flow Operation F Call the My_TVM function here: *Your function should contain NO Cells or Range commands. ... ensure you pass in the data as arguments within the function () * Your function should contain a nested IF structure ** Ensure you save your Excel file as macro-enabled
Expert Answer:
Related Book For
Data Structures and Algorithms in Python
ISBN: 978-1118290279
1st edition
Authors: Michael T. Goodrich , Roberto Tamassia, Michael H. Goldwasser
Posted Date:
Students also viewed these accounting questions
-
How are the present value of a lump sum and the periodic payment of a sinking fund similar? How are they different?
-
Write a general red-ify function. Write a function that accepts a picture as input, then doubles the red value of every pixel and cut the blue and green values in half.
-
Write a general blue-ify function. Write a function that accepts a picture as input, then doubles the blue value of every pixel and cut the red and green values in half.
-
What does this code print (unless it produces an error)? print(int("trick1".upper()[-1])==1)
-
Refer to Exercise 14.33. Obtain an analysis of variance for both dependent variables (i. e., y1 = mg/mL of active ingredient and y2 = pH). Draw conclusions about the stability of these 2-mL vials...
-
Consumer confidence is an indicator of the level of optimism that consumers have about the performance of their countrys economy. How might consumer confidence affect the decisions of marketers and...
-
Consider the consumptionsaving problem of Section 2.1.2. How would you formulate the problem using multistage stochastic programming with recourse or stochastic dynamic programming?
-
Droog Co. is a retailer dealing in a single product. Beginning inventory at January 1 of this year is zero, operating expenses for this same year are $5,000, and there are 2,000 common shares...
-
Prepare a business plan which includes the following information: What changes will be required and why What the risks are and how these can be resolved What the benefits and expected outcomes are...
-
Described below are three independent and unrelated situations involving accounting changes. Each change occurs during 2021 before any adjusting entries or closing entries are prepared. a. On...
-
= 4 1.The ceiling function is defined by [x] = n where nis the unique integer so that n-1 < xn. For example [3.25] since 4 is the least integer still greater than 3.25. a. Sketch a graph of y = [x]....
-
What are nominal, real and personal accounts? Give four examples of each of them.
-
While interest payment is an expense, dividend payment, in contrast, is not reckoned expense. Explain.
-
You would most likely be a union member if you _______. a) were a teacher b) lived in the South c) worked for Walmart d) were a corporate executive
-
The analysis of cash flow statement in any organisation can be very useful to the management. Elucidate the statement.
-
The cash flow statement is as useful to shareholders and lenders as to management. Explain.
-
5. A particle moving in simple harmonic motion has a period, T, of 0.5 seconds, and an amplitude of 30 cm. If it starts at its maximum positive displacement (x = +30cm) at time t = 0.09 find the...
-
a. Determine the domain and range of the following functions.b. Graph each function using a graphing utility. Be sure to experiment with the window and orientation to give the best perspective of the...
-
The shuffle method, supported by the random module, takes a Python list and rearranges it so that every possible ordering is equally likely. Implement your own version of such a function. You may...
-
Write a short recursive Python function that rearranges a sequence of integer values so that all the even values appear before all the odd values.
-
Implement the _ _neg_ _ method for the Vector class of Section 2.3.3, so that the expression v returns a new vector instance whose coordinates are all the negated values of the respective coordinates...
-
A Consider \[\begin{cases}\dot{x}_{1}=-x_{1}\left|x_{1} ight|+a x_{2}-\frac{2}{3}+\sin t & x_{1}(0)=\frac{2}{3} \\ \dot{x}_{2}=-x_{1}-\frac{1}{2} x_{2}-1, & x_{2}(0)=1\end{cases}\] where \(a\) is a...
-
Draw the Bode plot and identify the corner frequency, as well as the asymptotic approximations of magnitude for low-frequency and high-frequency ranges. \(G(s)=\frac{4}{3 s+\frac{2}{3}}\)
-
The governing equation for an RLC circuit driven by the applied voltage \(v_{a}(t)\) is derived as \[L \frac{d i}{d t}+R i+\frac{1}{C} \int i d t=v_{a}(t)\] where \(L=4 \mathrm{H}, R=4 \Omega\), and...
Study smarter with the SolutionInn App