Reference no: EM131191466
Accounting Project Spring
This is a formal project, and the following standards are to be applied:
If help is needed you may consult with instructor. You are encouraged to send the instructor drafts of your work to make sure that you are on the right track.
A. All items must be typed, except for the T accounts which may be neatly handwritten (although using excel spreadsheet would be useful).
B. Work must be collated in the following manner:
1. Cover Sheet
2. Problem 1 work (Financial Statements with proper headings) and brief written analysis.
3. General Journal Entries (problem 2)
4. Chart of Accounts-listing of all accounts with identification numbers (problem 2)
5. Ledger/T-Accounts (problem 2)
6. Financial Statements (problem 2)
7. Written Analysis (problem 2)
C. No projects will be accepted after the deadline. No exceptions. Early submission will be accepted and is encouraged.
D. This project is worth 20 % of your overall semester grade.
Problem One: Below is the financial data for One Corporation for 2013, 2014 and 2015
|
2015
|
2014
|
2013
|
|
Equipment $83,005
|
Cash $14,500
|
Owner's Equity $244,752
|
|
Cash $17,286
|
Marketable Securities $9,000
|
Accounts Payable $51,400
|
|
Accounts Receivable $49,317
|
Accounts Receivable $31,000
|
Cash $12,996
|
|
Owner's Equity $265,230
|
Allowance for Bad Debt $2750
|
Accounts Receivable $34,620
|
|
Plant $121,300
|
Plant $121,300
|
Allowance for Bad Debt $5,000
|
|
Land $80,030
|
Land $80,030
|
Inventory $48,201
|
|
Accounts Payable $57,424
|
Equipment $83,005
|
Plant $121,300
|
|
Marketable Securities $5,000
|
Accounts Payable $49,000
|
Land $80,030
|
|
Inventory $53,716
|
Long-Term Liabilities $75,000
|
Marketable Securities $4,000
|
|
Long-Term Liabilities $80,000
|
Inventory $46,000
|
Equipment $83,005
|
|
Allowance for Bad Debt $7,000
|
Owner's Equity $258,085
|
Long-Term Liabilities $83,000
|
|
Net Sales $611,873
|
Interest Expense $6400
|
Cost of Goods Sold $335,555
|
|
Income Taxes $20,026
|
Operating Expense $97,000
|
Income Taxes $19,200
|
|
Operating Expenses $122,183
|
Net Sales $468,065
|
Interest Expense $6400
|
|
Interest Expense $6400
|
Cost of Goods Sold $287,015
|
Operating Expense $104,121
|
|
Cost of Goods Sold $428,354
|
Income Taxes $16,775
|
Net Sales $511,773
|
Required:
*Prepare a multi-step Income Statement for each year
*Prepare a balance sheet for each year using the information given*
*Calculate Working Capital, Return on Investment and Return on Equity Ratios for each year
*Calculate Current Ratio and Acid-Test Ratio for each year
* Conduct a Trend Analysis and write a brief analysis on the financial position of the firm.
Problem Two:
2. The following transactions occurred during the first 30 days of operation of a new services company:
January 1 Owners invested Cash of $25,000
January 3 The Company borrowed $20,000 from a bank
January 4 Equipment was purchased for $12,000 on account
January 5 Office Supplies were purchased for $2600 with Cash
January 7 $2500 Cash was spent on advertising to let the public know about the new company
January 8 Revenue of $7500 was earned on account
January 10 Revenue of $1250 was earned and received as Cash
January 11 Revenue of $1000 was earned on account
January 13 Paid $750 with a check toward Accounts Payable
January 15 Revenue of $6000 was earned on account
January 15 Employee wages of $2750 were paid with Cash
January 16 Revenue of $4300 was earned and received as Cash
January 17 $2500 was spent on advertising with a check
January 18 Received $1500 Check (a check is considered cash) to be applied against on account from customer
January 19 Revenue of $1600 was earned on account
January 20 Paid $750 cash toward Accounts Payable
January 21 Equipment was purchased for $8500 Cash
January 22 Revenue of $10,000 was earned and received as Cash
January 23 Paid $1000 Check toward bank loan
January 24 Paid Utilities bill of $1000 with Check
January 25 Revenue of $3000 was earned on account
January 26 $2500 Cash was spent on advertising
January 27 Paid $800 toward Accounts Payable
January 28 Revenue of $9100 was earned and received as Cash
January 29 Employee Wages of $2750 were paid with Cash
January 30 Paid $1000 Cash toward bank loan
**** If cash (or a check is received) on account, this means that accounts receivable is credited (decreased)
**** If revenue is earned on account, accounts receivable is debited (increased)
**** If cash is paid on account, accounts payable is debited (decreased), while cash is credited (also decreased)
• Prepare journal entries for each of the transactions in either Word or Excel
• Prepare a Chart of Accounts (for example 100 Cash, 101 Accounts Receivable, 102 Equipment, 201 Accounts Payable)
• Set up T accounts in an Excel spreadsheet for each category and record transactions (debits and credits)
• Calculate net income for the month dated January 31, 2014 by preparing a detailed income statement (listing out each individual expense)
• Prepare a balance sheet dated January 31, 2014
• Prepare a short written analysis of your company's financial performance during its first month of operations. Include quantitative data in your summary. A paragraph or two is expected.
|
What physical assets can be used to increase profitability
: While I do support employee bonuses and recognition I do believe excess cash should be use to increase other assets including its employees. What physical assets can be used to increase the shareholder's profitability?
|
|
Summarise literature in the field of occupational health
: The first part assesses your ability to locate, summarise and reference appropriate literature in the field of occupational health. The second part requires you to prepare a referenced summary of the psychological effects, occurrence and preventi..
|
|
Principles that american government
: Explain the principles that American Government is based upon. As you discuss those values, focus your attention on both the normative and procedural aspects.
|
|
Describe the three most important rules of media buying
: You have been assigned the task of purchasing media for your client's advertising campaign. In a two to four-page paper, discuss the steps you would use in determining how you would select a media venue. Describe each of the five W's for your medi..
|
|
Prepare a multi-step income statement for each year
: Prepare a multi-step Income Statement for each year. Prepare a balance sheet for each year using the information given. Calculate Working Capital, Return on Investment and Return on Equity Ratios for each year
|
|
Discuss the effect on the assessable income of the parent
: Discuss whether or not the three payments are income from personal exertion.- Discuss the effect on the assessable income of the parent.
|
|
Would all employees benefit from these policies
: Suggest two policies that you think employers could institute that would best promote work-life balance among their employees. Be sure to explain why you think these policies would help. Would all employees benefit from these policies or just cert..
|
|
Define the term social engineering
: In the context of the above scenario, define the term 'social engineering'. In the above scenario, identify FOUR (4) instances where the staff member was subject to a social engineering technique. Identify the technique and say why it was used
|
|
Determine the tension t required to hold the rectangular
: Determine the tension T required to hold the rectangular solid in the position shown. The 125-kg rectangular solid is homogeneous. Friction at D is negligible.
|