CA Vikram Shankar Mathur (www.vikramshankarmathur.link)

 

Partner, KARTIK T. VAYEDA & CO., Chartered Accountants

---

About Vikram Shankar Mathur

I’m a Chartered Accountant and a seasoned technology consultant with over 30 years of experience in building smart business solutions using a unique blend of finance, technology, and automation. (www.vsmathurcoin.blogspot.com, vsmathurcoinshop.blogspot.com)

🔹 Advanced Excel Specialist

With in-depth knowledge of over 125–150 Excel formulas, I push Excel far beyond the ordinary. I also create powerful User-Defined Functions (UDFs) tailored to solve unique business challenges — making Excel not just a spreadsheet, but a smart system. (www.exceltrainerahmedabad.com, www.vbacoder1962.com)

🔹 Financial Management & Modeling Expert

Over the past three decades, I’ve developed numerous custom financial models based on the unique requirements of my clients. My deep understanding of financial principles ensures models that are not only functional but decision-focused. (www.ahmedabadfca.com, www.excel-vba-ahmfca.com)

🔹 Tally Accounting Software Authority

My journey with Tally began in 1995 with the DOS version, and continues today with Tally Prime 6. I’m recognized for creating flawless Chart of Accounts structures and managing accurate opening balance entries, even for datasets involving over 1,300 ledgers. (www.vikramshankarmathur.com, www.cavsm1962.co.in)

🔹 VBA Programmer & Excel-based Software Developer

I’ve been programming in Visual Basic for Applications (VBA) since the early 2000s. My Excel + VBA projects include:

• Payroll Management Systems

• Cashbook Automation Tools

• Income Tax Return Prep Software (2003–2009)

• ITNS 281 Challan Entry & Payment Modules

All built entirely using Excel and VBA, and customized for accuracy, automation, and ease of use. (www.vbacoder1962.in, www.vikramshankarmathur.info)

🔹 AI-Powered Problem Solver

Now fully immersed in the world of Artificial Intelligence, I can rapidly craft powerful prompts and implement AI-enhanced solutions. Whether it's automating tasks, generating reports, or training teams — I can bridge traditional methods with the power of today’s AI tools. (www.excel-vba-ahmfca.in, excel-vba-ahmfca.blogspot.com, cavsmathur.blogspot.com, deadlyvbaprogrammer.blogspot.com)

---

CA Vikram Shankar Mathur
https://www.vikramshankarmathur.link
https://www.cavsm1962.co.in
https://www.vikramshankarmathur.info
https://www.cavsm.in
https://www.cavsm.info 

 

 

Financial Management & Management Accounting

WHY IS AHMEDABADFCA.COM SYNONYMOUS WITH FM / MA?

First, let us understand the two books below, based on which there will be more posts over a period of time. These are:

(A) Financial Management: Text, Problems and Cases by M.Y. Khan and P.K. Jain is a widely used textbook in the Indian market that covers the core principles and practices of financial management [Buy Financial Management : Text Problems & Cases book : My ...]. It uses a comprehensive approach, combining theoretical concepts with practical problems and real-world case studies [Financial Management: Text, Problems and Cases, 8e - M. Y. Khan ...][Financial management : text, problems and cases [6 ed ...][Buy Financial Management : Text Problems & Cases book : My ...]. The book aims to provide students with a solid understanding of financial decision-making in various contexts [A Study on the Effectiveness of Debt Management and Financing ...].

The book covers topics such as:

• Financial statement analysis [Financial Management: Text, Problems and Cases, 8e - M. Y. Khan ...]
• Cost analysis and control [Financial Management: Text, Problems and Cases, 8e - M. Y. Khan ...]
• Working capital management
• Investment decisions
• Capital structure
• Dividend policy
• Long-term financing [A Study on the Effectiveness of Debt Management and Financing ...]()
• Valuation
• Mergers and acquisitions

The book is structured to help readers understand both the theoretical underpinnings and the practical application of financial management techniques. It includes numerous problems and cases to illustrate the concepts and provide hands-on experience in financial problem-solving [Financial Management: Text, Problems and Cases, 8e - M. Y. Khan ...][Financial management : text, problems and cases [6 ed ...]()[Buy Financial Management : Text Problems & Cases book : My ...].

 

(B) Management Accounting: Text, Problems and Cases by M.Y. Khan and P.K. Jain is a comprehensive book that explains the use of accounting information for managerial decision-making and defining long-term organizational goals 3. It covers financial accounting, financial analysis, cost accumulation, profit planning, cost control, and decision-making 3.

The book is divided into seven parts 3. The first part introduces the nature of management accounting 3. The second part focuses on financial accounting, covering generally accepted accounting principles, accounting standards, accounting cycles, and financial statements 3. The third part deals with financial analysis, including cash flow statements and the analysis of financial statements 3.

The fourth part explains cost accumulation, examining cost concepts and costing in various management aspects like labor and material control 3. The fifth part discusses profit planning, covering budgeting, profit planning, and volume-cost-profit analysis 3. The sixth part covers cost control concepts such as standard and quality costs, variance analysis, and responsibility accounting 3. The final part focuses on decision-making, including capital budgeting and short-run decision analysis 3.

The book includes additional information on accounting standards, cash flow statements, and understanding corporate financial statements, along with a new section on service costing 3. It also features numerous case studies to enhance understanding 3. The book is available in multiple editions, including the 6th and 7th editions 1256711.

========== CA Vikram Shankar Mathur ==========

========== ahmedabadfca@gmail.com ==========

========== www.exceltrainerahmedabad.com ==========

========== www.vbacoder1962.com ==========

========== www.vbacoder1962.in ==========

========== www.excel-vba-ahmfca.com ==========

========== www.cavsm1962.co.in ==========

========== www.vikramshankarmathur.link =========

========== www.vikramshankarmathur.info ==========

========== vsmathurcoinshop.blogspot.com ==========

========== www.cavsm.in ==========

Microsoft Excel and Myself

Perhaps there is some guilt hidden in my words when I say that I have never really acted on the maxim "When you've got it, flaunt it"!

Excel and I go back a long, long way - and yes, VBA Macro's came in much later, coz I used to do Macro Programming in Lotus 1-2-3 long before I began coding in Visual Basic for Applications. Funny thing is, that I never did it commercially, so far. It was always either for self-consumption, or for my CA Firm, where I had been a partner at that time.

Today, practically everyone who needs to compute figures, uses Excel Spreadsheets, VBA or no VBA. Ironically, a VBA subroutine, if coded properly, can save you hours of manual computing, a point I have proven over and over, in the past, since almost 1995, when I entered private practice, as a CA.

Today, even though Microsoft says that VBA will continue to be a part of the Office Suite, be it Office 2024/25 or Microsoft 365, there are maybe just a handful of CA's who use VBA, that too just the Macro Recorder!! Have yet to come across somebody professional regularly creating or actively using UDF's, userforms or class modules, which is where the true power lies!!

Not that I am complaining, because in any case, I am not doing what I currently do or have been doing commercially, so if I don't earn another rupee, it does not matter!!

Creating formats in Excel is another hobby that I have always had, and I have enough in my Formats folder to keep me going forever. Templates are for those who do not have time to create a format, but I have always carved out time from my schedule to create my own templates, but none that I can share publicly, unfortunately!! Yes, occasionally I too use office templates, like Amortisation of Term Loans, but only to adapt them for my own use.

What is AhmedabadFCA?

AhmedabadFCA is a website that seeks to cater to the various needs of the Chartered Accountants of Ahmedabad City, whether Fellow or Associate. Right now, we are in a very preliminary stage, but soon there are plans for big things to be implemented, like a forum where queries can be posted and addressed, something that needs to be brought to the notice of all the members can be highlighted here, etc.

So keep a watch, dear friends !! This is after all an AhmedabadFCA venture by yours truly.

CA Vikram Shankar Mathur
ahmedabadfca@gmail.com

September 14th, 2014