Question

1. Which of the following methods of project analysis are most commonly used by CFO's? internal...

1.
Which of the following methods of project analysis are most commonly used by CFO's?
internal rate of return and net present value
discounted payback and net present value
net present value and payback
internal rate of return and payback

2.  

Consider the following two mutually exclusive projects:

  

Year Cash Flow
(A)
Cash Flow
(B)
0 –$ 341,000 –$ 51,000
1 54,000 24,900
2 74,000 22,900
3 74,000 20,400
4 449,000 15,500

  

Whichever project you choose, if any, you require a 15 percent return on your investment.

  

a-1

What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

  

Payback period
  Project A years  
  Project B years  

  

a-2 If you apply the payback criterion, which investment will you choose?
Project A
Project B

  

b-1

What is the discounted payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

  

Discounted payback period
  Project A years  
  Project B years  

  

b-2 If you apply the discounted payback criterion, which investment will you choose?
Project A
Project B

  

c-1

What is the NPV for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

  

NPV
  Project A $   
  Project B $   

  

c-2 If you apply the NPV criterion, which investment will you choose?
Project A
Project B

  

d-1

What is the IRR for each project? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

  

IRR
  Project A %  
  Project B %  

  

d-2 If you apply the IRR criterion, which investment will you choose?
Project A
Project B

  

e-1

What is the profitability index for each project? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.)

  

Profitability index
  Project A     
  Project B     

  

e-2 If you apply the profitability index criterion, which investment will you choose?
Project A
Project B
f. Based on your answers in (a) through (e), which project will you finally choose?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text aCopy в 1 프· ー· 鱼, Δ. :r-ㄧ 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Formsat Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard DA150 CW Alignment Number Cells Edting CX CY cZ DA DB DC DE DF DG DH DI DJ 132 133 134 135 136 137 138 139 140 141 142 a-1 143 144 145 146 147 148 NOTE: IGNORE NEGATIVE SIGN IN CALCULATION OF CCFAT 149 150 a-2 I < , H | IRRnpv | RATION PBP ARR. external rate . MIRR NpV IRR REPLACEMENT S / HPR GMAM YEAR CFATA CFAT B CUMULATIVE CFAT 0 -341000 1 54000 2 74000 3 74000 4 449000 1000 341000 24900 -287000 22900-213000 20400139000 15500 310000 51000 26100 3200 17200 32700 PAYBACK PERIOD (A) 3 CCFAT 3/CFAT4 3(139000/449000) 3.31 YEARS PAYBACK PERIOD (B) 2 CCFAT 2/CFAT3 2 (3200/20400) 2.16 YEARS SELECT PROJECT B , EAC MACRS RATIOCASHBUDGET wacc BOND EPS EBIT REPLACEMENT STats erences: JF17 05:53 11-01-2019Home nert Page Layout Formulas Data Review View dd-Ins as Cut Σ AutoSum ー E ゴWrap Text Copy в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard DA151 CW Alignment Number Cells Edting CX CY cZ DA DB DC DE DF DG DH DI DJ 151 152 153 154 155 156 157 158 159 160 161 b-1 162 163 164 165 166 167 b-2 168 169 (4 トト1 | IRRnpv | RATION PBP ARR. external rate YEAR CFATA CFAT B PV FACTOR PRESENT VALUE OF CFAT AT 15% CUMULATIVE DISCOUNTED CFAT 0 -341000 1 54000 2 74000 3 74000 4 449000 51000 24900 22900 20400 55000.5718 256717.2:1 1000-34100051000 0.8696 46956.52 21652.17 -294043.48-29347.83 0.756155954.63 17315.69 -238088.85-12032.14 0.6575 48656.20 13413.33-189432.65 1381.20 8862.1867284.56 10243.37 341000 DISCOUNTED PAYBACK PERIOD (A) 3 +CCFAT 3/CFAT4 3 (189432.65/256717.21) 3.74 YEARS 2 CCFAT 2/CFAT3 2 (12032.14/13413.33) DISCOUNTED PAYBACK PERIOD (B) 2.90 YEARS SELECT PROJECT B . MIRR NpV IRR REPLACEMENT S / HPR GMAM , EAC MACRS RATIOCASHBUDGET wacc BOND EPS EBIT REPLACEMENT STats erences: JF17 05:58 11-01-2019Home nert Page Layout Formulas Data Review View dd-Ins as Cut aCopy E AutoSum Wrap Text в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard DE169 CW Alignment Number Cells Edting CX CY cZ DA DB DC DE DF DG DH DI DJ 169 170 YEAR CFATA CFAT B PV FACTOR PRESENT VALUE OF CFAT AT 15% 172 173 174 175 176 0 -341000 1 54000 2 74000 3 74000 4 449000 51000 24900 22900 20400 55000.5718 256717.2:1 51000 0.8696 46956.52 21652.17 0.756155954.63 17315.69 0.6575 48656.20 13413.33 8862.18 67284.56 10243.37 341000 178 179 180 c-1 181 182 c-2 183 184 d-1 185 186 187 d-2 (4 , 커 | IRRnpv | RATION PBP ARR. external rate NPV = NPV FOR A 67284.56 NPV FOR B 10243.37 SELECT PROJECTA IRR FOR A FOR B 21.60% IRR(CY173:CY177) 25.44% IRR(C2173:C2177) SELECT PROJECT B . MIRR NpV IRR REPLACEMENT S / HPR GMAM , EAC MACRS RATIOCASHBUDGET wacc BOND EPS EBIT REPLACEMENT STats erences: JF8 11-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy. ,_a. ars-函Merge & Center, $, % , 弼,8 C Paste B 1 u. Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard CX198 CW Alignment Number Cells Edting CX CY cZ DA DB DC DE DF DG DH DI DJ 183 184 d-1 185 186 187 d-2 188 189 e-1 190 191 192 e-2 193 194 f 195 196 197 198 199 200 201 (4 トト1 | IRRnpv | RATION PBP ARR. external rate IRR FOR A FOR B 21.60% IRR(CY173:CY177) 25.44% IRR(C2173:C2177) SELECT PROJECT B FOR A FOR B 1.197 (1 NPV/INVESTMENT) 1.201 SELECT PROJECT B NPV IS THE BEST METHOD AS IT MEASURES HOW MUCH WEALTH IS CREATED BY SHAREHOLDERS . MIRR NpV IRR REPLACEMENT S / HPR GMAM , EAC MACRS RATIOCASHBUDGET wacc BOND EPS EBIT REPLACEMENT STats erences: JF8 06:06 11-01-2019

Add a comment
Know the answer?
Add Answer to:
1. Which of the following methods of project analysis are most commonly used by CFO's? internal...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$...

    Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$ 344,000 –$ 49,000 1 51,000 24,600 2 71,000 22,600 3 71,000 20,100 4 446,000 15,200 Whichever project you choose, if any, you require a 15 percent return on your investment. a-1 What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Payback period Project A years Project B years a-2 If...

  • Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...

    Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$ 354,000 –$ 48,000 1 41,000 23,600 2 61,000 21,600 3 61,000 19,100 4 436,000 14,200    Whichever project you choose, if any, you require a return of 14 percent on your investment.    a-1 What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)       a-2 If you apply...

  • Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...

    Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$ 340,000 –$ 51,500 1 55,000 25,000 2 75,000 23,000 3 75,000 20,500 4 450,000 15,600    Whichever project you choose, if any, you require a 16 percent return on your investment.    a-1 What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)    Payback period   Project A years     Project...

  • 11 Consider the following two mutually exclusive projects: Cash Flow Cash Flow Year (A) (B) 3342,000...

    11 Consider the following two mutually exclusive projects: Cash Flow Cash Flow Year (A) (B) 3342,000 250,500 53,000 24,800 73,000 22,800 73,000 20,300 448,000 15,400 AWNO Book Hint Print Whichever project you choose, if any, you require a return of 14 percent on your investment erences a-1 What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Project A Project B انمي | N| 22 a-2 If...

  • please help showcase the step by step calculations needed for solving this problem. thank you! :)...

    please help showcase the step by step calculations needed for solving this problem. thank you! :) Consider the following two mutually exclusive projects: Year Cash Flow (A) ONM $346,000 49,000 69,000 69,000 444,000 Cash Flow (B) $48,000 24,400 22,400 19,900 15,000 Whichever project you choose, if any, you require a return of 16 percent on your investment 0-1 What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g.,...

  • Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$...

    Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$ 350,000 –$ 50,000 1 45,000 24,000 2 65,000 22,000 3 65,000 19,500 4 440,000 14,600 Whichever project you choose, if any, you require a 15% return on your investment. a-1. What is the payback period for each project? (Round the final answers to 2 decimal places.) Payback Period Project A years Project B years a-2. If you apply the payback criterion, which investment will...

  • Consider the following two mutually exclusive projects: Cash Flow Year 0 Cash Flow (B) - $...

    Consider the following two mutually exclusive projects: Cash Flow Year 0 Cash Flow (B) - $ 50,000 24,000 22,000 19,500 14, 600 - $ 350,000 45,000 65,000 65,000 440,000 AM + Whichever project you choose, if any, you require a 15% return on your investment. a-1. What is the payback period for each project? (Round the final answers to 2 decimal places.) Payback Period Project A Project B years years a-2. If you apply the payback criterion, which investment will...

  • Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...

    Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$ 360,000 –$ 45,000 1 35,000 23,000 2 55,000 21,000 3 55,000 18,500 4 430,000 13,600    Whichever project you choose, if any, you require a return of 14 percent on your investment. c-1 What is the NPV for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)       c-2 If you apply the NPV...

  • Consider the following two mutually exclusive projects: 6.66 points WNO Cash Flow (A) 354,000 41,000 61,000...

    Consider the following two mutually exclusive projects: 6.66 points WNO Cash Flow (A) 354,000 41,000 61,000 61,000 436,000 Cash Flow (B) 348,000 23,600 21,600 19,100 14,200 eBook Hint Print Whichever project you choose, if any, you require a return of 14 percent on your Investment References a-1 What is the payback period for each project? (Do not round Intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) years Project A Project B years We were unable to...

  • stocks

    Consider the following two mutually exclusive projects: YearCash Flow (A)Cash Flow (B)0–$420,000–$71,000172,00031,000292,00029,000372,00026,5004447,00021,600 Whichever project you choose, if any, you require a 15% return on your investment. a-1. What is the payback period for each project? (Round the final answers to 2 decimal places.) Payback PeriodProject A3.41  Numeric Response 1.Edit Unavailable. 3.41 correct.yearsProject B2.42  Numeric Response 2.Edit Unavailable. 2.42 correct.years a-2. If you apply the payback criterion, which investment will you choose? multiple choice 1Project AProject B Correct b-1. What is the discounted payback period for each project? (Do not round intermediate calculations. Round the final answers to 2 decimal places.) Discounted Payback PeriodProject...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT