Caribbean Internet Café[1] case: A tutorial in managerial accounting concepts and financial modeling using Excel Assignment 1: Introduction We will begin our work this semester with a case called Caribbean Internet Café [hereafter‚ CIC]. In the CIC case‚ David Grant wants to open an Internet Café in Kingston‚ Jamaica. This simple business setting is familiar; how many coffee shops‚ drive-up or otherwise‚ can you think of that are within walking distance of campus? Even if you are not a coffee-holic
Premium Balance sheet Variable cost Fixed cost
FINANCIAL MODELING The materials in this book are intended for instructional and educational purposes‚ to illustrate situations similar to those encountered in the real world. The reader will understand that MIT Press and its authors do not guarantee the accuracy or completeness of any information published in this book. Neither MIT Press nor its authors is responsible for the consequences of the implementation of models or information presented in this book. FINANCIAL MODELING Simon Benninga
Premium Net present value Discounted cash flow Rate of return
INDIAN INSTITUTE OF QUANTITATIVE FINANCE CERTIFICATE PROGRAM IN FINANCIAL MODELLING IN EXCEL CURRICULUM Advanced Excel (2 Days) (A) Excel Features and Techniques 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. Excel Shortcuts Excel formulae Usage of names to make formulas easier Data Sorting Excel formatting Data Formats Lines and Borders Colours and Patterns Excel functions Excel charts Dynamic Graphs Conditional Formatting Linking worksheets Data Validation Controls
Premium Discounted cash flow Financial statements Spreadsheet
8. Illustrate with an example any three profitability ratios. 9. State and explain ‘time value of money’. 10. Explain with an example‚ the ‘if-then’ analysis & features in excel enabling it. 11. Explain any three significant financial analysis features of excel. 12. Explain ‘derivatives’ trading. State its significance in modern day trading. 13. Comment on the business valuation through the ‘build-up’ method. 14. State & Explain and two methods of appraisal
Premium Spreadsheet Venture capital Microsoft Excel
Financial Modeling Discipline – Guiding Principles A good financial analyst has the discipline of adhering to a list of guiding principles to help ensure that the development of the financial model achieves the desired results. By following these simple steps‚ a financial analyst should be able to build a financial model that is simple‚ accurate and most importantly consistent‚ to help build confidence in a financial decision making process. Financial Modeling Discipline can be acquired in all
Premium Model Financial services Spreadsheet
Tutorial 1 1. Ice breaking session 2. General overview of financial markets and institutions module 3. Group project briefing 4. Mid semester and final examination 5. Other relevant matters Tutorial 2 : Financial Intermediation 1. Why is financial intermediation important in the economy? Because they channel funds from those who do not have a productive use for them (surplus sector) to those who do (deficit sector)‚ thereby resulting in higher economic efficiency
Premium Bond Stock market Stock
Tutorial Applicable to Week 2 CH2 Q2) What are the critical drivers of industry profitability? 1. Rivalry among existing firms The greater the degree of competition of firms in an industry‚ the lower their average. Existing firm rivalry is influenced by: industry growth rate‚ concentration and balance of competitors‚ degree of differentiation and switching costs‚ scale/learning economies (if your working at maximum productivity you can bring costs down) and the ratio of fixed to variable
Premium Barriers to entry Coca-Cola Soft drink
Financial Statement Modeling Copyright 2008 © by Wall Street Prep‚ Inc. | All rights reserved Inc. ***************************** SAMPLE PAGES FROM TUTORIAL GUIDE ***************************** Table of contents SECTION 1: PREPARING FOR MODELING Welcome letter Introduction Gathering historical documents/information Understanding projections Modeling techniques in Excel Debt schedule Interest expense SECTION 3: ENHANCEMENTS TO A COMPLETE MODEL Balancing the model and circularity Ratio analysis
Premium Balance sheet Income statement
only a single “treasurer” to look after the financial matters of the organization. This is a good idea … But it is also a recipe for fraud. d. Several advantages can accrue to computerizing club finances. Among them are (1) greater accuracy in data recording and data processing‚ (2) the ability to output financial information in a variety of legible and professional-looking formats‚ (3)‚ (4) (5) Case 2-25‚ 2-27‚ 2-28 2-25‚ 2-27 done in tutorial 2-28. Bennet National Bank 1. The special
Premium Internal control Accounting software
calculations automatically and to change single number and update all related numbers at the click of a mouse. As one of the most popular financial software‚ spreadsheet is widely applied in areas such as accounting‚ finance‚ marketing‚ taxation‚ engineering‚ educational‚ scientific and medical fields (Ballantine‚ 1991). In 2004‚ SimCorp USA Inc and the Financial Executives Consulting Group found that about 64 percent of domestic companies depend on spreadsheet. Many authors view spreadsheet as a very
Premium Computer Internet Education