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, theyve 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-yearold Old 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. Theyve figured that the inn could be open for business in January of 2018. 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

Owners 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:

Getting each room ready (regardless of type) costs $15.00

The cost of serving breakfast per room occupancy is $5.00

Depreciation Rates:

Building 30 years (straight line)

Furniture Fixtures 10 years (straight line)

Your Task:

Based on the given information above, prepare a financial plan for Tom and Lisas planned business (use the Dr. Dungans BA 499 Template)

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

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.