Casey wants to calculate the monthly payments for each loan option that he is considering. Switch to the Loan Options worksheet. In cell B12, create a formula using the PMT function to calculate the monthly payments for loan Option A. Use the values in cells B8, B10, and B5 for the Rate, Nper, and Pv arguments, respectively, and do not enter any values for the optional arguments. Copy the formula you created in cell B12 into the range C12:D12.

Garrett is an executive vice president at samm hardware. he researches a proposal by a larger company, maximum hardware, to combine the two companies. by analyzing past performance, conducting focus groups, and interviewing maximum employees, garrett concludes that maximum has poor profit margins, sells shoddy merchandise, and treats customers poorly. what actions should garrett and samm hardware take? a. turn down the acquisition offer and prepare to resist a hostile takeover. b. attempt a friendly merger and use managerial hubris to improve results at maximum. c. welcome the acquisition and use knowledge transfer to impart sam hardware's management practices. d. do nothing; the two companies cannot combine without samm hardware's explicit consent.