...Microsoft Excel for financial calculations? Microsoft Office Excel is a great computer program that is widely used throughout the financial industry. Excel is an invaluable tool in Finance and Accounting. Of course professionals also use special financial calculators. But a financial calculator can be expensive for students. It is not intuitive to use and unless they become investment bankers or realtors, most students will never use it after finishing the financial course. Fortunately, it is very easy to create a financial calculator for free if you have Excel on your computer. In fact, an Excel calculator can do much more than a dedicated financial calculator. Another advantage is the fact that if you learned how to use financial functions of Excel you will be able also to use a special financial calculator should the need arise. Below is a short introduction of how to start using MS Excel for financial calculations. Inserting Functions Excel comes with a wide array of functions that can easily be inserted into a spreadsheet. Adding a function is as easy as clicking on the "Insert Function" button on the top tool bar. Insert Function Button If you don't see the "Insert Function" button on your tool bar, you can easily add it by clicking: Tools > Customize > Commands > Find and click on Insert in the left-hand scroll-down menu. Then, find "Insert Function" in the right-hand scroll-down menu and click and drag it to your tool bar. Clicking on the "Insert Function" button...
Words: 488 - Pages: 2
...2013 Did not know there are so many functions for excel, some of the most useful tools in excel let you perform a variety of tasks automatically within a spreadsheet. They return different result depending on certain circumstance such as whether a particular condition is true or false. Excel includes a number of these functions that you can use to not only to make working with spreadsheets faster, but also to help ensure your accuracy. These functions let you code the decision-making process inside your worksheets rather than relying on the person who enters the data to make the choice and enter the result. For example, to see how a decision-making function can work, consider a situation where you charge a flat fee for shipping up to certain value of invoice and percentage of the invoice value above that. Instead of manually checking to see whether a flat fee or percentage value is appropriate and then entering the amount into a cell, you can have excel do the work for you. There are a number of Excel formulas that work in a similar way by allowing you to create one function to handle multiple situations. This is the IF function that I’m referring to, let's suppose we have a situation where the cost of shipping a product is $4.95 for any amount of product up to and including $20.00 in value and then 25 percent of the invoice price over that amount. The function looks like this: =IF (G15<=20, 4.95, G15*0.25). The syntax of the function reads: =IF (test, calculation or value...
Words: 298 - Pages: 2
...Financial Functions Using Microsoft Excel FV | PV | RATE | NPV | IRR | PMT | Printing Formulas | FV FV(rate,nper,pmt,pv,type) Rate is the interest rate per period. Nper is the total number of payment periods in an annuity. Pmt is the payment made each period; it cannot change over the life of the annuity. Pmt must be entered as a negative number. Pv is the present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero). PV must be entered as a negative number. Type is the number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0 which represents at the end of the period. If payments are due at the beginning of the period, type should be 1. PV PV(rate,nper,pmt,fv,type) Rate is the interest rate per period. For example, if you obtain an automobile loan at a 10 percent annual interest rate and make monthly payments, your interest rate per month is 10%/12, or 0.83%. You would enter 10%/12, or 0.83%, or 0.0083, into the formula as the rate. Nper is the total number of payment periods in an annuity. For example, if you get a four-year car loan and make monthly payments, your loan has 4*12 (or 48) periods. You would enter 48 into the formula for nper. Pmt is the payment made each period and cannot change over the life of the annuity. Pmt must be entered as a negative amount. Fv is the future value, or a cash balance you want to attain after the...
Words: 2368 - Pages: 10
...[데이터 입력] |단축키 |설 명 | |Alt + Enter |셀 안에 있는 내용 입력 시 새 줄을 만들어 줍니다. | |Ctrl + Enter |셀 범위를 지정한 후 내용을 입력하고 Ctrl+Enter를 누르면 셀 범위에 동일한 내용이 | | |채워집니다. | |Shift + Enter |셀 입력을 완료하고 위의 이전 셀을 선택합니다. | |Tab |셀 입력을 완료하고 오른쪽에 있는 다음 셀을 | | |선택합니다. | |Shift + Tab |셀 입력을 완료하고 왼쪽에 있는 이전 셀을 선택합니다. | |F4 또는 Ctrl + Y |바로 전에 작업한 내용을 반복합니다. | |Ctrl + Z |바로 전에 작업한 내용을 취소합니다. | |Ctrl + D |빈 셀에 데이터를 입력한 후 아래 셀로 이동하고 Ctrl+D를 누르면 동일한 내용이 | | |채워집니다. | |Ctrl + R |빈 셀에 데이터를 입력한 후 오른쪽 셀로 이동하고 Ctrl+R을 누르면 동일한 내용이 | | |채워집니다. ...
Words: 418 - Pages: 2
...Math 155 Excel Project / Lab 1 Spring 2014 Introduction to Excel and Supply/Demand Functions Chapters 0 and 1 50 points DUE DATE: the week of Feb 24 in the discussions or before 11:50 am on Feb 26. Late projects will be penalized by 10 points for each calendar day. Objectives: By the end of this lab, you should be comfortable with the following objectives: 1. Inputting a table and graph into Excel. (Technology Guide, Section 1.1, pages 116-117) 2. Understanding a supply and demand graph. (Example 4a, Section 1.2, page 118) 3. Plotting multiple sets of data on one graph in Excel. (Example 5, Section 1.2, page 119) Instructions: Work in your discussion groups. Your final product will be a typed document. Add a cover sheet with the names of all group members. Word problems should be answered using complete sentences and Standard American Written English. Rewrite each question in your document before answering it. The graph(s) you create in Excel should be labeled clearly and neatly pasted into the typed document (do not turn in any Excel spreadsheets for this document!). Equations and mathematical solutions should be entered using Equation Tools. Exercise 1 (10 points, specific to group members): Using the discussion of how to enter formulas into Excel on page 5 and page 116 of your textbook, have each group member write out one of the following functions as an Excel function: 1. 2. 3. 4. y= 4 x ¡ 6x y = (4 ¡ x)2 + 3x y = (2x ¡ 12)(2x2 + 3x) p y = 93 ¡ x2 x3 + 1...
Words: 899 - Pages: 4
...Pre-requisite Courses: Nil WELCOME TO THE CLASS Introduction: I look forward to have a fruitful and meaningful interaction with each one of you during the term. This will however depend on your active participation and attention during the class sessions and an active follow up afterwards. Course Description: The course will stress mainly on developing basics concepts of mathematics. It will include basic mathematical operations, factorization, solving first and second-degree equations, solving first and second-degree inequalities, analytical geometry (graph, linear equation – slope-intercept form), solving simultaneous equations, mathematical functions (concept of domain and range), quadratic functions, mathematics of finance and matrices. All topics will be discussed along with their applications. Some features of Microsoft Excel on graph and matrices are also included in the course. Course Objective: This is the first course in mathematics and the main objective of this course is to improve the level of quantitative abilities possessed by students and prepare them for the applications of mathematics in the courses like finance, economics, operations research, etc. Teaching Methodology & Requirements: Please arrive and leave on time. Class will begin promptly five minutes after the hour and will end exactly on the hour. Late arrivals and early departures disrupt class and ruin the presentations of others. They are unprofessional. Do your own work. Plagiarism...
Words: 876 - Pages: 4
...Technical Supplement 1 Linear Programming with Transportation in Operations Management LEARNING OBJECTIVES After studying this technical supplement, you should be able to: 1. Explain the importance of optimization to operations management 2. Demonstrate how to develop linear programming models 3. Show how linear programming models can be solved using EXCEL 4. Demonstrate 0-1, transportation, and assignment models LINEAR PROGRAMMING MODELS IN OPERATIONS MANAGEMENT Linear programming (LP) is one of the most powerful analytic tools available to improve operations management. LP provides the optimal, or best possible, solution to problems that can be formulated by a linear function subject to a set of linear constraints. This has proven extremely useful in many operations management applications, some of which are described in Table 1. TABLE 1 Linear Programming Models |Type of Model |Variables |Function to Optimize |Typical Constraints | |Product Mix |Number of products to produce |Maximize contribution to |Resource limits, such as time, | | | |profit |labor, material; Maximum or | | | | |minimum quantities | |Blending |Amount of materials to combine |Minimize cost |Resource limits; Demand...
Words: 5880 - Pages: 24
...Microsoft Excel 2010 Tutorial Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts. The Ribbon Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003 to Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features. Home Tab This is the most used tab; it incorporates all text and cell formatting features such as font and paragraph changes. The Home Tab also includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style. Insert Tab This tab allows you to insert a variety of items into a document from pictures, clip art, and headers and footers. Page Layout Tab This tab has commands to adjust page such as margins, orientation and themes. Created By: Amy Beauchemin Source: office.microsoft.com 1/13/11 2 Formulas Tab This tab has commands to use when creating Formulas. This tab holds an immense function library which can assist when creating any formula or function in your...
Words: 7496 - Pages: 30
...follows: In Excel, or other suitable program, develop a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites. Solve the model you developed in #1 (above) and clearly describe the results. In Excel, or other suitable program, Develop a transshipment model in which each of the plants and disposal sites can be used as intermediate points. Solve the model you developed in #3 (above) and clearly describe the results. Interpret the results and draw conclusions that address the question posed in the case problem. What are the limits of the study? Write at least one paragraph. There are two deliverables for this Case Problem, the Excel spreadsheets and an accompanying written description/explanation. Please submit both of them electronically via the dropbox. The assignment will be graded using the associated rubric. Outcome Assessed: Develop solutions for transshipment problems. Communicate issues in Management Science Grading Rubric for Stateline Shipping & Transport Case Problem There are 12 points in each of the five criteria for a total of 60 points possible Criteria 0 Unacceptable (0 points) 1 Developing (6 points) 2 Competent (9 points) 3 Exemplary (12 points) 1. Develop a transportation model for shipping from the 6 plants directly to the 3 disposal sites. Describe and implement the model. Did not submit or the objective function and/or constraints are specified with less than 70% accuracy. The objective function and constraints...
Words: 589 - Pages: 3
...Spreadsheet Modeling Assignment 1. Objectives The purpose of this assignment is to use some of the more advanced tools that Excel provides to develop a model of a complex business problem. In particular, you will use the following Excel features: 1. Importing data from text files 2. Sorting data 3. Database functions 4. Pivot Tables 5. Data Tables 6. Goal Seeking 2. What You Will Need 1. Access to a computer with a printer and Excel 2007. 2. Note that the instructions in this handout are written for Excel 2007. There are significant differences in user interface between Excel 2007 and 2003. 3. Download the following three files: Mymodel.xls, labor.txt, and demand.txt. 3. What You Will Hand In 1. a CD containing the model your group develops - on the outer label, write the course number, group number, the name of each group member 2. two full-page charts (with your course number and group number as a footer) 3. four worksheet printouts (with your course number and group number as a footer) 4. Make sure your CD is free of any computer virus. A contaminated CD will result in a 50% penalty in grade! 4. Due Date Check the course syllabus for assignment due date. A penalty will be assessed against assignments handed in late (including during class). 5. Background You work for the NOVA Corporation, a mid-tier supplier of hoses and hose assemblies...
Words: 4251 - Pages: 18
...a key parameter in the Capital Asset Pricing Model (CAPM) which is most commonly used asset pricing model for the estimation of required rate of returns on a share (i.e. cost of equity=rE). This assignment consists of two parts. Part I directs you to work with real financial data in Excel and aims to take you through the basic exercise of estimating a company beta and computing statistics which can be evaluated as part of investment decision-making process. Part II requires you to write a report based on interpretations of the outputs obtained from the first part. In this manual, you will also find out how to download historical share price, market index data and interest rates from the web portal. ➢ Details of Questions PART 1 [30 marks] To successfully complete PART 1, please read each section carefully. You must read “Format and printing requirement” before you produce any outputs. I also encourage you to read the entire manual before you choose your companies for analysis. If you have read “Format and printing requirement”, then proceed. Provide your answers (or outputs) for the following questions. All the calculations and computations are required to be produced in Excel (This manual has been designed for you to do this assignment using...
Words: 3262 - Pages: 14
...Types of Information Systems XACC 210 XXXXXXXXXXXXXX The type of information that we use in our accounting department is Yardi, and Microsoft Excel, and PowerPoint. Yardi Systems is the property management software leader for real estate clients worldwide. Yardi provides integrated property management software & investment management solutions for all real estate verticals allowing owners, managers, investors & other stakeholders access to information specific to their needs. Yardi is also used for our daily journal entries, payables, and receivables, and other accounting functions that we need to have interoffice transaction done between our other office in Philadelphia, Washington D.C.; New Castle, DE; Baltimore, MD; and Bordentown, NJ. The other information system that we use is Microsoft Excel we use it for all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager). It has a programming aspect, Visual Basic for Applications, allowing the us to employ a wide variety of numerical methods, for example...
Words: 325 - Pages: 2
...programs, like Microsoft Word or Microsoft Excel, for ease of access. Being able to import an Excel spreadsheet into the Microsoft Access database cuts down on the amount of duplicate data. Lastly, Access can help with the collaboration of different departments when reporting to higher levels. For example, Microsoft Access can be utilized: to create a profit/overhead report for the President/CEO of the company, to track how much product each salesperson sells for goal setting/keeping, or just to keep track of your employees’ payroll. Overall, Party Plates will benefit from the use of this program. Although Microsoft Excel spreadsheet does not qualify as a database, this application is extensively utilized to hoard data and is habitually employed in working out uncomplicated database tribulations, since it is a flat file database. However, it is very useful to convert data currently held in Microsoft Excel spreadsheets into a relational database using Microsoft Access. First, converting Excel data into a relational database through Access has the benefit of lesser inaccuracies and variations. The significance of whichever database is to stock up interrelated information in a single place, allowing the user to connect various entities together. Sustaining a single edition of data for the entities one requires tracking diminishes the prospective for replication, faults, and contradictory values. Secondly, converting data from Excel into a relational Access database also has...
Words: 616 - Pages: 3
...UNIT BRIEF Edexcel HND (Computing) Level 5 COMPUTER PLATFORMS 2011 EThames Graduate School. India 8-2-228 to 231 Punjagutta Cross Road Hyderabad 500082 Tel: +91 40 44432223 This handbook belongs to the following student; if found please hand in to Reception: NAME: ___________________________________________ Student ID: ________________________________________ |Unit Name: |Introduction to Computers | |Unit Number: | | |Course Duration: |09 Sessions | |Batch: |March, 2011 | |Tutor: |B Jagadish Chandra Reddy | A warm welcome to all the students enrolled for this unit. The unit handbook will give you a clear understanding of the aim and learning objectives of the unit. It will also portray the unit planning in terms of coverage, prerequisites for each session, tools and techniques used by the tutor and the level of efforts expected to be put by a student. It will make you aware of the assessment policy, assignment...
Words: 474 - Pages: 2
...USING MICROSOFT EXCEL 2013 Independent Project 4-4 Independent Project 4-4 Eller Software Services has received updated client information with sales numbers. You import the data into the worksheet, sort and filter it, and apply conditional formatting. You also format the data as an Excel table and create a PivotTable. Skills Covered in This Project Import a text file. Sort data Use an AutoFilter. Filter data by cell color. Copy, name, and move a worksheet. Use the Subtotal command. Apply Conditional Formatting. Clear filters and conditional formatting. Create an Excel table. Create a PivotTable. Protect a worksheet with a password. IMPORTANT: Download the resource file(s) needed for this project from the Resources link. Be sure to extract the file(s) after downloading the resources zipped folder. Please visit SIMnet Instant Help for step-by-step instructions. Step 1 Download start file 1. Open the EllerSales-04 start file. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it. 2. 3. Import the ClientInfo-04.txt file in cell A4. The text file is tab-delimited. 4. Unhide row 10. Fix the phone number in cell C12. 5. Set Conditional Formatting to show cells I5:I13 with Yellow Fill with Dark Yellow Text for values that are less than 1500. 6. Download Resources The file will be renamed automatically...
Words: 681 - Pages: 3
