hope someone could help us with our group project. the subject is hospitality mngt. simulation HTM490 and this is HOTS business plan. please see file below and help us with the Capital Budget analysis (which we need to calculate the Payback period)

5. Capital Budget/ Expansion Analysis

With your strategic goals and position statement in mind, select 3 items from the "extra facilities", or "EMS" decision tab on HOTS. Perform a Payback Period analysis for each of the items selected and discuss why you would or would not choose to invest in the facilities you've analyzed.

Mission Statement We strive to provide our guests with high quality service and affordable accommodation while creating an environmental-W that meets the demands and challenges of the fast-changing industry. Positioning Statement For local and international guests who are looking for affordabie accommodation without compromising quality, our hotel can provide excellent yet simplified amenities and services that strive to meet every customer's needs. We believe that bringing comfort and modesty can make every staycation matter and memorable. We have a strong focus on enhancing the experience of our guests in giving them the perfect balance of relaxation and enjoyment through our clean rooms. great food and drinks, and friendly staff. Goals: 1. Create a 2-Star hotel rating by the end of Year 2 2. Achieve a 4-Star rating by Year 5 3. Overcome negative prot by constantly increasing income by 20% each year. 4. Develop advertising strategies to boost revenue. 5. Achieve at least 80% or 90% overall guest satisfaction by Year 2 6. Build a more sustainable organization and be in the forefront of environmental consciousness. Key Area Projections - Table KEY ROOMS GROSS NET RETURN ON STAFF MARKET AVERAGE PERFORMANCE OPERATING OWNER'S OCC % ROOM PROJECTIONS REVENUE INCOME TURNOVER SHARE PROFIT EQUITY RATE ($) YEAR 0 $1,316,923.65 -794,436 -$794,436 -15.1% 33.2% 68.5% 4.05% $86.94 YEAR 1 $1,896,406.41 $31,000.80 $21,700.56 .4% 39.84% 55% 4.86% $104.33 Occupancy Rate projected increase is 20% *Rooms Rate projected increase is 20% Income Statement for Year 1 Revenue Rooms 1,896,406.41 60% F &B 1,232,664.17 39% Other Operated Department 31,606.77 1% Total Revenue 3, 160,677.35 100% Expenses Rooms 474, 101.60 25% F &B 616,332.08 50% Other Operated Department 20,544.40 65% Administrative & General 316,067.73 10% Sales & Marketing 189,640.64 6% Maintenance (up by 15% from YO) 515262.10 Utilities 216,141 Property Taxes & Insurance 199,940 Bank Charges 10,890 Interest 21,398 Depreciation 549,359 Total Expenses 3, 129,676.55 Income Before Taxes 31,000.80 Taxes 30% 9300.24 Net Income 21,700.56Capital Budget / Expansion Analysis ????????????????????? 1. Internet Initial Investment: ($80 x 125 rooms) = $10000 Net Annual Cash Saving:$10000 - ($4 x 125) = $500 Payback Period in Years: 1.05 years Payback Period in Days: 384 days