Master Financial Modelling with Ease - Comprehensive Study Notes for DSC2604 Course! Discover the Power of Excel in Building and Testing Financial Models, Calculating NPV, PI, IRR and Sensitivity Analysis. These Summary Notes for Semesters 1 & 2, 2023 provides key things you need to succeed in this...
,Table of Contents
............................................................................................................................................................ 2
INTRODUCTION .................................................................................................... 3
Systems, models and problem solving .................................................................... 3
Explain what is meant by systems thinking: ............................................................ 3
Describe the benefits of models: ............................................................................. 4
Construct a concept model of a system or problem: ............................................... 4
Describe the phases of the modelling process:....................................................... 4
Explanation of how to do spreadsheet tasks: .......................................................... 8
Formulas of key concepts ....................................................................................... 9
Capital budgeting .................................................................................................. 11
key formulas used in capital budgeting and their explanations: ............................ 11
Describing and modeling data using statistics ...................................................... 13
Ways To Incorporate Risk Into Capital Budgeting Decisions ................................ 15
Portfolio theory ...................................................................................................... 19
2|Page
, INTRODUCTION
Systems, models and problem solving
Explain what is meant by systems thinking:
• A way of thinking that considers the complex interactions between different
parts of a system and how they affect each other and the overall system.
• Views the system as a whole, rather than as a collection of individual parts.
• Involves analyzing feedback loops, cause-and-effect relationships, and system
dynamics.
• Aims to understand the behavior of a system and identify opportunities for
improvement.
2. Describe an entity or situation as a system:
• A system is made up of interconnected and interdependent components or
elements that work together to achieve a common goal or purpose.
• Can be a physical, biological, social, or technological system.
• Can be characterized by inputs, processes, outputs, feedback loops, and
boundaries.
• Can be analyzed using systems thinking to identify patterns and relationships
between different components and how they affect the overall system.
3. Name and describe the different types of models:
• Conceptual models: simplified representations of a system or problem that
illustrate its key elements and relationships.
3|Page
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MyStudyBudd. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R50,00. You're not tied to anything after your purchase.
