Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Welcome to the course on Project Funding Modelling.
Economy grows only when more business happens and it is possible only when new business opportunities are identified and converted into viable ventures.
Identifying business opportunity is the responsibility of the entrepreneurs. But making it as viable venture is possible only when it is funded by stake holders.
Stake holders can be Investors / Lenders.
Lenders would like to evaluate the business opportunities presented by their customers in various angle.
They would study the business of the customer from Risk / Return / Technical / Economic / Commercial Viable angles.
In order to understand the Economic and Commercial Viability and also to know the Break Even and Sensitivity of the Business, the Bankers would be using Project Funding Models.
Project Funding Model is basically excel based tool which would capture past financial data of the customer as well future projections and would provide various set of analysis to the Bankers for decision making.
CMA is used by the Banker as Project Funding Model tool.
CMA stands for Credit Monitoring Arrangement.
By feeding data in CMA, we will get following information:
a) Valid Statement:
i) Whether the Balance Sheet is tallying
ii) Whether there is any difference between the depreciation in Operating Statement and Balance Sheet
iii) What is the proportion of various expenses to the total production cost.
b) Financial Indicators:
I) Various Financial Ratios
ii) Efficiency Ratios
iii) Risk Related Ratios
c) Inventory and Receivables Holding Levels
I) Levels of Inventory
ii) Levels of Receivables
iii) Levels of Payables
d) Assessed Bank Finance Statement
e) Fund Flow Statement
This sheet will automatically calculate Fund Flow and will show whether there is any diversion of funds.
f) DSCR Statement
This sheet will automatically calculate the Debt Service Coverage Ratio.
The above information will be analysed by the bankers in depth.
Apart from the above, the Bankers will also study Break Even Analysis, Sensitivity Analysis.
This course is presented in casual style and in self learning pace.
Take this course to understand the nuances of Project Funding Modelling.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to Project Funding Modelling|
|Section 2: Analysing Previous Year Financial Statement|
Capturing Past Data from Audited Financial StatementsPreview
Analysing Previous Years Income Statement
Analysing Previous Year Liability Statement
Analysing Previous Years Asset Statement
Fund Flow Statement Real Case
|Lecture 7||958.5 kB|
CMA - Used for analysing the past financials as well for Project Funding Modelling.
Bonus Lecture - Discount Coupon Links for other Courses
I am a practicing Chartered Accountant with tonnes of passion for teaching.
I teach Financial Management & Strategic Financial Management for Chartered Accountancy, Cost and Management Accountancy and Company Secretary students in Ernakulam, India. I also hold Post Graduate Diploma in Business Administration in Finance from Symbiosis, Pune and Bachelors in Commerce, from Loyola College, Chennai.
I worked in State Bank of India as Assistant Vice President - Credit for a period of four years after which i started my Chartered Accountancy Practice. During the stint in State Bank of India, I worked on credit proposals of Mid Corporate Units and gained good experience in Financial Analysis, Risk Assessment, Viability Study, Evaluating business models, Project Finance, Working Capital Management, etc.
I conduct work shops for Entrepreneurs, Chartered Accountancy / Cost and Management Accountancy Students on the topics like Project Finance, Credit Risk Assessment, Entrepreneurship Development, Finance for Non Finance Executives, etc.
I love teaching and i want fundamentals of accounting and finance to reach students and so i am here.