-In the accompanying figure,in the formula in the active cell,why is B6 entered as -B6?
A) To reflect a calculation for a reverse mortgage.
B) To show that borrowing money is a negative activity.
C) To show the monthly payment as a positive number.
D) To subtract the amount of the loan from the total payments.

Question

-In the accompanying figure,in the formula in the active cell,why is B6 entered as -B6?
A) To reflect a calculation for a reverse mortgage. 
B) To show that borrowing money is a negative activity. 
C) To show the monthly payment as a positive number. 
D) To subtract the amount of the loan from the total payments.

Quizplus · Accepted Answer

The use of -B6 in a formula, particularly in financial calculations like loan payments, is to convert the loan amount (a negative impact on one's finances) into a positive monthly payment figure. This is common in functions like PMT in Excel, where the loan amount is input as a negative value to indicate cash outflow, resulting in a positive monthly payment calculation.

-In the Accompanying Figure,in the Formula in the Active Cell,why