Email Address
Password
Forgot Password?
.............................................................................................................................DescriptionA comprehensive book on Learning Financial Management and dealing withrisk and uncertainties using models built on Excel Worksheets• The book aims on concepts, theory & practices of finance and further expanding its application to excel worksheets.• Modelling primarily cover simple sheets and data, which are added up to sophisticated models, which has the flexibility for changes.• Each topic is explained with the help of fully explained graphs and exhibits.• At the end of each chapter there are problems based on concept discussed on the topic. Number of illustrative examples are in corporated. There are solved by the basic concepts of Financial Management and further solved on excel worksheets. Besides there are number of problems on financial decisions.• There are more than 118 Exhibits and Diagrams toexplain the models and concepts with number of unsolved questions atthe end of each chapter.• 9 situation-based case studies and analytical data about the market are incorporated.• Case studies have been updated with financial data.About the CDExcel files - This folder contains all the spreadsheets, which are usedacross all the chapters, this helps the learner to associate with theEXHIBITS in the book and speeds up the learning process. User cansubstitute his/her own data to check the desired result, likecalculating EMI, Effective interest rate, Retirement planningcalculation etc.Power point slides - These slides can be used by the instructor formaking presentation and for the students to revise the key concepts inthe chapter.Case studies data - This folder contains the soft copy of data for all the case studies in the text..............................................................................................................................ContentsChapter 1 - Getting Acquainted with Basics of Modelling & ExcelChapter 2 - Basic Concepts in FinanceChapter 3 - The Individual Cost of CapitalChapter 4 - The Overall Cost of Capital Chapter 5 - Determination of Cash FlowChapter 6 - Tools for Project AppraisalChapter 7 - Practical Capital BudgetingChapter 8 - Break Even Point and LeverageChapter 9 - Designing Capital StructureChapter 10 - Dividend Policy and Value of FirmChapter 11 - Basics of Working Capital and Managing ReceivablesChapter 12 - Inventory ManagementChapter 13 - Cash ManagementChapter 14 - Working Capital FinancingAppendicesAppendix 1 - Compounded value of Rupee 1Appendix 2 - Compounded value of Annuity of Rupee 1 (Assuming Rupee to be invested at the end of the year)Appendix 3 - Compounded value of Annuity of Rupee 1 (Assuming Rupee to be invested at the beginning of the year)Appendix 4 - Present value of Rupee 1Appendix 5 - Present Value of Annuity of Rupee 1Appendix 6 - Continuous compounding of Rupee 1 and continuous Discounting of Rupee 1Appendix 7 - Technical terms and abbreviations used in the bookAppendix 8 - Description of menu reproduced from the help of menu in windowsAppendix 9 - Useful websitesSubject Index.............................................................................................................................Author DetailsDr. Ruzbeh J. Bodhanwala is working as a Trainer with a MultinationalCompany. He has also served as a faculty at FORE School of Management,Delhi and Banasthali Vidhyapith. He has also worked at GENPACT as atrainer on finance and valuation's. Since last 11 years he is intoAcademics and Research, and also has an industry experience of 3 years.He has also successfully conducted Management Development Programmesfor executives, on the topic "Finance for Non-Finance Executives" and"Valuations". He is also a researcher and actively contributes in CaseAnalysis and Articles for reputed journal in India.He is also an author of highly acclaimed book "Understanding andanalyzing balance Sheet using Excel Worksheet" and "ManagementAccounting - Text and Cases" both published by Prentice Hall of India.His Area of Interest & Specialization is Financial Management,Management Accounting, Financial Modelling and Equity Valuations..............................................................................................................................