Hello tutor. I am having trouble calculating the correct depreciation expense for 2012. There is a narrative to accompanyt the project as well as a practice problem template . I have come close. I have the correct answer. I tried it with the MACRS table which is the way my Professor demonstrated in class. I will upload the excel workbook as well as the narrative. He purposely includes some information that is irrelevant. I know he said the fact that the contributed property was not put into use until Feb. 1, but the company incorporated on Jan. 1st was key piece of info. My calculations are in sheet titled "Part II". The instructions are as follows. We use the "Book Depreciation" sheet from the practice project as a template, but with the info from the "Book Depreciation" and "Fixed assets" from the "Excel Schedules" workbook.

I understand it may take a while to sort through the narrative, but I know most of my classmates said they were overthinking it. I only took my Prof. about 10 minutes to demonstrate in class. He wants us to be able to throw out irrelevant info. Do we include contributed depreciation or not? A little confused. We have been using the half-year MACRS tax table. That is where I got the percentages. I hope to find out where I went wrong.

Regards,

Gabrielle

AST RECORDS GAAP BASED TRIAL BALANCE AS OF DECEMBER 31, 2012 CASH INVESTMENTS, AT FMV ACCOUNTS RECEIVABLE ALLOWANCE FOR DOUBTFUL ACCOUNTS INVENTORY INVENTORY RESERVE COMPUTERS - CONTRIBUTED COMPUTERS - PURCHASED MACHINERY - CONTRIBUTED MACHINERY - PURCHASED SOFTWARE - PURCHASED OTHER EQUIPMENT - PURCHASED ACCUMULATED DEPRECIATION - COMPUTERS CONTRIBUTED ACCUMULATED DEPRECIATION - COMPUTERS PURCHASED ACCUMULATED DEPRECIATION - MACHINERY CONTRIBUTED ACCUMULATED DEPRECIATION - MACHINERY PURCHASED ACCUMULATED DEPRECIATION - OTHER EQUIPMENT PURCHASED ACCUMULATED DEPRECIATION - SOFTWARE PURCHASED INTANGIBLES EQUITY INVESTMENT IN DAVECO WAGES PAYABLE - EMPLOYEES WAGES PAYABLE - SIMON WAGES PAYABLE - THEODORE WAGES PAYABLE - ALVIN WITHHOLDING TAXES PAYABLE ACCRUED PAYROLL TAXES ACCRUED VACATION PAYABLE ACCRUED WARRANTY ALLOWANCE FOR SALES RETURNS ACCRUED RENTAL ACCOUNTS PAYABLE DEBT DEFERRED REVENUE FEDERAL INCOME TAXES PAYABLE NOTES PAYABLE OWNERS CONTRIBUTIONS DISTRIBUTIONS TO OWNERS OTHER COMPREHENSIVE INCOME - INVESTMENTS RETAINED EARNINGS GROSS SALES SALES RETURNS INCOME FROM EQUITY METHOD INVESTMENT COST OF GOODS SOLD (GAIN)/LOSS ON SALE OF FIXED ASSETS (GAIN)/LOSS ON SALE OF INVESTMENTS INTEREST INCOME DIVIDEND INCOME FROM INVESTMENTS INTEREST EXPENSE MEALS & ENTERTAINMENT PENALTY EXPENSE PROPERTY TAX EXPENSE PAYROLL TAX EXPENSE REPAIR EXPENSE ADVERTISING EXPENSE RENT EXPENSE OFFICER LIFE INSURANCE PREMIUM EXPENSE BAD DEBT EXPENSE ACCOUNTING FEES LEGAL FEES FEES PAID TO ALVIN WARRANTY EXPENSE INSURANCE EXPENSE DEPRECIATION EXPENSE VACATION EXPENSE WAGES EXPENSE FEDERAL TAX EXPENSE 2,614,652 3,685,950 225,000 (10,600) 576,550 (24,000) 36,000 175,000 8,000,000 250,000 1,000,000 (23,000) (26,736) (428,571) (38,194) (75,000) 495,000 (24,000) (6,000) (4,000) (5,000) (12,500) (5,850) (75,600) (73,459) (12,450) (9,000) (64,500) (900,000) (55,600) (1,636,381) (9,000,000) (1,685,257) 1,000,000 (685,950) (11,500,325) 95,460 (90,000) 4,500,757 115,476 (70,000) (127,560) (157,980) 336,000 25,000 1,500 95,800 64,350 32,540 110,450 99,000 3,250 15,600 12,500 3,500 75,000 73,459 32,456 906,883 105,000 429,000 1,636,381 - AST RECORDS BOOK DEPRECIATION EXPENSE FY 2012 ACQUISITION DATE COMPUTERS - CONTRIBUTED COMPUTERS - PURCHASED MACHINERY - CONTRIBUTED MACHINERY - PURCHASED SOFTWARE - PURCHASED OTHER EQUIPMENT - PURCHASED 2/1/12 7/15/12 2/1/12 8/15/12 7/15/12 8/15/12 BOOK LIFE BOOK METHOD 3 3 7 7 3 5 S/L S/L S/L S/L S/L S/L BASIS FOR DEPRECIATION 36,000 175,000 2,500,000 8,000,000 250,000 1,000,000 ANNUALIZED FY 12 BOOK DEPR. EXPENSE 12,000 58,333 357,143 1,142,857 83,333 200,000 ACTUAL MONTHS 11.0 5.5 11.0 4.5 5.5 4.5 ACTUAL FY 12 BOOK DEPR EXPENSE 11,000 26,736 327,381 428,571 38,194 75,000 906,883 BEGINNING ACCUM DEPREC. 12,000 357,143 - YEAR END ACCUM DEPREC. 23,000 26,736 684,524 428,571 38,194 75,000 1,276,026 LESS: SALE TRANSACTION (684,524) - FINAL YEAR END ACCUM DEPREC. 23,000 26,736 428,571 38,194 75,000 591,502 AST RECORDS BOOK DEPRECIATION EXPENSE FY 2012 ACQUISITION DATE BOOK LIFE BOOK METHOD MACHINERY - CONTRIBUTED COMPUTERS - CONTRIBUTED 2/1/12 2/1/12 7 3 COMPUTERS - PURCHASED MACHINERY - PURCHASED SOFTWARE - PURCHASED 7/15/12 8/15/12 7/15/12 OTHER EQUIPMENT - PURCHASED 8/15/12 (Straight-Line) ACQUISITION DATE BASIS FOR DEPRECIATION 2,500,000 36,000 3 7 3 MACRS MACRS MACRS MACRS MACRS MACRS 5 MACRS 1,000,000 BOOK LIFE BOOK METHOD 2,291,667 33,000 175,000 8,000,000 250,000 BASIS FOR DEPRECIATION MACHINERY - CONTRIBUTED COMPUTERS - CONTRIBUTED 2/1/12 2/1/12 7 3 S/L S/L 2,500,000 36,000 COMPUTERS - PURCHASED MACHINERY - PURCHASED SOFTWARE - PURCHASED OTHER EQUIPMENT - PURCHASED 7/15/12 8/15/12 7/15/12 8/15/12 3 7 3 5 S/L S/L S/L S/L 175,000 8,000,000 250,000 1,000,000 2,291,667 33,000 BONUS 87,500 4,000,000 125,000 500,000 4,712,500 BONUS REMAINING BASIS % MACRS 14.29% 33.33% 357,250.00 11,999 87,500 33.33% 4,000,000 14.29% 125,000 S/L 29,164 571,600 41,667 500,000 REMAINING BASIS 20.00% 100,000 742,430 Correct answer 327,479.17 10,998.90 5,454,930 5,393,883 S/L 327,479.17 10,998.90 87,500 4,000,000 125,000 500,000 4,712,500 87,500 4,000,000 125,000 500,000 29,167 571,429 41,667 100,000 742,262 5,454,762 5,393,883 AST RECORDS ASSETS CONTRIBUTED TO FORM AST RECORDS FY 2012 ------------FROM SIMON--------------- ------------FROM THEODORE---------------------FROM ALVIN--------------FMV TAX BASIS FMV TAX BASIS FMV TAX BASIS CASH INVESTMENT A ACCOUNTS RECEIVABLE INVENTORY MACHINERY TAX ACCUMULATED DEPRECIATION COMPUTERS TAX ACCUMULATED DEPRECIATION INTANGIBLE ASSETS 75,000 125,000 125,000 65,000 1,750,000 400,000 75,000 100,000 125,000 40,000 2,500,000 (2,500,000) - 60,000 60,000 75,000 ### 35,000 25,000 36,000 (36,000) - 300,000 SERVICES TOTAL CONTRIBUTED DEBT NET CONTRIBUTED ASSETS CONTRIBUTED WITHOUT DEPR BOOK DEPR NET ASSETS CONTRIBUTED BOOK 5,000 75,000 2,540,000 340,000 (900,000) (900,000) 1,640,000 (560,000) 500,000 500,000 95,000 95,000 1,940,000 131,000 (357,143) (12,000) 1,582,857 - 119,000 80,000 80,000 5,000 - 5,000 5,000 5,000 - 5,000 1,706,857 AST RECORDS SALES OF FIXED ASSETS FY 2012 SALE IS ON DECEMBER 31 SALE IS FROM THE CONTRIBUTED MACHINERY ACCOUNT SALES PRICE 1,700,000 BASIS SOLD 2,500,000 BOOK ACCUMULATED DEPRECIATION NET BOOK BASIS BOOK LOSS ON SALE (684,524) 1,815,476 (115,476) WTF ENTERPRISES ASSETS CONTRIBUTED TO FORM WTF ENTERPRISES FY 2012 ------------FROM WARREN--------------------------------FMV TAX BASIS BOOK BASIS CASH ACCOUNTS RECEIVABLE ALLOWANCE FOR DOUBTFUL ACCOUNTS INVENTORY MACHINERY - SEE DETAILS INTANGIBLE ASSETS 2,000,000 750,000 (50,000) 450,000 4,500,000 3,700,000 2,000,000 750,000 450,000 1,956,600 - 2,000,000 750,000 (50,000) 450,000 6,768,512 - ------------FROM TIM--------------------------------FMV TAX BASIS BOOK BASIS 2,310,000 400,000 (10,000) 300,000 1,500,000 2,310,000 400,000 234,915 - 2,310,000 400,000 (100,000) 584,087 - FUTURE SERVICES FROM FRANK CURRENT SERVICES TOTAL "CONTRIBUTED" DEBT NET CONTRIBUTED PERCENTAGE OWNERSHIP BASED UPON CONTRIBUTED FAIR MARKET VALUE ------------FROM FRANK---------------------------FMV TAX BASIS BOOK BASIS 500,000 - 1,000,000 - ------------THE LAWYERS--------------------------FMV TAX BASIS BOOK BASIS 516,667 - 4,310,000 1,150,000 (60,000) 450,000 5,300,000 5,200,000 1,000,000 150,000 150,000 11,350,000 5,156,600 9,918,512 (2,500,000) (2,500,000) (2,500,000) 8,850,000 2,656,600 7,418,512 59.00% 4,500,000 4,500,000 30.00% 2,944,915 2,944,915 3,194,087 3,194,087 1,500,000 1,500,000 10.00% - 516,667 150,000 - - - 516,667 150,000 1.00% ------------------GRAND TOTALS-----------------------------FMV TAX BASIS BOOK BASIS - - 4,310,000 1,150,000 450,000 2,191,515 - 4,310,000 1,150,000 (150,000) 450,000 7,869,266 - 17,500,000 8,101,515 13,629,266 (2,500,000) (2,500,000) (2,500,000) 15,000,000 5,601,515 11,129,266 100.00% WTF ENTERPRISES ACCUMULATED DEPRECIATION ON CONTRIBUTED ASSETS FY 2012 ` BOOK ORIGINAL COST ACQUISITION DATE (in months) BOOK LIFE BOOK METHOD MONTHLY DEPRECIATION (as of 1/1/12) MONTHS OWNED ACCUMULATED DEPRECIATION NBV FY 2012 DEPRECIATION WARREN'S ASSETS: PRINTING PRESS EQUIPMENT OTHER EQUIPMENT COMPUTERS FURNITURE DELIVERY TRUCKS 6,000,000 1,250,000 500,000 400,000 300,000 TOTAL 8,450,000 1/1/10 2/15/11 6/30/10 5/15/11 9/30/10 120 84 36 120 84 S/L S/L S/L S/L S/L 50,000 14,881 13,889 3,333 3,571 24.0 10.5 18.0 6.5 15.0 1,200,000 156,250 250,000 21,667 53,571 4,800,000 1,093,750 250,000 378,333 246,429 600,000 178,571 166,667 40,000 42,857 1,681,488 6,768,512 1,028,095 104,167 138,889 30,000 42,857 395,833 111,111 70,000 7,143 71,429 83,333 10,000 7,143 315,913 584,087 171,905 83,333 - 516,667 - 200,000 - TIM'S ASSETS PRINTING PRESS EQUIPMENT OTHER EQUIPMENT COMPUTERS FURNITURE DELIVERY TRUCKS 500,000 250,000 100,000 50,000 TOTAL 900,000 7/15/10 4/30/10 1/1/09 1/1/06 120 84 36 120 84 S/L S/L S/L S/L S/L 5,952 6,944 833 595 17.5 20.0 36.0 72.0 FRANK'S ASSETS: PRINTING PRESS EQUIPMENT OTHER EQUIPMENT COMPUTERS FURNITURE DELIVERY TRUCKS 600,000 7/31/11 - TOTAL 600,000 83,333 516,667 200,000 9,950,000 2,080,734 7,869,266 1,400,000 GRAND TOTALS 120 84 36 120 84 S/L S/L S/L S/L S/L 16,667 - 5.0 PURCHASED ASSETS IN 2012 SOFTWARE TOTAL DEPRECIATION FOR FY 12 3,000,000 7/1/12 12,950,000 36 S/L 83,333 6.0 500,000 1,900,000 PROJECT NARRATIVE INFORMATION ACCY 171 SUMMER 2016 Simon and Theodore are father and son and have each been operating reasonably successful businesses independent of each other. They have recently concluded that their individual strengths would be more successful if they combined their businesses together and have been formulating a plan to bring their businesses together as a single entity. They have been operating their businesses as separate sole proprietorships but now want to both put them together and obtain some legal liability protection. Alvin is Theodore's best friend since grade school. Alvin would like to participate in the new business venture but has limited cash to contribute. He has offered to do all the start up accounting and legal work in exchange for a portion of the new business. Even though Simon is not sure about Alvin's work ethic, he agrees to let Alvin become part of the new business. The assets and liabilities they each contribute are included in the excel spreadsheet under the tab \"Assets Contributed\". On February 1, 2012, the contributions are finally completed and all of the legal agreements signed by all of the parties. Simon contributed his existing business, with the exception of the land and building he owns where the business will be operated. Theodore contributed all of his business assets and liabilities. Alvin contributed a little bit of cash and his services prior to the final contributions which were valued at $75,000. The new entity was formed in January 2012 in anticipation of the contributions by each party. As it turns out, at least looking at the trial balance included in the excel spreadsheet (tab \"Trial Balance\"), the combining of the two businesses has resulted in increased sales and profits and the new business entity is very successful. Alvin turns out to be a pretty good financial accountant and has completed the trial balance as of the end of the year. You have had a number of discussions with Alvin and have found out the following information about the new business. The name of the company is AST Records. The business is manufacturing vinyl records for various recording artists. As a part of the business, the company not only manufactures the vinyl albums but also does the art work for the album cover. Alvin has chosen the accrual method for book purposes and sees no reason why the tax returns should be anything different. Inventory is a significant part of the revenue production process. Since the entity was just formed at the beginning of the year, there were no reserves or other accruals as of the start date of February 1, 2012. Because the company has turned out to be more successful than they ever planned, there is a significant amount of cash on the balance sheet at the end of the year. Simon has taken some of the extra cash and made investments in various stocks (other than DaveCo, all are less than 20% ownership of the stock investment) and bonds to provide at least some interest and dividend income. All of the investments are presented at fair market value using the \"Available for Sale\" accounting method. Alvin knew enough about this method that he correctly included the increase in value from original cost in the Other Comprehensive Income account (but did not do so net of tax which you can safely ignore for purposes of this exam). During the year, some of the equipment contributed by Simon was sold for a book loss. Additionally, Simon sold some investments for gains and losses. All of the necessary details are included on tabs \"Fixed Asset Sales\" and \"Sale of Investments\". In August, Simon's friend Dave approached Simon with an idea for a related business. Dave thought opening a recording studio for local bands would fit well with the existing vinyl record business and proposed a new venture. Simon was initially skeptical but agreed to form a new corporate subsidiary of AST Records along with Dave. AST contributed $450,000 in cash to the new entity in exchange for 45% of the common stock of the new company called \"DaveCo\". Dave contributed some assets and his services for the remaining 55% interest. Alvin knows that if you own between 20% and 50% of a business, then you account for it using the Equity Method for GAAP, but he has no idea what you do for tax purposes. The details on DaveCo are included on tab \"DaveCo Rollforward\". You do NOT need to worry about the formation of DaveCo as that is not part of this exam. As mentioned earlier, Simon retained ownership of the land and building where AST Records is located. AST pays Simon monthly rent of $9,000 that is payable on the first of each month for the PRECEEDING month. Alvin, Simon, and Theodore are all employees of AST Records as well as owners. Simon made a choice early on that all employees would be paid once per month on the 1st of each month for the past month's work. This was so he would never pay anyone in advance for work they had not yet done. AST Records has four employees in addition to Alvin, Simon and Theodore, all of whom have been with the company since February 1, 2012. None of the accrued vacation balance at the end of the year was paid within 2 months of year end. During the year, the company needed some new fixed assets. Details of the acquisition dates and book depreciation calculations are included on the tab \"Book Depreciation\". Here are some details to help you finish the forms (do not get caught up in googling things such as whether I have the proper zip code, etc. - that just wastes your time): AST Records 1234 Album Drive Las Vegas, NV 80024 Simon and Theodore live together at 4567 Chipmunk Lane Las Vegas, NV 80024 Alvin lives at 9876 Burbank Road Las Vegas, NV 80025 Below are the Social Security numbers for each of the owners: Simon Theodore Alvin 555-55-5556 333-33-3334 111-11-1112 For any tax calculation, use a flat rate of 34%. Do not use the graduated rates