Question: #The numpy function np.pv(rate, nper, pmt, fv=0, when='end') works like the Excel pv() function to calculate the present value of an annuity. The last two

#The numpy function np.pv(rate, nper, pmt, fv=0, when='end') works like the Excel pv() function to calculate the present value of an annuity. The last two inputs (fv and when) are optional.

-Assuming that the annualized percentage interest rate is 4%. An annuity investment offers monthly payments of $30,000 per month for 5 years.

a. Calculate the present value this investment using the np.pv() function and print the answer.

b. Keeping the size and number of payments the same, graph the present value of the annuity vs. the discount rate for discount rates ranging from 0.01 to 0.20 in increments of .01. Put a title and axis labels on the plot

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I am having a hard time answering the tabs 5 thru 7 on the attached excel spread sheet. I am new at this and would love to be able to use it as an example going forward. Can you help me complete so I...

A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49\% (15-year term) with monthly payments of $1,881.46. They just made their 25th payment, and...

Chapter 9 - Financial Functions in Excel Use the RATE, NPER, PMT, PV and FV functions to answer the following. Remember the following important subtleties: RATE = periodic rate; you must divide the...

Please type the formulas for the yellow ones. Thank You! -aurman, Inc. Is considering a new project and has provided the detalls of the project. The Controller has asked you to compute varlous...

please use correct excel functions the application is bery specific Laurman, Inc. Is considering a new project and has provided the detalls of the project. The Contioller has asked you to compute...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

123please help me with this Winter 1, 2013 7/22/2012 Chapter 4. Ch 04 P35 Build a Model Except for charts and answers that must be written, only Excel formulas that use cell references or functions...

I am having issues with this entire problem. I posted the problems. Can you please break down the formulas and points you use please To get the dialog box, click on fx, then Financial, then FV, then...

1. Before doing Q1 and Q2, please first read the assigned readings and do quiz 2. Based on Chapter 4's Section 6 to 9, answer: 1) If the definition of FVA is future value of annuity, what are...

Why are forecasts generally wrong?

Complete the highlighted areas in the Markov analysis below to forecast availabilities for the next year, by job category. The notes below the table will assist you in doing this. Transition...

The tax shield adds an advantage to using debt. True False

please answer based on given program. 5. Consider the following program. (25 points) void main() \{ int xian, boy, carry: * definition 1 void Testl 0 t int xian, boy, month, zoo; / definition 2% Test...