Profit & Cost Tracking Excel Expert
Budget: $10 – $30 CAD
I need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage.
The Excel sheet should track the following:
- Project cost
- Project revenue
- Project expenses
- Percentage of account receivable
- Percentage of account paid
- How the client paid after tax
- Description for the costs
- Percentage of the costs
- Percentage of the profit before tax
- Percentage of account receivable before tax
- Date of payment
The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement advanced Excel functions, is necessary.
The Excel sheet should track the following:
- Project cost
- Project revenue
- Project expenses
- Percentage of account receivable
- Percentage of account paid
- How the client paid after tax
- Description for the costs
- Percentage of the costs
- Percentage of the profit before tax
- Percentage of account receivable before tax
- Date of payment
The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement advanced Excel functions, is necessary.