10.you plan to purchase a $ 100,000 house using a 30- year mortgage obtained from your local credit union. the mortgage rate offered is 8.25 percent. a. calculate your monthly payments on this mortgage. b. create an excel file with 7 columns (months, payment, interest, principle, balance, %interest and %principle) for all 360 months. c. calculate the amount of interest paid over the life of this mortgage.

Consider a treasury bill with a rate of return of 5% and the following risky securities: security a: e(r) = .15; variance = .0400 security b: e(r) = .10; variance = .0225 security c: e(r) = .12; variance = .1000 security d: e(r) = .13; variance = .0625 the investor must develop a complete portfolio by combining the risk-free asset with one of the securities mentioned above. the security the investor should choose as part of her complete portfolio to achieve the best cal would be a. security a b. security b c. security c d. security d

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding

Bcorporation, a merchandising company, reported the following results for october: sales $ 490,000 cost of goods sold (all variable) $ 169,700 total variable selling expense $ 24,200 total fixed selling expense $ 21,700 total variable administrative expense $ 13,200 total fixed administrative expense $ 33,600 the contribution margin for october is: