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 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 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 | 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 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 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:
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 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]
In: Accounting
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:
|
|
||
|
15,000,000ordinary shares, selling for $55 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
|
|
|
|
|
|||||
| 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 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 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:
|
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:
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