818 excel comprehensive problem: abc corporation is a new company

ABC Corporation is a new company that buys and sells office supplies.  Business began on January 1, 2015.

Given on the first two tabs are ABC’s 12/31/15 Unadjusted Trial Balance and a list of needed adjustments.

1.  Make all 12 adjustments on the “Adjusting Journal Entries” tab.  Remember to include a description under each journal entry.
 
2.  Post the adjustments to the general ledger on the “12-31-15 T-Accounts” tab.  You may have to add T-Accounts for new accounts.
    Link your T-Account entries to your Journal Entries.  PLEASE NOTE THAT THE “BB” (BEGINNING BALANCES) FOR THE 
    T-ACCOUNTS REPRESENT THE BALANCES AS OF 12/31/15.  
 
3.  Once the 12/31/15 T-Accounts are complete, prepare the Adjusted Trial Balance.  There may be some accounts with zero dollars, and you
     may have to insert lines for new accounts.  Link the Adjusted Trial Balance to your T-Accounts.
 
4.  Use the Adjusted Trial Balance numbers to complete the Income Statement, Statement of Retained Earnings, and Balance Sheet.
     For purposes of the Income Statement, prepare using the multiple step format and assume that Rent Revenue, any Unrealized Holding Gains/Losses,
     Interest Expense, Interest Revenue, and any other Gains/Losses are NOT part of the major central ongoing operations of the company.  For purposes
     of the Balance Sheet, be sure to prepare a classifed Balance Sheet.  Link your financial statements to your Adjusted Trial Balance.  
     If necessary, review financial statement preparation in Chapters 4 and 5 of your textbook for a quick refresher.  
 
5.  When the Financial Statements are complete, make the closing entries on the “Closing Entries” tab.
 
6.  When closing entries have been made, post the entries to the general ledger on the “Post-Close T-Accounts” tab.  Make sure your adjusting
     journal entries are also on your Post-Close T-Accounts.  They will not automatically flow from tab-to-tab. (Helpful hint:  After you have completed
     and posted all of your adjusting entries, make a duplicate copy of your “12-31-15 T-Accounts” tab to replace the existing blank 
    “Post-Close T Accounts” tab by right clicking on the completed “12-31-15 T-Accounts” tab, select Move or Copy,
     then click on “Create a Copy” and then place at the desired location.  You can then delete the original “Post-Close T-Accounts” tab and rename the
     newly duplicated tab as your “Post-Close T-Accounts” tab).
 
7.  The final step is the Post-Closing Trial Balance, which will use the ending balances from the Post-Close T-Accounts.
 
                      8.  Double-check your work.  Here are a few things to check for:  
-Adjusted Trial Balance:  Make sure debit column and credit column total to the same figure at the bottom.
-Net income from the income statement will flow through to the Statement of Retained Earnings.
-Ending Retained Earnings from the Statement of Retained Earnings will flow through to the Balance Sheet.
-The Post-Closing Trial Balance should not have any revenue, expense, gain, or loss (temporary) accounts.
-Check figure 1:  Gross profit = $573,000.
-Check figure 2:  Income before income taxes = $345,266.
-Check figure 3:  Total Liabilities and Stockholders’ Equity = $1,298,480.
-Check figure 4:  Adjusted Trial Balance debit and credit columns total $2,010,321.
-Check figure 5:  Total Current Assets = $1,145,045.
-Remember:  Neatness matters in Financial Statements.  Print or Print Preview before submitting to make sure your statements are neat.
 Otherwise, management may send back to you for revision!
-Include your work at the bottom of each tab as needed.
-Ask questions prior to the day/night before the due date.  The due date is clearly indicated on the course schedule.
-Utilize formulas and worksheet linkings in your financial statements to improve accuracy and save time in completing the assignment.
-Please take advantage of Excel by using formulas to calculate groups of numbers (i.e. “Total Liabilities and Stockholders’ Equity”).
-DO NOT force any cells to match check figures given.  Any adjustments in the T-Accounts or financial statements not supported by 
 legitimate adjusting or closing entries will be considered financial statement misrepresentation sufficient to result in a failing grade.
 
Final comments:  This project is intended to make sure that you understand the accounting cycle as well as several key financial accounting transactions that you have
studied during your Intermediate Accounting series.  It is very important to take the necessary time on this project to master these concepts.  The concepts mastered in this
comprehensive problem will serve you well in the rest of your accounting curriculum.
Please review the grading rubric tab as you start work on the assignment to make sure that you understand how your work will be evaluated.
ABC Corporation
Unadjusted Trial Balance
December 31, 2015
     
Particulars Debit Credit
Cash                707,650.00  
Accounts receivable                357,120.00  
Allowance for doubtful accounts    
Inventory    
Allowance to Reduce Inventory to Market Value                              –  
Purchases                267,000.00  
Prepaid insurance                    8,250.00  
Land                  88,000.00  
Building                  37,500.00  
Accumulated depreciation: building                      1,150.00
Equipment                  21,600.00  
Accumulated depreciation: equipment                      9,000.00
Patent                  20,000.00  
Accounts payable                    40,750.00
Notes payable                    40,000.00
Income taxes payable                    88,000.00
Unearned rent revenue                    15,000.00
Bonds Payable                  700,000.00
Discount on Bonds Payable                  51,520.00  
Common stock                  125,000.00
PIC In Excess of Par-Common Stock                    40,000.00
Retained earnings    
Treasury stock                  20,000.00  
Dividends                  28,000.00  
Sales Revenue                  790,000.00
Advertising expense                    9,240.00  
Wages expense                  62,150.00  
Office expense                  14,370.00  
Depreciation expense                  10,150.00  
Utilities expense                  33,600.00  
Insurance expense                  24,750.00  
Income taxes expense                  88,000.00  
Total             1,848,900.00

            1,848,900.00

 

 

1 On March 1, ABC purchased a one-year liability insurance policy for $33,000.  
  Upon purchase, the following journal entry was made:    
    Dr Prepaid insurance   33,000    
      Cr Cash     33,000  
  The expired portion of insurance must be recorded as of 12/31/15.  
  Notice that the expired portion from March through November has been recorded already.
  Make sure that the Prepaid Insurance balance after the adjusting entry is correct.  
               
               
2 Depreciation expense must be recorded for the month of December.  
  The building was purchased on February 1, 2015 for $37,500 with a remaining useful life of 25 years and a salvage value of $3,000.  
    The method of depreciation for the building is straight-line.    
  The equipment was purchased on February 1, 2015 for $21,600 with a remaining useful life of 4 years and a salvage value of $1,800. 
    The method of depreciation for the equipment is double-declining balance.
  Depreciation has been recorded for the building and equipment for months February through November.
               
               
3 On December 1, XYZ Co. agreed to rent space in ABC’s building for $5,000 per month,
  and XYZ paid ABC on December 1 in advance for the first three months’ rent.  
  The entry made on December 1 was as follows:      
    Dr Cash     15,000    
      Cr Unearned rent revenue   15,000  
  The unearned revenue account must be adjusted to reflect the amount earned as of 12/31/15.
               
               
4 Per timecards, from the last payroll date through December 31, 2015, ABC’s employees have worked a total of 275 hours.
  Including payroll taxes, ABC’s wage expense averages about $21 per hour.  The next payroll date is January 5, 2016.
  The liability for wages payable must be recorded as of 12/31/15.    
               
               
5 On November 30, 2015, ABC borrowed $40,000 from American National Bank by issuing an interest-bearing note payable.
  This loan is to be repaid in three months (on February 28, 2016), along with interest computed at an annual rate of 9%.  
  The entry made on November 30 to record the borrowing was:    
    Dr Cash     40,000    
      Cr Notes payable   40,000  
  On February 28, 2016 ABC must pay the bank the amount borrowed plus interest.  
  Assume the beginning balance for Notes Payable is correct.    
  Interest through 12/31/15 must be accrued on the $20,000 note.    
               
               
6 ABC uses a periodic inventory system, and the ending inventory for each year is determined by taking a complete
  physical inventory at year-end.  A physical count was taken on December 31, 2015, and the inventory on-hand at
  that time totaled $50,000, which reflects historical cost.  A review of inventory data further indicated that current 
  replacement value of the ending inventory is $45,000, the retail sales value of the ending inventory is $182,000, estimated
  cost of completion and disposal is 72.5% of retail, and normal profit margin is 1.25% of retail value.
  Record the adjusting entry for properly recognizing 2015 Cost of Goods Sold.  
               
  Additionally, ABC adheres to GAAP by recording ending inventory at the lower of cost or market at a total inventory level.
  Be sure to make an additional adjustment, if necessary, to properly value ending inventory using the Loss and Allowance methodology.
               
               
7 It would be unusual for a company to have an asset impairment in Year 1, but for the sake of this example, ABC realized
  that their intangible asset might be impaired on December 31, 2015.  Record the impairment if any.
  The expected future undiscounted net cash flows for this intangible asset totals $15,000, and the fair value of the asset is $17,500.
               
               
8 On 7/1/15, ABC purchased 4,000 shares of its own stock from existing stockholders as treasury stock.  The cost of the treasury 
  stock was $5 per share, or $20,000 in total.  The effects of this transaction are already shown in the unadjusted trial balance.  On 12/31/15,
  ABC reissued 2,000 shares of the treasury stock at $8 per share.  Record the journal entry required for the reissuance of the treasury stock. 
               
               
9 On 12/31/15, ABC issued 9,000 shares of $3 par value common stock at the closing market price of $4 per share.  Prepare ABC’s journal entry
   to reflect the issuance of the stock on 12/31/15.      
               
               
10 On 7/1/15, ABC sold 10% bonds having a maturity value of $700,000 for $648,480, resulting in an effective yield of 12%.  The bonds are
  dated 7/1/15, and mature 7/1/20.  Interest is payable semiannually on July 1 and January 1.  ABC uses the effective interest method of 
  amortization for bond premium or discount.  Record the adjusting entry for the accrual of interest and the related amortization on 12/31/15.
  Hint:  Develop an abbreviated amortization schedule to accurately determine the interest expense.
               
               
11 ABC Corporation prepares an aging schedule on 12/31/15 that estimates total uncollectible accounts at $25,000.  Assuming that the allowance method is used,
  prepare the entry to record bad debt expense.      
               
               
  Do this step after preparing the Income Statement except for the Income taxes line:  
12 Corporate taxes are due in four estimated quarterly payments on April 15, June 15, September 15, and December 15.  
  However, for the purposes of this ABC illustration, we will assume that estimates are not paid, and that the tax is paid in full 
  on the return’s March 15, 2016 due date.      
  ABC’s income tax rate is 40%.  The entire year’s income tax expense was estimated at the beginning of 2015 to be $96,000,
  so January through November income tax expense recognized amounts to $88,000 (11/12 months).
  Since we are assuming estimates are not made during the year, the balance in Income taxes payable represents
  income tax accrued for January through November.  Assume no deferred tax assets or deferred tax liabilities.
  Based on the income before income taxes figure from the income statement, record December’s income tax expense  
  so that the entire year’s tax expense is correct (i.e. the difference between total income tax expense and the amount already accrued through November).
                             
                             
Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Custom Writings Help is a Quality-Oriented Company in Online Writing as a result of hiring exceptional professionals to execute clients' tasks.

Essays

Research Papers

At Custom Writings Help,We understand the struggle of research paper writing, and that is why at Custom WritingS Help, we are all out to help you. We pride ourselves on having a team of clinical writers. The stringent and rigorous vetting process ensures that only the 'BEST' Writers are chosen for the job. We have highly qualified Ph.D. and MA writers working with us; we equally offer these experienced writers specific bonuses and incentives to make them deliver highly original, unique, and informative content at reasonably low prices.

Admissions

Thesis Writing Service

Worlwide, Many Masters Students are struggling with Thesis Completion. A thesis is likely to be the longest and most challenging piece of work a student has ever completed. However, unlike essays and other assignments, a student can pick a particular interest topic and work on their initiative. Fortunately, we are there for you. At Custom Writings Help, you are assured of an authentic, imaginative, informative, linguistically great, and advantageous thesis that adheres to all your needs. So, why continue considering different writers when you have discovered the best in the field?

Editing

Custom Papers

Not a single student can avoid writing custom papers. However, a total lack of experience, skills, and time makes it very hard to produce a superb writing piece. Therefore, if you are seeking professional help, turn to us. Our specialized and experienced writers compose a variety of model papers, including custom essays, college term papers, research papers, book reports, MBA essays, executive summaries, dissertations, Ph.D. theses, admission essays, and research proposals for college and university students at any level.

Coursework

Essay Writing

Most of the students disregard the critical principles of essay writing and compose papers below sensible guidelines. Therefore, with Custom Writings Help, one should not worry about his/her essay. Our Writers compose informative and engaging content on all complexities and topics. We write meaningful and smart essays while prioritizing all aspects that bring about a good grade, such as impeccable grammar, proper structure, zero-plagiarism, and conformance to guidelines.

Coursework

Coourse Work Writing

Don't let the seemingly never-ending onslaught of writing assignments get you down. If you are looking where to get course work assistance online, the writers at Custom Writings Help are here to assist you with all of your writing needs. We undertake to unique delivery of papers that meet the professor's requirements. The content is proofread, edited, and checked plagiarism before submission to customers. No matter how big or small your work is, we will deliver on time. Try US Now! !

Coursework

Dissertation Writing Service

High-Quality Dissertation Writing Services are rare. They require Ph.D. academicians – not easily found. However, are an exception. The years, time, and resources we have invested in the dissertation world has given us a competitive advantage over others. Choose to come to Custom Writings Help; You will find perfect Ph.D. consultants who have written hundreds of dissertations theses ready to help you. Let our dissertation-writing services help you craft your dissertation, for you are assured we will give you the results.

See all services