Go to the PMT Sheet. Use a financial function to compute the loan payment amount in cell D2. The 50,000 loan is an ordinary annuity with an annual interest rate of 6% and with monthly payments made each month for 15 years.  Use cell addresses for everything that is listed in the input area. Paste your function in the blank. [BLANK-1]

On the PMT sheet, Enter the formula for monthly interest expense in cell C11 and fill it down. Paste your formula in the blank. [BLANK-1]

Consider the following list and the selection sort.  What number will be further left?  (i.e, 64 will no longer be there. What number will take the place of 64? 64 25 12 22 11

Which patient factor is MOST directly associated with impaired oxygen diffusion at the alveolar‑capillary membrane?

Less willing or able to take part in the authenticity rituals, older participants may be perceived by their youthful counterparts as less _______ .

Scholars consider the breakdown of conventional rules during the _________________ to be the beginning of post-modern fashion.

Which patient would the nurse identify as having an the highest risk for the development of respiratory acidosis? A patient with: 

2. (12 pts) Complete the first two months of amortization schedule for a fixed rate of 6% on a $500,000 loan for 30 years with a monthly mortgage payment of $2997.75.  Payment number Total payment Interest Payment Principal Payment Balance of Principal After Payment 1 2

1. (12 pts) Shelly wants to invest $7,500 in a certificate of deposit (CD) account. There are two possible choices.  First choice: The Alaska USA FCU has a nominal rate of 4.125%, compounded quarterly.  Second choice: The First Internet Bank of Indiana which has an effective annual yield of 4.156%.  Which choice of CD should Shelly invest her money in and why? 

4. (12 pts) The Starks purchase a home for $800,000. After making a down payment, they have a 20-year fixed rate mortgage for $650,000 with a 7% interest rate. Find the following.  a. Their monthly payment.  b. The total amount they pay on their mortgage over the life of the loan.  c. The total amount of interest they will pay over the lifetime of the loan.