Reference no: EM131699276

The Blue Nights Inn

Tom and Lisa have recently moved from California. After working and living in the Bay Area for 20 years, they have managed to save enough money to purchase a nice new home in Ashland and have a decent retirement fund. After six months of living in Ashland, they've decided to invest part of their retirement money in a business. They thought of owning and running an inn whose customers will mainly be tourists who come for the Shakespeare Festival.

For a couple of months, Tom and Lisa put their thought into action. They collected basic information relevant and important to building and running an inn. First they scoured the newspapers and talked to realtors to look for an ideal house for sale located in a place perfect for an inn. They needed a house that is large enough to have six bedrooms, and have ample parking space for their guests. After several months of searching, they finally found one - an 80-yearoldOld Victorian 2500 square-foot home that sits in a half-acre lot selling for $350,000. The value of the land, Tom and Lisa estimated to be at $300,000.

Tom and Lisa thought that the house must be renovated, refurbished, and redecorated before it is ready for occupancy. After consulting with an architect and a building contractor, they estimated the renovation, refurbishing, redecorating, and landscaping to cost an additional $150,000. They also estimated that it would cost an additional $50,000 to furnish the inn. On top of these, they estimated they needed $50,000 as working capital.

In order to start the process, Tom and Lisa needed a total of $600,000. They planned to invest $250,000 of their retirement fund and borrow the balance from a local bank at 8.0% interest per annum, payable in 30 years. They've figured that the inn could be open for business in January of 2007. They will call the inn The Blue Nights Inn.

The inn Tom and Lisa plan to build will have five bedrooms. The largest bedroom will be the Presidential Suite. Three medium rooms will be called the DeLuxe Room and one small room will be called Heavenly.  After checking around, they thought to apply the following room rates:

                Presidential           $250 per night

                Deluxe                   $150

                Heavenly               $100

Tom and Lisa realize that running and maintaining the inn would cost additional money. After much research and discussion, they identified and listed expense items, and came up with what they deemed reasonable and expected monthly cost estimates shown below. They thought to use these expense items for all months of the year.

Expense Category                                                Est. Monthly Expense

Owner's Salary                                                            $ 1,500

Housekeeper Salary (two full-time)                                  $ 4,000

Utilities - Gas                                                              $ 300

Utilities - Electric/Water                                                250

Advertising and Promotion                                              300

Insurance                                                                   100

Maintenance Expense                                                   300

Landscape Maintenance                                                300

Telephone                                                                  50

Website Maintenance                                                   150

Internet Cable Connection                                             50

Miscellaneous                                                              500

Tom and Lisa are projecting a 3% increase in these costs from year 1 to year 2 and from year 2 to year 3.

Tom and Lisa plan to open the inn 365 days per year. Based on this, they estimated the capacity (in terms of number of room-days) of the inn shown in the table below.

Since occupancy rates in Ashland are not the same throughout the year, T and L did some research and found the following information published in an annual report published by the Ashland Chamber of Commerce. The pie below shows the relative shares of revenues earned each quarter.

Other assumptions:

1. Getting each room ready (regardless of type) costs $15.00
2. The cost of serving breakfast per room occupancy is $5.00
3. Depreciation Rates:
   1. Building - 30 years (straight line)
   2. Furniture Fixtures - 10 years (straight line)

Your Task:

1. Based on the given information above, prepare a financial plan for Tom and Lisa's planned business (use the Dr. Dungan's BA 499 Template)

2. Evaluate the financial viability of the planned business - inspect closely the balance sheets, cash flow, break-even and other important financial information.

3. Evaluate the assumptions used in this business planning scenario.  Are there any important assumptions that were not included or omitted in this scenario? What are they?If any assumption appears unrealistic or does not represent the current condition, change them and revise the financial template to reflect the more current assumptions.

Very Important Note: The case presented above is just an example. The figures are contrived and are not based on actual research. The scenario was written for the sole purpose of demonstrating how to use the financial template used in BA499.

In your case, when you develop your business plan, all the assumptions you use in coming up with your plan (marketing, operations, financial, HR, etc.) will be closely scrutinized by your BA499 instructor and professors who may be attending your oral presentation. Be ready to back up any assumption you use in your plan with data or research.