"Management Decision Analysis" 1. Discounted cash flow and budget cut analysis for a long lasting institute. A famous university was planning to prepare a ten-year continuous expenditure as a necessary investment for the renovation of the faculty buildings, i.e., 800 million Yuan per year in the next ten years are required for an extra expenditure beside all other needs of operations of the university. The project committee were considering a budget cut from the "current" annual budget of 7 billion per year. What could be an adequate rate of budget cut that you should want to suggest? Discuss about the influence of the interest rate used in the computation. Requirement: Write a VBA function "AnnuityFactor" to compute annuity factor to be used in the analysis, for skill enhancement

"Management Decision Analysis" 1. Discounted cash flow and budget cut analysis for a long lasting institute. A famous university was planning to prepare a ten-year continuous expenditure as a necessary investment for the renovation of the faculty buildings, i.e., 800 million Yuan per year in the next ten years are required for an extra expenditure beside all other needs of operations of the university. The project committee were considering a budget cut from the "current" annual budget of 7 billion per year. What could be an adequate rate of budget cut that you should want to suggest? Discuss about the influence of the interest rate used in the computation. Requirement: Write a VBA function "AnnuityFactor" to compute annuity factor to be used in the analysis, for skill enhancement

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter10: The Basics Of Capital Budgeting: Evaluating Cash Flows

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

An investment center in Shellforth Corporation was asked to identify three proposals for its capital budget. Details of those proposals are as follows. Capital Budget Proposals Capital required Annual operating return $ 96,000 $ 60,000 20,400 $ 180,000 16,200 24,960 Shellforth uses residual income to evaluate all capital budgeting projects. Its minimum required return is 10 percent. a-1. Assume you are the investment center manager. Calculate the residual income for each project? a-2. Which project do you prefer? b-1. Assume your investment center's current ROI is 18 percent and that the president of Shellforth is thinking about using ROI for the investment center's evaluation. Calculate the ROI for each project? b-2. Would your preferences for the projects listed change? Complete this question by entering your answers in the tabs below. Reg A1 Req A2 Req B1 Req B2 Assume you are the investment center manager. Calculate the residual income for each project? Project A Project B Project…
The net present value of a project with an initial outflow of $1,100,000 and annual cash income of $240,000 per year for 9 years is (assume an annuity factor of 5.7590) : a. $66,980 b. $126,980 c. $182,160 d. $282,160 Which of the following is an advantage of the budgeting process? 1. It forces management to focus on the past and not be distracted by the day-to-day operations of the business. 2. It can communicate to employees specific information about their past performance to determine their promotion prospects. 3. It can communicate to employees specific information about their past performance to determine their promotion prospects. 4. It can communicate to employees information about their performance expectations in the period ahead. Which one of the following statements regarding changing inventory costing methods is true? 1. A change in inventory methods can be justified if the change is made to better match profits with revenue 2. Changing inventory costing methods…
Problems. Problem 1. A division in a large company has been allocated $160 million for capital projects this year. Managers have proposed five projects for the budgeting committee to consider. The committee would like to maximize the total NPV. What projects should be selected? • There is one project of each type, each project has an estimated NPV (net present value, a measurement of profit) and each requires a capital expenditure (this comes out of the budget above). • At least 2 projects must be done. • If Project 5 is chosen, Project 1 must be done as well. Project 1 Project 2 Project 3 Project 4 Project 5 NPV (in millions of $) 10 17 16 8 14 Expenditure (millions of $) 48 96 80 32 64 a. What are your decision variables (x)? State the units for each. b. Write down your objective function (include min/max with the equation) and constraints below, include descriptions/explanations/calculations on the right. Delete/add rows as needed. (objective function above, constraints below)
Senior management asks you to recommend a decision on which project(s) to accept based on the cash flow forecasts provided. Relevant information: The firm uses a 3-year cutoff when using the payback method. The hurdle rate used to evaluate capital budgeting projects is 15%. The cash flows for projects A, B and C are provided below. Project A Project B Project C Year 0 -30,000 -20,000 -50,000 Year 1 0 4,000 20,000 Year 2 7,000 5,000 20,000 Year 3 20,000 6,000 20,000 Year 4 20,000 7,000 5,000 Year 5 10,000 8,000 5,000 Year 6 5,000 9,000 5,000 Calculate the net present value (NPV) for each project in excel. Which projects would you accept based on the NPV criterion?
Senior management asks you to recommend a decision on which project(s) to accept based on the cash flow forecasts provided. Relevant information: The firm uses a 3-year cutoff when using the payback method. The hurdle rate used to evaluate capital budgeting projects is 15%. The cash flows for projects A, B and C are provided below. Project A Project B Project C Year 0 -30,000 -20,000 -50,000 Year 1 0 4,000 20,000 Year 2 7,000 5,000 20,000 Year 3 20,000 6,000 20,000 Year 4 20,000 7,000 5,000 Year 5 10,000 8,000 5,000 Year 6 5,000 9,000 5,000 Calculate the internal rate of return (IRR) for each project in excel Which projects would you accept based on the IRR criterion?
Senior management asks you to recommend a decision on which project(s) to accept based on the cash flow forecasts provided. Relevant information: The firm uses a 3-year cutoff when using the payback method. The hurdle rate used to evaluate capital budgeting projects is 15%. The cash flows for projects A, B and C are provided below. Project A Project B Project C Year 0 -30,000 -20,000 -50,000 Year 1 0 4,000 20,000 Year 2 7,000 5,000 20,000 Year 3 20,000 6,000 20,000 Year 4 20,000 7,000 5,000 Year 5 10,000 8,000 5,000 Year 6 5,000 9,000 5,000 Calculate the payback period for each project. Which project(s) would you accept based on the payback criterion?
Simple Investment Allocation Case: This year, 2022 ABM Company selected your team to manage their allotted budget amounting to 10 million pesos for investment diversification portfolio. Your team was assigned to handle the said account. Question: How would you allocate funds?
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…
Suppose a company has the following three projects and limits it capital budget to $50,000. Projects Present Value of Cash Inflows Initial Investment A $40,000 $25,000 B 37,500 25,000 70,000 50,000 1. Calculate the projects' NPVSS. 2. Calculate the projects' Pls. 3. Which project(s) should the company choose? Why?
Capital Budget Methods The private buildings company wants to invest in one of the following two projects because of the lack of funds to invest in both (the case of the money technicians) if you know that each of the projects costs 200 thousand dinars, and the cost of capital in the company 9% as the director of the company wishes a recovery period of 7 years, if the net cash flows in the interior of the two projects as follows: End of the year Cash flows inward Project A Project B 1 20000 25000 2 40000 25000 3 60000 25000 4 20000 25000 5 40000 25000 What is required is: Calculate the recovery period, the discounted recovery period for each project, which project you choose, and why?
Capital budgeting PARCO is considering a new project that complements its existing business. The machine required for the project costs $3.9 million. The marketing department predicts that sales related to the project will be $2.35 million per year for the next four years, after which the market will cease to The machine will be depreciated down to zero over its four-year economic life using the straight-line method. Cost of goods sold and operating expenses related to the project are predicted to be 25 percent of sales. PARCO also needs to add net working capital of $150,000 immediately. The additional net working capital will be recovered in full at the end of the project’s life. The corporate tax rate is 30 percent. The required rate of return for PARCO is 13 percent. Should PARCO proceed with the project?
Suppose a company has the following three projects and limits it capital budget to $50,000. Projects Present Value of Cash Inflows Initial Investment A $40,000 $25,000 B 37,500 25,000 70,000 50,000 1. Calculate the projects' NPVs. 2. Calculate the projects' PIs. 3. Which project(s) should the company choose? Why?