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 06:00

Why might a business based on a fad be a good idea? question 2 options: fads bring in the most customers. some fads are longer lasting than expected. fads have made some business owners incredibly wealthy. fads can take a business in a new direction.

Answers: 2

Answer

Business, 22.06.2019 10:30

How are interest rates calculated by financial institutions? financial institutions generally calculate interest as (1) interest or (.

Answers: 1

Answer

Business, 22.06.2019 12:30

On june 1, 2017, blossom company was started with an initial investment in the company of $22,360 cash. here are the assets, liabilities, and common stock of the company at june 30, 2017, and the revenues and expenses for the month of june, its first month of operations: cash $4,960 notes payable $12,720 accounts receivable 4,340 accounts payable 840 service revenue 7,860 supplies expense 1,100 supplies 2,300 maintenance and repairs expense 700 advertising expense 400 utilities expense 200 equipment 26,360 salaries and wages expense 1,760 common stock 22,360 in june, the company issued no additional stock but paid dividends of $1,660. prepare an income statement for the month of june.

Answers: 3

Answer

Business, 22.06.2019 15:10

Popeye produces 20 cans of spinach in 8 hours. wimpy produces 15 hamburgers in 10 hours. if each hamburger trades for 1.5 cans of spinach, then: a.wimpy’s production and productivity are greater than popeye’s. b.popeye’s production is greater than wimpy’s, but his productivity is less. c.wimpy’s production is greater than popeye’s, but his productivity is less. d.popeye’s production and productivity are greater than wimpy’s.

Answers: 3

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