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 |
|||
In: Economics
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 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 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., 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., 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 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
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 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 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