Hi. I have to make a budget and forecasting plan for a hypothetical business venture for an established company. I have chosen to create bed and breakfasts under the Southwest Airlines umbrella using the low-cost model in destinations that the company services. Currently, SWA generates 4% of sales from international destinations so my plan is that this will spark more travel in the industry. I have created a budget for 10 properties near the Yucatan to begin.

property acquistion and renovations: 10 mil

marketing: 25k

hire/training: 25% of the projected budget

bills monthly: 12k for all properties

room rate: average of $90 a night with a 60% capacity annually

I am hoping for 5% projected growth year over year with the target consumers being SWA travelers and millennials

These are the proposed fixed costs but I am really confused on what to include and how to get to a breakeven point for a business that doesn't exist. I have to do all of it in excel but I don't even know where to start Can you please provide me some guidance?