447 Financial Modelling & Analysis courses

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Cashflow Management and Forecasting course teaches you how to manage personal finances better. Throughout the course, you will learn to create a sales forecast, and able to maintain your own personal flow. The course also shows you how to reduce debt to improve your flow. The course explains two things: Sales forecasting and Cashflow management. You will learn about cash flow and know in which cash flows into you, improvements to the cash flow, and the common cash flow problems. The course is best for the people who are currently working in the accounts or finance department or want to obtain the career of an accountant. Upon completion, you will be able to create cash flow forecasts and report back to the owners of the firm. In short, the course teaches you to forecast and manage the cash flow. What Will I Learn? By the end of the course, you will be able to forecast and manage the cash flow Manage personal finances better Requirements You'll need to be prepared to dig out your own bank statements (last 3 months min) so that you can fill in the template No previous accounting or finance knowledge required or assumed Module 01 Introduction FREE 00:03:00 What is Cashflow? 00:08:00 Forecasting FREE 00:10:00 Planning and Management 00:08:00 Planning Part 2 00:12:00 Module 02 Where it can go Wrong 00:09:00 Personal Cashflow Analysis 00:05:00 Personal Cashflow Analysis my Numbers Story 00:06:00 Debt 00:10:00 Conclusion 00:04:00

🚀 Unlock Financial Excellence: Mastering Financial Stability - Part 3 - Workforce Deployment and Cost Strategies!   Are you ready to elevate your financial game and transform your business into a powerhouse of stability and success? Introducing our cutting-edge online course - 'Mastering Financial Stability - Part 3: Workforce Deployment and Cost Strategies.' 🌐💼 Course Overview: 🔍 Module 1: Your Staffing Model Learn to design the perfect staffing model tailored to your business needs. Discover strategies for optimizing your workforce to enhance productivity. Understand the art of balancing skills, roles, and responsibilities for maximum efficiency. 🚀 Module 2: Staffing Model Walk-Through Dive deep into real-world case studies and practical examples. Get hands-on guidance on implementing your customized staffing model. Master the art of workforce deployment for peak performance and scalability. 💡 Module 3: Your Expense Model Uncover the secrets to creating a robust expense model that aligns with your business goals. Explore cost-saving opportunities without compromising quality. Develop a keen understanding of expense allocation for sustainable financial health. 🔥 Module 4: Expense Model Walk-Through Navigate through live demonstrations and simulations. Fine-tune your expense model with expert guidance. Implement cost-effective strategies that drive long-term financial stability. What Sets This Course Apart? 🌟 Expert Guidance: Led by industry experts with years of hands-on experience. Practical insights and strategies you won't find elsewhere. 🤝 Interactive Learning: Engage in live Q&A sessions and discussions. Collaborate with like-minded professionals for a dynamic learning experience. 📈 Applicability: Directly apply learned concepts to your business for immediate results. Unlock the potential for sustainable growth and financial prosperity.   💼 Tailored for Success: Specifically designed for business owners, executives, and finance professionals. Relevant, actionable content that addresses the challenges of workforce deployment and cost management. Enroll Today and Secure Your Financial Future! Don't miss this opportunity to revolutionize your approach to financial stability. Join 'Mastering Financial Stability - Part 3' now and gain the knowledge and tools needed to propel your business to new heights!   🎓 Enroll Now and Empower Your Financial Future! 🚀🌐💰   Course Curriculum Your Staffing Model Your Staffing Model 00:00 Employee ROI 00:00 Staffing Classifications 00:00 Staffing Model Walk-Through Working with the Staffing Worksheet 00:00 Inputting Contractors 00:00 Employee Overhead 00:00 Your Expense Model Expense Model Explained 00:00 Expense Model Walk-Through Expense Worksheet Explained 00:00

Discounted Course | Premium Audio-Visual Training by Expert Professionals | CPD Accredited Course | 24x7 Tutor Support

Build- to- rent involves the construction of purpose- built residential buildings with the intention of renting out the units for the long term, rather than selling the individually. On this webinar, we will introduce the concept of Build-to-rent (BtR) and explore the key features, including design considerations, financial models and management strategies. We will also discuss the benefits of BTR investors, tenants, and communities as well as potential challenges and risk associated with this type of investment.

Course overview Financial analysis is a crucial part of a successful business. It helps companies to make informed decisions regarding investing. Learn how to make a practical analysis of financial statements with this Financial Statement Analysis Masterclass program.  This Financial Statement Analysis Masterclass course explains the steps involved in a practical financial statement analysis in detail. It will also educate you on the importance of financial accounting in businesses. Going through the lesson, you will develop a comprehensive understanding of GAAP rules, correct timing, earnings management and financial valuation. In addition, you will understand the importance and purpose of executive compensation and identify its major components. You will also learn how to prepare and analyze a balance sheet and the steps to prepare a cash flow statement.  Learning outcomes Explore the steps to an effective financial analysis Understand the GAAP requirements for creating financial statements Deepen your understanding of earnings management Learn about applying ratios Deepen your understanding of owner's equity Know how to prepare a cash flow statement Who Is This Course For? This Financial Statement Analysis Masterclass course is highly beneficial for anyone interested in learning the steps for an effective financial statement analysis. In addition, the skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Financial Statement Analysis Masterclass Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Financial Analyst Financial Advisor Financial Planning Analysis Manager Financial and Management Accountant Introduction to the Course Introduction 00:02:00 Module 01: Why Analyse Financial Statements? Why Analyse Financial Statements? 00:10:00 Module 02: GAAP Rules GAAP Rules 00:10:00 Module 03: Correct Timing Correct Timing 00:15:00 Module 04: Earnings Management Earnings Management 00:11:00 Module 05: Balance Sheet Balance Sheet 00:11:00 Module 06: Balance Sheet Part-2 Balance Sheet Part-2 00:11:00 Module 07: Balance Sheet Part-3 Balance Sheet Part-3 00:07:00 Module 08: Statement of Cash Flow Statement of Cash Flow 00:07:00 Module 09: Time Series Time Series 00:11:00 Module 10: Ratios- Introduction Ratios- Introduction 00:16:00 Module 11: Applying Ratios Applying Ratios 00:19:00 Module 12: Valuation Valuation 00:14:00 Module 13: Credits Credits 00:07:00 Module 14: Contracts Contracts 00:10:00 Module 15: Executive Compensation Executive Compensation 00:12:00 Module 16: Lease Lease 00:08:00 Module 17: Owners' Equity Owners' Equity 00:07:00 Module 18: Earnings Per Share Earnings Per Share 00:16:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Did you know that the average salary for Mortgage Advisors and Financial Advisors in the UK is around £30,000 to £60,000 per year? Such professions require a deep understanding of complex financial landscapes, and that's where our bespoke course bundle comes into the picture. Our rigorous training module will equip you with the knowledge to break into this lucrative field, explore your potential and set your path to increase your yearly earnings. Introducing our three-course bundle: "Financial Analysis for Mortgage & Financial Advisor" that offers in-depth theoretical knowledge in finance, enhancing career prospects, increasing earning potential, and providing a comprehensive understanding of mortgage advising, tax accounting, and financial advising. Immerse yourself in our carefully curated three-course bundle titled "Financial Analysis for Mortgage & Financial Advisor". Each course within the bundle, which includes the "Mortgage Advisor Course", "Advanced Tax Accounting", and "Finance: Financial Advisor", has been thoughtfully designed to ensure that you gain profound insights into the different facets of financial advising. Enrich your knowledge base, boost your understanding of complex financial concepts, and set yourself apart in the fast-paced world of finance with our comprehensive training package. This bundle includes the "Mortgage Advisor Course", the "Advanced Tax Accounting", and "Finance: Financial Advisor" course. Our training will cover a comprehensive range of financial topics, from the nitty-gritty of mortgage advising to the broader aspect of financial advising, all while delving into the intricate details of tax accounting. Immerse yourself in these diverse, enthralling subjects, each designed to fuel your curiosity and enhance your knowledge. Dive in now! The courses in this bundle include: Mortgage Advisor Advanced Tax Accounting Finance: Financial Advisor Learning Outcomes: Acquire an in-depth understanding of the mortgage advising process and the financial advisor's role. Gain knowledge on advanced tax accounting principles and how they relate to financial advising. Develop analytical skills to assess and advise on various financial products. Learn the strategies to manage wealth and advise clients on financial planning. Understand the ethical and regulatory aspects of the financial industry. Develop skills to communicate complex financial concepts to clients effectively. Our "Mortgage Advisor Course" is meticulously designed to elucidate the complexities of the mortgage advising process. It covers key financial concepts and relevant regulations in the industry to help you guide prospective homeowners effectively. The "Advanced Tax Accounting" course is a deep dive into the world of taxation. It focuses on both basic and advanced tax principles, offering you the knowledge needed to understand, compute, and explain tax-related financial matters. Lastly, our "Finance: Financial Advisor" course will develop your proficiency in offering sound financial advice. With a concentration on wealth management, retirement planning, and investment strategies, this course will elevate your understanding of the financial landscape. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring financial advisors looking to enhance their theoretical knowledge. Individuals aiming to build a career as mortgage advisors. Finance students seeking an in-depth understanding of advanced tax accounting. Professionals in the financial sector who are aiming to broaden their skills. Any individuals who are interested in deepening their knowledge in financial advising and tax accounting. Career path Mortgage Advisor: £30K to £50K/year. Financial Advisor: £30K to £60K/year. Tax Accountant: £25K to £45K/year. Wealth Management Advisor: £40K to £70K/year. Retirement Planner: £35K to £55K/year. Investment Strategist: £50K to £80K/year. Portfolio Manager: £60K to £90K/year. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - £9.99 Unlock your potential and showcase your accomplishments with our CPD Quality Standards certificates! Upon successful completion of the course, learners can obtain a CPD Quality Standards PDF certificate for Mortgage Advisor absolutely free! Upon finishing Advanced Tax Accounting and Finance: Financial Advisor, you'll have the opportunity to obtain valuable proof of your achievement. For just £4.99, we'll send you a CPD Quality Standards PDF Certificate via email, or if you prefer, you can get a beautifully printed hardcopy certificate for £9.99 in the UK. If you're located internationally, don't worry! We offer a printed hardcopy certificate for £14.99, ensuring your success knows no boundaries. Grab your certificate and celebrate your success today!

Learn how to create effective business plans through forecasting and budgeting with our specialized course. Gain practical skills in predicting future financial outcomes, allocating resources, and setting strategic goals. Explore techniques for budget development, financial modeling, and risk assessment to ensure the success of your business ventures. Whether you're an entrepreneur, manager, or aspiring business professional, this course provides valuable insights and tools to help you make informed decisions and achieve your business objectives.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Computer Simulation of Realistic Mathematical Models Training Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Computer Simulation of Realistic Mathematical Models Training Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Computer Simulation of Realistic Mathematical Models Training Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Computer Simulation of Realistic Mathematical Models Training Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Computer Simulation of Realistic Mathematical Models Training? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Computer Simulation of Realistic Mathematical Models Training there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Computer Simulation of Realistic Mathematical Models Training course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Computer Simulation of Realistic Mathematical Models Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Computer Simulation of Realistic Mathematical Models Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Computer Simulation of Realistic Mathematical Models Training is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:04:00 Section 02: Prey-Predator Model Pure prey-predator model 00:06:00 Equilibrium points and their stability 00:05:00 Equilibrium points in the prey-predator model 00:03:00 Section 03: Constructing the Model with Open-Source Software Introduction to Scilab 00:03:00 Constructing the model with Scilab part 1 00:09:00 Constructing the model with Scilab part 2 00:18:00 How parameters affect the output of the model 00:09:00 Influence of fishing on the model 00:11:00 Addition of logistic terms to the model 00:13:00 Section 04: Evolution of Epidemics Model on the evolution of epidemics 00:16:00 Assignment Assignment - Computer Simulation of Realistic Mathematical Models Training 00:00:00

Overview This comprehensive course on Banking and Finance Accounting Statements Financial Analysis will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Banking and Finance Accounting Statements Financial Analysis comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Banking and Finance Accounting Statements Financial Analysis. It is available to all students, of all academic backgrounds. Requirements Our Banking and Finance Accounting Statements Financial Analysis is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 54 lectures • 04:53:00 total length •Introduction to Financial Statements and Analysis: 00:05:00 •Why are Financial Statements Important: 00:07:00 •What do we mean by Financial Accounting?: 00:04:00 •Accounting Standards and why they are important: 00:06:00 •The Concepts and Principles Underlying Accounting: 00:06:00 •Single Entry vs Double Entry Book Keeping: 00:08:00 •Understanding The Accounting Equation: 00:06:00 •The Accounting Cycle: 00:05:00 •Financial Statements: 00:07:00 •Section Introduction - Understanding Financial Statements: 00:02:00 •Overview of Financial Statements: 00:03:00 •GAAP: Accruals and Cash Accounting: 00:06:00 •Income Statement or Profit and Loss Account: 00:08:00 •Introduction to the Balance Sheet: 00:11:00 •Introduction to the Cash Flow Statement: 00:06:00 •Cash Flow Metrics Explained: 00:09:00 •Case Study- Apple Financial Statements: 00:04:00 •What is Working Capital: 00:03:00 •What is the Working Capital Cycle?: 00:05:00 •Why is working Capital Management important: 00:05:00 •Working Capital Analysis: 00:05:00 •Working Capital Ratios: 00:07:00 •Working Capital Policies: 00:05:00 •Working Capital Summary: 00:03:00 •Section Introduction: Strategic Financial Analysis: 00:01:00 •What is Financial Analysis?: 00:11:00 •Measures of Profitability Financial Analysis: 00:04:00 •Balance Sheet Ratio Analysis: 00:12:00 •Cash Flow Statement Analysis: 00:05:00 •Valuation Ratios: 00:04:00 •Section Introduction: Financial Analysis - Case Study and Assignment: 00:01:00 •Case Study Assignments Apple Inc Financial Analysis: 00:06:00 •Apple Inc Financial Analysis - Solution: 00:03:00 •Discussion of Measurements of Growth Analysis: 00:05:00 •Discussion of Measures of Profitability Analysis: 00:07:00 •Discussion of Trading Performance Analysis: 00:03:00 •Discussion of Working Capital (Liquidity and Efficiency) Analysis: 00:12:00 •What do we mean by Corporate Finance?: 00:06:00 •Financial Ratios in Corporate Finance: 00:03:00 •Liquidity Ratios in Corporate Finance: 00:08:00 •Operational Risk Ratios in Corporate Finance: 00:08:00 •Profitability Ratios in Corporate Finance: 00:08:00 •Efficiency Ratios in Corporate Finance: 00:07:00 •Why is modelling so critical: 00:03:00 •Three Models You Will Need: 00:08:00 •Understanding The Integrated Financial Statements Model: 00:06:00 •The Integrated Financial Statements Model Example: 00:07:00 •Key Tips to Modelling the Integrated Financial Statements Model: 00:02:00 •Assignment - Banking and Finance Accounting Statements Financial Analysis: 00:00:00 •Understanding the Discounted Cash Flow Formula: 00:06:00 •Understanding the Merger Model: 00:08:00 •Course Summary and Wrap Up: 00:03:00 •Banking and Finance Accounting Statements Financial Analysis: 00:00:00 •Assignment - Banking and Finance Accounting Statements Financial Analysis: 00:00:00