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
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
Target Corporation: A Capital Budgeting Analysis Target Corporation was founded in 1902 and headquartered in Minneapolis‚ Minnesota. Target Corporation operates general merchandise and food discount stores throughout the United States. The company’s products range from household essentials‚ to electronics‚ to toys‚ to apparel and accessories‚ to home furnishings‚ to food and pet supplies. Most of the merchandise is sold under Target and SuperTarget trademarks‚ but it also sells under private-label
Premium Net present value Internal rate of return Target Corporation
better understanding of how Heritage Elementary School’s budget is determined‚ how funds are allocated‚ and the timeline in which a budget has to be developed and finalized. In referring to School District Budgeting (Hartman‚ 2003)‚ I concluded that my district uses a centralized approach to budgeting. Many decisions are made at the district level by our Business Manager‚ Steve Summers and Superintendent‚ Randy Guttenburg. The budgets for personnel costs‚ utilities‚ maintenance‚ technology‚ and textbooks
Premium High school Education Teacher
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
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
one of the most burning problems of nowadays. Now millions of chimneys‚ cars‚ buses‚ trucks all over the world exhaust fumes and harmful substances into the atmosphere. These poisoned substances pollute everything: air‚ land‚ water‚ birds and animals people. So‚ it is usually hard to breathe in the large cities where there are lots plants. Everything there is covered with soot and dirt. All these affect harmfully. Environmental pollution is one of the most acute problems of modern society. The Earth
Free Pollution Environmentalism
References: Local Chua (2003) stated in his “Heart to Heart Talk: Is Your Drinking Water Safe?” that Water purification is now both a science and a technology Foreign Gil and Passino (2004) purification of drinking water is a very important problem in environmental engineering Local Israel (2009) Potable or drinking water is a critical requirement of human life
Premium Drinking water Water