CMIS2250_Excel_Modeling_Assignment - Assignment 2 Modeling...

This preview shows page 1 - 2 out of 4 pages.

Assignment 2: Modeling and Spreadsheet Engineering Group Name: Group Member Names: 1. Classify the following facts into Irrelevant, Assumption: Goal, Assumption ParameterVariable Parameter, and Goal. Explain your choice in the justification section. , Statement Classification Justification John currently has $20,000 in savings Assumption Parameter This is a fact which cannot be changed. Current mortgage interest rate is 3.00% Assumption Parameter This is a fact which cannot be changed. John works in Marketing Irrelevant This information is irrelevant. Current unemployment rate is 6% Assumption Parameter This is a fact which cannot be changed. John’s budget for buying a house is $400,000 Variable Parameter The budget can be changed later. John currently rents for $1500 a month Assumption Parameter This is a fact which cannot be changed. John likes to go for weekly runs Irrelevant This information is irrelevant. Current annual savings rate is 2.00% Assumption Parameter This is a fact which cannot be changed. John would like to

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture