Answered step by step
Verified Expert Solution
Link Copied!
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 ... 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_2

Step: 3

blur-text-image_3

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

Financial and Managerial Accounting the basis for business decisions

Authors: Jan Williams, Susan Haka, Mark Bettner, Joseph Carcello

16th edition

0077664078, 978-0077664077, 78111048, 978-0078111044

More Books

Students explore these related Accounting questions