In 2002, the city of Louisville passed a curfew that required youngsters below the age of 16 be off city streets after 10 o'clock at night. The ordinance proved controversial and was repealed in 2003. In late 2004, however, the ordinance was reenacted and has been enforced up to the present time. City officials would now like to know if the ordinance has actually reduced youth crime and violence in the city. How will you address this?

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

Using the 2015 Comprehensive Annual Financial Report for St. Tammany Parish included, please answer the following questions.

http://www.stpgov.org/files/Departments/Finance/2015_CAFR.pdf

All questions relate to the financial statements of St. Tammany Parish for the year ended December 31, 2015. For each answer also write the page number where you found the answer. NOTE: the page number is the page number listed in the CAFR which is not the same as the page number up top in Acrobat Reader!!!

1.            The total assets of the primary government amounted to $                                                         

2.            St. Tammany Parish reports four major governmental funds. They are:

3.            How many non-major funds does St. Tammany Parish report in their CAFR?                                                                         

4.            According to the statement of activities, the parish’s top two revenue sources, excluding component units, are:

               Source                                                                                             Amount                                             

               Source                                                                                             Amount                                             

5.            Using the statement of revenues, expenditures and changes in fund balance, for the total governmental funds:

                              Total revenues                                                              

                              Total expenditures                                                       

                              Net change in fund balances                                                     

                              Year-end fund balance                                                                              

6.            According to the notes, capital assets total:

                              Governmental activities, ending balance, net                                                                    

                              Business-type activities, ending balance, net                                                                     

                              Total governmental activities depreciation expense                                                        

                              Total business-type depreciation expense                                                                          

7.            What percentage of property tax billed does St. Tammany expect to collect?                                                       

8.            According to the schedule of employer contributions, for the employees retirement system for the St. Tammany Parish Coroner’s Office for 2015

                              Employer contributions totaled                                                                             

                              Annual required contributions were                                                                      

9.            There are how many non-major governmental funds of each type

                              Special Revenue Funds                                 

                              Debt Service Funds                                        

                              Capital Project Funds                                    

                              Internal Service Funds                                  

10.         For the internal service funds, what is the

                              Total net position at 12/31/2015                                                            

                              Total change in net position for 2015                                                    

11.         What discount rate is used to measure the pension liability?                                                        

12.         For the general fund, give the following information related to the budget:

                              Original budgeted amount of total revenues                                                                     

                              Final budgeted amount of total revenues                                                            

                              Actual amount of total revenues on a budgetary basis                                                    

                              Original budgeted amount of total expenditures                                                              

                              Final budgeted amount of total expenditures                                                                    

                              Actual amount of total expenditures on a budgetary basis                                             

13.         According to the Statement of Activities, total program revenues from operating grants and contributions for government activities was                                                                      

14.         According to the Statement of Activities, total program revenues from operating grants and contributions for business-type activities was                                                                   

15.         When were property taxes

               Levied?                                             

               Due?                                                  

               Became delinquent?                                                                   

Name at least two changes brought about by Sarbanes Oxley (SOX) Act of 2002.

ACTIVITY 2

Use the information below to calculate the CPI and inflation rate

Basket                  8 pair of shoes                  4 oil changes

Compute the cost of the basket of goods.

Calculate the CPI use 2003 as the base year.

Calculate the inflation rate use beginning with the inflation rate between 2003 and 2004

Use the information below to calculate the CPI and the Inflation rate

Basket                  10 DVDs                             6 gallons of Milk

Compute the cost of the basket of goods

Calculate the CPI use 2004 as the base year.

Calculate the inflation rate beginning with the inflation rate between 2004 and 2005

Suppose a local news anchorperson in 1960 made $30,000 and the price level in 1960 was 45. Today’s price level is 210. What is the 1960’s local news anchorperson salary worth in today’s dollars.(This is similar to the Babe Ruth example in the notes

Suppose the nominal interest rate is 14% and the inflation rate is 5%. What is the real interest rate?

Suppose the real interest rate is 7% and the inflation rate is 6%. What is the nominal interest rate?

Bond Redemption

St. Wyncomb Co. issued 10 percent, $420,000 face value bonds with a 20 year maturity at 96 on Jnuary 1, 2002. The bonds are callable at 104 after one year. St. Wyncomb Co. decided to call the bonds after interest rates dropped on December 31. 2004. To finance the retirement, St. Wyncomb issued 8 percent, $440,000 face value bonds with a 20 year maturity at 102 on December 31, 2004.

1. Prepare an amortization schedule for the first three years for the original bonds, and the first two years of the new bonds.

2. Prepare the journal entries to recorn the following.

a. Issue of original bonds.

b. Annual interest payment in the year of the redemption, 2004 for the original bonds.

c. Isue of new bonds.

d. Redemption of original bonds.

e. First annual interest payment for the new bonds.

3. Prepare a T-Account for the dincount accond for the original bonds.

****Please show work so I can follow along****

Use the Housing Interest Rate database (see DATA at bottom of this question)

In this part using Housing Interest Rate database, the objective is to compare the variation in the FIXED_RATE between two periods; before 2000 and after year 2000.

• i) Using descriptive statistics measures to interpret the shape of FIXED_RATE variable, calculate any outlier(s) finally verify whether if the empirical rule applies to the FIXED_RATE distribution.  Use an appropriate graph to confirm your findings.

• ii) Use a random generating procedure to draw a random sample of size 80 with respect to the “before and after year 2000 “factor.  Indicate which sampling method you used.  Using your sample data, calculate which period shows more variation in the FIXED_RATE.  Using the sample data, what is the   sampling error of FIXED_RATE?

I WILL GIVE YOU THUMBS UP AND EXCELLENT REVIEWS FOR HELP/GUIDANCE WITH THIS. ANY HELP WILL BE GREATLY APPRECIATED! THANK YOU!

DATA:

Suppose retailers would like to forecast the percentage of customers who plan to purchase gift cards during the upcoming holiday season. The following data show this percentage from 2002 to 2009. The data is as follows:

Perform the following:

1. Using a 3-period simple moving average, forecast the percentage of holiday shoppers who will purchase a gift card in 2010.

-

2. Calculate the MAD for the forecast in part a.

3. Using a 3-period weighted moving average with the weights 5, 3, and 1, forecast the percentage of holiday shoppers who will purchase a gift card in 2010.

4. Calculate the MAD for the forecast in part c.

5. In which forecast do you have the most confidence?

Please show excel sheets for the following, answers are provided

The CPI-U for Americans 62 years of age and older (some of your professors and some of your authors are interested in this!) present the following annual inflation rates in percent:

A farmer's marketing cooperative recorded the volume of wheat harvested by its members from 1991-2004. The cooperative is interested in detecting the long-term trend of the amount of wheat harvested. The data collected is shown in the table.

                                     Wheat Harvested by Coop. Member

            Year      Time          (y, in thousands of bushels)    

            1991         1                               75

            1992         2                               78

            1993         3                               82

            1994         4                               82

            1995         5                               84

            1996         6                               85

            1997         7                               87

            1998         8                               91

            1999         9                               92

            2000        10                              92

            2001        11                              93

            2002        12                              96

            2003        13                            101

            2004        14                            102                       

Find the least squares prediction equation for the model. Use excel to conduct data analysis. Provide detailed interpretation of the results.