What numbers do I put in the PMT formula on excel? Craig has decided to start snow plowing during the winter months. He purchased a heavy-duty dump truck with plow and salter from Power Equipment for $40,000 on October 1st, 2026. He paid $1,000 as a down payment and the remaining balance on a 5% -7 year note to Power Equipment. You will be completing several accounting activities in regards to this purchase. 1. Prepare amortization schedules in Excel for the purchase of the Truck with snow plow. Craig wants to know the total interest cost if he made monthly payments or quarterly payments. You will calculate the payments using the PMT function. Your amortization table should show the principal and interest amount for each payment for the entirety of the loan. The payments will begin on December 1st, 2026.
What numbers do I put in the PMT formula on excel?
Craig has decided to start snow plowing during the winter months. He purchased a heavy-duty dump truck with plow and salter from Power Equipment for $40,000 on October 1st, 2026. He paid $1,000 as a down payment and the remaining balance on a 5% -7 year note to Power Equipment. You will be completing several accounting activities in regards to this purchase.
1. Prepare amortization schedules in Excel for the purchase of the Truck with snow plow. Craig wants to know the total interest cost if he made monthly payments or quarterly payments. You will calculate the payments using the PMT function. Your amortization table should show the principal and interest amount for each payment for the entirety of the loan. The payments will begin on December 1st, 2026.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 8 images
