13. In cell Q4, enter a formula using the VLOOKUP function to display a staff member’s pay rate. Look up the employee ID listed in cell Q2. Use a structured reference to retrieve the value in the 5th column of the Staff table. Since the formula is looking for a specific staff member’s data, find an exact match.

A) plot the m1 and m2 money stock in the us from 1990-2015. (hint: you may use the data tools provided by fred.) (b) plot the nominal interest rate from 1960 to 2014. (hint: you can either use the daily interest rates for selected u.s. treasury, private money market and capital market instruments from or the effective federal funds rate fromfred.) (c) the consumer price index (cpi) is a measure of the average change over time in the prices paid by urban consumers for a market basket of consumer goods and services. intuitively, the cpi represents the cost of living or the average price level. plot the cpi from 1960 to 2013.(d) the inflation rate is the yearly percentage change in the average price level. in practice, we usually use the percentage change in the cpi to compute the inflation rate. plot the inflation rate from 1960 to 2013.(e) explain the difference between the ex-ante and ex-post real interest rate. use the fisher equation to compute the ex-post real interest rate. plot the nominal interest rate and the ex-post real interest rate from 1960 to 2013 in the same graph.

Amanda rice has just arranged to purchase a $640,000 vacation home in the bahamas with a 20 percent down payment. the mortgage has a 7 percent apr compounded monthly and calls for equal monthly payments over the next 30 years. her first payment will be due one month from now. however, the mortgage has an eight-year balloon payment, meaning that the balance of the loan must be paid off at the end of year 8. there were no other transaction costs or finance charges. how much will amanda’s balloon payment be in eight years

If a team of three workers, each making the u.s. federal minimum wage, produced these 12 rugs, what would the total labor cost be? don't forget that these workers would be working overtime.