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
1. EXAMINE & ANALYZE THE FINANCIAL RATIOS FOR EIGHT PAIRS OF UNIDENTIFIED COMPANIES A) Health Products From the market data‚ the beta of company B is slightly higher than company A. Company A appears to be less risky than company B. It is likely because company A is a diversified health-products company. Since it manufactures various products and involves in different segments‚ risk could be reduced. The liquidity ratios show that both companies A and B might not face liquidity problem. Current
Premium Financial ratios Balance sheet Financial ratio
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
Content 1. Introduction 2 2. Tricol Plc Flexed budged 2 3. The calculation of the variances and the variance rate 2 4. Variance analysis and report 3 5. Recommendation 4 6. Analysis of two investment appraisal technique 5 Assumption 5 7. Calculation of net present value 5 8. Calculation of the payback period method 6 9. Recommendation for investment decision 6 10. Consideration of other factors that management should consider 7 11. Conclusion 7 1. Introduction
Premium Net present value
CHAPTER 1 FInANCIAL ACCOUNTING AND ITS ECONOMIC CONTEXT ISSUES FOR DISCUSSION ID1–1 Security analysts and stockholders: These users would use financial statements to try to estimate the future earnings and cash flow potential of the company‚ which would be used to project a value for the company’s stock. Bank loan officers: These users would use the financial statements to determine the ability of a company to repay loans to the bank. A company’s
Premium Stock market Stock Generally Accepted Accounting Principles
financial analysis “Read the name of Lord‚ Who created man from a clot of blood. Read! The Lord is most Bounteous who taught by pen.”(96:1-4) Final Project On INDUS MOTOR COMPANY LIMITED ------------------------------------------------- Submitted By M. HASEEB 1662-111001 M.Com (FINANCE) ------------------------------- Submitted To: Registrar PIMSAT Institute of Higher Education INDUS MOTOR COMPANY THIS PROJECT IS SUBMITTED TO PIMSAT Institute
Premium Toyota
Appendix B: Financial analysis Financial analysis is the mean to clarify most important factors that affected Costco performance and resulted in companies’ success. In order to reach that goal‚ we studied financial performance of Costco for 2008 to 2012. These data obtained from different sources such as Costco annual reports and other respectable financial sources. At some levels comparison between leading companies in the industry such as Sam’s club and Bj’s has been made. The major problem that
Premium Generally Accepted Accounting Principles Balance sheet Income statement
Financial Careers What am I going to do after school or university? Maybe I should consider a job in the financial world. There’s a surprisingly wide range to choose from — for example‚ I could raise money for charities or sell famous paintings or write about economics as a financial journalist or run my own company or... Fund-raiser. There are thousands of different charities these days — e.g. ’for children’‚ ’cancer research’‚ ’the disabled’‚ ’the third world’‚ ’AIDS research’. They all do
Premium Auction Employment Economics
1. Financial Aid: I found this was a great tool for me because I found out there are different funding options that are available to me‚ including scholarships‚ state grants‚ and employer programs. I like how she said that different students come from different backgrounds‚ with different financial needs. I like how it told me what financial aid is‚ and where it comes from. And last about the two different types of loans‚ subsidized and unsubsidized loans. * Subsidized loans are for students
Premium Bond Debt Education
Financial Leverage: Financial leverage is a leverage created with the help of debt component in the capital structure of a company. Higher the debt‚ higher would be the financial leverage because with higher debt comes the higher amount of interest that needs to be paid. Leverage can be both good and bad for a business depending on the situation. If a firm is able to generate a higher return on investment (ROI) than the interest rate it is paying‚ leverage will have its positive effect shareholder’s
Premium Finance Debt Corporate finance