Calculate openness as a percentage for Paraguay and Poland. Explain how you calculated openness, i.e., write down the formula. Using a graph of Openness (as a percentage) versus time, explain in up to 200 words how openness has changed for these countries from 2001 to 2014. Put Paraguay and Poland in the same graph and make sure your graph is properly labelled.
| Country Name | Country Code | Series Name | Series Code | 2001 [YR2001] | 2002 [YR2002] | 2003 [YR2003] | 2004 [YR2004] | 2005 [YR2005] | 2006 [YR2006] | 2007 [YR2007] | 2008 [YR2008] | 2009 [YR2009] | 2010 [YR2010] | 2011 [YR2011] | 2012 [YR2012] | 2013 [YR2013] | 2014 [YR2014] |
| Paraguay | PRY | Exports of goods and services (current US$) | NE.EXP.GNFS.CD | 3459319570 | 3402825624 | 3625989129 | 4371893087 | 5083809323 | 6252319090 | 7818347667 | 9993980610 | 8210295841 | 11036468064 | 13186264509 | 12278348692 | 14356651476 | 13954911448 |
| Paraguay | PRY | GDP (current US$) | NY.GDP.MKTP.CD | 7662595076 | 6325151760 | 6588103836 | 8033877360 | 8734653809 | 10646157920 | 13794910634 | 18504130753 | 15929902138 | 20030528043 | 25099681461 | 24595319574 | 28965906502 | 30881166852 |
| Paraguay | PRY | GDP per capita (current US$) | NY.GDP.PCAP.CD | 1417 | 1148 | 1175 | 1409 | 1507 | 1810 | 2312 | 3060 | 2600 | 3226 | 3988 | 3856 | 4480 | 4713 |
| Paraguay | PRY | GINI index (World Bank estimate) | SI.POV.GINI | 55 | 57 | 56 | 53 | 51 | 54 | 52 | 51 | 50 | 52 | 53 | 48 | 48 | 52 |
| Paraguay | PRY | Imports of goods and services (current US$) | NE.IMP.GNFS.CD | 2727373823 | 2298406126 | 2623501714 | 3307792347 | 4018039423 | 5221045741 | 6461917817 | 9166237324 | 7130137358 | 10313046052 | 12621883682 | 11979621541 | 12983600420 | 13242370791 |
| Poland | POL | Exports of goods and services (current US$) | NE.EXP.GNFS.CD | 51878648721 | 57137009804 | 72632296220 | 87410323710 | 105952277925 | 130565028203 | 165538367008 | 202086584758 | 163740453116 | 191967370760 | 225042181278 | 222344181762 | 242809098962 | 259386390289 |
| Poland | POL | GDP (current US$) | NY.GDP.MKTP.CD | 190521263343 | 198680637255 | 217518642325 | 255102252843 | 306134635594 | 344826430298 | 429249647595 | 533815789474 | 440346575958 | 479257883742 | 528725113046 | 500284003684 | 524201151607 | 545075908846 |
| Poland | POL | GDP per capita (current US$) | NY.GDP.PCAP.CD | 4981 | 5197 | 5694 | 6681 | 8021 | 9041 | 11260 | 14001 | 11542 | 12598 | 13891 | 13144 | 13780 | 14340 |
| Poland | POL | GINI index (World Bank estimate) | SI.POV.GINI | 33 | 34 | 35 | 35 | 35 | 34 | 34 | 34 | 34 | 33 | 33 | 32 | 33 | 32 |
| Poland | POL | Imports of goods and services (current US$) | NE.IMP.GNFS.CD | 58766945944 | 63908088235 | 78406788377 | 94256069554 | 109183717624 | 137680257857 | 180703003578 | 228993441806 | 167514280213 | 201543256955 | 235386043059 | 224546822229 | 232598709188 | 251529270071 |
In: Economics
Explain in up to 200 words the relationship between Openness and economic development by calculating the correlation coefficient between GDP per capita (proxy for economic development) and Openness for Paraguay and Poland, respectively. [Here you have to use the CORREL command in Excel].
| Country Name | Country Code | Series Name | Series Code | 2001 [YR2001] | 2002 [YR2002] | 2003 [YR2003] | 2004 [YR2004] | 2005 [YR2005] | 2006 [YR2006] | 2007 [YR2007] | 2008 [YR2008] | 2009 [YR2009] | 2010 [YR2010] | 2011 [YR2011] | 2012 [YR2012] | 2013 [YR2013] | 2014 [YR2014] |
| Paraguay | PRY | Exports of goods and services (current US$) | NE.EXP.GNFS.CD | 3459319570 | 3402825624 | 3625989129 | 4371893087 | 5083809323 | 6252319090 | 7818347667 | 9993980610 | 8210295841 | 11036468064 | 13186264509 | 12278348692 | 14356651476 | 13954911448 |
| Paraguay | PRY | GDP (current US$) | NY.GDP.MKTP.CD | 7662595076 | 6325151760 | 6588103836 | 8033877360 | 8734653809 | 10646157920 | 13794910634 | 18504130753 | 15929902138 | 20030528043 | 25099681461 | 24595319574 | 28965906502 | 30881166852 |
| Paraguay | PRY | GDP per capita (current US$) | NY.GDP.PCAP.CD | 1417 | 1148 | 1175 | 1409 | 1507 | 1810 | 2312 | 3060 | 2600 | 3226 | 3988 | 3856 | 4480 | 4713 |
| Paraguay | PRY | GINI index (World Bank estimate) | SI.POV.GINI | 55 | 57 | 56 | 53 | 51 | 54 | 52 | 51 | 50 | 52 | 53 | 48 | 48 | 52 |
| Paraguay | PRY | Imports of goods and services (current US$) | NE.IMP.GNFS.CD | 2727373823 | 2298406126 | 2623501714 | 3307792347 | 4018039423 | 5221045741 | 6461917817 | 9166237324 | 7130137358 | 10313046052 | 12621883682 | 11979621541 | 12983600420 | 13242370791 |
| Poland | POL | Exports of goods and services (current US$) | NE.EXP.GNFS.CD | 51878648721 | 57137009804 | 72632296220 | 87410323710 | 105952277925 | 130565028203 | 165538367008 | 202086584758 | 163740453116 | 191967370760 | 225042181278 | 222344181762 | 242809098962 | 259386390289 |
| Poland | POL | GDP (current US$) | NY.GDP.MKTP.CD | 190521263343 | 198680637255 | 217518642325 | 255102252843 | 306134635594 | 344826430298 | 429249647595 | 533815789474 | 440346575958 | 479257883742 | 528725113046 | 500284003684 | 524201151607 | 545075908846 |
| Poland | POL | GDP per capita (current US$) | NY.GDP.PCAP.CD | 4981 | 5197 | 5694 | 6681 | 8021 | 9041 | 11260 | 14001 | 11542 | 12598 | 13891 | 13144 | 13780 | 14340 |
| Poland | POL | GINI index (World Bank estimate) | SI.POV.GINI | 33 | 34 | 35 | 35 | 35 | 34 | 34 | 34 | 34 | 33 | 33 | 32 | 33 | 32 |
| Poland | POL | Imports of goods and services (current US$) | NE.IMP.GNFS.CD | 58766945944 | 63908088235 | 78406788377 | 94256069554 | 109183717624 | 137680257857 | 180703003578 | 228993441806 | 167514280213 | 201543256955 | 235386043059 | 224546822229 | 232598709188 | 251529270071 |
In: Economics
Asylum Applications and GDP
Economic research provides evidence for a positive relationship between Gross Domestic Product (GDP) and Asylum Applications across the EU. This provides support for the view that a strong economy tend to have higher level of asylum applications.
The Table below gives Asylum Applications and an index of GDP per capita (written as GDP for short) for each year from 2003 to 2014. A regression analysis with Asylum Applications as the response variable and GDP as the predictor variable is shown at the end of the question.
Table: Asylum Applications and GDP in each year
|
2003 |
2004 |
2005 |
2006 |
2007 |
2008 |
2009 |
2010 |
2011 |
2012 |
2013 |
2014 |
|
|
GDP |
140 |
145 |
147 |
148 |
148 |
134 |
129 |
130 |
131 |
132 |
133 |
137 |
|
Asylum Applications |
7,483 |
4,766 |
4,323 |
4,314 |
3,985 |
3,866 |
2,860 |
1,935 |
1,290 |
955 |
945 |
1,450 |
Regression Analysis: Asylum Applications versus GDP (GDP per Capita (index))
Explain your answer taking into consideration the Adj-R squared value
Regression Equation
Asylum Applications = -19.720 + 166 GDP
|
Predictor |
Coef |
SE Coef |
T-Value |
P-Value |
|
Constant |
-19,720 |
9,104 |
-2.16 |
0.06 |
|
GDP |
166 |
66 |
2.51 |
0.03 |
|
Adj-R-Squared |
33% |
Analysis of Variance
|
Source |
DF |
SS (000) |
MS(000) |
F-Value |
P-Value |
|
GDP |
1 |
16,695 |
16,695 |
6.33 |
0.031 |
|
Error |
10 |
26,355 |
2,635 |
||
|
Total |
11 |
43,050 |
Predicted Values for New Observations
|
GDP |
Fit |
SE Fit |
95% CI |
95% PI |
|
140 |
3,526 |
469 |
(2,440, 4,611) |
(-235, 7,305) |
|
177 |
9,668 |
2,634 |
(3,839, 15,499) |
(2,806, 16,351) XX |
XX denotes an extremely unusual point relative to predictor levels used to fit the model
In: Statistics and Probability
The following data relates to the size of the electricity bill
sent to 7 randomly selected customers and the
time the customers took to pay the bills.
Customer 1 2 3 4 5 6 7
Size of bill($) 1500 1800 2300 2700 3300 3700 4600
Time to pay (days) 16 21 19 20 24 30 27
a) State the dependent variable and independent variable of the
data set.
b) Plot the data on a scatter graph and add a trend line on the
scatter graph.
c) Find the correlation coefficient and comment on it.
d) Determine the linear regression equation that can be used to
predict how long a bill of a given size
will take to pay.
e) Interpret your equation.
f) Use your equation to predict how long it will take a customer to
pay:
i. A bill of $1050, and
ii. A bill of $8000.
What reservations do you have about these predictions?
In: Statistics and Probability
A regional electrical distributor currently has 1,000 customers who buy an average of $5,000 per year, generating a 50% margin. From experience, the company knows that 20% of its customers will not return the next year and it takes an average of $500 to acquire each new customer.
Given a choice of 1) investing $50,000 in a new customer acquisition program for 100 additional customers or 2) investing $50,000 in a new retention program which would take the rate of retention from 80% to 85%, what should the company do? complete the Excel template for both scenarios (customer acquisition and customer retention) to show which option is the most profitable. Assume the new programs are in effect and you are calculating the impact for both beginning Year 1. Also, do not account for the cost of the programs since it doesn't impact the overall conclusion.
| Five Year Payout | ||||||
| Scenario 1: New Customer Acquisition | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Incremental Customers: | 100 | |||||
| Purchases: | ||||||
| Additional Annual Profits: | ||||||
| Cumulative Additional Annual Profits: | ||||||
| Scenario 2: Customer Retention | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Retained Customers @ 80%: | 800 | |||||
| Retained Customers @ 85%: | 850 | |||||
| Additional Retained Customers: | ||||||
| Incremental Annual Purchases: | ||||||
| Additional Annual Profits: | ||||||
| Cumulative Additional Annual Profits: | ||||||
| Conclusion: |
In: Accounting
You are working for The Wellington Company on temporary assignment while one of the accountants is on family leave. You have been asked to review the company’s investment
The balance sheet caption used to report long-term investments in stocks not intended as a source of cash in the normal operations of the business.
journal entries and provide necessary information to the accountant preparing the financial statements.
PAGE 8
JOURNAL
| DATE | DESCRIPTION | POST. REF. | DEBIT | CREDIT | |
|---|---|---|---|---|---|
|
1 |
Jan. 17 |
Investment-Red Rock Co. Stock |
37,400.00 |
||
|
2 |
Cash |
37,400.00 |
|||
|
3 |
Feb. 5 |
Investment-Sunset Village Bonds |
34,000.00 |
||
|
4 |
Interest Receivable |
290.00 |
|||
|
5 |
Cash |
34,290.00 |
|||
|
6 |
23 |
Investment-Mays and Co. Stock |
25,500.00 |
||
|
7 |
Cash |
25,500.00 |
|||
|
8 |
Mar. 31 |
Cash |
340.00 |
||
|
9 |
Interest Receivable |
290.00 |
|||
|
10 |
Interest Revenue |
50.00 |
|||
|
11 |
Apr. 6 |
Investment in Minions Corp. Stock |
170,000.00 |
||
|
12 |
Cash |
170,000.00 |
|||
|
13 |
30 |
Cash |
750.00 |
||
|
14 |
Dividend Revenue |
750.00 |
|||
|
15 |
Jul. 1 |
Cash |
18,162.00 |
||
|
16 |
Loss on Sale of Investments |
2,448.00 |
|||
|
17 |
Interest Revenue |
210.00 |
|||
|
18 |
Investment-Sunset Village Bonds |
20,400.00 |
|||
|
19 |
Aug. 14 |
Cash |
41,300.00 |
||
|
20 |
Gain on Sale of Investments |
1,800.00 |
|||
|
21 |
Investment-Harding Construction Stock |
39,500.00 |
|||
|
22 |
27 |
Cash |
3,400.00 |
||
|
23 |
Investment in Minions Corp. Stock |
3,400.00 |
|||
|
24 |
Sep. 22 |
Cash |
29,000.00 |
||
|
25 |
Gain on Sale of Investments |
3,500.00 |
|||
|
26 |
Investment-Mays and Co. Stock |
25,500.00 |
|||
|
27 |
30 |
Cash |
130.00 |
||
|
28 |
Interest Revenue |
130.00 |
|||
|
29 |
Nov. 1 |
Investment in Minions Corp. Stock |
15,300.00 |
||
|
30 |
Income of Minions Corp. |
15,300.00 |
|||
|
31 |
Dec. 31 |
Unrealized Loss on Available-For-Sale Investments |
3,275.00 |
||
|
32 |
Valuation Allowance for Available-For-Sale Investments |
3,275.00 |
|||
|
33 |
31 |
Valuation Allowance for Trading Investments |
2,150.00 |
||
|
34 |
Unrealized Gain on Trading Investments |
2,150.00 |
The accountant preparing the financial statements has asked you to provide the fair value as of the end of the year for the investments. Present the information as it would be shown on the financial statements. Last year, The Wellington Company reported costs of $68,000 in trading investments and $82,000 in available-for-sale investments. Refer to the journal entries shown on The Wellington Company panel. Assume that all investments sold during this year were trading investments and that purchases during the year were new investments.
| Trading Securities | |
| Trading investments at cost | ? |
| Plus valuation allowance for trading investments | 2150 |
| Trading investments at fair value | ? |
| Available-For-Sale Securities | |
| Available-for-sale investments at cost | ? |
| Less valuation allowance for available-for-sale investments | 3275 |
| Available-for-sale investments at fair value | ? |
In: Accounting
| THE COCA-COLA COMPANY AND SUBSIDIARIES | |||||
| CONSOLIDATED STATEMENTS OF INCOME | |||||
| Year Ended December 31, | 2008 | 2007 | 2006 | ||
| (In millions except per share data) | |||||
| NET OPERATING REVENUES | $31,944 | $ 28,857 | $ 24088 | ||
| Cost of goods sold | 11,374 | 10,406 | 8,164 | ||
| GROSS PROFIT | 20,570 | 18,451 | 15,924 | ||
| Selling, general and administrative expenses | 11,774 | 10,945 | 9,431 | ||
| Other operating charges | 350 | 254 | 185 | ||
| OPERATING INCOME | 8,446 | 7,252 | 6,308 | ||
| Interest income | 333 | 236 | 193 | ||
| Interest expense | 438 | 456 | 220 | ||
| Equity income (loss) — net | (874) | 668 | 102 | ||
| Other income (loss) — net | (28) | 173 | 195 | ||
| INCOME BEFORE INCOME TAXES | 7,439 | 7,873 | 6,578 | ||
| Income taxes | 1,632 | 1,892 | 1,498 | ||
| NET INCOME | $ 5,807 | $ 5,981 | $ 5,080 | ||
| BASIC NET INCOME PER SHARE | $ 2.51 | $ 2.59 | $ 2.16 | ||
| DILUTED NET INCOME PER SHARE | $ 2.49 | $ 2.57 | $ 2.16 | ||
| AVERAGE SHARES OUTSTANDING | 2,315 | 2,313 | 2,348 | ||
| Effect of dilutive securities | 21 | 18 | 2 | ||
| AVERAGE SHARES OUTSTANDING ASSUMING DILUTION | 2,336 | 2,331 | 2,350 | ||
Refer to Notes to Consolidated Financial Statements.
Review Coca-Cola's financial statements and answer the following questions:
1. How are Coke's numbers reported (in what
denomination)?
For items 2-4, enter the answers as presented (e.g. $24,088 not $24,088,000).
2. What is Coke's net operating revenue for
2008?
$
3. What is Coke's cost of goods sold for
2008?
$
4. What is Coke’s net income 2008?
$
5. What is Coke’s percent of interest expense
to net operating revenue on its 2008 income statement? Rounding
your answer to two decimal places.
%
6. What is Coke's percent of increase in net
operating revenue from 2007 to 2008? Rounding your answer to one
decimal place.
%
In: Accounting
True or False?
1. Merchandise inventory consists of products that a company acquires to resell to customers.
2. A service company earns net income by buying and selling merchandise.
3. Gross profit is the same as gross margin.
4. Cost of goods sold is also called cost of sales.
5. A wholesaler is an intermediary that buys products from a manufacturers or other wholesalers and sells them to consumers.
6. Goods in transit are automatically included in a company's inventory account.
7. If damaged & obsolete goods cannot be sold they are not included in inventory.
8. Goods on consignment are goods shipped by their owner, called the consignee, to a party called the consignor.
9. If obsolete or damaged goods can be sold, they will be included in inventory for realizable value.
10. If the seller is responsible for paying freight charges, then ownerships is passed when goods arrive at their destination.
11. A properly designed internal control system is a key part of accounting information systems design, analysis and performances.
12. The use of internal controls provides guaranteed protection against losses due to operating activities.
13. Internal control policies and procedures are the same for all companies
14. Maintaining adequate business records is an important internal control principle.
15. Proper internal control means that the responsibility for a task is clearly established and assigned to one person.
16. Accounts receivables occur from credit sales to customers
17. Credit sales are recorded by crediting an account receivable for the specific customer who is making the purchase
18. As long as a company accurately records total credit sales information, it is not necessary to have separate accounts for specific customers
19. If a customer owes interest on accounts receivable, the interest revenue account is debited and account receivable is credited
20. If a credit card sale is made, the seller can either debit cash or debit accounts receivable when the sale occurs.
In: Accounting
In: Economics
8. A professor tests whether the loudness of noise during an exam (low, medium, and high) is independent of exam grades (pass, fail). The following table shows the observed frequencies for this test.
| Noise Level | |||||
|---|---|---|---|---|---|
| Low | Medium | High | |||
| Exam | Pass | 21 | 17 | 9 | 47 |
| Fail | 9 | 6 | 12 | 27 | |
| 30 | 23 | 21 | N = 74 | ||
Part A) Conduct a chi-square test for independence at a 0.05 level of significance. (Round your answer to two decimal places.)
Decide whether to retain or reject the null hypothesis.
Part B) Compute effect size using Cramer's V. (Round your answer to two decimal places.)
9. What is Cramer's V for each of the following values for the chi-square test for independence? (Round your answers to two decimal places.)
Part A) X2 = 3.63, n = 50, dfsmaller = 1
Part B) X2 = 9.27, n = 120, dfsmaller = 2
Part C) X2 = 12.23, n = 160, dfsmaller = 3
In: Statistics and Probability