A travel association reported the domestic airfare (in dollars) for business travel for the current year and the previous year. Below is a sample of 12 flights with their domestic airfares shown for both years.
| Current Year |
Previous Year |
|---|---|
| 345 | 315 |
| 526 | 475 |
| 420 | 474 |
| 216 | 206 |
| 285 | 275 |
| 405 | 432 |
| 635 | 585 |
| 710 | 650 |
| 605 | 545 |
| 517 | 547 |
| 570 | 508 |
| 610 | 580 |
(a)
Formulate the hypotheses and test for a significant increase in the mean domestic airfare for business travel for the one-year period.
H0: μd = 0
Ha: μd ≠ 0
H0: μd < 0
Ha: μd = 0
H0: μd ≥ 0
Ha: μd < 0
H0: μd ≠ 0
Ha: μd = 0
H0: μd ≤ 0
Ha: μd > 0
Calculate the test statistic. (Use current year airfare − previous year airfare. Round your answer to three decimal places.)
Calculate the p-value. (Round your answer to four decimal places.)
p-value =
Using a 0.05 level of significance, what is your conclusion?
Reject H0. We can conclude that there has been a significant increase in the mean domestic airfare for business travel for the one-year period.Reject H0. We cannot conclude that there has been a significant increase in the mean domestic airfare for business travel for the one-year period. Do not reject H0. We cannot conclude that there has been a significant increase in the mean domestic airfare for business travel for the one-year period. Do not reject H0. We can conclude that there has been a significant increase in the mean domestic airfare for business travel for the one-year period.
(b)
What is the sample mean domestic airfare (in dollars) for business travel for each year?
current $ previous $
(c)
What is the percentage change in mean airfare for the one-year period? (Round your answer to one decimal place.)
%
In: Statistics and Probability
|
The following was taken from the records of Smith Company in the year ending December 31, 20X7. Journalize the following transactions in an Excel spreadsheet for year-end 20X7 using the aging method. Assume that the allowance for doubtful accounts has a beginning credit balance of $8,000 on January 1, 20X7. The assignment template is attached below. Label the transactions below as journal entries #1 to #4, along with the dates of the entries: February 20, 20x7: Wrote off Jones account: $250. May 20, 20x7: Received $410 as partial payment on the $700 account receivable due from Garcia. August 10, 20x7: Received $725 from Jones on the account written off on February 20, 20x7. September 15: Wrote off the individual account receivables for the following customers as payment not expected in future: Tang: $400; Mulaka: $210; Quan: $375. December 31, 20x7: Smith Company prepared the following aging schedule for it accounts receivables: $120,000 of Accounts Receivable (A/R) are 0-30 days late: 3% probability of being uncollectible. $30,000 of A/R are 31-60 days late: 10% probability of being uncollectible. $14,000 of A/R are 61-90 days late: 20% probability of being uncollectible $1,000 of A/R are later than 90 days late: 50% probability of being uncollectible Instructions: Using the Excel spreadsheet template provided for this assignment, submit the following items: The four journal entries (1 to 4 above) with a one-sentence description for each The T-account for the allowance for doubtful accounts The journal entry to record bad debt expense The balance sheet presentation of net realizable value, including gross accounts receivables of $29,500 Company Company- December 31, 201X |
|||||||
| Journal# | Date | Account Title | Debit | Credit | |||
| a | 20-Feb | Allowance for doutful accounts | |||||
| Jones- Accounts receivable | |||||||
| b | |||||||
| 20-May | Cash | ||||||
| Garcia-Accounts Receivables | |||||||
| c | 10-Aug | Cash | |||||
| Allowance for doubtful accounts | |||||||
| d | 15-Sep | Allowance for doubtful accounts | |||||
| Tang-Accounts Receivable | |||||||
| Mukala-Accounts Receivable | |||||||
| Quan-Accounts Receivable | |||||||
| Question 2 | |||||||
| Dates | T-Account for Allowance for doubtful accounts | ||||||
| Debit | Credit | ||||||
| Begining balance | |||||||
| 20-Feb | |||||||
| 15-Sep | |||||||
| Bad Debt Expense= | |||||||
| Ending Balance | |||||||
| Calculations: Aging schedule | |||||||
| Days Late | Accounts Receivable Amount | Uncollection Probability | Uncollectible Amount | ||||
| Question 3 | |||||||
| Date | Account Title | Debit | Credit | ||||
| 31-Dec | Bad Debt Expense | ||||||
| Allowance for doubtful accounts | |||||||
| Question 4 | |||||||
| Balance Sheet Presentaion | |||||||
| Gross Accounts Receivables | |||||||
| Ending Balance of Allowance for Doubtbul Accounts | |||||||
| Net Realizable Balance | |||||||
In: Accounting
Forecast the Balance Sheet
Following is the balance sheet for Medtronic PLC for the year ended April 29, 2016.
| Medtronic plc | |||||
|---|---|---|---|---|---|
| Consolidated Balance Sheets | |||||
| ($ millions) | Apr. 29, 2016 | Apr. 24, 2015 | |||
| Current assets | |||||
| Cash and cash equivalents | $2,988 | $4,843 | |||
| Investments | 9,758 | 14,637 | |||
| Accounts receivable | 5,562 | 5,112 | |||
| Inventories | 3,473 | 3,463 | |||
| Tax assets | 697 | 1,335 | |||
| Prepaid expenses and other current assets | 1,234 | 1,454 | |||
| Total current assets | 23,712 | 30,844 | |||
| Property, plant, and equipment, net | 4,841 | 4,699 | |||
| Goodwill | 41,500 | 40,530 | |||
| Other intangible assets, net | 26,899 | 28,101 | |||
| Long-term tax assets | 1,383 | 774 | |||
| Other assets | 1,559 | 1,737 | |||
| Total assets | $99,894 | $106,685 | |||
| Current liabilities | |||||
| Short-term borrowings | $1,105 | $2,434 | |||
| Accounts payable | 1,709 | 1,610 | |||
| Accrued compensation | 1,712 | 1,611 | |||
| Accrued income taxes | 566 | 935 | |||
| Deferred tax liabilities | - | 119 | |||
| Other accrued expenses | 2,185 | 2,464 | |||
| Total current liabilities | 7,277 | 9,173 | |||
| Long-term debt | 30,247 | 33,752 | |||
| Long-term accrued compensation | 1,759 | 1,535 | |||
| Long-term accrued income taxes | 2,903 | 2,476 | |||
| Long-term deferred tax liabilities | 3,729 | 4,700 | |||
| Other long-term liabilities | 1,916 | 1,819 | |||
| Total liabilities | 47,831 | 53,455 | |||
| Shareholders’ equity | |||||
| Ordinary shares | - | - | |||
| Retained earnings | 53,931 | 54,414 | |||
| Accumulated other comprehensive (loss) | (1,868) | (1,184) | |||
| Total shareholders’ equity | 52,063 | 53,230 | |||
| Total liabilities and shareholders’ equity | $99,894 | $106,685 | |||
Use the following assumptions to forecast the company’s balance sheet for FY2017.
| Forecasted FY2017 net income | $5,151 |
million |
||||||
| Forecasted FY2017 net sales | $36,274 |
million |
||||||
| Accounts receivable | 19.3% |
of net sales |
||||||
| Inventories | 12.0% |
of net sales |
||||||
| Tax assets | 2.4% |
of net sales |
||||||
| Prepaid expenses and other current assets | 4.3% |
of net sales |
||||||
| Long-term tax assets | 4.8% |
of net sales |
||||||
| Other assets | 5.4% |
of net sales |
||||||
| Accounts payable | 5.9% |
of net sales |
||||||
| Accrued compensation | 5.9% |
of net sales |
||||||
| Accrued income taxes | 2.0% |
of net sales |
||||||
| Other accrued expenses | 7.6% |
of net sales |
||||||
| Long-term accrued income taxes | 10.1% |
of net sales |
||||||
| Long-term deferred tax liabilities | 12.9% |
of net sales |
||||||
| Other long-term liabilities | 6.6% |
of net sales |
||||||
| Investments | No change | |||||||
| Goodwill | No change | |||||||
| Long-term accrued compensation and retirement benefits | No change | |||||||
| Ordinary shares | No change | |||||||
| Accumulated other comprehensive (loss) | No change | |||||||
| CAPEX | 3.6% |
of net sales |
||||||
| Depreciation expense | 18.9% |
of prior year PPE, net |
||||||
| Amortization expense in FY2016 | $1,931 |
million |
||||||
| Current maturities of debt due in FY2017 | $1,105 |
million |
||||||
| Current maturities of debt due in FY2018 | $6,176 |
million |
||||||
| Dividend payout ratio | 60.5% |
Round your answers to the nearest whole number.
Do not use negative signs with any of your answers.
| Medtronic plc | ||||
|---|---|---|---|---|
| Forecasted Consolidated Balance Sheet | ||||
| ($ millions) | EST. 2017 | |||
| Current assets | ||||
| Cash and cash equivalents | $Answer | |||
| Investments | Answer | |||
| Accounts receivable | Answer | |||
| Inventories | Answer | |||
| Tax assets | Answer | |||
| Prepaid expenses and other current assets | Answer | |||
| Total current assets | Answer | |||
| Property, plant, and equipment, net | Answer | |||
| Goodwill | Answer | |||
| Other intangible assets, net | Answer | |||
| Long-term tax assets | Answer | |||
| Other assets | Answer | |||
| Total assets | $Answer | |||
| Current liabilities | ||||
| Short-term borrowings | $Answer | |||
| Accounts payable | Answer | |||
| Accrued compensation | Answer | |||
| Accrued income taxes | Answer | |||
| Other accrued expenses | Answer | |||
| Total current liabilities | Answer | |||
| Long-term debt | Answer | |||
| Long-term accrued compensation | Answer | |||
| Long-term accrued income taxes | Answer | |||
| Long-term deferred tax liabilities | Answer | |||
| Other long-term liabilities | Answer | |||
| Total liabilities | Answer | |||
| Shareholders’ equity | ||||
| Ordinary shares | - | |||
| Retained earnings | Answer | |||
| Accumulated other comprehensive (loss) | Answer | |||
| Total shareholders’ equity | Answer | |||
| Total liabilities and shareholders’ equity | $Answer | |||
In: Accounting
A poll was taken this year asking college students if they considered themselves overweight. A similar poll was taken 5 years ago. Five years ago, a sample of 270 students showed that 120 considered themselves overweight. This year a poll of 300 students showed that 140 considered themselves overweight. At a 5% level of significance, test to see if there is any difference in the proportion of college students who consider themselves overweight between the two polls. What is your conclusion? Show all work and please make legible
In: Statistics and Probability
On January 1, 2017, Loud Company enters into a 2-year contract with a customer for an unlimited talk and 5 GB data wireless plan for $65 per month. The contract includes a smartphone for which the customer pays $299. Loud also sells the smartphone and monthly service plan separately, charging $649 for the smartphone and $65 for the monthly service for the unlimited talk and 5 GB data wireless plan.
Required:
| 1. | Calculate the transaction price for the smartphone and unlimited talk and 5 GB data wireless plan assuming that Loud allocates consideration based on stand-alone prices. |
| 2. | Record the initial journal entry for Loud Company’s sale of a 2-year contract on January 1, 2017, and the monthly journal entry. |
In: Accounting
Assume all salaries are paid at the end of each year; evaluate the three options for peter
option 1. Stay in his current job
Annual salary $520,000 and his salary is expected to increase by 5.25% per year for 38 more years until retirement.
Peter's remuneration package includes base salary and medical and dental health care insurance plans. Assume individual income tax rate is 20%.
Option 2. Nanyang business school full-time MBA 1 yr plan
Tuition fee is $55,000, books and other supplies cost $1,200. Upon graduation, peter expects to receive offers with remuneration package that includes a base salary of $520,000 per year, signing bonus of $30,000 as well as medical and dental health care insurance. His salary will be increased by 7.25%. Individual tax rate is 20%.
Option 3. Singapore management university 1 yr plan
Tuition fee is $60,990, books and other supplies cost is $1,500. Upon graduation, peter expects to receive offers with a remuneration package that includes a base salary of $540,000 per year, signing bonus of $10,000 as well as medical and dental health care insurance plans. His salary will be increased by 7% per year. Assume individual income tax rate is 20%.
* Peter estimates that the living and miscellaneous expenses at both universities may cost $4,000 more. Assume the tuition fee as well as the additional living and miscellaneous expenses are payable at the beginning of each term and the discount rate is 8%.
In: Finance
A project requires an investment of $20,000 and will return $26,500 after one year. Suppose the 10-year Treasury bill rate is 5%, and the project has a risk premium of 12%.
A) Should this project be taken? Also Calculate the IRR of this project.
B)If the manager wants to finance the project solely with equity, what is the equity holder’s valuation of this project?
C)If the manager wants to finance the project 50% with equity and 50% with 10-year T-bill, what is equity holder’s valuation of this project?
D)Explain in your own words why the equity holder’s valuation of the project differs between B) and C).
E)Using the information of this project, draw a graph illustrating the relation between cost of levered equity and the leverage ratio [D/ (D+E)]
Please Help!
In: Finance
The following information pertains to the City of Williamson for 2017, its first year of legal existence. For convenience, assume that all transactions are for the general fund, which has three separate functions: general government, public safety, and health and sanitation.
| Receipts: | |
| Property taxes | $320,000 |
| Franchise taxes | 42,000 |
| Charges for general government services | 5,000 |
| Charges for public safety services | 3,000 |
| Charges for health and sanitation services | 42,000 |
| Issued long-term note payable | 200,000 |
| Receivables at end of year: | |
| Property taxes (90% estimated to be collectible) | 90,000 |
| Payments: | |
| Salary: | |
| General government | 66,000 |
| Public safety | 39,000 |
| Health and sanitation | 22,000 |
| Rent: | |
| General government | 11,000 |
| Public safety | 18,000 |
| Health and sanitation | 3,000 |
| Maintenance: | |
| General government | 21,000 |
| Public safety | 5,000 |
| Health and sanitation | 9,000 |
| Insurance: | |
| General government | 8,000 |
| Public safety ($2,000 still prepaid at end of year) | 11,000 |
| Health and sanitation | 12,000 |
| Interest on debt | 16,000 |
| Principal payment on debt | 4,000 |
| Storage shed | 120,000 |
| Equipment | 80,000 |
| Supplies (20% still held) (public safety) | 15,000 |
| Investments | 90,000 |
| Ordered but not received: | |
| Equipment | 12,000 |
| Due in one month at end of year: | |
| Salaries: | |
| General government | 4,000 |
| Public safety | 7,000 |
| Health and sanitation | 8,000 |
Compensated absences (such as vacations and sick days) legally owed to general government workers at year-end total $13,000. These amounts will not be taken by the employees until so late in 2018 that the payment is not viewed as requiring 2017 current financial resources.
The city received a piece of art this year as a donation. It is valued at $14,000. It will be used for general government purposes. There are no eligibility requirements. The city chose not to capitalize this property.
The general government uses the storage shed that was acquired this year. It is being depreciated over 10 years using the straight-line method with no salvage value. The city uses the equipment for health and sanitation and depreciates it using the straight-line method over five years with no salvage value.
The investments are valued at $103,000 at the end of the year.
For the equipment that has been ordered but not yet received, the City Council (the highest decision-making body in the government) has voted to honor the commitment when the equipment is received.
b-2. Prepare a balance sheet for the general fund as of December 31, 2017. Assume that the city applies the consumption method.
In: Accounting
The following information pertains to the City of Williamson for 2017, its first year of legal existence. For convenience, assume that all transactions are for the general fund, which has three separate functions: general government, public safety, and health and sanitation.
| Receipts: | |
| Property taxes | $320,000 |
| Franchise taxes | 42,000 |
| Charges for general government services | 5,000 |
| Charges for public safety services | 3,000 |
| Charges for health and sanitation services | 42,000 |
| Issued long-term note payable | 200,000 |
| Receivables at end of year: | |
| Property taxes (90% estimated to be collectible) | 90,000 |
| Payments: | |
| Salary: | |
| General government | 66,000 |
| Public safety | 39,000 |
| Health and sanitation | 22,000 |
| Rent: | |
| General government | 11,000 |
| Public safety | 18,000 |
| Health and sanitation | 3,000 |
| Maintenance: | |
| General government | 21,000 |
| Public safety | 5,000 |
| Health and sanitation | 9,000 |
| Insurance: | |
| General government | 8,000 |
| Public safety ($2,000 still prepaid at end of year) | 11,000 |
| Health and sanitation | 12,000 |
| Interest on debt | 16,000 |
| Principal payment on debt | 4,000 |
| Storage shed | 120,000 |
| Equipment | 80,000 |
| Supplies (20% still held) (public safety) | 15,000 |
| Investments | 90,000 |
| Ordered but not received: | |
| Equipment | 12,000 |
| Due in one month at end of year: | |
| Salaries: | |
| General government | 4,000 |
| Public safety | 7,000 |
| Health and sanitation | 8,000 |
Compensated absences (such as vacations and sick days) legally owed to general government workers at year-end total $13,000. These amounts will not be taken by the employees until so late in 2018 that the payment is not viewed as requiring 2017 current financial resources.
The city received a piece of art this year as a donation. It is valued at $14,000. It will be used for general government purposes. There are no eligibility requirements. The city chose not to capitalize this property.
The general government uses the storage shed that was acquired this year. It is being depreciated over 10 years using the straight-line method with no salvage value. The city uses the equipment for health and sanitation and depreciates it using the straight-line method over five years with no salvage value.
The investments are valued at $103,000 at the end of the year.
For the equipment that has been ordered but not yet received, the City Council (the highest decision-making body in the government) has voted to honor the commitment when the equipment is received.
a-2. Prepare a statement of net position for governmental activities for December 31, 2017.
In: Accounting
On January 1 of the current year, Herkimer & Co. purchases, a group of 6 laptops for its new hires. The laptops are purchased for $2,200 each with a residual value of $400 each. Herkimer expects the laptops to be used for 3 years. At the end of the current year, Herkimer & Co. sells two laptops for $1,900 each.
Required:
| Prepare the journal entries to record the purchase of the laptops, the depreciation on the laptops, and the sale of the laptops in Year 1. |
In: Accounting