In: Computers and Technology

Submitted By maisha5
Words 474
Pages 2
Spreadsheet Analysis & Modeling
Questions for Final Exam

1. What is name range? How can ranges be named? What are its uses? 2. What is lookup in Excel? What are the different kinds of lookup functions? What are its uses? 3. What is Index function? Write down the procedure of index function. What are its uses? 4. What is Match function? How you can write an Index and Match functions in a nested way? What are its uses? 5. Describe different kinds of text functions in Excel (such as left, right, mid). 6. How can you put date in Excel? What are its uses? 7. What is NETWORKINGDAYS function in Excel? What is NETWORKINGDAYS.INT function in Excel? What are its uses? 8. What is workday and WORKDAY.INT functions in Excel? What are its uses? 9. What is Net Present Value? How do NPV and XNPV function work in Excel? What are its uses? 10. What is internal rate of return (IRR)? How do IRR, XIRR, and MIRR work in Excel? What are its uses? 11. What is present value? How does PV function work? What are its uses? 12. What is Future Value? How does FV function work? What are its uses? 13. Write down the functions of PMT, PPMT, IPMT. How can you use these functions to prepare a loan amortization schedule? 14. Write down the function of IF Statement, AND, OR and XOR. 15. Describe different Time functions. What are its uses? 16. What is What If Analysis? Describe different kind of what if analysis. What are its uses? 17. What do you mean by Sensitivity Analysis? What are its uses? 18. Describe difference between What if analysis and sensitivity analysis. 19. What is data table? How do one-way and two-way data tables work in Excel? What are their uses? 20. What is scenario manager? Describe the process of using scenario manager. 21. What is the importance of sensitivity analysis?…...

Similar Documents

Decoupling the Univac Computer from Spreadsheets in Redundancy

...Decoupling the UNIVAC Computer from Spreadsheets in Redundancy Taras Mos Abstract The implications of embedded models have been farreaching and pervasive. Given the current status of lossless algorithms, computational biologists predictably desire the study of symmetric encryption, which embodies the confusing principles of e-voting technology. In order to fix this issue, we concentrate our efforts on demonstrating that Smalltalk and the location-identity split can collaborate to surmount this problem. the analysis of object-oriented languages. Furthermore, we validate that IPv6 and lambda calculus can interfere to surmount this riddle. The rest of this paper is organized as follows. We motivate the need for Boolean logic. Furthermore, to fulfill this objective, we concentrate our efforts on disproving that extreme programming and IPv7 can interact to answer this problem. To achieve this objective, we motivate a novel application for the investigation of compilers (Cutch), which we use to disconfirm that consistent hashing can be made robust, “smart”, and optimal. Ultimately, we conclude. 1 Introduction Many biologists would agree that, had it not been for Smalltalk, the improvement of gigabit switches might never have occurred. The influence on distributed cryptoanalysis of this has been adamantly opposed. Next, two properties make this method perfect: our heuristic requests symbiotic communication, without providing the UNIVAC computer, and also Cutch emulates......

Words: 2196 - Pages: 9

Use of Spreadsheets in Business and Technology

...Use of Spreadsheets in Business and Technology Marty Montgomery August 25, 2013 Many corporations depend on spreadsheets as a fundamental (Institute of Corporate Auditors, 2006) device in their financial reporting and operational processes. As a result, the use of spreadsheets is an essential part of the information and decision-making structure for these organizations. In developing and using spreadsheets, organizations need to balance their ease and flexibility against the value of reliable information for management’s application. As users of spreadsheet applications such as Microsoft Excel® or Lotus 1-2-3® have become more sophisticated, so have spreadsheets. Once used to support simple functions such as logging, tracking and totaling information, spreadsheets with enhanced formulas and built-in advanced features are now used to support such business functions as complex valuation models. The use of macros and multiple spreadsheets which are linked together allows users to build very complicated—and sometimes convoluted—models and other business functions with minimal or no documentation. In addition, these complex spreadsheets are not usually supported by the same control environment as formally-developed, purchased applications. For example, the developers and users of spreadsheets are usually not trained in structured programming, testing, version control or systems development life cycles, and spreadsheets are rarely restricted from unauthorized access by......

Words: 949 - Pages: 4

Spreadsheet Modeling

... SPREADSHEET MODELING IN CORPORATE FINANCE To accompany Principles of Corporate Finance by Brealey and Myers CRAIG W. HOLDEN Richard G. Brinkman Faculty Fellow and Associate Professor Kelley School of Business Indiana University Prentice Hall, Upper Saddle River, New Jersey 07458 To Kathryn, you’re the inspiration, and to Diana and Jimmy, with joy and pride. Craig CONTENTS Preface PART 1 TIME VALUE OF MONEY Chapter 1 Single Cash Flow 1.1 Present Value 1.2 Future Value Problems Chapter 2 Annuity 2.1 Present Value 2.2 Future Value 2.3 System of Four Annuity Variables Problems Chapter 3 Net Present Value 3.1 Constant Discount Rate 3.2 General Discount Rate Problems Chapter 4 Real and Inflation 4.1 Constant Discount Rate 4.2 General Discount Rate Problems Chapter 5 Loan Amortization 5.1 Basics 5.2 Sensitivity Analysis Problems PART 2 VALUATION Chapter 6 Bond Valuation 6.1 Basics 6.2 By Yield To Maturity 6.3 System Of Five Bond Variables 6.4 Dynamic Chart Problems Chapter 7 Stock Valuation 7.1 Two Stage 7.2 Dynamic Chart Problems Chapter 8 The Yield Curve 8.1 Obtaining It From Bond Listings 8.2 Using It To Price A Coupon Bond 8.3 Using It To Determine Forward Rates Problems Chapter 9 U.S. Yield Curve Dynamics 9.1 Dynamic Chart Problems PART 3 CAPITAL BUDGETING Chapter 10 Project NPV 10.1 Basics 10.2 Forecasting Cash Flows 10.3 Working Capital 10.4 Sensitivity Analysis Problems Chapter 11 Cost-Reducing......

Words: 49278 - Pages: 198

Bis 155 Data Analysis with Spreadsheets Final Exam

...1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: Note: This is a one part question. • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours.  • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax.  In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula.  In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather keep the payroll running on one worksheet or by assigning a new worksheet for each week. ......

Words: 2277 - Pages: 10

Business Computing Excel Spreadsheet

...Used: * Microsoft Excel 2007 (Home edition) * Microsoft Word 2008: (License No: 92464-513-2506215-12994) * Microsoft Expression Web (Student version) Attached Files: * Business Report.docx * Spreadsheet Assignment.xlsm * Website files * home.html * about.html * sit.html * work.html * registration.html * locate.html * contact.html * Formulae sheets Attempted the High Distinction Level Table of Contents 1.0 Executive Summary 3 2.0 Business Problem Opportunity 4 3.0 Recommendations (based on ‘What-if’ analysis) 5 3.1 Production targets 5 3.2 Fixed costs 5 3.3 Sales 6 4.0 Appendices 7 4.1 User instructions 7 1.0 Executive Summary Classic Offices is a company that manufactures and sells chairs. The recent recession of 2009 had a negative global effect on markets all over the world and Classic Offices was adversely affected too. Along with vital information such as income and commission figures, the increment of fixed costs and reduction of profits have been captured in the form of this user-friendly spreadsheet. This spreadsheet has been designed with the consideration of Classic Offices’ internal users in mind. To make interpretation of the spreadsheet easier: * Different years have been colour coded * Appropriate command buttons (e.g. ‘Home’, ‘Print’) are accompanied with icons Internal users of Classic Offices (mainly employees) will be able......

Words: 1137 - Pages: 5


...Strengths and Weaknesses of Each Spreadsheet (Teacher) Aims to help the teacher: * Recording Results * Tracking the Learners’ Progress Strengths: One of the strengths of the teacher’s spreadsheet was the use of conditional formatting. Conditional formatting was helpful by easily presenting data, by formatting a range of cells depending on certain grades or scores means that analysing and categorising data will much easier with a visual representation and the teacher can make more accurate conclusions. The way the tables are laid out, and by defining a range is very useful for a teacher when it comes to neatly organising a spreadsheet with many tables of class’s results. By defining a range means that tables are easy to input into formulae, and will help reduce errors. AutoSum is very beneficial to a teacher because it simply adds up an entire column without having to add each cell individually. This saves a lot of time, and helps reduce errors, especially if there is lots of students’ data. Weaknesses: Macros are not included in the spreadsheet, which would’ve been very useful for a teacher. Macros stop repetitive tasks being completed over and over again. This is useful as it saves a lot of time to the teacher, e.g. if they click a customised button which filters data or changes sheets. This will also improve the usability of the spreadsheet and make the data input easier. Goal seek, which also isn’t included in the spreadsheet, would also be very......

Words: 1576 - Pages: 7

Modeling and Solving Lp Problems in a Spreadsheet

...Modeling and Solving LP Problems in a Spreadsheet Chapter 3 C.T. Ragsdale. 2008. Spreadsheet Modeling & Decision Analysis, 5th E. Revised, Thompson 1 Section 1 EXCEL SOLVER 2 Introduction • Solving LP problems graphically is only possible when there are two decision variables • Few real-world LP have only two decision variables • Fortunately, we can now use spreadsheets to solve LP problems 3 LP Solvers • Conventional – MPS (IBM) – LINDO, GINO – GAMS – AMPL • Algebraic Language • Spreadsheet Modeling • The company that makes the Solver in Excel, Lotus 12-3, and Quattro Pro is Frontline Systems, Inc. Check out their web site: http://www.solver.com – Frontline Solver, Premium Solver, Risk Solver – What’s Best? 4 Steps in Implementing an LP Model in a Spreadsheet 1. Organize the data for the model on the spreadsheet. 2. Reserve separate cells in the spreadsheet for each decision variable in the model. 3. Create a formula in a cell in the spreadsheet that corresponds to the objective function. 4. For each constraint, create a formula in a separate cell in the spreadsheet that corresponds to the left-hand side (LHS) of the constraint. 5 The Simple Farm Model Again! max π = x1 + 1.5x2 s/t x1 + 2x2 ≤ 160 3x1 + 2x2 ≤ 240 x1 ≥ 0, x2 ≥ 0 6 Implementing the Model See file FarmEx original.xls 7 Cell Labels 8 How Solver Views the Model • Target cell - the cell in the spreadsheet that represents the objective......

Words: 2610 - Pages: 11

Database Program vs. Spreadsheet Program

...Database program Vs. Spreadsheet program When choosing which type of program you should use to manage your customer records, you need to know what the difference is between the two. Spreadsheets are designed to analyze data and sort list items, not for long-term storage of raw data. A spreadsheet should be used for ‘crunching’ numbers and storage of single list items. Spreadsheet programs provide the means for keeping inventory, statistical data modeling, and computing data. They also include graphing functions that allow for quick reporting and analysis of data. Spreadsheet programs are relatively easy to use, require little training to get started, and have the advantage that most data mangers are somewhat familiar with them. The disadvantages of spreadsheets include having to re-copy data over and over again to maintain it in separate data files, the inability to efficiently identify data errors, the lack of detailed sorting and querying abilities, and sharing violations among users wishing to view or change data at the same time. Additionally, spreadsheets are restricted to a finite number of records, and can require a large amount of hard-drive space for data storage. Databases require little or no duplication of data between information tables, and changes made to the data do not corrupt the programming. Databases offer better security to restrict users from accessing privileged information, and from changing coded information in the programming. Furthermore, the......

Words: 415 - Pages: 2

Relative vs. Absolute Cell References in Spreadsheets

...Relative vs. Absolute Cell References in Spreadsheets In working with spreadsheets, you need to know about relative vs. absolute cell references. Here is the issue: when you COPY A FORMULA that contains cell references, what happens to the cell references? Usually the CELL REFERENCES will CHANGE! If you copy a formula 2 rows to the right, then the cell references in the formula will shift 2 cells to the right. If you copy a formula 3 rows down and 1 row left, then the cell references in the formula will shift 3 rows down and 1 row left. These are called "relative" cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same. Place a "$" before a row number if you want that to always stay the same. For example, "$C$3" refers to cell C3, and "$C$3" will work exactly the same as "C3", expect when you copy the formula. Note: when entering formulas you can use the F4 key right after entering a cell reference to toggle among the different relative/absolute versions of that cell address. The trick in creating spreadsheets is deciding before you copy a formula what cell references in the formula you want to be relative and what you want to be absolute. If some cell references refer to input cells in the spreadsheet, you usually want those cells to be......

Words: 849 - Pages: 4

Spreadsheet Modelling

...Word Count: 587 This is my own unaided work . SPREADSHEET mODELLING Word Count: 587 . SPREADSHEET mODELLING Spreadsheet modelling As a future financial analyst my work will be based on analysing data from company’s gathered data spreadsheets. Hence it is crucial for my own career success to understand the importance of spreadsheet modelling and its implementation. As according to (Susan Coles, Jennifer Rowley, 1996) “The decision maker’s judgement must be exercised in the interpretation of the data and the final decision making.” There is no better way of benefiting my future career than developing advanced skills in modelling Excel. As I have learned from few articles I read about this subject, there are many advantages of excelling my skills so as problems I should look out for. Firstly, studying advanced Excel modelling not only helps students to build technological knowledge but “also largely improve their practical analytical skills and abilities.”(Junying, 2010). By studying how to model spreadsheets students get a real chance to see how actual data is analysed by spreadsheet build in models and help them to further their own analytical knowledge and see how it works in real life. I think it is hugely beneficial for students in their further real...

Words: 715 - Pages: 3

Business Spreadsheets

...Business Spreadsheets. Name: Course: Instructor: Institution: Date of submission: 1) Calculate X-Bar-Bar, R-Bar, and associated control limits using the data in the table above.  From the data we have, the X-Bar-Bar number can be seen at the top set of results titled Centre x-bar bar = 5.1 a. The R-Bar result is the “Center” result the bottom set of data is R-Bar. Therefore R-Bar = 1.083 2) Create X-Bar•R (Average & Range) Control Charts from the data in the table above.  The X-Bar Control Chart is shown below Control limits for the x - chart are: Control limits = x- bar ± A2 (MR) Control limits = 5.1 ± 0.729 *1.083 Control limits = 4.31 to 5.89 Control limits ranges between 4.31 to 5.89 The R Control Chart is shown below Control limits for R- chart are: Upper control limits = (MR) * D4 Upper control limits = 2.282 *1.083 Upper control limits = 2.47 Lower control limit = D3 * MR Lower control limit = 0 * 1.083 Lower control limit = 0 3) Discuss notable out-of-control conditions displayed in the completed X-Bar•R (Average & Range) Control Charts. We consider points outside the control limits. We do not consider runs, set of points within certain regions. From the X-Bar control chart, we can see that two points 19 and 21 are above the upper control limit. From the R-Chart we can see that one point, 18 is above the upper control limit. 4. If...

Words: 890 - Pages: 4


...Consulting Assessment HRM/326 Amanda L Conley August 17, 2015 Rick Lab Consulting Assessment The company that I am going to discuss is called Professor Plumb. This is a company that I have recently began working for and it is a well-known plumbing company that is also a sub-contractor for two large home improvement stores. The bulk of the company business is the work obtained from the sub-contracts, in performing installs of plumbing and appliance needs. There are two large markets in the Alabama area, there is the Birmingham region and the Montgomery region. We have a total of five technicians that are scheduled to take care of the servicing needs of the customers. The one thing that the company makes the most money on is going to be the installation and sales of hot water heaters, and therefore those calls take priority. The Birmingham region is the most recent acquired by the company owner, and there are not as many stores and business in this area. We as a company are focusing on the growth in sales of the hot water heaters in both regions and the building of more jobs in the Birmingham region. When looking at the focus and the needs of the company it is very important to ensure that the technicians are well trained and know and understand what is needed and expected of them. The company is struggling at this time with the acquisition of the new region and trying to make money and provide the funds for the overhead and more. We as a company have been trying...

Words: 819 - Pages: 4

Bis 221 Week 4 Sales Analysis Spreadsheet Bis221 Week 4 Sales Analysis Spreadsheet

...Security Breaches: Collaborative Summary Based on your Week Two collaborative learning team discussion: Write a 350- to 700-word summary of the discussion your team had about preventing security breaches in businesses in Week Two.  Click the Assignment Files tab to submit your assignment.   BIS 221 WEEK 4 Sales Analysis Spreadsheet Using the ABC Technologies Inc., Q1 2012 Sales spreadsheet, analyze the data on Q1 2012 Sales identifying the following: * Monthly sales by Region * Quarter One sales by Region * Monthly sales by Product * Quarter One sales by Product * Monthly sales by Region, by Sales people * Quarter One sales by Region, by Sales people * Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month, etc...  Create a spreadsheet formatted to present your analysis of the sales numbers to management. In your spreadsheet, use the following: * Use the SUM function * The date function * An additional math or statistical function of your choice * Fill colors to differential areas of your spreadsheet * Border lines to differential area of your spreadsheet  Click the Assignment Files tab to submit your assignment. BIS 221 WEEK 4 Wireless Technologies and Networks in the Work Environment Collaborative Summary Based on your Week Three collaborative learning team discussion: Write a 350- to 700-word summary of the discussion your team had about wireless technologies and......

Words: 880 - Pages: 4

Spreadsheet Problem

...Cumberland Industries' financial planners must forecast the company's financial results for the coming year. The forecast for many items will be based on sales, and any additional funds needed will be obtained as notes payable. a. Assuming the historical trend continues, what will sales be in 2010? Base your forecast on a spreadsheet regression analysis of the 2004-2009 sales data above, and include the summary output of the regression in your answer. By what percentage are sales predicted to increase in 2010 over 2009? Is the sales growth rate increasing or decreasing? Here are the company's historical sales. Hint: Use the Trend function to forecast sales for 2010. Year Sales Growth Rate 2004 129,215,000 2005 180,901,000 40.0% 2006 235,252,000 30.0% 2007 294,065,000 25.0% 2008 396,692,000 34.9% 2009 455,150,000 14.7% 2010 515,465,267 % Increase in Predicted Sales for 2010 over 2009: 2009 Sales 455,150,000 2010 Sales 515,465,267 % increase 13.25% Note: This growth rate has been declining over time. b. Cumberland’s management believes that the firm will actually experience a 20 percent increase in sales during 2010. Construct 2010 pro forma financial statements. Cumberland will not issue any new stock or long-term bonds. Assume Cumberland will carry forward its current amounts of short-term investments and notes payable, prior to calculating AFN. Assume that any Additional Funds Needed (AFN) will be raised as notes payable (if AFN is...

Words: 616 - Pages: 3

Bond Valuation Spreadsheet

...Week 3 DQ 2 Forecasting Methods Read Problem 6 in Chapter 6 of your textbook.  Calculate and answer parts a through d. Include all calculations and spreadsheets in your post. Explain why the moving average method was used instead of another forecasting method. What might be another forecasting method that could prove to be just as useful?  Your initial post should be 200-250  words. Below see the number of mergers that took place over a 12-year period in the savings and loan industry. |Year |  |Mergers |  |Year | |2005 |61 |52.6 |8.4 |70.56 | |2006 |83 |55.6 |27.4 |750.76 | |2007 |123 |63 |60 |3,600 | |2008 |97 |75.2 |21.8 |475.24 | |2009 |186 |85.6 |100.4 |10,080.16 | |2010 |225 |110 |115 |13,225 | |2011 |240 |142.8 ...

Words: 573 - Pages: 3

Ek Hazaaron Mein Meri Behna Hai (2011) | Weihnachtsmann Co. KG (6) | Code Black