Write a function NewPV(CF, r) which calculates the present value of a given cash flow CF at

Question:

Write a function NewPV(CF, r) which calculates the present value of a given cash flow CF at interest rate r for 5 periods:

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Financial Modeling

ISBN: 9780262027281

4th Edition

Authors: Simon Benninga

See More Books

Question Posted: Dec 29, 2020 12:36 AM

See More Questions

The Excel function PV(rate, number_periods, payment) calculates the present value of a constant payment. For example in the spreadsheet example below, Use Data Table to graph the present value as a...
Interest rates determine the present value of future amounts. Requirements 1. Determine the present value of seven-year bonds payable with maturity value of $91,000 and stated interest rate of 14%,...
The present value of interest tax shields is often written as TcD, where D is the amount of debt and Tc is the marginal corporate tax rate. Under what assumptions is this present value correct?
Elaborate the basic functioning of a hydraulic lift. Include the terms pressure, density, and buoyant force in the explanation. Give one example of a hydraulic lift you have encountered.
A lender makes a loan of S3 million that carries an interest rate of six-month LIBOR + 125 basis points and matures in two years. The lender is worried about a decline in the LIBOR rate and in order...
How can a misunderstanding around the application of cost concepts and classifications in any company lead to a poor decision making?
Two machines are used to fill cans. The machines are supposed to fill each can with 12 ounces of liquid. The amounts actually filled follow a normal distribution. A simple random sample of 10 cans is...
Calculate the average raw food cost per resident per day for the month of June. A. $.80 B. $1.25 C. $2.40 D. $7.20 The following information from a long-term care facility for questions. April $2319...
Crystal Charm Company makes handcrafted silver charms that attach to jewelry such as a necklace or bracelet. Each charm is adorned with two crystals of various colors. Standard costs follow: Silver...
The following provides a brief description of the computerized payroll system used by Merriman in its biweekly processing of payroll for its employees. 1. Employees automatically record their...
Write a VBA function that computes the n th number in the Fibonacci series; do not use recursion. A 1 Exercise 11 2 n LoopFibonacci 0
Rewrite the function in exercise 2 as BetterNewPV(CF, r, n), so it could deal with n periods. 1 BETTERNEWPV IN ACTION 2 CF D E BetterNewPV r n 5% =BetterNewPV(A3,B3,C3) =BetterNewPV(A4,B4,C4) 3...
Observations on shear strength for 26 subgroups of test spot welds, each consisting of six welds, yield xi = 10,980, si = 402, and ri 5 1074. Calculate control limits for any relevant control charts.
Thompson's Hardware spent $46,370 this year on business insurance alone. If total sales were $765,500, what percent of total sales was spent on business insurance? Round to the nearest tenth.
The altitude of a triangle is increasing at a rate of 2 centimeters/minute while the area of the triangle is increasing at a rate of 2.5 square centimeters/minute. At what rate is the base of the...
Draw a finite automaton (NFA or DFA, at your choice) that accepts the regular (a Uba)*. expression: 4. (15 Points) Convert this NFA to an equivalent DFA: S t S q0 t S q2
Consider the equation below. 4x + y +42 - 4y 24z + 36 = 0 Reduce the equation to one of the standard forms. Classify the surface. elliptic cylinder circular cone ellipsoid hyperboloid of one sheet...
Find dx dt dx - dt at x= dy =-4 if y = x + 2 and = dt 1.
Answer true or false and explain your answer: If it is important not to reject a true null hypothesis, the hypothesis test should be performed at a small significance level?
The diameter of a sphere is 18 in. Find the largest volume of regular pyramid of altitude 15 in. that can be cut from the sphere if the pyramid is (a) square, (b) pentagonal, (c) hexagonal, and (d)...
Identify all the problems Target Canada encountered that prevented it from becoming a successful retailer. What were the management, organization, and technology factors that contributed to these...
How much of Target Canadas problems were technology based? Explain your answer.
How responsible was management for Target Canadas problems? Explain your answer.
Outline two benefits of good group dynamics on a team's performance. Provide examples of three causes of poor group dynamics. Explain why a team would need a team performance plan.
Find the NPV of the project below if your company WACC = 10% and the project has comparable risk to your firm's average risk. The project requires an immediate investment of $50,000 and generates a...
Performance appraisals are used throughout business to provide feedback and growth opportunities to employees; this in turn leads to increased productivity. Leaders create performance appraisals for...

Write a function NewPV(CF, r) which calculates the present value of a given cash flow CF at

Question:

NewPV(CF,r)= CF CF + CF CF CF (1+r)' ' (1+r)* ' (1+r)* ' (1+r)* ' (1+r)°

Step by Step Answer:

Solution rowcolumn A B C D 1 New PV in actiion 2 CF r New P...View the full answer

Financial Modeling

Students also viewed these Business questions