Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

each student will simulate finding and purchasing a home. The loan amount each student can afford will be based on a simulated annual income that

each student will simulate finding and purchasing a home. The loan amount each student can "afford" will be based on a simulated annual income that will be calculated below. Having selected a home to purchase within the appropriate price range, each student will identify an amortization table in a spreadsheet program detailing the repayment of the home mortgage. Modifications will then be made to the amortization table to explore the effects of various repayment options.

The problems below guide the sequence of calculations needed to answer all of the required questions. The first several problems provide an approximate (simulated) price range that each student "can afford."

  • 1. Personal Annual Income

For this project, each student will have an individual simulated annual income - annual gross income will

equal the student's current WeBWorK percentage multiplied by $68,000. WeBWorK percentage is 69.95.

Calculate and state your (simulated) annual income.

  • 2. Monthly Payment

Several factors influence how much an individual can afford to pay each month toward a home loan.

a) Find and state your monthly income by dividing your annual income by 12.

It is recommended that your housing payment never exceed 33% of your gross monthly income.

b) Find and state 33% of your monthly income.

Home mortgage payments usually include several fees which are not directly related to repaying the actual home loan - mortgage insurance, homeowner's insurance, property taxes, etc.

c) To simulate the effect of these fees (which often are as high as 15% of the actual monthly payment required by the home loan), divide the value found in part b by 1.15. This is the maximum (simulated) amount you can afford to pay each month toward a home loan. State your maximum (simulated) loan amount.

  • 3. Loan Amount

A typical home loan has a term of 30 years and a fixed APR. Using the monthly payment calculated in the previous problem, calculate and state the loan amount you can afford assuming an APR of 4.28% compounded monthly.

  • 4. Down Payment

Suppose you have been saving money to purchase this home since your 14th birthday. Calculate and state the amount you would have saved if you have been investing $95 each month (since your 14th birthday) into a savings account with an APR of 2.4%. This amount can be used as a down payment on your house.

  • 5. Purchase Price

Calculate and state your total maximum (simulated) purchase price by adding the loan amount and down payment calculated above.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential Calculus Early Transcendental Functions

Authors: Ron Larson, Robert P. Hostetler, Bruce H. Edwards

1st Edition

618879188, 618879182, 978-0618879182

More Books

Students also viewed these Mathematics questions

Question

What is the Delphi method of forecasting? Why is it a popular tool?

Answered: 1 week ago

Question

In which of the following environments can sound travel fastest?

Answered: 1 week ago

Question

Which type of energy does an object have when it is in motion?

Answered: 1 week ago

Question

The working principle of a washing machine is?

Answered: 1 week ago

Question

Nuclear sizes are expressed in a unit named?

Answered: 1 week ago