The following data show the average Home Price Index over a six-quarter period. Complete parts a through e below Q1 2016 Q2 2016 Q3 2016 Q4 2016 01 2017 Q2 2017- 190.7 194.7 194.7 198.4 185.5 200.4 Quarter Index a. Forecast the price index for Q3 2017 using a two-period simple moving average. The forecasted price index is 199.4 (Round to two decimal places as needed.) b. Calculate the MAD for the forecast in part a MAD= (Round to two decimal places as needed)

The population of Utica NY reached its peak around 1930, when it was about 101 740 people By 1970 the population had declined to 91,611 people. In 2010, the Utica population was at 62,236 people Complete the table below by filling in the absolute and relative decreases Round the relative decrease to the nearest tenth of a percent when necessary Ending Year 1970 Starting Year Absolute Decrease Relative Decrease 1930 1970 2010 1930 2010

Which of the following is the correct excel formula that describes the monthly payment of a loan ($800) that is fixed with an APR of 0.99% that lasts for 15 years? Group of answer choices =PMT(.0099/12,15*12,-800) =PMT(0.0099,12*15,-800) =PMT(0.0099/12,15,-800) =PMT(0.99/12,12*15,-800) =PMT(.099/12,180,-800)

Express the rate of inflation from 1985 to 2015 as a percent correct to two decimal places. (see graph)

Assuming that all net sales figures are at retail and all cost of goods sold figures are at cost, calculate the average inventory (in $) and inventory turnover for the following. If the actual turnover is less than the published rate, calculate the target average inventory necessary to come up to industry standards. If the actual turnover is greater than the published rate, enter "above" for target average inventory. Round inventories to the nearest dollar and inventory turnovers to the nearest tenth

As one of the loan officers for Grove Gate Bank, calculate the monthly principal and interest, PI (in $), using this table and the monthly PITI (in $) for the mortgage. (Round dollars to the nearest cent.) AmountFinanced InterestRate Termof Loan(years) MonthlyPI AnnualPropertyTax AnnualInsurance MonthlyPITI $230,000 9.50% 25 $  $6,573 $2,126 $

The table below shows the year open and year closing price of the S&P 500 Stock Index from 2005 to 2020:   Year Year Open Year Close Annual Percent Change 2005  $  1,202.08  $  1,248.29   2006  $  1,268.08  $  1,418.30   2007  $  1,416.60  $  1,468.36   2008  $  1,447.16  $     903.25   2009  $     931.80  $  1,115.10   2010  $  1,132.99  $  1,257.64   2011  $  1,271.87  $  1,257.60   2012  $  1,277.06  $  1,426.19   2013  $  1,462.42  $  1,848.36   2014  $  1,831.98  $  2,058.90   2015  $  2,058.20  $  2,043.94   2016  $  2,012.66  $  2,238.83   2017  $  2,257.83  $  2,673.61   2018  $  2,695.81  $  2,506.85   2019  $  2,510.03  $  3,230.78   2020  $  3,257.85  $  3,756.07     Find the annual percent change for the S&P 500 from 2005 to 2020; (Put those values in the table above)   Compute the mean,…

Virginia Community College Syst X N Quiz: Quiz 2 - Unit 3 s/355859/quizzes/2912611/take Year CPI 2009 214.5 2010 218.1 2011 224.9 2012 229.6 2013 233.0 2014 236.7 2015 237.0 2016 240.0 Calculate the rate of inflation from 2011 to 2016. (round to the nearest tenth of a percent)

Complete the following table and draw a graph showing how bond price for each bond changes over time as they move towards their maturity dates. Describe the relationship between bond prices and time remaining for maturity. Using the table below show all the calculations for every bond prices calculated  Years remaining to maturity BOND A Coupon rate = 8% p.a. Market interest rate = 6% p.a. BOND B Coupon rate = 6% p.a. Market interest rate = 6% p.a. BOND C Coupon rate = 4% p.a. Market interest rate = 6% p.a. 10       9       8       7       6       5       4       3       2       1       0

Calculate the average inventory (in $) and inventory turnover ratio for the given company. (Round the inventory turnover ratio to one decimal place.) Company BeginningInventory EndingInventory AverageInventory Cost ofGoods Sold InventoryTurnover a hardware store $315,220 $300,070 $  $4,856,470