ONLY SHOW HOW TO DO IN EXCEL.
please no hard coded formulas
A. If the appropriate discount rate is 12%, rank the two projects.
B. Which project is preferred if you rank by IRR?
C. Calculate the crossover rate, namely, the discount rate r at which the NPVs of both projects are equal. D. Should you use NPV or IRR to choose between the projects? Give a brief description.
Homework Answers
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP
PLEASE
Add Answer to:
ONLY SHOW HOW TO DO IN EXCEL.
please no hard coded formulas
A. If the appropriate...
Your firm is considering two projects with the following cash flows: Cash flows from project B...
Your firm is considering two projects with the following cash flows: Cash flows from project B (£000) (500) 200 250 170 25 30 Year Cash flows from project A (£000) 0(500) 167 180 160 100 100 4 1. Calculate the ARR and payback rule 2. If the appropriate discount rate is 12%, rank the two projects 3. Which project is preferred if you rank by IRR? 4. Calculate the discount rate (r) for which the NPVs of both projects are...
Show excel formulas A company has a 11% WACC and is considering two mutually exclusive investments...
Show excel formulas
A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 4 Project A Project B ($300) ($400) ($387) $132 ($193) $132 ($100) $132 $500 $132 $500 $132 $850 $132 ($180) $0 a. What is each project's NPV? Round your answer to the nearest cent. b. What is each project's IRR? Round your answer to two decimal places. c. What is each project's MIRR? d. From...
PLEASE ONLY SHOW HOW TO DID IN EXCEL AND ONLY HARD CODED FORMULAS D 1 Year...
PLEASE ONLY SHOW HOW TO DID IN EXCEL AND ONLY HARD CODED
FORMULAS
D 1 Year 2 Cash flow -750,000 500,000 500,000 3 500,000 4 500,000 500,000 -2,000,000 5% 10% 45% 4 Cost of capital,r 5 NPV 6 Accept/reject? 3 Part d: to decide on a range of cost of capital to accept/reject, make a table of NPV for different r NPV AFAMAA 10 Cost of capital, 0% 2% 4% 6% 8% 10% 12% 14% 16% 18% 20% 22% 24%...
Please answer A, B, C with excel thank you! You are choosing between two projects. The cash flows for the projects...
Please answer A, B, C with excel thank you!
You are choosing between two projects. The cash flows for the projects are given in the following table (5 million) Project Year 0 Year 1 Year 2 - $50 $23 -$102 $20 $40 Year 3 Year $18 $19 $59 a. What are the IRRs of the two projects? b. If your discount rate is 5.2%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the...
CAN SOMEONE PLEASE HELP WITH THIS QUESTION. THANK YOU! You are choosing between two projects. The...
CAN SOMEONE PLEASE HELP WITH THIS QUESTION. THANK YOU!
You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): Project Year 2 Year 0 - $49 - $102 Year 1 $25 $20 $19 Year 3 $18 $52 Year 4 $12 $62 $41 a. What are the IRRs of the two projects? b. If your discount rate is 5.2%, what are the NPVs of the two projects? c. Why do IRR...
this is really though for me someone please answer (16.67 points-Each question is equally weighted for the entire test to sum to 100%) The large miture retailer "Sofa So Good" is evaluatin...
this is really though for me someone please answer
(16.67 points-Each question is equally weighted for the entire test to sum to 100%) The large miture retailer "Sofa So Good" is evaluating two mutually exclusive projects: NPV versus IRR. Consider the following projects, where the firms may only ch The firm's cost of capital/required return equals 9% PLEASE NOTE: The firm's cost of capital, K, acts as a hurdle rate, and is based on the costs involved in financing other...
(Preferred: Please provide Excel formulas when calculating this problem; not the tables) Consider two projects, A and B....
(Preferred: Please provide Excel formulas when calculating this problem; not the tables) Consider two projects, A and B. The present value (PV) of after-tax cash inflows for project A is $55,000, while the original investment outlay for this project is $50,000. Project B, on the other hand, has the following characteristics: PV of after-tax cash inflows = $24,000; original investment outlay = $20,000. Assume that these two projects are mutually exclusive and that the company has adequate capital to fund...
Please show how to answer this step by step in Excel A company is considering two...
Please show how to answer this step by step in Excel A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.39 million per year for 20 years. Plan B requires a $12 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.69 million per year for 20 years. The firm's WACC is 11%....
how to do the problem Lab 7 (C11) FIN 203 - Exce Home Insert Draw Page Layout Formulas Data Review View Help T...
how to do the problem
Lab 7 (C11) FIN 203 - Exce Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do = Copy Format Painter Calibri BIU. -12 . A À . A 23 Wrap Text Merge & Center - Mignment Percentage $ -% Number - 53-43 S 162,021 Maya, the treasurer, believes the projects are not equally risky. She believes the firm should demand higher returns from riskier projects. She analyzes...
Excel Online Structured Activity: Capital budgeting criteria A company has a 12% WACC and is considering...
Excel Online Structured Activity: Capital budgeting criteria A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $132 $132 $132 $132 $132 $132 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the...
Your firm is considering two projects with the following cash flows: Cash flows from project B (£000) (500) 200 250 170 25 30 Year Cash flows from project A (£000) 0(500) 167 180 160 100 100 4 1. Calculate the ARR and payback rule 2. If the appropriate discount rate is 12%, rank the two projects 3. Which project is preferred if you rank by IRR? 4. Calculate the discount rate (r) for which the NPVs of both projects are...
Show excel formulas
A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 4 Project A Project B ($300) ($400) ($387) $132 ($193) $132 ($100) $132 $500 $132 $500 $132 $850 $132 ($180) $0 a. What is each project's NPV? Round your answer to the nearest cent. b. What is each project's IRR? Round your answer to two decimal places. c. What is each project's MIRR? d. From...
PLEASE ONLY SHOW HOW TO DID IN EXCEL AND ONLY HARD CODED
FORMULAS
D 1 Year 2 Cash flow -750,000 500,000 500,000 3 500,000 4 500,000 500,000 -2,000,000 5% 10% 45% 4 Cost of capital,r 5 NPV 6 Accept/reject? 3 Part d: to decide on a range of cost of capital to accept/reject, make a table of NPV for different r NPV AFAMAA 10 Cost of capital, 0% 2% 4% 6% 8% 10% 12% 14% 16% 18% 20% 22% 24%...
Please answer A, B, C with excel thank you!
You are choosing between two projects. The cash flows for the projects are given in the following table (5 million) Project Year 0 Year 1 Year 2 - $50 $23 -$102 $20 $40 Year 3 Year $18 $19 $59 a. What are the IRRs of the two projects? b. If your discount rate is 5.2%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the...
CAN SOMEONE PLEASE HELP WITH THIS QUESTION. THANK YOU!
You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): Project Year 2 Year 0 - $49 - $102 Year 1 $25 $20 $19 Year 3 $18 $52 Year 4 $12 $62 $41 a. What are the IRRs of the two projects? b. If your discount rate is 5.2%, what are the NPVs of the two projects? c. Why do IRR...
this is really though for me someone please answer
(16.67 points-Each question is equally weighted for the entire test to sum to 100%) The large miture retailer "Sofa So Good" is evaluating two mutually exclusive projects: NPV versus IRR. Consider the following projects, where the firms may only ch The firm's cost of capital/required return equals 9% PLEASE NOTE: The firm's cost of capital, K, acts as a hurdle rate, and is based on the costs involved in financing other...
how to do the problem
Lab 7 (C11) FIN 203 - Exce Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do = Copy Format Painter Calibri BIU. -12 . A À . A 23 Wrap Text Merge & Center - Mignment Percentage $ -% Number - 53-43 S 162,021 Maya, the treasurer, believes the projects are not equally risky. She believes the firm should demand higher returns from riskier projects. She analyzes...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago