Nobero (Shiprocket) - Capex

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 3

BACK TO COSTS 6

Useful life
Deployment
SN Item Description as per
Date
books
1 Desktop 3 1-Jun-22
2 Wireless Scanners 3 1-Jun-22
3 Wired Scanners 3 1-Jun-22
4 Label Printer 3 1-Jun-22
Storage cage - For keeping Packed carton before
5 3 1-Jun-22
dispatch
6 Pedestal Fan 5 1-Jun-22
7 CCTV Solutions 5 1-Jun-22
8 Packing Tables L-3.5m & B-2m 3 1-Jun-22
9 Office Chair 3 1-Jun-22
Warehouse Electrification Cost(Lighting, Wiring,
10 5 1-Jun-22
MHE Charge Area)
11 Corrugated Bins 3 1-Jun-22
12 Hand Pallet Truck - 2.5 ton 5 1-Jun-22
13 Pick Trolley - Flat Bed 5 1-Jun-22
13 Slotted Angle racks 5 1-Jun-22
14 Step Ladder 5 1-Jun-22

ANNUAL COST
MONTHLY COST CHARGE BACK
6/30/2022
Asset Life Actual
Life of Asset in Life of Asset Actual Total Purchase
Completed in UoM Purchase
Months Pending Qty Cost
Months Rate
36 1 35 Nos 4 57,750 231,000
36 1 35 Nos 5 30,000 150,000
36 1 35 Nos 4 5,000 20,000
36 1 35 Nos 4 30,000 120,000
36 1 35 Nos 3 20,000 60,000
60 1 59 Nos 3 7,000 21,000
60 1 59 sqft 5 0 350,000
36 1 35 sqft 4 16,000 64,000
36 1 35 sqft 4 5,000 20,000
60 1 59 sqft 1 0 150,000
36 1 35 sqft 5,100 70 357,000
60 1 59 sqft 1 18,000 18,000
60 1 59 sqft 4 10,000 40,000
60 1 59 sqft 500 2,464 1,232,000
60 1 59 sqft 5 5,000 25,000

2,858,000
9.50%

Annual Asset Amortization


Interest
Usage Charge Value

96,257 77,000 19,257


62,504 50,000 12,504
8,334 6,667 1,667
50,003 40,000 10,003
25,002 20,000 5,002
6,062 4,200 1,862
101,040 70,000 31,040
26,668 21,333 5,335
8,334 6,667 1,667
43,303 30,000 13,303
148,760 119,000 29,760
5,196 3,600 1,596
11,547 8,000 3,547
355,660 246,400 109,260
7,217 5,000 2,217

955,889 707,867 248,022


79,657 58,989 20,669

You might also like