| 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 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 |
|
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
| 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 | 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 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 | 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 | 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.
In: Statistics and Probability
In: Nursing
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 |
||
|
55,000 |
|
|
Total Revenues |
55,000 |
|
|
Expanses |
||
|
15,000 |
|
|
4,000 |
|
|
11,900 |
|
|
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