In cell b8, create a formula without using a function that determines the total interest associated with the mortgage. first multiply the value in cell b6 (the number of terms) by the value in cell b7 (the number of monthly payments) and by 12 (to convert the yearly terms to monthly terms), and then subtract the value in cell b4 (the total loan amount).

Suppose that a worker in agland can produce either 10 units of organic grain or 2 units of incense per year, and a worker in zenland can produce either 5 units of organic grain or 15 units of incense per year. there are 20 workers in agland and 10 workers in zenland. currently the two countries do not trade. agland produces and consumes 100 units of grain and 20 units of incense per year. zenland produces and consumes 50 units of grain and no incense per year. if each country made the decision to specialize in producing the good in which it has a comparative advantage, then the combined yearly output of the two countries would increase by a. 30 units of grain and 100 units of incense. b. 30 units of grain and 150 units of incense. c. 50 units of grain and 90 units of incense. d. 50 units of grain and 130 units of ince

Two assets have the following expected returns and standard deviations when the risk-free rate is 5%: asset a e(ra) = 18.5% σa = 20% asset b e(rb) = 15% σb = 27% an investor with a risk aversion of a = 3 would find that on a risk-return basis. a. only asset a is acceptable b. only asset b is acceptable c. neither asset a nor asset b is acceptable d. both asset a and asset b are acceptable

Profits from using currency options and futures.on july 2, the two-month futures rate of the mexican peso contained a 2 percent discount (unannualized). there was a call option on pesos with an exercise price that was equal to the spot rate. there was also a put option on pesos with an exercise price equal to the spot rate. the premium on each of these options was 3 percent of the spot rate at that time. on september 2, the option expired. go to the oanda.com website (or any site that has foreign exchange rate quotations) and determine the direct quote of the mexican peso. you exercised the option on this date if it was feasible to do so. a. what was your net profit per unit if you had purchased the call option? b. what was your net profit per unit if you had purchased the put option? c. what was your net profit per unit if you had purchased a futures contract on july 2 that had a settlement date of september 2? d. what was your net profit per unit if you sold a futures contract on july 2 that had a settlement date of september 2