Discussion Board

Can you show some practical sales and investment costing sheet where startups worked together ?

Investment

Chillies (3459 Boxes @ Rs. 184/- per Box)

6,36,456.00

CHA / Shipping / Freight Charges

1,44,000.00

Total invested amount

7,80,456.00

 

Investment breakdown

Vivek Patil

2,50,000.00

Shivprasad Purohit

2,50,000.00

Ankit Dalvi

1,00,000.00

Vilas Gaikwad

1,00,000.00

Pallavi Pansare

1,00,000.00

Total Amount Raised

8,00,000.00

Balance amount

19,544.00

 

Percent wise investment breakdown (Rs. 7,80,456) & actual value used

Vivek Patil

31.48%

2,45,671.94

Shivprasad Purohit

31.48%

2,45,671.94

Ankit Dalvi

12.35%

96,370.71

Vilas Gaikwad

12.35%

96,370.71

Pallavi Pansare

12.35%

96,370.71

Total

100.00%

7,80,456.00

 

Chilly Selling

Date

Boxes

Rate, AED

Price, AED

26-02-2020

1019

10

10,190.00

80

9

720.00

 

27-02-2020

83

10

830.00

230

9

2,070.00

330

8

2,640.00

 

28-02-2020

440

8

3,520.00

48

7.5

360.00

5

8

40.00

 

29-02-2020

1000

8

8,000.00

120

7

840.00

 

 

 

Adjusted boxes

100

9

900.00

Total

3455

 

30,110.00

Total number of boxes was 3459; 4 boxes was adjusted in sampling & customs operations.

 

Destination Expenses, AED

Hamali

435.00

Parking

1,250.00

CHA/VAT

5,500.00

Loading/Unloading

300.00

Commission

1,460.00

Total

8,945.00

 

 

 

Profit/Loss assessment

Text Box: Profit/Loss assessment

 

 

Total difference:

(Chillies selling rate - expenses) in AED

30,110.00

8,945.00

21,165.00

 

Currency calculations: 21,165x20= Rs. 4,23,300/-

Total P/L:

7,80,456 - 4,23,300 = Rs. 3,57,156/-

 

Government incentive calculations: (expected in April/May 2020)

Duty drawback

931.00

MEIS (3%)

18,619.00

TMA

28,000.00

Total

47,550.00

Total Loss incurred considering incentives:

Rs. 3,09,606

     

 

Current P/L of individual investors considered on invested amount of Rs. 7,80,456/- Loss value considered: Rs. 3,57,156 (for current calculations as incentives not received)

Loss amount is distributed as per the percentage of amount invested by the investors individually

Vivek Patil

1,12,425.60

Shivprasad Purohit

1,12,425.60

Ankit Dalvi

44,101.60

Vilas Gaikwad

44,101.60

Pallavi Pansare

44,101.60

Total P/L

3,57,156.00

 

  1. Please keep buffer of Rs. 5000 in minus side as we are yet to calculate banking charges & misc that will be known after final amount receival.
  2. Final calculations considering the government incentives & banking charges will be done after receiving the same.
 
  Text Box: >	Please keep buffer of Rs. 5000 in minus side as we are yet to calculate banking charges & misc that will be known after final amount receival.
>	Final calculations considering the government incentives & banking charges will be done after receiving the same.