Reference no: EM131699173

Assignment: 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.

CAPACITY (Room-days per month)

Days Open	Jan 31	Feb 28	Mar 31	Apr 30	May 31	Jun 30	Jul 31	Aug 31	Sep 30	Oct 31	Nov 30	Dec 31
Presidential Suite	31	28	31	30	31	30	31	31	30	31	30	31
Delux (3 rooms)	93	84	93	90	93	90	93	93	90	93	90	93
Heavenly	31	28	31	30	31	30	31	31	30	31	30	31

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:

a. Building - 30 years (straight line)
b. 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.

This file contains a contrive scenario for developing a business idea. The process described in this scenario is similar to the process you would go through in developing your business plan idea for BA 499 (Business Planning) capstone. Pay particular attention to how this contrived business idea relates to the topic on breakeven analysis and financial analysis. Feedback from BA 499 instructors indicate that many business plans fall short in this area. The topic of breakeven analysis is covered not only in this core class, but in at least one other business core class (BA213). Even beyond this class, BA213 and BA 499, the knowledge of breakeven and financial analysis will be useful in the workplace--especially if you decide to have and run your own business.