Answered step by step
Verified Expert Solution
Question
1 Approved Answer
create a spreadsheet for this pro forma Year 1 Revenue: $175,000 Expenses: Cost of goods sold: $40,000 Rent: $17,500 Utilities: $7,500 Marketing: $10,000 Salaries: $50,000
create a spreadsheet for this pro forma
Year 1
Revenue: $175,000
Expenses:
Cost of goods sold: $40,000
Rent: $17,500
Utilities: $7,500
Marketing: $10,000
Salaries: $50,000
Other expenses: $5,000
Net income: $45,000
Year 2
Revenue: $250,000
Expenses:
Cost of goods sold: $75,000
Rent: $22,500
Utilities: $8,500
Marketing: $15,000
Salaries: $75,000
Other expenses: $8,000
Net income: $46,000
Year 3
Revenue: $350,000
Expenses:
Cost of goods sold: $90,000
Rent: $25,000
Utilities: $9,000
Marketing: $18,000
Salaries: $110,000
Other expenses: $10,000
Net income: $88,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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