Questions
We want to investigate now whether the average occupancy rate in May differs across the three...

We want to investigate now whether the average occupancy rate in May differs across the three regions.2.1 State the null and alternative hypotheses for the above research question.2.2 Conduct a Levene test for the homogeneity of the variances at the 10% level using the absolute deviations from the median. Make sure you state both the null and alternative hypotheses and the conclusions of your test.2.3 Test the null hypothesis in 1.1 at the 10% significance level.2.4 What can you conclude from the above test in 2.3? Explain the importance of the results in 2.2 for the procedure you performed in 2.3.

region id 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3

OR_MAY
60
86
93
89
74
81
83
71
90
83
77
82
90
81
20
87
48
60
45
80
65
60
75
15
16
97
74
62
40
82
24
49
16
60
42
68
55
75
35
0
40
40
10
83
50
77
81
37
27
49
53
60
80
58
64
65
68
75
55
60
56
10
85
4
24
85
75
44
45
0
34
35
70
65
15
40
10
10
35
50
2
0
3
30
15
83
91
85
80
50
79
92
87
84
65
86
62
70
87
87
50
61
59
77
46
81
48
15
80
52
90
90
75
20
10
30
53
52
90
53
48
84
90
35
25
35
10
10
60
70
3
10
10
75
10

In: Statistics and Probability

We want to investigate now whether the average occupancy rate in May differs across the three...

We want to investigate now whether the average occupancy rate in May differs across the three regions.2.1 State the null and alternative hypotheses for the above research question.2.2 Conduct a Levene test for the homogeneity of the variances at the 10% level using the absolute deviations from the median. Make sure you state both the null and alternative hypotheses and the conclusions of your test.2.3 Test the null hypothesis in 2.1 at the 10% significance level.2.4 What can you conclude from the above test in 2.3? Explain the importance of the results in 2.2 for the procedure you performed in 2.3.

region id 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3

OR_MAY
60
86
93
89
74
81
83
71
90
83
77
82
90
81
20
87
48
60
45
80
65
60
75
15
16
97
74
62
40
82
24
49
16
60
42
68
55
75
35
0
40
40
10
83
50
77
81
37
27
49
53
60
80
58
64
65
68
75
55
60
56
10
85
4
24
85
75
44
45
0
34
35
70
65
15
40
10
10
35
50
2
0
3
30
15
83
91
85
80
50
79
92
87
84
65
86
62
70
87
87
50
61
59
77
46
81
48
15
80
52
90
90
75
20
10
30
53
52
90
53
48
84
90
35
25
35
10
10
60
70
3
10
10
75
10

In: Statistics and Probability

We want to investigate now whether the average occupancy rate in May differs across the three...

We want to investigate now whether the average occupancy rate in May differs across the three regions.2.1 State the null and alternative hypotheses for the above research question.2.2 Conduct a Levene test for the homogeneity of the variances at the 10% level using the absolute deviations from the median. Make sure you state both the null and alternative hypotheses and the conclusions of your test.2.3 Test the null hypothesis in 1.1 at the 10% significance level.2.4 What can you conclude from the above test in 2.3? Explain the importance of the results in 2.2 for the procedure you performed in 2.3.

region id 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3

OR_MAY
60
86
93
89
74
81
83
71
90
83
77
82
90
81
20
87
48
60
45
80
65
60
75
15
16
97
74
62
40
82
24
49
16
60
42
68
55
75
35
0
40
40
10
83
50
77
81
37
27
49
53
60
80
58
64
65
68
75
55
60
56
10
85
4
24
85
75
44
45
0
34
35
70
65
15
40
10
10
35
50
2
0
3
30
15
83
91
85
80
50
79
92
87
84
65
86
62
70
87
87
50
61
59
77
46
81
48
15
80
52
90
90
75
20
10
30
53
52
90
53
48
84
90
35
25
35
10
10
60
70
3
10
10
75
10

In: Statistics and Probability

1 a b c 2 Aspen Industries INCOME STATEMENT 3 4 2004 2003 5 sales 285000...

1 a b c
2

Aspen Industries

INCOME STATEMENT

3
4 2004 2003
5 sales 285000 190,000
6

cost of goods sold

215000 143000
7 g. profit 70000 47000
8 operating expenses
9 variable expenses 28500 19000
10 fixed exp. 21000 20000
11 depreciation 10000

4500

12 total 59500 43500
13 EBIT 10500 3500
14 INTEREST EXP. 6100 3000
15 EBT 4400 500
16 TAXES 1540 175
17 NET INCOME 2860 325
18
19 NOTE
20 TAX RATE 35%
21 PAYOUT RATON 30%
22 DIVIDENTS 858
A b c
BALANCE SHEET
4 2003 2004
5 ASSETS
6

Cash

4,000

9,000

7

Accounts Receivable

16,000

12,500

8

Inventories

42,500

29,000

9 TOTAL C.A. 62500

50,500

10

Land

26,000

20,000

11

Buildings and Equipment

100,000

70,000

12

Accumulated Depreciation

(38,000)

(28,000)

13

Total Fixed Assets

88,000

62,000

14

Total Assets

150,500

112,500

15
16

Liabilities and Owner's Equity

17

Accounts Payable

22,298

10500
18

Short-term Bank Notes

47,000

17000
19

Total Current Liabilities

69,298

27,500

20

Long-term Debt

22,950

28,750

21

Common Stock

31,500

31,500

22

Retained Earnings

26,752

24,750

23

Total Liabilities and Owner's Equity

150,500

112,500

a. (6 points) Re-create the income statement and balance sheet using formulae wherever possible. Each statement should be on a separate worksheet. Try to duplicate the format exactly.

b. (4 points) On another worksheet, create a statement of cash flows for 2004. Do not enter any numbers directly on this worksheet. All formulae should be linked directly to the source on previous worksheets.

c. (1 point) Using Excel’s outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section.

d. (2 points) Suppose that sales were $320,000 in 2004 rather than $285,000 (all other information remains unchanged). What is the 2004 net income and retained earnings?

e. (2 points) Undo the changes from Part d, and change the tax rate to 40% (all other information remains unchanged). What is the 2004 net income and retained earnings?

In: Accounting

Nearly a decade-and-a-half ago The Economist magazine noted (“Pop, Crackle, Snap,” April 3, 2004), “Even desperate...

Nearly a decade-and-a-half ago The Economist magazine noted (“Pop, Crackle, Snap,” April 3, 2004), “Even desperate job-seekers think twice about accepting hazardous work such as coal-mining, cow slaughtering or cleaning up asbestos sites.” Oh, really?!? Suppose different types of people have different tastes for wages and safety. Specifically, Type 1 people are very safety-oriented while Type 2 will do “anything” for money. Suppose employers are able to provide different combinations of wages and safety. Specifically, for Type A employers safety is relatively easy/inexpensive to provide. For Type B employers safety is relatively difficult/expensive to provide.

A. Draw and identify the different workers’ indifference curves for wages and safety. Explain which curve(s) represents which type of worker.

B. Draw and identify the different firms’ isoprofit curves for wages and safety. Explain which curve(s) represents which firm.

C. Given your answers in Parts A and B above, use suitable economic analysis to demonstrate whether or not people can be persuaded to do dangerous work.

In: Economics

The comparative balance sheets for 2021 and 2020 and the income statement for 2021 are given...

The comparative balance sheets for 2021 and 2020 and the income statement for 2021 are given below for Arduous Company. Additional information from Arduous’s accounting records is provided also.

ARDUOUS COMPANY
Comparative Balance Sheets
December 31, 2021 and 2020
($ in millions)
2021 2020
Assets
Cash $ 142 $ 100
Accounts receivable 209 232
Investment revenue receivable 25 23
Inventory 226 219
Prepaid insurance 23 32
Long-term investment 213 144
Land 235 169
Buildings and equipment 437 438
Less: Accumulated depreciation (117 ) (158 )
Patent 53 56
$ 1,446 $ 1,255
Liabilities
Accounts payable $ 69 $ 103
Salaries payable 25 37
Interest payable (bonds) 27 23
Income tax payable 31 38
Deferred tax liability 49 27
Notes payable 33 0
Lease liability 101 0
Bonds payable 234 313
Less: Discount on bonds (41 ) (46 )
Shareholders’ Equity
Common stock 487 429
Paid-in capital—excess of par 133 104
Preferred stock 94 0
Retained earnings 232 227
Less: Treasury stock (28 ) 0
$ 1,446 $ 1,255
ARDUOUS COMPANY
Income Statement For Year Ended
December 31, 2021
($ in millions)
Revenues and gain:
Sales revenue $ 589
Investment revenue 30
Gain on sale of treasury bills 2 $ 621
Expenses and loss:
Cost of goods sold 199
Salaries expense 92
Depreciation expense 13
Amortization expense 3
Insurance expense 26
Interest expense 47
Loss on sale of equipment 34
Income tax expense 55 469
Net income $ 152


Additional information from the accounting records:

  1. Investment revenue includes Arduous Company’s $25 million share of the net income of Demur Company, an equity method investee.
  2. Treasury bills were sold during 2021 at a gain of $2 million. Arduous Company classifies its investments in Treasury bills as cash equivalents.
  3. Equipment originally costing $108 million that was one-half depreciated was rendered unusable by a flood. Most major components of the equipment were unharmed and were sold for $20 million.
  4. Temporary differences between pretax accounting income and taxable income caused the deferred tax liability to increase by $22 million.
  5. The preferred stock of Tory Corporation was purchased for $44 million as a long-term investment.
  6. Land costing $66 million was acquired by issuing $33 million cash and a 10%, four-year, $33 million note payable to the seller.
  7. The right to use a building was acquired with a 15-year lease agreement; present value of lease payments, $107 million. Annual lease payments of $6 million are paid at the beginning of each year starting January 1, 2021.
  8. $79 million of bonds were retired at maturity.
  9. In February, Arduous issued a stock dividend (11.6 million shares). The market price of the $5 par value common stock was $7.50 per share at that time.
  10. In April, 1 million shares of common stock were repurchased as treasury stock at a cost of $28 million.


Required:
Prepare the statement of cash flows for Arduous Company using the indirect method. (Amounts to be deducted should be indicated with a minus sign. Enter your answers in millions (i.e., 10,000,000 should be entered as 10).)

In: Accounting

Beginning account balances for 2019 Cash 150.000 , Land 20,000 , supplies 50,000 , unearned revenue...

Beginning account balances for 2019

Cash 150.000 , Land 20,000 , supplies 50,000 , unearned revenue 100,000 , common stock , 100,000 , retaines earnings 20,000

The following are the general journal information of Maxwell Company for 2019.

Maxwell Company

General Journal, 2019

Event

Account Titles

Debit

Credit

1.

Cash

30,000

                               Bank Loan

30,000

2.

Office Equipment

15,000

                               Cash

15,000

3

Account Receivable

35,000

                               Service Revenue

35,000

4.

Cash

15,000

                               Account Receivable

15,000

5.

Dividends

5,000

                               Cash

5,000

6.

Prepaid Rent

12,000

                               Cash

12,000

7.

Unearned Revenue

50,000

                               Service Revenue

50,000

8.

Rent Expense

      6,000

                               Prepaid Rent

       6,000

9.

Supplies Expense

10,000

                                 Supplies

10,000

Required: [ 13 Marks]

  1. Prepare T- Account [5 Marks]                                                                                    
  2. Prepare Trial Balance [3 Marks]
  3. Prepare Income Statement [2 Marks]
  4. Prepare Balance Sheet [3 Marks]

In: Accounting

Galaxy Industries Limited is a large publicly listed company and is the market leader in vacuum...

Galaxy Industries Limited is a large publicly listed company and is the market leader in vacuum cleaner
manufacturing in New Zealand. The company is looking to set up a manufacturing plant overseas to produce a
new line of commercial vacuum cleaners. This will be a six-year project. The company bought a piece of land
four years ago for $ 8 million in anticipation of using it for its proposed manufacturing plant. If the company
sold the land today, it would receive $ 9.75 million after taxes. In six years the land can be sold for $14 million
after taxes and reclamation costs. Galaxy Industries Ltd wants to build a new manufacturing plant on this land.
The plant will cost $275 million to build. The following market data on Galaxy Industries Ltd are current:

Debt

$120,000,000,7.25% coupon bonds outstanding with 20 years to maturity redeemable at par, selling for 95 percent of par; the bonds have a $1000 par value each and make semi-annual coupon payments.

Equity

15,000,000ordinary shares, selling for $55 per share

Non-redeemable Preference shares

12,000,000 shares (par value $ 10 per share) with 6.5% dividends (after taxes), selling for $32 per share

The following information is relevant:
• Galaxy Industries Ltd’s tax rate is 28%
• The company had been paying dividends on its ordinary shares consistently. Dividends paid
during the past five years is as follows

Year (-4) ($)
Year (-3) ($)
Year (-2) ($)
Year (-1) ($)
Year (0) ($)
4.6 4.8 5.3 5.5 6.0

•The project requires $ 7.95 million in initial net working capital investment in year 0 to

become operational.

Required:
1. Calculate the project’s initial, (time 0) cash flows.
2. Compute the weighted average cost of capital (WACC) of Galaxy Industries Ltd. Show all workings and
state clearly any assumptions underlying your computations.

3. Using the WACC computed in part (2) above and assuming the following, compute the project’s Net
Present Value (NPV), Internal Rate of Return (IRR) and the Profitability Index (PI).
a. The manufacturing plant has a ten-year tax life, and Galaxy Industries Ltd uses Diminishing
value method of depreciation for the plant using a 25% depreciation rate per annum. At the
end of the project, (i.e., at the end of year 6), the plant can be scrapped for $ 22 million.
b. The project will incur $250 million per annum in fixed costs
c. Galaxy Industries Ltd will manufacture 300,000 commercial vacuum cleaners per year in each
of the years and sell them at $ 2,200 per vacuum cleaner.
d. The variable production costs are $ 950 per vacuum cleaner.
e. At the end of year 6, the company will sell the land.
Note: Work all solutions to the nearest two decimals.
2.2. What are the pros and cons of using risk-adjusted costs of capital for individual investments?

In: Finance

Pick a publicly recognized company. You are the newly appointed treasurer and your partner is the...

Pick a publicly recognized company.

You are the newly appointed treasurer and your partner is the newly appointed controller of your company. In order to learn more about your company, you have decided to analyze the company’s financial performance over the last 2 years. To do this, you have decided to calculate the following ratios for the company’s 2 most recent years in the noted categories:

Profitability Ratios

Gross Margin Percentage

EBIT Margin Percentage

Resource Management Ratios:

Age of Inventory

Age of Accounts Receivable

Age of Accounts Payable

Liquidity Ratio:

Current Ratio

Leverage Ratios

Debt-to-Assets Ratio

Debt-to-Equity Ratio

Interest Coverage

In addition, you have decided to evaluate the Return on Equity (ROE) of the company by calculating the DuPont Ratio, including the Profit Margin, Asset Turnover, and Financial Leverage Ratios.

Required

As a member of a team, you will produce a 5–7-page paper that will show your calculations of each of these ratios for the company’s 2 most recent years. In addition, you will provide a brief analysis of each of the ratios. You will also provide a brief evaluation regarding the company’s performance as it relates to the four categories listed above, plus the DuPont Equation. Finally, you will discuss how these ratios will help you make appropriate financial decisions as they relate to your role as a financial manager, and also assist in achieving the firm’s financial management goals.

In: Accounting

The statement of comprehensive income of kolad plc, a publicly listed company, is as follows: Statement...

The statement of comprehensive income of kolad plc, a publicly listed company, is as follows:

Statement of comprehensive income for the year ended 31 March 2020

£000

Revenue

33,600

Cost of sales

(22,500)

Gross profit

11,100

Distribution costs

(3,600)

Administrative expenses

(3,450)

Finance costs

(300)

Profit before tax

3,750

Income tax expense

(150)

Profit for the year

3,600

Gain on revaluation

250

Total comprehensive income

3,850

The following supporting information is available:

  1. Depreciation of £965,000 was charged (to cost of sales) for property, plant and equipment in the year ended 31 March 2020. An item of plant with a carrying value of £750,000 was sold at a profit of £65,000 during the year.
  1. The following extracts from the statements of financial position for the years ended 31 March 2020 and 31 March 2019 are relevant:

2020

2019

£000

£000

Inventory

4,350

4,050

Trade receivables

1,800

900

Trade payables

850

2,625

Current tax payable

825

1,800

YOU ARE REQUIRED TO:

  1. Calculate the net cash flow from operating activities for kolad plc for the year to 31 March 2020 in accordance with IAS 7 Statement of cash flows using the indirect method.

  1. Explain the characteristics of an item to be considered as a cash equivalent and give three examples of items that could be included as cash and cash equivalents in a statement of cash flows.

  1. Profit is not a good indicator of performance as it can be changed to suit management’s needs.

Discuss whether, in your opinion, the statement of profit or loss or the statement of cash flows is a better indicator of a company’s performance.

In: Accounting