Financial Accounting

User Generated

OhmmAwnl

Business Finance

Description

Respond to the following scenario with your thoughts, ideas, and comments. Be substantive and clear, and use research to reinforce your ideas.

Apix is considering coffee packaging as an additional diversification to its product line. Here’s information regarding the coffee packaging project:

  • Initial investment outlay of $40 million, consisting of $35 million for equipment and $5 million for net working capital (NWC) (plastic substrate and ink inventory); NWC recoverable in terminal year
  • Project and equipment life: 5 years
  • Sales: $27 million per year for five years
  • Assume gross margin of 50% (exclusive of depreciation)
  • Depreciation: Straight-line for tax purposes
  • Selling, general, and administrative expenses: 10% of sales
  • Tax rate: 35%

Assume a WACC of 10%.

Should the coffee packaging project be accepted? Why or why not? Compute the project’s IRR and NPV.

In addition, answer the following questions:

  • Do you believe that there was sufficient financial information to make a solid decision on what to do?
  • Was there further financial information that you required that was not provided to you?
  • What financial figure do you believe was the determinant to your decision and why?
  • How would you be able to apply this particular financial information to other situations?
  • Discuss risk methodologies used in capital budgeting.

Deliverable Length: 6–12 slides with 150–200 words in notes section

Unformatted Attachment Preview

Respond to the following scenario with your thoughts, ideas, and comments. Be substantive and clear, and use research to reinforce your ideas. Apix is considering coffee packaging as an additional diversification to its product line. Here’s information regarding the coffee packaging project: • • • • • • • Initial investment outlay of $40 million, consisting of $35 million for equipment and $5 million for net working capital (NWC) (plastic substrate and ink inventory); NWC recoverable in terminal year Project and equipment life: 5 years Sales: $27 million per year for five years Assume gross margin of 50% (exclusive of depreciation) Depreciation: Straight-line for tax purposes Selling, general, and administrative expenses: 10% of sales Tax rate: 35% Assume a WACC of 10%. Should the coffee packaging project be accepted? Why or why not? Compute the project’s IRR and NPV. In addition, answer the following questions: • • • • • Do you believe that there was sufficient financial information to make a solid decision on what to do? Was there further financial information that you required that was not provided to you? What financial figure do you believe was the determinant to your decision and why? How would you be able to apply this particular financial information to other situations? Discuss risk methodologies used in capital budgeting. Deliverable Length: 6–12 slides with 150–200 words in notes section
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Thank you so much

FIN 615
NPV and IRR calculations

Cost of Capital
Time/yr
Cash flow Input here (millions)
Discounted CF (millions)
NPV
PV factor

10.00%
0
1
2
-40
9.47
9.47
-40
8.61
7.83
-1.00 =cf1/((1+n)^1) =cf2/((1+n)^2)
0.909090909 0.826446281

IRR

9.08%

Year 0
Cash outflow (millions)
machine
net working capital
Sales (millions)

Year 1
0

0

27

27

13.5

13.5

2.7

2.7

7

7

3.8

3.8

Tax(millions)

1.33

1.33

Net Income after Tax

2.47

2.47

CF (NI after tax + depreciation)

9.47

9.47

GM (millions)
SG&A (millions)
Depreciation (millions)
EBIT (millions)

40
35
5

Year 2

3
4
5
9.47
9.47
14.47
7.11
6.47
8.98
=cf3/((1+n)^3) =cf4/((1+n)^4) =cf5/((1+n)^5)
0.751314801 0.683013455 0.620921323

Year 3

Year 4

Year 5

0

0

0

27

27

27

13.5

13.5...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags