Total Invenstment
Freight
Advance Payment (10%)
Total Installment Amount
Tenure of the project
Per Year Spare Parts & Service Cost 8%
Sales per Year
Operating Cost per year (8% on sales)
per year revenue
Payment Terms
Payment Period
Per Month Instalment
Per Year Instalment
Sales Revenue
Less: Operating Expenses
Spare Parts & Service Cost
Operating Cost
Total Operating Expenses
Less: Financial Expenses
Ineterest Expenses (12.2(kibor)+2%)
Total Financial Expenses
Less: Extra Costs
Spare Parts Clearing charges & Tax
Deprecaition Expenses (20%)
Training of user
Training of staff
Instalation Cost
Trials Cost
Clearing Charges & Taxes
Total Extra Costs
Total Expenses
venues
Net Margin
% to Sales
Total Outflow
Less: revenue (Inflow)
Net Cash Flow
1,675,339 1,573,196 Per Year Spare Parts & Service Cost 8% 134,027
33,236
157,320 1,578,575
1,415,877
7 years
134,027 Freight - 5% 6,701 140,728
1,000,000 Custom Duty - 20% 28,146 168,874
80,000 Income Tax - 4% 6,755 175,629
450,000 GST- 16% 28,101 203,730
Clearing Charges - 10% 20,373 224,103
30 months
47,196
566,351
1st Year 2nd Year 3rd Year 4th Year 5th Year 6th Year 7th Year 8th Year
500,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 500,000
134,027 134,027 134,027 134,027 134,027 134,027 67,014
40,000 80,000 80,000 80,000 80,000 80,000 80,000 40,000
40,000 214,027 214,027 214,027 214,027 214,027 214,027 107,014
107,032 59,704 #REF!
107,032 59,704 #REF! - - - -
90,076 90,076 90,076 90,076 90,076 90,076 90,076 -
269,392 215,514 172,411 137,929 137,929 110,343 70,620
10,000
50,000
5,000
60,000
215,076 359,468 305,590 262,487 228,005 228,005 200,419 70,620
362,108 633,200 #REF! 476,514 442,032 442,032 414,446 177,633
225,000 450,000 450,000 450,000 450,000 450,000 450,000 225,000
(137,108) (183,200) #REF! (26,514) 7,968 7,968 35,554 47,367
978,746 870,453 #REF! 304,103 304,103 304,103 304,103 36,394
225,000 450,000 450,000 450,000 450,000 450,000 450,000 225,000
753,746 420,453 #REF!
90,076
Total
7,000,000
1,431,176
#REF!
1,869,668
#REF!
3,150,000
#REF!
#REF!
#REF!
3,150,000
#REF!