In: Economics
Can you find a break-even point analysis and profit analysis? Profit and loss income statement projected for the next 3 years first year monthly
•R&D Expenses $7000 each year
•S&A $3000 each month
•Salaries 10 people with $9000 each month
•Costumer Satisfaction $8000 each month
•Rent of office $5000 each month
•Cost of recipes $2000 each month
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
R&D | 583.33 | 583.33 | 583.33 | 583.33 | 583.33 | 583.33 | 583.33 | 583.33 | 583.33 | 583.33 | 583.33 | 583.33 |
S&A | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 |
Salaries | 9,000.00 | 9,000.00 | 9,000.00 | 9,000.00 | 9,000.00 | 9,000.00 | 9,000.00 | 9,000.00 | 9,000.00 | 9,000.00 | 9,000.00 | 9,000.00 |
Customer satisfaction | 8,000.00 | 8,000.00 | 8,000.00 | 8,000.00 | 8,000.00 | 8,000.00 | 8,000.00 | 8,000.00 | 8,000.00 | 8,000.00 | 8,000.00 | 8,000.00 |
Rent | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 |
Cost of recipe | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 | 2,000.00 |
Total monthly expenses | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 |
Total monthly revenues should equal expenses for break even | ||||||||||||
Total montly revenues (breakeven) | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 | 27,583.33 |
It is assumed that 10 people's salary is 9000 (combined)
Also, no information is given about revenues, so breakeven is in dollar revenues.
Year 1 | Year 2 | Year 3 | |
R&D | 7,000.00 | 7,000.00 | 7,000.00 |
S&A | 36,000.00 | 36,000.00 | 36,000.00 |
Salaries | 1,08,000.00 | 1,08,000.00 | 1,08,000.00 |
Customer satisfaction | 96,000.00 | 96,000.00 | 96,000.00 |
Rent | 60,000.00 | 60,000.00 | 60,000.00 |
Cost of recipe | 24,000.00 | 24,000.00 | 24,000.00 |
Total yearly expenses | 3,31,000.00 | 3,31,000.00 | 3,31,000.00 |
Total yearly revenues (breakeven) | 3,31,000.00 | 3,31,000.00 | 3,31,000.00 |
If I missed any assumption, let me know in the comment section, I will update the same. Thanks.