Juhayna Food Industries is attempting to select the best of three mutually exclusive projects. The initial investment and after-tax cash inflows associated with these projects are shown in the following table. Cash flow Project A Project B Project C Initial Investment 100000 120,000 130,000 Year 1 Cash Inflows  30000 36,500 38000 Year 2 cash inflows 35000 45000 20000 Year 3 cash inflows 40000 40000 42000 Year 4 cash inflows 38000 35000 45000 Year 5 cash inflows 20000 30000 50000   Taking into consideration that the cost of debt 7% , cost of preferred stock 12% and cost of new common stock 15%. The weight of each source of capital are long term debt 30% , preferred stock 20% and common stock equity 50%.   TO dO Create a spreadsheet to answer the following questions: Calculate the firm‘s cost of capital ( WACC) Calculate the payback period for each project. Calculate the net present value (NPV) of each project, Calculate the internal rate of return (IRR) for each project. Discuss any conflict in ranking that may exist between NPV and IRR. Summarize the preferences dictated by each measure, and indicate which project you would recommend. Explain why

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%

Question 3:

Juhayna Food Industries is attempting to select the best of three mutually exclusive projects.

The initial investment and after-tax cash inflows associated with these projects are shown in the following table.

Cash flow

Project A

Project B

Project C

Initial Investment

100000

120,000

130,000

Year 1 Cash Inflows 

30000

36,500

38000

Year 2 cash inflows

35000

45000

20000

Year 3 cash inflows

40000

40000

42000

Year 4 cash inflows

38000

35000

45000

Year 5 cash inflows

20000

30000

50000

  Taking into consideration that the cost of debt 7% , cost of preferred stock 12% and cost of new common stock 15%. The weight of each source of capital are long term debt 30% , preferred stock 20% and common stock equity 50%.

 

TO dO

Create a spreadsheet to answer the following questions:

  1. Calculate the firm‘s cost of capital ( WACC)
  2. Calculate the payback period for each project.
  3. Calculate the net present value (NPV) of each project,
  4. Calculate the internal rate of return (IRR) for each project.
  5. Discuss any conflict in ranking that may exist between NPV and IRR.
  6. Summarize the preferences dictated by each measure, and indicate which project you would recommend. Explain why

 

 

T 93.pdf - Adobe Reader
File Edit View Window Help
Open
125%
Tools
F& Sign
Comment
Sign in
- Export POF
Question 3:
Adobe ExportPDF
Convent POF filei to Word or Excel
anline
Juhayna Food Industries is attempting to select the best of three mutually exclusive projects.
Selet POF File
t alod
The initial investment and after-tax cash inflows associated with these projects are shown in the
following table.
1e/250 KS
Convert Ta:
Microsoft Word ("doo)
Cash flow
Project A
100000
| Project B
120.000
Project C
130.000
Initial Investment
Recognice lest in Englahu.s)
Change
Year 1 Cash Inflows 30000
Year 2 cash inflows 35000
Year 3 cash inflows 40000
Year 4 cash inflows 38000
Year 5 cash inflows 20000
Taking into consideration that the cost of debt 7%, cost of preferred stock 12% and cost of new
common stock 15%. The weight of each source of capital are long tem debt 30% . prefered
stock 20% and common stock equity 50%.
36.500
45000
38000
20000
42000
Convert
40000
35000
45000
• Create PDF
30000
50000
ト Edit PDF.
• Combine PDF
Send Files
• Store Files
TO do
Create a spreadsheet to answer the following questions:
a) Calculate the fim's cost of capital ( WACC)
b) Calculate the payback period for each project.
c) Calculate the net present value (NPV) of each project,
d) Calculate the internal rate of retum (IRR) for each project.
e) Discuss any conflict in ranking that may exist between NPV and IRR.
) Summarize the preferences dictated by each measure, and indicate which project you
would recommend. Explain why
A6XG A 00 O ENG 1250 AM
Transcribed Image Text:T 93.pdf - Adobe Reader File Edit View Window Help Open 125% Tools F& Sign Comment Sign in - Export POF Question 3: Adobe ExportPDF Convent POF filei to Word or Excel anline Juhayna Food Industries is attempting to select the best of three mutually exclusive projects. Selet POF File t alod The initial investment and after-tax cash inflows associated with these projects are shown in the following table. 1e/250 KS Convert Ta: Microsoft Word ("doo) Cash flow Project A 100000 | Project B 120.000 Project C 130.000 Initial Investment Recognice lest in Englahu.s) Change Year 1 Cash Inflows 30000 Year 2 cash inflows 35000 Year 3 cash inflows 40000 Year 4 cash inflows 38000 Year 5 cash inflows 20000 Taking into consideration that the cost of debt 7%, cost of preferred stock 12% and cost of new common stock 15%. The weight of each source of capital are long tem debt 30% . prefered stock 20% and common stock equity 50%. 36.500 45000 38000 20000 42000 Convert 40000 35000 45000 • Create PDF 30000 50000 ト Edit PDF. • Combine PDF Send Files • Store Files TO do Create a spreadsheet to answer the following questions: a) Calculate the fim's cost of capital ( WACC) b) Calculate the payback period for each project. c) Calculate the net present value (NPV) of each project, d) Calculate the internal rate of retum (IRR) for each project. e) Discuss any conflict in ranking that may exist between NPV and IRR. ) Summarize the preferences dictated by each measure, and indicate which project you would recommend. Explain why A6XG A 00 O ENG 1250 AM
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education