Lantana Company had the following transactions this month, which resulted in the T-account balances below: a. Issued 7,500 shares of stock with a par value $0.10 to three owners (2,500 shares each) for $75,000 in cash. b. Purchased a short-term investment for $10,000 cash. c. Purchased 2 acres of land for $20,000, paid $5,000 in cash and signed a 2 year note for the remainder. d. Bought 5900 of supplies on account. e. Sold 1/2 acre of land for $5,000. Accepted a note to receive payment in one year. f. Purchased $10,000 of equipment in cash. g. Paid $500 on account for supplies purchased in transaction (d). \begin{tabular}{|rr|ll|r|r|} \hline & 7,500 & 5 & 0.10 & 2,500 & $75,000 \\ 5 & 10,000 & & & & \\ 5 & 20,000 & 5 & 5,000 & & \\ 5 & 900 & & & & \\ 5 & 5,000 & & & \\ 5 & 10,000 & & & \\ 5 & 500 & & & \\ \hline \end{tabular} Supplies \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ Debit } & Credit \\ \hline d. & 900 & \\ \hline & & \\ \hline Balance & & \\ \hline \hline & & \\ \hline \hline \end{tabular} \begin{tabular}{|lr|r|} \hline \multicolumn{3}{|c|}{ Equipment } \\ \hline & Debit & Credit \\ \hline f. & 10,000 & \\ \hline Balance & 10,000 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ Note Payable } \\ \hline Debit & Credit \\ \hline & 15,000C. \\ \hline & 15,000 Balance \\ \hline \hline & \end{tabular} \begin{tabular}{|c|r|} \hline \multicolumn{2}{|c|}{ Additional Paid-in Capital } \\ \hline Debit & Credit \\ \hline & 74,250 a. \\ \hline & 74,250 Balance \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} Using the T-account balances (and the information in the transactions, if necessary), prepare a classified balance sheet for Lantana company. You will need to use the following: Cell References: Never type a number from an Excel sheet elsewhere in the sheet. Instead, type an equals sign and then click the cell that includes the number. For example, =B5 would return the number from B5. Basic Arlthmetic: Use symbols (+/) to add, subtract, multiply, and divide in Excel. Do not do any calculations by hand. SUM Function: =5UM(C4,C5,C6)" and "=SUM(C4:C6)" will both return the value of C4+C5+C6. Include relevant cells in your sums even if they are blank so the balance sheet will automatically update if the T-account balances were to change