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
Other questions on the subject: Business
Business, 22.06.2019 12:00, dwilburn01
Simon, aged 10, is invited to a classmate's birthday party at an exclusive ski resort on march 15th. the day will include 4 hours of snowboarding, lunch and birthday cake. simon's mother checks a box on the invitation that says "yes, we will attend" and returns it to the classmate's address. unfortunately, they later don't attend the party when simon comes down with the flu. on march 17th, simon's mother receives an invoice in the mail from simon's classmate for $35 that says, "party no-show fee." can simon's classmate collect the fee?
Answers: 3
Business, 22.06.2019 14:40, robert7248
Which of the following statements about revision is most accurate? (a) you must compose first drafts quickly (sprint writing) and return later for editing. (b) careful writers always revise as they write. (c) revision is required for only long and complex business documents. (d) some business writers prefer to compose first drafts quickly and revise later; others prefer to revise as they go.
Answers: 3
Business, 22.06.2019 17:00, martinez6221
Vincent is interested in increasing his earning potential upon completing his internship at a major accounting firm. which option can immediately boost his career in the intended direction? b. complete a certification from a professional organization c. complete a new four-year undergraduate program in a related field d. complete a two-year associate degree in a related field e. complete an online course in accounting
Answers: 3
Business, 22.06.2019 19:40, cieloromero1
Moody corporation uses a job-order costing system with a plantwide predetermined overhead rate based on machine-hours. at the beginning of the year, the company made the following estimates: machine-hours required to support estimated production 100,000 fixed manufacturing overhead cost $ 650,000 variable manufacturing overhead cost per machine-hour $ 3.00 required: 1. compute the plantwide predetermined overhead rate. 2. during the year, job 400 was started and completed. the following information was available with respect to this job: direct materials $ 450 direct labor cost $ 210 machine-hours used 40
Answers: 3
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 in other subjects:
