Based on the information above, identify which project (Project A or B) should be accepted? Explain why. By changing the figures in the excel template (above), assume the interest rate for Project A fell to 13%, and Cash outflow (The initial investment) was $950,000, Cash Inflows was $350,000 per annum for the 6 years, and Net inflows was also $250,000. For Project B, assume interest rate also fell to 13% but Cash outflow, Inflow and Net Inflows remain the same. What is the new NPV for each of the project? Would you receommend that any of these t1

Corporate Fin Focused Approach
5th Edition
ISBN:9781285660516
Author:EHRHARDT
Publisher:EHRHARDT
Chapter2: Financial Statements, Cash Flow, And Taxes
Section: Chapter Questions
Problem 14SP
icon
Related questions
Question
C9
1
2
3 Question 1:
COMPARING TWO PROJECTS UNSING NET PRESENT VALUE (NPV)
4
5 Project A
6 Required
7 Outflow
8 Inflow
9 Net Inflow
LO NPV
Interest rate
Year 0
Year 1
Year 2
Year 3
Year 5
Year 6
Total
15%
($700,000)
$225,000
$225,000
$225,000
$225,000
$225,000
$225,000
$225,000
$225,000
($700,000)
$225,000 1,125,000.00
$429,000
$225,000
$54,234.90
1
L2
3 Project B
4 Required
5 Outflow
6 Inflow
15%
($400,000)
$110,000
$110,000
$110,000
$110,000
$110,000
$110,000
$110,000
$110,000
$110,000
$110,000
($400,000)
$550,000
$150,000
7 Net Inflow
8 NPV
($31,262.94)
Based on the information above, identify which project (Project A or B) should be accepted? Explain why. By
changing the figures in the excel template (above), assume the interest rate for Project A fell to 13%, and Cash
outflow (The initial investment) was $950,000, Cash Inflows was $350,000 per annum for the 6 years, and Net
inflows was also $250,000. For Project B, assume interest rate also fell to 13% but Cash outflow, Inflow and Net
Questions:
Answer
Inflows remain the same. What is the new NPV for each of the project? Would you receommend that any of these
20
01
Sheet1
Ready
Ps
Transcribed Image Text:C9 1 2 3 Question 1: COMPARING TWO PROJECTS UNSING NET PRESENT VALUE (NPV) 4 5 Project A 6 Required 7 Outflow 8 Inflow 9 Net Inflow LO NPV Interest rate Year 0 Year 1 Year 2 Year 3 Year 5 Year 6 Total 15% ($700,000) $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 ($700,000) $225,000 1,125,000.00 $429,000 $225,000 $54,234.90 1 L2 3 Project B 4 Required 5 Outflow 6 Inflow 15% ($400,000) $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 ($400,000) $550,000 $150,000 7 Net Inflow 8 NPV ($31,262.94) Based on the information above, identify which project (Project A or B) should be accepted? Explain why. By changing the figures in the excel template (above), assume the interest rate for Project A fell to 13%, and Cash outflow (The initial investment) was $950,000, Cash Inflows was $350,000 per annum for the 6 years, and Net inflows was also $250,000. For Project B, assume interest rate also fell to 13% but Cash outflow, Inflow and Net Questions: Answer Inflows remain the same. What is the new NPV for each of the project? Would you receommend that any of these 20 01 Sheet1 Ready Ps
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Planning
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage