Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please offer some guidance with this project. Thanks. Acct 3401 Financial Statements Assignment Requirements This assignment is due on Monday, Nov. 20 (submit
Can you please offer some guidance with this project. Thanks.
Acct 3401 Financial Statements Assignment Requirements This assignment is due on Monday, Nov. 20 (submit online via the Canvas Assignment). This assignment is worth 60 course points. Use the accompanying document (\"3401 Final Assignment Submission.docx\") to prepare and submit your answers. Background It is early 2017 and you have just been hired as the financial reporting guru for TECHNOGYM, a diversified exercise/fitness corporation that has just finished a very fast-paced, dynamic year. TECHNOGYM began as the sole distributor of TechTone, a full-body fitness machine sold to fitness centers and hospitals. This remains the main operation of TECHNOGYM's business. Your predecessor left the firm in a hurry. Your primary responsibility is to finish the 2016 yearend financial statements. Luckily, there is still time to make any necessary adjusting and closing journal entries for the 2016 fiscal year. Throughout the semester you are working on different aspects of the company's financial records relating to: discontinued operations, revenue recognition, accounts receivable, and inventory. As you are working on the 2016 year-end, you are also reviewing the first quarter 2017 journal entries and will make any necessary correcting journal entries. Note: you may collaborate with classmates on discussing the issues to be considered in this exercise, but you must do your own work. Especially in the memo (part 3), you must independently write your own memoyour document may not have similar wording to another student's memo or they will be considered plagiarized. If you want someone else to read your draft memo, choose someone who is not currently taking the course. Part 1 Requirements (18 points): a) Using information in the 2016 preliminary adjusted trial balance (attached), prepare the adjusting journal entry for Income Tax Expense for the full year 2016. b) Using information in the 2016 preliminary adjusted trial balance, combined with the adjusting entry for income taxes you did above, prepare the 2016 closing journal entries for TECHNOGYM. c) Using information in the 2016 preliminary adjusted trial balance, combined with the adjusting entry for income taxes you did above, prepare the 2016 Balance Sheet and Income Statement for TECHNOGYM. The Balance Sheet must be classified and the Income Statement must be multi-step. Both must be comparative, with columns for the appropriate number of years. Remember this is a public reportit should be formatted appropriately (labeled, values aligned, single page, etc.). Part 2 Requirements (8 points): For the first quarter of 2017, prepare any needed correcting or adjusting journal entries related to the following information. For corrections, first prepare an entry reversing the original incorrect entry, then prepare the correct entry. Show the calculation of any amounts not included in the problem. Round intermediate calculations to 4 significant digits (e.g., 63.27%). If no journal entry is needed, write \"No Entry Needed\" and explain briefly why it is not needed. d) In addition to its normal operations, during the first quarter of 2017, TECHNOGYM launched a new service through its website called MagnaTrain. This web site offers online fitness training through contracted independent trainers. Each trainer sets her own price for a training session. TECHNOGYM connects interested individuals with the trainers but does not directly provide any of the training. For its services and per the contract, TECHNOGYM is entitled to 15% of the total per session fee. TECHNOGYM has recorded the entire Page 1 of 5 Acct 3401 Financial Statements Assignment Requirements $6,000,000 fee collected in cash from the sessions as revenue and recognized its cost associated with MagnaTrain as 85% of the collected fee. e) Also, in addition to its normal operations, during the first quarter of 2017, TECHNOGYM entered into a long-term agreement to supply its internally developed smart-phone-interactive fitness equipment, BodyTracker, and maintenance support to a regional 24 hour fitness chain. TECHNOGYM was paid $9,000,000 during March, 2017 for the equipment plus 3 years of maintenance support (beginning on April 1, 2017the first day of the next quarter). The fitness chain could have bought just the equipment for $7,500,000 with no support and they could have independently contracted for the maintenance support for $3,000,000 for the three year period. The cost of the equipment sold was $3,500,000. TECHNOGYM has recorded the $9,000,000 as a point-of-sale cash transaction. f) Note: Before answering this item, read the section of chapter 13 in the textbook (9th edition) about \"Loss Contingencies\" on pages 730-732. During the first quarter of 2017, the company to which TECHNOGYM sold its West Coast division on Dec. 31, 2016 filed a lawsuit alleges that TECHNOGYM misrepresented the division's assets and liabilities. The plaintiff is seeking $2.4 million as an adjustment to the purchase price. TECHNOGYM's attorneys advise that it is reasonably possible the company could lose $1 million, but that it's extremely unlikely it could lose the $2.4 million asked for. Part 3 Requirements (34 points): During 2016, the following key events occurred at TECHNOGYM. These are the same activities you have analyzed in assignments during the semester. You should refer to the solutions to the TECHNOGYM assignments for Discontinued Operations, Revenue Recognition, and Accounts Receivable for more details about these events and the resulting financial impacts. Discontinued Operation: On October 1, 2015, TECHNOGYM made and announced a decision to sell its West Coast operations (considered a \"component\" according to the GAAP definition) to an unaffiliated company. On December 31, 2016, the West Coast division was sold, and the actual result of the sale was a $125,200 loss. The journal entries related to the sale were recorded already, along with all other normal 2016 adjusting entries. Revenue Recognition: TECHNOGYM has a division that builds university fitness centers. At the end of 2016, there was one building project in process, the $45,000,000 Western Sky University project (WSU), which was started in June 2015. Throughout 2016, routine transaction entries were to record construction costs, billings, and collections. During 2016 there were substantial additional cost increases, resulting in a 2016 year-end total cost estimate of $45,500,000 for the job. Accounts Receivable: TECHNOGYM uses the Accounts Receivable approach to estimate bad debts, based on an A/R aging schedule. g) Mr. James Techno, the company's President, has asked you to prepare a brief memo for him, which should include following three key items: 1) Analyze TECHNOGYM's 2016 financial statements, identifying the major factors causing changes in the company's financial health and performance. Recommendation: Look at the data behind the financial statements and the relationships among the values. It is always a good idea to start with a horizontal (changes year to year) and vertical (percentage of assets, revenues) analyses to assess which values changed the most significantly so you can consider the possible causes and decisions. For example: Page 2 of 5 Financial Statements Assignment Requirements Acct 3401 Horizontal Analysis for 2015: from 2014 to 2015 Cash changed from $5,610 to $9,200 an increase of $3,590 (64%); Accounts Receivable, net changed from $4,575 to $5,340 an increase of $765 (17%). Vertical Analysis for 2015: Inventory was 6% of Total Assets (2,500/41,460); Cost of Goods Sold was 53% of Revenue (57,850/108,840). How did the various business segments perform against expectations? Think about the related accounts and the journal entries that would be made for the changes. For example, if product sales increase, normally so would A/R, bad debts, COGS, and sometimes inventory and accounts payable (if continued growth is expected). Does the timing of purchases and sales imply anything? 2) Analyze the following applicable ratios: Current Ratio Quick Ratio Debt-to-Assets Ratio Times-Interest-Earned Ratio Net Profit Margin Pct. Return on Equity Pct. Account Receivable Turnover Inventory Turnover 2016 Ratio Values 2.3 1.4 0.9 4.3 1.7 28.8 10.6 5.2 2015 Ratio Values 0.5 0.4 0.9 n/a 3.8 68.4 22.0 24.1 Select several ratios of different types (profitability, efficiency, liquidity, solvency) that provide the best insight into the company's financial performance and position. Recommendation: Analysis is more than calculating a ratio and saying if it is good or bad. Don't just explain how the numbers changedexplain what they reveal about business decisions and events, and what they might mean for the future. Think about things like: What were the big changes? What caused them? Are they reason for ongoing concern? How were complementary ratios impacted (e.g., if cash was obtained by issuing stock, current ratio would increase but return on equity would decrease)? 3) Provide specific recommendations for improvements. Note: The 2015 Balance Sheet and 2015 Income Statement are attached to this document. Please include (as an attachment) a small table of the ratios you discuss in the memo. Top management understands the ratios so your explanation should not include definitions. Your explanation memo should be single spaced, and 1 to 1.5 pages in length (not counting the ratio table). Page 3 of 5 Acct 3401 Financial Statements Assignment Requirements 2015 (prior year) Financial Statements: Page 4 of 5 Acct 3401 Financial Statements Assignment Requirements Preliminary 2016 Adjusted Trial Balance (before the adjusting entry for income tax): Page 5 of 5 Acct 3401 Financial Statements Assignment Submission Refer to the accompanying document (\"3401 Final Assignment Requirements.docx\") for the information needed to complete this assignment. Class Start Time: Name : Part 1 Requirements (18 points): a) Using information in the 2016 preliminary adjusted trial balance, prepare the adjusting journal entry for Income Tax Expense for the full year 2016. You can omit the date, but it must otherwise be in proper form (including showing the basic accounting equation impacts). b) Using information in the 2016 preliminary adjusted trial balance, combined with the adjusting entry for income taxes you did above, prepare the 2016 closing journal entries for TECHNOGYM. You can omit the date, but it must otherwise be in proper form. c) Using information in the 2016 preliminary adjusted trial balance, combined with the adjusting entry for income taxes you did above, prepare the 2016 Balance Sheet for TECHNOGYM. The format must be classified and comparative (with columns for the Page 1 of 6 Acct 3401 Financial Statements Assignment Submission appropriate number of years). Remember this is a public reportit should be formatted appropriately (labeled, values aligned, single page, etc.). TECHNOGYM Balance Sheet As of December 31 (all amounts are in $thousands) Page 2 of 6 Acct 3401 Financial Statements Assignment Submission c) (continued) ... Using information in the 2016 preliminary adjusted trial balance, combined with the adjusting entry for income taxes you did above, prepare the 2016 Income Statement for TECHNOGYM. The format must be multi-step and comparative (with columns for the appropriate number of years). Remember this is a public reportit should be formatted appropriately (labeled, values aligned, single page, etc.). TECHNOGYM Income Statement As of December 31 (all amounts are in $thousands, except per-share amounts) Page 3 of 6 Acct 3401 Financial Statements Assignment Submission Part 2 Requirements (8 points): For the first quarter of 2017, prepare any needed correcting or adjusting journal entries related to the following information. For corrections, first prepare an entry reversing the original incorrect entry, then prepare the correct entry. Show the calculation of any amounts not included in the problem. Round intermediate calculations to 4 significant digits (e.g., 63.27%). If no journal entry is needed, write \"No Entry Needed\" and explain briefly why it is not needed. d) MagnaTrain revenue - TECHNOGYM recorded the entire $6,000,000 fee collected in cash from the sessions as revenue and recognized its cost associated with MagnaTrain as 85% of the collected fee. For its services and per the contract, TECHNOGYM is entitled to 15% of the total per session fee. You can omit the date, but it must otherwise be in proper form (including showing the basic accounting equation impacts). e) BodyTracker revenue - TECHNOGYM has recorded $9,000,000 cash collected as a pointof-sale cash transaction during March, 2017 for equipment plus 3 years of maintenance support (beginning on April 1, 2017). The fitness chain could have bought just the equipment for $7,500,000 with no support and they could have independently contracted for the maintenance support for $3,000,000 for the three year period. The cost of the equipment sold was $3,500,000. Page 4 of 6 Acct 3401 Financial Statements Assignment Submission f) During the first quarter of 2017, the company to which TECHNOGYM sold its West Coast division on Dec. 31, 2016 filed a lawsuit alleges that TECHNOGYM misrepresented the division's assets and liabilities. The plaintiff is seeking $2.4 million as an adjustment to the purchase price. TECHNOGYM's attorneys advise that it is reasonably possible the company could lose $1 million, but that it's extremely unlikely it could lose the $2.4 million asked for. Page 5 of 6 Acct 3401 Financial Statements Assignment Submission Part 3 Requirements (34 points): g) Insert memo to Mr. Techno here. Page 6 of 6 Financial Statements Assignment TechnoGym Trial Balance Acct 3401 TECHNOGYM Adjusted Trial Balance December 31, 2016 Cash Accounts Receivable Allowance for Doubtful Accounts Income Tax Refund Receivable Inventory LIFO Reserve Purchases Construction in Progress Billings on Contracts Property, Plant & Equipment Accumulated Depreciation Accounts Payable Interest Payable Income Tax Payable Notes Payable-Noncurrent Common Stock Retained Earnings Tech Tone Sales Revenue Sales Returns Building Revenues Loss on Sale of Discontinued Operation Cost of TechTone Equipment Sold Costs of Construction Bad Debt Expense Depreciation Expense Interest Expense General and Admin Expenses Income Tax Expense/(Benefit) TOTAL Income Tax Rate Common Shares of Stock Outstanding Debit 12,730,908 18,187,500 Credit Discontinued Ops Debit 124,650 Credit Continuing Ops Debit 12,606,258 18,187,500 862,769 862,769 20,060,000 20,060,000 175,000 175,000 31,200,000 31,200,000 32,000,000 32,000,000 52,800,000 52,800,000 43,680,000 17,640,000 2,659,914 43,680,000 17,640,000 2,659,914 30,000,000 1,500,000 3,439,340 140,482,500 30,000,000 1,500,000 3,422,708 120,487,600 280,965 16,632 19,994,900 39,990 240,975 13,751,000 125,200 68,447,500 15,151,500 842,768 12,000,000 905,215 53,458,967 286,190,523 34% 150,000 Credit 13,751,000 125,200 10,270,000 58,177,500 15,151,500 842,768 10,560,000 905,215 45,447,275 1,440,000 8,011,692 286,190,523 20,011,532 20,011,532 266,178,991 266,178,991 Acct 3401 Financial Statements Assignment TechnoGym 2015 Financial Stataments TECHNOGYM Income Statement For the Years Ended December 31 All amounts are in $Thousands (except per-share amounts) Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Operating Income Other Revenues Other Expenses Income Before Taxes & Other Items Income Tax Expense/(Benefit) Income from Continuing Operations Discontinued Operating Results Loss on Sale of Discontinued Oper. Tax Expense/(Benefit) from Disc. Ops. Discontinued Operations Total NET INCOME EPS - Continuing Operations EPS - Discontinued Operations EPS - Net Income 2015 $108,840 57,850 $50,990 46,560 $4,430 17,600 (17,400) $4,630 1,574 $3,056 2014 $78,420 42,300 $36,120 35,730 $390 12,450 (12,190) $650 221 $429 2013 $62,736 33,840 $28,896 28,584 $312 9,960 (9,752) $520 177 $343 1,620 (250) (200) 551 $1,069 (85) ($165) (68) ($132) $4,125 $264 $211 $20.37 $7.13 $27.50 $4.29 ($1.65) $2.64 $3.43 ($1.32) $2.11 Acct 3401 Financial Statements Assignment TechnoGym 2015 Financial Stataments TECHNOGYM Balance Sheet As of December 31 All amounts are in $Thousands 2015 ASSETS Cash Accounts Receivable, Net Inventory, Net Assets Held For Sale Subtotal Current Assets Property, Plant & Equipment, Net TOTAL ASSETS LIABILITIES and EQUITIES Accounts Payable Interest Payable Income Tax Payable Construction Contract Liability Liabilities Held For Sale Subtotal Current Liabilities Common Stock Retained Earnings TOTAL LIABILITIES and EQUITIES 2014 $9,200 5,340 2,500 1,860 $18,900 $5,610 4,575 2,300 1,885 $14,370 22,560 $41,460 36,000 $50,370 $25,588 2,235 1,574 2,400 3,631 $35,428 $24,507 18,070 221 6,165 $48,963 1,500 4,532 $41,460 1,000 407 $50,370Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started