Section outline

  • -      To appreciate the modeling of accounts to create a comprehensive AIS.

    -      Create and maintain various ledger accounts

    -      Construct Loan Amortization Schedules:

    -      Manage Asset Schedules

    -      Prepare Final Accounts

    -      Apply Best Practices in Excel Accounting Modeling


    • Financial Accounting systems File

      The main purpose is to Prepare a financial accounting model in  Microsoft Excel.

    • Financial Accounting model in Excel Illustration One File
      Using the financial transactions given to prepare financial statements. 
    • Q1. SUPREX, a limited liability company File

      Use the information provided by the Cashier of Suprex Co Limited to :

      To Prepare (a) General Journal (b) the statement of profit or loss and (c) the statement of financial position of SUPREX Co as at 31 October 2020

    • Depreciation Model File

      A motor vehicle costing of 60 m has an estimated life of 5 years and a residual value of 7m. Calculate the annual depreciation using a straight line method.