Reference no: EM13184739
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.
|
Calculate the incremental npv of the lease agreement
: Calculate the incremental NPV of the lease agreement and ascertain if the company should take out the lease.
|
|
Determine whether the project should be undertaken
: The firm is an ongoing profitable business and pays taxes at a 30% rate in the year of income. It uses a 15% discount rate on the new project. Using the NPV approach, determine whether the project should be undertaken (use the relevant tax rate in..
|
|
Determine whether the project should be undertaken
: The firm is an ongoing profitable business and pays taxes at a 30% rate in the year of income. It uses a 15% discount rate on the new project. Using the NPV approach, determine whether the project should be undertaken (use the relevant tax rate in..
|
|
Calculate the cost of capital for the individual components
: Calculate the cost of capital for the individual components in the capital structure, and then calculate the weighted average cost of capital for Metacorp. Consider after-tax cost of capital in your calculations.
|
|
Determine the cash flow statement including npv and irr
: 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..
|
|
Determine the cash payback period for each proposal
: Determine the cash payback period for each proposal. Round your answers to two decimal places, if necessary
|
|
Determine the unadjusted forecasting mse
: Use the sales data given below to determine a)the least squares trend line b)the predicted value for 2002 sales. c) the MAD d) the unadjusted forecasting MSE sales 1995 130 1996 140 1997 152 1998 160 1999 169
|
|
How should the firm charge in these markets
: Suppose that you are hired as consultant to a firm producing a therapeutic drug protected by a patent that gives a firm a monopoly in two markets. The drug can be transported between the two markets at no cost. The demand schedule in the first mar..
|