Ch 11 Practice Questions solutions

.xlsx

School

Western University *

*We aren’t endorsed by this school

Course

20

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

11

Uploaded by DeaconWolverinePerson934

Report
Year 0 1 2 3 Cash Flows $ (155,000.00) $ 63,120.00 $ 70,800.00 $ 96,080.00 Balance $ (155,000.00) $ (91,880.00) $ (21,080.00) $ 75,000.00 2.22 25,000.0000 NPV Example 16.67% TIME CF PV of CF 0 $ (155,000.00) $ (155,000.00) Original Investment 1 $ 63,120.00 $ 56,357.14 CF Y1 2 $ 70,800.00 $56,441.33 CF Y2 3 $ 96,080.00 $68,387.85 CF Y3 Total $ 26,186.32 NPV $ 26,186.32 NPV Formula You are looking at a new project and you have estimated the following cash flows: Year 0: Initial Investment = -155,000 Year 1: Cash Flow = 63,120; Net Income = 13,120 Year 2: Cash Flow = 70,800; Net Income = 20,800 Year 3: Cash Flow = 91,080; Net Income = 41,080 Salvage at the end of year 3 = 5,000 Your required return for assets of this risk is 12%. Chapter 11 Payback Example Assume we will accept the project if it pays back within two years. So would we accept this? ARR Example Assume we require an average accounting return of 20%, and projected net income for three years is $13,120 , $20,800, $41,080. The initial investment is $155,000 and the salvage value at the end of 3 years is $5,000. Should we accept the project? Average Net Income : (13,120 + 20,800 + 41,080 / 3 = 25,000 ARR = 25,000 / (155,000 - 5000) = 16.7%
Profitability Index PV of Cash Flows $ 181,186.32 Investment $ 155,000.00 PI 1.17 Internal Rate of Return The required return is 12%. TIME CF 0 $ (155,000.00) 1 $ 63,120.00 2 $ 70,800.00 3 $ 96,080.00 20.9% 20.91% Shortcoming of IRR - more than one possible answer with unconventional cash flows TIME CF NPV NP 0 $ (90,000.00) $ (90,000.00) IRR 1 $ 132,000.00 $114,782.61 2 $ 100,000.00 $75,614.37 3 $ (150,000.00) ($98,627.43) 10.11% $ 1,769.54 $ 1,769.54 NPV @ 10.11% $ (0.00) 43% NPV @ 42.66% $ 0.00 42.65847% Rate NPV 0% $ (8,000.00) Suppose an investment will cost $90,000 initially and will generate the following cash flows: Year 1: 132,000 Year 2: 100,000 Year 3: -150,000 The required return is 15%. Should we accept or reject the project? 1 2 3 4 5 6 7 8 0% 200000% 400000%
5% $ (3,158.41) 10% $ - 15% $ 1,769.54 20% $ 2,638.89 25% $ 2,800.00 30% $ 2,435.14 35% $ 1,681.15 42.65847% $ - 50% $ (2,000.00) You should accept the project if the required return is between 10.11% and 42.66%. 1 2 3 4 5 6 7 8 -1000000% -800000% -600000% -400000% -200000%
2.2194004996 $56,357.14 $56,441.33 $68,387.85 $26,186.32 If using the NPV function in Excel, must remember to net out the original cash flow (cost).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help