Questions
Year Large Company US Treasury Bill 1    3.92 5.90 2   14.18 2.53 3   19.37 3.76 4...

Year Large Company US Treasury Bill
1    3.92 5.90
2   14.18 2.53
3   19.37 3.76
4 –14.31 7.16
5 –31.80 5.42
6   37.08 6.24
a.

Calculate the arithmetic average returns for large-company stocks and T-bills over this period. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

Average returns
  Large company stocks %
  T-bills %
b.

Calculate the standard deviation of the returns for large-company stocks and T-bills over this period. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

Standard deviation
  Large company stocks %
  T-bills %
c-1

Calculate the observed risk premium in each year for the large-company stocks versus the T-bills. What was the average risk premium over this period? (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

  Average risk premium %
c-2

Calculate the observed risk premium in each year for the large-company stocks versus the T-bills. What was the standard deviation of the risk premium over this period? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

  Standard deviation %

In: Finance

x 1 2 3 4 5 6 y 608 619 674 672 676 721 Use exponential...

x 1 2 3 4 5 6
y 608 619 674 672 676 721



Use exponential regression to find an exponential function that best fits this data.

f(x) =     

Use linear regression to find an linear function that best fits this data.

g(x) =    

In: Math

Servings MU boeuf bourguignon 1 $60.00 2 $58.00 3 $56.00 4 $54.00 5 $52.00 6 $50.00...

Servings

MU boeuf bourguignon

1

$60.00

2

$58.00

3

$56.00

4

$54.00

5

$52.00

6

$50.00

7

$48.00

8

$46.00

9

$44.00

10

$42.00

11

$40.00

12

$38.00

13

$36.00

14

$34.00

Production. Ella makes boeuf bourguignon using equipment that she rents for $75 and beef, potatoes, wine and other ingredients that cost $12.50 a serving. (Note that she signed a lease and pays the rent regardless of how many dinners she serves.) She hires workers at $25 each and finds that they produce servings according to the following schedule:

Servings

Total Workers

1

0.30

2

1.00

3

1.90

4

3.00

5

4.30

6

5.80

7

7.50

8

9.40

9

11.50

10

13.80

11

16.30

12

19.00

13

21.90

14

25.00

a. Calculate and graph the marginal cost of each serving. (Use a spreadsheet show all your calculations!) Why does the MC curve have the slope (up, down, or flat) that it does?

b. Calculate and graph the marginal cost of each serving if workers become more productive so each serving can be made with only 70% as much labor. Show your calculations! Calculate and graph marginal cost if workers suffer a 30% pay cut with the old productivity. Compare the effect on MC of the productivity increase with the pay cut.

In: Economics

Division Profitability Quarter 1 Quarter 2 Quarter 3 Quarter 4 graph GROSS PROFIT Revenues 0 0...

Division Profitability
Quarter 1 Quarter 2 Quarter 3 Quarter 4 graph
GROSS PROFIT
Revenues 0 0 1,056,604 1,597,853
- Rebates 0 0 16,500 23,750
- Cost of Goods Sold 0 0 410,486 581,268
= Gross Profit 0 0 629,618 992,835
EXPENSES
Store Leases 0 0 90,000 144,000
+ Sales and Service Personnel Expense 0 0 99,571 149,429
+ Brand Promotions 0 0 0 0
+ Special Programs 0 0 0 0
+ Ad Creation/Revision 0 0 24,000 12,000
+ Point of Purchase Display Expenses 0 0 800 1,800
+ Advertising Expenses 0 0 17,454 34,747
+ Internet Marketing Expenses 0 0 2,000 2,000
+ Engineering Cost for New Brands 0 150,000 0 90,000
+ Market Research 88,000 0 20,000 60,000
= Operating Expenses 88,000 150,000 253,825 493,976
Operating Profit -88,000 -150,000 375,793 498,859
MISCELLANEOUS INCOME AND EXPENSES
+ Other Income 0 0 0 0
- Other Expenses 0 0 0 0
- Research and Development Costs 0 0 0 0
- Set Up Costs for New Stores 0 438,000 146,000 180,000
= Net Profit for Division -88,000 -588,000 229,793 318,859
Cumulative Net Profit for Division -88,000 -676,000 -446,207 -127,348

I am needing projections of profits of the next three quarters?

What would the return on investment be by the end of the second year?

In: Accounting

Month housing index 0 183.28 1 187.11 2 191.62 3 196.02 4 200.47 5 202.31 6...

Month housing index
0 183.28
1 187.11
2 191.62
3 196.02
4 200.47
5 202.31
6 204.82
7 207.20
8 209.31
9 210.72
10 212.70
11 214.13
12 215.51
13 216.41
14 217.40
15 218.82
16 219.29
17 218.82
18 218.03
19 216.55
20 214.98
21 214.31
22 213.56
23 213.37
24 213.27
25 213.16
26 214.62
27 214.88
28 215.32
29 213.53
30 210.78
31 207.97
32 205.57
33 204.52
34 203.11
35 199.65
36 194.70
37 190.00
38 186.64
39 178.85
40 172.55
41 166.74
42 162.56
43 158.50
44 154.10
45 148.16
46 142.83
47 137.59
48 134.68
49 130.64
50 126.66
51 123.96
52 121.08
53 120.18
54 119.87
55 123.34
56 126.15
57 129.24
58 131.55
59 134.03
60 136.12
61 137.03
62 138.50
63 139.29
64 140.93
65 141.74
66 141.40
67 140.53
68 139.85
69 139.18
70 138.88
71 137.24
72 136.98
73 136.91
74 136.54
75 134.74
76 133.72
77 133.53
78 133.20
79 134.00
80 134.60

use the index to determine the value of the condo each month.

An investor bought a $120,000 condo by putting 20% down and borrowing the rest using a 15 year mortgage with an annual rate of 4.8%. ignore the opportunity cost of the down payment to the investor. Calculate the monthly payments. Three years later she sold the condo, what was her return on her investment?( think IRR or Rate) What percentage of her equity at the time of the sale was due to the change in the value of the condo?

create a data table with the return on investment as the output. the column input is the down payment percent ,going from 0% to 20% in increments of 5%. the row input is the mortgage rate, going from 4% to 6% in increments of 0.5%. Discuss your findings from the data table. what price would she have to sell the condo after three years in order to make a return of 0.5% a month?

In: Finance

Exercise 14-4 Prepare a Statement of Cash Flows [LO14-1, LO14-2] The following changes took place last...

Exercise 14-4 Prepare a Statement of Cash Flows [LO14-1, LO14-2] The following changes took place last year in Pavolik Company’s balance sheet accounts: Asset and Contra-Asset Accounts Liabilities and Stockholders' Equity Accounts Cash $ 5 D Accounts payable $ 35 I Accounts receivable $ 110 I Accrued liabilities $ 4 D Inventory $ 70 D Income taxes payable $ 8 I Prepaid expenses $ 9 I Bonds payable $ 150 I Long-term investments $ 6 D Common stock $ 80 D Property, plant, and equipment $ 185 I Retained earnings $ 54 I Accumulated depreciation $ 60 I D = Decrease; I = Increase. Long-term investments that cost the company $6 were sold during the year for $16 and land that cost $15 was sold for $9. In addition, the company declared and paid $30 in cash dividends during the year. Besides the sale of land, no other sales or retirements of plant and equipment took place during the year. Pavolik did not retire any bonds during the year or issue any new common stock. The company’s income statement for the year follows: Sales $ 700 Cost of goods sold 400 Gross margin 300 Selling and administrative expenses 184 Net operating income 116 Nonoperating items: Loss on sale of land $ (6 ) Gain on sale of investments 10 4 Income before taxes 120 Income taxes 36 Net income $ 84 The company’s beginning cash balance was $90 and its ending balance was $85. Required: 1. Use the indirect method to determine the net cash provided by operating activities for the year. 2. Prepare a statement of cash flows for the year.

In: Accounting

Absences Grade (Marks) 0 89.2 1 86.4 2 83.5 3 81.1 4 78.2 5 73.9 6...

Absences Grade (Marks)
0 89.2
1 86.4
2 83.5
3 81.1
4 78.2
5 73.9
6 64.3
7 71.7
8 65.5
9 66.2
5 72.4
6 67.5
1 85
1 86.9
1 83.7
2 82.7
3 81
3 80.9
2 83
2 82.2
3 81
4 77.6
5 72.9
6 61.2
7 66.9
5 70.8
9 65.2
8 55.9
5 71.8
2 85.5

An Economics professor is trying to investigate the relationship between the number of times students were absent during the semester and their numerical grades. The data represents the grades of 30 randomly selected students from his economics class along with the number of times they were absent.

Using Excel make a scatterplot.

Does it appear to be a positive or negative relationship?

Explain your answer.

What are the independent and dependent variables?

                      Independent Variable:

                      Dependent Variable:

In: Statistics and Probability

Month Revenue ($000) 1 700 2 740 3 710 4 695 5 760 6 810 7...

Month Revenue ($000)
1 700
2 740
3 710
4 695
5 760
6 810
7 750
8 820
9 730
10 710
11 720
12 760
13 800
14 820
15 770
16 740
17 690
18 680
19 710
20 740

Monthly revenue for the past 20 months of all the products sold in the Health and Beauty Department of Green Corporation is contained in the Excel data file. Use that data to answer the following.

  1. Obtain a Moving Average forecast of the data using 3 periods to get the moving average – i.e., MA3 forecast. Plot the results on one chart with the plots showing both the actual line and the MA3 line. Show the screenshot of the plot (copy as picture and paste) below. What is the MAD of this forecast? What is the MAPE?

  1. Obtain the Exponential Smoothing (ES) Forecast using a = 0.25. Plot the results on one chart with the plots showing both the actual line and the ES forecast line. Show the screenshot of the plot (copy as picture and paste) below. What is the MAD of this forecast? What is the MAPE?

In: Statistics and Probability

1.How would you effectively limit the use of social media? Name 4 effective ways. 2.Name four...


1.How would you effectively limit the use of social media? Name 4 effective ways.

2.Name four important ways social media may be used.

3. List four dangers of using social media.

4. What is your own comfort level with computers and social media?

In: Nursing

Trial Balance Debit Credit 1. Cash 70,000 2. Account Receivable 16,500 3. Prepaid Insurance 2,500 4....

Trial Balance

Debit

Credit

1.

Cash

70,000

2.

Account Receivable

16,500

3.

Prepaid Insurance

2,500

4.

Supplies

13,000

5.

Equipment

16,000

6.

Accounts Payable

15,000

7.

Unearned Revenue

11,400

8.

Notes Payable

22,300

9.

Capital

49,000

10.

Drawings

1,500

11.

Service Revenue

55,000

12.

Salaries Expense

15,000

13.

Utilities Expense

4,000

14.

Rent Expense

11,900

15.

Supplies Expense

2,300

152,700

152,700

Income Statement

Revenues

  • Service Revenue

55,000

Total Revenues

55,000

Expanses

  • Salaries Expense

15,000

  • Utilities Expense

4,000

  • Rent Expense

11,900

  • Supplies Expense

2,300

Total Expenses

33,200

Net Income

21,800

Owner’s Equity Statement

Opening Capital

49,000

Net Income

21,800

Subtotal

70,800

Drawing

1,500

Ending Capital

69,300

Balance Sheet

Assets

Cash

70,000

Account Receivable

16,500

Prepaid Insurance

2,500

Supplies

10,000

Equipment

28,000

Total Assets

127,000

Liabilities

Accounts Payable

15,000

Unearned Revenue

11,400

Notes Payable

22,300

Capital

69,300

Total Liabilities

118,000

Trying to prepare a financial statement for the trial balance transactions, can someone point to me where is my mistake or what I did wrong in my answer.. the balance sheet is not even. thanks.

Note: Feel free to modify or substitute any entry in the trial balance if needed.

In: Accounting