Question

Bitforth Co. is considering two projects, but can afford only one. They require a 15% return...

Bitforth Co. is considering two projects, but can afford only one. They require a 15% return on their investment. Show your work for each step. (15 marks) Year Project A cashflow Project B cashflow 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 Using the payback method, which project would you choose? Why? Using the NPV method, which project would you choose? Why? Using the IRR method, which project would you choose? Why? If you apply the profitability index, which project would you choose? Why? Which project should you choose? Why

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 E AutoSum Wrap Text в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Paste Sort &Find & 2 ClearFe Select Editing Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard NF323 NE Alignment Number NF NG NH NO NJ FOR B CCFAT NK NM NP FOR A PROJECTA PROJECT B CCFAT 309 310 311 312 313 314 315 316 317 318 319 ans 1 PAYBACK PERIOD 320 321 322 323 324 325 326 /4 トト MIRR NpV IRR REPLACEMENTS HPR GMAM EAC MACR LEASE RATIOCASHBUDGET acc BOND EPS EBIT C REPLACEMENT STats -NPV BETA LEVERED PV FACTOR at 15% PV OF CFAT FORA & B P*R (A) Q R(B) year 0 350000 45000 65000 65000 440000 50000 24000 22000 19500 14600 350000 -50000 305000 -26000 2400004000 175000 15500 265000 30100 1 -350000.00 -50000.00 0.8696 39130.43 20869.57 0.7561 49149.34 16635.16 0.6575 42738.56 12821.57 0.5718251571.438347.60 NPV-.-> 32589.76 8673.89 FORA 3CCFAT3/CFAT4 (ignore negative sign DECISION LOWER THE PAYBACK PERIOD, BETTER IT IS 3(175000/440000) 3.3977 YEARS SO SELECT PROJECT B FOR B 2 CCFAT2/CFAT3 2 (4000/19500) (ignore negative sign) 2.2051 YEARS erences: NI296 130% 10:13 10-01-2019File Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum Calibri ー E ゴWrap Text General aCopy в 1 프 . Ej-.

Add a comment
Know the answer?
Add Answer to:
Bitforth Co. is considering two projects, but can afford only one. They require a 15% return...
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 CF of Project A CF of Project B...

    Consider the following two mutually exclusive projects: Year CF of Project A CF of Project 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 percent return on your investment. a)If you apply the payback (PB) criterion, which investment will you choose? Why? b)If you apply the NPV criterion, which investment will you choose? Why? c)If you apply the IRR 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 –$ 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...

  • Question 2 Consider the following two mutual exclusive projects Cash flow A -600,000 170,000 180,000 205,000 270,000 Cash flowB Year 600,000 220,000 390,000 220,000 350,000 4 whichever project yo...

    Question 2 Consider the following two mutual exclusive projects Cash flow A -600,000 170,000 180,000 205,000 270,000 Cash flowB Year 600,000 220,000 390,000 220,000 350,000 4 whichever project you choose if any, would require a 6% return on your investment a) If you apply the playback criteria, which project will you choose? Why? b) If you apply the NPV payback criteria, which project will you choose? Why? c) If you apply the IRR payback criteria, which project will you choose?...

  • PLEASE SHOW ALL WORK 1.  (35 points) You are considering the following two mutually exclusiveprojects. Both projects...

    PLEASE SHOW ALL WORK 1.  (35 points) You are considering the following two mutually exclusiveprojects. Both projects will be depreciated using straight-line depreciation to a zero book value over the life of the project. Neither project has any salvage value. Year Project(A) Project (B) 0 -$30,000 -$30,000 1 13,000 5,000 2 11,000 5,000 3 9,000 5,000 4 7,000 5,000 5 0 5,000 6 7 8 9 10 0 0 0 0 0 5,000 5,000 5,000 5,000 5,000                      The required rate...

  • 2. A company has the following mutually exlcusive projects to choose from: Year Cash Flow A Cash Flow B -55.000 -24...

    2. A company has the following mutually exlcusive projects to choose from: Year Cash Flow A Cash Flow B -55.000 -24,000 12.800 11,700 23.100 11.100 27.700 12,600 46,400 5,900 The required return is 14%. a. Using payback, which project will you choose? b. Using NPV, which project will you choose? c. Using IRR, which project will you choose? d. Using profitability index, which project will you choose? e. Based on all the previous answers, which project will you choose?

  • 6. Comparing Investment Criteria: Consider the following two mutually exclusive projects Year Cash Flow (A)Cash Flow...

    6. Comparing Investment Criteria: Consider the following two mutually exclusive projects Year Cash Flow (A)Cash Flow (B) 0 $40,000 60,000 1 19,000 2 25,000 3 18,000 4 6,000 270,000 14,000 17,000 24,000 Whichever project you choose, if any, you require a 15 percent return on your investment. a. If you apply the payback criterion, which investment will you choose? Why? b. If you apply the discounted payback criterion, which investment will you ch oose? Why? c. If you apply the...

  • by hand #1 Questions a) to c) refer to two projects with the following cash flows:...

    by hand #1 Questions a) to c) refer to two projects with the following cash flows: Year Project B Project A - $200 80 -$200 100 80 100 80 100 Projects A and B are mutually exclusive. a) Calculate the Payback, Discounted Payback, NPV, IRR, and Profitability Index for Projects A and B using an opportunity cost of capital of 10% (where applicable). Which of these projects is worth pursuing? Explain. b) Calculate the Payback, Discounted Payback, NPV, IRR, and...

  • The two projects below are possible investments. You require a return of 12%.

    The two projects below are possible investments. You require a return of 12%.YearProject YProject Z0-$31,000-$60,000114,00024,000212,40023,000314,80022,000410,40021,000The profitability index for project Y is____, for project Z is_____The NPV for project Y is____,for project Z is_____Based on the above calculations, project ____ should be accepted.

  • Given the following information, in which order would you choose the following projects based on the...

    Given the following information, in which order would you choose the following projects based on the profitability index? Project A (NPV of cash flows: $190,000, Investment Cost: $50,000) Project B (NPV of cash flows: $200,000, Investment Cost: $70,000) Project C (NPV of cash flows: $440,000, Investment Cost: $110,000) Project B, Project C then Project A Project C, Project B then Project A Project A, Project C then Project B Project A, Project B then Project C Project C, Project A...

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