homework

profileTPT123
Break-evenAnalysisExcel1.xlsx

Sheet1

Home and Community-Based Services (HCBS)
Assumptions
Expected Monthly Revenue (Membership Fee): $125 per person
Fixed Costs
Utilities $ 590.00
Health/Wellness Staff $ 2,500.00
Arts/Crafts Staff $ 2,000.00
Supplies $ 800.00
Fitness Equipment $ 200.00
Total Fixed Costs
Variable Costs
Monthly Lunch Costs $ 25.00
Monthly Breakfast Costs $ 15.00
Total Variable Costs
Break-Even Analysis
Total Revenues - Total VC - FC = Profit
Total Revenues - Total VC
Total FC/Total Revenues - Total VC
Payback period
Initial investment $317,880
1st Year $46,920
2nd Year $68,166
3rd Year $93,404
4th Year $123,287
5th Year $158,573