BUDGETED BALANCE SHEET - December 31,2022 ASSETS: Current Assets: \begin{tabular}{l|r|} \hline Cash & 38,000 \\ Accounts Receivable & 16,000 \\ Merchandise laventory & 5,500 \\ \hline TOTAL CURRENT ASSETS & 59,500 \\ \hline \end{tabular} Property, Plant, \& Equipment: \begin{tabular}{l|r|} \hline Equipment \& Fixtures & 88,000 \\ \hline Ace. Dep. - Equipment \& Fixtures & 16,000 \\ \hline TOTAL P.P.E & 72,000 \\ \hline TOTAL ASSETS & 131,500 \\ \hline \hline \end{tabular} LIABILITIESIOWNERS' EQUITY Current Liabilities: \begin{tabular}{l|r|} Accounts Payable & 15,500 \\ Salaties Payable (if needed) & - \\ Line of Credit & - \\ \hline Notes Payable, Cument Portion (if needed) & \\ \hline TOTAL CURRENT LIABIL.ITIES & 15,500 \\ \hline \end{tabular} Lang-Term Liabilities: \begin{tabular}{l|r|} \hline NP- Long-Term Portion (if needed) & 0 \\ \hline TOTAL L L LABIL.TIES & 0 \\ \hline \end{tabular} TOTAL L.IBIL.ITIES 15,500 Owner's Equity: \begin{tabular}{l|l|} Capital & 116,000 \\ \hline TOTAL OE & 116,000 \\ TOTAL L.ABIL.ITIES \& SE & 131,500 \\ \hline \hline \end{tabular} If a corporation payment in awners - Dividends If a sile proprietorshipipartacrahip, payment to ownets = Withdrawals Vou aust muke this determainution when it comes to tax ealculatini. UNE OF CREDIT SCHEDULE (LOC) DATE: SET THIS UP AS WAS LEARNED FROM OH. 12, IF NEEDED, IN CASE YOUR GROUP DECIDES TO BORROW MONEY TO EUY LONGTERM EQUIPMENT USE THE FMT EXCEL FUNCTON TO CALCULATE THE MOS. PAYMENT Rote = Annual Ratel 12 to get the monthly rate NPER = Number of Monthly Feriods Essed on When Co. Wants to Poy Down. ORIGNAL UNE OF CREDIT (LOC) NEEDED LINE OF CREDIT BY MONTHS IF MORE UNE OF CREDIT NEADED THEN ADO MORE HERE AND RECALCUAT NEW END Of FERIOD LOCFAVAFII. TO THEN CALCULATE nTEREST BUDGETED BALANCE SHEET - December 31,2022 ASSETS: Current Assets: \begin{tabular}{l|r|} \hline Cash & 38,000 \\ Accounts Receivable & 16,000 \\ Merchandise laventory & 5,500 \\ \hline TOTAL CURRENT ASSETS & 59,500 \\ \hline \end{tabular} Property, Plant, \& Equipment: \begin{tabular}{l|r|} \hline Equipment \& Fixtures & 88,000 \\ \hline Ace. Dep. - Equipment \& Fixtures & 16,000 \\ \hline TOTAL P.P.E & 72,000 \\ \hline TOTAL ASSETS & 131,500 \\ \hline \hline \end{tabular} LIABILITIESIOWNERS' EQUITY Current Liabilities: \begin{tabular}{l|r|} Accounts Payable & 15,500 \\ Salaties Payable (if needed) & - \\ Line of Credit & - \\ \hline Notes Payable, Cument Portion (if needed) & \\ \hline TOTAL CURRENT LIABIL.ITIES & 15,500 \\ \hline \end{tabular} Lang-Term Liabilities: \begin{tabular}{l|r|} \hline NP- Long-Term Portion (if needed) & 0 \\ \hline TOTAL L L LABIL.TIES & 0 \\ \hline \end{tabular} TOTAL L.IBIL.ITIES 15,500 Owner's Equity: \begin{tabular}{l|l|} Capital & 116,000 \\ \hline TOTAL OE & 116,000 \\ TOTAL L.ABIL.ITIES \& SE & 131,500 \\ \hline \hline \end{tabular} If a corporation payment in awners - Dividends If a sile proprietorshipipartacrahip, payment to ownets = Withdrawals Vou aust muke this determainution when it comes to tax ealculatini. UNE OF CREDIT SCHEDULE (LOC) DATE: SET THIS UP AS WAS LEARNED FROM OH. 12, IF NEEDED, IN CASE YOUR GROUP DECIDES TO BORROW MONEY TO EUY LONGTERM EQUIPMENT USE THE FMT EXCEL FUNCTON TO CALCULATE THE MOS. PAYMENT Rote = Annual Ratel 12 to get the monthly rate NPER = Number of Monthly Feriods Essed on When Co. Wants to Poy Down. ORIGNAL UNE OF CREDIT (LOC) NEEDED LINE OF CREDIT BY MONTHS IF MORE UNE OF CREDIT NEADED THEN ADO MORE HERE AND RECALCUAT NEW END Of FERIOD LOCFAVAFII. TO THEN CALCULATE nTEREST
