FIN550_V-III_homework_capital_budgeting

You are considering the following two projects for investment:                               Project A                    Project B Year 0                 ($10000)                        ($5000) Year 1                     $3000                             $3000 Year 2                     $7000                              $4000 Year 3                      $9000                              $5000 You must conduct an analysis using your knowledge of capital budgeting (NPV, IRR ect, ) and time value of money to decide which of the options is better. All analysis must be done in Excel. (This will require all calculations to be done using cell references and excel functions). Your analysis will require you to: A. Calculate thefollowing values for the investment proposals: i. The payback period assuming end-of-the-year cash flows. ii. The discounted payback period assuming a required rate of return of 10% and ending of-the-year cash flows. iii. The NPV of each project. iv. The PI of each…

OPPfel Hospitality Consulting Inc. has two similar financial projects to offer one of its corporate clients in the hospitality industry. OPPfel wants to evaluate a set of capital budgeting projects and come up with the best decision according to the project’s IRR and PI for the client. NINV and NCF data for both of the projects are shown in the data table below: Year Project AR Project BF 0 -$100,000 -$100,000 1 $70,000 $20,000 2 $60,000 $50,000 3 $20,000 $100,000 If the minimum required rate of return is 10.00% for both of the capital budgeting projects, which one of the projects provides a better investment decision that OPPfel can consult to the its client?

You are a financial analyst for the Hittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12%. The projects’ expected net cash flows are as follows: Expected Net Cash Flows Year Project X Project Y 0 −$10,000 −$10,000 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000 3,500 a. Calculate each project’s payback period, net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), and profitability index (PI). b. Which project or projects should be accepted if they are independent? c. Which project should be accepted if they are mutually exclusive? d. How might a change in the cost of capital produce a conflict between the NPV and IRR rankings of these two projects? Would this conflict exist if r were 5%? (Hint: Plot the NPV profiles.) e. Why does the conflict exist?

Net Present Value (NPV) In this assignment, you are required to prepare a PowerPoint presentation reviewing 3 projects. You will calculate the NPV, IRR, and payback period for each project. Utilizing the capital budgeting calculations, you will need to select the best investment for the company. These calculations will be based on the following scenario: AIU Industries has 3 potential projects to consider, all with an initial cost of $1,250,000. The company prefers to reject any project with a 4-year cut-off period for recapturing initial cash outflow. Given the cost of capital rates and the future cash flow for each project, determine which project the company should accept. Project AProject Project U Cash Flow Year 1 250,000 450,000 250,000 Year 2 250,000 450,000 400,000 Year 3 250,000 450,000 600,000 Year 4 250,000 450,000 800,000 Year 5 400,000 400,000 200,000 Year 6 400,000 400,000 800,000 Year 7 400,000 400,000 600,000 Year 8 400,000 400,000 200,000 Cost of Capital 4% 6% 8%

You are a financial analyst for the Hittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12%. The projects' expected net cash flows are as follows: Expected Net Cash Flows Year Project X Project Y -S10,000 -$10,000 6,500 3,500 3,000 3,500 3,500 3,500 3,000 1,000 a. Calculate each project's payback period, net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), and profitability index (PI). b. Which project or projects should be accepted if they are independent? c. Which project should be accepted if they are mutually exclusive?

You are a financial analyst for the H Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each project is 12 percent. The projects’ expected net cash flows are as follows:   Expected Net Cash Flows Year Project X Project Y ($100,000) ($100,000) 60,500 40,000 30,000 40,000 30,000 40,000 10,000 40,000   Required: Calculate each project’s payback period, net present value (NPV) and Profitability Index (PI) Which project or projects should be accepted if they are independent? Which project should be accepted if they are mutually exclusive?

SUPERIOR Company Limited is considering the following projects for inclusion in its capital budget for year 2021.The projects have equal risks and the capital outlay required is as follows: Project Investment required Project  Investment Requirement  Return    $000 $000 1 24,000 5520 2 9600 3072 3 7000 980 4 4800 864 5 3200 640 6 1400 392 As the Divisional Manager, you are to decide which of the projects to accept. The company has a cost of capital of 15% with $60million available to the division for investment purposes.Required: Compute the total investment, total return on capital invested and residual income on each of the following assumptions, indicating the preferred project: The Company has a rule that all projects promising at least 20% or more should be accepted.  The divisional manager is evaluated on his ability to maximise his return on capital investment.  The divisional manager is expected to maximise residual income as computed by using…

Appelbaum Inc. is comparing several alternative capital budgeting projects as shown below:                                                                                          Projects                                                                                         A                  B                       C      Initial investment                                   $80,000      $120,000        $160,000 Present value of net cash flows             90,000         110,000          200,000 Using the net present value, how many of the projects are available?? Group of answer choices

You are a financial analyst for the Vincenzo Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each project is 12%. The projects’ expected net cash flows are as follows: Expected Net Cash Flows Year                       Project X                              Project Y 0                              ($10,000)                            ($10,000) 1                             6,500                                     3,500 2                             3,000                                     3,500 3                             3,000                                     3,500 4                             1,000                                     3,500     Calculate each project’s payback period, net present value (NPV), internal rate of return (IRR), and modified internal rate of return (MIRR). Which project or projects should be accepted if they are…

Brunko Hospitality Investment Associates have been approached to evaluate a set of capital budgeting projects. The expected net cash flows along with the initial outlays are represented in the data table below: Year Project 1 Project 2 0 -$250,000 -$250,000 1 $0 $120,000 2 $0 $120,000 3 $0 $120,000 4 $0 $120,000 5 $900,000 $120,000 This firm would like to evaluate the set of capital budgeting projects based on the NPV and IRR. If the minimum required rate of return is 13.00% for both of the projects, which project seems like a better investment to undertake?

Problem B: A firm must choose from six capital budgeting proposals outlined below.  The firm is subject to capital rationing and has a capital budget of Php 1,000,000; the firm's cost of capital is 15%. Project          Initial Investment(Php)       IRR        NPV (Php)   _______          __________________            ___                 ______         1                    200,000                    19%               100,000     2                   400,000                      17%                20,000     3                  250,000                      16%                 60,000     4                  200,000                      12%                  (5,000)     5                  150,000                     20%                  50,000    6                    400,000                    14.5%              150,000   *Using Internal Rate of Return approach of ranking projects, which projects should the firm accept?

Your employer is trying to select from a list of possible capital projects. The projects, along with their cost and benefits, are listed below. The capital budget available is $1 million. In addition to spending constraints, your employer would like to select at least 2 projects. Projects 4 and 5 cannot both be selected together. Formulate the problem as a linear program and determine the optimal solution. Project 1 Cost Net Present Value $260,000 $210,000 $720,000 $590,000 $570,000 $470,000 $490,000 3 $235,000 $215,000 4. $220,000 Which projects should be selected? Project 1 will Project 2 will Project 3 will Project 4 will Project 5 will

Part 3: Capital Budgeting and Project Evaluation Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product. It will require the company to buy a new equipment that will generate the same revenue for the company each year. The table below shows the initial and annual costs for each option. 3.1. Capital Budgeting Decision Making: Perform capital budgeting technique based on Equivalent Annual Cost (EAC) to advise the Company Management which option should be chosen if the relevant discount rate is 9%? Costs Option A Option B Initial Investment 1,400,000 1,500,000 Year 1 35,000 25,000 Year 2 35,000 25,000 Year 3 35,000 25,000 Year 4 35,000 25,000 Year 5   25,000 3.2. Risk Analysis and Project evaluation: Assume that the company finally chose Option B. It expects to sell 600,000 units of the new product for an average price of $15 per unit. The…

You are a financial analyst for the Waffle Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects A and B.  Each project has a cost of $50,000, and the cost of capital for each is 10%.  The projects’ expected net cash flows are as follows:      Expected Net Cash Flows Year Project A Project B 0 ($50,000) ($50,000) 1 25,000 15,000 2 20,000 15,000 3 10,000 15,000 4 5,000 15,000 5 5,000 15,000  Which project or projects should be accepted if they are independent?

You are a financial analyst for the Waffle Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects A and B.  Each project has a cost of $50,000, and the cost of capital for each is 10%.  The projects’ expected net cash flows are as follows:      Expected Net Cash Flows Year Project A Project B 0 ($50,000) ($50,000) 1 25,000 15,000 2 20,000 15,000 3 10,000 15,000 4 5,000 15,000 5 5,000 15,000 Which project should be accepted if they are mutually exclusive?

You are a financial analyst for the Waffle Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects A and B.  Each project has a cost of $50,000, and the cost of capital for each is 10%.  The projects’ expected net cash flows are as follows:      Expected Net Cash Flows Year Project A Project B 0 ($50,000) ($50,000) 1 25,000 15,000 2 20,000 15,000 3 10,000 15,000 4 5,000 15,000 5 5,000 15,000 Which project will you select if your decision was based solely on the project’s payback period?

You are a financial analyst for the Waffle Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects A and B.  Each project has a cost of $50,000, and the cost of capital for each is 10%.  The projects’ expected net cash flows are as follows:      Expected Net Cash Flows Year Project A Project B 0 ($50,000) ($50,000) 1 25,000 15,000 2 20,000 15,000 3 10,000 15,000 4 5,000 15,000 5 5,000 15,000 d. How might a change in the cost of capital produce a conflict between the NPV and IRR rankings of these two projects? Would this conflict exist if r were 6%? (Hint: Plot the NPV profiles.)

You are a financial analyst for the Waffle Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects A and B.  Each project has a cost of $50,000, and the cost of capital for each is 10%. The projects’ expected net cash flows are as follows:   Expected Net Cash Flows Year Project A Project B 0 ($50,000) ($50,000) 1 25,000 15,000 2 20,000 15,000 3 10,000 15,000 4 5,000 15,000 5 5,000 15,000   Calculate each project’s payback period, net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), and profitability index (PI). Which project will you select if your decision was based solely on the project’s payback period? Which project or projects should be accepted if they are independent? Which project should be accepted if they are mutually exclusive? d. How might a change in the cost of capital produce a conflict between the NPV and…

You are a financial analyst for the Waffle Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects A and B.  Each project has a cost of $50,000, and the cost of capital for each is 10%.  The projects’ expected net cash flows are as follows:      Expected Net Cash Flows Year Project A Project B 0 ($50,000) ($50,000) 1 25,000 15,000 2 20,000 15,000 3 10,000 15,000 4 5,000 15,000 5 5,000 15,000 Calculate each project’s payback period, net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), and profitability index (PI).

You are a financial analyst for the Brittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments: Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12%. The projects' expected net cash flows are shown in the table below. Expected Net Cash Flows Year Project X Project Y 0 – $10,000 – $10,000 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000 3,500   Use the Homework Student Workbook to calculate each project's net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), and profitability index (PI). Which project or projects should be accepted if they are independent? Which project or projects should be accepted if they are mutually exclusive?

You are a financial analyst for the Brittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments: Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12%. The projects' expected net cash flows are shown in the table below. Expected Net Cash Flows Year Project X Project Y 0 – $10,000 – $10,000 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000 3,500   Which project or projects should be accepted if they are independent? Which project or projects should be accepted if they are mutually exclusive?

Project (Capital Budgeting Techniques) Use an Excel spreadsheet to perform the calculations. Be sure to show all the necessary steps involved in the calculation. Attach both the Excel spreadsheet and the Word document for this project. Your division is considering two investment projects, each of which requires an up-front expenditure of $30 million. You estimate that the cost of capital is 8 % and that the investments will produce the following after-tax cash flows (in millions of dollars): Year Project A Project B 1 5 25 2 15 15 3 20 10 4 25 8 What is the payback period? What are its advantages and disadvantages? What is the payback period for each project? Calculate the NPV and IRR of the two projects. If the two projects are independent and the cost of capital is 8 %, which project or projects should the firm undertake? Briefly discuss merits and demerits of NPV rule for decision making. If the two projects are mutually exclusive and the cost of capital is 8%,…

.Assume you are the chief financial officer at Lehman Memorial Hospital. The CEO has asked you to analyze two proposed capital investment Project X and project Y each project requires a net investment outlay of $12,000 and the opportunity cost of capital for each project is 14% the project's expected net cash flows are as following Year Project x Project Y 0 (12,000) (12,000) 1 6,600 3,500 2 3,500 3,500 3 3,500 3,500 4 3,500 3,500   Calculate each project’s payback, NPV and IRR.   Which project is financially acceptable? Explain

(d)    State which project you would recommend to Dreamon Corporation if ONE project can be selected (i.e. mutually exclusive). Give reason to support your decision.

Capital Budgeting Decisions A college intern working at Anderson Paints evaluated potential investments using the firm’s average required rate of return (r) as the discount rate in the evaluation process and he produced the following report for you as the capital budgeting manager at Anderson Paints: Project                         NPV                IRR                 Risk LOM                           $1,500             12.5%              High QUE                            0                      11.0                 Low YUP                           (800)               10.0                 Average DOG                          (150)               9.5                   Low As the capital investment manager you must account for the risks associated with capital budgeting projects before making final recommendations and decisions. The company’s capital investment risk management policy calls for an adjustment of the firm’s average required rate of return by plus/minus 2% if a project’s…