Question

3. Consider the information in Table 2. Sports Bulletin Plc. is considering investing in two projects, A and B. The initial outlay and annual cash flows are shown in Table 2. Straight-line depreciation method is used. The minimum accounting rate of return is 15%. The discount rate is 10%, and the depreciation rate is 25%. The minimum acceptable pavback period is 3 vears. For each project, the change in net working capital is zero in each vear, Both proiects are of equal-length Table 2 Project A 450,000 Cash Flows (Inflows) 165,000 135,000 180,000 100,000 Project IB 55,000 Cash Flows (Inflows) 12,000 22,000 22,000 26,000 Initial Outlay_> Year 4 (a) Consider Table 2. Calculate project earnings for each year over the lifetime of each project (b) Consider Table 2. Calculate the net present value for each project and rank the projects (c) Consider Table 2. Calculate the accounting rate of return for each project and rank the projects (d) Consider Table 2. Calculate (approximate) the internal rate of return for each project and rank the projects (e) Consider Table 2. Calculate the payback period for each project and rank the projects (f) Assume for now that the firm can invest in a single project only. Which project would you advise the firm to invest in? Explain your answer.

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 General ta copy. в 1 프· ー· 鱼, Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Formsat Paste Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. Styles ▼ ㆆ ▼ Clipboard HE165 GV Font Alignment Number GW GX GY GZ HA HB HC HD HG 152 153 154 155 156 157 ANSWER a 158 159 160 161 162 163 164 165 166 167 168 169 170 11 1 トト | IRRmpv RATION PBP ARR external rate -MIRR NPV 1RR NOTEDepeciation (DEPRE) for project A for project B 25% x 450000 = 25% x 55000 112500 13750 EARNINGS-CASH INFLOWS-DEPRECIATION project earnings PROJECTA CASH FLOWS LESS DEPRE PROJECT B YEAR EARNINGS CASH FLOWS LESS DEPRE = EARNINGS 165000 135000 180000 100000 112500 112500 112500 112500 52500 22500 67500 -12500 130000 12000 22000 22000 26000 13750 1750 8250 3750 8250 13750 12250 27000 13750 4 TOTAL EARNINGS REPLACEMENT S HPR GMAM EAC MACRS RATIOCASHBUDGET acc BOND EPS EBIT- REPLACEMENT-STat - L erences: JF8 07:57 05-01-2019Home nert Page Layout Formulas Data Review View dd-Ins s Cut aCopy Σ AutoSum ー E ゴWrap Text в 1 프· ー· 鱼, Δ. : rーー 遑锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard HC191 GV Font Alignment Number Cells GW GX GY GZ HA HB НС HD HE HF HG 186 187 ANSWER d 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 11 1 トト | IRRmpv RATION PBP ARR external rate -MIRR NPV 1RR INTERNAL RATE OF RETURN PROJECTA CF (A) PROJECT B CF(B) YEAR 0 450000 165000 135000 180000 100000 11.62% 55000 12000 22000 22000 26000 16.12% 4 IRR = RANK REPLACEMENT S HPR GMAM EAC MACRS RATIOCASHBUDGET acc BOND EPS EBIT- REPLACEMENT-STat - L erences: JF17 07:58 05-01-2019

Add a comment
Know the answer?
Add Answer to:
3. Consider the information in Table 2. Sports Bulletin Plc. is considering investing in two projects,...
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
  • 3. Consider Table 2. Victoria Way Inc. is considering investing in Projects 1 and 2. The...

    3. Consider Table 2. Victoria Way Inc. is considering investing in Projects 1 and 2. The initial cost of Project l is €8,000 and E3,000 for Project 2. Each project lasts four years. Straight-line depreciation method is used. The minimum accounting rate of return is 10%. The discount rate is 10% for Project 1 and 20% for Project 2, and the depreciation rate is 25% for each project. NWC is "Net Working Capital". PROJECT 2 0 1,5001,5001,5001,500 16,000 16,000 16,00016,000...

  • Consider Table 1. Public Life Inc. is considering investing in projects 1 and 2. The initial...

    Consider Table 1. Public Life Inc. is considering investing in projects 1 and 2. The initial cost of project 1 is 10,000 and e3,000 for project 2. Each project lasts four years. Straight-line depreciation method is used The minimum accounting rate of return is 10%. The discount rate is 10% for both projects, and the depreciation rate is 25% for each project. 2. Table Project 1 Years Project 2 Years 2 0 2 0 Barnings Cashflows 4 60 120 180...

  • Consider Table 4. The Burren Inc. is considering investing in projects 1 and 2. The initial...

    Consider Table 4. The Burren Inc. is considering investing in projects 1 and 2. The initial cost of project 1 is €3,000 and €2,000 for project 2. Each project lasts four years. Straight-line depreciation method is used The minimum accounting rate of return is 10%. The discount rate is 10% for both projects, and the depreciation rate is 25% for each project. The minimum acceptable payback is 3 years. NWC is net working capital Table 4 Project 1 Time (in...

  • Nicholson Roofing​ Materials, Inc., is considering two mutually exclusive​ projects, each with an initial investment of...

    Nicholson Roofing​ Materials, Inc., is considering two mutually exclusive​ projects, each with an initial investment of ​$110,000. The​ company's board of directors has set a​ 4-year payback requirement and has set its cost of capital at 12​%. The cash inflows associated with the two projects are shown in the following ​table: Cash inflows ​(CFt​) Year Project A Project B 1 ​$35,000 ​$65,000 2 ​$35,000 ​$50,000 3 ​$35,000 ​$20,000 4 ​$35,000 ​$20,000 5 ​$35,000 ​$20,000 6 ​$35,000 ​$20,000 a. Calculate the...

  • All techniques, conflicting rankings - Nicholson Roofing Materials, Inc. is considering two mutually exclusive projects, each...

    All techniques, conflicting rankings - Nicholson Roofing Materials, Inc. is considering two mutually exclusive projects, each with an initial investment of $180,000. The company's board of directors has set a 4 year payback requirement and has set its cost of capital at 9%. The cash inflows associated with the two projects are shown in the following table. Capital inflows (CF) Year Project A Project B 1 $60,000 $75,000 2 $60,000 $70,000 3 $60,000 $50,000 a. calculate the payback period for...

  • QUESTION 2 (20) 2.1. Consider two projects whose cash inflows are not even. Assume that the...

    QUESTION 2 (20) 2.1. Consider two projects whose cash inflows are not even. Assume that the project costs R190 000. The net cash inflows for each year is as follows: Year Project B R30 000,00 R35 000,00 R62 000,00 R75 000,00 R100 000,00 R105 000,00 Project C R95 000,00 R85 000,00 R50 000,00 R20 000,00 REQUIRED 2.1.1 Calculate the payback period of each project and recommend which project should be selected based on the payback period. (6) 2.2. Glens Ltd...

  • All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with...

    All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of $160,000. The company's board of directors has set a 4-year payback requirement and has set its cost of capital at 10%. The cash inflows associated with the two projects are shown in the following table: 0 Data Table a. Calculate the payback period for each project. Rank the projects by payback period. b. Calculate the NPV of each project. Rank...

  • Nicholson Roofing​ Materials, Inc., is considering two mutually exclusive​ projects, each with an initial investment of...

    Nicholson Roofing​ Materials, Inc., is considering two mutually exclusive​ projects, each with an initial investment of ​$100000. The​ company's board of directors has set a​ 4-year payback requirement and has set its cost of capital at 12​%. The cash inflows associated with the two projects are shown in the following​ table: YR Project A Project B 1 30000 85000 2 30000 50000 3 30000 10000 4 30000 10000 5 30000 10000 6 30000 10000 .a. Calculate the payback period for...

  • The following table contains information about four projects in which Morales Corporation has the opportunity to...

    The following table contains information about four projects in which Morales Corporation has the opportunity to invest. This information is based on estimates that different managers have prepared about their potential project. Investment Net Present Life of Internal Rate Profitability Payback Period Accounting Rate Project Required Value Project of Return Index in Years of Return A. . . . . . $200,000 $52,350 5 22 % 1.26 2.86 20 % B. . . . . . $400,000 $72,230 6 25...

  • E12-35A (similar to) Question Help The following table contains information about four projects in which Hughes...

    E12-35A (similar to) Question Help The following table contains information about four projects in which Hughes Corporation has the opportunity to invest. This information is based on estimates that different managers have prepared about their potential project. (Click the icon to view the projects information.) Requirements 1. Rank the four projects in order of preference by using the a. net present value. b. project profitability index c. internal rate of return. d. payback period. e. accounting rate of return. 2....

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