PROJECT INFORMATION:
You are the controller of ABC Company. You have been asked by the Board of Directors to assist them with upcoming changes they are looking to make for the company. They need additional information from you regarding the company overall. Throughout the next few weeks, you will provide information needed by the Board of Directors.
Course objectives covered: 1, 2, 4, 5, 6
PROJECT REQUIREMENTS:
This project is split into four (4) parts with one (1) part due each week of the course.
Parts 1, 2 and 3 will utilize Microsoft Excel and Microsoft Word. Part 4 is your Voice-Over PowerPoint to be submitted in the Week 4 Presentation Discussion Board.
Part 1: The Board of Directors has asked you to explain the method used to handle uncollectible Accounts Receivables. They know that you use the Allowance Method but are not familiar with the difference between the Direct Write Off Method versus the Allowance Method. Using the textbook as a source, explain each type of method and why ABC Company has selected the Allowance Method. Download the memo template provided below to respond. Keep in mind the intended audience of the memo.
Memo-Template.doc
Part 2: The Board of Directors has moved further into reviewing the liabilities of ABC Company. They wish to learn more about the payroll requirements of ABC Company. Using the spreadsheet below, complete the workbook for one payroll cycle.
ACG2011 ABC Company Payroll Report updated.xls
Part 3: In a continuation of their efforts to explore the financial condition of ABC Company, the Board of Directors has now started to explore the various investment strategies of the company. They would like to understand more about the differences between debt versus equity investments. They also wish to learn more about the various types of investments reported on the Balance Sheet.
Using your text and outside sources, explain the following: (1) debt versus equity securities; (2) various types of investments such as those listed in Exhibit 15-2; and (3) how to account for these investments (refer to Exhibit 15-8 as a guide). Keeping in mind the intended audience of the memo use Excel or Word to embed charts, tables, etc as you deem appropriate.
Memo-Template(1).doc
Part 4: Throughout the project, you have been asked several questions relating to the Balance Sheet of ABC Company. The Board of Directors
would like an overview of the company’s existing financial condition, including a summary of the following: (1) accounts receivable and uncollectible accounts; (2) payroll liabilities and other liabilities currently reported on the Balance Sheet; (3) an analysis of investments held by the company; and (4) a horizontal analysis of the Balance Sheet (provided below).
Using the Balance Sheet provided below, perform a horizontal analysis.
Once complete, use your new version of the Balance Sheet to present and discuss the Balance Sheet of ABC Company using voice-over PowerPoint.
Be sure to:
Address the items that the Board of Directors requested information on above such as: (1) Accounts Receivables and the process for uncollectible accounts; (2) Payroll Liabilities as well as other Current or Long-Term liabilities; and (3) the types of investments held by ABC Company.
Discuss your completed horizontal analysis. Based on the inferences you make from your horizontal analysis, discuss any improvements and/or changes that may have occurred since the prior year.
Keep in mind the intended audience of your presentation, which is the Board of Directors.
Ensure that you included proper APA citations for outside sources used, including the textbook.
ABC Company Balance Sheet(1).xls
Writing Activity:
Week 1 you will submit a 1 page report and Week 3 you will submit a memo with at least 1 reference from the Keiser University library each week. This is expected to be college-level writing. The report(s) need to be one that your instructor wants to read.
All written documents and sources used are to be submitted in APA format (use the writing center as needed). APA Formatting & Style Guide at https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/general_format.html
Technology/Collaborative Activity:
You will be presenting and discussing your findings to the class using the voice-over feature in PowerPoint. Please be sure the audio is clear and the file or link is accessible in the Week 4 Presentation.
You will be using Excel to create spreadsheets in Week 2.
Assignment Due Date Schedule: OK to turn in early
Week 1: Submit a 1 page report for Part 1 above.
Week 2: Submit completed Payroll Liabilities Workbook using the Excel template provided for Part 2.
Week 3: Submit a 1 page memo with appropriate charts, tables, etc. for Part 3 above.
Week 4: Present and discuss the provided Balance Sheet after performing horizontal analysis using voice-over PowerPoint.
RELATED: Assignment 2: Applying Employee Selection Methods to Real-Life and Career Goals
Order This Paper
Reviews
There are no reviews yet.