Ealing Company began operations as a new subsidiary of
Fundamental Company, a U.S. Corporation, on January 2, 2018, by
issuing common stock for 180,000 foreign currency units (FCU).
Ealing immediately borrowed 35,000 FCU with a 10-year, 10% note,
interest payable annually on January 1. On the same date, Ealing
bought a building for 200,000 FCU. The building was to be
depreciated for 20 years on a straight-line basis with a residual
value of 40,000 FCU.
During the year, the building was rented for 9,000 FCU per month.
At year's end, all rent had been collected.
On May 1 a repair on the building of 15,000 FCU was completed and
paid for. Land for a parking lot was acquired for 30,000 FCU in
cash on June 1.
A dividend of 20,000 FCU was declared and paid on December 1.
Exchange rates for the year were as follows:
January 2, 2018 1 FCU = $.30
May 1, 2018 1 FCU = .37
June 1, 2018 1 FCU = .38
November 1, 2018 1 FCU = .41
December 1, 2018 1 FCU = .39
December 31, 2018 1 FCU = .35
average for 2018 1 FCU = .36
Fundamental company determined that the FCU was the functional
currency and translation using the current rate method was
appropriate for consolidation. Calculate the translation adjustment
for 2018. (You might remember that the translation adjustment uses
the net assets approach, not the net monetary assets approach.)
In: Accounting
Calculate the monthly returns for 08/01/2015 – 08/31/2019 period for
(i) S&P 500:
| Date | Adj Close |
| 8/1/2015 | 1972.18 |
| 9/1/2015 | 1920.03 |
| ######## | 2079.36 |
| ######## | 2080.41 |
| ######## | 2043.94 |
| 1/1/2016 | 1940.24 |
| 2/1/2016 | 1932.23 |
| 3/1/2016 | 2059.74 |
| 4/1/2016 | 2065.3 |
| 5/1/2016 | 2096.95 |
| 6/1/2016 | 2098.86 |
| 7/1/2016 | 2173.6 |
| 8/1/2016 | 2170.95 |
| 9/1/2016 | 2168.27 |
| ######## | 2126.15 |
| ######## | 2198.81 |
| ######## | 2238.83 |
| 1/1/2017 | 2278.87 |
| 2/1/2017 | 2363.64 |
| 3/1/2017 | 2362.72 |
| 4/1/2017 | 2384.2 |
| 5/1/2017 | 2411.8 |
| 6/1/2017 | 2423.41 |
| 7/1/2017 | 2470.3 |
| 8/1/2017 | 2471.65 |
| 9/1/2017 | 2519.36 |
| ######## | 2575.26 |
| ######## | 2584.84 |
| ######## | 2673.61 |
| 1/1/2018 | 2823.81 |
| 2/1/2018 | 2713.83 |
| 3/1/2018 | 2640.87 |
| 4/1/2018 | 2648.05 |
| 5/1/2018 | 2705.27 |
| 6/1/2018 | 2718.37 |
| 7/1/2018 | 2816.29 |
| 8/1/2018 | 2901.52 |
| 9/1/2018 | 2913.98 |
| ######## | 2711.74 |
| ######## | 2760.17 |
| ######## | 2506.85 |
| 1/1/2019 | 2704.1 |
| 2/1/2019 | 2784.49 |
| 3/1/2019 | 2834.4 |
| 4/1/2019 | 2945.83 |
| 5/1/2019 | 2752.06 |
| 6/1/2019 | 2941.76 |
| 7/1/2019 | 2980.38 |
| 8/1/2019 | 2926.46 |
In: Finance
Ray Inc. sponsors a defined benefit pension plan for its employees. At January 1, 2018, Ray Inc. has unrecognized prior service cost of $24 million (amortized $4 per year) and net gains in AOCI of $30 million (amortized over 10 years). Ray Inc. reported Net Pension Asset of $10 million on its balance sheet as of December 31, 2017. Additional information for Ray’s pension plan follows (the fiscal year ends in December):
|
(in $ millions) |
12/31/2017 |
12/31/2018 |
|
Projected benefit obligation |
240 |
273 |
|
Plan assets (at fair value) |
? |
270 |
|
(in $ millions) |
During 2017 |
During 2018 |
|
Service cost |
50 |
41 |
|
Interest cost, (discount rate 5%) |
? |
? |
|
Expected rate of return, 10% |
? |
? |
|
Actual return on plan assets |
? |
20 |
|
Annual contributions |
0 |
20 |
|
Benefits paid to retirees |
30 |
20 |
Record the journal entry for pension expense for 2018. Write step by step
Record the journal entry for gain or losses in PBO for 2018 if necessary. Write no entry if unnecessary.
Record the journal entry for gain or losses in plan assets for 2018 if necessary. Write no entry if unnecessary.
Record the journal entry for cash contribution to plan assets for 2018 if necessary. Write no entry if unnecessary.
Record the journal entry for benefits paid to employees for 2018 if necessary. Write no entry if unnecessary.
What is the balance of Net gain–AOCI at December 31, 2018 and what will be the “amortization of net gain–OCI” amount in 2019?
Please explain step by step.
In: Accounting
(mysql)Lab 10 Database Normalization
The relation (PatientLab) below provides some sample data for a clinic office that stores patient, insurance, lab test, and lab test result information. The relation is already in first normal form (1NF). Assuming that one patient can have multiple different tests performed in one day and same test can be performed for the same patient in different dates.
|
Patient _ID |
Name |
Insurance_Code |
Insurance_Name |
DOB |
Lab_Test_ID |
Lab_Test_Name |
Lab_Result |
Lab_Test_Date |
|
P001 |
Joe Doe |
IN001 |
B&B |
1/1/1990 |
L001 |
WBC |
5 |
5/5/2019 |
|
P001 |
Joe Doe |
IN001 |
B&B |
1/1/1990 |
L002 |
RBC |
5.2 |
5/5/2019 |
|
P001 |
Joe Doe |
IN001 |
B&B |
1/1/1990 |
L003 |
MCV |
90 |
5/5/2019 |
|
P002 |
John Smith |
IN002 |
Aetna |
2/2/1988 |
L002 |
RBC |
5.8 |
5/6/2019 |
|
P002 |
John Smith |
IN002 |
Aetna |
2/2/1988 |
L004 |
MCH |
32 |
5/6/2019 |
|
P001 |
Joe Doe |
IN001 |
B&B |
1/1/1990 |
L001 |
WBC |
4.2 |
5/7/2019 |
1. Provide examples to show that insertion, deletion, and modification anomalies could occur on this table.
a. Insertion anomaly
b. Deletion anomaly
c. Update anomaly
2. Identify the functional dependencies represented by the attributes shown in the above table. State any assumptions you make about the data and the attributes.
Note: Assume that the primary key is (Patient_ID, Lab_Test_ID, Lab_Test_Date) which fully functionally determines the Lab_Result.
|
Patient _ID |
Name |
Insuranc_Code |
Insurance_Name |
DOB |
Lab_Test_ID |
Lab_Test_Name |
Lab_Result |
Lab_Test_Date |
3. Describe and illustrate the process of normalizing the table shown above to 3NF. Identify the primary keys and foreign keys in your resulting relations after 3NF.
1NF: (Find any repeating group and process it if there is any.)
Relations after 1NF
2NF: (Find any partial dependency and process it if there is any.)
Relations after 2NF
3NF: (Find any transitive dependency and process it if there is any.)
Relations after 3NF (Show primary key and foreign key in each relation.)
Q: answer for 1,2,3 plz
In: Computer Science
On October 1, 2018, Jay Pryor established an interior decorating business, Pioneer Designs. During the month, Jay completed the following transactions related to the business:
| Oct. | 1 | Jay transferred cash from a personal bank account to an account to be used for the business in exchange for common stock, $32,800. |
| 4 | Paid rent for period of October 4 to end of month, $3,180. | |
| 10 | Purchased a used truck for $27,000, paying $3,000 cash and giving a note payable for the remainder. | |
| 13 | Purchased equipment on account, $12,790. | |
| 14 | Purchased supplies for cash, $2,200. | |
| 15 | Paid annual premiums on property and casualty insurance, $4,920. | |
| 15 | Received cash for job completed, $13,780. |
Enter the following transactions on Page 2 of the two-column journal:
| 21 | Paid creditor a portion of the amount owed for equipment purchased on October 13, $4,560. | |
| 24 | Recorded jobs completed on account and sent invoices to customers, $15,680. | |
| 26 | Received an invoice for truck expenses, to be paid in November, $1,440. | |
| 27 | Paid utilities expense, $1,640. | |
| 27 | Paid miscellaneous expenses, $590. | |
| 29 | Received cash from customers on account, $6,560. | |
| 30 | Paid wages of employees, $4,360. | |
| 31 | Paid dividends, $3,640. |
Required:
1. Journalize and insert the posting references
for each transaction in a two-column journal beginning on Page 1,
referring to the following chart of accounts in selecting the
accounts to be debited and credited. For a compound transaction, if
an amount box does not require an entry, leave it blank.
| 11 | Cash | 31 | Common Stock |
| 12 | Accounts Receivable | 33 | Dividends |
| 13 | Supplies | 41 | Fees Earned |
| 14 | Prepaid Insurance | 51 | Wages Expense |
| 16 | Equipment | 53 | Rent Expense |
| 18 | Truck | 54 | Utilities Expense |
| 21 | Notes Payable | 55 | Truck Expense |
| 22 | Accounts Payable | 59 | Miscellaneous Expense |
| General Journal | Page 1 | |||
|---|---|---|---|---|
| Date | Description | Post. Ref. | Debit | Credit |
| 2018 | ||||
| Oct. 1 | Cash | |||
| Common Stock | ||||
| Oct. 4 | Rent Expense | |||
| Cash | ||||
| Oct. 10 | Truck | |||
| Cash | ||||
| Notes Payable | ||||
| Oct. 13 | Equipment | |||
| Accounts Payable | ||||
| Oct. 14 | Supplies | |||
| Cash | ||||
| Oct. 15 | ||||
| Oct. 15 | ||||
| General Journal | Page 2 | |||
|---|---|---|---|---|
| Date | Description | Post. Ref. | Debit | Credit |
| 2018 | ||||
| Oct. 21 | ||||
| Oct. 24 | ||||
| Oct. 26 | ||||
| Oct. 27 | ||||
| Oct. 27 | ||||
| Oct. 29 | ||||
| Oct. 30 | ||||
| Oct. 31 | ||||
2. Post (in chronological order) the journal to a ledger of four-column accounts, inserting appropriate posting references in the general journal as each item is posted. Extend the balances to the appropriate balance columns after each transaction is posted. If an amount box does not require an entry, leave it blank.
| General Ledger | ||||||
|---|---|---|---|---|---|---|
| Account | Cash | ACCOUNT NO. | 11 | |||
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 1 | 1 | |||||
| Oct. 4 | 1 | |||||
| Oct. 10 | 1 | |||||
| Oct. 14 | 1 | |||||
| Oct. 15 | 1 | |||||
| Oct. 15 | 1 | |||||
| Oct. 21 | 2 | |||||
| Oct. 27 | 2 | |||||
| Oct. 27 | 2 | |||||
| Oct. 29 | 2 | |||||
| Oct. 30 | 2 | |||||
| Oct. 31 | 2 | |||||
| Account | Accounts Receivable | ACCOUNT NO. | 12 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 24 | 2 | |||||
| Oct. 29 | 2 | |||||
| Account | Supplies | ACCOUNT NO. | 13 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 14 | 1 | |||||
| Account | Prepaid Insurance | ACCOUNT NO. | 14 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 15 | 1 | |||||
| Account | Equipment | ACCOUNT NO. | 16 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 13 | 1 | |||||
| Account | Truck | ACCOUNT NO. | 18 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 10 | 1 | |||||
| Account | Notes Payable | ACCOUNT NO. | 21 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 10 | 1 | |||||
| Account | Accounts Payable | ACCOUNT NO. | 22 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 13 | 1 | |||||
| Oct. 21 | 2 | |||||
| Oct. 26 | 2 | |||||
| Account | Common Stock | ACCOUNT NO. | 31 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 1 | 1 | |||||
| Account | Dividends | ACCOUNT NO. | 33 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 31 | 2 | |||||
| Account | Fees Earned | ACCOUNT NO. | 41 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 15 | 1 | |||||
| Oct. 24 | 2 | |||||
| Account | Wages Expense | ACCOUNT NO. | 51 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 30 | 2 | |||||
| Account | Rent Expense | ACCOUNT NO. | 53 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 4 | 1 | |||||
| Account | Utilities Expense | ACCOUNT NO. | 54 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 27 | 2 | |||||
| Account | Truck Expense | ACCOUNT NO. | 55 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 26 | 2 | |||||
| Account | Miscellaneous Expense | ACCOUNT NO. | 59 | |||
|---|---|---|---|---|---|---|
| Balance | ||||||
| Date | Item | Post. Ref. | Debit | Credit | Debit | Credit |
| 2018 | ||||||
| Oct. 27 | 2 | |||||
Feedback
1. Identify which accounts are affected in each transaction. Keep in mind that every transaction involves at least two accounts. Determine whether the account increases or decreases and record each increase or decrease following the rules of debit and credit. Use the Posting Reference column to enter the corresponding account number from the general ledger account. Remember total debits should equal total credits in your entries.
2. See the illustration in Exhibit 4 below. The 4-column accounts ledger is a more formal presentation of the T accounts. The Posting Reference column should have the page number from the journal where the transaction is found. The debits and credits for each journal entry are posted to the accounts in the order in which they occur in the journal. After each entry, subtotal the 4-column ledger, making sure to maintain the correct normal balance and double-checking any non-normal balances to see if they are valid or possible.
| Journal Entry Account | ||
| Common Transaction Terminology | Debit | Credit |
| Received cash for services provided | Cash | Fees Earned |
| Services provided on account | Accounts Receivable | Fees Earned |
| Received cash on account | Cash | Accounts Receivable |
| Purchased on account | Asset account | Accounts Payable |
| Paid on account | Accounts Payable | Cash |
| Paid cash | Asset or expense account | Cash |
| Issued common stock | Cash and/or other assets | Common Stock |
| Paid dividends | Dividends | Cash |
Learning Objective 1, Learning Objective 2, Learning Objective 3 and Learning Objective 4.
3. Prepare an unadjusted trial balance for Intrex Designs as of October 31, 2018. List all accounts in the order of Assets, Liabilities, Stockholders’ equity, Revenues, and Expenses.For those boxes in which no entry is required, leave the box blank. The first two account titles are filled in as an example.
| Pioneer Designs Unadjusted Trial Balance October 31, 2018 |
||
|---|---|---|
| Debit Balances | Credit Balances | |
| Cash | ||
| Accounts Receivable | ||
| Totals | ||
4. Determine the excess of revenues over
expenses for October.
$
In: Accounting
Why do corporations issue convertible securities?
What are the advantages of using restricted stock to compensate employees?
What are the disadvantages of using restricted stock to compensate employees?
What are some reasons that employees might prefer this type of compensation?
Skim through the major tenets of the PwC Stock-based compensation. In March 2016, the FASB issued Accounting Standards Update (ASU) 2016-09, Compensation—Stock Compensation (Topic 718): Improvements to Employee Share-Based Payment Accounting, which amends ASC 718. What are a few of the improvements to employee share-based payment accounting discussed in the report?
In: Accounting
The proportion of public accountants who have changed companies within the last three years is to be estimated within 5%. The 99% level of confidence is to be used. A study conducted several years ago revealed that the percent of public accountants changing companies within three years was 20. (Use z Distribution Table.) (Round the z-values to 2 decimal places. Round up your answers to the next whole number.)
a. To update this study, the files of how many public accountants should be studied?
b. How many public accountants should be contacted if no previous estimates of the population proportion are available?
In: Statistics and Probability
|
The proportion of public accountants who have changed companies within the last three years is to be estimated within 4%. The 95% level of confidence is to be used. A study conducted several years ago revealed that the percent of public accountants changing companies within three years was 21. (Use z Distribution Table.) (Round the z-values to 2 decimal places. Round up your answers to the next whole number.) |
| a. | To update this study, the files of how many public accountants should be studied? |
| b. |
How many public accountants should be contacted if no previous estimates of the population proportion are available? |
In: Math
Consider the following price data from 2002 to 2010
| Year | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 |
| Price | 3.34 | 3.56 | 3.61 | 4.06 | 4.25 | 4.37 | 4.68 | 4.59 | 4.81 |
a. Compute the simple price index using 2002 as the base year. (Round your answers to 2 decimal places.)
| Year | Price index |
|---|---|
| 2002 | |
| 2003 | |
| 2004 | |
| 2005 | |
| 2006 | |
| 2007 | |
| 2008 | |
| 2009 | |
| 2010 |
b. Update the index numbers with a base year revised from 2002 to 2005. (Round your answers to 2 decimal places.)
In: Math
The proportion of public accountants who have changed companies within the last three years is to be estimated within 5%. The 99% level of confidence is to be used. A study conducted several years ago revealed that the percent of public accountants changing companies within three years was 23. (Use z Distribution Table.) (Round the z-values to 2 decimal places. Round up your answers to the next whole number.)
a. To update this study, the files of how many public accountants should be studied? b. How many public accountants should be contacted if no previous estimates of the population proportion are available?
In: Math