Question

In: Economics

Can you find a break-even point analysis and profit analysis? Profit and loss income statement projected...

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

Solutions

Expert Solution

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.


Related Solutions

​(​Break-even analysis​) You have developed the income statement in the popup​ window, LOADING... ​, for the...
​(​Break-even analysis​) You have developed the income statement in the popup​ window, LOADING... ​, for the Hugo Boss Corporation. It represents the most recent​ year's operations, which ended yesterday. Your supervisor in the​ controller's office has just handed you a memorandum asking for written responses to the following​ questions: a. What is the​ firm's break-even point in sales​ dollars? b. If sales should increase by 40 ​percent, by what percent would earnings before taxes​ (and net​ income) increase? data table...
​(​Break-even analysis​) You have developed the income statement in the popup​ window, LOADING... ​, for the...
​(​Break-even analysis​) You have developed the income statement in the popup​ window, LOADING... ​, for the Hugo Boss Corporation. It represents the most recent​ year's operations, which ended yesterday. Your supervisor in the​ controller's office has just handed you a memorandum asking for written responses to the following​ questions: a. What is the​ firm's break-even point in sales​ dollars? b. If sales should increase by 30 ​percent, by what percent would earnings before taxes​ (and net​ income) increase? Sales   51,853,438...
Consider the concept of break even analysis and target income. In order to apply break even...
Consider the concept of break even analysis and target income. In order to apply break even analysis, why would the expenses reported in external financial reports need to be reorganized into categories based on cost behavior? How do these analytical tools relate to product pricing and cost management (i.e., why would this analysis be useful to management)?
In a cost-volume-profit analysis, explain what happens at the break-even point and why companies do not...
In a cost-volume-profit analysis, explain what happens at the break-even point and why companies do not want to remain at the break-even point. In a paragraph, explain the concept in simple terms.
Break-Even Point
S.S Corporation had sales of Rs. 4,500,000. The fixed expense was Rs. 1,200,000 and variable expense totaled Rs. 1,800,000. You are required to calculate Break-Even Point for S.S Corporation.
​​​​​​ What is the maximum profit / loss and break-even for the following option spread trades?...
​​​​​​ What is the maximum profit / loss and break-even for the following option spread trades? Long 100 XYZ @ 42.50 / Sell 1 XYZ 45.00 Call @ 2.00 Long 100 XYZ @ 52.50 / Sell 1 XYZ 55.00 Put @ 4.00 Buy 1 XYZ 40.00 Call @ 2.50 / Buy 1 XYZ 40.00 Put @ 1.75 Buy 1 XYZ 50.00 Call @ 5.00 / Sell 1 XYZ 60.00 Call @ 1.50
STRATEGIC COST MANAGEMENT - BREAK-EVEN POINT AND CVP ANALYSIS
Cornwell Company is in business since 2010, makes swimwear for professional athletes. Analysis of the firm's record for the year reavelas the following:                 Average swimsuit selling price                      $140                 Average swimsuit expenses:                     Direct Material                       ...
STRATEGIC COST MANAGEMENT - BREAK-EVEN POINT AND CVP ANALYSIS
Cornwell Company is in business since 2010, makes swimwear for professional athletes. Analysis of the firm's record for the year reavelas the following:                 Average swimsuit selling price                      $140                 Average swimsuit expenses:                     Direct Material                       ...
2. Cost Volume Profit Analysis or Break Even Analysis You are given the financial information below:...
2. Cost Volume Profit Analysis or Break Even Analysis You are given the financial information below: Tom’s Treasures Income Statement . . .For Year Ended 12/31/17 Sales (85,000 units) . . ... . . .$5,500,000 Variable Expenses . . . . . . .$2,475,000 Contribution Margin . . . . . . . $3,025,000 Fixed Expenses. . . . . . . . . .$1,785.000 Net Operating Income . . . . . . $1,240,000 Additional Formulas Needed: 1. Sales...
What is the maximum profit / loss and break-even for the following option trades? Buy 1...
What is the maximum profit / loss and break-even for the following option trades? Buy 1 XYZ 30 Call @ 2.50 Sell 1 XYZ 25 Call @ 4.00 Buy 1 XYZ 40 Put @ 5.50 Sell 1 XYZ 30 Put @ 2.00
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT