Question

In: Finance

Based on the data below, forecast US hotel revenues for 2017, 2018, and 2019. Provide the...

Based on the data below, forecast US hotel revenues for 2017, 2018, and 2019. Provide the model developed for your calculations.

YEAR REVENUE ($USD BILLION)

2001 105.00

2002 111.90

2003 118.80

2004 119.30

2005 135.50

2006 146.20

2007 153.80

2008 154.70

2009 133.30

2010 142.00

2011 153.30

2012 155.50

2013 163.00

2014 176.70

2015 189.50

2016 199.30

Solutions

Expert Solution

X Y
Year Revenue
1 105.00
2 11.90
3 118.80
4 119.30
5 135.50
6 146.20
7 153.80
8 154.70
9 133.30
10 142.00
11 153.30
12 155.50
13 163.00
14 176.70
15 189.50
16 199.30
Regression Model Canbe used to forcast revenues
Regression Equation :
Y=a+bX
Y=Revenue
X=Year
a:Intercept
b:Slope
Regression tool of excel can be used.
Click "Data"
Click "Analysis"
Select "Regression "tool
Input Y range , Revenue
Input X range, Year
Intercept=80.21
Slope=X Variable 1=7.165
Regression Equation:
Y=80.21+7.165X
Y=Revenue
X=Year
Revenue Forecast in 2017=80.21+7.165*17 202.02
Revenue Forecast in 2018=80.21+7.165*18 209.18
Revenue Forecast in 2019=80.21+7.165*19 216.35

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

Use the macroeconomic data in the table below for the US economy for 2017 and 2018...
Use the macroeconomic data in the table below for the US economy for 2017 and 2018 to answer the questions followed. Year NGDP in ‘000” RGDP In ‘000’ In 2009 prices RGDP Growth Rate % GDPD Inflation Rate % u-Rate % CPI Inflation Rate % 2017 2018* 19,390.6 17,096.2 - ? - 4.4 245.12 - 19,956.8 17,379.7 ? ? ? 3.9 250.5 ? * Estimated data from 2017 data, but very close. Sources: www.bea.gov and www.bls.gov 5a. Estimate the values...
Input Data 2018 2017 Ratios 2018 2017 % Variance Revenues $500,343 $485,873 1.Profitability Ratios Cost of...
Input Data 2018 2017 Ratios 2018 2017 % Variance Revenues $500,343 $485,873 1.Profitability Ratios Cost of Goods Sold 373,396 361,256 a.Gross Margin Percentage = Gross Profit ÷ Revenues 25.37% 25.65% -1.08% Gross Profit 126,947 124,617 b.EBIT Margin Percentage = EBIT ÷ Revenues 4.08% 4.69% -12.82% EBIT 20,437 22,764 Interest Expense 1,978 2,044 Resource Management Ratios: Net Income 10,523 14,293 "a. Age of Inventory = Inventories ÷ Average Daily Cost of Goods Sold" 43 43 -1.59% Accounts Receivable 5,614 5,835 "b....
Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $...
Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $ 913 $ 988 Expenses 770 810 Pretax accounting income (income statement) $ 143 $ 178 Taxable income (tax return) $ 135 $ 200 Tax rate: 40% Expenses each year include $30 million from a two-year casualty insurance policy purchased in 2018 for $60 million. The cost is tax deductible in 2018. Expenses include $2 million insurance premiums each year for life insurance on key...
Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $...
Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $ 996 $ 1,031 Expenses 784 824 Pretax accounting income (income statement) $ 212 $ 207 Taxable income (tax return) $ 210 $ 230 Tax rate: 40% Expenses each year include $30 million from a two-year casualty insurance policy purchased in 2018 for $60 million. The cost is tax deductible in 2018. Expenses include $3 million insurance premiums each year for life insurance on key...
Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $...
Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $ 996 $ 1,031 Expenses 784 824 Pretax accounting income (income statement) $ 212 $ 207 Taxable income (tax return) $ 210 $ 230 Tax rate: 40% Expenses each year include $30 million from a two-year casualty insurance policy purchased in 2018 for $60 million. The cost is tax deductible in 2018. Expenses include $3 million insurance premiums each year for life insurance on key...
Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $...
Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $ 893 $ 992 Expenses 764 804 Pretax accounting income (income statement) $ 129 $ 188 Taxable income (tax return) $ 130 $ 200 Tax rate: 40% Expenses each year include $20 million from a two-year casualty insurance policy purchased in 2018 for $40 million. The cost is tax deductible in 2018. Expenses include $2 million insurance premiums each year for life insurance on key...
This information is available for Pharoah Company for 2017, 2018, and 2019. 2017 2018 2019 Beginning...
This information is available for Pharoah Company for 2017, 2018, and 2019. 2017 2018 2019 Beginning inventory $ 103,000 $ 319,000 $ 414,500 Ending inventory 319,000 414,500 472,000 Cost of goods sold 892,000 1,120,500 1,306,000 Net sales 1,200,000 1,605,500 1,903,000 Calculate inventory turnover for Pharoah Company for 2017, 2018, and 2019. (Round answers to 2 decimal places, e.g. 1.52.) 2017 2018 2019 Inventory turnover Calculate days in inventory for Pharoah Company for 2017, 2018, and 2019. (Round answers to 1...
Winter Technologies 2018 financial statements are shown below. 2019 Sales are forecast to grow by 7%,...
Winter Technologies 2018 financial statements are shown below. 2019 Sales are forecast to grow by 7%, and dividends are forecast to increase to $1.50 per share in 2019. Create the 2019 financial statements using the percent of sales method (not the AFN equation) assuming the firm is operating at full capacity in 2018. Any extra borrowing will be done with Notes Payable and excess funds will be used to pay down Notes Payable. Interest on all interest-bearing debt is 5%...
Winter Technologies 2018 financial statements are shown below. 2019 Sales are forecast to grow by 7%,...
Winter Technologies 2018 financial statements are shown below. 2019 Sales are forecast to grow by 7%, and dividends are forecast to increase to $1.50 per share in 2019. Create the 2019 financial statements using the percent of sales method (not the AFN equation) assuming the firm is operating at full capacity in 2018. Any extra borrowing will be done with Notes Payable and excess funds will be used to pay down Notes Payable. Interest on all interest-bearing debt is 5%...
Below are the 2018 and 2019 year-end balance sheets for Tran Enterprises: Assets: 2018 2017 Cash...
Below are the 2018 and 2019 year-end balance sheets for Tran Enterprises: Assets: 2018 2017 Cash $ 200,000 $ 170,000 Accounts receivable 864,000 700,000 Inventories 2,000,000 1,400,000 Total current assets $3,064,000 $2,270,000 Net fixed assets 6,000,000 5,600,000 Total assets $9,064,000 $7,870,000 Liabilities and equity: Accounts payable $1,400,000 $1,090,000 Notes payable to bank 1,600,000 1,800,000 Total current liabilities $3,000,000 $2,890,000 Long-term debt 2,400,000 2,400,000 Common stock 3,000,000 2,000,000 Retained earnings 664,000 580,000 Total common equity $3,664,000 $2,580,000 Total liabilities and equity...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT