Mod 15 HW

.xlsx

School

Utah State University *

*We aren’t endorsed by this school

Course

2010

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

35

Uploaded by ConstableElementWaterBuffalo

Report
*** STUDENTS - using the information provided below and the worksheets that follow, answer the que Problem Details Assume that you have been working for about five years and have been saving up to move into a home. The following information relates to your monthly paycheck and withholdings: * You estimate your combined state and federal income tax rate is 20% * You contribute $700 per month out of each paycheck to your 401k * $500 is withheld from each paycheck for health insurance * You have FICA withholdings of 7.65% from every paycheck You also create an estimate of your monthly expenses (before any housing costs), as follows: * Food: $ 800.00 * Utilities: 400.00 * Gas: 250.00 * Emergency Fund: 480.00 * Clothing: 200.00 * Medical: 265.00 * Personal: 110.00 * Entertainment: 290.00 * Life Insurance: 40.00 QUESTION 1: What is your monthly take-home pay? Monthly Pay: Monthly Gross Pay $ 12,250.00 taxes (2,450.00) 401K (700.00) Health Insurance (500.00) FICA (937.13) total $ 7,662.88 QUESTION 2: Based on the information above, what is the maximum amount that you could afford to Max monthly payment: take home pay $ 7,662.88 monthly expenses (2,835.00) $ 4,827.88 * Your annual gross salary is $147,000
estions listed on the "ASSIGNMENT - PART 1" and "ASSIGNMENT - PART 2" sheets *** You first evaluate your income to determine what you can afford in terms of monthly payments. pay for housing each month? CONTINUED BELOW CONTINUED BELOW CONTINUED BELOW CONTINUED BELOW
*** STUDENTS - using the information provided below and the worksheets that follow, answer the q Part 2 Details Option 1: * The home would require 100% financing with a $590,000 loan * The interest rate on the loan is 7.25% annually Option 2: * The home would require 100% financing with a $590,000 loan * The interest rate on the loan is 6.5% annually Option 3: * Rent a home from a family member for $2,800 per month * The family member has promised that rent will stay the same for the entire 7 years * You will be responsible for all utilities while you live in the home You also determine the following relevant information: * You expect that residential real estate will grow (appreciate) at a rate of 4.5% per year over the * If you purchase a home, in addition to the mortgage payment, you will be required to purchase * If you purchase a home, your monthly escrow for property taxes will be $310 per month * If you purchase a home, you estimate monthly repairs and maintenance will cost you $175 per * You plan to invest any excess monthly cash in your 401k, which you estimate will earn 11% ann QUESTION 3: What will be the monthly MORTGAGE payment for the 30- and 15-year fixed mortgag 30-year: ($4,024.84) 15-year: ($5,139.53) Months: (278.29) QUESTION 5: What will the home be worth after living in it for 7 years? Value: $802,908.48 QUESTION 6: Assuming you select the 30-year mortgage and make no extra payments, how much w Owe: $539,827.67 PV: $1,575,002.69 QUESTION 8: Assuming you select the 15-year mortgage and make no extra payments, how much w Now that you have established your monthly budget, you are ready to compare three options that you years, after which you will move to a different location/home. * Purchase a home for $590,000 using a 30-year fixed mortgage * Purchase a home for $590,000 using a 15-year fixed mortgage QUESTION 4: If you selected the 30-year fixed mortgage and paid an additional $360 per month tow QUESTION 7: What is the present value of purchasing a home with the 30-year mortgage option (an
Owe: $383,941.74 QUESTION 9: What is the present value of purchasing a home with the 15-year mortgage option (an PV: $150,173.17 QUESTION 10: What is the present value of pursuing the rental option (and living in it 7 years)? Be s PV: $163,528.13 QUESTION 11: Based SOLELY on your time value of money calculations (from Q7, Q9, and Q10), whi Option: 15 yr mortgage Option: rent, it seems safer 30-year PV: $167,384.59 15-year PV: $160,055.07 Option: still rent, the mortgages wouldn't be affordable. QUESTION 12: Based on your time value of money calculations AND your monthly budget, which op QUESTION 13: Assume instead that home values appreciate at 4.1% annually. What is the present v
questions listed on the "ASSIGNMENT - PART 1" and "ASSIGNMENT - PART 2" sheets *** e next 7 years e mortgage insurance ($60 per month) and homeowner's insurance ($220 per month) month over the 7 years nually over the next 7 years ges (ignoring other costs)? will you still owe after 7 years? will you still owe after 7 years? u are considering. Regardless of which option you select, you plan to stay in the home for 7 CONTINUED BELOW CONTINUED BELOW CONTINUED BELOW CONTINUED BELOW ward the principal, how long (in months) would it take you to pay off the loan? Ignore your estimated residency o CONTINUED BELOW CONTINUED BELOW CONTINUED BELOW nd living in it 7 years)? Assume no additional principal payments are made. Be sure to incorporate ALL relevant in CONTINUED BELOW
nd living in it 7 years)? Be sure to incorporate ALL relevant information above. sure to incorporate ALL relevant information above ich option should you pursue? CONTINUED BELOW CONTINUED BELOW CONTINUED BELOW CONTINUED BELOW ption should you pursue? Justify your answer. CONTINUED BELOW value of each home purchase option? Which option should you pursue? Justify your answer. CONTINUED BELOW
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help