I need a Excel tool where I can input data and it would simplify my credit analysis.
What the Excel must do:
1. I input up to 5 year past financials (balance sheet and income statement). Therefore it must suit for any industry. I can give more specific instructions later.
2. Calculate ratios + some other financial indicators - EBIT, EBITDA, liquidity ratios, working capital etc (more instruction to come)
3. Automated forecast with me inputting some assumptions for it.
4. Sensitivity analysis with two axes for example change in interest rate and vacancy (for real estate)
5. Cash flow analysis
Point is only once input data to the first sheet (financial report data) and other work is done by the Excel (some data will be entered later of course still). Tool must be able to use for all/most industries and their analysis from the credit analysis point of view.
I will have pictures of examples and there will be some differences according to my countries specialties (will explain if there are).
55 freelancers are bidding on average €168 for this job
Hello sir.I can provide you an Excel tool where you can input data and it would simplify your credit analysis .please discuss details [login to view URL]
Greetings! I am working on a similar excel tool for a US based peer to peer lending startup. I am keen to help you here. Look forward to hear from you. Thanks, RRC
Hi, I am an excel vba expert, have delivered similar projects in the recent past. I have finance domain expertise and willing to work with you to bring out your needed result. Thank you Regards