Best wishes for your Future
Dr. K. Sreenivasa Charyulu,
Assistant Professor,
Best wishes for your Future
Dr. K. Sreenivasa Charyulu,
Assistant Professor,
Dear Students,
Registrations are now open for the NPTEL Online Certification Course: "Finance Analytics for Decision Making using Excel."
This course will help you develop practical skills in financial analysis, data-driven decision making, and Excel-based financial modeling, which are highly valuable for academic and professional growth.
✅ Learn finance concepts through hands-on Excel applications
✅ Enhance your analytical and decision-making skills
✅ Earn an NPTEL certification from IIM, Banglore.
Course starts form : 10-07-2026
Registration link: https://onlinecourses.swayam2.ac.in/e-learning/preview/imb26_mg255
Best wishes for your learning journey
From:
Dr.K.Sreenivasa Charyulu,
Assistant Professor
I am delighted to share that I have successfully defended my PhD viva from Annamalai University.I would like to express my heartfelt gratitude to my research supervisor, Dr. P. Selvamani sir for his constant guidance and support throughout my research journey. I also extend my sincere thanks to Dr.Pragadeeswaran sir, Head of the Department, Business Administration, Annamalai University, for his encouragement and valuable support. Finally, I am deeply thankful to my family members for their unconditional love, encouragement, and support, which made this achievement possible. This milestone would not have been possible without all of you.
Dear Readers,
I am delighted to share a joyful milestone with you all. I have qualified the NTA NET in Commerce(Ph.D only). This achievement is a result of continuous learning, dedication, and the encouragement I receive from all of you who follow my blog and academic content.Your support and engagement motivate me to keep sharing knowledge in the areas of Commerce, Management Education, and Research. I sincerely thank each one of you for being part of this journey.
Thank you for your constant support.
Warm regards,
Sreenivas Kodamasimham
Dear MBA I–II Students,
This is to inform you that the marks for your oral presentations have been updated in the Google Sheet. Students who have already presented their topics in class, have been awarded marks, and their entries are highlighted in blue colour for easy identification. All students are also reminded to give presentation as per your schedule, in case if you are the absent on the day of your presentation without any prior permission, zero marks would be assigned and also submit written assignments (Assignment I and Assignment II) without delay before the end examination. Please check the sheet and ensure that all your submissions are completed on time.
After completion of assignment in excel sheet, fill the below google form and upload your excel sheet.
https://docs.google.com/forms/d/1stLNb7BtsH29IVg_NOdYXtwSCLv3foZPtlK97DjWaUU/preview
Unit-1
Short Questions:
1.Define Accounting and state any two objectives of accounting.
2.What are Accounting Concepts? Give any two examples.
3.What is GAAP? Mention any two implications of GAAP on the accounting system.
4.What is Double Entry System? Write its basic rule.
5.What is meant by Accounting Cycle? List any two stages of the accounting cycle.
Long Questions:
1.Explain the Importance and Objectives of Accounting.
2.Explain in detail the Accounting Concepts and Conventions(Principles of Accounting)
3.What are Generally Accepted Accounting Principles (GAAP)& explain its implications.
4.Explain the Double Entry System of Accounting.
5.Discuss various types of Accounts- (Golden rules of accounting)
Unit-2
Short Questions:
1.What are Books of Original Record? Give two examples.
2.Define Trial Balance. State any two objectives of preparing a Trial Balance
3.Differentiate between Capital Expenditure and Revenue Expenditure (any two points)
4.What is meant by Rectification of Errors?
5.What is Single Entry System? Mention any two disadvantages.
Long Questions:
1.Explain the preparation process of Final Accounts (Format also) with Adjustments
2.Explain types of errors and the procedure for rectifying errors with suitable examples.
3.Describe how profit is ascertained under Single Entry System and the preparation of necessary accounts.
4.Define single entry system, explain their features, advantages, and disadvantages
5.Explain the differences between single entry and double entry system
Numeric:
1.Journal Entries
2.Ledger posting
3.Trial Balance
4.Final Accounts
5.Rectification of errors
Unit-3
Short questions:
1.What is Valuation of Assets?
2.Differentiate between Tangible Assets and Intangible Assets (any two points).
3.List any two methods of Inventory Valuation.
4.What is Goodwill? Mention any two methods of valuation of goodwill.
5.What is Depreciation? State any two objectives of charging depreciation.
6.Differentiate between FIFO & LIFO.
Long questions:
1.Discuss FIFO, LIFO, Weighted Average Method, and their impact on profit measurement and financial statements.
2.Discuss different bases of asset valuation and distinguish between tangible and intangible assets with examples.
3.Explain the advantages & disadvantages of Straight line & written down value method.
4.Explain Goodwill and its Methods of Valuation.
5.Discuss the Impact of Different Depreciation Methods on Business Accounting.
Numeric:
1.Depreciation methods(Straight line and written down value methods)
2.Inventory valuation methods(FIFO,LIFO, Simple Avg. & weighted Avg.)
3.Goodwill valuation methods(Average profit, super profit and capitalization methods)
Unit-4
Short questions:
1.What is meant by Working Capital?
2.Define Funds from Operations.
3.Differentiate between Cash Profit and Book Profit (any two points).
4.What is Horizontal Analysis?
5.What is meant by Paid Costs and Unpaid Costs?
6.Horizontal Analysis Vs.Vertical Analysis
7.Comparative Vs. Common size statement(Income as well Balance sheet)
Long questions:
1.Describe its format and significance in Funds Flow Analysis.
2.Explain how it is calculated and its importance in preparing a Funds Flow Statement.
3.Discuss operating, investing, and financing activities as per accounting standards(Including formats)
4. Differentiate between cash flow and funds flow statements.
Numeric:
1.Comparative Income statement & Balance sheet
2.Common size Income statement & Balance sheet
3.Cash flow statement
4.Funds flow statement
Unit-5
Short questions
1.What is meant by Analysis and Interpretation of Financial Statements?
2.Define Liquidity Ratio. Give one example.
3.What is Du Pont Analysis?
4.What are Ind AS?
5.What is IFRS?
6.List out various types of ratios
7.What is Debt-Equity ratio
8.How to calculate Cost of goods sold(COGS)?
Long questions
1.What is Ratio analysis, explain its advantages & Limitations
2.Discuss various types of ratios/classification of financial ratios
3.Explain the significance of ratios using examples
4.Explain the importance of Indian Accounting Standards (Ind AS) and their convergence with International Financial Reporting Standards (IFRS).
Numeric:
1.Liquidity ratios
2.Solvency ratios
3.Turnover/Activity ratios
4.Profitability ratios
All the best
Dear MBA Students, fill the following google form related to SDA Lab-Practice purpose only.
Dear students, click the link to download the financial statements (sample) of a limited company.
Thank you
SINGLE ENTRY SYSTEM-SUMS
1.Find the Opening capital of business with the help of following information
* Closing capital : 210000
* Additional capital : 50000
* Drawings : 20000
* Interest on capital - 10000
* Interest on Drawings- 5000
*Net Profit- 25000
2.Mr.Shankar commernced business on 1st January,2012 with the capital of 15,000, on 1st July,2012, he introduced a further capital of 8000. During the year he withdrew 500 P.M for domestic use. on 31st Dec-2012 the following Assets & Liabilities are as follows.
*Stock - 21,000
*Debtors - 10,000
* Furniture - 3500
* Creditors - 8,300
* Cash at bank - 2100
* Expenses unpaid - 700
Prepare statement of affairs and find the Net Profit or Net Loss of his business.
Dear students, click the title of the post to attempt quiz for unit-3
Goodluck
Dear Students, click the above title to download excercises for practice on 03-01-2026, every student should download or copy the data to excel and apply those techniques and write the output in your observation note book(Interpret the output).
All the best
Dear Students, click the title of the post to download the format for Stock/Inventory valuation.
Thank you
Dear Students, click the link to download Unit-3 sums related to Depreciation, Goodwill & FIFO , LIFO, Simple & Weighted average.
Thank you
Dear students, click the title of the post to attempt the Unit-2 quiz.
All the best.
Dear students, click the link to download the Unit-II Presentation.
Thank you
Dear Students, click the above link to download the FRA Sums.
Thank you
Dear Students, click the title to download SDA Lab Practice sheet.
Thank you
Dear All,
I am pleased to present my paper titled ‘Emerging Trends in Carbon Credits – A Comparative Study Among Industries in India’, conducted under Annamalai University. This study highlights how different industries are adapting to carbon credit mechanisms, the progress made in reducing emissions, and the key trends shaping India’s transition towards a low-carbon economy.
Thank you.
Dear Student, click the title of the post to download Template
Thank you
Dear Students, click the title of the post to download Unit 2 sums
Thank you
Dear Students, click the title of the post to attempt quiz for unit-1
I wish you all the best
Dear Students, click the title of the post to download Presentation.
Thank you
Dear Students, click the link to download MBA I-I, Financial Reporting & Analysis Syllabus.
Thank you
I’m delighted to share that I have successfully completed the Faculty Development Programme (FDP) on Transforming Financial Services in the Digital Era(Embedded Finance-Focus Area). This program offered valuable insights into how financial services are being seamlessly integrated into non-financial platforms, shaping the future of fintech. It was an enriching experience to explore innovative financial technologies, digital payment systems, and the evolving regulatory frameworks driving this transformation. Grateful for the opportunity to enhance my knowledge and stay updated with the latest trends in the financial ecosystem.
Thank you all
K.Sreenivasa Charyulu(Ph.D)
Dear students, click the title of the post to download Financial Analytics-Introduction Presentation.
Thank you
Dear Students, Click the title of the post to access the following
1.Word of the Day according to your roll number
2.Unit wise practice sums
3.Assignment questions
Thank you
Dear Students, Excel is an essential tool in finance because it helps professionals handle large amounts of numerical data, perform quick and accurate calculations, and apply financial formulas like NPV, IRR, and ROI with ease. It allows budgeting, forecasting, valuation, and risk analysis while reducing manual errors and improving accuracy. With features like pivot tables, charts, and dashboards, Excel also helps in analyzing trends and presenting financial information clearly for better decision-making. Since it is widely used across industries, Excel has become a universal and flexible tool that makes financial work faster, more reliable, and more effective.
NPTEL is offering a very useful course on **Excel for Finance**, which will greatly help you in handling financial data, performing calculations, and improving your analytical skills. Since Excel is a must-have tool for finance professionals, this course will strengthen your knowledge and practical application.
https://onlinecourses.swayam2.ac.in/imb25_mg206/preview
Make sure you don’t miss this opportunity to enhance your finance and analytical skills with guidance from NPTEL experts.
Thanks & Regards
K.Sreenivasa Charyulu(Ph.D)
Assistant Professor
I am happy to share that I have Successfully completed Power BI for Beginners Certification
Thank you
Dear Students, I am sharing Recent question paper on BEFA for practice, download it for your reference.
Thank you
Hi K.Sreenivasa Charyulu, Congrats! You have successfully completed your Business Analytics with Excel training and earned your certificate. Please download it from here. https://lms.simplilearn.com/#/course/2738-Business-Analytics-with-Excel/showCertificate/ Thanks, Team Simplilearn
I have successfully completed SWAYAM-NPTEL Course on Advanced Financial Analytics
Thank you very much
Dear Students, Click the title of the post to download SDA Lab Practice sheet (SPSS)
Dear Students, click the title of the post to download the Company's balance sheet.
Thank you
Dear Students, Click the title of the post to download SPSS Practice file.
Dear Students, click the title of the post to fill the google form related to spss.
UNIT-1
Long Questions
1.
Define
Financial Analytics? Discuss the Need & Importance of Financial analytics
2.
Describe
scientific methods in Finance
3.
Explain
how Financial analytics helpful for Business and also explain uses of it
4.
Discuss
empirical studies & research in Finance
5.
Outline
various software packages for Financial data analysis
Short
questions
1.
Financial
Analytics Vs. Financial Analysis
2.
Financial
Analytics Vs. Financial Modeling
3.
What
is Financial Data?
4.
What
are various steps in SPSS
UNIT-2
1.
Explain
various Financial functions used in MS Excel
2.
Discuss
the PV, FV, NPV & IRR functions calculation process using Excel
3.
Explain
Various Finance tools used under Portfolio Management
4.
Discuss
the Annual return & Risk calculation process using Excel
5.
Discuss
the correlation function using example and its calculation process using Excel
Short
questions
1.
Define
Finance Function
2.
PV
Vs. FV function in excel
3.
NPV
Vs. IRR function in excel
4.
Angle
of Incidence
5.
XNPV
& XIRR
6.
What
is Annuities?
7.
Beta/Market
Beta/Systematic Risk
UNIT-3
Long Questions
1.
Explain
various characteristics of statistics & Various types
2.
Discuss
various scaling Techniques using examples
3.
Discuss
the Graphical representation of data using MS Excel
4.
Discuss
the applications of measures of central tendency
5.
Explain
important characteristic of good measure of dispersion
Short
questions
1. Descriptive
statistical tools
2. Symmetry,
Skewness & kurtosis
3. Population
vs. Sample
4. Parametric
Vs. Non-Parametric Test
5. Independent
Vs. Dependent variable
6. Correlation
Vs. Regression
UNIT-4
Long Questions
1.
Explain
the Applications of correlation from Investment point of view
2.
Write
the step by step procedure of calculation of Avg. Return, Risk & portfolio
using example
3.
Discuss
the Calculation procedure of MMULT &
TRASPOSE functions in MS Excel using example
4.
What
is Scatter Plot diagram, explain the procedure to draw using MS Excel
5.
Explain
various types of correlation using examples
Short
questions
1.
Investment
vs. speculation
2.
Risk
vs. Return
3.
Systematic
Risk vs. Unsystematic Risk
4.
Positive
correlation vs. Negative correlation
5.
CAPM
6. SML
UNIT-5
Long Questions
1.
Explain
the concept of Financial forecasting & its significance
2.
Discuss
various types of Financial forecasting
3.
What
is simple linear regression, explain its applications (Using MS Excel)
4.
What
is Multiple linear regression, explain its applications (Using MS Excel)
5.
Explain
the concept of Testing the equality of population regression coefficient to be
zero using examples
Short questions
1.
Dummy
variable
2.
Predictive
variable Vs. Dependent variable
3.
Simple
linear regression Vs. Multiple linear regression
4.
List
out categorical variables
5.
List
out quantitative methods in Finance
UNIT-6
Long Questions
1.
Explain
Predictive analytics need & importance
2.
Discuss
the applications of Time series analysis concept
3.
Explain
the concept of Time plot statistics
4.
Discuss
various Time series forecasting methods
5.
Discuss
the concept of Autoregressive time series model and its applications
6.
Explain
the concept of Random walk and Unit root concepts
7.
Discuss
various Trend models in Predictive analytics
Short
questions
1.
ARMA
Vs. ARIMA
2.
Time
series Vs. Cross sectional
3.
Time
series Vs. Panel data
4.
Panel
survey Vs. Longitude survey
5.
Stationary
data vs. Non-stationary data
I am delighted to announce that I have been awarded a certificate for presenting my research paper at the International Conference at CBIT, Hyderabad. This experience has been incredibly enriching, providing an excellent platform to share insights, engage with fellow researchers, and contribute to the ongoing dialogue in my field of study. A heartfelt thank you to the organizers, mentors, and peers who made this event a memorable and rewarding experience. This achievement motivates me to continue exploring and contributing to meaningful research.
I am thrilled to announce that I have successfully qualified for the NTA NET Exam in Management-Ph.D ! 🎓 This achievement marks a significant milestone in my academic and professional journey. I am deeply grateful for the support and encouragement from my family, friends, and mentors, who played a pivotal role in this success. Your guidance and motivation have been invaluable. This accomplishment inspires me to continue my pursuit of knowledge and contribute meaningfully to the field of Management.
Dear Students, Take the Printed copies during the discussion of solutions in the class room.
Dear Students, I am happy to announce the launch of a new course on SWAYAM-NPTEL: Financial Analytics! 💹📊
In today’s dynamic world, financial analytics is a game-changer. This course will equip you with cutting-edge tools and techniques to analyze financial data, make informed decisions, and unlock opportunities in finance and investment management. 🌟
Why should you enroll?
👉 Knowledge is the best investment you can make today!
Take the first step towards mastering financial analytics. Register now on SWAYAM-NPTEL and transform your future!
| Course Status : | Upcoming |
| Course Type : | Elective |
| Language for course content : | English |
| Duration : | 12 weeks |
| Category : |
|
| Credit Points : | 3 |
| Level : | Undergraduate/Postgraduate |
| Start Date : | 20 Jan 2025 |
| End Date : | 11 Apr 2025 |
| Enrollment Ends : | 27 Jan 2025 |
| Exam Registration Ends : | 14 Feb 2025 |
| Exam Date : | 04 May 2025 |
Link to register for the course"