ACC 112-Principles of Accounting II Excel Project

ACC 112-Principles of Accounting II Excel Project

ACC 112-Principles of Accounting II Excel Project 
On January 2, 2010 Mr. Burns decided to incorporate his business to Mr. Burns Good Old Fashion Cookies.

Complete the following tasks:
1. Prepare all journal entries on word/excel document.
2. Post all journal entries to the worksheet
3. Post all adjusting journal entries to the worksheet
4. In good form, produce an income statement, statement of retained earnings,
balance sheet and statement of cash flows.
5. Post the necessary closing entries to the proper accounts and update the retained
earnings account accordingly.

Instructions:
Post the regular journal entry amounts in columns G and I, post the adjusting journal entry amounts in columns O and Q, and post the closing entry amounts in columns W and Y.

Do not touch the columns with the account balances for they are formula driven. You will not have to calculate anything!

For tracking purposes post the journal entries as they appear. The regular transaction numbers will be posted in columns F and H. The adjusting transaction numbers will be posted in columns N and P. The closing transaction numbers will be posted in columns V and X. Regular transactions will have just the number (1, 2, 3, etc). Adjusting transactions will have A in front of the number (A1, A2, A3, and etc). Closing transactions will have C in front of the number (C1, C2, and C3). Failure to put in transaction numbers where instructed will automatically result in 15 point reduction in grade.

For the statements: use only the cells marked in yellow to put in numbers. The totals will calculate for you. You will not be required to do any formatting.

Check Figures:
Unadjusted Net Income: $171,268
Adjusted Net Income: $74,928
Ending Retained Earnings Balance: $203,860

Journal Entries
1. January 2: Mr. Burns sold 100,000 shares of common stock @ $10. The stock had a par value of $8
2. January 5: Mr. Burns collected $20,000 of prior accounts receivables by acquiring help from Fat Tony and the Mob.
3. January 5: Mr. Burns issued a bond (new bond) to raise the needed capital to enhance his evil empire in Springfield USA. The new bond is a five year 12%, $100,000 semi annual bond with an effective market rate of 10%. Payments are to be made semi-annually. The bond will be amortized using the effective interest method. Record the issuance of the new bond. Round to the nearest dollar.
4. February 4: Mr. Burns bought a new truck to speed up delivery time. Mr. Burns bought the truck outright for $20,000. The truck is expected to have a useful life of 150,000 miles.
5. February 10: Mr. Burns bought $200,000 of inventory on account. The freight cost was $2,000. The terms were FOB Destination.
6. March 1: Mr. Burns paid off what he originally owed in accounts payable at the beginning of the year.
7. March 15: Mr. Burns paid income tax from last year.
8. April 1: Mr. Burns wrote off a $1,000 of accounts receivable that he knew that he would never be able to collect from Homer Simpson. Record the write-off.
9. April 15: Mr. Burns sold on account $700,000 (2/10, n30) to city of Springfield. The cost of merchandise sold was $300,000
10. April 20: Because a couple of cookie batches had radiation contamination, they were returned. $100,000 of inventory was returned. The cost of merchandise sold was $40,000.
11. May 1: The city of Springfield paid Mr. Burns for the shipment of cookies in entry 9 and 10.
12. July 1: Mr. Burns made the third interest payment and amortized using the effective interest method on the old bond from January 1, 2009. This bond was a five year, semi annual bond with a face value of $100,000, effective market rate of 8%, and coupon rate of 6%. Payments are made semi-annual. Record the interest payment and the amortization. Round to the nearest dollar.
13. July 1: Mr. Burns made his first semi-annual interest payment on the new bond and amortized using effective interest method. Record the interest payment. Round to the nearest dollar.
14. July 1: Mr. Burns bought back 20,000 shares of treasury stock for $7 a share.
15. August 10: Mr. Burns paid the following expenses: Wage Exp $10,000, Rent Exp $20,000, Professional Fees $40,000, Sales Salary Exp $10,000, and Advertising Exp $60,000. (Combine the amounts into ONE cash entry)
16. August 25: Homer won some money in a trumped up lawsuit. He was able to pay off the debt he owed to Mr. Burns. This was the debt Mr. Burns previously wrote off.
17. September 15: Mr. Burns declared dividends of $50,000 because of an ether induced hallucination of Popping Fresh.
18. September 30: Mr. Burns sold 10,000 of the treasury stock with a cost $7 for $12 per share.
19. October 20: Mr. Burns paid off the entire Notes Payable which was due in 2012. The amount Mr. Burns paid included the face value of Note plus $10,000 of interest.
20. November 1: Mr. Burns paid off the Notes Payable due in December 2011. Mr. Burns paid full carrying value of the Note plus $500 of interest.
21. December 31: Mr. Burns made a semi annual interest payment on the old bond and amortized. Round to the nearest dollar.
22. December 31: Mr. Burns made a semi annual interest payment on the new bond and amortized. Round to the nearest dollar.
23. December 31: Mr. Burns paid the dividends previously declared.

Adjusting Entries
At December 31, 2010, Mr. Burns made the following adjusting entries to update the books.
A1. At year end, it was estimated that 6% of the year end accounts receivable will not be collected.
A2. Mr. Burns accrued for 2010 income taxes which are to be paid March 15, 2011, $70,000
A3. Mr. Burns earned the remaining amount of unearned revenue in 2009.
A4. Mr. Burns incurred the following depreciation expenses for the year:
Equipment (10 year straight line bought in 2007)
Machinery (10 year double decline bought in 2007)
Truck (driven 75,000 miles during the year)
Combine depreciation expense into one entry
A5. All prepaid expenses expired during the year.
A6. Office supplies were counted by Homer Simpson because he was caught skipping work. He counted $3,000 worth at year end.
A7. Accounts Receivables not recorded, $10,000

Closing Entries
At December 31, 2010, the following closing entries were needed:
C1. & C2. Close all revenue and expense accounts.
C3. Close income summary to retained earnings.
C4. Close the Dividends account.

CSU BBA4126 UNIT 4 AND 5 DISCUSSIONS

CSU BBA4126 UNIT 4 AND 5 DISCUSSIONS

Unit IV Discussion Board Question

Do you think risks can be eliminated if the project is carefully planned? Why, or why not? What is the difference between avoiding a risk and accepting a risk? Use a specific example to support your answer.


Please include the name of the person or question to which you are replying in the subject line. For example, "Tom's respon





Unit V Discussion QuestioN





Describe, in your own words, what you believe are the four most important characteristics of high-performing project teams. Tell why you believe each is so critical, and explain how they are related to each other. Give at least two specific suggestions for each.


Please include the name of the person or question to which you are replying in the subject line. For example, "Tom's response to Susan's comment."

se to Susan's comment."

proj

proj

proj
Project: Making IT Policy Decisions An important skill when working in IT is the ability to establish clear and workable IT policies. Policies must be well thought-out, to avoid potential problems, and also clearly explained to workers so there is no misunderstanding of the policies. Your assignment is to create a manual of IT policies for a small business. For each section of the manual, use your critical thinking skills to determine the best policy, and then explain the policy clearly and concisely. The audience is company employees who use computers as part of their jobs, including warehouse workers, office workers, and salespeople. The details of the business for which you will be proposing policies is as follows: The company's name is ACME Commercial Kitchen Supply. The company's business is to sell and support commercial kitchen equipment. The company has about 400 users, 50 of which travel at least half of the time. The IT staff consists of 4 full-time employees. All employees work out of a single building. The IT department maintains a client/server LAN that runs on Windows Server, which includes an Exchange mail server, and a Sharepoint server for internal data sharing, plus several file servers for individual departments. The Accounting, Sales, and Shipping departments share a proprietary, custom-built application that tracks and bills customer orders. If you need any additional information about this company to complete the assignment, please e-mail me and I will provide it.The manual should have the following sections: User Authentication: What are the rules regarding password strength and password changes? (For example, how often must users change their passwords?)3rd party software: What are the rules for employees loading their own private software on their work PCs, such as games, personal finance software, and so on?Computer use during business hours: What are the rules for employees checking personal email and social networking sites during...

CSU BHR3352 Unit 7 Article Critique

CSU BHR3352 Unit 7 Article Critique

Unit VII Article Critique

Use the CSU Online Library to locate and review a scholarly article found in a peer reviewed journal related to: Unions,

Labor Relations, or International Human Resources Management.

There is a minimum requirement of 500 words for the article critique.

? Write your critique in APA format.

? Begin with an introduction that defines the subject of your critique and your point of view. You will first need to

identify and explain the author's ideas. Include specific passages that support your description of the author's

point of view.

? Defend your point of view by raising specific issues or aspects of the argument. Offer your own opinion.

Explain what you think about the argument. Describe several points with which you agree or disagree.

? Explain how the passages support your opinion.

? Conclude your critique by summarizing your argument and re-emphasizing your opinion.

? For each of the points you mention, include specific passages from the text (you may summarize, quote, or

paraphrase) that provide evidence for your point of view.

Write a Movie Review: Louder Than a Bomb Film Analysis

Write a Movie Review: Louder Than a Bomb Film Analysis

Write a Movie Review: Louder Than a Bomb Film Analysis

1.	“Looking at” means what you perceive in the film. “Looking into” means what was done to encourage you to have those perceptions. For this assignment, your work will focus on a specific person or team in the film. “Looking at” for this assignment means stating your perceptions of the person or the team. “Looking at” for this assignment includes noticing short selection, setting, interactions with the other people, clothing, what is said about a a person by other people, how other people respond to person – all the decisions that the director makes to tell the story in the way that he or she wants to tell it.
2.	Your assignment for this paper is as follows:
a.	Get into your discussion groups from the previous class
b.	Choose one of the four main characters 
i.	Nate
ii.	Adam
iii.	Nova
iv.	The Steimenauts (the team)
3.	As you watch the film, what are you learning about the person or team who you are watching? How are you learning it?


MECHANICS¡ª3O POINTS POSSIBLE

1.25-30: Grammar, usage, punctuation, sentence structure do not interfere with the reader¡¯s understanding.

2.  20-25: only one or two problems in these areas

3. 15-20: more than three problems

4. 0-15: A significant difficulty in any of these areas interferes with the reader¡¯s ability to understand what is being said, or the point that the writer is attempting to make.

ORGANIZATION¡ª30 POINTS POSSIBLE

25-30: Form and logical sequence of ideas is easy to follow and makes sense. The idea or argument is clearly developed.
20-25: Organization is good, but the flow may not be entirely clear or some steps in the argument seem to be missing.
15-20: There is a focus to the paper, but the idea or argument is either trite or not clearly developed.
0-15: The organization interferes with the reader¡¯s ability to understand the writer¡¯s ideas.
CONTENT¡ª40 POINTS POSSIBLE

35-40: Creative and clearly stated idea/argument that represents careful thought/analysis.
30-35: Creative and clearly stated, but minor flaws in reasoning or assumptions.
25-30: Perhaps no new ideas, but fairly clearly stated.  Can have some flaws in reasoning or assumptions.
0-25: Little or no apparent effort to engage the topic.  Little or no thought evident, major flaws in reasoning or assumptions.

OPRE 3333 Homework 5 Assignment (Fall 2014) Solution…………………………………………….

OPRE 3333 Homework 5 Assignment (Fall 2014) Solution…………………………………………….

Use Decision Trees and the EV criteria to answer the questions presented after each of the following problem descriptions. There are 120 points available on this assignment.

Problem Statement
Radio Schlock is considering the production of a new consumer product with a five-year product lifetime. A new production facility for this upcoming product will be required. Management must decide whether to build a large facility at an estimated cost of $1,000,000 or a smaller facility for an estimated $600,000.
Preliminary market research indicates as 65% chance of high demand for the product.
High demand for the product is expected to result in a $400,000 per year positive cash flow from a large facility or a $150,000 per year positive cash flow from a smaller facility.
Low demand for the product is expected to result in a $50,000 per year positive cash flow from a smaller facility or a $50,000 per year loss from a large facility. A third option has been suggested: delay the decision while further product development is carried out. If the results of this product development are
favorable, Marketing estimates there is a 90% chance of high demand for the product. In the event of unfavorable results, Marketing estimates there is a 40% chance of high demand. If Management chooses to pursue this additional product development one year’s sales will be lost, although cash flows will otherwise be the same as if the production facility had been built immediately.
If the results of the further product development are unfavorable, Management has the option of shelving the project. It is assumed that there is a 50% chance of favorable results from the further product development.
Use the total, undiscounted, cash flow in all calculations rather than NPV.
Be prepared to answer the questions in the eLearning assessment.
Question 1(a) What is the EV for the Large production facility?
10 points Question 2(b) What is the EV for the Small production facility?
10 points Question 3(c) What is the EV for further product Development?
10 points Question 4(d) Which option should be chosen? Small. Large. Development.10 points Question 5(e) If results of further product development are favorable, what is the overall project EV at that point?
10 points Question 6(f) If results of further product development are favorable, what is the EV for the large production facility at that point?
10 points Question 7(g) If results of further product development are favorable, what is the EV for the smaller production facility at that point?
10 points Question 8(h) If results of further product development are unfavorable, what is the overall project EV at that point?
10 points Question 9(i) If results of further product development are unfavorable, what is the EV for the large production facility at that point?
10 points Question 10(j) If results of further product development are unfavorable, what is the EV for the smaller production facility at that point?
10 points Question 11(k) If results of further product development are unfavorable, what is the EV for the shelved project at that point?
10 points Question 12(l) What is the probability value of a Favorable outcome for Development necessary for indifference between the Large option and the Developement option? (List the value or type -1)
10 points Question 13(m) Going from Development through Favorable outcome and through facility size to Demand (High or Low), what is the probability value of High Demand necessary for indifference between the Large option and the Development option? (List the value or type -1)
10 points Save and Submit

Quality Assurance for System Integration – Discussion Board Week 3

Quality Assurance for System Integration – Discussion Board Week 3

Assignment Guidelines
For this Discussion Board assignment, you should use the library and course materials to complete the following:

    Research quality assurance considerations for system integration choices (starting with your nonfunctional requirements).
    Compile a list of 5–7 quality assurance categories, and discuss how they will be evaluated in the capstone project.
    Provide details about evaluation methods that could be utilized to assure quality.
    Select and discuss why 1 of these methods will best support quality assurance for your integration project. 

Post a new topic to the Discussion Board that contains your responses from the steps listed above

saint mgt320 assignment 4

saint mgt320 assignment 4

Assignment 4

For this assignment, please answer these questions:

1. Why is it important for entrepreneurs to develop financial plans for their companies?

2. How should a small business manager use the ratios discussed in this chapter?

3. Outline the key points of the 12 ratios discussed in this chapter. What signals does each give a business owner?

Complete it in a Microsoft Word Document and submit it via the Dropbox.

Be sure to include your name on the top of the document. Submit the assignmentno later than Sunday 11:59 PM EST/EDT. (This Dropbox basket is linked to Turnitin.)