Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make a balance sheet for the following data- One Time Start-Up Costs: Rent Deposit $4,000 Furniture & Fixtures $8,000 Equipment $6,000 Buildout/ Renovations $10,000 Decorating,
Make a balance sheet for the following data-
One Time Start-Up Costs: | |
Rent Deposit | $4,000 |
Furniture & Fixtures | $8,000 |
Equipment | $6,000 |
Buildout/ Renovations | $10,000 |
Decorating, Painting and Remodeling | $3,500 |
Installation of Fixtures & Equipment | $2,000 |
Starting Inventory | $20,000 |
Deposits with Public Utilities | $1,500 |
Legal and Other Professional Fees | $5,000 |
License and Permits | $3,000 |
Advertising and Promotion | $2,000 |
Consulting | 0 |
Software | $3,000 |
Cash | $7,500 |
Other: Contingency for unexpected exp. | $6,000 |
Total One Time Start-Up Costs: | $81,500 |
Monthly Expenses: | |
Bank Charges | $200 |
Debt Service (Principal & Interest)(6% interest paid monthly for 2 years at 103,840) | $4,600.00 |
Insurance | $400 |
Membership & Dues | $200 |
Maintenance & Repairs | $300 |
Marketing & Promotion: Advertising | $1,000 |
Miscellaneous | $500 |
Payroll: Wages (Owner/ Manager) | 0 |
Payroll: Wages (Employees) | $2,500 |
Payroll Tax | $400 |
Professional Fees: Accounting | $200 |
Professional Fees: Legal | $400 |
Professional Fees: Other | 0 |
Rent | $4,000 |
Supplies: Office | $200 |
Supplies: Operating | $400 |
Telephone | $200 |
Utilities | $600 |
Total Monthly Expenses: | $16,100 |
Number of months required to cover Expenses: | 3 Months |
Working Capital- | $48,300 |
TOTAL START-UP FUNDS REQUIRED: | $129,800 |
Loan Amount (At 80% of Total Start-Up) ( At 6% interest paid monthly for 2 years) | $103,840 |
Income Statement
Revenue | Year 1 | ||
Sales | 320,000 | ||
Less:Sales Return | |||
Less:Discounts and Allowances | |||
Net Sales | $320,000.00 | ||
Cost of Goods Sold | |||
Materials | $96,000.00 | ||
Total Cost of Goods Sold | $96,000.00 | ||
Gross Profit | $224,000.00 | ||
Operating Expenses | |||
Wages | $30,000.00 | ||
Payroll Tax | $4,800.00 | ||
Advertising | $12,000.00 | ||
Repairs & Maintenance | $3,600.00 | ||
Profession Fees: Legal + Accounting | $7,200.00 | ||
Rent/Lease | $50,000.00 | ||
Utilities | $7,200.00 | ||
Telephone Expenses | $2,400.00 | ||
Insurance | $4,800.00 | ||
Supplies: Operating | $4,800.00 | ||
Supplies: Office | $2,400.00 | ||
Membership & Dues | $2,400.00 | ||
Miscellaneous | $6,000.00 | ||
Interest | $55,200.00 | ||
Bank Charges | $2,400.00 | ||
Total Operating Expenses | $195,200.00 | ||
Operating Profit (Loss) | $28,800.00 |
Step by Step Solution
★★★★★
3.55 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
Here is the balance sheet for the given data Balance Sheet ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started