Need someone to solve these for IRR in Excel A IRR = RATE(nper = 10, pmt...

Need someone to solve these for IRR in Excel

A

IRR = RATE(nper = 10, pmt = 1525000, pv = -860000, fv = 0, 0)

B

IRR = RATE(nper = 10, pmt = 1100000, pv = 800000, fv = 980000, 0)

Expert Solution

Year	Project A	Project B
0	-860000	-800000
1	1525000	1100000
2	1525000	1100000
3	1525000	1100000
4	1525000	1100000
5	1525000	1100000
6	1525000	1100000
7	1525000	1100000
8	1525000	1100000
9	1525000	1100000
10	1525000	2080000

IRR	177.32%	137.51%

WORKINGS

jeff jeffy answered 2 years ago

#The numpy function np.pv(rate, nper, pmt, fv=0, when='end') works like the Excel pv() function to calculate...

#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...

Chapter 2 is using the EXCEL functions FV, PV, NPV, PMT, NPER, RATE & SUM. Explain in plain English in a clear and detail way how you can use these functions. How many inputs you need for each of these outputs?

Chapter 2 is using the EXCEL functions FV, PV, NPV, PMT, NPER, RATE & SUM. Explain in plain English in a clear and detail way how you can use these functions. How many inputs you need for each of these outputs? Are all inputs required? Why not? Use the excel help in order to understand these Formulas. Do not copy and paste. This question has seven parts, identify each part with a letter from the beginning of the alphabet, as...

,10. ( I NEED TO SOLVE THIS WITH EXCEL SPREADSHEET AND SENSITIVITY REPORT) Grave City...

,10. ***( I NEED TO SOLVE THIS WITH EXCEL SPREADSHEET AND SENSITIVITY REPORT) *** Grave City is considering the relocation of several police substations to obtain better enforcement in high-crime areas. The locations under consideration together Potential Locations for Substations: Areas Covered: A 1,5,7 B 1,2,5,7 C 1,3,5 D 2,4,5 E 3,4,6 F 4,5,6 G 1,5,6,7 a. Formulate an integer programming model that could be used to find the minimum number of locations necessary to provide coverage to all areas....

please, I need it with 30 minutes . can someone solve this ASAP and post ,...

please, I need it with 30 minutes . can someone solve this ASAP and post , I really appreciate. 4. "Machine A has an immediate cost of $15,000, and it will earn a net income of $4300 per year for a total of 7 years. Machine B has an immediate cost of $17,000, and it will earn a net income of $4400 per year for a total of 35 years. Assume that Machine A can continually be replaced at the...

I need a screenshot of the proper excel model to solve this: A Supply Company maintains...

I need a screenshot of the proper excel model to solve this: A Supply Company maintains 3 plants (production facilities P1, P2, & P3) which supply three fuel distributors (A, B, & C) in the city. Daily plant capacities: P1 = 4500 gallons; P2 = 3000 gallons; P3 = 5000 gallons Daily distributor requirements: A = 5500; B = 2500; C = 4200 Per-gallon transportation costs (in dollars) for each plant-distributor combination are: A B C P1 0.80 0.50 ...

need to solve it on excel as soon as possible Assume that three business owners each...

need to solve it on excel as soon as possible Assume that three business owners each own an identical storage building valued at $120,000. Assume that there is a 1% chance in any year each building will be destroyed by a peril (fire), and that a loss to any of the buildings is an independent event. Assuming that: (first case ) Fire events are independent of each other (second case) Each building faces the same types of risks and environmental...

DO NOT SOLVE IN EXCEL!!!! I need the actual formula & steps!! Consider the following...

**** DO NOT SOLVE IN EXCEL!!!!**** I need the actual formula & steps!! Consider the following hypotheses and sample data, and then complete parts a and b below using α=0.05 H0:μ≤16 H1:μ>16 2121 1818 1313 1717 2323 1919 1616 1919 1818 1616 I am getting the p-value wrong on all of these... I need to know the steps to solve p-value, please. I get all of the other stuff right, just not the p-value :(

I need to use Excel to solve the following: A United Nations report shows the mean...

I need to use Excel to solve the following: A United Nations report shows the mean family income for Mexican migrants to the United States is $27,000 per year. A Farm Labor Organizing Committee evaluation of 25 Mexican family units reveals the mean to be $30,000 with a sample standard deviation of $10,000. Does this information disagree with the United Nations report? Apply the .01 significance level.

Use Goal Seek in Excel, to solve for the yield to maturity (market rate of return)...

Use Goal Seek in Excel, to solve for the yield to maturity (market rate of return) on a corporate bond with a coupon rate of 4% per year, a maturity of 20 years, and a market value (price) of $1,210. Assume semi-annual coupon payments and a maturity payment of $1,000 per bond.

How to solve using Excel Solver: This is an assignment problem with 10 applicants and 5...

How to solve using Excel Solver: This is an assignment problem with 10 applicants and 5 positions. Determine the optimal assignments that Brenda Last should make. Use the data to determine the optimal assignments, but do not complete questions in the last two paragraphs of the text Formulate a linear programming model for this problem. List the objective function (minimize or maximize) and all model constraints. Solve problem using MS Excel’s Solver Hint: Use the “integer” constraint Highlight the "winning"...

Question