There are two altematives: A, and A2 Use trial & error and interpolation methods for finding exact value of IRR for difference between two alternatives (Draw cash flow diagram of difference). Which project is a better choice? Given MARR is 9%. Write formula and show your solution step by step A1 -$12,000 4,200 6,225 6,330 A2 -$1,000 n 1 800 2 500 3 500

There are two altematives: A, and A2 Use trial & error and interpolation methods for finding exact value of IRR for difference between two alternatives (Draw cash flow diagram of difference). Which project is a better choice? Given MARR is 9%. Write formula and show your solution step by step A1 -$12,000 4,200 6,225 6,330 A2 -$1,000 n 1 800 2 500 3 500

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

NPV profile of a project. Given the following cash flow of Project L-2, draw the NPV profile. Hint: Be sure to use a discount rate of zero for one intercept (y-axis) and solve for the IRR for the other intercept (x-axis). (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 = - $300,000 Year 1= $42,000 Year 2 = $77,000 Year 3 = $111,000 Year 4 = $140,000 What is the NPV of Project L-2 where zero is the discount rate? $ 70000.00 (Round to the nearest dollar.) What is the IRR of Project L-2? % (Round to two decimal places.)
EVALUATION o Given the following mutually-exclusive alternatives and a Minimum Attractive Rate of Return (MARR) of 7%, which should be chosen? o Solve as PV, FV and AW (3 separate analyses for each Design) and show which Design gets chosen in each. SHOW YOUR WORK (including cash flow diagram) with tool formulas, not tables at this time to ensure you're understanding the concepts. Year 0 1 23 4 5 Total Design A ($2500) $0 $0 $0 $0 $3100 $600 Design B ($2700) $650 $650 $650 $650 $700 $600 Design C ($3000) $250 $500 $750 $1000 $1250 $750
Suppose a project has an initial outflow of $600000. If the cash flows projected for years 1-6 are $225000, $200000, $250000, $100000, $0, and $50000, respectively the IRR. Draw the timeline. Set up (by hand) the equation to solve for IRR. DO NOT SOLVE. Solve for the IRR using excel. Create a data table in excel to solve for the NPV based on different costs of capital and initial outflow.
Consider the following cash flows: C0=-$42 C1=+$38 C2=+$38 C3=+$38 C4=-$76 a. Which two of the following rates are the IRRs of this project? (You may select more than one answer.) check all that apply 2.5% 7.8% 14.3% 32.5% 40.0% b. What is project NPV if the discount rates are 5%, 20%, 40%? (Negative amount should be indicated by a minus sign. Do not round intermediate calculations and round your final answer to 3 decimal places.)
Whispering Winds Company is considering a long-term investment project called ZIP. ZIP will require an investment of $130,000. It will have a useful life of four years and no salvage value. Annual cash inflows would increase by $81,000, and annual cash outflows would increase by $40,500. In addition, the company's required rate of return is 10% Click here to view the factor table (a) Calculate the net present value on this project. (If the answer is negative, use either a negative sign preceding the number eg-5,275 or parentheses es. (5,275), For calculation purposes, use 5 decimal places as displayed in the factor table provided, eg. 1.25124 and final answer to O decimal places, eg. 5,275) Net present value $ Identify whether the project should be accepted or rejected. The project should be (b) Q Search 458 PM
Consider the two mutually exclusive projects described in the table below. the question requires a step by step excel solutionFor any positive value of the MARR, divide the possible MARR values into ranges with different decisions;describe and discuss what decision would be made in each range and why. You will need to calculate the crossover rate to determine the precise MARR where the decision changes. Include an NPV profile table and chart to illustrate your answer.Year Cash Flow Project A Cash Flow Project B0 -450,000 -700,0001 200,000 200,0002 150,000 200,0003 100,000 200,0004 100,000 200,0005 75,000 200,000
Calculate/estimate the IRR(s) for a 6-year project with the following cash flows: CF0 = -50, CF1 =28 = CF2 = CF3 = CF4 = CF5, and CF6 = -93. In Excel, plot the NPV (= Y axis) against r (= discountrate), using r = 0%, 2%, and so on until you find all IRRs in the chart. Identify/estimate all IRRs.
3e.a.Determinethe payback period for each b.Calculatethe net present value (NPV) for each c.Calculatethe profitability index (PI) for each project. d.Calculatethe internal rate of return (IRR) for each e.Basedon ALL your answers above, explain briefly which project should be Note: i just need (e) no question answer not all no need excle formula , thank you
A2. (PaybackandNPV)Threeprojectshavethecashflowsgivenhere.Thecostofcapitalis10%. a. Calculate the paybacks for all three projects. Rank the projects from best to worst based on their paybacks. Calculate the NPVs for all three projects. Rank the projects from best to worst based on their NPVs c. Why are these two sets of rankings different? YEAR 0 1 2 3 4 5Project 1 −10 4 3 2 1 5 Project 2 −10 1 2 3 4 5 Project 3 −10 4 3 2 1 10
You are choosing between two projects. The cash flows for the projects are given in the attached table ($miilion) . a. What are the IRRs of the two projects? (A &B) b. If your discount rate is 4.9%,what are theNPVs of the two projects? (A & B) c. Why do IRR and NPV rank the two projects differently?
Rate of return analysis. Penne internal rate of return. The projested cash flow of a project (T-0 to T-5) is -S20,000. S2000, S8000, $12000, S8000, $2000, Briefly explain how you would caleulate the 1RR by nan and error if all you had was a hand calculator without financial funetion keys. DO NOT a. make any calculations.
Project A and B have a cost of OMR (700). Each project generates cash flows as seen in the below table, According to the payback period method and in the line of risk and liquidity preference, answer the following:- (Hint:- Your answer must be not random.) which is the project you will select? Justfy your decision. End-of- Year Cash Flow Project 1 2 3 A 500 300 100 B 400 450 100

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS