Lookup functions allow spreadsheet users to?
1.show quantities of distinct, discrete categories of data.
2.present data that changes as a function of time.
3.keep track of if statements and nested if statements.
4.reduce the amount of manual searching and data entry.

Ummit record company is negotiating with two banks for a $157,000 loan. fidelity bank requires a compensating balance of 24 percent, discounts the loan, and wants to be paid back in four quarterly payments. southwest bank requires a compensating balance of 12 percent, does not discount the loan, but wants to be paid back in 12 monthly installments. the stated rate for both banks is 9 percent. compensating balances will be subtracted from the $157,000 in determining the available funds in part a. a-1. calculate the effective interest rate for fidelity bank and southwest bank. (do not round intermediate calculations. input your answers as a percent rounded to 2 decimal places.) a-2. which loan should summit accept? southwest bank fidelity bank b. recompute the effective cost of interest, assuming that summit ordinarily maintains $37,680 at each bank in deposits that will serve as compensating balances

What would you do as ceo to support the goals of japan airlines during the challenging economics that airlines face?

After successfully completing your corporate finance class, you feel the next challenge ahead is to serve on the board of directors of schenkel enterprises. unfortunately, you will be the only person voting for you. the company has 375,000 shares outstanding, and the stock currently sells for $40, if there are four seats in the current election, how much will it cost you to buy a seat?