Company Credit Rating Score & Valuation (Plus Credit modelling)
£10-20 GBP
Paid on delivery
Create a template in excel for creating an international credit rating score from information published in uk company accounts. 2) Create a formula for valuing a uk based company based on information in published accounts. The successful bidder will provide the formula and create an effective template layout in Microsoft Excel with details of how are have arrived at the formula. The formula will then be applied to any company. The template will be created using brand colours, red, white and blue. (Details will be given to the successful bidder.
This is an example of information available:-
Balance Sheet
Date Of Accounts -
Tangible Assets £1,036
Intangible Assets
Total Fixed Assets
Stock 0 - 0 - 0 - - - -
Trade Debtors £4,916 -28.1% £6,839 999.9% £250
Cash 0 - 0 -100% £925 - - - -
Other Debtors 0 - 0 - 0 - - - -
Miscellaneous Current Assets 0 - 0 - 0 - - - -
Total Current Assets £4,916 -28.1% £6,839 482% £1,175 - - - -
Trade Creditors £67,564 1.5% £66,548 185.8% £23,285 - - - -
Bank Loans & Overdrafts 0 - 0 - 0 - - - -
Other Short Term Finance 0 - 0 - 0 - - - -
Miscellaneous Current Liabilities 0 - 0 - 0 - - - -
Total Current Liabilities £67,564 1.5% £66,548 185.8% £23,285 - - - -
Bank Loans & Overdrafts and LTL £750 - 0 - 0 - - - -
Other Long Term Finance 0 - 0 - 0 - - - -
Total Long Term Liabilities £750 - 0 - 0 - - - -
.
Capital & Reserves
Date Of Accounts 31/08/17 (%) 31/08/16 (%) 31/08/15 (%) - (%) -
Called Up Share Capital - - - -100% £1 - - - -
P & L Account Reserve -£62,362 -5.5% -£59,133 -173.5% -£21,623 - - - -
Revaluation Reserve - - - - - - - - -
Sundry Reserves - - - - - - - - -
Shareholder Funds -£62,362 -5.5% -£59,133 -173.5% -£21,622 - - - -
Other Financial Items
Date Of Accounts 31/08/17 (%) 31/08/16 (%) 31/08/15 (%) - (%) -
Net Worth -£62,362 -5.5% -£59,133 -173.5% -£21,622 - - - -
Working Capital -£62,648 -4.9% -£59,709 -170.1% -£22,110 - - - -
Total Assets £5,952 -19.7% £7,415 345.9% £1,663 - - - -
Total Liabilities £68,314 2.7% £66,548 185.8% £23,285 - - - -
Net Assets -£62,362 -5.5% -£59,133 -173.5% -£21,622 - - - -
Project ID: #16596409
About the project
Awarded to:
4 freelancers are bidding on average £26 for this job
My key skills are relevant to this project. I have huge experience in this area. I can do this project very efficiently.
Hello Dear i am reading this description job and i sure i will helpful for you to complete your work a high quality and finish statement finance and prepare Balance sheet . i have more than 8 years experience More