Spreadsheet Exercises Using Excel Learning Objective: These exercises are designed to familiarize you with a spreadsheet application software called MS Excel. After the completion of the lab‚ you should be able to: 1. work with MS Excel or other spreadsheet programs 2. use functions and formulas in a spreadsheet application software for calculation 3. explain what functions and formulas are‚ how they work‚ and the difference between them Formulas Well‚ a formula is a simple calculation
Premium Spreadsheet
this online NPV Calculation Tool http://finance.thinkanddone.com/online-n… we get the following NPV at 15% Net Cash Flows CF0 = -3000000 CF1 = 1100000 CF2 = 1450000 CF3 = 1300000 CF4 = 950000 Discounted Net Cash Flows DCF1 = 1100000/(1+0.15)^1 = 1100000/1.15 = 956521.74 DCF2 = 1450000/(1+0.15)^2 = 1450000/1.3225 = 1096408.32 DCF3 = 1300000/(1+0.15)^3 = 1300000/1.52087 = 854771.1 DCF4 = 950000/(1+0.15)^4 = 950000/1.74901 = 543165.58 NPV Calculation NPV = 956521.74 +
Premium Net present value Internal rate of return Cash flow
Value Net Present Value (NPV) is used in capital budgeting to analyze the profitability of an investment or project. NPV is found by subtracting the present value of the after-tax outflows from the present value of the after-tax inflows. Investments with a positive NPV increase shareholder value and those with a negative NPV reduce shareholder value. In order to compute the NPV for Worldwide Paper Company‚ we have to calculate the cash flow in capital budgeting of the project as below. | | 2007
Premium Investment Net present value Capital accumulation
Fast Forward MBA in Project Management by Eric Verzuh and started reading the chapter “Solving Common Project Problems”. Respond to the following items coherently: i. Which of the “problems” do they have? ii. Using the facts and your inferences from the case‚ describe what specific techniques‚ methods‚ documents‚ strategies‚ etc. they should use for each of the project management problems they have. iii. Explain for each technique‚ method‚ etc. why it will benefit the project to build the second
Premium Project management Earned value management Project manager
In the book Payback Time by Carl Deuker‚ the main character Mitch is an aspiring journalist that wants to write about very serious school topics. He hopes that it will build his portfolio to impress universities. When he finds out that he is not going to be the editor for his high school’s paper‚ he is very disappointed. Instead of Mitch being the editor he’s been assigned to write about the sports section. Mitch is overweight and even though he enjoys sports‚ being picked on about his weight kept
Premium Journalism High school Attention
2014 Etec 100 Dr. Wilson Chapter 10 Chapter ten introduces the topic of spread other cells. A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the X and Y locations. X locations‚ the columns‚ are nord sheets‚ A spreadsheet is an interactive computer application program for organization‚ analysis and storage of data in tabular form. Spreadsheets devel computerized oped as simulations of paper accounting worksheets. The program operates on data represented as cells of an array
Premium Application software Web page HTML
Figure 1: Cash flow comparison for 15 and 25 year term (NY) 9 Figure 2: Cash flow comparison for 15 and 25 year term (HK) 9 Figure 3: Revenue and Operating Expenses (HK) 10 List of Tables Table 1: List of Assumptions made for NPV analysis 4 Table 2: List of Limitations on NPV Analysis. 4 Table 3: Estimation of Resale value of Carrier @15th year 7 1. Introduction 1.1 Executive Summary Ocean Carriers Inc. (OCI) is an International provider of Marine transportation services mainly focussing on
Premium Net present value
FIN 320 EXCEL SHEET Problems Please solve the problems below using an excel sheet and the excel functions. 1) (15 pts) A firm is considering a project with an initial investment of $170‚000 and required return of 12%. The following cash flows are expected over the 8year life span of the project: Year Cash flows 1 35‚300 2 46‚200 3 50‚000 4 22‚620 5 15‚100 6 5‚200 7 11‚740 8 89‚300 a) Calculate the Net Present Value (NPV) of the project. Should the
Premium Cash flow Cash
Date: 6/5/2013 Re: Revenue Assessment Thank you for the opportunity to assess your sales data in order to provide recommendations for increasing your sales. The analysis and recommendations below are based on the data you provided‚ which covers a period from May 2004 through June 2006. The analysis below is based on this data alone. Therefore‚ our recommendations should be tempered by your knowledge of business realities and your market. Please let us know if we can answer any questions concerning
Premium Sales Revenue Marketing
What is a Spreadsheet? Honestly‚ when I first started this assignment‚ I really didn’t know what a spreadsheet was‚ etc. So I started at: http://en.wikipedia.org/wiki/Spreadsheet. I read that and got a good base of spreadsheets and the history. First of all‚ Microsoft Excel is the industry standard in spreadsheets (history on spreadsheets can be accessed at the above website address). With Excel‚ you can create a shared workbook and place it on a network location where several people can edit‚
Premium Spreadsheet Microsoft Microsoft Excel