Went through the Excel screenshot and also the Monthly inflation table.
Having the stock acquired date, excahnge rate
Sold date and Exchange rate
Acquisiting cost and Acutalised cost
The Actualised cost to be based on the inflation for the period the stock held, considering the monthly inflations for each month within that period.
This can be done
- Have done similar Tax calculations for Canadian firm Provincial and Federal tax
- Wage calculations based on hours worked etc.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables
- Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl