It is activity 4-9 and it has to be done by using Exel,

Ada Fontanez is the president of a large company that owns a chain of athletic shoe stores. The company was in dire financial condition when she was hired three years ago. In an effort to motivate Fontanez, the board of directors included a bonus plan as part of her compensation package. According to her employment contract, on January 15 of each year, Fontanez is paid a cash bonus equal to 5% of the amount of net income reported on the preceding December 31 income statement. Fontanez was sufficiently motivated through her leadership, the company prospered. Her efforts were recognized throughout the industry, and she received numerous lucrative offers to leave the company. One offer was so enticing that decided to change jobs. Her decision was made in late December 2013. However, she decided to resign effective February 1, 2014, to ensure the receipt of her January bonus. On December 31, 2013, the chief accountant, Walter Smith, advised Fontanez that the company had a sizable quantity of damaged inventory. A ware house fire has resulted in smoke and water damage to approximately $600,000 of inventory. The ware house were not insured, and the accountant recommended that the loss be recognized immediately. After examining the inventory, Fontanez argued that it could be sold as damaged goods to customers at reduced prices. Accordingly, she refused to allow the write-off the accountant recommended. She stated that so long as she is president, the inventory stays on the books at cost. She told the accountant that he could take up the matter with the new president in February. How would an immediate write-off of the damaged inventory affect the December 31, 2013, income statement, balance sheet, and statement of cash flows? How would the write-off affect Fontanez s bonus? If the new president is given the same bonus plan, how will Fontanez's refusal to recognize the loss affect his or her bonus? Assuming that the damaged inventory is truly worthless, comment on the ethical equations of Fontanez s refusal to recognize the loss in the 2013 accounting period. Assume that the damaged inventory is truly worthless and that you are Smith. How would you react to Fontanez's refusal to recognize the loss? Using either Alcoa's most current Form 10-K or the company s annual report, answer the questions below. To obtain the Form 10-K you can use either use the EDGAR system following the instructions in Appendix A, or it can be found on the company's website. The company's annual report is available on its website. What was Alcoa's gross margin percentage for the most current year? What was Alcoa's gross margin percentage for the previous year? Has changed significantly? What was Alcoa's return on sales percentage for the most current year? What percentage of Alcoa's total sales for the most current year was from operations in the United States? Comment on the appropriateness of comparing Aloca's gross margin, with, that of Microsoft. If Microsoft has a higher/lower margin, does that mean that Microsoft is a better managed company? The following account, balances, and other financial informal are drawn from the records Vong Company for the year 2013: The cash account revealed the following cash flows: Build an Excel spreadsheet to construct a multistep income statement, statement of changes in stockholders' equity, balance sheet, and statement of cash flows for the year 2013. At the end of 2013, the following information is available for Short and Wise Companies