Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Internal Auditing Pocket Guide Preparing Performing Reporting And Follow Up

Authors: J.P. Russell

2nd Edition

1636941303, 978-1636941301

More Books

Students also viewed these Accounting questions