Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I cannot get my balance sheet to balance, please help begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} hline methods & Jan-24 & Feb-24 & Mar-24 & Apr-24 & May-24 & Jun-24

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

I cannot get my balance sheet to balance, please help

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline methods & Jan-24 & Feb-24 & Mar-24 & Apr-24 & May-24 & Jun-24 & Jul-24 & Aug-24 & Sep-24 & Oct-24 & Nov-24 & Dec-24 & total \\ \hline & & & & & & & & & & & & & 0 \\ \hline radio & & & & & & & & & & & & & 0 \\ \hline \multirow[t]{3}{*}{RCl} & & & 55 & & & 55 & & & 55 & & & & 165 \\ \hline & & & & & & & & & & & & & 0 \\ \hline & & & & & & & & & & & & & 0 \\ \hline REFERRAL PKGS & 67 & 67 & 67 & 67 & 67 & 67 & 67 & 67 & 67 & 67 & 67 & 67 & 800 \\ \hline V-FLYERS & & & 101 & 101 & & 101 & 203 & 203 & & & 101 & 101 & 911 \\ \hline V-FLYERS & & & 101 & 101 & & 101 & 203 & 203 & & & 101 & 101 & 911 \\ \hline \multicolumn{14}{|l|}{ V-FLYERS } \\ \hline V-FLYERS & & & & & & & & & & & & & 0 \\ \hline V-FLYERS & & & 60 & & & 60 & & & & & 60 & & 180 \\ \hline \multicolumn{14}{|l|}{ business cards } \\ \hline bill boards & 4,000 & & & & & & & & & & & & 4,000 \\ \hline bus ads & 1,500 & & & & & & & & & & & & 1,500 \\ \hline PROMO VIDEO & & & & & 500 & & & & 500 & & & & 1,000 \\ \hline WEBSITE & 3,500 & & & & & & & & & & & & 3,500 \\ \hline \multicolumn{14}{|l|}{ APP } \\ \hline total & 9,067 & 67 & 384 & 269 & 567 & 384 & 472 & 472 & 622 & 67 & 329 & 269 & 12,968 \\ \hline \multicolumn{14}{|l|}{ REVENUES } \\ \hline TICKET SALES & 54,000 & 54,000 & 54,000 & 70,000 & 54,000 & 54,000 & 70,000 & 70,000 & 54,000 & 54,000 & 54,000 & 70,000 & 712,000 \\ \hline CONCESSIONNAIRES & 5,000 & 5,000 & 5,000 & 5,000 & 5,000 & 5,000 & 5,000 & 5,000 & 5,000 & 5,000 & 5,000 & 5,000 & 60,000 \\ \hline GYM SERVICES & 3,600 & 3,600 & 3,600 & 3,600 & 3,600 & 3,600 & 3,600 & 3,600 & 3,600 & 3,600 & 3,600 & 3,600 & 43,200 \\ \hline \multirow[t]{3}{*}{ WEBSITE ADS } & 200 & 200 & 200 & 200 & 200 & 200 & 200 & 200 & 200 & 200 & 200 & 200 & 2,400 \\ \hline & & & & & & & & & & & & & 0 \\ \hline & & & & & & & & & & & & & 0 \\ \hline TOTAL & 62,800 & 62,800 & 62,800 & 78,800 & 62,800 & 62,800 & 78,800 & 78,800 & 62,800 & 62,800 & 62,800 & 78,800 & 817,600 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & ljan & feb & mar & apr & may & jun & jul & aug & sep & oct & nov & dec & total \\ \hline rent & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 36000 \\ \hline insurance & 7740.62 & 7740.62 & 7740.62 & 7740.62 & 7740.62 & 7740.62 & 7740.62 & 7740.62 & 7740.62 & 7740.62 & 7740.62 & 7740.62 & 92887.44 \\ \hline asset acquisition & 104,000 & 0 & & & 0 & & & & & & & & 104,000 \\ \hline lights & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 12000 \\ \hline water & 500 & 500 & 500 & 500 & 500 & 500 & 500 & 500 & 500 & 500 & 500 & 500 & 6000 \\ \hline ict & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 3600 \\ \hline supplies & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 3600 \\ \hline maintenance & 150 & 150 & 150 & 150 & 150 & 150 & 150 & 150 & 150 & 150 & 150 & 150 & 1800 \\ \hline legal fees & 4000 & 4000 & 4000 & 4000 & 4000 & 4000 & 4000 & 4000 & 4000 & 4000 & 4000 & 4000 & 48000 \\ \hline accounting fees & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 300 & 5300 & 8600 \\ \hline & & & & & & & & & & & & & 0 \\ \hline & & & & & & & & & & & & & 0 \\ \hline miscellaneous & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 3000 & 36000 \\ \hline total & 127262.1 & 23262.12 & 23262.12 & 23262.12 & 23262.12 & 23262.12 & 23262.12 & 23262.12 & 23262.12 & 23262.12 & 23262.12 & 28262.12 & 388145.44 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Beginnig balance sheet for The Plavground as at DEC 312024} & \\ \hline & Jan 2024 & Dec 2024 & \\ \hline \multicolumn{4}{|l|}{ Current Assets } \\ \hline Cash & $100,000 & $469,777 & \\ \hline \multicolumn{4}{|l|}{A/R} \\ \hline \multicolumn{4}{|l|}{ OTHER } \\ \hline TOTAL CURRENT ASSETS & $100,000 & $469,777 & \\ \hline \multicolumn{4}{|l|}{ FIXED Assets } \\ \hline security cameras & & $11,000 & \\ \hline cash register & & $7,500 & \\ \hline furniture & & $12,000 & \\ \hline tools & & $4,000 & \\ \hline lockers & & $10,000 & \\ \hline signage & & $1,500 & \\ \hline sound system & & $8,000 & \\ \hline accessories & & $50,000 & \\ \hline dep & & $10,800 & \\ \hline total fixed assets & \$o & $93,200 & \\ \hline total assets & $100,000 & $562,977 & \\ \hline \multicolumn{4}{|l|}{ current liabilities } \\ \hline taxes payable & & $36,640 & \\ \hline \multicolumn{4}{|l|}{ other } \\ \hline total current liabilities & \$0 & $36,640 & \\ \hline \multicolumn{4}{|l|}{ Iong term liabilitities } \\ \hline loans & & $375,758 & \\ \hline \multicolumn{4}{|l|}{ other } \\ \hline total long term liabilities & $0 & $375,758 & \\ \hline total liabilities & $0 & $412,398 & \\ \hline \multicolumn{4}{|l|}{ owners equity } \\ \hline beginning capital & $100,000 & $100,000 & \\ \hline profits/loss & & $109,921 & \\ \hline \multicolumn{4}{|l|}{ Idrawings } \\ \hline ending capital & $100,000 & $209,921 & \\ \hline toal owners equity+total liabilties & $100,000 & $622,319 & $59,342 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline Ioan & & & \\ \hline principle & int rate & duration & payment \\ \hline 395000 & 0.04 & 15 & 2971.5 \\ \hline grant & 5000 & & \\ \hline & & & \\ \hline equity & 100000 & & \\ \hline & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline FUNCTION & RATE & JAN & FEB & MAR & APR & MAY & JUN & JUL & AUG & SEP & OCT & NOV & DEC & TOTAL \\ \hline TOP MGMT & 12000 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 144000 \\ \hline CLEANER & 1000 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 12000 \\ \hline CASHIER & 1500 & 2 & 2 & 2 & 3 & 2 & 2 & 3 & 3 & 2 & 2 & 2 & 3 & 42000 \\ \hline SECURITY & 1800 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 43200 \\ \hline MAINTENANCE & 2500 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 30000 \\ \hline COORDINATORS & 1800 & 2 & 2 & 2 & 3 & 2 & 2 & 3 & 3 & 2 & 2 & 2 & 3 & 50400 \\ \hline \multirow[t]{3}{*}{ ACCOUNTANT } & 716.67 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 8600.04 \\ \hline & & & & & & & & & & & & & & 0 \\ \hline & TOTAL & 10 & 10 & 10 & 12 & 10 & 10 & 12 & 12 & 10 & 10 & 10 & 12 & 330200 \\ \hline TOP MGMT & & 12000 & 12000 & 12000 & 12000 & 12000 & 12000 & 12000 & 12000 & 12000 & 12000 & 12000 & 12000 & 144000 \\ \hline CLEANER & & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 1000 & 12000 \\ \hline CASHIER & & 3000 & 3000 & 3000 & 4500 & 3000 & 3000 & 4500 & 4500 & 3000 & 3000 & 3000 & 4500 & 42000 \\ \hline SECURITY & & 3600 & 3600 & 3600 & 3600 & 3600 & 3600 & 3600 & 3600 & 3600 & 3600 & 3600 & 3600 & 43200 \\ \hline MAINTENANCE & & 2500 & 2500 & 2500 & 2500 & 2500 & 2500 & 2500 & 2500 & 2500 & 2500 & 2500 & 2500 & 30000 \\ \hline COORDINATORS & & 3600 & 3600 & 3600 & 5400 & 3600 & 3600 & 5400 & 5400 & 3600 & 3600 & 3600 & 5400 & 50400 \\ \hline \multirow[t]{4}{*}{ ACCOUNTANT } & & 716.67 & 716.67 & 716.67 & 716.67 & 716.67 & 716.67 & 716.67 & 716.67 & 716.67 & 716.67 & 716.67 & 716.67 & 8600.04 \\ \hline & & & & & & & & & & & & & & 0 \\ \hline & & & & & & & & & & & & & & 0 \\ \hline & TOTAL & 26416.67 & 26416.67 & 26416.67 & 29716.67 & 26416.67 & 26416.67 & 29716.67 & 29716.67 & 26416.67 & 26416.67 & 26416.67 & 29716.67 & 330200 \\ \hline nic & & 1320.834 & 1320.834 & 1320.834 & 1485.834 & 1320.834 & 1320.834 & 1485.834 & 1485.834 & 1320.834 & 1320.834 & 1320.834 & 1485.834 & 16510 \\ \hline total & & 27737.5 & 27737.5 & 27737.5 & 31202.5 & 27737.5 & 27737.5 & 31202.5 & 31202.5 & 27737.5 & 27737.5 & 27737.5 & 31202.5 & 346710 \\ \hline & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & \\ \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

Accounting Principles

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

10th Edition

1119491630, 978-1119491637, 978-0470534793

More Books

Students also viewed these Accounting questions

Question

What information does the audience need?

Answered: 1 week ago