Business, 13.02.2020 20:47 lkhushi

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.

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 00:30

You wants to open a saving account.which account will grow his money the most

Answers: 1

Answer

Business, 22.06.2019 11:00

How did the contribution of the goods producing sector to gdp growth change between 2010 and 2011 a. it fell by 0.3%. b. it fell by 2.3%. c. it rose by 2.3%. d. it rose by 0.6%. the answer is b

Answers: 1

Answer

Business, 22.06.2019 12:10

The following transactions occur for badger biking company during the month of june: a. provide services to customers on account for $32,000. b. receive cash of $24,000 from customers in (a) above. c. purchase bike equipment by signing a note with the bank for $17,000. d. pay utilities of $3,200 for the current month. analyze each transaction and indicate the amount of increases and decreases in the accounting equation. (decreases to account classifications should be entered as a negative.)

Answers: 1

Answer

Business, 22.06.2019 13:40

Randall's, inc. has 20,000 shares of stock outstanding with a par value of $1.00 per share. the market value is $12 per share. the balance sheet shows $42,000 in the capital in excess of par account, $20,000 in the common stock account, and $50,500 in the retained earnings account. the firm just announced a 5 percent (small) stock dividend. what will the balance in the retained earnings account be after the dividend?

Answers: 1

Answer

You know the right answer?

In cell K4, create a formula using the IF function to calculate the interest paid on the mortgage (o...

Questions