Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources
Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study
Go to the blog

Financial modeling using Microsoft excel, Assignments of Finance

Devi Ahilya VishwavidyalayaFinance

Financial modeling using Microsoft excel to analyse financial models

Typology: Assignments

2020/2021

Uploaded on 05/07/2021

karan-devnani
karan-devnani 🇮🇳

5

(1)

2 documents

1 / 11

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
TATA MOTORS
Mar-20 Mar-19
EQUITIES AND LIABILITIES
SHAREHOLDER'S FUNDS
Equity Share Capital 719.54 679.22
TOTAL SHARE CAPITAL 719.54 679.22
Reserves and Surplus 16,800.61 21,483.30
TOTAL RESERVES AND SURPLUS 16,800.61 21,483.30
TOTAL SHAREHOLDERS FUNDS 18,387.65 22,162.52
NON-CURRENT LIABILITIES
Long Term Borrowings 14,776.51 13,914.74
Deferred Tax Liabilities [Net] 198.59 205.86
Other Long Term Liabilities 1,646.56 404.11
Long Term Provisions 1,769.74 1,281.59
TOTAL NON-CURRENT LIABILITIES 18,391.40 15,806.30
CURRENT LIABILITIES
Short Term Borrowings 6,121.36 3,617.72
Trade Payables 8,102.25 10,408.83
Other Current Liabilities 10,180.46 7,765.57
Short Term Provisions 1,406.75 1,148.69
TOTAL CURRENT LIABILITIES 25,810.82 22,940.81
TOTAL CAPITAL AND LIABILITIES 62,589.87 60,909.63
ASSETS
NON-CURRENT ASSETS
Tangible Assets 19,540.25 18,316.61
Intangible Assets 5,667.73 3,970.22
Capital Work-In-Progress 1,755.51 2,146.96
Other Assets 0 0
FIXED ASSETS 29,702.78 28,573.42
Non-Current Investments 15,730.86 15,434.19
Deferred Tax Assets [Net] 0 0
Long Term Loans And Advances 138.46 143.13
Other Non-Current Assets 3,449.01 3,529.59
TOTAL NON-CURRENT ASSETS 49,021.11 47,680.33
CURRENT ASSETS
Current Investments 885.31 1,433.18
Inventories 3,831.92 4,662.00
Trade Receivables 1,978.06 3,250.64
BALANCE SHEET OF TATA MOTORS&(in
Rs. Cr.)
pf3
pf4
pf5
pf8
pf9
pfa

Partial preview of the text

Download Financial modeling using Microsoft excel and more Assignments Finance in PDF only on Docsity!

TATA MOTORS

Mar-20 Mar- EQUITIES AND LIABILITIES SHAREHOLDER'S FUNDS Equity Share Capital 719.54 679. TOTAL SHARE CAPITAL 719.54 679. Reserves and Surplus 16,800.61 21,483. TOTAL RESERVES AND SURPLUS 16,800.61 21,483. TOTAL SHAREHOLDERS FUNDS 18,387.65 22,162. NON-CURRENT LIABILITIES Long Term Borrowings 14,776.51 13,914. Deferred Tax Liabilities [Net] 198.59 205. Other Long Term Liabilities 1,646.56 404. Long Term Provisions 1,769.74 1,281. TOTAL NON-CURRENT LIABILITIES 18,391.40 15,806. CURRENT LIABILITIES Short Term Borrowings 6,121.36 3,617. Trade Payables 8,102.25 10,408. Other Current Liabilities 10,180.46 7,765. Short Term Provisions 1,406.75 1,148. TOTAL CURRENT LIABILITIES 25,810.82 22,940. TOTAL CAPITAL AND LIABILITIES 62,589.87 60,909. ASSETS NON-CURRENT ASSETS Tangible Assets 19,540.25 18,316. Intangible Assets 5,667.73 3,970. Capital Work-In-Progress 1,755.51 2,146. Other Assets 0 0 FIXED ASSETS 29,702.78 28,573. Non-Current Investments 15,730.86 15,434. Deferred Tax Assets [Net] 0 0 Long Term Loans And Advances 138.46 143. Other Non-Current Assets 3,449.01 3,529. TOTAL NON-CURRENT ASSETS 49,021.11 47,680. CURRENT ASSETS Current Investments 885.31 1,433. Inventories 3,831.92 4,662. Trade Receivables 1,978.06 3,250. BALANCE SHEET OF TATA MOTORS (in Rs. Cr.)

Mar-20 Mar-19 Mar- 12 mths 12 mths 12 mths INCOME 43,485.76 68,764.88 58,234. 0 0 793. 43,485.76 68,764.88 57,441. 43,928.17 69,202.76 58,831. Other Income 1,383.05 2,554.66 1,557. TOTAL REVENUE 45,311.22 71,757.42 60,389. EXPENSES Cost Of Materials Consumed 26,171.85 43,748.77 37,080. Operating And Direct Expenses 830.24 571.76 474. 722.68 144.69 842. Employee Benefit Expenses 4,384.31 4,273.10 3,966. Finance Costs 1,973.00 1,793.57 1,744. 3,375.29 3,098.64 3,101. Other Expenses 7,959.75 9,895.68 9,251. TOTAL EXPENSES 49,927.64 69,155.42 60,369. -4,616.42 2,602.00 19. Exceptional Items -2,510.92 -203.07 -966. PROFIT/LOSS BEFORE TAX -7,127.34 2,398.93 -946. Current Tax 33.05 294.66 92. Less: MAT Credit Entitlement 0 0 0 Deferred Tax 129.24 83.67 -4. Tax For Earlier Years 0 0 0 TOTAL TAX EXPENSES 162.29 378.33 87. -7,289.63 2,020.60 -1,034.

PROFIT & LOSS ACCOUNT OF

TATA MOTORS (in Rs. Cr.) REVENUE FROM OPERATIONS [GROSS] Less: Excise/Sevice Tax/Other Levies REVENUE FROM OPERATIONS [NET] TOTAL OPERATING REVENUES Changes In Inventories Of FG,WIP And Stock-In Trade Depreciation And Amortisation Expenses PROFIT/LOSS BEFORE EXCEPTIONAL, EXTRAORDINARY ITEMS AND TAX TAX EXPENSES-CONTINUED OPERATIONS PROFIT/LOSS AFTER TAX AND BEFORE EXTRAORDINARY ITEMS

12 mths 12 mths

  • Cash And Cash Equivalents 3,532.19 1,306.
  • Short Term Loans And Advances 232.14 200.
  • OtherCurrentAssets 3,109.14 2,376.
  • TOTAL CURRENT ASSETS 13,568.76 13,229.
  • TOTAL ASSETS 62,589.87 60,909.
  • Mar-18 Mar-17 Mar-
  • 679.22 679.22 679.
  • 679.22 679.22 679.
  • 19,491.76 20,483.39 22,582.
  • 19,491.76 20,483.39 22,582.
  • 20,170.98 21,162.61 23,262.
  • 13,155.91 13,686.09 10,599.
  • 154.61 147.58 71.
  • 502.37 1,451.47 3,289.
  • 1,009.48 892.18 750.
  • 14,822.37 16,177.32 14,712.
  • 3,099.87 5,158.52 3,654.
  • 14,225.63 11,462.24 5,141.
  • 6,030.53 4,440.42 9,455.
  • 862.92 477.17 450.
  • 24,218.95 21,538.35 18,701.
  • 59,212.30 58,878.28 56,676.
  • 18,192.52 17,897.13 17,573.
  • 3,411.23 2,875.80 3,502.
  • 1,371.45 1,902.61 1,557.
  • 26,800.35 28,043.92 26,762.
  • 14,260.79 14,858.39 15,217.
  • 143.96 391.46 252.
  • 3,035.54 2,827.44 2,581.
  • 44,240.64 46,121.21 44,814.
  • 2,502.78 2,437.42 1,745.
  • 5,670.13 5,553.01 5,117.
  • 3,479.81 2,128.00 2,045.
  • 795.42 326.61 788.
  • 140.27 215.96 484.
  • 2,383.25 2,096.07 1,679.
  • 14,971.66 12,757.07 11,861.
  • 59,212.30 58,878.28 56,676.
  • Mar-17 Mar-
  • 48,078.77 46,883.
  • 4,738.15 4,538.
  • 43,340.62 42,345.
  • 44,316.34 42,845.
  • 981.06 1,402.
  • 45,297.40 44,247.
  • 27,651.65 24,997.
  • 454.48 418.
  • -252.14 10.
  • 3,764.35 3,188.
  • 1,569.01 1,592.
  • 3,037.12 2,329.
  • 8,083.12 8,216.
  • 47,311.96 43,820.
  • -2,014.56 427.
  • -338.71 -271.
  • -2,353.27 155.
  • 57.06 -7.
  • 19.27 2.
  • 76.33 -4.
  • -2,429.60 160.

Very Low Very Low Very Low Very Low 0.377238692920256 0.373452375918723 0.384060002601269 0. Low Liquidity Low Liquidity Low Liquidity Low Liquidity 2.40390805785405 1.74831697839415 1.93551924596623 1. Greater Risks Within Safety Margin Within Safety Margin Within Safety Margin 0.293839881757224 0.259504121105316 0.250325861349753 0. Good Good Good Good 0.136849197352118 0.056955704702668 0.032842877168498 0. Low Liquidity Low Liquidity Low Liquidity Low Liquidity -12,242.06 -9,711.51 -9,247.29 -8,781. Low Working Capital Low Working Capital Low Working Capital Low Working Capital 0.4999490198904 0.583703154325049 0.576423234700307 0. Low ROI Low ROI Low ROI Low ROI 0.293779967908545 0.363859048232603 0.340655235483168 0. High use of Debts High use of Debts High use of Debts High use of Debts 0.694773131818296 1.12896564960253 0.970086451632516 0. Low Returns Low Returns Low Returns Low Returns 0.887082320249378 1.44220646123884 1.29837746470214 0. Low Returns High Returns to Asset High Returns to Asset Low Returns -16.7632576733165 2.93841856482553 -1.80158614788553 -5.

Very Low

Low Liquidity

Within Safety Margin

Good

Low Liquidity -6,840. Low Working Capital

Low ROI

High use of Debts

Low Returns

Low Returns -0.