The stayanight discount motel chain is considering a

Reference no: EM13379860

The StayaNight discount motel chain is considering a proposal to build a new motel that would have 150 rooms.

Revenues: Once the motel is operational, it will generate revenue of $100 per night per room that is occupied. This price is expected to hold constant over the lifespan of the project.

Operational Costs: Daily operational including labor and materials; costs are $5,000 + $20 per occupied room in year 1, and both will increase 3% annually. Accounts Receivable, Accounts Payable and Inventory can be ignored.
Administrative Expense: Administrative expense is estimated at $350,000 annually with no annual change. Annual Replacement Expense (furniture etc.) is $50,000 in year one and will grow10% per year after that. Marketing is planned at $60,000 annually.
Investment: The motel will cost $1,000,000 to build. Simplify depreciation to be calculated as straight line over 30 years. It will be financed with a 30 year loan at 8% interest compounded annually with annual payments. It will be sold at the end of year 15 for $300,000, at which time the remaining balance on the load will be paid. The land lease cost is $100,000 annually. The corporate minimally attractive rate of return is 15%. Tax rate is 35%.

1. Prepare an income statement and cash flow statement including NPV and IRR.

2. Devise three alternative scenarios (covered in Week 10) concerning the motel project. Make one variable an average occupancy rate percentage. Make and state any assumptions, if needed. Specify your evaluation criteria.

3. Minimum requirement is a management proposal of 2-3 pages including any recommendations suggested by the scenario analyses.

Some notes on this project from my professor:

I do not need to create a working capital statement, but I do need a cash flow statement.

I need it set it up in excel with the basic formulas so it will do the work for you. (not sure if there is a way to attach the spreadsheet or not)

Needs to be clear and concise. One page is ok, say it and say it well. Make recommendations and summarize spreadsheet.

Create a data block first thing so you don't miss anything.

Reference no: EM13379860

Questions Cloud

1the table below shows the probability that a mother in a : 1.the table below shows the probability that a mother in a given part of the income distribution given by the row will

S90 116 1991 105 1992 : sales 1990 116 1991 105 1992 29 1993 59 1994 1081995

Play the social security game to solve the social security : play the social security game to solve the social security problem. detail your choices noting the whys of your choices

Susanna nanna is the production manager for a furniture : susanna nanna is the production manager for a furniture manufacturing company. the company produces tables x and chairs

The stayanight discount motel chain is considering a : the stayanight discount motel chain is considering a proposal to build a new motel that would have 150 rooms.revenues

Suppose that you are hired as consultant to a firm : suppose that you are hired as consultant to a firm producing a therapeutic drug protected by a patent that gives a firm

Jimmy ltd is a retailer of car batteries jimmy ltd was : jimmy ltd is a retailer of car batteries. jimmy ltd was facing its first loss since listing on the asx five years ago

Prepare at least fifteen 15 ms powerpoint slides and use : prepare at least fifteen 15 ms powerpoint slides and use for this part of your presentation. this will need to be

Chesterfield pty ltd is a resident private company : chesterfield pty ltd is a resident private company established in 2005 to manufacture quality leather lounge suites.

User Account

All Pages