Docsity
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

Financial modeling using Microsoft excel, Assignments of Finance

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.