Unit 5 IP
pptx
keyboard_arrow_up
School
Colorado Technical University *
*We aren’t endorsed by this school
Course
615
Subject
Finance
Date
Jan 9, 2024
Type
pptx
Pages
10
Uploaded by ConstableLightningWalrus4
Slide 1
Colorado Technical University
Unit 5 Individual Project
Applied Managerial Finance FINC615
Kevin Hemstreet
July 13, 2023
OUR BIG IDEA
Apex’s
Diversification
to
their
product lines
mission is to become a
recognized
leader
for
providing
an
outstanding selection of premium coffee
packaging.
Slide 2
3
Your Coffee Shop
Lets Talk Numbers
Slide 3
•
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 the terminal year
•
Project and equipment life: 5 years
•
Sales: $27 million per year for five years
•
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%.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4
Your Coffee Shop
The Questions
Slide 4
Should the Coffee Packaging
Project be Accepted?
The Project’s IRR and NPV
Cost of Capital
10.00%
Time/yr
0
1
2
3
4
5
Cash flow Input here
-40000000
9470000
9470000
9470000
9470000
14470000
Discounted CF
-40000000
8609090.909
7826446.281
7114951.165
6468137.422
8984731.545
NPV
-996642.678
=cf1/((1+n)^1)
=cf2/((1+n)^2)
=cf3/((1+n)^3)
=cf4/((1+n)^4)
=cf5/((1+n)^5)
PV factor
0.909090909
0.826446281
0.751314801
0.683013455
0.620921323
IRR
9.08%
NPV is -996642.68
IRR is 9.08%
Sufficient Information?
Only the basic
evaluation can be done
Market analysis could
help the decision-
making process
Risk assessment
Slide 5
Further Financial Information
Cash Flow Timing
Salvage Value
Inflation Rate
Slide 6
Risk Assessment
Detailed Cost
Breakdown
Market Research and Demand Analysis
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
7
Your Coffee Shop
The Determinant of the
Decision
Slide 7
•
The Net Present Value (NPV)
•
Which was calculated at approximately -
$996,642.68
•
The negative NPV indicates the project may not
be financially attractive.
8
Your Coffee Shop
Applying This Particular Financial
Information to Other Things
Slide 8
•
Comparative Analysis
•
Risk Assessment
•
Performance Evaluation
9
Your Coffee Shop
Risk Methodologies
Slide 9
•
Sensitivity Analysis
•
Scenario Analysis
•
Monte Carlo Simulation
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
10
Your Coffee Shop
References
Slide 10
•
Bogataj, D., & Bogataj, M. (2019).
NPV approach to material requirements planning theory - a 50-year review of these
research achievements
Taylor & Francis. doi:10.1080/00207543.2018.1524167
•
Boyle, G. W., & Guthrie, G. A. (2003).
Cash flow immediacy and the value of investment timing
College of Business
Administration, Texas Tech University. doi:10.1111/1475-6803.00074
•
Espinoza, D., & Morris, J. W. F. (2013).
Decoupled NPV: A simple, improved method to value infrastructure
investments
E. & F.N. Spon. doi:10.1080/01446193.2013.800946
•
Mubashar, A., & Yasir, B. T. (2019). Capital budgeting decision-making practices: evidence from Pakistan. [Capital
budgeting decision-making practices]
Journal of Advances in Management Research, 16
(2), 142-167.
https://doi.org/10.1108/JAMR-07-2018-0055
Related Documents
Related Questions
Question content area top
Part 1
New Process
Corporation is a rapidly growing biotech company that has a required rate of return of
8%.
It plans to build a new facility in Santa Clara County. The building will take 2 years to complete. The building contractor offered
New Process
•
Plan I: Payment of
$225,000
at the time of signing the contract and
$4,675,000
upon completion of the building. The end of the second year is the completion date.
•
Plan II: Payment of
$1,675,000
at the time of signing the contract and
$1,675,000
at the end of each of the two succeeding years.
•
Plan III: Payment of
$375,000
at the time of signing the contract and
$1,550,000
at the end of each of the three succeeding years.
Requirement 1. Using the net present value method, calculate the comparative cost of each of the three payment plans
a choice of three payment plans, as follows:
arrow_forward
A
B
C
E
F
G
H
J
K
1 Function: FV, Rate; Cell referencing
2
3 Problem 10.22 - Modified Internal Rate of Return (MIRR)
4
PROBLEM
5 Morningside Bakeries recently purchased equipment at a cost of
6 $650,000. Management expects the equipment to generate cash flows of
7 $275,000 in each of the next four years. The cost of capital is 14 percent.
Student Work Area
Required: Provide input into cells shaded in gray in this template.
Use the FV function with cell references to the Problem area in order to calculate
the terminal value of cash flows. Use the Rate function with cell references to the
Problem area and Student Work area to calculate the MIRR. Do not leave any
portion of the formula for the functions blank - use 0's when necessary. Be sure to
represent cash inflows as positive values.
8
9
PV of Costs
10
Length of Project
11
Cost of Capital
12
Annual Cash Flows
13
14
15
16
17
18
19
$ 650,000.00
4 years
14%
$275,000.00
What is the terminal cash flow for this project?
Terminal cash flow…
arrow_forward
Dog
arrow_forward
PI
A manager at Shannon's Custom Cabinets is interested in purchasing a computer, software, and peripheral equipment costing $240,000 that would allow company salespeople to demonstrate to custor
finished carpet installation would appear. Using this cost, the manager has determined that the investments net present value is $126.000, Compute the investment's profitability index
Note: Round your answer to one decimal point de round 4.555 to 4.63
0
arrow_forward
Required information
Learning Objective 11-04 Calculate the periodic amortization of an
intangible asset.
(The following information applies to the questions displayed below.]
The allocation process for intangible assets is called amortization. For an
intangible asset with a finite useful life, the capitalized cost less any estimated
residual value must be allocated to periods in which the asset is expected to
contribute to the company's revenue-generating activities. An intangible asset
that is determined to have an indefinite useful life is not subject to periodic
amortization. Goodwill is perhaps the most typical intangible asset with an
indefinite useful life.
Software development
arrow_forward
Q. 1
purchase of equipment in the coming year. The capital budget is limited to $5,000,000 for the
year. Lori Alleyne, staff analyst at McGloire's, is preparing an analysis of the three projects
under consideration by Joyanne McGloire, the company's owner.
McGloire Construction is analyzing its capital expenditure proposals for the
A
в
D
Project A
Project B
Project C
1
Projected cash outflow
Net initial investment
2
3
$3 000 000
$1 500 000
$4 000 000
4
5 Projected cash inflows
Year 1
$1 000 000
1 000 000
1 000 000
1 000 000
$ 400 000
$2 000 000
7
Year 2
900 000
2 000 000
8
Year 3
800 000
200 000
Year 4
100 000
10
11 Required rate of return
10%
10%
10%
1. Because the company's cash is limited, McGloire thinks the payback method
should be used to choose between the capital budgeting projects.
a. List two benefits and two limitations of using the payback method to choose
between projects?
b. Calculate the payback period for each of the three project
Ignore income taxes. Using the payback…
arrow_forward
Bha
arrow_forward
Problem 6-27 Calculating Project NPV
With the growing popularity of casual surf print clothing, two recent MBA graduates
decided to broaden this casual surf concept to encompass a “surf lifestyle for the home."
With limited capital, they decided to focus on surf print table and floor lamps to accent
people's homes. They projected unit sales of these lamps to be 10,400 in the first year,
with growth of 6 percent each year for the next five years. Production of these lamps will
require $53,000 in net working capital to start. Total fixed costs are $137,000 per year,
variable production costs are $20 per unit, and the units are priced at $62 each. The
equipment needed to begin production will cost $595,000. The equipment will be
depreciated using the straight-line method over a 5-year life and is not expected to have
a salvage value. The tax rate is 24 percent and the required rate of return is 19 percent.
What is the NPV of this project? (Do not round intermediate calculations and round…
arrow_forward
Question Two
a) A company has $10 million available for investment. It is considering investing in three
individual investment projects.
Project One
Project Two
Project Three
Initial Investment
$4 million
$2 million
$7 million
Net present value
$9 million
$3 million
$11 million
What would be the opportunity cost of investing in Project One?
b) What is the strongest argument in favor of setting a common hurdle rate across a company
for all projects?
c) You have been asked to determine the internal rate of return (IRR) of a project that has an
initial cash outflow, followed by seven years of net cashflows. The project's net present
value was +$500,000 when determined at 11% and -$500,00 when determined at 16%.
arrow_forward
Exercise 24-22A (Algo) Using Excel to compute IRR LO P4
Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company
requires a 10% return from its investments.
Initial investment
Net cash flown in
Pool
Spa
Year 1
Year 2
IRR
41,100
57,100
81,395
91,500
66,100
Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.)
Year 3
Year 4
Year 5
%
Pool
Spa
$ (171,000) $ (116,000)
%
33,100
51,100
67,100
73,100
25,100
arrow_forward
Subject: accounting
arrow_forward
1 Jlgu
übja 1
Flint Systems is considering investing in production-
management software that costs $630,000, has $67,000
residual value, and leads to cost savings of $1,650,000
per year over its five-year life. Calculate the average
amount invested in the asset that should be used for
calculating the accounting rate of return
$697,000
.A
$348,500
.B O
$67,000
.c O
$630,000
.D
arrow_forward
Please help me with all answers thanku
arrow_forward
Chapter 11, Question 7
arrow_forward
K
Question 7, Problem 9-18ab
Part 1 of 4
HW Score: 65.48%, 7.86 of 12 points
○ Points: 0 of 1
Save
Buhler Industries is a farm implement manufacturer. Management is currently evaluating a proposal to build a plant that will manufacture lightweight tractors. Buhler plans to use a cost of capital of
12% to evaluate this project. Based on extensive research, it has prepared the following incomplete incremental free cash flow projections (in millions of dollars):
Free Cash Flow ($000,000s)
Revenues
- Manufacturing expenses (other than depreciation)
-Marketing expenses
- CCA
= EBIT
- Taxes (35%)
Unlevered net income
+ CCA
Year 0
Years 1-9 Year 10
116.00
116.00
-36.00
-36.00
- 8.00
-8.00
?
?
?
?
?
?
?
?
?
?
-Increases in net working capital
- 5.00
- 5.00
Using the indirect method requires a separate calculation of the CCA tax shield. What is the present value of the CCA tax shield?
The present value of the CCA tax shield is $ million. (Round to two decimal places.)
arrow_forward
Problem 9
Intro
Apollo Learnings needs $39 million to build a new campus. The company has a target debt-equity ratio of 1.
The flotation cost for new equity is 9% and the flotation cost for new debt is 4%.
Part 1
What are the weighted average flotation costs as a fraction of the amount invested?
4+ decimals
Submit
Part 2
What is the true cost of building the new campus (in $ million)?
1+ decimals
Submit
arrow_forward
Question 6 options:
Investigation and a reasonable amount of work had brought the following project to the attention of Arthur Morgan, CEO of Valentine Ventures.
The following information is presented to you:
CCA rate Building: 4%
CCA rate Equipment: 30%
Cost of Capital 12%
Corporate Tax Rate 40%
An immediate cash outlay of $800,000 will be required to purchase vacant land. The vacant land will be required to house the specialized building that will be constructed over the next 2 years.
The building will require an immediate down payment of $700,000 now and $1,600,000 upon completion of the building at the end of the second year.
New equipment also will be placed in the building at the end of the 2nd year. The equipment will require annual year end purchase payments of $400,000 in year one and two.
The equipment…
arrow_forward
10:17 W W
n
s26-3
S26-4 Using the payback and accounting rate of return methods to make capital
investment decisions
Learning Objective 2
:::
Consider how Hunter Valley Snow Park Lodge could use capital budgeting to
decide whether the $11,000,000 Snow Park Lodge expansion would be a good
investment. Assume Hunter Valley's managers developed the following
estimates concerning the expansion:
Number of additional skiers per day
Average number of days per year that weather conditions allow
skiing at Hunter Valley
Useful life of expansion (in years)
Average cash spent by each skier per day
Average variable cost of serving each skier per day
Cost of expansion
C
056ll 70%
QAA
1465/ 1480
| b
121 skiers
142 days
7 years
$ 241
83
11,000,000
||| 0 <
X
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning

Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Related Questions
- Question content area top Part 1 New Process Corporation is a rapidly growing biotech company that has a required rate of return of 8%. It plans to build a new facility in Santa Clara County. The building will take 2 years to complete. The building contractor offered New Process • Plan I: Payment of $225,000 at the time of signing the contract and $4,675,000 upon completion of the building. The end of the second year is the completion date. • Plan II: Payment of $1,675,000 at the time of signing the contract and $1,675,000 at the end of each of the two succeeding years. • Plan III: Payment of $375,000 at the time of signing the contract and $1,550,000 at the end of each of the three succeeding years. Requirement 1. Using the net present value method, calculate the comparative cost of each of the three payment plans a choice of three payment plans, as follows:arrow_forwardA B C E F G H J K 1 Function: FV, Rate; Cell referencing 2 3 Problem 10.22 - Modified Internal Rate of Return (MIRR) 4 PROBLEM 5 Morningside Bakeries recently purchased equipment at a cost of 6 $650,000. Management expects the equipment to generate cash flows of 7 $275,000 in each of the next four years. The cost of capital is 14 percent. Student Work Area Required: Provide input into cells shaded in gray in this template. Use the FV function with cell references to the Problem area in order to calculate the terminal value of cash flows. Use the Rate function with cell references to the Problem area and Student Work area to calculate the MIRR. Do not leave any portion of the formula for the functions blank - use 0's when necessary. Be sure to represent cash inflows as positive values. 8 9 PV of Costs 10 Length of Project 11 Cost of Capital 12 Annual Cash Flows 13 14 15 16 17 18 19 $ 650,000.00 4 years 14% $275,000.00 What is the terminal cash flow for this project? Terminal cash flow…arrow_forwardDogarrow_forward
- PI A manager at Shannon's Custom Cabinets is interested in purchasing a computer, software, and peripheral equipment costing $240,000 that would allow company salespeople to demonstrate to custor finished carpet installation would appear. Using this cost, the manager has determined that the investments net present value is $126.000, Compute the investment's profitability index Note: Round your answer to one decimal point de round 4.555 to 4.63 0arrow_forwardRequired information Learning Objective 11-04 Calculate the periodic amortization of an intangible asset. (The following information applies to the questions displayed below.] The allocation process for intangible assets is called amortization. For an intangible asset with a finite useful life, the capitalized cost less any estimated residual value must be allocated to periods in which the asset is expected to contribute to the company's revenue-generating activities. An intangible asset that is determined to have an indefinite useful life is not subject to periodic amortization. Goodwill is perhaps the most typical intangible asset with an indefinite useful life. Software developmentarrow_forwardQ. 1 purchase of equipment in the coming year. The capital budget is limited to $5,000,000 for the year. Lori Alleyne, staff analyst at McGloire's, is preparing an analysis of the three projects under consideration by Joyanne McGloire, the company's owner. McGloire Construction is analyzing its capital expenditure proposals for the A в D Project A Project B Project C 1 Projected cash outflow Net initial investment 2 3 $3 000 000 $1 500 000 $4 000 000 4 5 Projected cash inflows Year 1 $1 000 000 1 000 000 1 000 000 1 000 000 $ 400 000 $2 000 000 7 Year 2 900 000 2 000 000 8 Year 3 800 000 200 000 Year 4 100 000 10 11 Required rate of return 10% 10% 10% 1. Because the company's cash is limited, McGloire thinks the payback method should be used to choose between the capital budgeting projects. a. List two benefits and two limitations of using the payback method to choose between projects? b. Calculate the payback period for each of the three project Ignore income taxes. Using the payback…arrow_forward
- Bhaarrow_forwardProblem 6-27 Calculating Project NPV With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home." With limited capital, they decided to focus on surf print table and floor lamps to accent people's homes. They projected unit sales of these lamps to be 10,400 in the first year, with growth of 6 percent each year for the next five years. Production of these lamps will require $53,000 in net working capital to start. Total fixed costs are $137,000 per year, variable production costs are $20 per unit, and the units are priced at $62 each. The equipment needed to begin production will cost $595,000. The equipment will be depreciated using the straight-line method over a 5-year life and is not expected to have a salvage value. The tax rate is 24 percent and the required rate of return is 19 percent. What is the NPV of this project? (Do not round intermediate calculations and round…arrow_forwardQuestion Two a) A company has $10 million available for investment. It is considering investing in three individual investment projects. Project One Project Two Project Three Initial Investment $4 million $2 million $7 million Net present value $9 million $3 million $11 million What would be the opportunity cost of investing in Project One? b) What is the strongest argument in favor of setting a common hurdle rate across a company for all projects? c) You have been asked to determine the internal rate of return (IRR) of a project that has an initial cash outflow, followed by seven years of net cashflows. The project's net present value was +$500,000 when determined at 11% and -$500,00 when determined at 16%.arrow_forward
- Exercise 24-22A (Algo) Using Excel to compute IRR LO P4 Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. Initial investment Net cash flown in Pool Spa Year 1 Year 2 IRR 41,100 57,100 81,395 91,500 66,100 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) Year 3 Year 4 Year 5 % Pool Spa $ (171,000) $ (116,000) % 33,100 51,100 67,100 73,100 25,100arrow_forwardSubject: accountingarrow_forward1 Jlgu übja 1 Flint Systems is considering investing in production- management software that costs $630,000, has $67,000 residual value, and leads to cost savings of $1,650,000 per year over its five-year life. Calculate the average amount invested in the asset that should be used for calculating the accounting rate of return $697,000 .A $348,500 .B O $67,000 .c O $630,000 .Darrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningPfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning

Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning