Company Credit Rating Score & Valuation (Plus Credit modelling)
£10-20 GBP
완료함
게시됨 약 6년 전
£10-20 GBP
제출할때 지불됩니다
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 - - - -
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 in this field work Accounting and Financial manager and all my study in University specialization include is books ( UK and USA ) in Accounting and financial and i am work to prepare many report financial ( Balance sheet , Trial balance , income statement )