What is the correct formula for cell B8 to calculate the modified duration?





a) =DURATION(B1,B2,B3,B4,B6,B7)

b) =MDURATION(B1,B2,B4,B3,B6,B7)

c) =MDURATION(B1,B2,B3,B4,B6,B7)


c) =MDURATION(B1,B2,B3,B4,B6,B7)

Business

You might also like to view...

Start-up and organization costs include all of the following except

A) goodwill. B) cost of printing stock certificates. C) attorney's fees. D) state incorporation fees.

Business

An illusory promise can be defined as a ________

A) contract providing that only one of the parties need perform, only if he or she chooses to do so B) contract not supported by consideration since the promise is supported by an illegal act C) promise that lacks consideration since the person promises to perform an act or do something she already has an obligation to do D) contract based on love and affection

Business

In attempting to understand how cultural values influence human relations on the job, the most important factor is the

A) cultural value profile of that individual's country. B) individual's age. C) individual's value profile. D) level of job satisfaction and happiness.

Business

A retailer is considering building a large store. If the local economy experiences expansion, the firm expects the store to earn a $2,000,000 profit next year

If the local economy experiences a contraction, the firm expects the store to lose $400,000 next year. Analysts estimate a 20% chance for the local economy to experience an expansion next year (hence an 80% chance for contraction). What is the expected monetary value (EMV) of building the large store? A) $1,600,000 B) $720,000 C) $2,000,000 D) $80,000 E) $1,520,000

Business