I need help with the attached project. Please adhere to the directions provided. The instructions are also included in the attached file. Thanks for your help. Davenport University: ACCT202 Project -...

Instructions
    Davenport University: ACCT202 Project - Part III
    *Part III is completely independent of parts I and II and cannot be used to check answers for this parts.
    Part III - READ ALL INSTRUCTIONS - COMPLETELY SEPARATE FROM PARTS I & II
    Financial Statement Analysis
    a. Within this workbook there is a worksheet labeled "Adjusted Trial Balances". Within that worksheet you will find fully completed trial balances for 5 years. Also within this workbook you will find worksheets for comparative income statements and comparative balance sheets.Using the trial balances or comparative financial statements you need to calculate a variety of ratios. You will find the required ratios in the worksheet labeled "Ratios Historical". Complete all the required ratios AND analysis (see Ratios Historical worksheet). You MUST use formulas and/or linking to compute your ratios. You cannot simply hard key the answers. You must reference the appropriate data from the trial balances or comparative financial statements.
    b. After completing all of your ratio calcualtions, analyze the results in comparison to prior years and industry averages. Write a business memo explaining your findings. Your memo must be written in Word and follow normal business memo conventions - use word memo templates for this. There is not a length requirement, however you will be graded upon the substance of your analysis.
Adjusted Trial Balances
            August 31, 2020        August 31, 2019        August 31, 2018        August 31, 2017        August 31, 2016
            Adjusted        Adjusted        Adjusted        Adjusted        Adjusted
            Trial Balance        Trial Balance        Trial Balance        Trial Balance        Trial Balance
    Acct. No.    Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr.    Dr.    Cr.    Dr.    Cr.
    100    Cash    334,504.00        361,264.32        404,616.04        441,031.48        432,210.85
    102    Accounts Receivable, net    533,086.00        575,732.88        644,820.83        702,854.70        688,797.61
    104    Merchandise Inventory, net    449,397.00        485,348.76        543,590.61        592,513.77        580,663.49
    106    Office Supplies    5,689.00        6,144.12        6,881.41        7,500.74        7,350.73
    107    Prepaid Insurance    15,400.00        16,632.00        18,627.84        20,304.35        19,898.26
    120    Investments - Equity Trading (Temporary)    120,000.00        129,600.00        145,152.00        158,215.68        155,051.37
    121    Investments - HTM Long Term    35,400.00        38,232.00        42,819.84        46,673.63        45,740.15
    122    Investments - Equity Long Term    80,000.00        86,400.00        96,768.00        105,477.12        103,367.58
    123    Valuation Allowance     52,000.00        56,160.00        62,899.20        68,560.13        67,188.93
    140    Land    1,550,000.00        1,674,000.00        1,874,880.00        2,043,619.20        2,002,746.82
    145    Building    1,200,000.00        1,296,000.00        1,451,520.00        1,582,156.80        1,550,513.66
    146    Accumulated Depreciation - Building        750,000.00        810,000.00        907,200.00        988,848.00        969,071.04
    151    Equipment     85,000.00        91,800.00        102,816.00        112,069.44        109,828.05
    152    Accumulated Depreciation - Equipment        68,000.00        73,440.00        82,252.80        89,655.55        87,862.44
    153    Office Furniture    14,000.00        15,120.00        16,934.40        18,458.50        18,089.33
    154    Accumulated Depreciation - Office Furniture        12,000.00        12,960.00        14,515.20        15,821.57        15,505.14
    201    Accounts Payable        680,980.00        735,458.40        823,713.41        897,847.61        879,890.66
    202    Wages Payable
    203    Interest Payable
    204    Dividends Payable
    205    Unearned Rent        10,000.00        10,800.00        12,096.00        13,184.64        12,920.95
    206    Customer Refunds Payable        18,795.00        20,298.60        22,734.43        24,780.53        24,284.92
    250    Notes Payable - Long Term        650,000.00        702,000.00        786,240.00        857,001.60        839,861.57
    251    Bonds Payable        1,300,000.00        1,404,000.00        1,572,480.00        1,714,003.20        1,679,723.14
    252    Premium on Bonds Payable        56,000.00        60,480.00        67,737.60        73,833.98        72,357.30
    253    Discount on Bonds Payable    16,000.00        17,280.00        19,353.60        21,095.42    - 0    20,673.52
    252    Mortgage (Warehouse) Payable        300,000.00        324,000.00        362,880.00        395,539.20        387,628.42
    300    Common Stock, $1 Par, 100,000 Authorized; 50,000 shares Issued/Outstanding        50,000.00        50,000.00        50,000.00        50,000.00        50,000.00
    301    Paid In Capital - Excess of Par, Common Stock        347,575.25        381,694.33        361,143.16        490,813.03        484,375.09
    330    Retained Earnings        324,582.75        388,687.17        329,202.03        308,639.67        294,694.17
    331    Cash Dividends    250,000.00        300,000.00        200,000.00        200,000.00        200,000.00
    340    Treasury Stock    50,000.00        60,000.00        20,000.00        20,000.00        10,000.00
    500    Sales        4,156,800.00        4,406,208.00        4,846,828.80        4,119,804.48        3,996,210.35
    600    Cost of Goods Sold    1,385,698.00        1,468,839.88        1,615,723.87        1,373,365.29        1,332,164.33
    700    Wage Expense (hourly workers)    756,894.00        802,307.64        882,538.40        750,157.64        727,652.91
    701    Salaries Expense (Exempt Staff)    800,000.00        848,000.00        932,800.00        792,880.00        769,093.60
    702    Marketing Expense    295,000.00        312,700.00        343,970.00        292,374.50        283,603.27
    703    Travel and Entertainment Expense    56,789.00        60,196.34        66,215.97        56,283.58        54,595.07
    704    Bad Debt Expense    42,185.00        44,716.10        49,187.71        41,809.55        40,555.27
    705    Property Tax Expense    500,000.00        530,000.00        583,000.00        495,550.00        480,683.50
    706    Office Maintenance & Repair Expense    2,000.00        2,120.00        2,332.00        1,982.20        1,922.73
    707    Accounting...