Assignment 1 - Johns Home Purchase - Group F[1055].docx -...

This preview shows page 1 - 3 out of 8 pages.

Assignment 1: Modeling and Spreadsheet EngineeringGroup Member Names:Lemae BasaloFrances Jamey IbascoDivine UwihayeModelingIntroductionIn data modeling, it is important to first organize the data (numbers) and information available into the following categories:1.Assumptions: Facts that will be held constantthat will simplifya data model. This will typically be facts that tend to change over time. For example, trying to predict future interest rates is difficult, so assume inflation to be at 2% into the future). Assumptions will either be a parameteror part of thegoal.2.Parameters: The inputs that will be used in the spreadsheet calculations. a.Variable Parameters:Facts that can be changedand adjustedto meet a goal. These are facts and values that can be influenced. For example, spending habits can be adjusted if budgets cannot be initially met.b.Assumptions Parameters:Facts that will not be adjusted, they are bound by the assumptions stated.3.Goal: The outputs that will be calculated from the parameters. May include non-numerical facts that are important to note.4.Irrelevant: Facts that have no value to the problem we are trying to solveAfter the data is categorized, a problem statementcan be formulated (i.e. what are we trying to solve). The problem statement should also state any key assumptions.DeliverablesJohn is saving for a house and is planning to make a purchase after saving for an additional two years from today. Hecurrently has a planned budget, an idea of the purchase price of a house, and savings for a down payment and wouldlike to consult you to ensure his expectations are realistic. The statements below outline John’s current financial situation.1.Classify the following facts into Irrelevant, Assumption: Goal, Assumption Parameter, Variable Parameter, and Goal. Explain your choice in the justification section.StatementClassificationJustificationJohn currently has $20,000 in savingsThis amount is John’s currentsavings. It cannot be adjusted.Current mortgage interest rate is 3.00%For analysis, the current mortgage interest rate will be held constant as this may change invariably. This rate may not greatly affect John while he is saving up
but has a significant impact after he purchases it as his installment payments are applied first to interest before principal home loan.John works in MarketingJohn could work in some other lucrative field as a part-time or he could perform well at his current job to receive a raiseCurrent unemployment rate is 6%This does not directly affect his decision of purchasing a house since he currently has a safe employment.John’s budget for buying a house is $400,000This is the target purchase price of the house that John wants to purchase.John currently rents for $1500 a monthIf lessor agrees, John can look for someone as additional occupant of the apartment/house he is currently renting to cut down on rent expense.John likes to go for weekly runsThis can be considered as John’s hobby. This is not in any way relevant to the

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture