E10 XV J D E F A B ####### ### Jan 1, 2021 Plant & Equipment 4 HP Cash Note: Purchase of 4 Trucks 7 8 Oo9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Tesla has a manufacturing building that they paid $500,000 on December 31, 2020. To pay for the building, they took a 30-year fixed mortgage loan at 5%. for the building. The mortgage payment is paid at the end of each month with cash. Complete the Mortgage Payment worksheet using the PMT and PPMT functions. You should use each function in only one column on the Mortgage Payment worksheet. Please make the needed journal entry for Dec. 31, 2021 only (Just type the numbers in - It is not necessary to use cell references). Hint: Don't forget to put a negative sign In front of the function. 0