M4 - Practical Application 2
.docx
keyboard_arrow_up
School
Louisiana State University, Shreveport *
*We aren’t endorsed by this school
Course
702
Subject
Finance
Date
Jan 9, 2024
Type
docx
Pages
10
Uploaded by HighnessArt10755
MBA702: Fall 2023 - AP2
M4: Practical Application 2
Feedback
comments
Great!! You performed well in completing the rate of return calculations, as well as the
calculations involving the various methods of capital budgeting evaluation. You also
demonstrated an understanding of the IRR, and also the consideration of changes
impacting the NPV. The only corrections included
: # 1 (add values for the total)
;
Project
C's NPV is negative and its PI (and double decision deductions were not made)
, and to
clarify
8 a (ii), the NPV does take into account a reinvestment rate (as later stated, the
cost of capital - no points deducted)
Answers are highlighted in blue.
Setup:
Baker Corp. has several new projects that look attractive, but some are riskier than the firm's
past projects. Baker has received a major inflow of cash from a venture capital firm, in exchange for
25% of the firm's closely held stock. The VC firm has asked Baker managers to "run the numbers" to
examine both the market outlook and the expected returns on each of the projects they are
considering. The cash infusion will not cover all the proposed projects; Baker and its new investors
need to know which projects should be approved.
1.
Based on Baker's earnings history over the past 10 years across a variety of projects, which have covered
various states of the economy, the venture capital execs want Baker to estimate their overall returns. Given
the following estimates of economy over the next several years, determine Baker's expected rate of return.
(6 pts)
Note, this type of development firm has much higher than normal returns under normal and boom conditions. The probability
of each state of the economy reflects the current situation, not necessarily historic market conditions for the firm.
State of the Economy
Current Probability of State of the Economy
Rate of Return if State Occurs
Boom
20%
23.0%
Normal
55%
10.0%
Recession
25%
-21.0%
Expected return for “average” company project (based on assumed economic probabilities) =
Boom: 20%*23% = 4.6%
Correction:
add values for the total
Normal: 55%*10% = 5.5%
Recession: 25%*-21% = -5.25%
2.
Historically, Baker projects have had an average beta of 1.25, which indicates the higher risk levels for the
firm. Assuming the market risk premium (MRP) currently estimated to be 6% and the risk-free rate is
5.53%, what is the required return for an "average" Baker project using based on its average project beta?
Show the average required return to 2 decimal places (x.xx%).
(6 pts)
Expected return for “average” company project (based on current estimated MRP) =
R=Rf + (beta * MRP)
1
MBA702: Fall 2023 - AP2
M4: Practical Application 2
Rf = 5.53%
Beta = 1.25
MRP = 6%
R= 5.53% + (1.25 * 6%)
R= 5.53% + 7.5%
R= 13.03%
3.
The potential projects that Baker is considering have the following expected cash flows.
Each project has
its own unique risk and as such, the beta on each project is given. Using the data from #2 for the risk-free
rate and market risk premium, what is the required percentage return for each of the projects? Show the
required returns to 2 decimals, that is xx.xx%.
You will use these rates when analyzing each project in the
next part of the assignment, these are the required rates of return for Problems 4-6)
.
(8 pts)
R=Rf + (beta * MRP)
Rf = 5.53%
MRP = 6%
Project A
Project B
Project C
Project D
Beta
1.3
0.9
1.1
1.6
Required
Return
(show
work)
R= 5.53% + (1.3* 6%)
=.0553+ (1.3*.06)
= .0553 + .078
= .1333 =
13.33%
R= 5.53% + (0.9* 6%)
=.0553+ (0.9*.06)
= .0553 + .054
= .1093 =
10.93%
R= 5.53% + (1.1* 6%)
=.0553+ (1.1*.06)
= .0553 + .0660
= .1213 =
12.13%
R= 5.53% + (1.6* 6%)
=.0553+ (1.6*.06)
= .0553 + .0960
= .1513 =
15.13%
NOTE: When a firm has projects that differ in risk (beta) than the "average" for the company, then the firm's
overall required return (from Problem 2) isn't applicable. Each project needs to provide a return greater than
or equal to its unique risk-adjusted required return. THE RATES CALCULATED FOR PROJECTS A – D IN
#3 ARE THE REQUIRED RETURNS FOR EACH FOR THE FOLLOWING:
Use for Problems 4-7.
For each project, calculate the NPV, IRR, profitability index (PI) and the payback
period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected,
assuming that each project is independent of the others. Important Note: The venture capital folks, when
considering payback period,
have a firm
maximum payback period of four years.
This 4-year payback
period
has no impact
on other capital budgeting analysis techniques, each is to be considered on its own. In
other words, yes, all cash flows need to be considered for NPV, IRR, and PI.
Expected cash flows for the four potential projects that Baker is considering as shown below (each project
ends when its cash flows end):
Year
Project A
Project B
Project C
Project D
0
-$4,000,000
-$3,000,000
-$6,000,000
-$7,250,000
1
$1,000,000
$300,000
$1,500,000
$2,500,000
2
$1,000,000
$500,000
$1,500,000
$3,000,000
2
MBA702: Fall 2023 - AP2
M4: Practical Application 2
3
$1,000,000
$500,000
$2,500,000
$2,000,000
4
$1,000,000
$750,000
$2,500,000
$1,500,000
5
$800,000
$750,000
$1,500,000
6
$0
$750,000
7
$800,000
$750,000
8
$300,000
$750,000
9
$750,000
10
$750,000
I have provided a
suggested
template for your final answers. Below the grid is where you should show all your
required backup calculations (
this means your cash flow register inputs, the interest rate, PI calculation and
cumulative cash flows for payback
). If you are working this in Excel, feel free to submit your Excel sheet,
where the equations in the cells will provide the required backup. Be sure to clearly indicate the required rate
of return for each project (you calculated each in Problem 3).
Remember that each capital budgeting method should be calculated and analyzed on a stand-alone basis.
Year
Project A
Project B
Project C
Project D
Point
s
Req. Return
(use 2
decimals xx.xx%)
13.33%
10.93%
12.13%
15.13%
6
4a
NPV
(to nearest $1)
-$174,462
-$637,952
$114,539
$90,679
2
4
b
NPV accept/reject
A
A
A
A
4
5a
IRR (xx.xx%)
11.77%
15.15%
11.31%
15.72%
2
5
b
IRR accept/reject
A
A
R
A
4
6a
PI
(show 2 decimals, x.xx)
0.96
1.21
1.96
1.01
2
6
b
PI accept/reject
R
A
A
A
4
7a
Payback Period
(x.x years)
4 years
5.3 years
3.2 years
2.9 years
2
7
b
Payback accept/reject
A
R
A
A
WORK SHOWN ON NEXT PAGES
3
MBA702: Fall 2023 - AP2
M4: Practical Application 2
Project A
Required Return = 13.33%
CF0
-$4,000,000
CF1
$1,000,000
F01= 4
CF2
$800,000
F02= 1
CF3
$0
F03= 1
CF4
$800,000
F04= 1
CF5
$300,000
F05=1
4a. NPV=
-$174,462.38
4b.
accept because >0
5a. IRR=
11.7790
5b.
accept because > return
6a. PI= 3,825,537.619/4,000,000=
0.9564
6b.
reject because <1
Years
Cash Flow
Cumulative Cash Flow
0
($4,000,000)
($4,000,000)
1
$1,000,000
($3,000,000)
2
$1,000,000
($2,000,000)
3
$1,000,000
($1,000,000)
4
$1,000,000
$0
5
$800,000
$800,000
6
$0
$800,000
7
$800,000
$1,600,000
8
$300,000
$1,900,000
7a. Payback Period =
4 years
project lasts 8 years
firm’s maximum payback period= 4 years
7b.
accept because not longer than max payback period
(continues on next page)
4
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
Related Questions
NOTE: JUST ANSWER 3. Accounting rate of return4. Profitability index
arrow_forward
quiz is acceptung
Question 1 (10 points)
The Internal Rate of Return is a financial measure that allows us to estimate:
a
The nominal value of the returns on a project.
b
The profitability of a potential investment in a project.
The variance of returns on a project.
The median of the returns on a project.
Next Page
Once you click Next Page you will not be able to change you answer
Support | Schoology Blog I PRIVACY POI
JUN
30
MacBook Air
arrow_forward
6.Calculate the project's Modified Internal Rate of Return (MIRR). What critical assumption does the MIRR make that differentiates it from the IRR?
TIP : look for the definition of Modified Internal Rate of Return, and then do it in excel, easy !!!
Year
Net Cash flow
Future Value of Net Cash flow
0
-$20.8
example
1
$4.5
$7.97 (n=6, i=10%)=fv(.1,6,,4.5)
2
$6.3
(n=5, i=10%)
3
$5.2
(n=4, i=10%)
4
$3.9
(n=3, i=10%)
5
$2.1
(n=2, i=10%)
6
$1.3
(n=1, i=10%)
7
$0.5
(n=0, i=10%)
Sum = $XX.XX
MIRR = ( in excel ) Rate ( 7,-20.8, xx.xx)
7.Where does the value of MIRR fall relative to the discount rate and IRR?
arrow_forward
Answer the following fast-
A.
Task whose incomes are adequate to compensate capital contributed for pace of return at that point net present worth will be
A. negative
B. zero
C. positive
D. autonomous
B.
Present estimation of future incomes is Rs 2000 and an underlying expense is Rs 1100 then benefit file will be
A. 55.00%
B. 1.82
C. 0.55
D. 1.82%
C.
Benefit record in capital planning is utilized for
A. negative undertakings
B. relative undertakings
C. assess projects
D. acquired tasks
D.
Different elements held steady, more prominent venture liquidity is a result of
A. less undertaking return
B. more prominent venture return
C. more limited compensation period
D. more prominent restitution period
E.
In count of inside pace of return, a supposition expresses that got income from project must
A. be reinvested
B. not be reinvested
C. be acquired
D. not be acquired
F.
In capital planning, number…
arrow_forward
From the problem below :1. For capital budgeting purposes, what is the net investment in the new, high-performing machine?A. P186,400B. P185,000C. P169,600D. P148,000
2. What is the payback period?A. 4.49 yearsB. 5.24 yearsC. 5.76 yearsD. None from the choices
3. Compute the new, high-performing machine's net present value.A. P1,200B. P15,892C. P28,025D. P6,729
arrow_forward
Alert dont submit AI generated answer.
arrow_forward
**Please solve using Excel and show formulas.**
Consider the following projects:
Project
Cash Flows
A
-4
5
2.3
0
0
1,000
B
-5,600
2,800
2,800
5,800
2,800
2,800
C
-7,000
2,800
2,500
0
2,800
2,800
Question: What is the payback period for Project C?
Multiple Choice
3.4
3.9
3.2
3.6
3.8
arrow_forward
Value/other investment criteria (i
Saved
Help
Save
Consider the following two projects:
Cash flows
Project A Project B
-$270
CO
-$270
С1
115
143
C2
115
143
Сз
115
143
C4
115
a. If the opportunity cost of capital is 10%, which of these two projects would you accept (A, B, or both)?
b. Suppose that you can choose only one of these two projects. Which would you choose? The discount rate is still 10%.
Which one would you choose if the cost of capital is 15%?
d. What is the payback period of each project?
e. Is the project with the shortest payback period also the one with the highest NPV?
f. What are the internal rates of return on the two projects?
g. Does the IRR rule in this case give the same answer as NPV?
h-1. If the opportunity cost of capital is 10%, what is the profitability index for each project?
h-2. Is the project with the highest profitability index also the one with the highest NPV?
h-3. Which measure should you use to choose between the projects?
Complete this question by…
arrow_forward
Fast answer please
arrow_forward
Answer as soon as possible please
arrow_forward
Mc
Graw
Hill
Risk and Capital Budgeting
AA
Fill in the blank: Scenario analysis is made up of
several
Correct
Michael
Scenarios
Michael
We have created various scenarios each with
a forecast for our expected sales volume,
revenues, expenses, risks, etc.
At a high level, here are how each of the
scenarios looks like.
Calculate NPV for Scenario A.
Use the information provided on the right. Round to
the nearest whole number.
Submit
Enter a response then click Submit below
$0
Scenarios
Area 1.1
Scenario Comparison ($)
Scenario A
Scenario B
Scenario C
Initial
Investment
2,000,000
2,000,000
2,000,000
Expected interest rate: 12%
Forecasting period: 5 years
PV annuity factor: 3.6048
Annual Net
Income
545, 100
426,995
1,644,385
Annual Cash
Flow
656,890
-493, 005
2,564,385
NPV
-3,777, 184
7,244,095
Return to Activity
Score
Materials
arrow_forward
Question
The following economical indictors are referring to types of project (A and B). Answer the
following points according to these given indictors in the tables.
project A:r=8%
project B: r=8%
year
cash flow (CF)
year
cash flow (CF)
0
-598
0
-384
1
110
1
105
2
170
2
105
3
210
3
95
4
320
4
118
A) If you are aware that( r%) percentages are various for different reasons to be (10% and 20%). So
determine level of NPV during your analysis procedures for whole the mentioned cases of (% r)
for each project?
B) Which one of the mentioned project are more economically by using concept of IRR and take
the range of (% r) between (9% to %25) for supporting your answers?
C) Drawing out all the levels of various of the project for each cases of (r %) which given initially in
point (A) above.
D) Give clear justification about any of the above project more feasible?
arrow_forward
H1.
Account
arrow_forward
Which of the following is FALSE regarding various methods of project analysis?
Both NPV and IRR consider the time value of money.
Average Accounting Return ignores the time value of money.
Payback focuses on liquidity.
O Profitability Index is able to rank projects in the situation of capital rationing.
() Payback considers the time value of money.
Next Page
Page 17 of 3
Previous Page
Submit Quiz
O of 30 questions saved
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- NOTE: JUST ANSWER 3. Accounting rate of return4. Profitability indexarrow_forwardquiz is acceptung Question 1 (10 points) The Internal Rate of Return is a financial measure that allows us to estimate: a The nominal value of the returns on a project. b The profitability of a potential investment in a project. The variance of returns on a project. The median of the returns on a project. Next Page Once you click Next Page you will not be able to change you answer Support | Schoology Blog I PRIVACY POI JUN 30 MacBook Airarrow_forward6.Calculate the project's Modified Internal Rate of Return (MIRR). What critical assumption does the MIRR make that differentiates it from the IRR? TIP : look for the definition of Modified Internal Rate of Return, and then do it in excel, easy !!! Year Net Cash flow Future Value of Net Cash flow 0 -$20.8 example 1 $4.5 $7.97 (n=6, i=10%)=fv(.1,6,,4.5) 2 $6.3 (n=5, i=10%) 3 $5.2 (n=4, i=10%) 4 $3.9 (n=3, i=10%) 5 $2.1 (n=2, i=10%) 6 $1.3 (n=1, i=10%) 7 $0.5 (n=0, i=10%) Sum = $XX.XX MIRR = ( in excel ) Rate ( 7,-20.8, xx.xx) 7.Where does the value of MIRR fall relative to the discount rate and IRR?arrow_forward
- Answer the following fast- A. Task whose incomes are adequate to compensate capital contributed for pace of return at that point net present worth will be A. negative B. zero C. positive D. autonomous B. Present estimation of future incomes is Rs 2000 and an underlying expense is Rs 1100 then benefit file will be A. 55.00% B. 1.82 C. 0.55 D. 1.82% C. Benefit record in capital planning is utilized for A. negative undertakings B. relative undertakings C. assess projects D. acquired tasks D. Different elements held steady, more prominent venture liquidity is a result of A. less undertaking return B. more prominent venture return C. more limited compensation period D. more prominent restitution period E. In count of inside pace of return, a supposition expresses that got income from project must A. be reinvested B. not be reinvested C. be acquired D. not be acquired F. In capital planning, number…arrow_forwardFrom the problem below :1. For capital budgeting purposes, what is the net investment in the new, high-performing machine?A. P186,400B. P185,000C. P169,600D. P148,000 2. What is the payback period?A. 4.49 yearsB. 5.24 yearsC. 5.76 yearsD. None from the choices 3. Compute the new, high-performing machine's net present value.A. P1,200B. P15,892C. P28,025D. P6,729arrow_forwardAlert dont submit AI generated answer.arrow_forward
- **Please solve using Excel and show formulas.** Consider the following projects: Project Cash Flows A -4 5 2.3 0 0 1,000 B -5,600 2,800 2,800 5,800 2,800 2,800 C -7,000 2,800 2,500 0 2,800 2,800 Question: What is the payback period for Project C? Multiple Choice 3.4 3.9 3.2 3.6 3.8arrow_forwardValue/other investment criteria (i Saved Help Save Consider the following two projects: Cash flows Project A Project B -$270 CO -$270 С1 115 143 C2 115 143 Сз 115 143 C4 115 a. If the opportunity cost of capital is 10%, which of these two projects would you accept (A, B, or both)? b. Suppose that you can choose only one of these two projects. Which would you choose? The discount rate is still 10%. Which one would you choose if the cost of capital is 15%? d. What is the payback period of each project? e. Is the project with the shortest payback period also the one with the highest NPV? f. What are the internal rates of return on the two projects? g. Does the IRR rule in this case give the same answer as NPV? h-1. If the opportunity cost of capital is 10%, what is the profitability index for each project? h-2. Is the project with the highest profitability index also the one with the highest NPV? h-3. Which measure should you use to choose between the projects? Complete this question by…arrow_forwardFast answer pleasearrow_forward
- Answer as soon as possible pleasearrow_forwardMc Graw Hill Risk and Capital Budgeting AA Fill in the blank: Scenario analysis is made up of several Correct Michael Scenarios Michael We have created various scenarios each with a forecast for our expected sales volume, revenues, expenses, risks, etc. At a high level, here are how each of the scenarios looks like. Calculate NPV for Scenario A. Use the information provided on the right. Round to the nearest whole number. Submit Enter a response then click Submit below $0 Scenarios Area 1.1 Scenario Comparison ($) Scenario A Scenario B Scenario C Initial Investment 2,000,000 2,000,000 2,000,000 Expected interest rate: 12% Forecasting period: 5 years PV annuity factor: 3.6048 Annual Net Income 545, 100 426,995 1,644,385 Annual Cash Flow 656,890 -493, 005 2,564,385 NPV -3,777, 184 7,244,095 Return to Activity Score Materialsarrow_forwardQuestion The following economical indictors are referring to types of project (A and B). Answer the following points according to these given indictors in the tables. project A:r=8% project B: r=8% year cash flow (CF) year cash flow (CF) 0 -598 0 -384 1 110 1 105 2 170 2 105 3 210 3 95 4 320 4 118 A) If you are aware that( r%) percentages are various for different reasons to be (10% and 20%). So determine level of NPV during your analysis procedures for whole the mentioned cases of (% r) for each project? B) Which one of the mentioned project are more economically by using concept of IRR and take the range of (% r) between (9% to %25) for supporting your answers? C) Drawing out all the levels of various of the project for each cases of (r %) which given initially in point (A) above. D) Give clear justification about any of the above project more feasible?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education