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 over time The risk factors associated with an investment‚
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
Analysis in Capital Budgeting In today’s business environment‚ company executives are often required to participate in a company’s capital budgeting process as the sponsor‚ reviewer or approving authority of investment decisions. In any of these capacities‚ it is imperative that the executive understands many of the key aspects of capital budgeting such as analyzing income statements‚ balance sheets‚ cash flows‚ appropriately discounting cash flows and‚ most importantly‚ identifying risk. Capital budgeting
Premium Risk Investment Corporate finance
Johnnie & Sons Paints Inc. Capital Budgeting Decision SAMPLE PROJECT The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the paint cans instead of purchasing them. The equipment needed would cost $200‚000‚ with a disposal value of $40‚000‚ and would be able to produce 5‚000‚000 cans over the life of the machinery. The production department estimates that approximately 1‚000‚000 cans would be needed for
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
Application of Monte Carlo Simulation in Capital Budgeting | | |by Prit‚ Aug 2‚ 2008 | |The usefulness of Monte carlo Simulation in Capital Budgeting and the processes involved in Monte Carlo Simulation. It also | |highlights the advantages in some situation compared to other deterministic models where uncertainty is the norm. | |[pic]
Premium Monte Carlo methods in finance Randomness Capital budgeting
Memo To: Beth Davies-Lowry‚ President of Intercoastal Electronics Company From: Student Date: February 20‚ 2011 Re: Budgeting Impacting Company’s Financial Statements Scope and Objective Intercoastal Electronics Company is excited about the upcoming year‚ and is ready to acquire new inventory equipment in order to process a streamline operation for their small‚ rapidly growing consumer electronics products base. The acquisition of new assets
Premium Balance sheet Asset
Introduction Berger Paints Bangladesh Limited (BPBL) is a renowned paint company in Bangladesh. The Company was introduced on 6 June 1973 as a private co. limited by shares registered under the Company Act. In December 2005‚ the company issued 5% shares to the public and listed with Dhaka Stock Exchange (DSE) and Chittagong Stock Exchange (CSE). BPBL previously was known by Jenson & Nicholson (J & N). The name of the company was changed from J& N (Bangladesh) Limited to Berger Paints Bangladesh
Premium Financial ratios Inventory Financial ratio
Working Capital Management and Capital Budgeting Alexis A. Stoute University of Phoenix Finance for Business FIN/370 Terry Dowdy‚ PhD August 02‚ 2010 Working Capital Management and Capital Budgeting This week’s assignment focused on Working Capital Management and Capital Budgeting. As per the class syllabus‚ students were to formulate responses for questions 4-6A (Chapter 4) and 5-1A‚ 5-4A‚ 5-5A‚ and 5-6A (Chapter 5) from the book Financial Management: Principles and Applications
Premium Finance Investment Economics
Capital Budgeting Case Richard Hughes QRB/501 Robert Halle Capital Budgeting Case Our extensive research on two investment options yielded the decision that Corporation B is the company that our company has decided to acquire with a $250‚000 initial outlay. We have conducted 5-year income cash flow projections. Our company determined the Net Present Value (NPV) as well at the investment’s internal rate of return (IRR). When making a decision to purchase or invest in a company‚ a decision maker
Premium Net present value