Scribd
Upload
21 views3 pages

DCA Calculation

Uploaded by

ba154022267
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
21 views3 pages

DCA Calculation

Uploaded by

ba154022267
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

RENDER

Quantity Purchase Total Quantity Purchase Total


Bought Rate Cost Bought Rate Cost
3 7 21 0
5 6 30 0
6 5 30 0
8 4 32 0
10 3 30 0
Total Qty. Total Inv. Total Qty. Total Inv.
32 143 0 0
Avg. Cost 4.47 Avg. Cost #DIV/0!
This is the Sample

Quantity Purchase Total Quantity Purchase Total


Bought Rate Cost Bought Rate Cost
0 0
0 0
0 0
0 0
0 0
Total Qty. Total Inv. Total Qty. Total Inv.
0 0 0 0
Avg. Cost #DIV/0! Avg. Cost #DIV/0!

*NOTE: Just Need to put the Quantity and Purchase Rate (highlighted in
Quantity Purchase Total Quantity Purchase Total
Bought Rate Cost Bought Rate Cost
0 0
0 0
0 0
0 0
0 0
otal Inv. Total Qty. Total Inv. Total Qty. Total Inv.
0 0 0 0
Avg. Cost #DIV/0! Avg. Cost #DIV/0!

Quantity Purchase Total Quantity Purchase Total


Bought Rate Cost Bought Rate Cost
0 0
0 0
0 0
0 0
0 0
otal Inv. Total Qty. Total Inv. Total Qty. Total Inv.
0 0 0 0
Avg. Cost #DIV/0! Avg. Cost #DIV/0!

te (highlighted in RED Color) of the Coins in which multiple entries were taken. Rest it shall
Quantity Purchase Total Quantity Purchase Total
Bought Rate Cost Bought Rate Cost
0 0
0 0
0 0
0 0
0 0
otal Inv. Total Qty. Total Inv. Total Qty. Total Inv.
0 0 0 0
Avg. Cost #DIV/0! Avg. Cost #DIV/0!

Quantity Purchase Total Quantity Purchase Total


Bought Rate Cost Bought Rate Cost
0 0
0 0
0 0
0 0
0 0
otal Inv. Total Qty. Total Inv. Total Qty. Total Inv.
0 0 0 0
Avg. Cost #DIV/0! Avg. Cost #DIV/0!

e taken. Rest it shall calculate the Total Cost and then the Average Cost in Green Color.

You might also like