Net cash flow Discount Factor = 1/((1+r)^n) Present value of the cash flows Net present value 1.000 3. Use Excel's NPV function to compute the present value of the cash flows from years 1-5. Do not include the original investment at time zero. NPV of Cash Flows from Years 1-5 Deduct the cost of the investment Net present value Write an if/then statement to ACCEPT or REJECT the project based on NPV 4. Use Excel's IRR function to compute the project's internal rate of return Write an if/then statement to ACCEPT or REJECT the project based on IRR 5. Compute the project's payback period. 6. Compute the project's accounting rate of return. years

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Topic Video
Question
Net cash flow
Discount Factor = 1/((1+r)^n)
Present value of the cash flows
Net present value
Net present value
Write an if/then statement to ACCEPT or REJECT the project based on NPV
4. Use Excel's IRR function to compute the project's internal rate of return
Write an if/then statement to ACCEPT or REJECT the project based on IRR
5. Compute the project's payback period.
3. Use Excel's NPV function to compute the present value of the cash flows from years 1-5. Do not include the original investment at time zero.
NPV of Cash Flows from Years 1-5
Deduct the cost of the investment
6. Compute the project's accounting rate of return.
4
▶
ADY
tempt(s)
Sheet1
0
1.000
+
2
years
3
用 E
||
5
+
100%
Hint
Transcribed Image Text:Net cash flow Discount Factor = 1/((1+r)^n) Present value of the cash flows Net present value Net present value Write an if/then statement to ACCEPT or REJECT the project based on NPV 4. Use Excel's IRR function to compute the project's internal rate of return Write an if/then statement to ACCEPT or REJECT the project based on IRR 5. Compute the project's payback period. 3. Use Excel's NPV function to compute the present value of the cash flows from years 1-5. Do not include the original investment at time zero. NPV of Cash Flows from Years 1-5 Deduct the cost of the investment 6. Compute the project's accounting rate of return. 4 ▶ ADY tempt(s) Sheet1 0 1.000 + 2 years 3 用 E || 5 + 100% Hint
X
Paste
FILE
A1
Clipboard G
6
7
8
•
HOME
Calibri
4
INSERT
BIU
16 Cost of Capital
17
▶
⠀
14 Net operating income
15
READY
Attempt(s)
A
1 Laurman, Inc. is considering the following project:
2 Required investment in equipment
3 Project life
4 Salvage value
5
11
Font
PAGE LAYOUT
The project would provide net operating income each year as follows:
Sales
Variable expenses
9 Contribution margin
10
11
12
Depreciation
13 Total fixed expenses
À À
A-
Fixed expenses:
Salaries, rent and other fixed out-of pocket costs
Sheet1
FORMULAS
Wrap Text
=== **Merge & Center
Alignment
X ✓ fxx Laurman, Inc. is considering the following project:
Гу
18 1. Compute the annual net cash inflow from the project.
19
(+)
DATA
B
Comparison of Capital Budgeting Methods - Excel
VIEW
REVIEW
18%
$
0
$
General
-
$ %,
Number
с
+.0 .00
.00 .0
1,750,000
5 years
225,000
520,000
350,000
$
1
$
Conditional Format as Cell
Formatting Table Styles
Styles
$
D
20 2. Complete the following timeline to compute the net present value of the future cash flows for this project. Don't forget to include the salvage value in year 5.
21
Year
22
23 Net cash flow
2,750,000
1,600,000
1,150,000
870,000
280,000
2
E
I
II
▬
H
Insert Delete Format
Cells
F
3
> AutoSum
✔Fill
✓Clear
4
"
?困
AY M
Sort & Find &
Filter Select
Editing
G
Sign In
8
5
X
Hint
LA
100%
Transcribed Image Text:X Paste FILE A1 Clipboard G 6 7 8 • HOME Calibri 4 INSERT BIU 16 Cost of Capital 17 ▶ ⠀ 14 Net operating income 15 READY Attempt(s) A 1 Laurman, Inc. is considering the following project: 2 Required investment in equipment 3 Project life 4 Salvage value 5 11 Font PAGE LAYOUT The project would provide net operating income each year as follows: Sales Variable expenses 9 Contribution margin 10 11 12 Depreciation 13 Total fixed expenses À À A- Fixed expenses: Salaries, rent and other fixed out-of pocket costs Sheet1 FORMULAS Wrap Text === **Merge & Center Alignment X ✓ fxx Laurman, Inc. is considering the following project: Гу 18 1. Compute the annual net cash inflow from the project. 19 (+) DATA B Comparison of Capital Budgeting Methods - Excel VIEW REVIEW 18% $ 0 $ General - $ %, Number с +.0 .00 .00 .0 1,750,000 5 years 225,000 520,000 350,000 $ 1 $ Conditional Format as Cell Formatting Table Styles Styles $ D 20 2. Complete the following timeline to compute the net present value of the future cash flows for this project. Don't forget to include the salvage value in year 5. 21 Year 22 23 Net cash flow 2,750,000 1,600,000 1,150,000 870,000 280,000 2 E I II ▬ H Insert Delete Format Cells F 3 > AutoSum ✔Fill ✓Clear 4 " ?困 AY M Sort & Find & Filter Select Editing G Sign In 8 5 X Hint LA 100%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
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…
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