Questions
Based on the EViews result in Table 1, answer the following questions. Table 1: Estimated Regression...

Based on the EViews result in Table 1, answer the following questions.

Table 1: Estimated Regression Result

Dependent Variable: LGDP

Method: Least Squares

Sample: 2000Q1 2012Q4

Included observations: 52

Variable

Coefficient

Std. Error

t-Statistic

Prob.  

LM2

0.796910

0.032383

24.60868

0.0000

LREER

-0.060125

0.065220

-0.921892

0.3613

LSDR

0.051745

0.074618

0.693465

0.4914

LTBR

0.029174

0.007715

3.781436

0.0004

C

2.795406

0.427355

6.541183

0.0000

R-squared

0.986591

    Mean dependent var

13.28409

Adjusted R-squared

0.985450

    S.D. dependent var

0.429315

S.E. of regression

0.051786

    Akaike info criterion

-2.992187

Sum squared resid

0.126044

    Schwarz criterion

-2.804568

Log likelihood

82.79686

    Hannan-Quinn criter.

-2.920258

F-statistic

864.5234

    Durbin-Watson stat

0.777639

Prob(F-statistic)

0.000000

  1. Write down the estimated result. [5 marks]
  1. Examine the parameters of interest from the perspective of: (hint: used p-value)
  1. What is your conclusion about the relationship between parameter of interests based on the empirical results?
  1. Based on the empirical results in Table 1, what are the possible diagnostic problems that you observe?

In: Economics

Loretta, who turns eighty this year, has just learned about blood pressure problems in the elderly...

Loretta, who turns eighty this year, has just learned about blood pressure problems in the elderly and is interested in how her blood pressure compares to those of her peers. Specifically, she is interested in her systolic blood pressure, which can be problematic among the elderly.She has uncovered an article in a scientific journal that reports that the mean systolic blood pressure measurement for women over seventy-five is 130.4 mmHg, with a standard deviation of 6.0 mmHg. Assume that the article reported correct information. Complete the following statements about the distribution of systolic blood pressure measurements for women over seventy-five. (a) According to Chebyshev's theorem, at least ?56%75%84%89% of the measurements lie between 118.4 mmHg and 142.4. (b) According to Chebyshev's theorem, at least 36% of the measurements lie between mmHg and mmHg . (Round your answer to 1 decimal place.) (c) Suppose that the distribution is bell-shaped. According to the empirical rule, approximately 99.7% of the measurements lie between mmHg and mmHg . (d) Suppose that the distribution is bell-shaped. According to the empirical rule, approximately ?68%75%95%99.7% of the measurements lie between 118.4 mmHg and 142.4.

In: Statistics and Probability

Sun Microsystems is a leading supplier of computer-related products, including servers, workstations, storage devices, and network...

Sun Microsystems is a leading supplier of computer-related products, including servers, workstations, storage devices, and network switches. In 2009, Sun Microsystems was acquired by Oracle Corporation. In the letter to stockholders as part of the 2001 annual report, President and CEO Scott G. McNealy offered the following remarks: Fiscal 2001 was clearly a mixed bag for Sun, the industry, and the economy as a whole. Still, we finished with revenue growth of 16 percent—and that's significant. We believe it's a good indication that Sun continued to pull away from the pack and gain market share. For that, we owe a debt of gratitude to our employees worldwide, who aggressively brought costs down—even as they continued to bring exciting new products to market. The statement would not appear to be telling you enough. For example, McNealy says the year was a mixed bag with revenue growth of 16 percent. But what about earnings? You can delve further by examining the income statement in Exhibit 4. Also, for additional analysis of other factors, consolidated balance sheet(s) are presented in Exhibit 5.

Exhibit 1

                        2001 Dollars 2000 Dollars 1999 Dollars 1998 Dollars

Net revenues $ 18,550        $ 15,726           $11,804         $ 9,865

Costs and expenses:

Cost of sales $ 10,044         $ 7,543             $ 5,675          $ 4,645

Research and

development

                       2,011               1,626                1 ,273            1,034

Selling, general

and administrative

                        4,547               4,069               3,188              2,836

Goodwill

amortization

                           260                    63                    19                 0.3

In-process

research and

development

                             80                     11                  117                178

Total costs and

expenses

                    $ 16,942          $ 13,312           $ 10,272          $8,693.3

Operating Income

                       $1,608           $ 2,414             $ 1,532           $1,171.7

Gain (loss) on

strategic investments

                         $ -94                $ 206                       -                     -

Interest income, net

                        $ 362                $ 170                 $ 86                $ 48

Litigation settlement

                             -                         -                          -                   -

Income before taxes

                    $ 1,876               $ 2,790             $ 1,618         $1,219.7

Provision for income

taxes

                  $ 1,004.9             $ 969.12            $ 699.6          $ 426.2

Cumulative effect of

change in accounting

principle, net

                        $ -55                            -                     -                   -

Net income

                      $ 926.1            $1,820.88           $ 918.4          $ 793.5

Net income per

common share-

                        $ 0.27                 $ 0.54              $ 0.28           $ 0.25

diluted

Shares used in the

calculation of net

income per common

share-diluted

                           3,430             3,372                 3,280               3,174

Part A

Referring to Exhibit 1, compute the annual percentage change in net income per common share-diluted (second

Rate of change, 1998 to 1999:

Rate of change, 1999 to 2000:

Rate of change, 2000 to 2001:

Part B

Also in Exhibit 1, compute net income/net revenue (sales) for each of the four years. Begin with 1998.

1998 Profit Margin:

1999 Profit Margin:

2000 Profit Margin:

2001 Profit Margin:

Part C

Compute return on stockholders’ equity for 2000 and 2001 using data from Exhibits 1 and 2.

2000 Return on Stockholders' Equity:

2001 Return on Stockholders' Equity:

Part D

Analyze your results to Question 2 (Part B above) more completely by computing ratios 1, 2a, 2b, and 3b (these

numbers correspond with the numbered ratios listing in Chapter 3 of our textbook) for 2000 and 2001. Actually,

the answer to ratio 1 can be found as part of the answer to question 2 (Part B), but it is helpful to look at it again.

Ratio             2000                   2001

1

2a

2b

Part E

The average stock prices for each of the four years shown in Exhibit 1 were as follows:

1998 11¼

1999 16¾

2000 28½

2001 9½

Compute the price/earnings (P/E) ratio for each year. That is, take the stock price shown above and divide by net

income per common stock-dilution from Exhibit 1.

1998 P/E Ratio:

1999 P/E Ratio:

2000 P/E Ratio:

2001 P/E Ratio:

In: Finance

You own five apartment complexes. You created a dataset listing the apartment numbers, apartment complex names, number of bedrooms, rental price, whether the apartment is occupied or not, and the date the apartment was last remodeled.

You own five apartment complexes. You created a dataset listing the apartment numbers, apartment complex names, number of bedrooms, rental price, whether the apartment is occupied or not, and the date the apartment was last remodeled. You want to insert some functions to perform calculations to help you decide which apartments need to be remodeled. To focus on the apartments that need to be remodeled, you will use advanced filtering and database functions for your analysis. Finally, you are considering purchasing a sixth apartment complex. You will perform some financial calculations and analysis to help you decide if you will purchase the complex.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Open exploring_e07_grader_h1_Apartment.xlsx and save it asexploring_e07_grader_h1_Apartment_LastFirst.

0

2

In cell G8 in the Summary worksheet, insert a date function to calculate the number of years between 1/1/2018 in cell H2 and the last remodel date in the Last Remodel column (cell F8). Use relative and mixed references correctly. Copy the function to the range G9:G57. Unit 101 was last remodeled 13.75 years ago. Ensure that the function you use displays that result.

6

3

In cell H8, insert a nested logical function to display the required pet deposit for each unit. If the unit has two or more bedrooms (C8) AND was remodeled less than 10 years ago (cell H3), the deposit is $275 (cell H4); if not, the deposit is $200 (cell H5). Use relative and mixed references correctly. The pet deposit for Unit 101 is $200.

5

4

In cell I8, enter a nested logical function to display Need to Remodel if the apartment is unoccupied (No) AND was last remodeled more than 10 years ago (H3). For all other apartments, display No Change. Although Unit 101 was last remodeled over 10 years ago, the recommendation is No Changebecause the unit is occupied.

5

5

Copy the functions in the range H8:I8 to the range H9:I57.

2

6

In cell B3 insert a nested MATCH function within an INDEX function that will look up the rental price in column D using the apartment number referenced in cell B2. With 101 entered in cell B2, the lookup function displays $950.00.

5

7

In the Database sheet, enter conditions in the criteria range for unoccupied two- and three-bedroom apartments that need to be remodeled. Enter criteria as text only, without use of quotation marks. Be sure to enter the criteria separately in rows 3 and 4.

6

8

Apply an advanced filter based on the criteria range (A2:H4). Filter the existing database (range A15:H65) in place. Nine apartments meet the advanced filter conditions.

5

9

In cell C8, use the DCOUNTA database function to calculate the number of apartments that need to be remodeled based on the advanced filter you created.

5

10

In cell C9, enter a database function to calculate the total value of monthly rent lost for the apartments that need to be remodeled based on the advanced filter you created.

5

11

In cell C10, enter a database function to display the date of the apartment that had the oldest remodel date based on the filtered data. Format the result with Short Date format.

5

12

In the Loan sheet, insert formulas in the range E2:E4 to calculate the loan amount, the number of payment periods, and the monthly interest rate, respectively. Use cell references in all formulas.

6

13

In cell E5, enter a financial function to calculate the monthly payment. In cell E6, insert a financial function to calculate the cumulative total interest paid throughout the loan. Make sure the results display as positive numbers.

8

14

In cell C11, enter a formula to reference the date stored in cell B7. Insert a nested function in cell C12 to calculate the date for the next payment. Nest the YEAR, MONTH, and DAY functions within the DATE function. Add 1 to the month result. Copy the function to the range C13:C34.

6

15

In cell D11, enter a formula to reference the value stored in cell E2. Insert a formula in cell D12 that references the ending balance for the previous payment row (G11). Copy the formula in D12 to the range D13:D34.

5

16

In cell E11, enter a financial function to calculate the interest paid. Copy the formula to the range E12:E34. The result should be a positive value.

6

17

In cell F11, enter a financial function to calculate the principal payment. Copy the function to the range F12:F34. The result should be a positive value.

6

18

In cell G11, enter a formula to calculate the ending balance. Copy the formula to the range G12:G34. Adjust the width of column G, if needed, to display the values. Select the range D11:G34 and apply Accounting Number Format.

6

19

In cell I4 insert a financial function to calculate the present value of the total monthly rent you will collect for the 8 units for 30 years. Use the number of periods and monthly rate in the Summary Calculations section and the cell references in the What If section. The result should be a positive value.

5

20

In the Loan sheet, set 0.5" left and right margins and repeat row 10 on all pages.

3

21

Save and close the workbook, and submit the file as directed.

0

 

Total Points

100

In: Statistics and Probability

Baci is a well-known lollipops maker in Western Australia and produces lollipops in two size, i.e.,...

Baci is a well-known lollipops maker in Western Australia and produces lollipops in two size, i.e., regular and large. The company sells their products to convenience stores, fairs, schools for fundraisers and in bulk on the internet. 2018 summer is approaching and Baci is preparing its budget for the December. All Baci’s lollipops are hand-made, mostly out of sugar, and attached to wooden sticks. Expected sales are based on past experience.

Other information for December 2018 is as follows:

Input prices :

Direct materials:

Sugar $0.50 per kg

Sticks $0.30 each

Direct manufacturing labour $8 per direct manufacturing labour hour (DMLH)

Input quantities per unit of output

Regular Large

Direct materials:

Sugar 0.25 kg 0.5 kg

Sticks 1 1

Direct manufacturing labour hour (DMLH) 0.2 hour 0.25 hour

Set-up hours per batch 0.08 hour 0.09 hour

Inventory data for direct materials1

Sugar Sticks

Beginning inventory 125 kg 350

Target ending inventory 240 kg 480

Cost of beginning inventory $64 $105

1: Baci accounts for direct materials using a FIFO cost flow assumption.

Sales and inventory data for finished goods2

Regular Large

Expected sales in units 3,000 1,800

Selling price $3 $4

Target ending inventory in units 300 180

Beginning inventory in units 200 150

Beginning inventory in dollars $500 $474

2: Baci uses a FIFO cost flow assumption for finished goods inventory.

All the lollipops are made in batches of 10. Baci incurs manufacturing overhead cost, and marketing and general administration costs, but customers pay for shipping. Other 3 than manufacturing labour costs, monthly processing costs are very small. Baci uses activity-based costing (ABC) and has classified all overhead costs for December 2018 as follows:

Cost type Denominator activity Rate

Manufacturing:

Set-up Set-up hours $20 per set-up hour

Processing Direct manufacturing labour hour (DMLH) $1.70 per DMLH

Non-manufacturing:

Marketing & general admin Sales revenue 10%

2. Baci’s balance sheet for 30 November 2018 follows. Use it and the following information to prepare a cash budget for Baci for December 2018:

• 80% of sales are on account, of which 50% are collected in the month of the sale, 49% are collected the following month and 1% are never collected and written off as bad debts.

• All purchases of materials are on account. Baci pays for 70% of purchases in the month of purchase and 30% in the following month.

• All other costs are paid in the month incurred.

• Baci is making monthly interest payments of 1% (12% per year) on a $20,000 long-term loan.

• Baci plans to pay the $500 of taxes owed as of 30 November 2018 in December 2018. Income tax expense for December is zero.

•40% of processing and set-up costs, and 30% of marketing and general administration costs, are depreciation.

Baci Balance Sheet as of 30 November 2018

Assets

Cash $587

Account receivable $4,800

Less: Allowance for bad debts 96 4,704

Inventories:

Direct materials 169

Finished goods 974

Fixed assets $190,000

Less: Accumulated depreciation 55,759 134,241

Total assets $140,675

Liabilities and equity

Account payable $696

Taxes payable 500

Interest payable 200

Long-term debt 20,000

Ordinary shares 10,000

Retained earnings 109,279

Total liabilities and equity $140,675

require 3. Prepare a budgeted income statement for December 2018 and a budgeted balance sheet for Baci as of 31 December 2018.

In: Accounting

Summarize (in your own words) the interventions the author(s) suggest to improve patient outcomes. Tanner, J.,...

Summarize (in your own words) the interventions the author(s) suggest to improve patient outcomes.

Tanner, J., Dumville, J. C., Norman, G., & Fortnam, M. (2016). Surgical hand antisepsis to reduce surgical site infection. Cochrane Database of Systematic Reviews, Issue 1. Art. No.: CD004288. DOI: 10.1002/14651858.CD004288.pub3.

In: Nursing

The sales forecast is often the starting point of the budgeting process. Identify and discuss key...

The sales forecast is often the starting point of the budgeting process. Identify and discuss key assumptions that are made in the creation of the sales forecast. How would you defend these assumptions when presenting your budget to the budget committee?

Please type out and use a different answer than what's already on the Chegg database please and thank you

In: Accounting

What strategic competitive benefits do you see in a company’s use of extranets?

 

Q1: Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.

Q2: What strategic competitive benefits do you see in a company’s use of extranets?

In: Computer Science

Answer these questions using the Federal Reserve Bank of St. Louis's database. Calculate the 12-month percentage...

Answer these questions using the Federal Reserve Bank of St. Louis's database.

Calculate the 12-month percentage increase in the consumer price index, and plot this, along with the unemployment rate. Do you observe a positive correlation, a negative correlation, or a correlation that is essentially zero? Can you find a Phillips curve relation or reverse Phillips curve?

In: Economics

: Pam Tarver just opened an information technology consulting company and has thought for a long...

: Pam Tarver just opened an information technology consulting company and has thought for a long time about what to name it. She finally settled on the fictitious name Infoxx. Search the USPTO database to determine if the name Infoxx is available. Is it? If it is available, describe how Pam would go about obtaining a trademark on Infoxx or any other name.

In: Operations Management