Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show equations with cell to put them in Tesla has a manufacturing building that they paid $500,000 on December 31,2022 . To pay for
Please show equations with cell to put them in
Tesla has a manufacturing building that they paid $500,000 on December 31,2022 . To pay for the building, they took a 30 -year flxed 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. Hint: Don't forget to put a negative sign in front of the function. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hliney & A & B & C & D & E & F & G & H & I \\ \hline 1 & & 1cosa & & & iviro & age & & & \\ \hline 2 & & & & & & & & & \\ \hline 3 & \# & Date & \begin{tabular}{l} Monthly \\ Payment \end{tabular} & Principal & Interest & \begin{tabular}{l} Current \\ Balance \end{tabular} & \begin{tabular}{l} Current \\ Interest \end{tabular} & & \\ \hline 4 & & Jan. 12023 & & & & 500,000 & 5% & & \\ \hline 5 & 1 & Jan. 31, 2023 & & & $0.00 & $500,000,00 & & & \\ \hline 6 & 2 & Feb. 28, 2023 & & & $0.00 & $500,000.00 & & & \\ \hline 7 & 3 & Mar. 31, 2023 & & & $0.00 & $500,000.00 & & & \\ \hline 8 & 4 & Apr. 30, 2023 & & & $0.00 & $500,000.00 & & & \\ \hline 9 & 5 & May 31,2023 & & & $0.00 & $500,000.00 & & & \\ \hline 10 & 6 & Jun. 30,2023 & & & $0.00 & $500,000.00 & & & \\ \hline 11 & 7 & Jul. 31,2023 & & & $0.00 & $500,000.00 & & & \\ \hline 12 & 8 & Aug. 31, 2023 & & & $0.00 & $500,000.00 & & +2 & \\ \hline 13 & 9 & Sept. 30,2023 & & & $0.00 & $500,000.00 & & & \\ \hline 14 & 10 & Oct. 31,2023 & & & $0.00 & $500,000.00 & = & \% & \\ \hline 15 & 11 & Nov. 30,2023 & & & $0.00 & $500,000.00 & & & \\ \hline 16 & 12 & Dec. 31,2023 & & & $0.00 & $500,000.00 & & & \\ \hline 17 & & & s. & & & 5x & + & & \\ \hline 18 & & & & & & & & & \\ \hline 19 & 2 & & & & & & & & \\ \hline 20 & & & & & & & 3x & & \\ \hline \end{tabular} Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started