Question

1 Approved Answer

Posted on Oct 06, 2024

create a balance sheet with these data sheets A B D E F G H 1 K L M N o P Q R S

create a balance sheet with these data sheets image text in transcribed

A B D E F G H 1 K L M N o P Q R S TU v W Y Z Input Start month >>>>>>> Sep-21 Oct-21 Jan-22 Feb-22 2 3 Business Plan Trinity Beale Aug-21 Month 1 Month 2 2 Nov-21 Month 4 Dec-21 Month 5 Mar-2 Month 8 Month 3 Month 6 Month 7 SERVICE CHARGES # Income # Income # Income # Income # Income # Income # Income # Income 3 4 5 3 4 4 5 $2,000.00 $4.000.00 $6,000.00 2 1 4 3 3 2 3 3 2 3 3 2 2 3 1 2 2 2 2 4 updated April 2021 5 6 Level 1 Marketing 7 7 Level 2 Marketing 8 Level 3 Marketing 9 10 11 12 13 Total All Revenue 14 Average service charge per month $4,000 $4,000 $18,000 $ $0 $ $0 $0 $0 $6,000 $8,000 $6,000 $0 $0 $0 $0 $8,000 $12,000 $12,000 $0 $0 $0 $0 $10,000 $12,000 $12,000 $0 $0 $0 $0 $6,000 $12,000 $18,000 $0 $0 $0 $0 $8,000 $8,000 $12,000 $0 $0 $0 $0 $28,000 $3,500 $10,000 $8,000 $12,000 $0 $0 $0 $0 $8,00 $12,00 $12,00 $ $ $ $ $ 6 G 91 10 9 8 9 $26,000 $4,333 $20,000 $3,333 $32,000 $3,556 $34,000 $3,400 $36,000 $4,000 $30,000 $3,333 $32,00 $3,55 13 $12,243 $1,020 $1,020 $1,020 $1,020 $1,020 $1,020 $1,020 $1,02 20% $5,200 $667 $6,400 $6,800 $7,200 $5,600 $6,000 $6,40 Assumed Operating Expenses (1/12 of 16 annual forecast) 17 Additional Costs payment to influencer 18 Additional Costs social media campaign 19 Payroll 20 salary 21 Total Additional Costs 20% % 20% $5,200 $5,200 $15,600 $4,000 $4,000 $6,400 $6,400 $6,800 $6,800 $20,400 $7,200 $7,200 $21,600 $5,600 $5,600 $16,800 $6,000 $6,000 $18,000 $6,40 $6,40 $ $19,20 $8,667 $19,200 $9,687 $20,220 22 Total Operating Expenses 23 Monthly Net Income $16,620 $9,380 $21,420 $12,580 $22,620 $13,380 $17,820 $10,180 $19,020 $10,980 $20,22 $11,78 $10,313 $11,780 25 26 27 ncome Yr 1 Yr 2 Yr 3 Total Revenue $428,000 $444,000 $584,000 Other Revenue Gross Profit $428,000 $444,000 $584,000 $0 0 0 0 0 100 100 0 1,900 250 0 0 50 0 2,000 500 0 1,368 0 0 1,000 300 Operating Expenses Salary (Office & Overhead) Payroll (taxes etc.) 20% Supplies - Cleaning products Office supplies, business cards, paper, etc Repairs/ Maintenance - car, equipment advertising, social media Accounting and Legal Sas elephone Utilities nsurance Chamber/rotary/business memberships Vebsite Booking software Credit card processing Travel Other Other 0 0 1,368 0 1,368 0 1,500 1,500 325 SO 1,500 325 50 325 50 0 2,500 0 2,400 5,475 0 3,000 5,000 4,250 Table Balance Sheet Company As of 30 40 1Q 20 YR1 YR2 YR3 $. $ Assets Current Assets Long-Term Assets Total Assets Liabilities Short-Term Liabilities Long-Term Liabilities Total Liabilities Owner's Equity Total Liabilities & Owner's Equity $ $ $ $ A B D E F G H 1 K L M N o P Q R S TU v W Y Z Input Start month >>>>>>> Sep-21 Oct-21 Jan-22 Feb-22 2 3 Business Plan Trinity Beale Aug-21 Month 1 Month 2 2 Nov-21 Month 4 Dec-21 Month 5 Mar-2 Month 8 Month 3 Month 6 Month 7 SERVICE CHARGES # Income # Income # Income # Income # Income # Income # Income # Income 3 4 5 3 4 4 5 $2,000.00 $4.000.00 $6,000.00 2 1 4 3 3 2 3 3 2 3 3 2 2 3 1 2 2 2 2 4 updated April 2021 5 6 Level 1 Marketing 7 7 Level 2 Marketing 8 Level 3 Marketing 9 10 11 12 13 Total All Revenue 14 Average service charge per month $4,000 $4,000 $18,000 $ $0 $ $0 $0 $0 $6,000 $8,000 $6,000 $0 $0 $0 $0 $8,000 $12,000 $12,000 $0 $0 $0 $0 $10,000 $12,000 $12,000 $0 $0 $0 $0 $6,000 $12,000 $18,000 $0 $0 $0 $0 $8,000 $8,000 $12,000 $0 $0 $0 $0 $28,000 $3,500 $10,000 $8,000 $12,000 $0 $0 $0 $0 $8,00 $12,00 $12,00 $ $ $ $ $ 6 G 91 10 9 8 9 $26,000 $4,333 $20,000 $3,333 $32,000 $3,556 $34,000 $3,400 $36,000 $4,000 $30,000 $3,333 $32,00 $3,55 13 $12,243 $1,020 $1,020 $1,020 $1,020 $1,020 $1,020 $1,020 $1,02 20% $5,200 $667 $6,400 $6,800 $7,200 $5,600 $6,000 $6,40 Assumed Operating Expenses (1/12 of 16 annual forecast) 17 Additional Costs payment to influencer 18 Additional Costs social media campaign 19 Payroll 20 salary 21 Total Additional Costs 20% % 20% $5,200 $5,200 $15,600 $4,000 $4,000 $6,400 $6,400 $6,800 $6,800 $20,400 $7,200 $7,200 $21,600 $5,600 $5,600 $16,800 $6,000 $6,000 $18,000 $6,40 $6,40 $ $19,20 $8,667 $19,200 $9,687 $20,220 22 Total Operating Expenses 23 Monthly Net Income $16,620 $9,380 $21,420 $12,580 $22,620 $13,380 $17,820 $10,180 $19,020 $10,980 $20,22 $11,78 $10,313 $11,780 25 26 27 ncome Yr 1 Yr 2 Yr 3 Total Revenue $428,000 $444,000 $584,000 Other Revenue Gross Profit $428,000 $444,000 $584,000 $0 0 0 0 0 100 100 0 1,900 250 0 0 50 0 2,000 500 0 1,368 0 0 1,000 300 Operating Expenses Salary (Office & Overhead) Payroll (taxes etc.) 20% Supplies - Cleaning products Office supplies, business cards, paper, etc Repairs/ Maintenance - car, equipment advertising, social media Accounting and Legal Sas elephone Utilities nsurance Chamber/rotary/business memberships Vebsite Booking software Credit card processing Travel Other Other 0 0 1,368 0 1,368 0 1,500 1,500 325 SO 1,500 325 50 325 50 0 2,500 0 2,400 5,475 0 3,000 5,000 4,250 Table Balance Sheet Company As of 30 40 1Q 20 YR1 YR2 YR3 $. $ Assets Current Assets Long-Term Assets Total Assets Liabilities Short-Term Liabilities Long-Term Liabilities Total Liabilities Owner's Equity Total Liabilities & Owner's Equity $ $ $ $