Suoritettu

Fix and verify (or create a new) FIFO Capital Gains Spreadsheet

Regarding this Google Sheet -

https://docs.google.com/spreadsheets/d/1Hns15p7AHcKKPDaKGHHUyaZyg64N3V6t1qhpr68OPOA/edit#gid=670991799

As an outcome I need the FIFO Capital Gains/Profits for the profits on purchases and sales of items. You can either fix the existing FIFO formulas or replace the entire system, whatever you want as long as it's accurate. The yellow columns are fixed however, I cannot change these columns if you make a new Sheet.

What I need is Columns U and V to be modified so that if a sell order matches with a buy order (remember a sell order of say 40 units could match to 4 different buy orders of 10 units each for example), it correctly find the FIFO profit and then split it into 2 components. Profit from purchases OVER a year will go in Column V, Profit from purchases UNDER a year will go in Column U.

End Goal:

- Column U will be the Capital Gains/Profit component owed for the part UNDER a year

- Column V will be the Capital Gains/Profit component owed for OVER a year.

Example:

- 5x Apples are purchased on 1st Jan 2020 for $100 in Total

- 5x Apples are purchased on 1st June 2020 for $120 in Total

- 10x Apples are sold on 2nd March 2021 for $250 in Total. The profit is $25 on the first 5x Apples and as the gap is OVER a year it will go in Column V. The profit is $5 on the second group of 5x Apples, and as the gap is UNDER a year it will go in Column U.

Requirements:

- Work from this Spreadsheet as a starting point - [login to view URL]

- Replace broken FIFO parts of the Sheet to add FIFO Capital Gains calculation system, afterwards validate and ensure it is working correctly.

- For a particular sell order, the profit needs to be split into 2 components: Profit from relevant buy orders OVER a year, and UNDER a year.

- Spreadsheet will have multiple different tickers included in Column A (Tickers) of the transaction history. The formulas must be able to account for this and only report the capital gains for the correct ticker.

- FIFO calulations must correctly take into account brokerage costs.

- Units sold/bought must have support for fractions (ie. 1.54 shares bought or sold)

- Confirm that the Average Cost base portions of the Sheet are still working correct.

- The yellow portions of the sample Sheet are fixed, these cannot be changed or moved in location.

- The Sheet must be able to scale to infinite going down in rows. The Sheet must not scale to infinite in columns as you add more data, columns must be fixed in number once made.

If you have any further questions don't hesitate to ask. Please only apply if you have made a FIFO Spreadsheet before, I have already one one incomplete and would like to avoid again to not lose time.

Taidot: Excel, Google Sheets, Kirjanpito, Tax Accounting

Näytä lisää: capital repayment spreadsheet formula, excel capital expenses spreadsheet examples, invested capital excel spreadsheet, mortgage interest capital repayment spreadsheet, capital expense spreadsheet, create online form email populate spreadsheet, create employee time clock excel spreadsheet, gmail bypass verify create, create iphone app based excel spreadsheet, mortgage capital repayment spreadsheet excel, fifo capital gains excel, write macro calculate capital gains, capital gains worksheet excel, capital gains fifo, calculations capital gains excel, google apps script create new spreadsheet, excel fifo capital gains, how to create new sheets for each row in google sheets, google script create new spreadsheet

Tietoa työnantajasta:
( 0 arvostelua ) Glen Waverley, Australia

Projektin tunnus: #30596272

Myönnetty käyttäjälle:

(29 Arvostelua)
4.8

10 freelanceria on tarjonnut keskimäärin $148 tähän työhön

(53 arvostelua)
6.3
(29 arvostelua)
5.9
(12 arvostelua)
5.6
martinoa90

Hi there! I am positive I can help you out fixing this formulas. I'm going to be 100% honest with you, I have not done a FIFO Spreadsheet before but I did do several Cashflows P&L Spreadsheets, in Excel and GoogleShee Lisää

$100 AUD 2 päivässä
(7 arvostelua)
4.0
RavenSolutions

Hi! I have read about your project Fix and verify (or create a new) FIFO Capital Gains Spreadsheet I am KickAss in Excel, Accounting, Google Sheets and Tax Accounting, so I'am totally sure I can deliver Your project ! Lisää

$334 AUD 4 päivässä
(2 arvostelua)
2.9
dominicnzioka197

MASTERS IN FINANCE & ACCOUNTING, EXPERT IN NAMED SKILLS, OVER 18 YEARS OF EXPERIENCE, DEAR EMPLOYER, After KEENLY reading your description and being in possession of all CLEARLY STATED REQUIRED SKILLS as this is my are Lisää

$140 AUD 7 päivässä
(0 arvostelua)
0.0
phpdeveloper3

Hello employer, I am a 7+ years experienced web programmer specializing in almost all php cms(Word, Joomla, Drupal, Magento) / frameworks (Laravel, CODEIGNITER, CakePHP, symphony) and full stack technologies (Angular Lisää

$83 AUD 2 päivässä
(0 arvostelua)
0.0
vaniagr03

Hey! PLEASE KNOW THAT I HAVE A SPECIALISED TEAM that can handle projects like this. I along with my team can complete your project professionally, starting with a free sample. Moreover we have prior experience with F Lisää

$250 AUD 3 päivässä
(0 arvostelua)
0.0
CARishimonNandy

hello sir/madam I am a chartered accountant by profession. I can perform the work as per your requirement. Please drop a message so that we can discuss further and once you are satisfied we can proceed with the agreem Lisää

$30 AUD 7 päivässä
(1 arvostelu)
0.0