Free Essay

Succeeding in Business Using Excel 2013 Chapter 5

In:

Submitted By mastergirl
Words 3779
Pages 16
Chapter 5: Retrieving Data for Computation, Analysis, and Reference

TRUE/FALSE

1. A data list that categorizes values you want to retrieve is called a linkup table.

ANS: F PTS: 1 REF: 291

2. A vertical lookup table is a lookup table in which the data to be searched is organized in columns.

ANS: T PTS: 1 REF: 294

3. When you write a VLOOKUP formula, you indicate the value you want to look up in a table.

ANS: T PTS: 1 REF: 294

4. If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP opens up the Lookup Wizard.

ANS: F PTS: 1 REF: 297

5. When using a VLOOKUP function it’s not always obvious when a returned value is incorrect.

ANS: T PTS: 1 REF: 298

6. When you use a lookup type of TRUE, the VLOOKUP function looks only for an exact match of the lookup value.

ANS: F PTS: 1 REF: 299

7. Headings at the top of each column should be included as part of the lookup_range in the VLOOKUP formula.

ANS: F PTS: 1 REF: 301

8. When creating a vertical lookup table with the TRUE type, be certain to start with the lowest possible value, such as 0, so that the table covers all the possible data.

ANS: T PTS: 1 REF: 301

9. The syntax of the HLOOKUP function is as follows: HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

ANS: T PTS: 1 REF: 303

10. The rules for an HLOOKUP function with a TRUE lookup type test the values down the first column.

ANS: F PTS: 1 REF: 304

11. A table_array argument must contain relative cell references so that the row values will not change when the formula is copied down the column.

ANS: F PTS: 1 REF: 305

12. You can use a VLOOKUP formula and an HLOOKUP formula to retrieve data stored in lookup tables on the same worksheet.

ANS: T PTS: 1 REF: 307

13. Range names copy absolutely.

ANS: T PTS: 1 REF: 310

14. Unlike VLOOKUP, the RLOOKUP function looks up the greatest value that does not exceed a specified value anywhere in a table or range.

ANS: F PTS: 1 REF: 312

15. You can often use a LOOKUP function instead of a VLOOKUP or HLOOKUP function with a TRUE lookup type.

ANS: T PTS: 1 REF: 313

16. LOOKUP has both a TRUE and a FALSE lookup type.

ANS: F PTS: 1 REF: 314

17. The INDEX function allows you to retrieve data from multidimensional tables.

ANS: T PTS: 1 REF: 315

18. In a one-dimensional table, Excel searches one dimension, such as the columns, and then searches another dimension, such as the rows, to find the value at the intersection of a single row and column.

ANS: F PTS: 1 REF: 316

19. You cannot use VLOOKUP, HLOOKUP, or LOOKUP functions with a two-dimensional table.

ANS: T PTS: 1 REF: 316

20. The INDEX function allows you to specify a list of nonadjacent ranges as the reference argument, and then specify which of these ranges to use in the area_num argument.

ANS: T PTS: 1 REF: 317

MODIFIED TRUE/FALSE

1. The V in VLOOKUP stands for velocity. ____________________

ANS: F vertical Vertical

PTS: 1 REF: 294

2. In VLOOKUP, if a type FALSE is specified, an exact or approximate match is returned. ____________________

ANS: F
TRUE
True true PTS: 1 REF: 297

3. Internal values are those pieces of data that you know, such as customer names, quantities, or product descriptions. ____________________

ANS: F, Key

PTS: 1 REF: 301

4. When you use the HLOOKUP function, you specify the row_index_num. ____________________

ANS: T PTS: 1 REF: 303

5. The Lookup function argument called Lookup_Vector is the location of the data you want to look up. ____________________

ANS: T PTS: 1 REF: 312

6. In a two-dimensional table, Excel can search a row or column to find key data, and then use that data to locate the correct value. ____________________

ANS: F, one

PTS: 1 REF: 316

7. If you want to use the INDEX function to retrieve data stored in more than one range, be certain to store all the lookup ranges on the same computer. ____________________

ANS: F, worksheet

PTS: 1 REF: 322

8. Excel provides nine functions, called the OF functions, that test a value or cell reference, and then return a TRUE or FALSE value depending on the results. ____________________

ANS: F, IS

PTS: 1 REF: 330

9. You can use the ISEMPTY function to test a cell reference. ____________________

ANS: F
ISBLANK
Isblank isblank PTS: 1 REF: 330

10. The IS function called ISLOGICAL is for values that refer to a logical value. ____________________

ANS: T PTS: 1 REF: 331

11. A function named IFWRONG can be used in combination with the VLOOKUP function to simplify error checking. ____________________

ANS: F, IFERROR

PTS: 1 REF: 332

12. The syntax of the CHOOSE function is as follows: =CHOOSE(index_num,value1,value2,…). ____________________

ANS: T PTS: 1 REF: 336

13. The final argument of the VLOOKUP function is the range_lookup type, which can be TRUE or FALSE. ____________________

ANS: T PTS: 1 REF: 338

14. The syntax of the INDEX function is as follows: INDEX(value,row_num,column_num,area_num). ____________________

ANS: F, reference

PTS: 1 REF: 343

15. The MATCH function is designed to return the relative position (such as 1, 2, or 3) of an item in a list. ____________________

ANS: T PTS: 1 REF: 346

MULTIPLE CHOICE

1. A data list that categorizes values you want to retrieve is called a ____.
a.|lookup table|c.|query table|
b.|list table|d.|help table|

ANS: A PTS: 1 REF: 291

2. You use VLOOKUP when the ____ of the lookup table contains the data you are looking up.
a.|the first column|c.|any column|
b.|the last column|d.|all columns|

ANS: A PTS: 1 REF: 294

3. The data you are looking up is also called the ____.
a.|key data|c.|important data|
b.|look data|d.|clean data|

ANS: A PTS: 1 REF: 294

4. When you write a VLOOKUP formula, you indicate the value you want to look up in a ____.
a.|table|c.|graph|
b.|chart|d.|list|

ANS: A PTS: 1 REF: 294

5. VLOOKUP searches for a matching value in the leftmost column of the table, and then retrieves the value ____.
a.|in the same row but in another column that you specify|
b.|in the same column but in another row that you specify|
c.|anywhere in the table|
d.|in the same row, in the very next column|

ANS: A PTS: 1 REF: 294

6. The syntax of the VLOOKUP function is as follows: =VLOOKUP(lookup_value,table_array,col_index_num,____).
a.|lookup_range|c.|row_index_num|
b.|range_lookup|d.|table_value|

ANS: B PTS: 1 REF: 294

7. In a VLOOKUP function, the argument ____ refers to the data you want to look up.
a.|lookup_value|c.|col_index_num|
b.|table_array|d.|range_lookup|

ANS: A PTS: 1 REF: 294

8. In a VLOOKUP function, the argument ____ refers to the range containing the data that you want to search to find the lookup value.
a.|lookup_value|c.|col_index_num|
b.|table_array|d.|range_lookup|

ANS: B PTS: 1 REF: 294

9. In a VLOOKUP function, the argument ____ refers to the number of the column containing the data you want to retrieve.
a.|lookup_value|c.|col_index_num|
b.|table_array|d.|range_lookup|

ANS: C PTS: 1 REF: 294

10. In a VLOOKUP function, the argument ____ refers to the type of lookup you want to perform—TRUE or FALSE.
a.|lookup_value|c.|col_index_num|
b.|table_array|d.|range_lookup|

ANS: D PTS: 1 REF: 294

11. With a ____ type of VLOOKUP, the function would look only for the exact match.
a.|FALSE|c.|complex|
b.|TRUE|d.|simple|

ANS: A PTS: 1 REF: 294

12. With a ____ type of VLOOKUP, the function returns the greatest value that does not exceed the lookup value.
a.|FALSE|c.|complex|
b.|TRUE|d.|simple|

ANS: B PTS: 1 REF: 294

13. If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the ____ error value.
a.|#N/A|c.|#ERROR#|
b.|##|d.|@#@#|

ANS: A PTS: 1 REF: 297

14. When creating a range for use with a type TRUE VLOOKUP table, make sure to sort the values in the first column of table_array in ____ order.
a.|descending|c.|alphabetical|
b.|ascending|d.|numerical|

ANS: B PTS: 1 REF: 297

15. When creating a range for use with a type FALSE VLOOKUP table, make sure to sort the values in the first column of table_array in ____ order.
a.|descending|c.|alphabetical|
b.|ascending|d.|any (values do not need to be sorted)|

ANS: D PTS: 1 REF: 297

16. In a FALSE VLOOKUP, if an exact match is not found, ____ is returned.
a.|an error value|c.|the first value in the column|
b.|an approximate match|d.|the last value in the column|

ANS: A PTS: 1 REF: 297

17. To find and retrieve data from a vertical lookup table in the most efficient way, create a simple worksheet that contains related data, and organize this data in ____ to form the vertical lookup table.
a.|columns|c.|either a or b|
b.|rows|d.|neither a nor b|

ANS: A PTS: 1 REF: 301

18. For a VLOOKUP table, list the key values in ____.
a.|the last column|c.|the first column|
b.|any column|d.|the first row|

ANS: C PTS: 1 REF: 301

19. A VLOOKUP table can have ____ key value(s) in each cell of its first column.
a.|one|c.|three|
b.|two|d.|four or more|

ANS: A PTS: 1 REF: 301

20. If you have a valid range that is not in ascending order, you can sort it using the ____ commands in the Editing group on the Home tab on the Ribbon.
a.|Sort|c.|Range|
b.|Order|d.|Data|

ANS: A PTS: 1 REF: 302

21. The H in HLOOKUP stands for ____.
a.|help|c.|historic|
b.|horizontal|d.|hit|

ANS: B PTS: 1 REF: 303

22. When solving an HLOOKUP formula, Excel looks up a value by testing for a criterion across a ____.
a.|row|c.|table|
b.|column|d.|worksheet|

ANS: A PTS: 1 REF: 303

23. The syntax of the HLOOKUP function is as follows: LOOKUP(lookup_value,_____,row_index_num,range_lookup).
a.|table_index|c.|table_range|
b.|table_array|d.|table_row|

ANS: B PTS: 1 REF: 303

24. The first row (key values) of the lookup table must be sorted in ____ order to use an HLOOKUP function with a TRUE lookup type.
a.|ascending|c.|alphabetical|
b.|descending|d.|numerical|

ANS: A PTS: 1 REF: 304

25. To return a negative value, _____ is a correct formula.
a.|=–HLOOKUP(F14,I$7:K$9,3,TRUE)*H14|
b.|=(NEGATIVE)HLOOKUP(F14,I$7:K$9,3,TRUE)*H14|
c.|=(0)HLOOKUP(F14,I$7:K$9,3,TRUE)*H14|
d.|none of the above|

ANS: A PTS: 1 REF: 305

26. Note that the table_array argument must contain ____ cell references so that the row values will not change when the formula is copied down the column.
a.|absolute|c.|simple|
b.|relative|d.|complex|

ANS: A PTS: 1 REF: 305

27. You can use VLOOKUP and HLOOKUP to retrieve data stored in lookup tables on ____.
a.|the same worksheet|c.|either a or b|
b.|other worksheets|d.|neither a nor b|

ANS: C PTS: 1 REF: 307

28. If the values you want to look up are in column B and the values to retrieve are in column A, you can use the ____ function.
a.|VLOOKUP|c.|either a or b|
b.|LOOKUP|d.|neither a nor b|

ANS: B PTS: 1 REF: 312

29. The ____ function looks up the greatest value that does not exceed a specified value anywhere in a table or range.
a.|HLOOKUP|c.|LOOKUP|
b.|VLOOKUP|d.|all of the above|

ANS: C PTS: 1 REF: 312

30. LOOKUP also uses a ____ lookup type, so the column or row containing the lookup values must be in ascending order.
a.|TRUE|c.|both a and b|
b.|FALSE|d.|neither a nor b|

ANS: A PTS: 1 REF: 312

31. The syntax of the LOOKUP function is as follows: LOOKUP(____,lookup_vector,result_vector).
a.|lookup_value|c.|lookup_range|
b.|lookup_reference|d.|lookup_index|

ANS: A PTS: 1 REF: 312

32. In a LOOKUP function, the argument ____ refers to the data you want to look up.
a.|lookup_value|c.|result_vector|
b.|lookup_vector|d.|lookup_range|

ANS: A PTS: 1 REF: 312

33. In a LOOKUP function, the argument ____ refers to the location of the data you want to look up.
a.|lookup_value|c.|result_vector|
b.|lookup_vector|d.|lookup_range|

ANS: B PTS: 1 REF: 312

34. In a LOOKUP function, the argument ____ refers to the location of the data you want to retrieve.
a.|lookup_value|c.|result_vector|
b.|lookup_vector|d.|lookup_range|

ANS: C PTS: 1 REF: 312

35. You can only use a LOOKUP function when you want to retrieve a value that is stored to the ____ of a key data column in a vertical lookup table.
a.|left|c.|either a or b|
b.|right|d.|neither a nor b|

ANS: A PTS: 1 REF: 313

36. You can only use a LOOKUP function when you want to retrieve a value that is stored ____ a key data row in a horizontal lookup table.
a.|above|c.|either a or b|
b.|below|d.|neither a nor b|

ANS: A PTS: 1 REF: 313

37. As with the VLOOKUP and HLOOKUP functions with the TRUE lookup type, the ____ function looks for a value that matches the criterion by comparing values based on their position in the lookup table.
a.|POSITION|c.|LINK|
b.|LOOKUP|d.|LIST|

ANS: B PTS: 1 REF: 313

38. If the lookup_value is less than the smallest value in the lookup_vector, LOOKUP displays ____.
a.|an error symbol|c.|the number zero|
b.|the LOOKUP wizard|d.|the number 100|

ANS: A PTS: 1 REF: 314

39. The LOOKUP function has the _____ lookup type.
a.|TRUE|c.|either a or b|
b.|FALSE|d.|neither a nor b|

ANS: A PTS: 1 REF: 314

40. The _____ at the beginning of the formula indicates that Excel should display the results as a negative value.
a.|negative sign|c.|(0)|
b.|double negative sign|d.|none of the above|

ANS: A PTS: 1 REF: 314

41. The ____ function allows you to retrieve data from multidimensional tables.
a.|INDEX|c.|VLOOKUP|
b.|LOOKUP|d.|HLOOKUP|

ANS: A PTS: 1 REF: 315

42. In a(n) ____ table, Excel can search a row or column to find key data, and then use that data to locate the correct value.
a.|one-dimensional|c.|three-dimensional|
b.|two-dimensional|d.|none of the above|

ANS: A PTS: 1 REF: 316

43. In a(n) ____ table, Excel searches one dimension, such as the columns, and then searches another dimension, such as the rows, to find the value at the intersection of a single row and column.
a.|one-dimensional|c.|three-dimensional|
b.|two-dimensional|d.|none of the above|

ANS: B PTS: 1 REF: 316

44. In an INDEX function, the argument ____ refers to the range containing the data you want to find.
a.|reference|c.|column_num|
b.|row_num|d.|area_num|

ANS: A PTS: 1 REF: 317

45. In an INDEX function, the argument ____ refers to the number of the row in the range referenced in the first argument.
a.|reference|c.|column_num|
b.|row_num|d.|area_num|

ANS: B PTS: 1 REF: 317

46. In an INDEX function, the argument ____ refers to the column in the range referenced in the first argument.
a.|reference|c.|column_num|
b.|row_num|d.|area_num|

ANS: C PTS: 1 REF: 317

47. In an INDEX function, the argument ____ refers to the part of a nonadjacent range referenced in the first argument.
a.|reference|c.|column_num|
b.|row_num|d.|area_num|

ANS: D PTS: 1 REF: 317

48. The INDEX function allows you to specify a list of nonadjacent ranges as the reference argument, and then specify which of these ranges to use in the ____ argument.
a.|reference|c.|column_num|
b.|row_num|d.|area_num|

ANS: D PTS: 1 REF: 319

49. The INDEX function can solve for ____.
a.|no variables|c.|one or two variables only|
b.|one variable only|d.|two or more variables|

ANS: D PTS: 1 REF: 319

50. With the INDEX function, if you are using a noncontiguous range, you must enclose the entire reference in ____.
a.|quotation marks|c.|parentheses|
b.|brackets|d.|none of the above|

ANS: C PTS: 1 REF: 322

51. With the INDEX function, if you specify ____ contiguous range(s), you can omit the area_num argument.
a.|only one|c.|two or more|
b.|one or two|d.|three or more|

ANS: A PTS: 1 REF: 322

52. You can use the INDEX function to look up data stored in a single row, such as B3:E3, or a single column, such as B3:B7. In this case, you enter the range as the ____.
a.|first argument|c.|third argument|
b.|second argument|d.|fourth argument|

ANS: A PTS: 1 REF: 322

53. When using an INDEX function, if you enter a row_num, column_num, or area_num outside of the range you referenced in the first argument, Excel displays ____.
a.|an error message|c.|the next nearest column or row|
b.|the INDEX wizard|d.|none of the above|

ANS: A PTS: 1 REF: 322

54. When using an INDEX function, you can use a row_num of ____ to retrieve all the values in a specified column.
a.|0|c.|100|
b.|.01|d.|10|

ANS: A PTS: 1 REF: 322

55. If you do use an INDEX formula that refers to ranges on separate worksheets, Excel displays the ____ error message.
a.|#VALUE|c.|#ERROR|
b.|#REF!|d.|none of the above|

ANS: A PTS: 1 REF: 322

56. Excel provides nine functions, called the ____ functions, that test a value or cell reference, and then return a TRUE or FALSE value depending on the results.
a.|IS|c.|OR|
b.|IF|d.|OF|

ANS: A PTS: 1 REF: 330

57. The ISBLANK function checks whether a specified value refers to an empty cell. The syntax of this function is as follows: ____.
a.|ISBLANK(value)|c.|ISBLANK(reference)|
b.|ISBLANK(value,reference)|d.|ISBLANK(reference,value)|

ANS: A PTS: 1 REF: 331

58. In the formula =IF(ISBLANK(A9)," ",VLOOKUP(A9,Products,2,FALSE)), if A9 is blank, Excel displays ____.
a.|a string of empty characters|c.|the word “FALSE”|
b.|the word “products”|d.|the error “#VALUE”|

ANS: A PTS: 1 REF: 331

59. The function named IFERROR combines aspects of the IF function and the ____ function.
a.|OFERROR|c.|ISBLANK|
b.|ISERROR|d.|VLOOKUP|

ANS: B PTS: 1 REF: 332

60. The ISBLANK function tests for a(n)____.
a.|blank cell|
b.|error message resulting from the use of a blank cell in your formula|
c.|both a and b|
d.|neither a nor b|

ANS: A PTS: 1 REF: 332

61. The syntax of the IFERROR function is ____.
a.|=IFERROR(value_if_error, value)|c.|=IFERROR(value, range)|
b.|=IFERROR(value, value_if_error)|d.|=IFERROR(value, vector_lookup)|

ANS: B PTS: 1 REF: 333

62. The CHOOSE function can return a value or a range for up to ____ different values.
a.|12|c.|202|
b.|157|d.|254|

ANS: D PTS: 1 REF: 336

63. The syntax of the CHOOSE function is as follows: ____.
a.|=CHOOSE(index_num,value1,value2,…)|c.|=CHOOSE(value1, value2,...)|
b.|=CHOOSE(num_index,value1,value2,...)|d.|=CHOOSE(range_num,value1,value2,...)|

ANS: A PTS: 1 REF: 336

64. When using the CHOOSE function, if the index_num argument is 2, the function returns the ____.
a.|first value from the list|c.|an error message|
b.|second value from the list|d.|the first value that equals “2”|

ANS: B PTS: 1 REF: 336

65. When using the CHOOSE function, if the index_num argument is less than 1 or greater than the last value in the list, the function displays the error ____.
a.|#VALUE!|c.|#REF|
b.|#NAME|d.|#ERROR|

ANS: A PTS: 1 REF: 336

66. When using the CHOOSE function, if the index_num is a fraction, it is truncated to the ____ before being used.
a.|lowest integer|c.|first decimal place|
b.|highest integer|d.|second decimal place|

ANS: A PTS: 1 REF: 336

67. The ____ function is designed to return the relative position (such as 1, 2, or 3) of an item in a list.
a.|MATCH|c.|POSITION|
b.|RELATIVE|d.|LIST|

ANS: A PTS: 1 REF: 346

68. If you use a match_type of 0 (exact match), you can use the ____ to match any sequence of characters.
a.|asterisk (*)|c.|exclamation point (!)|
b.|question mark (?)|d.|dollar sign ($)|

ANS: B PTS: 1 REF: 346

69. When testing a worksheet, it’s best to use numbers like ____ for testing.
a.|10, 100, 1000|c.|13, 27, 88|
b.|12, 124, 248|d.|1, 77, 129|

ANS: A PTS: 1 REF: 346

70. One effective way to verify accuracy in a worksheet is to create an order with ____ set(s) of entries, and then systematically vary each entry to test each formula and cell that contains a value.
a.|one|c.|three|
b.|two|d.|four or more|

ANS: A PTS: 1 REF: 349

Case-Based Critical Thinking Questions
Case 5-1

Violet is learning how to use the MATCH function and is testing several different formulas. The chart above shows orders for small robot toys from 5 different customers. The amount “0” in column A is for a customer who changed his mind. Please answer the questions below using the data in the figure above.

71. Violet wants to send any orders for 30 toys or less to Warehouse 1 to ship out. To do this she locates the position in the chart where the greatest value does not exceed 30. The formula is ____.
a.|=MATCH(30,A1:E1,0)|c.|=MATCH(30>,A1:E1,1)|
b.|=MATCH(30,A1:E1,1)|d.|=MATCH(30=A1:E1,-1)|
b.|MATCH(31,A1:E1,0)|d.|MATCH(31

Similar Documents

Premium Essay

Financial Management

...© Nikada/iStockphoto.com Chapter 28 Time Value of Money © Cengage Learning. All rights reserved. No distribution allowed without express authorization. In Chapter 1, we saw that the primary objective of financial management is to maximize the intrinsic value of a firm’s stock. We also saw that stock values depend on the timing of the cash flows investors expect from an investment—a dollar expected sooner is worth more than a dollar expected further in the future. Therefore, it is essential for financial managers to understand the time value of money and its impact on stock prices. In this chapter we will explain exactly how the timing of cash flows affects asset values and rates of return. The principles of time value analysis have many applications, including retirement planning, loan payment schedules, and decisions to invest (or not) in new equipment. In fact, of all the concepts used in finance, none is more important than the time value of money (TVM), also called discounted cash flow (DCF) analysis. Time value concepts are used throughout the remainder of the book, so it is vital that you understand the material in this chapter and be able to work the chapter’s problems before you move on to other topics.1 There are no Beginning-of-Chapter Questions for this chapter. 1. The problems can be worked with either a calculator or an Excel spreadsheet. Calculator manuals tend to be long and complicated, partly because they cover a number of topics that aren’t used in...

Words: 27451 - Pages: 110

Free Essay

Mktg Syllabus

...Marketing  Management   MKTG  5150,  007,  077,  080,  086   Fall  2013  8W     Instructor:       Kenneth  N.  Thompson,  Ph.D.    Professor  of  Marketing  &  Logistics     Office  Hours:  1:30  –  3:30  TTh  and  by  appointment     E-­‐mail:  kenneth.thompson@unt.edu.  Only  use  this  e-­‐mail  address  if  you  cannot  reach  me   via  the  Blackboard  Learn  e-­‐mail  facility.    Use  the  ‘e-­‐mail’  selection  on  the  Learn  menu  bar   (left  side  of  the  Learn  window).  E-­‐mail  traffic  initiated  via  Blackboard  Learn  is  specifically   flagged  to  get  my  attention.      By  the  way,  do  not  expect  me  to  respond  to  e-­‐mail  on   weekends  or  after  5:00  p.m.  on  weeknights.    I  am  often  online  during  these  times,  but  there   are  no  guarantees  with  my  extensive  travel  schedule  this  Summer.       Roger  Kerin  and  Robert  Peterson  (2010),  Strategic  Marketing  Problems:  Cases  and   Comments,  12th  Ed.  (Upper  Saddle  River,  NJ:    Pearson  Prentice  Hall)  ISBN-­‐13:  978-­‐0-­‐13-­‐...

Words: 6865 - Pages: 28

Premium Essay

Business

...*IS1347* //integrafs1/cengage/3-Pagination/Cengage_US/Business_and_Economics/FFM13e/3B2/brigham_endpaper.3d, 11/16/11, 17:35, page: 1 FREQUENTLY USED SYMBOLS/ABBREVIATIONS ACP Average collection period ADR American depository receipt AFN Additional funds needed AMT Alternative minimum tax APR b Annual percentage rate Beta coefficient, a measure of an asset’s riskiness bL Levered beta bU Unlevered beta BEP BVPS CAPEX CAPM CCC Basic earning power Book value per share Capital expenditures Capital Asset Pricing Model Cash conversion cycle CF Cash flow; CFt is the cash flow in Period t CR Conversion ratio CV Coefficient of variation Dp Dividend of preferred stock Dt Dividend in Period t DCF Discounted cash flow D/E Debt-to-equity ratio DEP Depreciation D1/P0 DPS DRIP Expected dividend yield Dividends per share Dividend reinvestment plan DRP Default risk premium DSO Days sales outstanding e Approximately equal to 2.7183 EAA Equivalent annual annuity EAR Effective annual rate, EFF% EBIT EBITDA EPS EVA F Earnings before interest and taxes; operating income Earnings before interest, taxes, depreciation, and amortization Earnings per share Economic value added (1) Fixed operating costs (2) Flotation cost FCF Free cash flow FVN Future value for Year N FVAN g GAAP HVN I IFRS IPER I/YR INT IP IPO IRR LIBOR ...

Words: 199840 - Pages: 800

Premium Essay

Project Management

...An Introduction to Project Management, Fifth Edition By Kathy Schwalbe Professor Emeritus, Augsburg College Department of Business Administration Minneapolis, Minnesota An Introduction to Project Management, Fifth Edition Cover Photo: Dan Schwalbe ©2015 Schwalbe Publishing ISBN-13: 978-1505212099 ISBN-10: 150521209X ALL RIGHTS RESERVED. No part of this work covered by the copyright hereon may be reproduced, transmitted, stored, or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the author. Materials from Kathy Schwalbe’s Information Technology Project Management, Sixth and Seventh Editions, are used with permission from Cengage Learning. Microsoft and the Office logo are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. All screenshots from Microsoft products are used with permission from Microsoft. Information and screenshots from MindView Business are used with permission from MatchWare. Information and screenshots from Basecamp are used with permission from Basecamp. Some of the product names and company names used in this book have been used for identification purposes...

Words: 14496 - Pages: 58

Premium Essay

Business Management

...SAGE India website gets a makeover! Global Products Enhanced Succinct Intuitive THE Improved Interactive Smart Layout User-friendly Easy Eye-catching LEADING WORld’s LEADING Independent Professional Stay tuned in to upcoming Events and Conferences Search Navigation Feature-rich Get to know our Authors and Editors Why Publish with SAGE ? World’s LEADING Publisher and home and editors Societies authors Professional Academic LEADING Publisher Natural World’s Societies THE and LEADING Publisher Natural authors Societies Independent home editors THE Professional Natural Societies Independent authors Societies and Societies editors THE LEADING home editors Natural editors Professional Independent Academic and authors Academic Independent Publisher Academic Societies and authors Academic THE World’s THE editors Academic THE Natural LEADING THE Natural LEADING home Natural authors Natural editors authors home World’s authors THE editors authors LEADING Publisher World’s LEADING authors World’s Natural Academic editors World’s home Natural and Independent authors World’s Publisher authors World’s home Natural home LEADING Academic Academic LEADING editors Natural and Publisher editors World’s authors home Academic Professional authors Independent home LEADING Academic World’s and authors home and Academic Professionalauthors World’s editors THE LEADING Publisher authors Independent home editors Natural...

Words: 63606 - Pages: 255

Premium Essay

Performance Appraisal

... Presented to: Prof. Diana Lee Tracy K. Chan By Grutas, Princess May T. Rivero, Jubelle A. Sta.Ana, Babylyn E BSBA HRDM 3-1N S.Y 2013-2014 CERTIFICATION This Undergraduate Research entitled “Implementation of Performance Appraisal in Small Scale Businesses in Quezon City” prepared and submitted by Princess May T. Grutas, Jubelle A. Rivero and Babylyn E. Sta. Ana, in fulfillment of the requirements for the course FUNDAMENTALS OF RESEARCH has been examined and recommended for approval. DIANA LEE TRACY K. CHAN, MEM Adviser APPROVAL SHEET Approval by the PANEL OF EXAMINERS on the ORAL EXAMINATION with a grade of . ROSALIE A. CORPUS, DEM Chairman ANALYN DIAZ, DEM MR. NORMAN LOS ANES, MBA Member Member Accepted in partial fulfillment of the requirements for the Degree Bachelor of Science Major in Human Resource Development and Management. OCTOBER 21, 2013 PASCUALITO B. GATAN, MPA Director ABSTRACT Title of Research: Implementation of...

Words: 17114 - Pages: 69

Premium Essay

Report on City Bank Limitd

...Introduction In this chapter we tried to describe the origin of the report, objective of the report, scope and limitations of the report. Origin of The Report: The BBA Program under the department of finance offers a course named “Law & Practice of Banking” which requires submitting a report on a specific topic determined by the course instructor. The report under the headline “A comprehensive Analysis of City Bank Limited” has been prepared towards the purpose. Objective of The Report: There are several objectives to conduct the study which are: * To provide an overall information on City Bank Limited. * To analyze the financial statement of City Bank Limited. * To analyze the ratio of City Bank & compare it to Bank Asia. Methodology: To prepare this report we mainly depend on secondary data. We collected our necessary data from annual report of the City Bank For last five years. Then we calculate its different types of ratio and compare it to Bank Asia. . Scope of The Report: 1.4. Scope of the report: Everything has some advantage which helps that work to be completed thoroughly. We get some scope which helps us to make a standard report. Major of them are- Easy access of information: We have collected information from the annual report of the City bank. It helps us to prepare this report easily. Easy access to internet: We have a very smooth access to internet in our computer lab so that we didn’t face any kind of trouble...

Words: 4636 - Pages: 19

Premium Essay

The Effect of Working Capital Management and Profitability

...Micael Hillergren Supervisor: Lars Lindbergh   Student Umeå School of Business and Economics Spring semester 2014 Degree project, 30 HP Abstract Many argue that there is a trade off between profitability and liquidity. However, many studies have found that the profitability can increase with an efficient Working Capital Management. Correctly allocating cash flows to where and when it is needed increases liquidity and simultaneously increasing profitability. The purpose of this study is to develop the research on the relationship between Working Capital Management and profitability by investigating how it is affected by different company characteristics. A quantitative method was applied with philosophical stances in objectivism and positivism and deductive theory was used to approach the subject. From the theoretical framework, five hypotheses were established and statistically tested in order to answer our research question. The first hypothesis was formulated to confirm previous research, while the remaining two aimed at providing both a theoretical and practical contribution to existing knowledge. The thesis centers on the Cash Conversion Cycle, a metric of how fast a company turns purchased products into profit, with Gross Profit Margin as the measure of profitability. The data analyzed is financial information from 2012, collected from a secondary source, Business Retriever database. In order to fulfill the purpose, hypotheses were tested....

Words: 30644 - Pages: 123

Premium Essay

Inside the European Parliament

...of Contents List of tables and figures 4 Acknowledgements 5 List of Abbreviations 6 Section A. Organisation evaluation 8 The Executive Summary 8 The Placement Overview 9 1. The Evaluation of the EP’s activities 10 1.1 The EP format 11 1.2 The History of the EP 11 1.3 Geographical Locations and Facilities 12 2. The People 16 2.1 Visions and Strategies 16 2.2 Institutional structure and management 16 2.2.1 External structure 16 2.2.2 Internal Structure 17 2.3 Management of the EP 21 2.3.1 EP’s Political management 21 2.3.2 EP’s Organisational management 22 2.3.3 EP’s Communication Management 23 2.4 Staffing, recruiting and training 24 2.4.1 Staffing 24 2.4.2 Recruiting 27 2.4.3 Training 27 3. The Numbers 27 3.1 Strict rules for efficient and transparent budget implementation 32 3.1.1 Separation of functions 32 3.1.2 Use of standard documents 32 3.2 Controls of the budgetary procedure 32 3.2.1 Internal controls 33 3.2.2 Internal audits 33 3.2.3 External controls 33 4. Evaluation and conclusion 34 4.1 SWOT analysis 34 4.2 Conclusions 35 Section B. Personal and professional development 36 1. Getting a Placement 36 2. Placement year objectives 37 3. Placement experiences 38 References 40 Appendices 43 List of tables and figures Figure 1. EP Locations Source: BBC.com (2014) 9 Figure 2. EU Coverage Source: EP Visits and seminar unit (2013) 13 Figure 3. Strasbourg centre Source: European Parliament...

Words: 12462 - Pages: 50

Premium Essay

Hot Spot and Grill Bar

...Executive Summary A. Market Study Food and parties have been a part of the culture of the Filipino. Filipino have always been a food lover, be it traditional food or food from another country. Hot is an adjective word that means having or giving off heat; having a high temperature; showing intense; requiring immediate delivery or correspondence; demanding priority. Spot is a noun word that means a place or locality; a specific position in a sequence. The owners chose this name because of the very reason that it is catchy and the word itself is explainable; it will be easily understood by their chosen target markets. Also, the owners thought of using this name because their main mission is to serve their customers with products that are warm and fresh. It features a variety of menu such as salads, pasta, hamburgers, rice meals, desserts and beverages hot or cold, alcoholic or non-alcoholic. It is also known for having the best ambiance having a laid back style with a twist of modernized furniture. Rest assured that Hotspot bar restaurant will maintain its security well. Hotspot bar and restaurant is an establishment that is very flexible and in its operations, it will make sure to cater to the needs and wants of every individual of all ages. B. Technical Study Burgers was introduced to the Philippines by the Americans, since then the Filipinos are fond of eating burgers. Hotspot bar and restaurant wants to be known for their best tasting burgers but they...

Words: 19178 - Pages: 77

Premium Essay

Strategy Management

...performance and balance sheet strength, identifying a company’s strategy, doing five-forces and driving-forces analysis, doing a SWOT analysis, and recommending actions to improve company performance. The content of these case exercises is tailored to match the circumstances presented in each case, calling upon students to do whatever strategic thinking and strategic analysis is called for to arrive at a pragmatic, analysis-based action recommendation for improving company performance. eBook Connect Plus includes a media-rich eBook that allows you to share your notes with your students. Your students can insert and review their own notes, highlight the text, search for specific information, and interact with media resources. Using an eBook with Connect Plus gives your students a complete digital solution that allows them to access their materials from any computer. Tegrity Make your classes available anytime, anywhere. With simple, one-click recording, students can search for a word or phrase and be taken to the exact place in your lecture that they need to review. EASY TO USE Learning Management System Integration McGraw-Hill Campus is a...

Words: 219639 - Pages: 879

Premium Essay

Financial Management: Theory & Practice

...University of Tennessee ________________________________________________________________________________ Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States Copyright 2013 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it. This is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. The publisher reserves the right to remove content from this title at any time if subsequent rights restrictions require it. For valuable information on pricing, previous editions, changes to current editions, and alternate formats, please visit www.cengage.com/highered to search by ISBN#, author, title, or keyword for materials in your areas of interest. Copyright 2013 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial...

Words: 197028 - Pages: 789

Premium Essay

3pl Report

...trademark belonging to Capgemini. www.3plstudy.com Supporting Organizations: 4 2014 18TH ANNUAL THIRD-PARTY LOGISTICS STUDY Executive Summary Current State of the 3PL Market In the 2014 18th Annual Third Party Logistics Study, survey results showed the continuing, positive overall nature of shipper-3PL relationships. Both parties view them as being successful, and shippers are seeing positive results again this year: an average logistics cost reduction of 11%, average inventory cost reduction of 6%, and an average fixed logistics cost reduction of 23%. Shippers agree that 3PLs provide new and innovative ways to improve logistics effectiveness, and that they are sufficiently agile and flexible to accommodate future business needs and challenges. Despite ongoing churn in shipper-3PL relationships, in general shippers are increasing their use of outsourced logistics services, and shippers and 3PLs are now about equally satisfied (70% and 69%, respectively) with the openness, transparency and good communication in their relationships. Big Data As suggested in last year’s report, however, several...

Words: 17774 - Pages: 72

Premium Essay

Management

...ELEVENTH EDITION Management LEADING & COLLABORATING IN A COMPETITIVE WORLD Thomas S. Bateman McIntire School of Commerce University of Virginia Scott A. Snell Darden Graduate School of Business University of Virginia MANAGEMENT: LEADING & COLLABORATING IN A COMPETITIVE WORLD, ELEVENTH EDITION Published by McGraw-Hill Education, 2 Penn Plaza, New York, NY 10121. Copyright © 2015 by McGraw-Hill Education. All rights reserved. Printed in the United States of America. Previous editions © 2013, 2011, and 2009. No part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written consent of McGraw-Hill Education, including, but not limited to, in any network or other electronic storage or transmission, or broadcast for distance learning. Some ancillaries, including electronic and print components, may not be available to customers outside the United States. This book is printed on acid-free paper. 1 2 3 4 5 6 7 8 9 0 DOW/DOW 1 0 9 8 7 6 5 4 ISBN 978-0-07-786254-1 MHID 0-07-786254-6 Senior Vice President, Products & Markets: Kurt L. Strand Vice President, Content Production & Technology Services: Kimberly Meriwether David Managing Director: Paul Ducham Executive Brand Manager: Michael Ablassmeir Executive Director of Development: Ann Torbert Senior Development Editor: Laura Griffin Digital Product Analyst: Kerry Shanahan Marketing Manager: Elizabeth Trepkowski ...

Words: 87010 - Pages: 349

Premium Essay

Leadership Style, a Correlational Study in Leadership Style and Use-of-Force Behavior of Police Officers

...could be more important in a law enforcement agency than to have these two variables coexisting in an organization in a harmonious manner? By investigating whether a relationship exists between these two variables an answer to this question could emerge. In law enforcement today, the cost associated with excessive use-of-force civil law-suits against police officers and their departments can be staggering. Exposing police officers to a specific leadership style may influence the dynamics in the use-of-force behavior during arrests or other police actions. Evaluating a non-experimental ex post facto field scenario and comparing these results with perceived leadership styles of the supervisors was a primary function of this study. Results from using the Multifactor Leadership questionnaire; both Rater and Leader forms were used to gather additional information. Fifteen officers participated in the role play...

Words: 30373 - Pages: 122