Chap 9 #1
Chapter 9 - Assignment 1.4
Problem 1: Calculating Payback 5 Points
Siva, Inc., imposes a payback cutoff of three years for its international investment projects. The company has two international projects with the following projected cash flows:
Year Cash Flow (A) Cash Flow (B)
0 $ (52,000) $ (55,000)
1 $ 17,000 $ 14,000
2 $ 19,000 $ 16,000
3 $ 17,000 $ 22,000
4 $ 11,000 $ 285,000
a) What is the precise payback period (in decimal form) for these two projects? XXXXXXXXXXb) Using payback period rules, should it accept either of them?
Create your Original Solution Below - Be sure to show all calculations and clearly indicate answers.
Project A:
Year Cash Flow Commulative Cash Flow
0 -52,000 -52,000
1 17000 -35,000
2 19000 -16,000
3 17000 1,000
4 11000 12,000
PayBack Period 2.94
Project B:
Year Cash Flow Commulative Cash Flow
0 -55,000 -55,000
1 14000 -41,000
2 16000 -25,000
3 22000 -3,000
4 285000 282,000
PayBack Period 3.0105 years
Question 2:
Project A has the lower payback period
This is the Student Template, provided in the course materials by D. Kendall April 2020
Chap 9 #2
Chapter 9 - Assignment 1.4
Problem 2: Calculating Discounted Payback 5 Points
An investment project has annual cash inflows of $3,700, $4,800, $6,300, and $5,400, for the next four years, respectively. The discount rate is 12 percent.
a) What is the discounted payback period if the initial cost is $6,200? XXXXXXXXXXb) What is the discounted payback period if the initial cost is $9,600? XXXXXXXXXXc) What is the discounted payback period if the initial cost is $11,800?
Use the Template Provided Below to Create Your Solution - Pay close attention to the formulas and formatting of the inputs.
Input area:
Annual cash inflows:
Year 1
Year 2
Year 3
Year 4
Discount rate
Initial cost
Initial cost
Initial cost
Output area:
.
Discounted payments:
Year 1 $ - 0
Year 2 $ - 0
Year 3 $ - 0
Year 4 $ - 0
Payback period - 0
Payback period - 0
Payback period - 0
This is the Student Template, provided in the course materials by D. Kendall April 2020
Chap 9 #3
Chapter 9 - Assignment 1.4
Problem 3: Calculating AAR 5 Points
You're trying to determine whether to expand your business by building a new manufacturing line. The automated assembly line has an installation cost of $25 million, which will be depreciated straight-line to zero over its five-year life. The line has projected net income of $1,754,000, $1,820,500, $1,716,300, $1,352,000, and $1,097,400 over these five years.
a) What is the project's average accounting return (AAR)? XXXXXXXXXXb) If the company's required return is 15%, should it pursue the project?
Use the Template Provided Below to Create Your Solution - Pay close attention to the formulas and formatting of the inputs.
Input area:
Installation cost ($) $ 25,000,000
# of years 5
Projected net income ($):
Year 0 $ 1,754,000
Year 1 $ 1,820,500
Year 2 $ 1,716,300
Year 3 $ 1,352,000
Year 4 $ 1,097,400
Acceptance Criteria (%) 15%
.
Output area:
.
Average net income $1,548,040
Average book value $10,000,000
AAR 15.48%
Decision Accept
This is the Student Template, provided in the course materials by D. Kendall April 2020
Chap 9 #4
Chapter 9 - Assignment 1.4
Problem 4: Calculating IRR 5 Points
A firm evaluates all of its projects by applying the IRR rule. The firm's required rate of return for its projects is 15 percent. A proposed project is expected to have the following cash flows:
Year Cash Flow
0 $ (250,000)
1 $ 85,000
2 $ 130,000
3 $ 110,000
a) What is the IRR for this project? XXXXXXXXXXb) Should the firm accept this project?
Use the Template Provided Below to Create Your Solution - Pay close attention to the formulas and formatting of the inputs.
Input area:
Required Return 15%
Annual cash flows:
Year 0 $ (250,000)
Year 1 $ 85,000
Year 2 $ 130,000
Year 3 $ 110,000
.
Output area:
.
IRR 13.73%
Accept/Reject Reject
This is the Student Template, provided in the course materials by D. Kendall April 2020
Chap 9 #5
Chapter 9 - Assignment 1.4
Problem 5: Calculating NPV 5 Points
A firm evaluates all of its projects by applying the NPV decision rule. A proposed project is expected to have the following cash flows:
Year Cash Flow
0 $ (250,000)
1 $ 85,000
2 $ 130,000
3 $ 110,000
a) At a required return of 12 percent, what is the project's NPV? Should the firm accept this project? XXXXXXXXXXb) At a required return of 18 percent, what is the project's NPV? Should the firm accept this project?
Create your Original Solution Below - Be sure to show all calculations and clearly indicate answers.
Required Return 15% Required Return 18%
Annual cash flows: Annual cash flows:
Year 0 $ (250,000) Year 0 $ (250,000)
Year 1 $ 85,000 Year 1 $ 85,000
Year 2 $ 130,000 Year 2 $ 130,000
Year 3 $ 110,000 Year 3 $ 110,000
. .
Output area:
. .
IRR 13.73% IRR 13.73%
Accept/Reject Reject Accept/Reject Reject
This is the Student Template, provided in the course materials by D. Kendall April 2020
Chap 9 #6
Chapter 9 - Assignment 1.4
Problem 6: Problems with Profitability Index 10 Points
The Sloan Corporation is trying to choose between the following two mutually-exclusive design projects:
Year Cash Flow (A) Cash Flow (B)
0 $ (76,500) $ (21,600)
1 $ 37,200 $ 11,700
2 $ 37,200 $ 11,700
3 $ 37,200 $ 11,700
a) Calculate the profitability index for both projects if the required return is 12 percent. Based on the profitability index decision rule, which project should the firm accept? XXXXXXXXXXb) Calculate the NPV for both projects if the required return is 12 percent. Based on the NPV decision rule, which project should the firm accept? XXXXXXXXXXc) Explain why your answers for (a) and (b) are different?
Create your Original Solution Below - Be sure to show all calculations and clearly indicate answers.
This is the Student Template, provided in the course materials by D. Kendall April 2020
Chap 10 #1
Chapter 10 - Assignment 1.4
Problem 1: Calculating Depreciation 5 Points
A piece of newly-purchased industrial equipment costs $1,240,000 and is classified as seven-year property under MACRS. Depreciation on this equipment will impact the company's taxes, and will therefore be a significant factor in determing whether the company should proceed with the purchase.
a) Calculate the annual depreciation under MACRS for all eight years depreciation is allowed. XXXXXXXXXXb) Calculate the end-of-year book values for this equipment, using MACRS, for all eight years.
Use the Template Provided Below to Create Your Solution - Pay close attention to the formulas and formatting of the inputs.
Input area:
Purchase Price ($)
*7-year property under MACRS
Output area:
.
Yr. Beginning Book Value MACRS Depreciation Ending Book value
1 $ 1,240,000.00 0.1429 $ 177,196.00 $ 1,062,804.00
2 1,062,804.00 0.2449 303,676.00 759,128.00
3 759,128.00 0.1749 216,876.00 542,252.00
4 542,252.00 0.1249 154,876.00 387,376.00
5 387,376.00 0.0893 110,732.00 276,644.00
6 276,644.00 0.0892 110,608.00 166,036.00
7 166,036.00 0.0893 110,732.00 55,304.00
8 55,304.00 0.0446 55,304.00 - 0
This is the Student Template, provided in the course materials by D. Kendall April 2020
Chap 10 #2
Chapter 10 - Assignment 1.4
Problem 2: Calculating Project OCF 10 Points
Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million. The fixed asset will be depreciated straight-line to zero over its three-year life, after which time it will be worthless (zero salvage value). The project is estimated to generate $2,190,000 in annual sales, with costs of $815,000. The applicable tax rate is 35 percent, and the required rate of return on the project is 12 percent.
a) What is the Operating Cash Flow (OCF) for this project?