Vikram Exercise 14-5 (Algo) Preference Ranking [LO14-5]Information on four Investment proposals is given below:Investment ProposalC$ (150,000)228,600$ 78,6006 yearsD$ (1,260,000)1,681,100$ 421,1006 yearsInvestment requiredABPresent value of cash inflows$ (130,000)185,600$ 55,600$ (140,000)193,800$ 53,8005 years7 yearsNet present valueLife of the projectRequired:1. Compute the profitability Index for each Investment proposal.Note: Round your answers to 2 decimal places.2. Rank the proposals in terms of preference.Investment ProfitabilityProposalRankIndexPreferenceABсD

Please find the attached screenshot of the excel sheet containing the detailed calculation for the…

Answered: Exercise 14-5 (Algo) Preference Ranking…

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter11: The Cost Of Capital

Section: Chapter Questions

Problem 19PROB

See similar textbooks

Similar questions

Exercise 14-5 (Algo) Preference Ranking [LO14-5] Information on four investment proposals is given below: Investment Proposal A B C D Investment required $ (390,000) $ (30,000) $ (40,000) $ (600,000) Present value of cash inflows 551,000 41,000 64,100 800,000 Net present value $ 161,000 $ 11,000 $ 24,100 $ 200,000 Life of the project 5 years 7 years 6 years 6 years Required: 1. Compute the profitability index for each investment proposal. (Round your answers to 2 decimal places.) 2. Rank the proposals in terms of preference.
Exercise 14-5 (Algo) Preference Ranking [LO14-5] Information on four investment proposals is given below: Investment required Present value of cash inflows Net present value Life of the project Required: Investment Profitability Proposal Index A B C D A $ (60,000) 88,600 $ 28,600 1. Compute the profitability index for each investment proposal. Note: Round your answers to 2 decimal places. 2. Rank the proposals in terms of preference. Rank Preference 5 years Investment Proposal C $ (110,000) 168,600 $ 58,600 B $ (190,000) 260,600 $ 70,600 7 years 6 years D $(2,660,000) 3,551,000 $ 891,000 6 years
Exercise 14-5 (Algo) Preference Ranking [LO14-5] Information on four investment proposals is given below: Investment required Present value of cash inflows Net present value Life of the project Investment Profitability Proposal Index A BUD В с D $ (280,000) 393,900 $ 113,900 Required: 1. Compute the profitability index for each investment proposal. (Round your answers to 2 decimal places.) 2. Rank the proposals in terms of preference. Rank Preference. 5 years Investment Proposal C $ (50,000) 78,100 $28,100 B $ (140,000) 192,800 $ 52,800 7 years 6 years D $ (780,000) 1,038, 100 $ 258, 100 6 years.
Alpesh
Exercise 14-11 (Algo) Preference Ranking of Investment Projects [LO14-5] Oxford Company has limited funds available for investment and must ration the funds among four competing projects. Selected information on the four projects follows: Project InvestmentRequired PresentValue of Cash Inflows Life oftheProject(years) InternalRateof Return A $ 180,000 $ 224,323 7 21% B $ 151,000 $ 197,000 12 18% C $ 102,000 $ 155,035 7 17% D $ 161,000 $ 233,136 3 16% The net present values should be computed using a 10% discount rate. The company wants your assistance in determining which project to accept first, second, and so forth. Required: 1. Compute the profitability index for each project. 2. In order of preference, rank the four projects in terms of net present value, profitability index, and internal rate of return.
Exercise 12-5 (Algo) Preference Ranking [LO12-5] Information on four investment proposals is given below: Investment required Present value of cash inflows Net present value Life of the project Investment Profitability Proposal Index A B C D A $ (60,000) 88,600 $ 28,600 Rank Preference 5 years Investment Proposal C $ (110,000) 168,600 $ 58,600 B $ (190,000) 260,600 $ 70,600 Required: 1. Compute the profitability index for each investment proposal. (Round your answers to 2 decimal places.) 2. Rank the proposals in terms of preference. 7 years 6 years D $ (2,660,0 3,551,0 $ 891,0
please answer do not image format
Exercise 14-11 (Algo) Preference Ranking of Investment Projects [LO14-5] Oxford Company has limited funds available for investment and must ration the funds among the four competing projects shown below: Project Investment Required Present Value of Cash Life of the Project Internal Rate Inflows ABL $ 160,000 $ 259,323 (years) 7 of Return 16% $ 135,000 $ 232,000 12 18% C $ 100,000 $ 190,035 7 22% D $ 164,000 $ 268,136 3 17% The net present values above have been computed using a 10% discount rate. Required: 1. Compute the profitability index for each project. 2. In order of preference, rank the four projects in terms of net present value, profitability index, and internal rate of return. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the profitability index for each project. Note: Round your answers to 2 decimal places. Profitability Project Index A B C D
Exercise 12-11 (Algo) Preference Ranking of Investment Projects [LO12-5] Oxford Company has limited funds available for investment and must ration the funds among four competing projects. Selected information on the four projects follows: Project A B C D Investment Required $ 130,000 $ 136,000 $ 105,000 $ 169,000 Present value of Cash Inflows $ 249,323 $ 222,000 $ 180,035 $ 258, 136 Required 1 Required 2 Project Life of the Project (years) 7 The net present values should be computed using a 10% discount rate. The company wants your assistance in determining which project to accept first, second, and so forth. A B C 12 Required: 1. Compute the profitability index for each project. 2. In order of preference, rank the four projects in terms of net present value, profitability index, and internal rate of return. 7 3 Complete this question by entering your answers in the tabs below. Profitability Index Internal Rate of Return 20% 18% 19% 17% Compute the profitability index for each project.…
12q-9
Answer in Excel, Attached it question.
12q-19

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

SEE MORE TEXTBOOKS