FIN100_Week10Assignment_DP
xlsx
School
Strayer University *
*We aren’t endorsed by this school
Course
100
Subject
Finance
Date
Apr 28, 2024
Type
xlsx
Pages
4
Uploaded by Everythingisalleged
Week 10 Assignment: Capital Management
Your name:
Destiny President
Calculate the NPV for Project #1
Variable
Amount
Discount rate (rate of return)
10%
Cash flow for year one
$0.00
Cash flow for year two
$100,000.00
Present value
$82,644.63
Cost of investment
$50,000.00
Net present value (NPV)
$32,644.63
Calculate the NPV for Project #2
Variable
Amount
Discount rate (rate of return)
10%
Cash flow for year one
$50,000.00
Cash flow for year two
$25,000.00
Present value
$66,115.70
Cost of investment
$50,000.00
Net present value (NPV)
$16,115.70
Evaluate the Net Present Value (NPV)
Evaluate the Internal Rate of Return (IRR)
Project Internal Rate of Return (IRR)
Project #1
41%
Project #2
37%
What does the IRR tell us about Project #1?
What does the IRR tell us about Project #2?
Make a Decision
What does the NPV tell us about Project #1, and why is this important?
projects is projected to generate a profit greater than the required rate of return. This is important because it shows that it may be What does the NPV tell us about Project #2, and why is this important?
Although the NPV is lower than projected in Project #2 it still tells us that the project is profitable which is important for investors. The IRR tells us that Project #1 would bring in 5% more in profit. The IRR tells us that Project #2 would bring in 5% less in profit.
Why is this project the best choice?
Based on the long-term increase in value, which project is the best choice for Just Running?
The best choice for Just Running is Project #1 because although the Project isn't projected to show any profit in year 1, it still shows more profit in the second year than Project #2 in both years. It shows that the company would get more out of the investment. How does your decision connect to the first financial principle, money has a time value?
My decision connects back to the first financial principle because I determined the future cash flows of the project.
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 Documents
Related Questions
Year
Project 1
Net Cash Flows
Project 2
Initial investment
$(60,000)
$(55,500)
1.
2.
15,000
35,000
27,400
3.
22,000
15,000
22,000
a. Compute payback period for each project. Based on payback period, which project is preferred?
b. Compute net present value for each project. Based on net present value, which project is preferred?
Complete this question by entering your answers in the tabs below.
Required A Required B
Compute net present value for each project. Based on net present value, which project is preferred?
Note: Round your present value factor to 4 decimals. Round your final answers to the nearest whole dollar.
Net Cash
Flows
Present Value
Present Value of Net
Factor
Cash Flows
Project 1
Year 1
Year 2
Year 3
Totals
Initial investment
Net present value
Project 2
Year 1
Year 2
Year 3
Totals
Initial investment
$
0
$
0
$
0
$
0
$
0
Net present value
Based on net present value, which project is preferred?
$
0
arrow_forward
Homework, Chapter 26
Average Rate of Return
The following data are accumulated by Watershed Inc. in evaluating two competing capital
investment proposals:
Project A
Project z
Amount of investment
$80,000
$92,000
Useful life
4 years
7 years
Estimated residual value
Estimated total income over the useful life
$8,800
$27,370
Determine the expected average rate of return for each project. Round your answers to one
decimal place.
Project A
Project z
arrow_forward
Discount Rate
12%
Investment Project
Cash Flow
Total Net Cash Flow
Initial Investment
$ (8,000)
?
Year 1
$ 800
?
Year 2
$ 900
?
Year 3
$ 1,500
?
Year 4
$ 1,800
?
Year 5
$ 3,200
NPV of investment
$ ?
Estimated Payback Period
?
Estimate the total net cash flows, NPV of Investment and Estimated Payback Period using the excel's formula.
arrow_forward
Vd
Subject: acounting
arrow_forward
Question content area top
Part 1
(IRR
calculation)
Determine the IRR on the following projects:
a. An initial outlay of $13,000 resulting in a single free cash flow of $17,165 after 9 years
b. An initial outlay of $13,000 resulting in a single free cash flow of $46,394 after 15 years
c. An initial outlay of $13,000 resulting in a single free cash flow of $105,001after 25 years
d. An initial outlay of $13,000 resulting in a single free cash flow of $13,653 after 4 years
arrow_forward
Problem #2 - Chapter 13 – Preference Ranking for Investment Projects
The management of Revco Products is exploring four different investment opportunities, Information on the four projects under study
follows:
Project C
(450,000)
522,970
72,970
Project B
(360,000)
433,400
73,400
Project A
Description
Investment Required ($)
Present value of Cash Inflows ($)
Net Present Value ($)
Life of the Project (in years)
Project D
(270,000)
336,140
66,140
(480,000)
567,270
87,270
6
3
12
6
Internal Rate of Return (%)
18%
19%
14%
16%
Because the company's required rate of return is 10%, a 10% discount rate has been used in the present value computations above.
Limited funds are available for the investment, so the company cannot accept all the available projects.
1) Compute the project profitability index for each investment project.
2) Rank the four projects according to preference in terms of the following metrics:
Net Present Value
b. Project Profitability Index
Internal Rate of Return
a.
c.
3)…
arrow_forward
MC algo 9-3 Calculating Payback Period
There is a project with the following cash flows :
Year
Cash Flow
0
−$ 24,700
1
7,400
2
7,900
3
7,300
4
5,500
What is the payback period?
Multiple Choice
4.00 years
3.84 years
3.38 years
2.71 years
3.65 years
arrow_forward
Part D: Investment Decisions
Now consider that Luxio has identified the following two mutually exclusive projects:
Year
0
1
2
3
4
Cash Flow (A)
-$34,000
$16,500
$14,000
$10,000
$6,000
Cash Flow (B)
-$34,000
$5,000
$10,000
$18,000
$19,000.
1. What is the IRR for each of these projects? Based on IRR decision rule, which
project should the company accept?
2. If the required return is 11%, what is the NPV for each of these projects?
Based on the NPV decision rule, which project should the company accept?
3. Over what range of discount rates would the company choose project A? At
what discount rate would the company be indifferent between these two
projects? Explain.
arrow_forward
Subject: acounting
arrow_forward
Question 9
Consider the following two mutually exclusive projects:
Year
Cash Flow (A)
Cash Flow (B)
0
-$50,000
-$25,000
1
$25,000
$10,000
2
$10,000
$10,000
3
$10,000
$10,000
4
$20,000
$5,000
Whichever project you choose, if any, you require a 10 percent return on your investment. If you apply the payback criterion, you will choose investment _____, if you apply the NPV criterion, you will choose investment _____; if you apply the IRR criterion, you will choose investment ____; if you choose the profitability index criterion, you will choose investment ____. Based on your first four answers, which project will you finally choose?
Group of answer choices
A; A; A; A; A
A; B; A; A; A
B; A; A; A; A
A; B; B; B; B
B; B; B; B; B
arrow_forward
MC algo 9-21 Calculating Profitability Index
POD has a project with the following cash flows:
Year
Cash Flows
0
−$ 275,000
1
145,800
2
163,300
3
128,400
The required return is 8.6 percent. What is the profitability index for this project?
Multiple Choice
1.130
.922
.737
1.356
1.243
arrow_forward
Question 7
Chestnut Tree Farms has identified the following two mutually exclusive projects:
Year
Cash Flow (A)
Cash Flow (B)
0
-$50,000
-$50,000
1
$35,000
$15,000
2
$8,000
$13,000
3
$7,000
$15,000
4
$6,000
$20,000
If forced to choose one of the two projects above, over what range of discount rates would you choose Project A?
Group of answer choices
12.32 percent or less
12.32 percent or more
13.16 percent or less
13.98 percent or less
13.98 percent or more
arrow_forward
mg
arrow_forward
Pls help stepwise sir
arrow_forward
Question 6
A project has expected cash inflows, starting with year 1, of $2,200, $2,900, $3,500 and finally in year four, $4,000. The profitability index is 1.14 and the discount rate is 12 percent. What is the initial cost of the project?
Group of answer choices
$9,211.06
$9,250.00
$8,166.19
$7,899.16
$8,098.24
arrow_forward
Task 2A business has two projects to invest in, as follows:Create a new spread sheet, calculate NPV for the following projects at discount rates of 3% and 7%, respectively, by creating a dynamic process.
Project 1 Project 2Year Cash inflows Cash outflows Cash inflows Cash outflows0 0.00 70,000.00 0.00 70,000.001 24,000.00 13,000.00 25,000.00 15,000.002 22,000.00 1,000.00 25,000.00 03 25,000.00 0 20,000.00 04 25,000.00 0 43,000.00 21,000.005 17,500.00 7,500.00 20,000.00 5,000.00
P1: NPV P2: NPVThen, a) by using a built-in/Excel function, calculate the NPV for each project with discount rates of 3% and 7%, respectively;b) By comparing the NPVs at the rate of…
arrow_forward
D, E, F, G, need to be solved
arrow_forward
Year
0
$10,000.00
1
$ 3,000.00
Project A
Cash Flow
Project B
Cash Flow
$11,000.00
$5,000.00
2
$ 4,000.00
$ 4,000.00
3
$ 5,000.00
$ 4,000.00
4
$3,000.00
$ 3,000.00
Assuming that the relevant cost of capital for both projects is 10%, you should be able to
determine the net present value (NPV) and the internal rate of return (IRR) for both project.
Assume now that the firm has capital rationing, but knows that its true reinvestment rate is
21%, while its cost of capital is 10 percent. Given this information, determine the modified
net present value (MNPV) for Project A.
$3,811.27
O $3,622.02
O $4,280.07
O $4,162.90
O $4,404.83
arrow_forward
Intro
Office Min is considering several risk-free projects:
Project Initial cash flow Cash flow in 1 year
A
-8,100
9,720
-4,000
4,200
-6,500
7,475
B
C
The risk-free interest rate is 10%.
Part 1
What is the NPV of project A?
0+ decimals
Submit
Part 2
What is the NPV of project B?
0+ decimals
Submit
Part 3
What is the NPV of project C?
0+ decimals
Submit
Part 4
Which projects should the company accept?
Check all that apply:
O Project C
Project A
Project B
Submit
arrow_forward
Solve this question general accounting
arrow_forward
Question list
✔Question 1
Data table
A
1
2 Projected cash outflow
3 Net initial investment
4 Projected cash inflows
5 Year 1
6 Year 2
7
Year 3
8 Year 4
9 Required rate of return
↑
Lulus Construction is analyzing its capital expenditure proposals for the purchase of equipment in the coming year. The capital budget is limited to $12,000,000 for the year. Lyssa
Bickerson, staff analyst at Lulus, is preparing an analysis of the three projects under consideration by Caden Lulus, the company's owner.
(Click the icon to view the data for the three projects.)
Present Value of $1 table
Read the requirements.
B
Project A
с
Project B
Present Value of Annuity of $1 table Future Value of $1 table Future Value of Annuity of $1 table
D
Project C
$ 6,000,000 $ 4,000,000 $8,000,000
8%
$ 2,050,000 $ 1,100,000 $4,700,000
2,050,000 2,300,000 4,700,000
2,050,000 700,000 50,000
2,050,000
25,000
8%
8%
Requirements
1. Because the company's cash is limited, Lulus thinks the payback method should be used to…
arrow_forward
MC algo 9-27 Calculating NPV
Living Colour Company has a project available with the following cash flows:
Year
Cash Flow
0
−$ 35,550
1
7,880
2
9,450
3
13,350
4
15,490
5
10,160
If the required return for the project is 7.6 percent, what is the project's NPV?
Multiple Choice
$20,780.00
$9,251.98
$10,573.69
$2,207.77
$10,022.98
arrow_forward
Subject: acounting
arrow_forward
QUESTION 14
You have a total of $30,000 to invest in a project and are considering the following three projects:
Cash Flows
Project A
($30,000)
$8,500
Year
Project B
($30,000)
$19,600
Project C
($30,000)
$10,400
1
$9,300
$17,300
$4,500
$10,400
$10,400
3.
$10,400
4.
$11,200
$4,200
$10,400
$12,300
$2,300
$10,400
If the cost of capital (discount rate) is 10%, which project(s) do you invest in and why?
A. Project B- it will pay back the quickest
OB. Project C- it generates the greatest cash flow
C. Project A-it has the highest accounting rate of return
D.Project B-it has the highest net present value
E. Project A- it has the highest net present value
OF. Project C- it has the highest profitability index
arrow_forward
Please find attached question
arrow_forward
Please help with formulas:
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
- Year Project 1 Net Cash Flows Project 2 Initial investment $(60,000) $(55,500) 1. 2. 15,000 35,000 27,400 3. 22,000 15,000 22,000 a. Compute payback period for each project. Based on payback period, which project is preferred? b. Compute net present value for each project. Based on net present value, which project is preferred? Complete this question by entering your answers in the tabs below. Required A Required B Compute net present value for each project. Based on net present value, which project is preferred? Note: Round your present value factor to 4 decimals. Round your final answers to the nearest whole dollar. Net Cash Flows Present Value Present Value of Net Factor Cash Flows Project 1 Year 1 Year 2 Year 3 Totals Initial investment Net present value Project 2 Year 1 Year 2 Year 3 Totals Initial investment $ 0 $ 0 $ 0 $ 0 $ 0 Net present value Based on net present value, which project is preferred? $ 0arrow_forwardHomework, Chapter 26 Average Rate of Return The following data are accumulated by Watershed Inc. in evaluating two competing capital investment proposals: Project A Project z Amount of investment $80,000 $92,000 Useful life 4 years 7 years Estimated residual value Estimated total income over the useful life $8,800 $27,370 Determine the expected average rate of return for each project. Round your answers to one decimal place. Project A Project zarrow_forwardDiscount Rate 12% Investment Project Cash Flow Total Net Cash Flow Initial Investment $ (8,000) ? Year 1 $ 800 ? Year 2 $ 900 ? Year 3 $ 1,500 ? Year 4 $ 1,800 ? Year 5 $ 3,200 NPV of investment $ ? Estimated Payback Period ? Estimate the total net cash flows, NPV of Investment and Estimated Payback Period using the excel's formula.arrow_forward
- Vd Subject: acountingarrow_forwardQuestion content area top Part 1 (IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $13,000 resulting in a single free cash flow of $17,165 after 9 years b. An initial outlay of $13,000 resulting in a single free cash flow of $46,394 after 15 years c. An initial outlay of $13,000 resulting in a single free cash flow of $105,001after 25 years d. An initial outlay of $13,000 resulting in a single free cash flow of $13,653 after 4 yearsarrow_forwardProblem #2 - Chapter 13 – Preference Ranking for Investment Projects The management of Revco Products is exploring four different investment opportunities, Information on the four projects under study follows: Project C (450,000) 522,970 72,970 Project B (360,000) 433,400 73,400 Project A Description Investment Required ($) Present value of Cash Inflows ($) Net Present Value ($) Life of the Project (in years) Project D (270,000) 336,140 66,140 (480,000) 567,270 87,270 6 3 12 6 Internal Rate of Return (%) 18% 19% 14% 16% Because the company's required rate of return is 10%, a 10% discount rate has been used in the present value computations above. Limited funds are available for the investment, so the company cannot accept all the available projects. 1) Compute the project profitability index for each investment project. 2) Rank the four projects according to preference in terms of the following metrics: Net Present Value b. Project Profitability Index Internal Rate of Return a. c. 3)…arrow_forward
- MC algo 9-3 Calculating Payback Period There is a project with the following cash flows : Year Cash Flow 0 −$ 24,700 1 7,400 2 7,900 3 7,300 4 5,500 What is the payback period? Multiple Choice 4.00 years 3.84 years 3.38 years 2.71 years 3.65 yearsarrow_forwardPart D: Investment Decisions Now consider that Luxio has identified the following two mutually exclusive projects: Year 0 1 2 3 4 Cash Flow (A) -$34,000 $16,500 $14,000 $10,000 $6,000 Cash Flow (B) -$34,000 $5,000 $10,000 $18,000 $19,000. 1. What is the IRR for each of these projects? Based on IRR decision rule, which project should the company accept? 2. If the required return is 11%, what is the NPV for each of these projects? Based on the NPV decision rule, which project should the company accept? 3. Over what range of discount rates would the company choose project A? At what discount rate would the company be indifferent between these two projects? Explain.arrow_forwardSubject: acountingarrow_forward
- Question 9 Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 -$50,000 -$25,000 1 $25,000 $10,000 2 $10,000 $10,000 3 $10,000 $10,000 4 $20,000 $5,000 Whichever project you choose, if any, you require a 10 percent return on your investment. If you apply the payback criterion, you will choose investment _____, if you apply the NPV criterion, you will choose investment _____; if you apply the IRR criterion, you will choose investment ____; if you choose the profitability index criterion, you will choose investment ____. Based on your first four answers, which project will you finally choose? Group of answer choices A; A; A; A; A A; B; A; A; A B; A; A; A; A A; B; B; B; B B; B; B; B; Barrow_forwardMC algo 9-21 Calculating Profitability Index POD has a project with the following cash flows: Year Cash Flows 0 −$ 275,000 1 145,800 2 163,300 3 128,400 The required return is 8.6 percent. What is the profitability index for this project? Multiple Choice 1.130 .922 .737 1.356 1.243arrow_forwardQuestion 7 Chestnut Tree Farms has identified the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 -$50,000 -$50,000 1 $35,000 $15,000 2 $8,000 $13,000 3 $7,000 $15,000 4 $6,000 $20,000 If forced to choose one of the two projects above, over what range of discount rates would you choose Project A? Group of answer choices 12.32 percent or less 12.32 percent or more 13.16 percent or less 13.98 percent or less 13.98 percent or morearrow_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