In cell K4, create a formula using the IF function to calculate the interest paid on the mortgage (or the difference between the total payments made each year and the total amount of mortgage principal paid each year).

a. The formula should first check if the value in cell H4 (the balance remaining on the loan each year) is greater than 0.

b. If the value in cell H4 is greater than 0, the formula should return the value in J4 subtracted from the value in cell D5 multiplied by 12. Use a relative cell reference to cell J4 and an absolute cell reference to cell D5. (Hint: Use 12*$D$5-J4 as the is_true argument value in the formula.)

c. If the value in cell H4 is not greater than 0, the formula should return a value of 0.

Sara is a manager at a restaurant with employees from different cultural backgrounds. which action of sara could employees perceive as an act of favoritism?

Jamie lee is reviewing her finances one month later. she has provided the actual amounts paid below. use the cash budget table below to her identify the variances in her budget. each answer must have a value for the assignment to be complete. enter "0" for any unused categories. actual amounts income: monthly expenses: gross monthly salary $2,315 rent obligation $260 net monthly salary $1,740 utilities/electricity $130 savings allocation: utilities/water $10 regular savings $130 utilities/cable tv $155 rainy-day savings $20 food $160 entertainment: gas/maintenance $205 cake decorating class $90 credit card payment $25 movies with friends $50 car insurance $75 clothing $145 budgeted amounts assets: monthly expenses: checking account $1,850 rent obligation $225 emergency fund savings account $4,300 utilities/electricity $75 car $5,200 utilities/water $35 computer & ipad $1,100 utilities/cable tv $120 liabilities: food $115 student loan $6,600 gas/maintenance $95 credit card balance $1,000 credit card payment $45 income: car insurance $45 gross monthly salary $2,155 clothing $45 net monthly salary $1,580 entertainment: savings allocation: cake decorating class $90 regular savings $130 movies with friends $50 rainy day savings $20

Consider how health insurance affects the quantity of health care services performed. suppose that the typical medical procedure has a cost of $160, yet a person with health insurance pays only $40 out of pocket. her insurance company pays the remaining $120. (the insurance company recoups the $120 through premiums, but the premium a person pays does not depend on how many procedures that person chooses to undergo.) consider the following demand curve in the market for medical care. use the black point (plus symbol) to indicate the quantity of procedures demanded if each procedure has a price of $160. then use the grey point (star symbol) to indicate the quantity of procedures demanded if each procedure has a price of $40. q d at p=$160 q d at p=$40 0 10 20 30 40 50 60 70 80 90 100 200 180 160 140 120 100 80 60 40 20 0 price of medical procedures quantity of medical procedures demand if the cost of each procedure to society is truly $160, the quantity that maximizes total surplus is procedures. economists often blame the health insurance system for excessive use of medical care. given your analysis, the use of care might be viewed as excessive because consumers get procedures whose value is than the cost of producing them.