Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. The table below summarizes prices (per $100 face value) of various default-free zero-coupon bonds (expressed as a percentage of face value):a. Compute the yield to maturity for each bond. b. Plot the zero-coupon yield curve (for the first five years).c. Is the yield curve upward sloping, downward sloping, or flat?Maturity (years) Price Face Value =$100.001 $95.512 $91.053 $86.384 $81.655 $76.51a. Compute the yield to maturity for each bond. YTM 1-year bond YTM 2-year bond YTM 3-year bond YTM 4-year bond YTM 5-year bond b. Plot the zero-coupon yield curve (for the first five years).c. Is the yield curve upward sloping, downward sloping, or flat?The yield curve is

2. the external environment (connect)choose whether each example belongs in the general, task, or internal environment. exampleenvironmenta worldwide recession task environment / general environment / internal environmentlocal mothers asking their community grocery store to carry no-salt cheerios-type cereal for their babies task environment / general environment / internal environmentchoose the phrase that best completes the following sentence. the relationship between the task environment and the general environment is best described as: a one-way system: changes in the task environment affect the general environment, but changes in the general environment do not affect the task environment. an open system: changes in the task environment affect the general environment, and changes in the general environment affect the task environment. a one-way system: changes in the general environment affect the task environment, but changes in the task environment do not affect the general environment. a closed system: changes in the general environment do not affect the task environment, and changes in the task environment do not affect the general environment.©bloomberg via getty imagesmanagement in the newsin april 2010, the explosion of british petroleum’s (bp) deepwater horizon oil drilling rig and the accompanying oil spill dramatically changed the external environment in which all oil companies operate. the explosion released more oil than any other accidental spill in history and had a huge impact on the waters and surrounding communities of the gulf coast. the conditions that led to the spill, the attempts to stop the spill, and the clean-up and aftermath of the spill prompted debates in the u. s. senate, concern on wall street, and attention from companies all over the world. match each oil spill event with a specific dimension of the general environment. eventgeneral environment dimensionbp stock prices falling 25% during the first month after the oil spill oil seeping into pelican nesting grounds, which will place the brown pelican back on the endangered species list people moving from louisiana to oklahoma to avoid the effects of the spill