1. =SUM(A14,A8)

2. =C8+ 15
3. PMT function {PMT(D4D12,E4,-C4)}

What will each of the above formulas do
please see if I have the correct answer using excel or another spreadsheet document.

1. Is the sum between the two blocks listed the more blocks the more #'s to the equation, it helps when the #'s change and the total has to be adjusted, the program will do it automatically for you( The same reason for all equations)

2. This would be the block in question plus 15

3. Calculates the payment for a loan based on constant payments and a constant interest rate. PMT(rate,nper,pv,fv,type)

Rate is the interest rate for the loan.

Nper is the total number of payments for the loan.

Pv is the present value, or the total amount that a series of future payments is worth now; also known as the principal.

Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.

Type is the number 0 (zero) or 1 and indicates when payments are due.

1. =SUM(A14,A8): This formula calculates the sum of the values in cell A14 and cell A8. If you want to test the formula, you can open a spreadsheet document (such as Microsoft Excel or Google Sheets), enter some numbers in cells A14 and A8, and then enter the formula =SUM(A14,A8) in a different cell. The result will be the sum of the two values that you entered.

2. =C8+15: This formula adds 15 to the value in cell C8. To test this formula, you can enter a number in cell C8 and then enter the formula =C8+15 in a different cell. The result will be the value in cell C8 plus 15.

3. PMT(D4D12,E4,-C4): This formula is using the PMT function to calculate the payment for a loan. The parameters of the function are as follows:

- Rate: The interest rate for the loan, which is located in cell D4D12.
- Nper: The total number of payments for the loan, which is located in cell E4.
- Pv: The present value, or the total amount that a series of future payments is worth now; also known as the principal, which is located in cell -C4. The negative sign indicates that it is a cash outflow.
- Fv: The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0.
- Type: The number 0 (zero) or 1, which indicates when payments are due.

To test this formula, you can enter the corresponding values in cells D4D12, E4, and -C4, and then enter the formula =PMT(D4D12,E4,-C4) in a different cell. The result will be the calculated payment for the loan. Make sure to adjust the parameters according to your specific loan details.