Excel Class - What If Analysis - DUE THURS (10/14)

profiletwinkletoes

  

Topic: What-If Analysis (2 spreadsheets – records/loans) / Reflection Paper

Format/Length: 2 Spreadsheets – 2.1 Records & 2.2 Loans | 1 Paper - APA Format / 1-2 pages

Due: 12 pm EST – Thursday, October 13th

Info: Please see the attached assignment details and spreadsheet templates. Please read assignment details carefully.  

SUBMISSION REQUIREMENTS

1. Project2.1_Records.xlsx.file.
2. Project2.2_Loans.xlsx.file.
3. Project Reflection (see below).

PROJECT REFLECTION

a. What is the main purpose of using goal seek?
b. What were your additional amounts for monthly payments (in Part 1, Item 2), and what were the corresponding interest rates that Goal Seek found for each?
c. What decisions would you need to make when creating a worksheet to evaluate and analyze data?
d. What is one advantage of using scenarios?
e. What should you do before creating a scenario report to make the entries on the report easier to interpret?
f. What are the changing cells in a scenario?

  • 2 years ago
  • 40
Answer(2)

Purchase the answer to view it

blurred-text
  • attachment
    Project2.1_Records.xlsx
  • attachment
    Project2.2_Loans.xlsx
  • attachment
    ReflectionPaperonWhat-if-analysisinExcel..docx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    Project2.2_Loans.xlsx
  • attachment
    Project2.1_Records.xlsx
  • attachment
    PROJECTREFLECTION.docx