Identify the correct formula to calculate the cumulative principal paid on a mortgage loan for the second year of the loan (periods 1-12, where rate =5%, nper =120, present value = $147,000
A) =CUMIPMT(.05/12, 120*12, 147000,12,1,0)
B) =CUMIPMT(.05/12, 120*12,-147000,1,12,0)
C) =ABS(CUMIPMT(.05/12, 120,-147000,12,1,0))
D) =(ABS(CUMIPMT(.05/12, 120, 147000,1,12,0))
Answer: D
You might also like to view...
The pictures that you can create, modify, store, download, and transmit using your PC are referred to as ____.
A. graphics B. bitmaps C. pics D. pixels
Which of the following creates the string of the numbers from 1 to 1000 most efficiently?
a. String s; for (int i = 1; i <= 1000; i++) s += i; b. StringBuilder sb = new StringBuilder(10); for (int i = 1; i <= 1000; i++) sb.append(i); String s = new String(sb); c. StringBuilder sb = new StringBuilder(3000); for (int i = 1; i <= 1000; i++) sb.append(i); String s = new String(sb); d. All are equivalently efficient.
To sort on more than one column, you must specify additional ________
A) columns B) levels C) rows D) cells
How do proxy server log files help protect the network?
What will be an ideal response?