Reference no: EM13185412
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.
|
In the case of cherokee nation vs. georgia-supreme court
: In the case of Cherokee Nation vs. Georgia, the Supreme Court:
|
|
Collection of intelligence in a security department, and why
: How important is the collection of intelligence in a security department, and why?
|
|
Professional standards movement in k-12 changed
: How has the content and professional standards movement in K-12 changed the way educators teach students in America?
|
|
Irregular in sleeping and eating and resists change
: According to Thomas and Chess, a child that is very irregular in sleeping and eating, resists change, and tends to be loud is labeled a(n) ___ child.
|
|
Simplify depreciation to be calculated as straight line
: 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 whi..
|
|
Dichotic listening or the cocktail party phenomenon
: Compare the experiences and comfort levels of each team member with dichotic listening, or the "cocktail party" phenomenon.
|
|
What prices should the firm charge in these markets
: The demand schedule in the first market is Q1=100-0.5P1, where P1 is the price of the product and Q1 is the amount sold in the market. In the seconds market, the demand is Q2=140-P2, where P2 is the price of the product and Q2 is the amount sold i..
|
|
Word feedback thought of in negative way-behavioral approach
: The aspect of the behavioral approach that I find is underused in the workplace is that of feedback. Unfortunately in our organizations today, the word feedback is thought of in a negative way.
|
|
Compare major dimensions of culture in thailand with the us.
: Compare the major dimensions of culture in Thailand with the U.S.
|