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...
Help finish the CVP income statement Use the CVP Analysis Tab to complete this analysis. Ignore interest expense for this section. 1. What is the breakeven point in units sold? What is the breakeven...
Explain the special issues that may arise in a purchase, and show how to account for them. AppendixLO1
On January 1, 2014, Prince Corporation acquired 70% of the 100,000 outstanding voting shares of Song Limited for a cash consideration of $1,015,000. On that date, shares of Song Limited were trading...
Marin Inc. issues $4,000,000 of 5% bonds due in 5 years with interest payable at year-end. The current market rate of interest for bonds of similar risk is 7%. Click here to view the factor table....
The following balance sheet and income statement data were taken from the records of Mako Retail Supply for the year ended December 31, 2018: Prepare the operating section of the statement of cash...
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...
When a corporation wants to sell a new security (whether debt or equity) through the public capital markets, if the corporation (issuer) and any of the persons to whom the security is offered...
Assume you have been given $400,000 CAD with access to all listed stocks, bonds, futures, and options worldwide. You can trade in options and futures, in combination with the underlying asset....
Charlene wrote a letter to Rachel offering to sell her car, a Proton Saga, for RM 60,000. The letter reached Rachel on 25. 11.2020. Rachel sent her letter of acceptance at 3 p.m. on the same day....
Data for the risk premium sensitivities (b, s, and h) as well as the beta coefficient for the CAPM of two companies are listed in the following table: Company b s h ERP SMBP HMLP Beta Alpha 1.1114...
Free-Response Questions 1. m Initial position eviribrA ARAL m Incline raised to 0 <0max pr A block of mass m is initially at rest on a rough board, which is initially horizontal on a tabletop. The...
A picture frame sits atop a bookshelf. When the bookshelf is bumped, the frame tumbles to the floor, landing after 0.64 s. How tall is the bookshelf?
Explain intranet.
As indicated by mutual fund flows, investors tend to beat the market seek safety invest in last year's winner invest in last years loser
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.
Discuss why it is important for company managers to understand and use social capital knowledge to help build social ties among their skilled knowledge workers so they can build employee loyalty...
Kate lives in a house close to a local university, and she traditionally has rented a garage apartment in the back of her property to students for $750 per month. Kate wants to transfer the title to...
Pottery Ranch Inc. has been manufacturing its own finials for its curtain rods. The company is currently operating at 100% of capacity, and variable manufacturing overhead is charged to production at...

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