Chapter 13
docx
keyboard_arrow_up
School
University of Guelph *
*We aren’t endorsed by this school
Course
2230
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
4
Uploaded by CommodoreResolveAntelope42
Capital Budgeting Decisions
Exercise 13-1 1.
Item
Year(s)
Cash
Flow
Present
Value of
Cash
Flows*
Annual cost savings
...............
1-5
$25,000
$99,825
Initial investment. .
Now
$(80,000
) (80,000
)
Net present value.
$19,825
*Calculated using NPV formula in Microsoft Excel and an 8% required return.
PV for cashflows year 1-5
Year 1: 25,000 x 0.926 = 23,150
Year 2: 25,000 x 0.857 = 21,425
Exercise 13-3
1.
The solar panel’s net present value without considering the intangible benefits would be:
Item
Year(s
)
Amount of
Cash Flows
Present Value
of Cash
Flows*
Cost of the equipment
..............
Now
$(2,000,00
0)
$(2,000,000)
Annual cash savings.
1-15
$200,000
1,521,000
Net present value
......
$(479,000
)
*Calculated using NPV formula in Microsoft Excel and a 10% required return.
2. The annual value of the intangible benefits would have to be large enough to offset the $478,784 negative present value for the equipment. Using the PMT formula in Microsoft Excel, the required increase in annual cash flows to offset the negative NPV of $478,784 is approximately $62,948. In other words, the goodwill created among customers from investing in solar panels would need to generate an incremental contribution margin of nearly $63,000 ignoring taxes.
Exercise 13-5 1. The payback period is determined as follows:
Year
Investme
nt
Cash
Inflow
Unrecovered
Investment
1
$15,000
$1,000
$14,000
2
$12,500
$2,000
$24,500
3
$2,500
$22,000
4
$4,000
$18,000
5
$5,000
$13,000
6
$6,000
$7,000
7
$5,000
$2,000
8
$4,000
$0
9
$3,000
$0
10
$2,000
$0
The investment in the project is fully recovered in the 7th year. To be more exact, the payback period is approximately 6.5 years.
2. Since the investment is recovered prior to the last year, the amount of the cash inflow in the last year has no effect on the payback period.
Exercise 13-7
Item
Year(s
)
Amount of
Cash
Flows
Present
Value of Cash
Flows*
Project Alpha:
Investment required
..............
Now
$(30,000)
$(30,000)
Annual cash inflows
................
1-10
$8,000
53,681
Net present value.
$
23,681
Project Beta:
Investment
...........
Now
$(30,000)
$(30,000)
Cash inflow
...........
10
$120,000
55,583
Net present value.
$ 25,583
*Calculated using NPV formula in Microsoft Excel and an 8% required return.
Project B should be selected since it provides a higher net present
value.
Exercise 13-11 1. The payback period would be:
Payback period
=
Investment required
Net annualcashinflow
4.2
years
=
$
210,000
$
50,000
Yes, the boat would be purchased, since the 4.2-year payback period is less than the company’s maximum 5-year payback period.
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
Exercise 13-15 1. Computation of the annual cash inflow associated with the new go-cart track:
Operating income
................................
$73,000
Add: Noncash deduction for depreciation
......................................
63,000
Net annual cash inflow
........................
$136,000
The payback computation would be:
Payback period =
Investment required
Net annualcashinflow
=
$
680,000
$
136,000
= 5
Yes, the go-cart track meets the requirement. The payback period is less than the maximum 6 years required.
Related Questions
Capital Budgeting
Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these.
Time
Project A Cash Flows
Project B Cash Flows
0
-$46,800
-$63,600
1
-21,600
20,400
2
43,200
20,400
3
43,200
20,400
4
43,200
20,400
5
-28,800
20,400
Sketch the NPV profile for projects A & B.
arrow_forward
Capital Budgeting
Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these.
Time
Project A Cash Flows
Project B Cash Flows
0
-$46,800
-$63,600
1
-21,600
20,400
2
43,200
20,400
3
43,200
20,400
4
43,200
20,400
5
-28,800
20,400
Calculate the IRR and MIRR of projects A & B. Assume a reinvestment rate of 13% for the calculation of MIRR.
arrow_forward
Capital Budgeting
Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these.
Time
Project A Cash Flows
Project B Cash Flows
0
-$46,800
-$63,600
1
-21,600
20,400
2
43,200
20,400
3
43,200
20,400
4
43,200
20,400
5
-28,800
20,400
Under what conditions on the cost of capital should project B be preferred to project A?
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
Capital Budgeting
Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these.
Time
Project A Cash Flows
Project B Cash Flows
0
-$46,800
-$63,600
1
-21,600
20,400
2
43,200
20,400
3
43,200
20,400
4
43,200
20,400
5
-28,800
20,400
Calculate the payback period and discounted payback period for projects A & B.
arrow_forward
Exercise 2
A fund begins with $10 million and reports the following three-month results (with negative
figures in parentheses):
Month:
1
2
Net cashflows (end of month, $ million)
-10
-3.0
-5
18.486
HPR (%)
2.0
8.0
(4.0)
Compute the arithmetic, time-weighted, and dollar-weighted average returns.
arrow_forward
Capital Budgeting
Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these.
Time
Project A Cash Flows
Project B Cash Flows
0
-$46,800
-$63,600
1
-21,600
20,400
2
43,200
20,400
3
43,200
20,400
4
43,200
20,400
5
-28,800
20,400
Assuming a cost of capital of 13%, which of these projects should be accepted?
arrow_forward
Video
Excel Online Structured Activity: Capital budgeting criteria
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows:
0
1
2
3
4
5
6
7
+
Project A
-$300 -$387
Project B -$405 $133
-$193 -$100
$133 $133
$600
$133
$600
$133
$850
-$180
$133
$0
The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
X
Open spreadsheet
a. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations.
Project A: $
162.48
Project B: $
b. What is each project's IRR? Round your answer to two decimal places.
Project A:
18.10
%
Project B:
%
arrow_forward
Capital Budgeting
Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 12% to evaluate projects such as these.
Time
Project A Cash Flows
Project B Cash Flows
0
-$300,000
-$405,000
1
-387,000
134,000
2
-193,000
134,000
3
-100,000
134,000
4
600,000
134,000
5
600,000
134,000
6
850,000
134,000
7
-180,000
0
Determine the crossover point for these projects’ NPV profiles.
arrow_forward
Please help with formulas:
arrow_forward
General accounting question
arrow_forward
Relevant Cash Flow Data for Year 2:Sales revenues Year 2 $100,000Cost of Goods Sold 20,000Depreciation Expense 10,000Tax Rate 40%
Based on the above cash flow data: What is the operating cash flow for year two of this capital budgeting project?
A.130,000
B.52,000
C.42,000
D. 78,000
arrow_forward
Solve this general accounting question
arrow_forward
Answer in Excel, Attached it question.
arrow_forward
Complete the following 6 Wk 3 Financial Exercises: Problem Set 1, Part 2
problems:
1. Calculate the net present value (NPV) of the following cash flow stream if the
required rate is 12%:
Insert your NPV calculation.
Year
Cash Flow
Is this a good project for the business to accept? Explain why or why not.
Insert your answer.
2. Calculate the NPV of the following cash flow projections based on a required
rate of 10.5%:
Insert your NPV calculation.
Year
Cash Flow
Is this a good project for the business to accept? Explain why or why not.
Insert your answer.
3. A company needs to decide if it will move forward with 2 new products that it is
evaluating. The 2 initiatives have the following cash flow projections:
Project A
Project B
Year
Cash Flow
Year
Cash Flow
Based on the risk of each project, the company has a required rate of return of
11% for Project A and 11.5% for Project B. The company has a $1.5 million
budget to spend on new projects for the year. Should the company move forward…
arrow_forward
Spreadsheet Link What is the IRR of the following project?
Cash Flow
Year 0 32.000
9,000
2 10,000
15,200
3.
4.
7,800
1) 10.8%
2) 11.2%
• 3) 11.7%
4) 12.0%
5) 12.3%
arrow_forward
Consider the following investment projects.Year (n) Net Cash FlowProject 1 Project 20 -$1,200 -$2,0001 600 1,5002 1,000 1,000IRR 19.65% 17.54%Determine the range of MARR where project 2 would be preferred over project 1.(a) MARR … 12.5%(b) 13% … MARR … 15%(c) 16% … MARR(d) Not enough information to determine
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Related Questions
- Capital Budgeting Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these. Time Project A Cash Flows Project B Cash Flows 0 -$46,800 -$63,600 1 -21,600 20,400 2 43,200 20,400 3 43,200 20,400 4 43,200 20,400 5 -28,800 20,400 Sketch the NPV profile for projects A & B.arrow_forwardCapital Budgeting Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these. Time Project A Cash Flows Project B Cash Flows 0 -$46,800 -$63,600 1 -21,600 20,400 2 43,200 20,400 3 43,200 20,400 4 43,200 20,400 5 -28,800 20,400 Calculate the IRR and MIRR of projects A & B. Assume a reinvestment rate of 13% for the calculation of MIRR.arrow_forwardCapital Budgeting Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these. Time Project A Cash Flows Project B Cash Flows 0 -$46,800 -$63,600 1 -21,600 20,400 2 43,200 20,400 3 43,200 20,400 4 43,200 20,400 5 -28,800 20,400 Under what conditions on the cost of capital should project B be preferred to project A?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_forwardCapital Budgeting Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these. Time Project A Cash Flows Project B Cash Flows 0 -$46,800 -$63,600 1 -21,600 20,400 2 43,200 20,400 3 43,200 20,400 4 43,200 20,400 5 -28,800 20,400 Calculate the payback period and discounted payback period for projects A & B.arrow_forwardExercise 2 A fund begins with $10 million and reports the following three-month results (with negative figures in parentheses): Month: 1 2 Net cashflows (end of month, $ million) -10 -3.0 -5 18.486 HPR (%) 2.0 8.0 (4.0) Compute the arithmetic, time-weighted, and dollar-weighted average returns.arrow_forward
- Capital Budgeting Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 13% to evaluate projects such as these. Time Project A Cash Flows Project B Cash Flows 0 -$46,800 -$63,600 1 -21,600 20,400 2 43,200 20,400 3 43,200 20,400 4 43,200 20,400 5 -28,800 20,400 Assuming a cost of capital of 13%, which of these projects should be accepted?arrow_forwardVideo Excel Online Structured Activity: Capital budgeting criteria A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 + Project A -$300 -$387 Project B -$405 $133 -$193 -$100 $133 $133 $600 $133 $600 $133 $850 -$180 $133 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet a. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. Project A: $ 162.48 Project B: $ b. What is each project's IRR? Round your answer to two decimal places. Project A: 18.10 % Project B: %arrow_forwardCapital Budgeting Assume you are evaluating two mutually exclusive projects, the cash flows of which appear below and that your company uses a cost of capital of 12% to evaluate projects such as these. Time Project A Cash Flows Project B Cash Flows 0 -$300,000 -$405,000 1 -387,000 134,000 2 -193,000 134,000 3 -100,000 134,000 4 600,000 134,000 5 600,000 134,000 6 850,000 134,000 7 -180,000 0 Determine the crossover point for these projects’ NPV profiles.arrow_forward
- Please help with formulas:arrow_forwardGeneral accounting questionarrow_forwardRelevant Cash Flow Data for Year 2:Sales revenues Year 2 $100,000Cost of Goods Sold 20,000Depreciation Expense 10,000Tax Rate 40% Based on the above cash flow data: What is the operating cash flow for year two of this capital budgeting project? A.130,000 B.52,000 C.42,000 D. 78,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College