Unit 2 Case Study by shuifanglj


									Unit 2 Case Study

Karla and David’s combined income is $68,000 a year. Their banker told them that the most they
should spend for a home is 2.5 times their annual income.
   1. Determine the maximum amount that Karla and David should spend on their future
       home. (2.5 times their annual income.)
   2. Help Karla and David decide what features they should take into consideration when they
       buy a home. Create a list of the features. Then, write a two-paragraph description of their
       future home. Draw a floor plan of the home they should buy.
   3. Use the Internet to locate an ad for a home in Karla and David’s price range.
   4. Use the Bankrate.com mortgage calculator to calculate, create, copy and save an
       amortization table of their loan amount.
   5. Estimate cost of insurance at $2500 per year.
   6. Estimate cost of utilities at $300 per month.
   7. Karla and David have budgeted approximately $10,000 to furnish their home. Using the
       Internet, research prices of furnishings and create a spreadsheet list of furnishings for
       their new home. List each item/furnishing and its price.
   8. Prepare a budget for Karla and David for their first year as homeowners. Use an Excel
       spreadsheet to save the budget.

Print and turn in the above items using word documents and excel spreadsheets.

To top