Find Jobs
Hire Freelancers

Calculating capital gains and currency gainy applying FIFO method

€8-30 EUR

Completed
Posted over 5 years ago

€8-30 EUR

Paid on delivery
I have one list with all stock trades that took place, one with all currency transactions and one with the daily official reference exchange rate. Now I have to file taxes and the Tax bureau wants to know how high were capital gains/losses and how high were currency gains/losses. According to tax law capital gains occur whenever shares of a stock are [login to view URL] are calculated by: sale price/share (column „[login to view URL]“) x nr. shares (column „Menge“) x current exchange rate(table: daily official reference exchange rate) - purchase price/share (column „[login to view URL]“) x nr. shares (column „Menge“) x exchange rate from share purchase date (table: daily official reference exchange rate). Currency gains occur when: 1) buying shares and are calculated by: nr. shares x (current exchange rate-exchange rate when $ where bought (applying FIFO method!)) and Occur when 2) selling USD ( nr. $ sold x ( current exchange rate- exchange rate when $ where bought (applying FIFO method!) I need to build an excel sheet that helps me do that. In the end I should have one field showing capital gains/losses 2016, one showing capital gains/losses 2017, one showing Currency gains/losses 2016 and one showing Currency gains/losses 2017.
Project ID: 17658445

About the project

31 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
A Chartered Accountant by profession having 8 years of experience in accounting, bookkeeping, taxation.
€28 EUR in 3 days
5.0 (2 reviews)
0.0
0.0
User Avatar
Hello, I am a professional business consultant looking to expand my client base and complete a variety of projects on Freelancer.com I am a diligent worker and I never miss a deadline. I look to impress my clients with a mix of efficiency and accuracy. I I am a CPA graduate with an extensive experience in business analysis and management. Regarding this particular I have been specialising in complex excel for many years and recently tested in tge top 10% of a global database of users when undertaking formal testung, so I am confident I can assist you. I am available to discuss this project anytime and I look forward to doing so in due course. Kind Regards Josh Luttrell
€14 EUR in 1 day
4.8 (2 reviews)
1.5
1.5
31 freelancers are bidding on average €25 EUR for this job
User Avatar
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 390 + projects with 100% client satisfaction. I can help you with Calculating capital gains and currency gainy applying FIFO method I have more than 5 years of the experience in Accounting, Excel, Mathematics, Tax Please ping me for more discussion. Thanks.
€100 EUR in 1 day
4.9 (383 reviews)
8.1
8.1
User Avatar
I have a bachelors degree in finance and good understanding of capital gains and FIFO method .I can deliver according to specification and within the required time.
€23 EUR in 1 day
4.9 (15 reviews)
4.2
4.2
User Avatar
Hi. I am a CPA (USA) and a Chartered Accountant from India. I have an experience of more than 9 years in the field of accounting, taxation, budgeting, valuation, auditing and advisory services. My clientele includes forex dealers, financial market investors, etc. The calculations you want to get done are done by me on a regular basis as the Indian tax laws need the same calculation to be done to assess the capital gains and tax thereon. The cutting edge of my services include timely completion of the work and minimum response time. Looking forward to working with you Thanks P Dokania
€29 EUR in 1 day
5.0 (4 reviews)
3.8
3.8
User Avatar
hello sir, excel sheet will be at your one message
€14 EUR in 2 days
5.0 (1 review)
0.8
0.8
User Avatar
I have strong analytical skills that allow me to make an accounting analysis . strong mathematic and statistic skills make me able to perform analysis accurately , I am able to work in a long time with under pressure , I am capable for making decision in crucial cases . I am proficient with Microsoft Office , Google sheet , Quick books and Zoho , I have experience in remote work as accountant , I have laptop and high speed Internet , I have previous experiences deal with many currency ( in Global business company we work with Multi currency US Dollar , KES( KENYA ) , TZS ( TANZYA) , LT ( Turkey) , L.E (EGYPT
€13 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Client, I am Aruna Ceyardass from India with around 18 years of experience in core accounting area. I have done certification in Quickbooks Online and Xero. I have 8 years of experience in Quickbooks Pro2000 and 4 years of experience in Xero, Quickbooks versions of 2008, 2010, 2015, Wave accounting and MYOB. I can control and maintain full set of accounting system including Account Receivable, Account Payable, Fixed Assets, Monthly P&L and Balance Sheet Statement, Cash book, General Ledger and prepare all statements for tax purposes, as per the directions. I have been in assistance level in preparing all types of Tax returns like 1120S, 1120, 1065, 1040 and have worked for different types of companies like Gas and Conventional stations, Restaurants, Hotel, Hospital, Real Estate, Property Management Agents, Manufacturing, Wholesale, Retail, Maintenance Service, Kids Care School, etc. Moving forward, i can dedicate up to 25 hours/week and my daily working hours are negotiable. If the contract is finalized for long term basis then i can dedicate more hours. I work professionally and independently to strict deadlines and deliver high quality solutions to meet clients' needs. I am ready to discuss on this position, further and will be available for online meetings either through Gmail or Skype on one day prior intimation. Thanks,
€24 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We will provide you the calculations in excel which will be very simple to understand. If you want to do any changes you can do it on your own in later stages. Let us know if you are interested. Thanks, SD
€20 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Excel is my passion and I really love working in Excel, be it simple reports with elegant formatting or Dashboards or Macros based forms, etc. I an experienced professional having more than 13 years of experience in Pakistan and UAE. I want don't want to merely complete a project rather I would like to win valuable long-term clients like you to be my real long-term earning. I will highly appreciate your confidence in me if I am given a chance. I am quite flexible and reliable and I would be happy to happy to answer your queries and open to negotiation. Yours truly, Rizwan
€14 EUR in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
My proposal is that i know about calculation ratios and account related Jobs And also know about the ms so i Will give easily solution. Relevant Skills and Experience Accounts formulas and ratios and ms work..
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Trust me Relevant Skills and Experience Trust me...I will manage..Nd give u best
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am proficient in EXCEL(have attended professional training). I understood the example and the task won't take more than few hours to complete. Will be glad to help you.
€10 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Professional Chartered Accountants. Handling this matter on day to day basis and after reviewing the work, I might reduce the work time...!!! Relevant Skills and Experience Knowledge of Income Tax Act. Capital Gain Provisions. Working in Excel and Calculations...!!!
€22 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Experience in calculating such gains in indian tax systems-Short term and long term gains. I would not be aware of foreign law but calculations are same.
€19 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can help in preparing an excel which will help in calculating capital gain or loss, whether short term or long term. the Excel will be such that once you plot the data it will do auto calculation. if you can send me the sample data for which you would like me to do this exercise, I can send you the Excel template which will auto calculate the gain once you put transactions data in the format you have received in excel. i will take maximum 2 days, but i can assure you will be pleased with the working I will provide you. I am qualified Chartered Accountant from India. please connect in case you are interested.
€34 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Chartered Accountant with more than 5 years of professional experience in the fields of Accounting, Finance, Bookkeeping, Budgeting, Forecasting, Management Accounting and Auditing. I am looking forward to helping you in all aforesaid topics. My Top Skills include: 1) Accounting in Quick books, Tally , SAGE , XERO , BUSY, EXCEL etc. 2) Project Financing & Budgeting 3) Reconciliation 4) Statutory & Internal Audit 5) AR / AP Management 6) Inventory Management 7) Payroll 8) Preparation & Compilation of Financial Statements & Annual Report 9) Accounting Standards Evaluation (IFRS, IAS, AASB) 10) Business Analysis 11) Audit (ISA) 12) Financial Analysis I believe in satisfying a client by my work quality, rather than finding my satisfaction by making one-time profit. I charge reasonable so that I can make good long term relationship.
€29 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very interested in this subjekt, and want to earn a 5 score rating so i can be more attraktive for furture projects. That is the reason for the low price. You Will not bedste not regret it Relevant Skills and Experience I know everthing needed to produce the ecaxt result that you have asked for in the description.
€14 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 3 year of work experience in tax field as i have been working as an article assistant.I have good knowledge and experience in doing the capital gains. I had done almost 20-30 capital gains and file income tax returns.
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I'm working in a CA Firm so i can help you get all these things, kindly revert me back asap.
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Leipzig, Germany
4.8
1
Member since Aug 25, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.