MT482 Financial Statement Analysis Unit 4 Assignment Rubrics Complete the Case Study: Inventory Valuation in the Film Industry For this Assignment, turn to page 259 in your textbook (Chapter 4 of Financial Statements Analysis) and complete Case 4-1, Inventory Valuation in the Film Industry — Columbia Pictures This is a challenging activity. You should prepare to spend substantial time working on your response. Directions for Submitting Your Project Before you submit your project, you should save your work on your computer in a location, and with a name, that you will remember. Make sure your project is in the appropriate format (Word, Excel, PowerPoint, or other); then, when you are ready, you may submit on the Dropbox page. MT482 – Unit 4 Assignment: Columbia Case 4-1 Content, Analysis, Points Possible Points Earned • Response includes accurate information regarding the main determinants of the valuation of feature films, television programs, and general release feature productions by Columbia Pictures. • Response includes accurate information on the reasonableness of the bases of valuation. • Response includes the additional information on inventory valuation that an unsecured lender to Columbia Pictures would wish to obtain and any analyses the lender would wish to conduct 15 • Response includes appropriate analysis of the bases of valuation and other areas of analysis that a lender would wish to conduct 9 Correct spelling and grammar 6 Total Points Earned 30 MT482 Financial Statement Analysis Unit 5 Assignment Rubric Complete the Case Study: Accounting Entries for Consolidation of Intercorporate Investments. For this Assignment, turn to page 321 in your textbook (Chapter 5 of Financial Statements Analysis), and complete Case 5-1, Accounting Entries for Consolidation of Intercorporate Investments — Axel Corporation This is a challenging activity. You should prepare to spend substantial time working on your response. Directions for Submitting Your Project Before you submit your project, you should save your work on your computer in a location, and with a name, that you will remember. Make sure your project is in the appropriate format (Word, Excel, PowerPoint, or other); then, when you are ready, you may submit on the Dropbox page. MT482 – Unit 5 Assignment: Axel Case 5-1 Content, Analysis, and Effective writing skills Points Possible Possible Earned Response includes the journal entries for Axel Corp. to record the acquisition of Wheal Company stock assuming: • pooling accounting • purchase accounting. Response includes the worksheet entries for Axel Corp. to eliminate the investment in Wheal Company stock in preparation for a consolidated balance sheet at December 31, Year 4 assuming: • pooling accounting • purchase accounting. Response includes the calculation of consolidated retained earnings for December 31: • Axel Corp. uses the pooling method for this business combination. • Axel Corp. uses the purchase method for acquisition of Wheal Company 24 Correct spelling and grammar 6 Total Points Earned 30 unit 7 MT482 Financial Statement Analysis Unit 7 Assignment Rubric Complete the Case Study: Analysis of Cash Flows For this Assignment, turn to page 439 in your textbook (Chapter 7 of Financial Statements Analysis), and complete Case 7-1, Cash Flow and Free Cash Flow Analysis – Lands’ End. This is a challenging activity. You should prepare to spend substantial time working on your response. Directions for Submitting Your Project Before you submit your project, you should save your work on your computer in a location, and with a name, that you will remember. Make sure your project is in the appropriate format (Word, Excel, PowerPoint, or other); then, when you are ready, you may submit on the Dropbox page. MT482 – Unit 7 Assignment: Lands’ End Case 7-1 Content, Analysis, and Effective writing skills Points Possible Possible Earned Year that Lands’ End strategy was implemented and summary for how the strategy is reflected in the information that is contained in the statement of cash flows. 4 Explanation for how the four items listed below reconcile net income to net cash flows from operating activities: (1) Depreciation (2) Receivables (3) Inventory (4) Reserve for returns, and calculates free cash flows for each year shown. 10 Calculation of free cash flows for each year. 6 Analysis of how Lands’ End uses its free cash flow statement and whether this reflects good financial strategy. 4 Correct spelling and grammar 6 Total Points Earned 30 unit 6 Understanding Revenue Recognition For this assignment, turn to page 362 in your textbook (Chapter 6 of Financial Statements Analysis), and complete Case 6-1, Understanding Revenue Recognition. BIKE Company starts with $3,000 cash to finance its business plan to produce bike helmets with a simple assembly process. During the first month of business the company signs sales contracts for 1,300 units (sales price of $9 per unit), produces 1,200 units (production cost of $7 per unit), ships 1,100 units, and collects in full for 900 units. Production costs are paid at the time of production. The company has only two other costs: This is the entire problem. Do you think it will be completed by tonight? Sorry but i need it by then. 1. Commission of 10% of the selling price when the company collects from the customer; 2. Shipping costs of $0.20 per unit paid at time of shipment. Selling price and all costs per unit have been constant and are likely to remain the same. A. Prepare comprehensive (side by side) balance sheets and income statements for the first month of BIKE Company for each of the following three alternatives: 1. Revenue is recognized at the time of shipment 2. Revenue is recognized at the time of collection 3. Revenue is recognized at the time of production Note: net income for each of the three alternatives is (1) $990, (2) $810, and (3) $1080 respectively. B. The method where revenue is recognized at the time of collection, known as the installment method, is except the bull for financial reporting in unusual and special cases. Why is BIKE Company likely to prefer this method for tax purposes? (one line simple answer) C. Comment on the usefulness of the installment method for a credit analyst is using both the balance sheet and income statement. unit 8 CASE 9–1: Forecasting Pro Forma Financial Statements Refer to the following financial statements forKodak: Analysis INCOME STATEMENT For Year Ended December 31 (in millions) 20×6 20×5 20×4 Net sales ……………………………………………………………………………… $13,234 $13,994 $14,089 Cost of goods sold…………………………………………………………………. 8,670 8,375 8,086 Gross profit………………………………………………………………………. 4,564 5,619 6,003 Selling, general, and administrative expenses…………………………… 2,781 2,665 2,846 Research and development costs…………………………………………….. 779 784 817 Restructuring costs (credits) and other…………………………………….. 659 (44) 350 Earnings from operations …………………………………………………… 345 2,214 1,990 Interest expense ……………………………………………………………………. 219 178 142 Other income (charges) …………………………………………………………… (18) 96 261 Earnings before income taxes …………………………………………………. 108 2,132 2,109 Provision for income taxes………………………………………………………. 32 725 717 Net earnings …………………………………………………………………….. $ 76 $ 1,407 $ 1,392 Prepare forecasts of its income statement, balance sheet, and statement of cash flows for 20×7 under the following assumptions: · a. All financial ratios remain at 20×6 levels. · b. Kodak will not record restructuring costs for 20×7. · c. Taxes payable are at the 20×6 level of $544 million. · d. Depreciation expense charged to SG&A is $765 million and $738 million for 20×6 and 20×5, respectively. · e. Gross PPE is $12,982 million and $12,963 million for 20×6 and 20×5, respectively. · f. Projected current maturities of long-term debt are $13 million for 20×7. Top of Form unit 9 final paper Complete Your Final Project Theme Comprehensive Case Analysis based on the course material Description Your instructor posted an announcement during Unit 1 assigning a major publicly traded corporation from a non-regulated industry to use for this Assignment. You are required to obtain complete financial statements of this company for the last 5 years. You will prepare a Financial Statement Analysis Report based on these financial statements and other information. You should have been working on this project throughout the term. Directions For your Final Project, turn to page 676 in our textbook, and complete the Assignment under Case CC-1, Comprehensive Financial Analysis. The final analysis should be set up as a research paper with the following sequence: Cover page with your name, course number, your instructor, date, subject, a brief statement that you (and you alone) produced the paper, and a citation for each reference mentioned in your statement. Executive Summary (max. ¾ page in Bold) Table of Contents Introduction Body (8 – 12 pages) Conclusion and Recommendation(s) References Submit your Final Project by the end of Unit 9. ID: MT482-09-11-FP unit 10 MT482 Financial Statement Analysis Unit 10 Reflection Paper Unit 10 Reflection Paper Communication skills, which include writing, are critical in academics and in the workplace. Therefore, in Unit 10, you will be completing a self-reflection. This is your opportunity to reflect of what you have learned in this course. This is a chance for you and your instructor to see how the value of the subject matter in this course will connect to your academic and professional future. Here is a preview of this Unit 10 Assignment: After reflecting on what you have learned and how you have benefited by taking MT482, write a minimum one-page response to the questions below. Make sure to address the critical elements so you will be successful in completing this Assignment. Please answer the following questions in your paper: 1. Reflect and describe which key concepts and topics in this course have made you a stronger candidate to enter the business world. 2. Discuss how this course has affected you in your professional development as a student and as a person as well as encouraging you on your academic path. Respond using the critical elements below; submit your minimum one page response to the Dropbox by Tuesday at 12 midnight EST in Unit 10. Critical Elements: • Write your original response in Standard American English, paying special attention to grammar, style, and mechanics. • Respond to the questions in a thorough manner, providing specific examples of concepts and topics, from question 1, and specific examples of their impact on you from question 2. • Ensure that your viewpoint and purpose are clearly stated. • Demonstrate logical and appropriate transitions from one idea to another.