B C In-class activities Time Value of Money, Part 2 D E F G H 1....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
B C In-class activities Time Value of Money, Part 2 D E F G H 1. A security has a cost of $1,000 and will return $2,000 after 5 years. What rate of return does the security provide? A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Inputs: PV = -1000 FV = 2000 r/YR = N = ? 5 15 Wizard (Rate): Note: Use zero for Pmt since there are no periodic payments. Note that the PV is given a negative sign 16 because it is an outflow (cost to buy the security). Also, note that you must scroll down the menu to 17 complete the inputs. 18 19 2. Suppose California's population is 30 million people, and its population is expected to grow by 20 2% per year. How long would it take for the population to double? 21 22 Inputs: 23 PV = FV = -30 60 24 25 r/YR = growth rate N = 2% 26 27 Wizard (NPER): 28 29 30 = Years to double. 31 3. What is the future value of $100 after 5 years under 12% annual compounding? 32 33 nX1 34 r 35 PV 36 37 FV = EAR = 38 What is the FV with semiannual compounding?What is the EAR%? 39 40 nX2 FV = B C In-class activities Time Value of Money, Part 2 D E F G H 1. A security has a cost of $1,000 and will return $2,000 after 5 years. What rate of return does the security provide? A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Inputs: PV = -1000 FV = 2000 r/YR = N = ? 5 15 Wizard (Rate): Note: Use zero for Pmt since there are no periodic payments. Note that the PV is given a negative sign 16 because it is an outflow (cost to buy the security). Also, note that you must scroll down the menu to 17 complete the inputs. 18 19 2. Suppose California's population is 30 million people, and its population is expected to grow by 20 2% per year. How long would it take for the population to double? 21 22 Inputs: 23 PV = FV = -30 60 24 25 r/YR = growth rate N = 2% 26 27 Wizard (NPER): 28 29 30 = Years to double. 31 3. What is the future value of $100 after 5 years under 12% annual compounding? 32 33 nX1 34 r 35 PV 36 37 FV = EAR = 38 What is the FV with semiannual compounding?What is the EAR%? 39 40 nX2 FV =
Expert Answer:
Answer rating: 100% (QA)
SOLUTION Sure Id be happy to help Here are the solutions to the problems 1 A security has a cost of 1000 and will return 2000 after 5 years What rate ... View the full answer
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Posted Date:
Students also viewed these finance questions
-
You would like to buy a house in in 16 years and estimate that you will need a deposit of $73,014. You plan to make bi-weekly deposits into an account that you hope will earn 7.05%. How much do you...
-
The function f(x) = k(2 x x3) has an inverse function, and f1(3) = 2. Find k.
-
Natsam Corporation has $250 million of excess cash. The firm has no debt and 500 million shares outstanding with a current market price of $15 per share. Natsams board has decided to pay out this...
-
We will use the Minitab macro BinoBP or R function binobp to nd the posterior distribution of the binomial probability when the observation distribution of Y is binomial(n,) and we have a beta(a, b)...
-
The comparative balance sheet of Mills Engine Co. at December 31, 2013 and 2012, is as follows: The noncurrent asset, noncurrent liability, and stockholders' equity accounts for 2013 are as follows:...
-
(a) Explain the following methods of payment that could be used by a multinational corporation (MNC) to settle international transactions: Required: (i) Prepayment. (2 marks) (ii) Letters of credit...
-
You have a 9 9 grid of squares, each of which can be colored red or blue. The grid is initially colored all blue, but you can change the color of any square any number of times. Imagining the grid...
-
(Q8) Can someone explain and answer? Image transcription text What is the skewness of the element in the figure below? 810 720 NOT TO SCALE O Skewness = 1 O Skewness = 0.175 O Skewness = 0.2 O...
-
How do advances in systems biology and computational modeling contribute to our understanding of the integrated network of metabolic, respiratory, and signaling pathways that govern cellular...
-
Tawas has just set up his new IT consulting company in London and has approached you to get advice taxes, banking and financing in particular he wants to know about the various types of taxes he...
-
The Premier Application You will use a Dictionary to drive this application. The Key will be the last name of the premier (there is a method in the Premier class that generated a key) and the value...
-
A three-year long forward contract is entered into when the spot price of an investment asset is $30 and the risk free rate for all maturities. (With continuous compounding is 10%. the asset provides...
-
Using Java Language make the following 1. Create a class Person to represent a person according to the following requirements: A person has two attributes: id name. a) Add a constructer to initialize...
-
3. In a parallogram ABCD, P divides AB in the ratio 2:5 and Q divides DC in the ratio 3:2. If AC and PQ intersect at R, find the ratios AR : RC and PR: RQ. 4. D and E are any two points on the sides...
-
Determine by direct integration the values of x for the two volumes obtained by passing a vertical cutting plane through the given shape of Fig. 5.21. The cutting plane is parallel to the base of the...
-
I have 500 potential customers who come to my candy store each day. Seventy percent of the customers buy no pieces of candy, 15 percent buy one piece, 10 percent buy two pieces, and 5 percent buy...
-
The file Nba02_03.xlsx contains scores for every regular season game during the 20022003 NBA season. Rate the teams.
-
The workbook Problem3_18.xlsx contains your baseball salary data, but the data is not sorted by salary. Which of the formulas in the workbook XLOOKUP.xlsx will return different answers when applied...
-
Consider the following binary linear programming formulation of a capital budgeting problem. \[\begin{array}{ll}\text { Max } & 1,200 x_{1}+600 x_{2}+950 x_{3}+1,650 x_{4} \\\text { s.t. } & 15,000...
-
Consider the following binary linear programming formulation of a capital budgeting problem. \[\begin{array}{ll}\text { Max } & 1,200 x_{1}+600 x_{2}+950 x_{3}+1,650 x_{4} \\\text { s.t. } & 15,000...
-
Consider six mutually exclusive and indivisible investment alternatives under evaluation by TranSystems in their bridge and structure design group. At any time TranSystems chooses to exit the...
Study smarter with the SolutionInn App