Intro Principal Payments

This intro problem practices PPMT. PPMT calculates the principal portion of a specific loan payment, assuming a fixed interest rate and equal periodic payments. Principal is the part of a payment that reduces the loan balance. Update the output cells to calculate the signed principal portion of the selected payment in each row. Return negative amounts for principal paid out, or 0 if no principal is repaid. Rate is the interest rate per period. Period selects the payment, starting at 1, and Periods is the total number of payments. Start Amt is the amount borrowed. End Amt is 0 for full repayment or a negative amount for a balance still owed. Timing is 0 for end-of-period payments or 1 for beginning-of-period payments. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

Need help with PPMT details and syntax? Review the PPMT function guide first.