Business, Accounting and Legal

Building a generic carding system in excel, which does financial ratio calculations for me. I have created some form of indirect and direct cash flows which balance with historic cash at bank recorded on balance sheet (Note this is a moderately large carding system which sits well over 300 chart of accounts between profit and loss and balance sheet). The only issue is that I have had to deduct depreciation and amortization expense to allow it to balance. What I require is someone to rebuild the historic indirect and direct cash flows so they are inline with industry standards. I would also like a free cash flow model built in on a seperate spread sheet that can be used for equity analysis. Following this project, the model will be expanded to create advanced 3-way forecasting (P & L, Balance Sheet and Cash Flow) and covenant testing. If the succesful applicant demonstrates good service, advanced understanding of accounting, financial modelling and is trustworthy they will most likely be succesful in the future progression og this model. In summary this project entails: -revise and create a new indirect cash flow -revise and create a new direct cash flow -Create a new free cash flow sheet -Review current Balance Sheet and Profit and Loss for errors and/or recommendations on missing fields for a generic carding and financial analysis tool Required Skills -Excel -Strong accounting/financial modelling -Trustworthy with discretion not to share or circulate the spreadsheets.