Company fm2 must pay 100,000 in 4 years. in order to fully immunize from changes in interest rate, the company invests in a 3 year zero coupon bond that matures for 45,000 and a 5 year zero coupon bond that matures for x. the actuary for company fm2 determined that their portfolio fully immunized their ability to meet their obligations at the current interest rate i. calculate i.

The management of a private investment club has a fund of $250,000 earmarked for investment in stocks. to arrive at an acceptable overall level of risk, the stocks that management is considering have been classified into three categories: high risk (x), medium risk (y), and low risk (z). management estimates that high risk stocks will have a rate of return of 15%/year; medium risk stocks, 10%/year; and low risk stocks, 6%/year. the amount of money invested in low risk stocks is to be twice the sum of the amount invested in stocks of the other two categories. if the investment goal is to have a rate of return of 9% on the total investment, determine how much the club should invest in each type of stock. (assume that all the money available for investment is invested.)

The following accounts are denominated in pesos as of december 31, 2015. for reporting purposes, these amounts need to be stated in u. s. dollars. for each balance, indicate the exchange rate that would be used if a translation is made under the current rate method. then, again for each account, provide the exchange rate that would be necessary if a remeasurement is being made using the temporal method. the company was started in 2000. the buildings were acquired in 2002 and the patents in 2003. (round your answers to 2 decimal places.) exchange rates for 1 peso are as follows: 2000 1 peso = $ 0.28 2002 1 = 0.26 2003 1 = 0.25 january 1, 2015 1 = 0.24 april 1, 2015 1 = 0.23 july 1, 2015 1 = 0.22 october 1, 2015 1 = 0.20 december 31, 2015 1 = 0.16 average for 2015 1 = 0.19

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?