TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat DC
      • Lightroom Classic CC 2018
      • Photoshop 2021
      • Photoshop 2020
      • Photoshop CC 2018
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 2019
      • Sage 50 2018
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

Microsoft Excel for Lawyers: Using the Law Firm Financial Analysis Worksheet

by Keeley Byrnes / Thursday, November 07 2013 / Published in Latest, Microsoft Excel Training for Lawyers

Microsoft Excel contains law firm templates that can be used by law firms, attorneys, lawyers, and anyone who practices law. In this post, we will cover the usage of the Law Firm Financial Analysis Worksheet.

 

 

 

 

 

 

Using the Law Firm Financial Analysis Worksheet

Let’s examine the structure and usage of the “Law Firm Financial Analysis Worksheet.” This workbook allows you to enter detailed financial information about your law firm, so that you can analyze the results in order to make better business decisions. You should first note that there are seven color-coded worksheets shown on the tabs at the bottom of the workbook. Information that is recorded within the “Actuals,” “Project Parameters,” “Actual Totals,” and “Monthly Billings” worksheets is then used by the charts shown within the “Billing Timeline,” “Account Billing,” and “Skill Type Billing” worksheets. Note that some sample data has been included within the data entry worksheets so that you can more easily understand how the worksheets function together.

Let’s begin by examining the “Project Parameters” worksheet. Within this worksheet you will list each project by general project type that your firm handles. The sample data is shown in cells A7 through A12. For each project type listed, you then input what percentage of the total hours of the project is performed by each general type of skilled worker, which are listed in cells B6 through G6. The percentages are then entered into the intersecting cells. For each skilled worker listed, you can then enter the billing rate into the “Blended Rate” cells in cell range B13 through G13. This rate is the average billing rate for someone with the selected skill set. Once this information has been entered, it will then be referenced by the other worksheets to determine project billing information. Note that you can also add columns and rows as needed in order to accommodate your law firm’s business needs.

The next sheet we will examine is the “Actuals” worksheet. Within this worksheet, you enter the names of the individual projects that your firm handles into the cells shown in column A within the table. Note that you should also enter the name of each project into the corresponding cells within column A on the “Actual Totals” and “Monthly Billing” worksheets, as well.

Then, back on the “Actuals” worksheet, you enter the project type for the project into the adjacent cell in column B. Note that each project type must correspond to one of the project types that you created in column A of the “Project Parameters” worksheet. You can then input the “Actual Start” and “Actual Finish” dates for the project. When you input the values into these columns, Excel will then calculate the “Duration” shown in column F. After that, enter the total number of work hours on the project into the “Actual Work” column. As you enter the total work for each project, you will see the grand total of work hours displayed at the bottom of column E.

As you complete the data entry listed, the values shown within all of the other spreadsheets will calculate themselves. This is the data that is then used for the financial analysis of your projects. If you view the “Actual Totals” worksheet, you will see the total amounts billed for each general type of skilled worker for each project. The data shown here is derived from the values entered on the “Actuals” and “Project Parameters” worksheets. You will also see the “Month of Completion” for each project, as well as grand totals for all values listed.

You can then click to the “Monthly Billings” worksheet to view the amounts billed for each project broken down by month of completion.  If you click the “Billing Timeline” worksheet, you can view a line chart that displays the monthly billings for your firm. This is a chart that represents the data shown within the “Monthly Billings” worksheet.

You can click the “Account Billing” worksheet to view a chart that shows billing amounts by project. This chart is derived from the data shown within the “Actual Totals” worksheet. You can also click the “Skill Type Billing” worksheet to view a pie chart that displays total billing by general skill type. This information is taken from the “Actual Totals” worksheet. Note that you can enter your company’s name in cell A1 within the “Actuals” through “Monthly Billings” worksheets.

You can also right-click the “Your logo here” picture box at the top of those worksheets and then select the “Change picture…” command from the pop-up menu that appears in order to open a dialog box that allows you to select a picture of your company’s logo to add to these sheets, if desired.

Tagged under: 2013, attorney, education, excel, financial analysis, lawyer, lawyers, legal, microsoft, template, worksheet

About Keeley Byrnes

Keeley is our Director of Marketing and has been with TeachUcomp since 2010. Keeley manages all aspects of our Marketing Department, acts as liaison for our reseller and affiliate partners and also authors courses in software and taxation.

What you can read next

A picture of a user saving a draft email in Outlook.
Save a Draft Email in Outlook – Instructions
Using the Calendar Feature in Microsoft Outlook 2013
A picture of a user changing the chart settings after they insert a modern chart in Access.
Insert a Modern Chart in Access- Instructions

 

Recent Posts

  • A picture that shows how to create moving elements in Photoshop Elements.

    Moving Elements in Photoshop Elements – Instructions

    Overview of How to Create Moving Elements in Ph...
  • Layer Types in Photoshop Elements: A picture of a user simplifying a Smart Object layer in Photoshop elements.

    Layer Types in Photoshop Elements- Instructions

    Overview of the Layer Types in Photoshop Elemen...
  • A picture of the training interface for the digital download or DVD versions of our Photoshop Elements training, titled “Mastering Photoshop Elements Made Easy™ v.2023.”

    Photoshop Elements Training

    Photoshop Elements Training for Photoshop Eleme...

Categories

Archives

  • GET SOCIAL

© 2001-2023 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Sale! $49 All-Access 0 Days 0 Hours 18 Minutes 19 Seconds      $199 $49 Entire Library!
See Deal