In:

Submitted By maisha5
Words 474
Pages 2
Spreadsheet Analysis & Modeling
MIS-505
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

Words: 1576 - Pages: 7

Free Essay

Words: 1137 - Pages: 5

#### Use of Spreadsheets in Business and Technology

Words: 949 - Pages: 4

#### 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 absolute. The...

Words: 849 - Pages: 4

#### Database Program vs. Spreadsheet Program

Words: 415 - Pages: 2

Free Essay

#### Unit 5 Group Project for Financial Management Excel Spreadsheet

...Cyrus Brown Manufacturing (CBM) Sales Budget March April May June July August September October November \$100,000 \$275,000 \$320,000 \$450,000 \$700,000 \$700,000 \$825,000 \$500,000 \$115,000 Cyrus Brown Manufacturing (CBM) Schedule of Cash Collections March April May June July August September October November Month of Sale (25%) \$25,000 \$68,750 \$80,000 \$112,500 \$175,000 \$175,000 \$206,250 \$125,000 \$28,750 Following Month (55%) \$55,000 \$151,250 \$176,000 \$247,500 \$385,000 \$385,000 \$453,750 \$275,000 Second Month (20%) \$20,000 \$55,000 \$64,000 \$90,000 \$140,000 \$140,000 \$165,000 Total Collections \$25,000 \$123,750 \$251,250 \$343,500 \$486,500 \$650,000 \$731,250 \$718,750 \$468,750 Cyrus Brown Manufacturing (CBM) Schedule of Cash Disbursements March April May June July August September October November Direct Manufacturing Costs \$187,500 \$206,250 \$375,000 \$337,500 \$431,250 \$640,000 \$395,000 \$425,000 Administrative Salaries \$35,000 \$35,000 \$35,000 \$35,000 \$35,000 \$35,000 \$35,000 \$35,000 \$35,000 Lease Payments \$15,000 \$15,000 \$15,000 \$15,000 \$15,000 \$15,000 \$15,000 \$15,000 \$15,000 Depreciation Charges \$15,000 \$15,000 \$15,000 \$15,000 \$15,000 \$15,000 \$15,000 \$15,000 \$15,000 New Plant Investment \$95,000 Income Tax \$55,000 \$55,000 Miscellaneous Costs \$10,000 \$10,000 \$10,000 \$10,000 \$10,000 \$10,000...

Words: 397 - Pages: 2

#### 1. Develop a Transportation Model for Shipping from the 6 Plants Directly to the 3 Disposal Sites. Describe and Implement the Model. Please See Tab One (Plant to Waste Shipment) of the Attached Spreadsheet After the

...the attached spreadsheet after the data was analyzed and dropped into the Excel Spreadsheet and the Data Solver was utilized to obtain the stated highlighted results. The cost is \$2,822 to ship. 2. Solve the model given in 1 and describe the results. The results of the model are as follows: 35 barrels per week from Kingsport Plant to Whitewater Waste Plant 26 barrels per week from Danville Plant to Duras Waste Plant 42 barrels per week from Macon Plant to Duras Waste Plant 1 barrel per week from Selma Plant to Whitewater Waste Plant 52 barrels per week from Selma Plant to Los Canos Waste Plant 29 barrels per week from Columbus Plant to Whitewater Waste Plant 28 barrels per week from Allentown Plant to Los Canos Waste Plant 10 barrels per week from Allentown Plant to Duras Waste Plant 3. Develop a transshipment model in which each of the plants and disposal sites can be used as intermediate points. Please see tab two (Intermediate Shipping) of the attached spreadsheet after the data was analyzed and dropped into the Excel Spreadsheet and the Data Solver was utilized to obtain the stated highlighted results. 4. Solve the model given in 3 and describe the results. The results of the model are shown on Row 4 and details the quantity of barrels that can be shipped per week to the intermediate points and then to the destined Waste Plants as highlighted in the spreadsheet. The cost is...

Words: 328 - Pages: 2

Free Essay

...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

...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 Project 11...

Words: 49278 - Pages: 198

...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

Words: 715 - Pages: 3

#### Finance

...[pic][pic] FIN 222 Corporate Finance Individual Major Assignment [80 marks] This manual outlines the followings. Objective of the assignment Details of questions (Instructions will be provided wherever necessary.) Format requirements Printing requirements Submission requirements ➢ Objective of the Assignment In Lecture 5 (CH11 and CH12), you were introduced to the concept of systematic risk, as measured by beta. Beta is an indicator of an asset’s exposure (or vulnerability) to systematic risk and evaluates the degree to which an asset’s return is correlated with the market return. Beta is 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...

Words: 3262 - Pages: 14

#### Lpp Through Excel

Words: 798 - Pages: 4