Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hello I need help with my project. 1st I would like you to double check my work. Also I need some essentials question answered. ACCT120

hello I need help with my project. 1st I would like you to double check my work. Also I need some essentials question answered.

image text in transcribed ACCT120 - Accounting Principles II Project Directions and Rubric submissions This Assessment is worth 20% of your overall grade _____________________________________________________________________________________________ Completing this assessment will help you to meet the following outcomes: Course Outcomes: Interpret and apply Generally Accepted Accounting Principles (GAAP) to analyze, record, and report financial information including receivable and payable transactions for a merchandising business using computerization. Identify and calculate the value of basic notes and bonds payable transactions including time value of money. Compute and evaluate depreciation, amortization, and depletion methods and apply the methods to fixed and intangible assets. Examine appropriate acquisition and disposal of assets. Select and utilize appropriate technology to complete a real world accounting project that requires the construction of a multi-step income statement and classified balance sheet. Program Outcomes: Record and report financial information using Generally Accepted Accounting Principles (GAAP). Institutional Outcomes: Information Literacy and Communication: Utilize appropriate current technology and resources to locate and evaluate information needed to accomplish a goal, and then communicate findings in visual, written and/or oral formats. Relational Learning: Transfer knowledge, skills and behaviors acquired through formal and informal learning and life experiences to new situations. Thinking Abilities: Employ strategies for reflection on learning and practice in order to adjust learning processes for continual improvement. Community and Career: Participate in social, learning, and professional communities for personal and career growth. Deadlines Activities The end of Week 2 at 11:59 pm, ET Essential Question Discussion The end of Week 3 at 11:59 pm, ET Prepare a schedule that provides detail on the asset allocation with the purchase. The end of Week 5 at 11:59 pm, ET Prepare the journal entries for the adjustments. The end of Week 6 at 11:59 pm, ET Prepare the trial balance, income statement, balance sheet and statement of owner's equity. The end of Week 7 at 11:59 pm, ET Final submission of Project to ePortfolio Reflection Discussion The end of Week 7 at 11:59 pm, ET Scenario/Directions: San Antonio Outfitters is in the process of expanding business operations and increasing total annual revenue. The leadership team recognizes that this objective was quite challenging in the current business location and purchased land and constructed a state of the art facility; however the cost was more than originally anticipated. You are a newly hired Accounting Assistant for San Antonio Outfitters. Your manager has asked you to help develop the financial data for the decision makers to use for planning and determination if the right decisions have been made. Accurate analysis is critical to the success of this endeavor. Week 2: Essential Questions Discussion Essential questions are designed to help you brainstorm prompt critical thinking as you begin working on your project. Use the information you learned about essential questions in ACCT110 to help you respond to the following: Explain the importance of utilizing appropriate technology in accounting. What are the differences between appropriate acquisition and disposal of assets? Now that you had the opportunity to address these essential questions, create at least one of your own that will further help you with the completion of your project. Respond to at least three of your classmates' initial post with constructive feedback. Project Excel Spreadsheet template and San Antonio Outfitters Financial Information for weeks 3, 5, and 6: Make sure you upload/submit your template in Blackboard for each week it is due. San Antonio Outfitters.pdf ACCT 120 Portfolio Project Template.xls Week 3: Prepare a Schedule Create a schedule that outlines the total spend for San Antonio on the construction expenses. Develop a schedule that shows initial values of the various assets that San Antonio acquired or constructed during 2013. The company uses the specific interest method to determine the amount of interest capitalized on the building construction. Develop a schedule that shows the total interest expense that San Antonio will need to show for 2013 as it relates to construction of the new facility. Week 5: Journal Entries Prepare the all associated journal entries using double entry accounting methods. Your debits and credits should equal and the entries should have proper impact on the accounts that are being used. Prepare all required journal entries Adjust the account balances Week 6: Financial Information Prepare the adjusted Trial Balance, Income Statement, Statement of Owners Equity and Balance sheet. You should use the work completed in week 5 (worksheet or general journal accounts) to prepare your adjusted trial balance, which should equal whereas debits equal credits. You will then need to prepare the Income statement, where net income will be carried through to the statement of owners' equity as one of the adjustments to the final balance in the equity account. You will then need to prepare the Balance Sheet, where you will show the updated Owners Equity balance. Produce the Trial Balance, Income Statement, Statement of Owners Equity and Balance Sheet for San Antonio for 2013. Week 7: Final Submission Use the feedback from your instructor to update the submission from weeks 3, 5, and 6. Upload your final version to the appropriate program outcome in your ePortfolio: (AAS ACCT) Interpret and apply generally accepted accounting principles (GAAP) to analyze, record, and report financial information. (BBA ACCT) Apply contemporary knowledge and skill sets to work effectively in the business community. Week 7: Reflection Discussion This discussion is designed to give you an opportunity to reflect on your progress to completion of the project. It further helps you identify how it directly relates to a career in accounting by identifying relevant workplace capabilities that you have gained during this assessment. Directions: In your initial post, answer the following questions: Reflect on what you learned and how the knowledge helped you with the understanding of the course, program, and institutional outcomes. The workplace capability specifically identified for this course is communication. Summarize how you feel communication was addressed in this course and why it is important for this project. Respond to at least three of your classmates' initial post with constructive feedback. ACCT120 - Project Grading Rubric Criteria Financial Data 80 Points Formatting & Mechanics 20 Points Instructor Comments: Exceeds Expectations 72-80 points Flawlessly submitted without any account errors: Prepared and submitted allocation of assets. Completed the journal entries in proper format. Completed Financial Statements in proper format. These include Income Statement, Statement of Owner's Equity, and Classified Balance Sheet. Completed Post-Closing Trial Balance in proper format. Meets Expectations 56-71 points Submitted with zero to minor accounting errors: Prepared and submitted allocation of assets. Completed the journal entries in proper format. Completed Financial Statements in proper format. These include Income Statement, Statement of Owner's Equity, and Classified Balance Sheet. Completed Post-Closing Trial Balance in proper format. 18-20 points The Excel document is formatted properly. No grammar, punctuation, or spelling errors. 14-17 points The Excel document is formatted properly. One major or two minor grammar, punctuation, or spelling errors. Below Expectations 0-55 points Did not submit or missing a significant amount of data; numerous accounting errors. Student does not understand how to create financial statements. 0-13 points The Excel document is not formatted properly. Many errors; detract from the meaning of the project significantly. Total Points: Points Name San Antonio Outfitters Land Account 12/31/XXXX Totals Name General Journal GENERAL JOURNAL Date Account Titles and Explanation P. R. Debit Credit Name General Ledger GENERAL LEDGER Date Explanation DEBIT ACCOUNT NO. ____ CREDIT BALANCE Date Accounts Receivable Explanation P.R. DEBIT ACCOUNT NO. ____ CREDIT BALANCE Date Explanation Prepaid Insurance P.R. DEBIT ACCOUNT NO. ____ CREDIT BALANCE Explanation Office Equipment P.R. DEBIT ACCOUNT NO. ____ CREDIT BALANCE Accum Depreciation, Office Equipment Explanation P.R. DEBIT ACCOUNT NO. ____ CREDIT BALANCE Date Date Date Explanation Cash P.R. Inventory P.R. DEBIT ACCOUNT NO. ____ CREDIT BALANCE Name Worksheet San Antonio Outfitters Work Sheet For Month Ended December 31, 2013 Account Titles Cash Accounts Receivables Prepaid Insurance Office Equipments Furniture & Fixtures Accumulated Depreciation OE Inventory Building Land Land Improvements Accounts Payable Notes Payable Interest Payable San Antonio Capital San Antonio Withdrawls Revenue Wages Expense Depreciation Expenses OE Equipment Rental Expenses Office Supplies Expenses Advertising Expenses Repairs Expenses Interest Expenses Unadjusted Trial Balance Dr. Cr. 3,394,380 2,129,500 42,300 119,300 Adjustments Dr. Cr. 3,000,000 6,405,000 455,000 145,000 Adjusted Trial Balance Dr. -10,620 2,129,500 42,300 574,300 145,000 11,750 2,104,000 100,000 720,000 Cr. Income Statement Dr. Cr. 11,750 5,473,512 100,000 505,000 104,410 600,000 2,104,000 5,473,512 720,000 505,000 104,410 3,600,000 180,658 2,541,700 3,000,000 180,658 2,541,700 10,450 10,450 6,144,100 6,144,100 654,500 4,250 71,410 7,500 32,400 11,970 107,145 654,500 4,250 71,410 7,500 32,400 11,970 107,145 6,144,100 654,500 4,250 71,410 7,500 32,400 11,970 107,145 9,401,960 9,401,960 9,685,657 9,685,658 12,582,617 12,582,618 Net Income Difference in rounding off 1 889,175 6,144,100 5,254,925 6,144,100 6,144,100 Balance Sheet & Statement of Owner's Equity Dr. Cr. -10,620 2,129,500 42,300 574,300 145,000 11,750 2,104,000 5,473,512 720,000 505,000 104,410 3,600,000 180,658 7,786,175 11,682,992 11,682,992 0 Name Income Statement San Antonio Outfitters Income Statement For Year Ended December 31, XXXX Revenue Expenses: Wages Expense Depreciation Expenses OE Equipment Rental Expenses Office Supplies Expenses Advertising Expenses Repairs Expenses Interest Expenses Total Expenses Net Income $6,144,100 $654,500 $4,250 $71,410 $7,500 $32,400 $11,970 $107,145 889,175 $5,254,925 San Antonio Outfitters Statement of Changes in Owner's Equity For Year Ended December 31, XXXX Balance on April 1 Net Income Withdrawls Balance on Dec. 31 $2,541,700 5,254,925 10,450 7,786,175 San Antonio Outfitters Balance Sheet December 31, XXXX Name Post Closing Trial Balance San Antonio Outfitters Post-Closing Trial Balance 12/31/XXXX Debit Cash -$10,620 Accounts Receivables $2,129,500 Prepaid Insurance $42,300 Office Equipments $574,300 Furniture & Fixtures $145,000 Accumulated Depreciation OE Inventory 2,104,000 Building 5,473,512 Land 720,000 Land Improvements 505,000 Accounts Payable Notes Payable Interest Payable San Antonio Capital Totals $11,682,992 Credit $11,750 104,410 3,600,000 180,658 7,786,175 $11,682,992 Interest Payable on old notes Payable 36000 Interest Payable on new notes payable Interest to be capitalized 1200000 151 days 1500000 91 days 300000 59 days Interest expenses Total Interest expenses Total interest payable 144658 39715 29918 3879 73512 71145 107145 180658 6 30 31 31 30 31 30 31 1 31 31 30 30 30 29 29 29 30 31 220 151 91 59 Early in its fiscal year ending December 31, 2013, San Antonio Outfitters finalized plans to expand operations. The first stage was completed on April 25th with the purchase of a tract of land on the outskirts of the city. The land and existing building were purchased for $800,000. San Antonio paid $200,000 and signed a noninterest-bearing note requiring the company to pay the remaining $600,000 on March 28, 2015. An interest rate of 8% properly reflects the time value of money for this type of loan agreement. Title search, insurance, and other closing costs totaling $20,000 were paid at closing. Below is the trial balance for San Antonio Outfitters as of March 31. SAN ANTONIO OUTFITTERS Trial Balance March 31, 20XX Debit Cash .......................................................................................... $3,394,380 Accounts receivable ............................................................... 2,129,500 Prepaid insurance ................................................................... 42,300 Office equipment .................................................................... 119,300 Accumulated Depreciation, Office Equipment .................. Credit $11,750 Inventory ................................................................................. 2,104,000 Building ................................................................................... 100,000 Land.......................................................................................... 720,000 Accounts payable ................................................................... $ 104,410 Notes payable.......................................................................... 600,000 San Antonio, Capital .............................................................. 2,541,700 San Antonio, Withdrawals .................................................... 10,450 Revenue ................................................................................... 6,144,100 Wages expense ........................................................................ 654,500 Depreciation Expense, Office Equipment ........................... 4,250 Equipment rental expense ..................................................... 71,410 Office Supplies Expense ........................................................ 7,500 Advertising expense............................................................... 32,400 Repairs expense ...................................................................... 11,970 Totals ........................................................................................ $9,401,860 $9,401,860 During April, the old building was demolished at a cost of $70,000, and an additional $50,000 was paid to clear and grade the land. Construction of a new building began on May 1 and was completed on October 29. Construction expenditures were as follows: San Antonio borrowed $3,000,000 at 8% on May 25 to help finance construction. This loan, plus interest, will be paid in 2014. In November, the company purchased 10 identical pieces of equipment and office furniture and fixtures for a lump-sum price of $600,000 on account. The fair values of the equipment and the furniture and fixtures were $455,000 and $145,000, respectively. In December, San Antonio paid a contractor $285,000 for the construction of parking lots and for landscaping

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Karen Braun, Linda S Bamber

2nd Edition

136091164, 978-0136091165

More Books

Students also viewed these Accounting questions

Question

3. Im trying to point out what we need to do to make this happen

Answered: 1 week ago

Question

1. I try to create an image of the message

Answered: 1 week ago