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 is 5%, nper is 120, and present value is $147,000
A) =ABS(CUMIPMT(.05/12, 120,-147000,12,1,0 )) B) =CUMIPMT(.05/12, 120*12,-147000,1,12,0 )
C) =(ABS(CUMIPMT(.05/12, 120, 147000,1,12,0 )) D) =CUMIPMT(.05/12, 120*12, 147000,12,1,0 )
C
You might also like to view...
The Arrange tab displays in both Layout and ________ views
Fill in the blank(s) with correct word
Match each item with a statement below.
A. in IPv6 addressing, a bit string that uniquely identifies a particular interface B. packets goes to the nearest single instance of this address C. a 4-bit field limiting the valid range for a multicast address D. an IPv6 address that is all zeros except for the very last bit, which is set to 1 and may be represented as ::1 in compact notation E. an address that can be combined with other addresses into a single entry in the router table F. an addressing scheme that is designed to be used only on a single segment of a local network G. a way of reducing the number of individual routing table entries that routers must manage H. allows internetwork devices to perform complex address recognition and management functions that can keep up with data volumes and time-sensitive processing needs I. a type of networking device that combines switch, router, and network management functions within a single box