WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Accounting Tutorials » Assets Tutorials » Total Assets Formula

Total Assets Formula

What is Total Assets Formula?

Assets are defined as resources owned by the company from which future economic benefits are expected to be generated. Total assets are the sum of non-current and current assets, and this total should equal the sum of stockholders’ equity and total liabilities combined.

The formula for Total Asset is:

Total Assets = Non Current Assets + Current Assets

Total Assets Formula

Note:

  • Current Assets: Current Assets are those assets that are expected to be converted into cash or cash equivalents within one financial year.
  • Non-Current Assets: Non-Current Assets are those assets that a company holds for more than one financial year, which are not readily convertible into cash or cash equivalents.

Examples of Total Assets Formula (with Excel Template)

Let’s see some simple to advanced examples of total assets equation to understand it better.

You can download this Total Assets Formula Excel Template here – Total Assets Formula Excel Template

Example # 1

The following are the asset details of a small manufacturing company for the year ended 31st March 2019.

  • Land = Rs.10,00,000
  • Machinery = Rs.5,00,000
  • Buildings = Rs.6,00,000
  • Sundry Debtors = Rs.2,00,000
  • Inventory = Rs.3,50,000
  • Cash & Bank = Rs.1,00,000

Solution:

Use the following data for the calculation of total assets.

Total Assets Formula Example 1

So, the calculation of total assets can be done as follows –

Example 1.1

Total Assets = Land + Buildings + Machinery + Inventory + Sundry Debtors + Cash & Bank

Total Assets = 1000000+600000+500000+350000+200000+100000

In the above total assets formula, non-current assets are Land, Buildings & Machinery, otherwise known as fixed assets.

Total Assets will be –

Total Assets Formula Example 1.2

Total Assets = 2750000

Hence, the total assets would be calculated as Rs. 27,50,000.

Example # 2

The following are the asset details of a medium-sized company for the year ended 31st March 2019.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • Land = Rs.20,00,000
  • Inventory = Rs. 40,00,000
  • Buildings = Rs.60,00,000
  • Sundry Debtors = Rs. 30,00,000
  • Vehicles = Rs.22,00,000
  • Cash & Bank = Rs. 25,00,000

Solution:

Note:

  • Accumulated Depreciation on Buildings = Rs. 20,00,000
  • Accumulated Depreciation on Vehicles = Rs. 6,00,000
  • Accumulated Depreciation on Machinery = Rs. 3,50,000

 

So, the calculation of total assets can be done as follows –

Total Assets Formula Example 2.0.1

Total Assets = Land + Buildings – Acc. Depreciation on Buildings + Vehicles – Acc. Depreciation on Vehicles + Machinery – Acc. Depreciation on Machinery + Inventory + Sundry Debtors + Cash & Bank

Total Assets = 2000000+6000000-2000000+2200000-600000+1500000-350000+4000000+3000000+2500000

Total Assets will be –

Example 2.0.2

Total Assets = 18250000

Hence, the total assets would be calculated as Rs. 1,82,50,000.

In this example, we are observing the concept of Gross vs. Net Book Value. While calculating total assets, it is important to note that the fixed assets should be stated at Net Value (Gross Value – Accumulated depreciation). It is assumed that the building, vehicle and machinery value provided is gross (at cost).

Hence, In the above total assets equation – Accumulated depreciation(Building, Vehicles, machinery) are subtracted from the gross value.

Example # 3

The following are the asset details of a large company for the year ended 31st March 2019.

  • Land =Rs.5,00,000
  • Inventory =Rs. 50,00,000
  • Buildings =Rs.70,00,000
  • Sundry Debtors =Rs. 20,00,000
  • Vehicles =Rs.12,00,000
  • Cash & Bank =Rs. 32,00,000
  • Furniture =Rs.40,00,000
  • Prepaid Expenses =Rs. 10,00,000
  • Bills Receivable =Rs.15,00,000
  • Bad Debts Provision =Rs. 1,50,000

 

So, the calculation of total assets can be done as follows –

Example 3.1

Total Assets = Land + Buildings + Vehicles + Furniture + Bills Receivable + Inventory + Prepaid Expenses + Sundry Debtors – Bad Debts Provision + Cash & Bank

Total Assets = 500000+7000000+1200000+4000000+1500000+5000000+1000000+2000000+3200000-150000

Total Assets will be –

Total Assets Formula Example 3.3

In the above total assets equation, current assets are Bills Receivable, Inventory, Prepaid Expense, Sundry Debtors, and Cash & Bank.

Total Assets = 25250000

Hence, the total assets would be calculated as Rs. 2,52,50,000.

In the above example, it is important to note the following distinctive assets:-

  • Bills receivable are bills of exchange against which the company will receive payment in the future. Generally, these are issued when the company has provided a credit sale (i.e., with no inflow of cash on sales).
  • Prepaid expenses reported as a current asset, represents the amount of prepaid expense which will be used up within one (current) financial year. This represents the payment made by the company for goods or services to be received in the future.
  • Debtors are to be stated at ‘net value,’ which is after subtracting the provision for bad and doubtful debts. This provision indicates the extent of receivables which the company is not confident of retrieving from the debtors.

Example # 4

The following are the asset details of a large manufacturing company for the year ended 31st March 2019.

  • Land = Rs20,00,000
  • Inventory = Rs. 40,00,000
  • Buildings = Rs60,00,000
  • Sundry Debtors = Rs. 30,00,000
  • Vehicles = Rs22,00,000
  • Cash & Bank = Rs. 25,00,000
  • Furniture = Rs15,00,000
  • Trademarks = Rs. 27,00,000
  • Investments = Rs40,00,000
  • Goodwill= Rs. 6,50,000
  • Machinery = Rs80,00,000

Note:

  • Accumulated Depreciation on Buildings = Rs. 20,00,000
  • Accumulated Depreciation on Vehicles = Rs. 6,00,000
  • Accumulated Depreciation on Machinery = Rs. 3,50,000
  • Furniture was purchased on the last day of the financial year.

Solution:

 

So, the formula of total assets and calculation can be done as follows –

Total Assets Formula Example 4.1

Total Assets = Land + Buildings – Acc. Depreciation on Buildings + Vehicles – Acc. Depreciation on Vehicles + Machinery – Acc. Depreciation on Machinery + Furniture + Investments + Trademarks + Goodwill + Inventory + Sundry Debtors + Cash & Bank

Total Assets = 2000000 + 6000000 + 2200000 +8000000 + 1500000 + 4000000 + 2700000 +650000 + 4000000 + 3000000 + 2500000 – 2000000 – 600000 – 3500000

Total Assets will be –

Example 4.2

Total Assets = 30450000

Hence, the total assets would be calculated as Rs. 3,04,50,000.

In the above example, it is important to note the following distinctive assets:-

  • Since the furniture was purchased on the last day of the financial year, there was no depreciation for the same.
  • Investments may be considered as long-term since no specification is made regarding the same. This indicates they are assets that a company intends to hold for more than a year, i.e., securities, real estate, etc.
  • Trademarks are intangible assets that represent the legal right to use a name, logo, or other identifiers in business. When a trademark is assigned a value as in this example, it is usually the fair value of the same when purchased from someone else.
  • Goodwill is also an intangible asset that represents the difference between the market value of the company and book value of assets (as per Balance Sheet).

Conclusion

The various types of assets can be categorized into Non-Current and Current. This would be dependent on their usage and significance to the operations of the company. Broadly, however, total assets are calculated by the summation of all value of current and non-current assets after adjusting for accumulated depreciation and any write-off or provision of receivables. Other variations are dependent on the applicability of accounting standards.

Recommended Articles

This has been a guide to Total Assets Formula. Here we discuss how to calculate total assets along with examples and downloadable excel template. You can learn more about financial analysis from the following articles –

  • Return on Total Assets Calculation
  • Methods of Goodwill Amortization
  • Formula of Net Asset
  • Complete List of Current Assets
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Total Assets Formula Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More