Reference no: EM132283453
Accounting Assignment -
Create the adjusted trial balance and the financial statements for a merchandising company for the fiscal year ending December 31, 2018. You will "make up" all numbers included in the adjusted trial balance, and ultimately the financial statements, except where a required balance is indicated, as detailed below.
The following must be reflected in those statements:
- use only whole numbers throughout the project - no cents or place holders for cents;
- the company is organized as a corporation;
- the company has both cumulative preferred and common stock issued;
- it was the company's first year of operations;
- the company is a merchandiser with an ending inventory on December 31;
- the cash account has an ending balance of $65,000;
- the company recognized bad debt expense on December 31 in the amount of $19,500 (allowance for doubtful accounts method is used - not the direct method);
- the company purchased only one long-term, depreciable asset during the year and depreciation was recognized - in addition, the asset was still in service on December 31 and will be in service during 2019;
- the company declared dividends during December in an amount large enough for common stockholders to receive a dividend (Statement of Stockholders' Equity must identify amount declared for preferred stockholders and amount declared for common stockholders);
- On December 31, the company still held all treasury stock that was repurchased during the year;
- the company has at least four current liabilities;
- the company issued $115,000 15-year, 7% bonds on July 1; the bonds pay interest semiannually on January 1 and July 1, and the effective interest rate method is used to amortize the bonds; the market rate of interest was 6% on the day of issuance.
- the bond described in the previous bullet point is the only interest-bearing liability that the corporation has ever entered into;
- the company had invested in only one trading security investment, which it still held on December 31 - the investment was purchased for $45,000 and has increased in value since its purchase;
- the company had invested in only one available-for-sale investment, which it still held on December 31 - the investment had decreased in value since its purchase;
- the income statement SHOULD NOT INCLUDE the earnings per share calculation, because the number of shared outstanding during the fiscal year did not remain constant throughout (requiring a weighted-average calculation).
Part A: Narrative
Provide the following in a bullet-point format:
Name of the company;
The product that the company is selling;
Preferred stock (cumulative) description that includes:
- number of shares: authorized, issued and outstanding
- par value of the stock
- percentage of par used to calculate dividend rights
- Common stock description that includes:
- number of shares: authorized, issued and outstanding
- par value of the stock
Part B: Adjusted Trial Balance -preparation in Excel required
Employ proper adjusted trial balance formatting, including:
- title centered over the adjusted trial balance;
- accounts listed in general ledger order;
- all numbers formatted using the "accounting" category;
- a $ sign at the top of each column and at the bottom of each column only;
- sum lines and double sum lines employed properly;
- "sum" function used to calculate the total for each column.
On the same Excel worksheet, but outside of the space used to prepare the Adjusted Trial Balance, complete the following tasks:
1. List the following labels in a column in the following order:
- Total Assets
- Total Liabilities
- Total Equity (not including the income statement accounts)
- Net Income
2. In the next column to the right, use a function to calculate the total for each of those respective items (listed in part 1 immediately above).
3. In the cell immediately below the total for "net income", use a function to calculate the following: Total Assets minus Total Liabilities minus Total Equity minus Net Income (using the totals you calculated in step 2 immediately above). NOTE: You should arrive at a total of zero.
Part C: Financial Statements
The set of financial statements must include the following:
1. Income Statement - you must use a multi-step income statement format.
2. Statement of Comprehensive Income - presented as a separate statement from the Income Statement.
3. Statement of Stockholders' Equity.
4. Classified Balance Sheet.
5. Statement of Cash Flows - only the title and the last three lines of this statement should be prepared.
Part D: Questions pertaining specifically to your company
1. The normal balance of the Retained Earnings account is a credit. Please discuss why a debit balance appears on the Adjusted Trial Balance. Provide enough detail to convince me that you understand the concept.
2. What was the balance in the Income Summary account immediately before closing the Income Summary Account to Retained Earnings? - indicate amount and whether it held a debit or credit balance.
3. What amount do debits and credits on the Post-Closing Trial Balance each total?
4. Assume the bonds that were issued during 2018 are not redeemed during 2019. What amount of interest expense will be recognized during 2019 for the bonds? You must show your work to earn any credit for this answer.
5. Assume that during 2019 there are no stockholder equity transactions that involve the sale or purchase of any of the corporation's stock, and that net income for 2019 is $1,500,000. Calculate earnings per share for 2019. You must show your work to earn any credit for this answer.