FRX2Any 

v.12.14.01 DEMO

                MANAGEMENT     NMG-NORTHP3 16/07/19

CHANAKYA Cash Statement
THE BUSINESS DECISION GAME
  4-NTPC Ltd.
                             REPORT DESCRIPTION CU

Operation Cash  Inflows 6,890,208
Income Statement
Sales Revenue Collection
Results of Quarter

C4 Current Quarter 6,890,208
Previous Quarter 0
DESCRIPTION CU
2 Operation Cash Outflows
RM & FG Procurement 
3,798,203

    Current Quarter 730,680
INCOME
    Previous Quarter 318,000
Balance Sheet Net Sales Revenue 6,890,208 Packaging
Other Income 0     Current Quarter 368,500
DESCRIPTION CU    Previous Quarter 0
Total Income 6,890,208
Warehousing Charges 36,504
Share Holders' Funds EXPENSES
Production Overheads 1,100,000
Equity Share Capital (FV=10) 4,500,000 FG Op Inv (incl  FG Proc) 42,828
Selling, Dist  and Admin costs 1,244,519
Res & Surplus or Ret Earnings 1,535,051 1,845,450
Raw Materials Consumed 0
(Eq share prem: 0.00 ) Information Package
+Packaging cost 368,500 0
Preference Share capital Product Design & Certification
0 =Total Direct Costs 2,213,950 Interest Flows 29,023
( )
(Pr. share prem: 0.00 ) +Warehousing Charges 36,504 Net Interest Paid
0
Loan Funds +Production Overheads 1,100,000 Interest on Bank OD
0 29,023
Two Year Term Loan =Cost of Production (CoP) 3,350,454 Interest on Term loans
0 Interest on Bonds 0
Three Year Term Loan Goods Available for Sale (Op+CoP) 3,393,282
Bonds 0 Shark Loan Interest 0
Less FG Closing Inventory 676,862
Total Sources 6,035,051 2,716,419 Income from Investments (+) 0
=Cost of Goods Sold
Fixed Assets Gross Profits
4,173,788 Corporate Tax 371,936
3,875,000 1,244,519 Ext item,inv writeoff, disband(+/-) 0
Assembly Plant (incl Plant under inst) Selling, Dist  & Admin Expenses
  less Accumulated Depreciation 987,500 0 Net Operational Flows
Bad Debts 2,691,044
Machinery (incl Mach under instal) 3,250,000 Cash Discount+Bill Disc Chges 0 Appropriations
  less Accumulated Depreciation 525,000 0 Preference Dividend 0
Information Package
Total Fixed Assets 5,612,500 0 Equity Dividend 0
Research & Develpment
2,929,268 Capital Inflows
Investments & Vendor Deposits 0 EBITDA
Depreciation & GW amortization 712,500   Overdraft and Loans Taken 0
Current Assets 1,176,773
EBIT Capital Raised
676,773 2,216,768 0
RM+FG Inv Pref Shares Issued
Bank Overdraft Interest 0
Accounts Receivables 0 Equity Shares Issued 0
Shark Loan Interest 0
Cash on Hand 500,000 Capital Outflows
2/3 year Term Loan Interest 29,023 0
Less Current Liabilities Investments
754,221 Bond Interest 0
Accounts Payables Principal Repayments 838,232
730,680 Misc Exp, Royalty, TM etc 700,000 0
Maturing Term Loans Shark Loan Repayed
0 Total Financial Expenses 1,500,000
729,023 Cap Expenditure
Bonds maturing 0 Corporate Tax 371,936 Net Capital Flows -2,338,232
Bank Overdraft 0 Ext item,Inv write off, disband 0
Shark Loans 23,540 Profit After Tax (PAT)
1,115,808 700,000
Appropriations Misc Exp, Royalty, TM etc
Total Net Current Assets 422,551
Total Application of Funds Dividend on Preference Shares 0 Opening Balance Cash 823,647
6,035,051 0 Shark Loans Raised 23,540
Dividend on Equity Shares
Net Income to Retained Earnings 1,115,808 Closing Balance 500,000

SUMMARY OF OUTSTANDING  TERM LOANS  & BONDS (PLR +  %) Inventory Data (ID)
# AMOUNT INTRATE DURATION ENDS IN AMOUNT DUE EQI Finished Goods MinAqu ZCal Juicy Spark

Order Enq Recd  Dom(units) 4,937 3,745 4,834 685

Opening Inventory (units) 392 163
Actual Production (units) 6,500 5,100 7,200 1,200
Equivalent Capacity Used 6,500 5,100 7,200 1,200
Proc from Contract Mfg (units)
Sale Dom + Export+Var (units) 4,945 3,745 5,029 752
FG Closing Inventory (units) 1,947 1,518 2,171 448
Material Consumed   / unit
Water 9.00 8.00 6.00 6.00
Add 1.00 2.00 4.00 5.00
Material Consumed (units)
Water 58,500 40,800 43,200 7,200
Add 6,500 10,200 28,800 6,000
Report  on the Market submitted by : Your Corporate Planning Dept
Packaging Cost/Unit 11.00 22.00 22.00 22.00
Forecast of General Economic Environment Your Direct Cost pu 76.94 104.21 137.20 158.50
Avg Ind  Selling Price CU 223.18 276.09 793.18 1,733.36
Qrtr-> 2 3 Your Market Share (%)(units) 8.00 9.00 11.00 12.00
4 5 6
Index (Base )
Raw Material Numbers Value Cu.
105 106 109 112 114 Water Add Water Add
GDP
STK IDX 13500 13650 13750 13800 13950 Opening Inventory 19,200 384,000
CPI 104 106 106 107 108 Fresh Purchases 149,700 32,300 748,500 712,861
IIP 104 105 108 108 110 Consumption 149,700 51,500 748,500 1,096,950
Closing Inventory
CIBOR/PLR (%pa) 10.0 10.0 10.0 10.0 10.0
WtAvg Proc Price pu 5.00 22.07
WAvg Cons Price pu 5.00 21.30
Actual Or Forecasted Demand for the Domestic Sector; Export, Tenders etc is extra and as given in Gz, emails  (in Units

Qrtr-> 2 3 4 5 6
Product Messages
MinAqu 78,319 86,224 97,405 110,044 121,000  Raw Materials Procurement adjusted as per limitations announced:
ZCal 40,951 49,412 55,627 62,634 68,310
Juicy 45,082 51,854 58,454 65,901 71,533
Spark 6,089 6,364 7,183 8,107 0
 FRX2Any v.12.14.01 DEMO
Sector
Update Issued at the end of  Quarter No:
2 Team No:
C 4
    NMG-NorthP3
16/07/19
Company Name 0-MSIL 1-POSOCO 2-IOCL 3-MSIL 4-NTPC 5-SAIL-BSL 6-HeroMoto 7-HPCL 8-L&T 9-MEJA Urj 10-POSOCO
Plant Capacity (for next qtr) 15000 19000 20000 20000 20000 20000 17000 18000 19000 21000 20000
Machine Capacity (for next qtr) 15000 19000 20000 20000 20000 20000 17000 18000 19000 21000 20000
Plant Capacity thru Productivity Gains
Machine Capacity thru Productivity Gains
Equity Share Price on Stk Exc 22.69 25.24 10.52 14.84 32.99 31.06 16.30 43.31 16.79 18.27 32.68
CUMPAT(000 11.092 12.762 4.911 7.136 15.332 14.834 8.178 19.101 6.075 8.734 14.993
Winning Criterion ( 00)
)
 6  5 11  9  2  4  8 Winner 10  7  3
Ranking

Key Performance Data  (Information Package # 6 - Price Cu.50,000)
Average Manpower Cost 22.00 17.99 17.80 19.21 18.43 17.69 17.93 18.03 17.93 18.08 18.05
Net Income Margin 0.1082 0.1312 0.0371 0.0693 0.1619 0.1547 0.0839 0.2025 0.0842 0.0918 0.1616
Debt to Equity Ratio 0.55 0.03 0.13 0.11
Current Ratio 8.03 1.82 1.01 0.76 1.56 1.52 0.84 2.93 0.36 1.05 0.90
Earnings Per Share 1.5904 1.7874 0.5119 0.8543 2.4796 2.3042 0.9844 3.4874 1.0145 1.1662 2.4883
Return on Equity 0.1276 0.1392 0.0458 0.0724 0.1849 0.1733 0.0824 0.2448 0.0859 0.0962 0.1849
Return on Investment 0.0769 0.1224 0.0329 0.0540 0.1643 0.1572 0.0664 0.2224 0.0530 0.0656 0.1481
Collection in Curr Qtr/Sales 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

 Efficiency  and Activity Ratios ((Information Package # 7 - Price Cu.40,000)
Prod Dev /Sales
S & D & Info Pack Cost/Sales 0.18 0.19 0.19 0.21 0.18 0.18 0.22 0.16 0.21 0.20 0.18
Material Cost/Sales 0.15 0.24 0.23 0.24 0.26 0.22 0.24 0.20 0.26 0.24 0.19
Financial Cost/Sales 0.12 0.11 0.11 0.12 0.10 0.10 0.13 0.09 0.13 0.12 0.10
Days Sales Outstanding
FG Inventory Holding Days 12.38 17.20 9.22 31.12 22.43 9.71 21.70 7.50 25.74 22.02 8.24
Sales/Total Assets 0.71 0.93 0.89 0.78 1.01 1.02 0.79 1.10 0.63 0.71 0.92

Market Share Data (Information Package # 8 - Price Cu.125,000)
MinAqu Mkt Share % units 0.06 0.10 0.12 0.08 0.08 0.11 0.08 0.11 0.08 0.08 0.10
        Avg Price / Unit 242 220 205 230 230 209 231 213 230 230 215
        Sale/Ord Enq 1.00 1.00 1.00 1.00 1.00 0.99 1.00 1.00 1.00 1.00 1.00

ZCal Mkt Share % units 0.08 0.09 0.12 0.09 0.09 0.11 0.09 0.07 0.09 0.09 0.09
        Avg Price / Unit 285 275 249 280 275 259 280 297 280 282 275
        Sale/Ord Enq 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

Juicy 0.12 0.07 0.13 0.06 0.11 0.08 0.05 0.16 0.05 0.06 0.10
        Avg Price / Unit 675 850 601 920 715 799 975 600 950 900 740
        Sale/Ord Enq 1.00 1.04 0.81 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04

Spark 0.10 0.09 0.10 0.12 0.09 0.10 0.09 0.10 0.10 0.11
        Avg Price / Unit 1750 1790 1759 1775 1499 1785 1759 1800 1750 1750 1650
        Sale/Ord Enq 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.09

Market Share (Rs Sales) 0.10 0.09 0.09 0.08 0.10 0.10 0.08 0.11 0.08 0.08 0.10

Contract Sales (no charge)
Price Quotation
MinAqu
Qty Awarded
Price Quotation
ZCal Qty Awarded
Price Quotation
Juicy
Qty Awarded
Price Quotation
Spark
Qty Awarded

Industry Wide Inventory Levels (Information Package # 9
                                                             - Price Cu.25,000)
MinAqu 14,403
 ZCal 13,108
Juicy 17,585 Water 81,738
Spark 1,519  Add 100,634

Asset List (no Charge)
Plant # 1 2
Capacity (units) 15000 5000
Remaining Life (qtrs) 7 9

Machine # 1 2
Capacity (units) 10000 10000
"
Remaining Life (qtrs) 7 9

"