The writer is very fast, professional and responded to the review request fast also. Thank you.
Presentation/PPT
27/08/2022
I don’t normally ask for help but I’ve got to finish this & with working, kids and a house to take care of I’m just having a hard time getting this done. A little confused on the assignment, would appreciate any help. Thanks! SUBDOMAIN 319.1 – ACCOUNTING & FINANCESUBDOMAIN 319.2 – INFORMATION TOOLSCompetency 319.1.2: Ratios – The graduate determines the financial condition of a firmusing financial ratios and other financial data.Competency 319.2.1: Technology Tools – The graduate uses information technologytools for specified business purposes.Objectives:319.1.2-04: Determine a firm’s financial condition by calculating and benchmarkingspecified ratios against other companies in the industry.319.2.1-01: Use the Internet to gather information on a specified business topic.319.2.1-02: Produce business letters or memorandums using a word processingapplication.319.2.1-03: Develop a spreadsheet report that solves a business problem.Introduction:Company G operates a small chain of wholly owned home centers selling to consumers andcontractors. Sales volume varies among the individual stores and ranges between $11million and $20 million per year. The company is organized as a corporation and does notoperate as a sub-chapter S corporation.Given:Consolidated financial statements for Company G are shown on the attached “StatementAnalysis Template.”• All figures on the income statements and the balance sheets are shown in thousandsof dollars.• Sales volume shown is net sales.• During Year 12 60% of net sales were on a credit basis.• Inventory is stated at cost on a first-in, first-out basis.• Depreciation expense totaled $1,875,000 for Year 12 and $1,644,000 for Year 11.• Depreciation expense is not shown as a separate item on the income statements butis included in store operating expense and general and administrative expense.• Depreciable assets are depreciated using the straight-line method over the estimateduseful life of the assets.• The market value for the company common stock at the end of Year 11 was$3.50/share and at the end of Year 12 it was $5.75/share.For this task, you will use financial statements and pertinent industry data to interpretCompany G’s financial condition. The required ratios have been calculated for Year 11 andare shown on the attached “Statement Analysis Template.”Ratios gathered from financial statements that were submitted to banks and other financinginstitutions by a large number of home centers are also included on the template. Whereavailable, the ratios are shown by first, second, and third quartiles. The industry ratiosincluded on the template were generated from statements submitted by stores with annualsales between $10 million and $24 million.As you develop your response, you should consider Company G trends by comparing Year12 ratios to the same ratios for Year 11, consider what is depicted by the horizontalanalysis, and benchmark Company G’s performance and condition by comparing Year 12ratios with the same ratios for the home center industry.Task:A. Calculate each of the thirteen indicated ratios for Year 12 indicated in the attached“Statement Analysis Template.” Complete the attached spreadsheet with thisinformation.B. Complete a horizontal analysis of the income statements using the attached spreadsheetwith this information.Note: Round the percentages to the nearest hundredth of a percent, i.e. 6.84%.Answers like 6.80% or rounded up to 7% are not acceptable.C. Complete a horizontal analysis of the balance sheets using the attached spreadsheetwith this information.Note: Round the percentages to the nearest hundredth of a percent, i.e. 6.84%.Answers like 6.80% or rounded up to 7% are not acceptable.D. Write a business memorandum to the CEO of Company G (suggested length of 2–3pages) in which you:1. Explain for each ratio and trend whether the ratio or trend indicates a strength of thecompany; a likely weakness, threat, or emerging problem; or a satisfactory conditionthat management should not view as a strength or weakness (i.e., no concern).2. Justify your identification of each ratio or trend as a strength, weakness, orsatisfactory condition (i.e., no concern).3. Evaluate the Company G ratios and trends against the ratios and trends for the homecenter industry.• Include the URL where you found the information you have entered on thetemplate.Note: Information on trends can be gathered through Internet research. Please consider,however, that ratios you find on the Internet are generally computed as of the current dateso ratios on the task might not match the numbers you see in your research. It is best toconsider the data based on the trends you see for the industry and how Company G is doingrelated to those trends.E. If you choose to use outside sources, include all in-text citations and references in APAformat.
Show more
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more