California State University Los Angeles - BUS 4150

Instructors Manual Problem Set

CHAPTER 10: MULTIPLE CHOICE QUESTIONS

1)What is the value of cell B7?

a)  1080.50

b)  1050.20

c)  975.34

d)  932.54

e)  837.11

2. 

   What is the value of cell B6?

a)  1586.8

b)  26.67

c)  13.33

d)   40.00

e)   80.00

3. 

   What is the correct formula for B9?

a)  =(B4B6)/(PRICE(B2,B3,B4,B5,B6/B6100,B7,B8)B6)

b) =B4B6/PRICE(B2,B3,B4,B5,B6/B6/100,B7,B8)

c)  =B4B6/PRICE(B2,B3,B4,B5,B6/B6100,B7,B8)/100B6

d)      =(B4B6)/(PRICE(B2,B3,B4,B5,B6/B6100,B7,B8)/100B6)

e)  =B4/PRICE(B2,B3,B4,B5,B6/B6,B7,B8)

4. What is the correct formula for B10?

a)  =YIELD(B2,B3,B4,B9/10,100,B7,B8)

b)       =RATE(YEARFRAC(B2,B3,B8)B7,B4B6/B7,-B9,B6)B7

c)  =YIELD(B2,B3,B4,B9/B6100,B6/B6100,B7,B8)

1. 4. All of the above
   5. None of the above

5. What is the correct formula in cell B10?

a)       =YIELD(B1,B2,B4,B9/B5100,B5/B5100,B7,B8)

b)       =YIELD(B1,B3,B4,B9/B5100,B6/B5100,B7,B8)

c)  =YIELD(B1,B2,B4,B9,B5,B7,B8)

d)       =RATE(YEARFRAC(B1,B2,B8)B7,B4B5/B7,-B9,B5)B7

e)  =YIELD(B1,B3,B4,B9,B5,B7,B8)

6. What is the value of cell B4?

a)   1.28%

b)   1.49%

c)   1.52%

d)   1.64%

e)   1.72%