Accounting homework help

INSTRUCTIONS
➢ You are not to work with any other students (current or former) on this project. You are not
to get help from family/friends. You are not to share spreadsheets or any other materials.
Violating these will result in a zero on this project and could also cause you to fail the entire
course. If this is unclear, it is your responsibility to ask me.
➢ Name your company and pick the products and services that you sell
➢ Complete each of the requirements listed below in Part I and Part II
PART I Record Entries and Build the Financial Statements
1. Company Introduction and Overview
Give a quick overview of your company. What is your company’s name? What products and
services do you sell?
2. Journal Entry List
Record entries from the transaction and event list provided below in proper journal entry format.
NOTE: You are recording entries for the fiscal year 2019 (Jan 1 – Dec 31). This list must be
organized. Make sure that I can easily identify the journal entry or adjusting journal entry with the
related transaction/event. Show your work if the entry requires you to make a calculation (i.e.
depreciation, interest expense, etc.).
3. Chart of T-Accounts
Create a chart of T-Accounts and post each journal entry to the appropriate accounts.
4. Financial Statements
Build a multi-step income statement and a balance sheet for the year ending December 31, 2019
(include three years of data for 2019, 2018, and 2017 on both the income statement and
balance sheet). Create a statement of cash flows for 2019 and 2018 using the indirect method.
PART II Analyze the Company
5. Ratio Analysis (ALL THREE YEARS)
Compute the following using the information from the financial statements you have produced for
2019. Show your work. Explain what every calculation means (i.e. explain the answer in nonbook language). Provide graphs which show the three-year trends of each ratio.
− Earnings Per Share
− Price-earnings ratio
− Return on Equity
− Working Capital
− Current Ratio
− Quick Ratio
− Inventory Turnover
− Gross Profit
− Gross Profit Ratio
− Operating Income
− Operating Margin
− Debt-to-equity ratio
Page 2 of 9
− AR Turnover − Book value per share
6. Business Analysis
Separate from your ratio analysis, perform an analysis of your business using your results from
the required calculations listed above and any other trend information you deem to be relevant.
Use these calculations to determine how the company is doing overall. Hint: Consider creating
graphs/tables to support your conclusions NOTE: Assume that you are the CEO of the company
when preparing your response to this question.
7. Projected Income Statement for 2020
Build a projected income statement for next year based on forecasted sales that equal
$3,500,000 (do not use a different amount than the $3,500,000 provided). Use the results of
the analysis you performed in the preceding question and any other information you deem to be
relevant to build this income statement. Provide a brief explanation of the method(s) your group
used to determine the projected numbers per account.
8. Actual vs. Predicted Earnings Per Share Evaluation
Analysts predicted earnings per share (EPS) for your company to be $0.13 at the close of 2019.
How does this compare to actual EPS for 2019? If actual EPS is higher than the analysts’
prediction, what factors contributed to the success? If actual EPS is lower than the prediction,
how will you explain the shortfall to your investors? Is there anything you could have done to meet
the prediction? NOTE: Assume that you are the CEO of the company when preparing your
response to this question.
SUBMIT THE FOLLOWING
➢ The physical printed-out package you submit must be in the following order:
1. Company Introduction and Overview – Indicate student names, UIDs, and project
version
2. Financial Statements (in the following order):
− Income Statement
− Balance Sheet
− Statement of Cash Flows for 2019 and 2018
3. Ratio Analysis
4. Business Analysis
5. Projected Income Statement for 2020 – Remember to include a discussion of the
methods used by your group to create this income statement
6. Actual vs. Predicted Earnings Per Share Evaluation
7. Include the following supporting documentation: Journal Entry List, Chart of TAccounts,
Inventory Tracking Schedule, Depreciation Schedules, Patent Amortization Schedule,
Page 3 of 9
Bond Amortization Schedule, and any other relevant items – such as Vertical or
Horizontal Analysis, etc.
➢ You will also upload the following pieces into canvas:
1. Business Analysis
I expect the package that you turn in to be professional in every way.
Your project will be compared to your classmate’s projects. Good Luck! -Xiaoxia
COMPANY INFORMATION
➢ Your company began operations on January 1, 2016.
➢ From January 1, 2017 – December 31, 2018 your company’s stock is traded on the NYSE with
4,000,000 common shares outstanding with a par value of $.25.
➢ At the close of December 31, 2019, your company’s stock was trading at $5.00 per share. On
November 1st the stock was trading at $3.25. At the end of 2018 and 2017, the value of your stock
was $3.80 and $2.90, respectively.
➢ Use the Cost Method for treatment of Treasury Stock.
➢ Use the Allowance Method in accounting for Bad Debts, specifically the Percentage of Accounts
Receivable Method.
➢ The inventory valuation used by your company is LIFO.
➢ The company’s inventory on January 1st, 2019 consists of 13,000 units.
Prior Income Statement Account Balances
2018 2017
Sales, net $ 2,280,000 $ 2,500,000
Cost of Goods Sold
850,000
780,000
Wages Expense
565,000
785,000
Utility Expense
37,050
37,500
Insurance Expense
23,905
21,097
Rent Expense
18,009
17,080
Fuel Expense
2,900
1,400
Office Supplies Expense
6,000
5,000
Advertising Expense
23,000
25,000
Page 4 of 9
Bad Debt Expense
60,750
45,000
Depreciation Expense
500,000
500,000
Interest Income
23,676
21,574
Interest Expense
56,250
56,250
Gain on Sale –
34,900
Loss on Sale –
120,000
BALANCE SHEET
December 31, 2018 2017
Assets
Cash $ 525,710 $ 658,079
Marketable Securities
75,000
15,000
Accounts Receivable 455,000 525,000
Allowance for Bad Debt
(25,000)
(105,000)
Interest Receivable
23,676
21,574
Prepaid Advertising – –
Prepaid Insurance 139,836 148,945
Prepaid Rent
29,050
34,982
Office Supplies
3,520
5,400
Inventory 975,000 775,000
Current Assets
2,201,792
2,078,980
Office Furniture – –
Equipment
5,000,000
5,000,000
Accumulated Depreciation
(2,000,000)
(1,500,000)
Page 5 of 9
Long-Term Notes Receivable 285,000 –
Land
1,450,000
1,450,000
Patent – –
Non-Current Assets
4,735,000
4,950,000
Total Assets $ 6,936,792 $ 7,028,980
Liabilities
Accounts Payable $ 450,000 $ 570,000
Wages Payable
35,000
33,000
Interest Payable – –
Short-Term Notes Payable – –
Deferred Revenue – –
Dividends Payable 155,000 135,000
Bond Interest Payable – –
Current Liabilities 640,000 738,000
Long-Term Notes Payable
1,250,000
1,250,000
Bonds Payable – –
Total Liabilities
1,890,000
1,988,000
Stockholders’ Equity
Common Stock
1,000,000
1,000,000
Additional Paid-In Capital
1,824,406
1,824,406
Treasury Stock – –
Contributed Capital 500,000 500,000
Retained Earnings
1,722,386
1,716,574
Total Stockholders’ Equity
5,046,792
5,040,980
Page 6 of 9
Total Liabilities & SE $ 6,936,792 $ 7,028,980
2019 TRANSACTION AND EVENT LIST Version B
HINT: Before booking an entry, remember to evaluate the substance of each transaction/event. Do
accounting standards require the event or transaction to be booked into your company’s accounting
records? NOTE: All interest rates included in the transaction list are stated at an annual rate.
January
1. On January 1st, The Board of Directors issued 250,000 additional shares (par of $.25) to raise
capital for the New Year. Assume no change in price from Dec 31, 2018.
2. Purchased a truck for $240,000 cash on the 1st of January. The truck will be depreciated over a
5-year period. You decide to use the 200% declining-balance depreciation method because it is
determined that the truck will be more productive when it is newer. The truck has an estimated
salvage value of $22,000.
[Adjusting Entry Required]
3. Purchased new office furniture for $93,000 with cash from California Furniture on January 1, 2019.
The new furniture will be depreciated over a ten-year period on a straight-line basis. The cabinet
has an estimated salvage value of $7,000.
[Adjusting Entry Required]
4. On January 1st, a 5 year, $128,000 long-term note payable was taken from a local bank.
5. On January 5th you receive payment from interest earned and accrued in 2018.
6. On January 22nd you purchased 8,500 additional units of inventory at a cost of $78.50 per unit.
You paid 45% in cash and purchased the remainder on account.
7. On January 25th you pay $219,000 cash toward your accounts payable.
February
8. Paid cash for $52,900 worth of radio advertising on February 1st. This gives you radio advertising
space until January 31st, 2020.
[Adjusting Entry Required]
9. February 13th you collect $366,000 of account payments from customers.
March
10. Purchased a parcel of land on March 1, 2019 for $990,000 by paying $450,000 in cash and signing
a short-term note payable with the seller for $540,000. You must repay the $540,000 in exactly
Page 7 of 9
one year on March 1, 2020. You agree to pay the seller 5 percent interest (annual rate) on a
quarterly basis (June 1, September 1, December 1, 2019, and March 1, 2020). [Adjusting Entry
Required]
11. On March 19th you purchased $21,000 of office supplies from Super Office Supplies with cash.
12. On March 20th you received a payment of $62,000 for 200 hours of service to be performed in the
future.
April
13. April 21st, your customers bought 15,000 units of your product for $124 per unit (you decide what
your company sells). The cost of this product is determined by the method of inventory valuation
used by your company. Customers paid you 60% in cash and the remainder was on account.
14. On April 27nd you purchased 9,250 units at a cost of $77 per unit. You paid 55% in cash and
purchased the remainder on account.
15. On April 29th you pay $483,000 cash toward your accounts payable.
May
16. On May 1st you pay all dividends owed to your owners.
June
17. Leased additional warehouse space from Leasing Solutions for two years on June 1st due to
expiration of the previous rental contract. $155,000 cash was paid for the new contract on this
date which covers the rental fee for two years. There is no value left in the previous contract.
[Adjusting Entry Required]
18. Wage expenses from January 1 – June 30 are $502,000. Pay this in full including your beginning
balance in wages payable.
19. On June 19th, $133,000 of prepaid insurance was used.
20. On June 26th a customer that previously bought your product on account has filed for bankruptcy.
He owed you $49,500. You expect to collect $0.
July
21. Your company issued 1,000, 3.8% bonds (face value of each bond is $1,000) at 102.2873 on July
1
st, 2019. The bonds are due on July 1, 2024, with interest payable each January 1 and July 1.
The market rate at the time of the bond issuance was 3.3%. Use the effective-interest method to
Page 8 of 9
calculate both the interest expense and the amortization of the bond discount when each interest
payment is made.
[Adjusting Entry Required]
August
22. Purchased a Patent (Intangible Asset) for $86,000 on August 1st. The patent will be amortized
over a 10-year period on a straight-line basis.
[Adjusting Entry Required]
23. On August 6th, a piece of land that was originally purchased for $1,250,000 was sold for
$2,000,000 cash.
24. August 15th, your customers bought 9,000 units of your product at $129 per unit. The cost of this
product is determined by the method of inventory valuation used by your company. Customers
paid you 60% in cash and the remainder was on account.
25. Received on August 25th a $193,000 cash payment from a customer paying on their account.
September
26. $44,000 cash was paid for an investment in Company X’s marketable securities on September
3
rd
.
27. On September 12th, a piece of equipment was sold for $750,000 cash. The equipment was
originally purchased for $510,000. At the time of the sale, it had been depreciated by $90,000.
28. Purchased and used $9,600 worth of fuel for the delivery truck on September 18th
.
October
29. Your top sales officer met with a new customer to discuss a potential future contract. She informs
you that the customer is considering signing the $289,000 deal, which would become effective
February 2020.
30. On October 1st, you purchased 11,250 units at the increased price of $82 per unit. The purchase
was made on account.
31. On October 10th you paid your supplier $235,000 cash for inventory purchased on account.
November
32. November 1st, the CEO, in an effort to adjust ratios, ordered the repurchasing of the company’s
own stock. The quantity of stock repurchased was 160,000 shares.
33. Purchased a two-year building insurance policy on November 1st for $364,000 cash. [Adjusting
Entry Required]
Page 9 of 9
34. On November 17th a customer pays you $458,000 for work that you will finish in January of 2020.
35. November 19th, your customers bought 8,650 units of your product at $135 per unit. The cost of
this product is determined by the method of inventory valuation used by your company. Customers
paid you 45% in cash and the remainder was on account.
36. An employment contract is signed with a new regional manager. You have offered him $160,000
per year. He will not begin working for the company until March 2020.
December
37. Wages earned from July 1st through December 31st was $536,000. Wages earned between Dec.
15th and Dec 31st amounting to $36,000 was not paid this until Jan 7th.
38. At the end of the year, $57,000 cash was paid to the local bank for the long-term note payable
taken out on January 1, 2019. $46,000 of this was applied to the loan principal. The remaining
amount was the accumulated interest due for 2019.
39. On December 31
st, the marketable (trading) securities you purchased on September 3, 2019
transaction now has a fair market value of $38,000.
40. On December 31st, $476,000 depreciation expense for the year was calculated for equipment
purchased before January 1, 2019.
41. On December 31st, you declare dividends of $.24 per share to be paid at a later date.
42. On December 31st, the utility bill was paid for the year. The amount was $62,000 and you paid in
cash.
43. On December 31st, you pay in cash recurring interest on the long-term note acquired prior to the
year 2017. HINT: See prior year financial statements.
44. On December 31st, your company earned interest on the average 2019 cash balance which will
be paid January 5th, 2020. The average interest rate for the year was 4.0%. Note: Compute the
average cash using only the beginning and ending balance.
45. By December 31st, 123 of the prepaid service hours from March 20, 2019 were completed.
46. A count of office supplies indicated that $20,800 of office supplies had been used by December
31st
.
47. Since the inception of your company, you have been able to collect 88% of your ending accounts
receivable balance from customers that bought your product on account. Based on this
information, adjust your allowance for bad debt account. NOTE: Use your 2019 ending accounts
receivable balance to make this calculation