/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q18BP The Pan American Bottling Co. is... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

The Pan American Bottling Co. is considering the purchase of a new machine that would increase the speed of bottling and save money. The net cost of this machine is \(60,000. The annual cash flows have the following projections:

Year

Cashflow

1

\)23,000

2

26,000

3

29,000

4

15,000

5

8,000

a. If the cost of capital is 13 percent, what is the net present value of selecting a new machine?

b. What is the internal rate of return?

c. Should the project be accepted? Why?

Short Answer

Expert verified

Answer

  1. Net present value is$14,353.

  2. Internal rate of return:25.77%.

  3. The company must accept the project.

Step by step solution

01

Definition of Capital Budgeting

Capital budgeting can be defined as the process by which the investors assess the different available investment options. It includes methods such as the payback method, Net present value, and IRR.

02

Net present value

Year

Cash inflows

PVIF @13%

Present value

1

$23,000

0.8849

$20,353

2

26,000

0.7831

20,361

3

29,000

0.6930

20,097

4

15,000

0.6133

9,200

5

8,000

0.5427

4,342

Total present value of cash inflows
$74,353
Less: Initial investment
(60,000)
Net present value
$14,353
03

Internal rate of return


Averageofinflows=TotalofcashflowseachyearNumberofyears=$23,000+$26,000+$29,000+$15,000+$8,0005=$20,200

Calculation of PVIFA:

PVIFA=InitialinvestmentAveragecashflow=$60,000$20,200=$2,97

For n=5, we will find 2.97 falls, around 20% or 25%.

Calculation of present value under each percent of estimated IRR:

20%:

Year

Cash flow

PVIF @ 20%

Present value

1

$23,000

0.833

$19,159

2

26,000

0.694

$18,044

3

29,000

0.579

16,791

4

15,000

0.482

$7,230

5

8,000

0.402

$3,216




$64,440

25%:

Year

Cash flow

PVIF @ 25%

Present value

1

$23,000

0.8

$18,400

2

26,000

0.64

$16,640

3

29,000

0.512

$14,848

4

15,000

0.410

$6,150

5

8,000

0.328

$2,624




$58,662

The net present value is below the initial investment; the IRR will be around 20% to 25%. Now, we will interpolate:

Particular

Amount $

Present value of 20%

$64,440

Less: Present value of 25%

(58,662)


$5,778

Particular

Amount $

Present value of 20%

$64,440

Less: initial investment

(60,000)


$4,440

Calculation of IRR:

IRR=25%+$4,440$5,778=25%+0.77%=25.77%

04

Investment decision

The business entity must accept the project because the net present value calculation is positive, and the IRR is higher than the project’s cost of capital.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Keller Construction is considering two new investments. Project E calls for the purchase of earthmoving equipment. Project H represents an investment in a hydraulic lift. Keller wishes to use a net present value profile in comparing the projects. The investment and cash flow patterns are as follows:

Project E (\(20,000 Investment)

Year

Cash flows

1

\)5,000

2

6,000

3

7,000

4

10,000

Project H (\(20,000 Investment)

Year

Cash flows

1

\)16,000

2

5,000

3

4,000

  1. Determine the net present value of the projects based on a zero percent discount rate.

  2. Determine the net present value of the projects based on a 9 percent discount rate.

  3. The internal rate of return on Project E is 13.25 percent, and the internal rate of return on Project H is 16.30 percent. Graph a net present value profile for the two investments similar to Figure12-3. (Use a scale up to \(8,000 on the vertical axis, with \)2,000 increments. Use a scale up to 20 percent on the horizontal axis, with 5 percent increments.)

  4. If the two projects are not mutually exclusive, what would your acceptance or rejection decision be if the cost of capital (discount rate) is 8 percent? (Use the net present value profile for your decision; no actual numbers are necessary.)

  5. If the two projects are mutually exclusive (the selection of one precludes the selection of the other), what would be your decision if the cost of capital is (1) 6 percent, (2) 13 percent, (3) 18 percent? Once again, use the net present value profile for your answer.

Question: You wish to retire in 14 years, at which time you want to have accumulated enough money to receive an annual annuity of \(17,000 for 19 years after retirement. During the period before retirement you can earn 8 percent annually, while after retirement you can earn 10 percent on your money. What annual contributions to the retirement fund will allow you to receive the \)17,000 annuity?

Assume a \(90,000 investment and the following cash flows for two alternatives:

Year

Investment A

Investment B

1

\)25,000

\(40,000

2

30,000

40,000

3

25,000

28,000

4

19,000

--

5

25,000

--

a. Calculate the payback for investments A and B.

b. If the inflow in the fifth year for Investment A was \)25,000,000 instead of $25,000, would your answer change under the payback method?

Question: As stated in the chapter, annuity payments are assumed to come at the end of each payment period (termed an ordinary annuity). However, an exception occurs when the annuity payments come at the beginning of each period (termed an annuity due). To find the present value of an annuity due, the annuity formula must be adjusted as to the following: PVAD 5 A 3 ( 12 1 ________ (11i) n 21 ___________ i 11) The Capital Budgeting Process blo7716x_ch09_255-294.indd 284. Likewise, the formula for the future value of an annuity due requires a modification: FVAD 5 A 3 ( (11i) n11 21 ___________ i 21). What is the future value of a 15-year annuity of $1,800 per period where payments come at the beginning of each period? The interest rate is 12 percent.

Question: Beverly Hills started a paper route on January 1. Every three months, she deposits $550 in her bank account, which earns 8 percent annually but is compounded quarterly. Four years later, she used the entire balance in her bank account to invest in an investment at 7 percent annually. How much will she have after three more years?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.