Office.com Page 1 of 5 Support / Excel / Excel 2003 Help and How-to / Excel for your job / Finance Improve your capital budgeting techniques Applies to: Microsoft Office Excel 2003‚ PowerPoint 2003 By BearingPoint Capital budgeting is a financial analysis tool that applies quantitative analysis to support strong management decisions. Using capital budgeting analysis‚ you can explain: l l l The benefit impact of an investment decision over time The cost impact of an investment decision
Premium Capital budgeting Investment Net present value
Globalizing the Cost of Capital Budgeting at AES Chia yun ‚Tsai(Debbie) 2013/3/22 The reason why Rob Venerus used the cost of capital concept to improve upon what AES had used in the past for a discount rate is because the old model always used the same discount rate for the model. However‚ with electricity generating businesses around the world‚ the old model started to cause some problems. In the past‚ AES used the same cost of capital for all of its capital budgeting‚ but the company’s international
Premium Currency United States dollar Capital
Part I A. Present Value with Discount rate of 7% = 15000/(1+7%) = 15000/1.07 = $14‚018.69 Present Value with Discount rate of 4% = 15000/(1+4%) = 15000/1.04 = $14‚423.08 B. Account A - Present Value with Discount rate of 6% = 6500/(1+6%) = 6500/1.06 = $6‚132.08 Account B - Present Value with Discount rate of 6% = 12600/(1+6%)^2 = 12600/1.1236 = $11‚213.96 C. Present Value of Gold Mine 7% = 4900000/1.07 + 61‚000‚000/(1.07)^2 + 85‚000‚000/(1.07)^3 = 45‚794‚392.52 + 61‚000‚000/1.1449 + 85
Premium Net present value Cash flow Internal rate of return
Question 1c In order to create the criteria for the committee we have to look at what they want from the project. Most businesses and organisations are in business to make a profit‚ however the committee has different aims and objectives compared to a normal business or organisation. They need to weight up the options of each proposal and decide which best relates to their aims and objectives. When the committee is considering which proposal to go with they should consider the following categories
Premium Term Variance Time
Name: _____________________________ ID: ___________________ Section: ______ 1. Adler Enterprises is considering a project that has the following cash flow and WACC data. What is the project’s NPV? Note that a project’s projected NPV can be negative‚ in which case it will be rejected. WACC: 10.00% Year: 0 1 2 3 Cash flows: -$1‚000 $450 $460 $470 Answer: 142.37 2. Choi Computer Systems is considering a project that has the following cash flow data. What is the project’s IRR
Premium Net present value Internal rate of return Cash flow
Part 5 Long-Term Investment Decisions Chapters in This Part 10 11 12 Capital Budgeting Techniques Capital Budgeting Cash Flows Risk and Refinements in Capital Budgeting INTEGRATIVE CASE 5 Lasting Impressions Company robably nothing that financial managers do is more important to the long-term success of a company than making good investment decisions. The term capital budgeting describes the process for evaluating and selecting investment projects. Often‚ capital expenditures can be very large
Premium Net present value
Case Study Assignments Week 1: Robin Hood Completed. Week 2: Dell Inc. in 2008: Can it Overtake Hewlett-Packard as the Worldwide Leader in Personal Computers? Week 3: Southwest Airlines in 2008: Culture‚ Values‚ and Operating Practices Midterm Exam: Competition in the Movie Rental Industry in 2008: Netflix and Blockbuster Battle for Market Leadership Answer the following questions from the list below: Questions 1‚ 2‚ 4‚ 5‚ 6‚ 9‚ 10‚ 11‚ 12‚ and 13 Week 4: PepsiCo’s Diversification
Premium Strategic management Porter generic strategies Dell
Nguyen Thanh Tuan – MBA06043 Dr. Ann Ericson Financial Management 18 January 2013 An arguable capital budgeting decision in Intel’s Financial Plan 2013 Thursday 17 January 2013‚ Thomson Reuters‚ the world’s largest international multimedia news agency‚ has highlighted some concerns about Intel’s Financial Plan 2013. Noel Randewich‚ the report’s writer‚ thought Intel Corporation ’s current-quarter revenue forecast disappointed Wall Street analysts. The reason behind is Intel will spend more
Premium Computer Investment Personal computer
INS Chapter 16 Additional Topics in International Capital Budgeting questions 1. Why should the required rate of return for a capital budgeting problem be project specific? Doesn’t the firm just have to satisfy an overall cost-of-capital requirement? Answer: The required rate of return for a capital budgeting problem is project specific because the firm is viewed as a portfolio of projects owned by the shareholders. It is the shareholder’s perspective that matters‚ and it is their
Premium Exchange rate Net present value Interest
The capital budgeting proposals consists of five distinct but interrelated steps: 1) Proposal generation: Proposals are made at all levels within a business organization and are reviewed by the finance personnel. Proposals that require large outlays are more carefully scrutinized than less costly ones. 2) Review and analysis: Formal review and analysis is performed to assess the appropriateness of proposals and evaluate their economic viability. Once the analysis is complete‚ a summary report
Premium Generally Accepted Accounting Principles Economics Cost-benefit analysis