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?