Reference no: EM131533927
Journal Lledger Workbook
This assignment has three parts to it I first need an outline of the entire project then part 1 is another assignment and the Length: 3 tabs of the Excel file should be completed is for that one. And last one has to have part 1 and 2 combined with the deliverable length below
Length: 6 Excel worksheets & a memo (minimum 350-500 words)
Part 1 Tasks From Phase 4
Scenario
It is time for the staff accountants to begin preparing daily accounting transactions. In preparation of the upcoming audit, the accountants must ensure that these transactions are correct and are free from any misstatement. Because this is a new subsidiary of the company, there are no beginning balances.
As a staff accountant, your job is to do the following:
• Prepare the 10 transactions below by posting to the general journal. You should use an Excel spreadsheet to accomplish this task.
• Post the general journal entries to the general ledger in the Excel spreadsheet.
• Prepare a trial balance from the ending balances on the ledger. You should also use an Excel file for the trial balance.
Transactions
1. Invested $50,000 in the business
2. Paid $100 for phone service
3. Purchased $35,000 equipment on credit
4. Paid $3,000 for 3 months rent
5. Paid $5,500 for 6 months of insurance
6. Paid $1,000 for advertising on credit (Note: This is an expense to the company)
7. Customer purchased $2,000 on account
8. Customer in #7 paid $1,000 on account
9. Paid for #6 advertising
10. Sold to customer and received $5,000 cash
General Journal Ledger template.
Part 2 Tasks
Complete a set of financial statements based on the transactions and general ledger from the Phase 4 IP. The financials to be completed on an Excel spreadsheet are the following:
• Income statement
• Statement of owners' equity
• Balance sheet
Financial Statement Template.
Based on the financial statements, prepare a memo to the President of LMO Company as to the financial performance of your company. Include the following:
• 3 strategies that the company can employ to improve its performance and increase net income
• Explanation of who might use the financial statements
o Be sure to include internal and external users.
Attachment:- Templates.rar
|
How bizcon could have positive net income
: Prepare the memo in a maximum 700 words. Explain to management how BizCon could have positive net income and yet run out of cash.
|
|
The quality of the user experience
: The quality of the user experience is very important to the success of an application.
|
|
Record the exchange assuming esteban paid cash
: Esteban Co. owns a machine that costs $38,400 with accumulated depreciation of $20,400. Esteban exchanges the machine for a newer model that has a market value.
|
|
Generate perpetual cash flows
: A firm is considered a project that will generate perpetual cash flows of $15,000 per year beginning next year.
|
|
Complete set of financial statement based on the transaction
: Complete a set of financial statements based on the transactions and general ledger from the Phase 4 IP. Explanation of who might use the financial statements.
|
|
Non value-maximizing motives for mergers
: Explain how agency problems may lead to non value-maximizing motives for mergers.
|
|
Discuss the international accounting standards
: Accounting for plant assets involves cost determination, depreciation, additional expenditures, and disposals. Is plant asset accounting broadly similar.
|
|
Develop a system scope document
: HS2061 Information Systems Project Management Case study analysis Assignment. Using the Delivered Case Study provided, develop a system scope document
|
|
Compute the cost recorded for this machine
: Farha Co. purchases a machine for $11,500, terms 2y10, ny60, FOB shipping point. The seller prepaid the $260 freight charges, adding the amount to the invoice.
|