Attachment # 00001369 - ACCT202Simulation_SS2014_Student_(1)_(3).xlsx
ACCT202Simulation_SS2014_Student_(1)_(3).xlsx (236.92 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
2. Is AC Speed able to effectively leverage its profitability? Why or why not?3. AC Speed's general manager mentioned that the company may be seeking some additional bank financing (both short- and long-term) in the near future. Explain how you think the bankwill view the company's request, based on the evidence of liquidity and solvency ratios. INDUSTRYEvaluate the company's performance trend relative to liquidity, profitability and solvency.Dec. 31, 2010Dec. 31, 2009Dec. 31, 2008Dec. 31, 2007BI $/UnitBI $Purch UnitsPurch $/UnitPurch $EI UnitsEI $/UnitEI $BalanceSale Units (CGS)Sale $/Unit (CGS)Sale $ (CGS)Depreciation Expense - Equip & Furniture - OfficeAC Speed CorporationAllowance for Doubtful AccountsEquipment & Furniture - WarehouseUnearned RentDividends PayableBonds PayableMortgage (Warehouse) PayableCommon Stock, $1 Par, 100,000 Authorized; 60,000 shares Issued/OutstandingPaid In Capital - Excess of ParRetained EarningsTreasury StockWage Expense (hourly workers)Salaries Expense (Exempt Staff)Marketing ExpenseTravel and Entertainment ExpenseINSTRUCTIONS: (also refer to the Instructions tab in this workbook)Calculate all of the ratios listed above for years ending December 31, 2010, 2009, and 2008. YOU MUST USE EXCEL FORMULAS AND LINKS TO DATA IN THE "Adj Trial Balances Prior Yrs" TAB TO DO THE CALCULATIONS.Evaluate the company's performance relative to liquidity, profitability and solvency for their industry for the three years.Use Word to prepare a memo (500 word minimum) to AC Speed's management, addressing the following questions:1. How efficiently is AC Speed using its assets to produce sales? How does it compare to other firms in the industry in this respect? Beginning Inventory (BI)PurchasesEnding Inventory (EI)Davenport UniversityACCT202 Practice SetOther - CRBalance Brought ForwardLegal ExpensesPurchases Balance Carried ForwardB/S AdjusterI/S AdjusterLiquidityBuildingAccumulated Depreciation - BuildingAccumulated Depreciation - Equip & Furn. - WarehouseAccumulated Depreciation - Equip & Furn. - OfficeMichigan Utility CompanyStatement of Retained EarningsIncome SummaryOtherAcct #Account NameCashAccounts ReceivableMerchandise InventoryOffice SuppliesPrepaid InsuranceBALANCE SHEET ACCOUNTS Assets Current Assets Property, Plant and EquipmentLand Liabilities Current LiabilitiesAccounts PayableWages PayableInterest Payable Long-Term LiabilitiesNotes Payable Capital (Equity)INCOME STATEMENT ACCOUNTS RevenueSalesSales DiscountsSales Returns & Allowances Cost of Goods SoldCost of Goods Sold Operating ExpensesOffice Supplies ExpenseInsurance ExpenseUtilities ExpensePost-closing Trial BalanceFor Month Ended June 30, 2010Current Ratio (One decimal place)Acid Test Ratio (One decimal place)Receivables Turnover (One decimal place)Inventory Turnover (One decimal place)ProfitabilityProfit Margin (% with two decimal places)Asset Turnover (two decimal places)Return on Assets (% one decimal place)Return on Common Shareholders' Equity (One decimal place)Earnings per Share (EPS) (Two decimal places)Price-Earnings (P/E ) Ratio (Two decimal places)Payout Ratio (% One decimal place)Solvency RatiosDebt to Total Assets Ratio (% One decimal place)Telecommunications ExpenseInterest ExpenseEquipment & Furniture - Office Other ExpensesDateInvoice No.A/R Account DebitedPost RefA/R - DR Sales - CRCGS - DR Inv - CRSales JournalCreditors Account CreditedA/P - CRInventory - DROffice Supplies - DROther - DROther Account - DebitedPurchases JournalA/R - CRSales - CRSale Discount - DRCash - DRCGS - DR Inv - CRAcct - CR Customer Acct Other AcctCheck #Cash - CRInventory - CRA/P - DRPayeeAccount DebitedCash Payments JournalAccountsDEBITCREDITGeneral JournalChart of Accounts - General LedgerChart of Accounts - Accounts Payable LedgerItemTransactionAccount BalanceAccount No.Account: Account:UnadjustedAdjustedIncome Bal. SheetTrial BalanceAdjustmentsStatementStmt. Own. EquityAcct. No.Account TitleDr.Cr.Income StatementBalance SheetShoe:BI UnitsDepreciation Expense - Equip & Furniture - WarehouseBad Debt ExpenseProperty Tax ExpenseOffice Maintenance & Repair Expense Other IncomeRent IncomeGeneral MotorsFord Motor Co.ToyotaHondaKiaNissanChart of Accounts - Accounts Receivable LedgerNavistarSamsungJVCMagellanGarminMotorolaCash Receipts JournalTotalNet Income (Loss)Product NameGPSDVD PlayerDocking StationDescriptionIn vehicle GPS unitIn vehicle DVD playerCell phone / Mobile Communications Docking StationDate:Access Code:CRN:Student's NameAccess CodeCRNTestThis is just a Test d. Use Word to prepare a memo (minimum 500 words) to AC Speed’s general manager, addressing the three questions listed at the bottom of the ratios tab. This should be formatted as a business memo, not an APA paper. Be sure to include a brief introduction and conclusion in the memo. Each question should be addressed in one or two paragraphs in the body of the memo. Remember that the general manager will expect details/facts/ratios to support statements you may make about the status of the business. Your writing should be concise, clear, and readable, with a fairly formal tone (since it’s addressed to AC Speed’s general manager, who is likely to share it with other members of management). Your instructor will provide the due date and submission requirements for this part of the project. c. After you calculate the ratios, consider whether there is a trend over the three-year period. Also compare the ratios you calculated for AC Speed with those listed as industry averages. Review the information in Chapter 18 to help you determine what the ratios are telling you about various aspects of AC Speed’s business operations.b. Tabs in the project workbook provide trial balance data for the current and two preceding years for AC Speed and a location to calculation a selection of ratios. Use the trial balance data and the formulas in Chapter 18 to compute the ratios listed for each of the three years. YOU MUST STRUCTURE YOUR RATIO CALCULATIONS AS FORMULAS AND LINKS TO APPROPRIATE CELLS ON THE TRIAL BALANCE TAB. You will lose points by simply typing the final ratio numbers or percentages.a. Before beginning this part of the project, you will find it helpful to review Chapter 18 on financial statement analysis. Page 809, a summary of ratios, will be particularly useful.F. Part 2 of this project requires you to analyze the company’s year-end financial statements to assist the management of AC Speed in assessing the company’s financial position and making decisions about its future direction.p. List the general ledger accounts that have balances other than zero on the post-closing trial balance. The totals of the debit column and the credit column should be equal.o. Prepare the end-of-month closing entries. Record these entries in the general journal and post them to the general ledger. Update balances in the general ledger accounts.n. Use the balance sheet information on the worksheet to prepare a classified balance sheet, similar in format to the example on page 711. Remember that the ending retained earnings balance from the just-completed statement is a necessary component of the equity section of the balance sheet.m. Prepare a statement of retained earnings in good form. Look at examples of this statement in your textbook. Remember that net income from your just-completed income statement is a necessary component of this statement.l. Use the income statement information on the worksheet to prepare a multi-step income statement in good form. Look at examples of this income statement format in your textbook, such as the one on page 220.k. Sort the dollars recorded in the adjusted trial balance columns into either the income statement or the balance sheet columns. Total these columns. The entry of net income should cause the debit and credit columns to equal one another. j. Complete the unadjusted trial balance columns on the worksheet. Use Excel formulas to carry balances from the unadjusted trial balance columns, adjusting as necessary by entries in the adjustments columns. Check your results against the balances recorded in the general ledger.i. Update general ledger account balances after posting adjusting journal entries. h. Prepare the end-of-month adjusting entries. Record these entries in the general journal and post them to the general ledger. Also record the adjusting entries in the designated columns in the worksheet and total the debit and credit columns. These totals should be equal.g. List all general ledger account balances in the unadjusted trial balance columns of the worksheet. Use the sum function in Excel to total the debit and credit columns. These totals should be equal.f. At this point in the closing process, the balances of all subsidiary ledger accounts would be totaled and that total compared to the balance of the corresponding control account in the general ledger. That is, the total of inventory control cards would be compared to the Merchandise Inventory balance; the customer subsidiary ledger total to the Accounts Receivable balance; and the vendor subsidiary ledger total to the Accounts Payable balance. Any discrepancies would be investigated and corrected. Given the limited scope of this project scenario, reconciliation between subsidiary ledgers and control accounts is not possible.e. When posting is completed, bring the balance in each subsidiary ledger account up to date.d. When posting is completed, bring the balance in each general ledger account up to date.c. At the end of the month, total each column in each special journal and post that total to the general ledger. EXCEPT for entries in the “Other” columns, which must be posted individually to the general ledger.b. At the end of the month, post each entry in the general journal to the general ledger.a. Record each business transaction, in sequence by date, in the appropriate special journal or the general journal. Also, immediately record any transaction involving inventory, a customer, or a vendor in the appropriate subsidiary ledger record.E. Financial Accounting Steps:e. Subsidiary ledger records are kept for each customer and for each vendor. The balances in the customer subsidiary ledger records, in total, must equal the Accounts Receivable account balance in the general ledger. The balances in the vendor subsidiary ledger records, in total, must equal the Accounts Payable account balance in the general ledger.d. AC Speed uses a perpetual inventory accounting system and a last-in, first-out (LIFO) inventory costing method.c. AC Speed accounts for the specific types of merchandise in their inventory with a set of subsidiary ledgers (inventory control cards). The balances in these subsidiary ledger records, in total, must equal the balance in the Merchandise Inventory account in the general ledger.b. When AC Speed sells merchandise to a customer on account, they offer that customer credit terms of 2/30, net 45.D. Credit Terms & Inventory Accountingd. Due dates for the parts of this project will be provided by your instructor in the course syllabus, in the Blackboard course site, or in a designated handout. Be sure to enter these on your personal calendar and plan your work on this project accordingly.c. You must read the academic integrity statement in the project workbook and enter your student ID number on the form to signify your agreement with and adherence to that statement. Final project submissions will not be accepted without this.b. Save backup copies of your work. If you have multiple versions of the project, clearly label them for your own reference and to ensure that you submit the appropriate version to your instructor.a. Final submission of all parts of this project must be in electronic (not paper) form. That is, you will submit your completed work via an assignment link in a Blackboard course site or via an email attachment. Follow your instructor’s directions.C. Submission Requirementsh. Appearance counts! Pay attention to the format, to spelling, and to other details of appearance. This reflects on management’s perception of you as a professional.g. Refer to the project rubric to determine how components of the project will be assessed.f. Use the check figures provided to check your work as you progress through the project. Investigate any discrepancies and correct them as you go along.e. If rounding is required, round to the nearest cent. For example, $96.835 would be entered as $96.84.d. Most of your work for this project will be accomplished in Excel. A basic skill level in this application is expected. That is, you should be able to such things as move around in a workbook, enter data in cells, use the sum function, compose basic formulas, and save your work.c. These project instructions will not address every detail of every task. If you have questions, ask your instructor.a. The parts of this project, including specific business transactions and steps in the accounting cycle, must be completed in sequence. This is particularly important with business transactions relating to purchases and sales of inventory.B. General Instructionsd. Before starting work, review the entire project: all instructions, business transactions descriptions, workbook sections, check figures, due dates, and submission requirements.c. This is an individual, not a team, project. While you may discuss this project with others, you must prepare and submit your own work. Refer to the academic integrity statement in the project workbook.b. Part 2 is an activity that requires you to analyze the company’s year-end financial statements to assist management in assessing the company’s position and making decisions about its future direction.a. Part 1 is a financial accounting activity that requires you to record various business transactions during the month, close the accounting records at the end of the month, and prepare the financial statements. These tasks relate to the steps in the accounting cycle that you learned in your first accounting course.`A. OverviewProject Overview & InstructionsThe company’s accountant has just been called away for a family emergency and will likely be absent for a month or so. The General Manager asks you to take over the accountant’s regular duties on an interim basis. You’re nervous about doing so, but are confident that what you’ve learned in accounting class, plus your personal problem-solving skills, will make this a successful experience. What a great learning opportunity, not to mention an enhancement to your resume!You’re a Davenport University student pursuing a bachelor’s degree in business and employed at the AC Speed Company this semester as an intern. You’ve worked in various departments and on several projects so far, learning a lot about the company’s business operations. Management seems impressed with your enthusiasm and the quality of your work.The AC Speed Company is a well-established, publicly-held corporation, operating as a wholesaler in the auto parts industry. Specifically, AC Speed purchases auto parts from manufacturers and sells them to large business customers. Most purchases and sales are on account, with trade credit terms (specified below).Company Background & ScenarioName:*Click the following buttons to go to the corresponding worksheets:Common DividendsWeighted Average Common SharesMarket Price per ShareJUNE JOURNAL TRANSACTIONSJune 1June 2June 3June 4June 5June 7June 8June 11Paid in full for the June 1 purchase from Navistar, Check #5281.June 12Paid the dividend that was declared on June 3, Check #5283.June 13June 15Check # 5284 was issued for payroll: $14,500 for salaried and $4,750 for wages.June 16June 17Returned the 350 defective units received from Kia to Navistar.June 18Received payment in full from Toyota for the June 1st sale.June 20While inspecting the June 13th purchase, it was discovered that the GPS units were programmed for South America instead of North America. AC Speed returned the entire order to Magellan.June 22June 23Paid $75,000 of the $162,500 owed to JVC from May 25, Check #5285.Received payment from Ford Motor Co. for $175,000 of the $300,000 owed from May 5.June 24June 25Paid in full for the purchase from JVC on June 13, Check #5287June 27Hired and paid a consultant $75,000 to devise a marketing plan. AC Speed's management felt this was necessary to develop brand awareness. Check #5289.June 28June 29Paid in full for the purchase from Magellan on May 31st, Check #5291.Check #5292 was issued for payroll: $14,500 for salaries and $4,750 for wages.June 30**All credit sales have terms of 2/30, n/45June Month-end Adjustments:( A )( B )The Company took a physical count of Office Supplies on June 30 and found the following to be on hand:( C )( D )The Company took a physical inventory count on June 30 and found the following inventory on hand:( E )( F )Depreciation on the company's fixed assets for the month of June is as follows:Sold 3,500 GPS units on account to Kia for $52 per unit, Invoice #5556.Sold 900 docking stations for $64 per unit and 1950 GPS units for $83 per unit on account to Nissan, Invoice #5560.Received and paid expense reports for travel and entertainment totaling $925, Check #5279.Received a bill from the law firm of Larry, Moe & Curly for $5,400, payable upon receipt, for bond consulting fees, Check #5282.Took advantage of a special deal to purchase 3,250 DVD players on account from JVC for $48 per unit.Purchased 850 GPS units on credit from Magellan for $33 per unit.Issued a credit to Kia for the return of 350 defective units from the June 2nd sale. These units has a cost basis of $35 per unit.Sold 1,650 docking stations on credit to Kia for $64.50 per unit, Invoice #5559.Purchased a $100 international phone card for one of the sales representative's upcoming European business trip, Check #5286.Sold 1,500 docking stations on credit to Honda for $61 per unit, Invoice 5558.June 26Purchased 1,250 docking station from Samsung for $41 per unit paying in cash, Check #5288Paid for office supplies purchased on June 2nd, Check #5280.Received payment in full from Honda for the June 27th transaction.Signed a one-year 18.5%, $180,000 note payable with First Bank. Purchased 3,000 GPS units on Credit from Navistar for $35.00 per unit. Issued 5,500 shares of common stock for $11 per share (Refer to General ledger for description of common stock). Sold 2,000 DVD players on account to Toyota for $75 per units, Invoice #5555. Purchases office supplies from Office Max on credit for $1,200.The Board of Directors declared a cash dividend of $5 per share for shareholders of record on June 5th, payable on June 12th. Received payment from Toyota for May 11th sale Rented part of the warehouse to a new tenant and received $4,900 for three months rent (June, July, August). Paid $2,100 to Michigan Utility Co. for utilities bill that was recorded in May as an Account Payable, Check #5278.Sold 2,000 DVD players on credit to Fort Motor Co. for $89.00 per unit, Invoice 5557.Purchased 1,800 docking stations on credit from Samsung for $42 per unit.A bankruptcy judge disallowed AC Speed's claim for $5,000 due from General Motors. Management Decided to write off this accounts receivable. AC Speed is behind in its mortgage payments to Bank of America. Paid a total of $10,000 ($2,000 principal and $8,000 interest), Check #5290. Paid the first month's principal payment of $15,000 on the note payable. In addition, paid one month's interest, Check #5293Issued bonds payable at face value for $350,000 *All purchases of inventory on account terms of 2/15, n/30AC Speed has earned one month of the prepaid rent received from their tenant at the beginning of June. Office Supplies - $2,465 AC Speed estimates bad debt expense on a monthly basis rather than waiting until year-end. The company uses the allowance method. Based on recent industry estimates, AC Speed estimates that the allowance account should be 2.5% of accounts receivable. Merchandise Inventory - $122,221 The Balance in the prepaid insurance account at the beginning of June represents 4 months of coverage. Record the amount of insurance for June. 1. The furniture and equipment for the warehouse was purchased a few years ago for $10,000. These assets have a 5-year life, an expected salvage value of $1,000, and are depreciated using the straight-line method. 2. The furniture and equipment for the office was purchased last year for $8,500. these assets have a 7 year life, an expected salvage value of $1,500, and are depreicated using stright-line method. a. When AC Speed purchases merchandise (inventory only) from a supplier or vendor on account, they receive credit terms of 2/15, net 30.b. You are also encouraged to use your textbook’s table of contents (front) or index (back) to locate helpful references.Spring/Summer 2014
ACCT202 simulation Project

ACCT202 simulation Project

Question # 00017552 Posted By: david8876 Updated on: 06/13/2014 10:42 AM Due on: 06/30/2014
Subject Accounting Topic Accounting Tutorials:
Question
Dot Image
Company Background & Scenario
The AC Speed Company is a well-established, publicly-held corporation, operating as a wholesaler in the auto parts industry. Specifically, AC Speed purchases auto parts from manufacturers and sells them to large business customers. Most purchases and sales are on account, with trade credit terms (specified below).
You’re a Davenport University student pursuing a bachelor’s degree in business and employed at the AC Speed Company this semester as an intern. You’ve worked in various departments and on several projects so far, learning a lot about the company’s business operations. Management seems impressed with your enthusiasm and the quality of your work.
The company’s accountant has just been called away for a family emergency and will likely be absent for a month or so. The General Manager asks you to take over the accountant’s regular duties on an interim basis. You’re nervous about doing so, but are confident that what you’ve learned in accounting class, plus your personal problem-solving skills, will make this a successful experience. What a great learning opportunity, not to mention an enhancement to your resume!
Project Overview & Instructions
A. Overview
a. Part 1 is a financial accounting activity that requires you to record various business transactions during the month, close the accounting records at the end of the month, and prepare the financial statements. These tasks relate to the steps in the accounting cycle that you learned in your first accounting course.`
b. Part 2 is an activity that requires you to analyze the company’s year-end financial statements to assist management in assessing the company’s position and making decisions about its future direction.
c. This is an individual, not a team, project. While you may discuss this project with others, you must prepare and submit your own work. Refer to the academic integrity statement in the project workbook.
d. Before starting work, review the entire project: all instructions, business transactions descriptions, workbook sections, check figures, due dates, and submission requirements.
B. General Instructions
a. The parts of this project, including specific business transactions and steps in the accounting cycle, must be completed in sequence. This is particularly important with business transactions relating to purchases and sales of inventory.
b. You are also encouraged to use your textbook’s table of contents (front) or index (back) to locate helpful references.
c. These project instructions will not address every detail of every task. If you have questions, ask your instructor.
d. Most of your work for this project will be accomplished in Excel. A basic skill level in this application is expected. That is, you should be able to such things as move around in a workbook, enter data in cells, use the sum function, compose basic formulas, and save your work.
e. If rounding is required, round to the nearest cent. For example, $96.835 would be entered as $96.84.
f. Use the check figures provided to check your work as you progress through the project. Investigate any discrepancies and correct them as you go along.
g. Refer to the project rubric to determine how components of the project will be assessed.
h. Appearance counts! Pay attention to the format, to spelling, and to other details of appearance. This reflects on management’s perception of you as a professional.
C. Submission Requirements
a. Final submission of all parts of this project must be in electronic (not paper) form. That is, you will submit your completed work via an assignment link in a Blackboard course site or via an email attachment. Follow your instructor’s directions.
b. Save backup copies of your work. If you have multiple versions of the project, clearly label them for your own reference and to ensure that you submit the appropriate version to your instructor.
c. You must read the academic integrity statement in the project workbook and enter your student ID number on the form to signify your agreement with and adherence to that statement. Final project submissions will not be accepted without this.
d. Due dates for the parts of this project will be provided by your instructor in the course syllabus, in the Blackboard course site, or in a designated handout. Be sure to enter these on your personal calendar and plan your work on this project accordingly.
D. Credit Terms & Inventory Accounting
a. When AC Speed purchases merchandise (inventory only) from a supplier or vendor on account, they receive credit terms of 2/15, net 30.
b. When AC Speed sells merchandise to a customer on account, they offer that customer credit terms of 2/30, net 45.
c. AC Speed accounts for the specific types of merchandise in their inventory with a set of subsidiary ledgers (inventory control cards). The balances in these subsidiary ledger records, in total, must equal the balance in the Merchandise Inventory account in the general ledger.
d. AC Speed uses a perpetual inventory accounting system and a last-in, first-out (LIFO) inventory costing method.
e. Subsidiary ledger records are kept for each customer and for each vendor. The balances in the customer subsidiary ledger records, in total, must equal the Accounts Receivable account balance in the general ledger. The balances in the vendor subsidiary ledger records, in total, must equal the Accounts Payable account balance in the general ledger.
E. Financial Accounting Steps:
a. Record each business transaction, in sequence by date, in the appropriate special journal or the general journal. Also, immediately record any transaction involving inventory, a customer, or a vendor in the appropriate subsidiary ledger record.
b. At the end of the month, post each entry in the general journal to the general ledger.
c. At the end of the month, total each column in each special journal and post that total to the general ledger. EXCEPT for entries in the “Other” columns, which must be posted individually to the general ledger.
d. When posting is completed, bring the balance in each general ledger account up to date.
e. When posting is completed, bring the balance in each subsidiary ledger account up to date.
f. At this point in the closing process, the balances of all subsidiary ledger accounts would be totaled and that total compared to the balance of the corresponding control account in the general ledger. That is, the total of inventory control cards would be compared to the Merchandise Inventory balance; the customer subsidiary ledger total to the Accounts Receivable balance; and the vendor subsidiary ledger total to the Accounts Payable balance. Any discrepancies would be investigated and corrected. Given the limited scope of this project scenario, reconciliation between subsidiary ledgers and control accounts is not possible.
g. List all general ledger account balances in the unadjusted trial balance columns of the worksheet. Use the sum function in Excel to total the debit and credit columns. These totals should be equal.
h. Prepare the end-of-month adjusting entries. Record these entries in the general journal and post them to the general ledger. Also record the adjusting entries in the designated columns in the worksheet and total the debit and credit columns. These totals should be equal.
i. Update general ledger account balances after posting adjusting journal entries.
j. Complete the unadjusted trial balance columns on the worksheet. Use Excel formulas to carry balances from the unadjusted trial balance columns, adjusting as necessary by entries in the adjustments columns. Check your results against the balances recorded in the general ledger.
k. Sort the dollars recorded in the adjusted trial balance columns into either the income statement or the balance sheet columns. Total these columns. The entry of net income should cause the debit and credit columns to equal one another.
l. Use the income statement information on the worksheet to prepare a multi-step income statement in good form. Look at examples of this income statement format in your textbook, such as the one on page 220.
m. Prepare a statement of retained earnings in good form. Look at examples of this statement in your textbook. Remember that net income from your just-completed income statement is a necessary component of this statement.
n. Use the balance sheet information on the worksheet to prepare a classified balance sheet, similar in format to the example on page 711. Remember that the ending retained earnings balance from the just-completed statement is a necessary component of the equity section of the balance sheet.
o. Prepare the end-of-month closing entries. Record these entries in the general journal and post them to the general ledger. Update balances in the general ledger accounts.
p. List the general ledger accounts that have balances other than zero on the post-closing trial balance. The totals of the debit column and the credit column should be equal.
F. Part 2 of this project requires you to analyze the company’s year-end financial statements to assist the management of AC Speed in assessing the company’s financial position and making decisions about its future direction.
a. Before beginning this part of the project, you will find it helpful to review Chapter 18 on financial statement analysis. Page 809, a summary of ratios, will be particularly useful.
b. Tabs in the project workbook provide trial balance data for the current and two preceding years for AC Speed and a location to calculation a selection of ratios. Use the trial balance data and the formulas in Chapter 18 to compute the ratios listed for each of the three years. YOU MUST STRUCTURE YOUR RATIO CALCULATIONS AS FORMULAS AND LINKS TO APPROPRIATE CELLS ON THE TRIAL BALANCE TAB. You will lose points by simply typing the final ratio numbers or percentages.
c. After you calculate the ratios, consider whether there is a trend over the three-year period. Also compare the ratios you calculated for AC Speed with those listed as industry averages. Review the information in Chapter 18 to help you determine what the ratios are telling you about various aspects of AC Speed’s business operations.
d. Use Word to prepare a memo (minimum 500 words) to AC Speed’s general manager, addressing the three questions listed at the bottom of the ratios tab. This should be formatted as a business memo, not an APA paper. Be sure to include a brief introduction and conclusion in the memo. Each question should be addressed in one or two paragraphs in the body of the memo. Remember that the general manager will expect details/facts/ratios to support statements you may make about the status of the business. Your writing should be concise, clear, and readable, with a fairly formal tone (since it’s addressed to AC Speed’s general manager, who is likely to share it with other members of management). Your instructor will provide the due date and submission requirements for this part of the project.
Dot Image
Attachments
ACCT202Simulation_SS2014_Student_(1)_(3).xlsx (236.92 KB)
Tutorials for this Question
  1. ACCOUNTS_GURU
    Tutorial # 00017002 Posted By: ACCOUNTS_GURU Posted on: 06/14/2014 09:07 AM
    Puchased By: 8
    Tutorial Preview
    The solution of ACCT202Simulation SS2014_Project...
      Get the Solution
    Attachments
    ACCT202Simulation_SS2014_Project.xlsx (257.06 KB)
  2. spqr
    Tutorial # 00214412 Posted By: spqr Posted on: 03/10/2016 04:55 PM
    Puchased By: 5
    Tutorial Preview
    The solution of ACCT202 simulation Project...
      Get the Solution
    Attachments
    ACCT202Simulation_SS2014_Project_(1).xlsx (257.06 KB)
Whatsapp Lisa