Capital Budgeting Problems

BUS3062 Week 5 Assignment Template

Capital Budgeting

Solve the following problems. Create appropriate formulas using the supplied values in the co

esponding cells so Excel can calculate the answer. Example problems can be found on the "Capital Budgeting Example" tab below.

1. Compute the NPV statistic for Project Y. Explain whether or not the firm should accept or reject the project with the cash flows shown in the chart below if the appropriate cost of capital is 10 percent.

Year Cash Flow

0 -$8,000

1 $3,350

2 $4,180

3 $1,520

4 $300

NPV= [NPV Calc. here]

[Brief Explanation]

2. Compute the payback period statistic for Project X and recommend whether the firm should accept or reject the project with the cash flows shown in the chart if the maximum allowable payback is four years.

Year Cash Flow

0 -$1,450

1 $250

2 $380

3 $620

4 $1,000

5 $100

Payback period = [Answer here]

3. Two projects being considered are mutually exclusive and have the following projected cash flows: (Compute both NPV and IRR). The cost of capital is 10%.

Year Cash Flow A Cash Flow B

0 -$50,000 -$50,000

1 $15,625 $0

2 $15,625 $0

3 $15,625 $0

4 $15,625 $0

5 $15,625 $99,500

NPV = [Answer here] [Answer here]

IRR = [Answer here] [Answer here]

4. Los Angeles Lumber Company is considering a project with a cost of $1,000 initially, and inflows of $300 at the end of years 1-5. LALC’s cost of capital is 12 percent. What is the project’s IRR and NPV? IRR NPV

5. A Project has a cost of $65,000 and it's expected cash inflows are $12,000 per year for 9 years and the cost of capital is 10%. What is the project's IRR and MIRR? IRR MIRR

6. Explain which capital budgeting method is better, NPV, IRR or MIRR. [Answer here]

Capital Budgeting Example

TVM: NPV and IRR

Practice Problem Worksheet using Excel Formulas

A good understanding of the principles of capital budgeting theory and of capital budgeting measurement techniques is necessary in order to understand how to co

ectly calculate the Net Present Value and Internal Rate of Return statistics. Accordingly, it is recommended you thoroughly read and understand the M: Finance text, Chapter 13: Weighing Net Present Value and Other Capital Budgeting Criteria before reviewing the following problems and solutions.

Net Present Value (NPV) Calculation

Solving for the Net Present Value (NPV):

Problem 1: Here is a simple net present value (NPV) calculation problem:

What is the NPV statistic for the following indicated Cash Flows assuming

the appropriate cost of capital is: 14%

Time: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5

Cash Flow: -100,000 25,000 35,000 45,000 35,000 25,000

Solution: Using the Excel, Formulas, Financial, NPV formula that calculates the present values of cash flows from year 1 and beyond, and first entering the cash flow at time point 0 (outside of the NPV formula function) because cash at time point 0 does not require a present value calculation because the present value of an amount at time point 0 (or now) equals its stated value:

NPV = Minus Cash Outflow at time point 0 + [NPV (Int rate or cost of capital, CF Yr 1, CF Yr 2, CF Yr 3 … )

Solution inputting the numbers into the Excel NPV formula in the exact order prescribed by the formula (click on Cell B29 and/or B31 to see the contents of the cell as inputted):

NPV = $12,941.93 This approach uses the problem's numbers inputted into the formula.

NPV = $12,941.93 This approach uses the appropriate cells inputted into the formula.

Either approach is acceptable.

Is the above project desirable? Yes, since the project's NPV is greater than $0; the project is earning $12,941.93 more than its cost of capital.

Problem 2

What is the NPV statistic for the following indicated Cash Flows assuming the appropriate cost of capital is 11%.

11%

Time: Year 0 Year 1 Year 2 Year 3 Year 4

Cash Flow: -12,000 2,000 3,000 4,000 5,000

NPV = ($1,544.91) This approach uses the problem's numbers inputted into the formula.

NPV = ($1,544.91) This approach uses the appropriate cells inputted into the formula.

Either approach is acceptable.

Is the above project desirable? No, since the project's NPV is less than $0; the project is earning $1,544.91 less than the cost of capital.

Internal Rate of Return (IRR) Calculation

Solving for Internal Rate of Return (IRR) Problem 1:

What is the Internal Rate of Return for the following indicated Cash Flows?

Time: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5

Cash Flow: -100,000 25,000 35,000 45,000 35,000 25,000

Solution: Using the Excel, Formulas, Financial, IRR formula that reads as follows:

IRR = (Range of initial cash outflow and subsequent cash inflow values by year beginning at CF0)

Solution inputting the numbers into the Excel IRR formula in the exact order prescribed by the formula (click on Cell B75 and to see the contents of the cell as inputted):

IRR = 19% You need to adjust the B71 cell to allow showing additional decimals (at least 4 decimal places) as reflected in cell B72.

IRR = 19.16%

If we are now advised the firm's cost of capital is 14%, is the above project desirable? Yes, the project is desirable since the project's IRR of 19.16% is greater than the project's cost of capital of 14%. Notice you do not use the cost of capital to calculate IRR, however, you do compare the calculated IRR to the cost of capital that serves as the benchmark.

Problem 2

What is the Internal Rate of Return (IRR)for the following Cash Flows?

Time: Year 0 Year 1 Year 2 Year 3 Year 4

Cash Flow: -12,000 2,000 3,000 4,000 5,000

IRR = 6% You need to adjust the B87 cell to allow showing additional decimals (at least 4 decimal places) as reflected in cell B88.

IRR = 5.61%

If we are now advised that the firm's cost of capital is 11%, is the above project desirable? No, the project is not desirable since the project's IRR of 5.61% does not exceed the project's cost of capital of 11%. Notice you do not use the cost of capital to calculate IRR, however, you do compare the calculated IRR to the cost of capital that serves as the benchmark.

Answered 3 days AfterMar 13, 2022

Capital Budgeting Problems

BUS3062 Week 5 Assignment Template

Capital Budgeting

Solve the following problems. Create appropriate formulas using the supplied values in the co

esponding cells so Excel can calculate the answer. Example problems can be found on the "Capital Budgeting Example" tab below.

1. Compute the NPV statistic for Project Y. Explain whether or not the firm should accept or reject the project with the cash flows shown in the chart below if the appropriate cost of capital is 10 percent.

Year Cash Flow

0 -$8,000

1 $3,350

2 $4,180

3 $1,520

4 $300

NPV= $ -153.10

The firm not to accept the project because NPV is less than 0

2. Compute the payback period statistic for Project X and recommend whether the firm should accept or reject the project with the cash flows shown in the chart if the maximum allowable payback is four years.

Year Cash Flow

0 -$1,450

1 $250

2 $380

3 $620

4 $1,000

5 $100

Payback period = 3.2

The firm can accept the project because computed pay back years is less than company's expected pay back years.

3. Two projects being considered are mutually exclusive and have the following projected cash flows: (Compute both NPV and IRR). The cost of capital is 10%.

Year Cash Flow A Cash Flow B

0 -$50,000 -$50,000

1 $15,625 $0

2 $15,625 $0

3 $15,625 $0

4 $15,625 $0

5 $15,625 $99,500

NPV = $ 9,231.04 $ 11,781.67

IRR = 16.99% 14.75%

4. Los Angeles Lumber Company is considering a project with a cost of $1,000 initially, and inflows of $300 at the end of years 1-5. LALC’s cost of capital is 12 percent. What is the project’s IRR and NPV? 15.24% $ 81.43

5. A Project has a cost of $65,000 and it's expected cash inflows are $12,000 per year for 9 years and the cost of capital is 10%. What is the project's IRR and MIRR? 11.57% 10.75%

6. Explain which capital budgeting method is better, NPV, IRR or MIRR. NPV will calculate and...

BUS3062 Week 5 Assignment Template

Capital Budgeting

Solve the following problems. Create appropriate formulas using the supplied values in the co

esponding cells so Excel can calculate the answer. Example problems can be found on the "Capital Budgeting Example" tab below.

1. Compute the NPV statistic for Project Y. Explain whether or not the firm should accept or reject the project with the cash flows shown in the chart below if the appropriate cost of capital is 10 percent.

Year Cash Flow

0 -$8,000

1 $3,350

2 $4,180

3 $1,520

4 $300

NPV= $ -153.10

The firm not to accept the project because NPV is less than 0

2. Compute the payback period statistic for Project X and recommend whether the firm should accept or reject the project with the cash flows shown in the chart if the maximum allowable payback is four years.

Year Cash Flow

0 -$1,450

1 $250

2 $380

3 $620

4 $1,000

5 $100

Payback period = 3.2

The firm can accept the project because computed pay back years is less than company's expected pay back years.

3. Two projects being considered are mutually exclusive and have the following projected cash flows: (Compute both NPV and IRR). The cost of capital is 10%.

Year Cash Flow A Cash Flow B

0 -$50,000 -$50,000

1 $15,625 $0

2 $15,625 $0

3 $15,625 $0

4 $15,625 $0

5 $15,625 $99,500

NPV = $ 9,231.04 $ 11,781.67

IRR = 16.99% 14.75%

4. Los Angeles Lumber Company is considering a project with a cost of $1,000 initially, and inflows of $300 at the end of years 1-5. LALC’s cost of capital is 12 percent. What is the project’s IRR and NPV? 15.24% $ 81.43

5. A Project has a cost of $65,000 and it's expected cash inflows are $12,000 per year for 9 years and the cost of capital is 10%. What is the project's IRR and MIRR? 11.57% 10.75%

6. Explain which capital budgeting method is better, NPV, IRR or MIRR. NPV will calculate and...

SOLUTION.PDF## Answer To This Question Is Available To Download

- ACC 556 financial accounting for managersTargetCorporationWal-MartStores, Inc.Income Statement Data for YearNet sales$65,300$417,000Cost of goods sold45,000301,000Selling and administrative...SolvedMar 21, 2022
- Chipotle Name: You are a senior financial analyst for Chipotle and the new VP of Finance has asked for you to develop a high- level analysis of performance for the past two years (2019 vs 2018)...SolvedMar 20, 2022
- ACCT 7080Spring 2022Project Submission #220 PointsUsing the Word document provided answer the questions below. Project Submission #2 is due on 3/31/2022 by 11:59 pm. Upload this document to...SolvedMar 16, 2022
- Ivey Business CaseYou will use the case titled 'High Performance Tire' for the group project. To purchase the case, please click on the link...SolvedMar 13, 2022
- ASSIGNMENT INSTRUCTIONS Assessment e.g. Analytical report (use terms used in MDF) Assessment code: 010/011/012 (delete as appropriate – code appears on MDF) Academic Year: 2021/2022...SolvedMar 13, 2022
- Risk and ReturnBUS3062 Week 4 Assignment TemplateRisk and returnSolve the following problems and answer the last question. Create appropriate formulas using the supplied values in the...SolvedMar 08, 2022
- Please read through the types of (depreciation methods) applicable in the business world.When a business acquired "assets" tangible or intangible form, they must access which is most benefical during...SolvedMar 08, 2022
- Directions – Chapter 6 HOMEWORK Please try your best on these answers. The more you work on these the better off you will be for the test! THERE WILL BE VARIATION IN YOUR ANSWERS TO WHAT I HAVE...SolvedMar 07, 2022
- InputStatements Date7/31/21Current MonthJULStatements Year2021Beginning of the Current Month7/1/21For the Month Ended Jul 31, 2021Jul 31, 2021List of...SolvedMar 07, 2022
- losreyes_b.pdfLos Reyes Hospital (B)I’m very concerned about your department’s financial performance. We’d been planning on a surplus of about $74,000 from you, and you’ve run a deficit of over...SolvedMar 06, 2022

Copy and Paste Your Assignment Here

Disclaimer: The reference papers provided by TAE serve as model papers for students and are not to be submitted as it is. These papers are intended to be used for research and reference purposes only.

Copyright © 2022. All rights reserved.