OnlineNursingOwl
← All nursing posts

Mathematics · Studypool

Mathematics Question

Post ID: 3443439

Overview

QUESTION 1:

Part 3 Financial Model

The purpose of this assignment is to develop a financial model in Excel that addresses key questions from the New Plant Planning case. This model will form the foundation for your course project, which includes a detailed paper and a screen capture video demonstrating your analysis and decision-making process.

Create a financial model in Excel that will answer the questions listed in the new plant planning case.

  1. Following these steps will help as you design and create your model in Excel:
    • Sketch the spreadsheet.
    • Organize your model into four modules or sections.
      • Input Parameters
      • Decisions - design for use by making it easy to change parameters that can be expected to change.
      • Outputs
      • Calculations

2. Start small by isolating one question at a time, then design, build, and test your model to make sure it answers that question. Then move to the next question. This way, you will begin with the simple and finish with the complex.

PLEASE DO to include the decisions or calculations to provide determinable dynamic outcomes.

Notes:

  1. Please refer to the Financial Model Rubric in the Start Here tab.
  2. You will complete the new plant planning model in MS Excel and submit the Excel file for grading. ( I HAVE ALRREADY ASKED THIS FOR LAST WEEK FOR THIS BUT WE ARE JUST MISSING to include the decisions or calculations to provide determinable dynamic outcomes)

QUESTION 2:

Course Project - Part 4 Case Study Questions Paper

The purpose of this assignment is to interpret and explain the financial and strategic insights generated by your Excel model. You will apply your analytical reasoning, financial acumen, and communication skills to thoroughly respond to the case study questions presented in the GreenTech Manufacturing scenario. This paper demonstrates your ability to synthesize quantitative results with business logic and provide decision-ready recommendations to stakeholders.

Using the New Plant Planning Model that you created in Excel, write 6-to-9-page paper answering the questions stated in the New Plant case study.

Instructions:

  1. Use Your Completed Excel Model (Part 3)
    Refer to the financial model you created in Week 6. All answers should be grounded in the model’s outputs and assumptions, including base-case, best-case, and worst-case scenarios.
  2. Answer All Case Study Questions in Detail
    Write a 6–9 page paper addressing each of the following case questions from the Course Project:
    • What is the project’s Net Present Value (NPV) and Internal Rate of Return (IRR)?
    • What is the payback period for the $1 million investment?
    • What key assumptions guided your financial model?
    • How might GreenTech evaluate or reduce input factors from the influence diagram that are outside their control?
    • What are the model results under best-case and worst-case scenarios?
    • How sensitive is the model to changes in:
      • Revenue growth
      • Labor costs
      • Discount rate
    • What operational risks could affect the project’s success?
    • Would it be more beneficial to lease a facility instead of building it?
    • Under what conditions would debt financing be more attractive than equity?
    • How do worst-case conditions impact the NPV and IRR?
    • How do the results improve under best-case assumptions?
    • Based on the financial metrics, should GreenTech proceed with the investment?
  3. Structure Your Paper Using These Required Sections:
    • Section 1: Introduction & Process Description (1–2 pages)
      Briefly introduce the project and describe your approach to building and testing the financial model.
    • Section 2: Executive Summary (2–3 pages)
      Provide a high-level summary of your findings for the stakeholders. Emphasize financial viability, risk insights, and your recommendation.
    • Section 3: Case Questions (2–5 pages)
      Answer each of the case questions thoroughly, using outputs from your model and explaining the logic behind your analysis.
    • Section 4: Conclusion (1–2 pages)
      Restate your final recommendation and support it with key financial evidence and strategic reasoning.

Notes:

  1. This assignment must be formatted in APA Style 7th edition.
  2. Please refer to the Case Study Questions Paper rubric on the start here tab for this assignment.
  3. All submissions will be reviewed by Turnitin to check for similarity to other sources. Refer to the Syllabus for more information.
  4. Part 4 of this assignment is due Sunday by 11:59 EST.

ALL OF THE PAST COURSE PROJECT ARE ATTACHED FOR REFERENCE (PART 1 and PART 2). WE JUST NEED TO MODIFY THE PART 3 to include the decisions or calculations to provide determinable dynamic outcomes