Mod 15 HW
.xlsx
keyboard_arrow_up
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
*** 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
Related Questions
A self-employed person deposits $2,000 annually in a retirement account (called a Keogh or H.R. 10 plan) that earns 8 percent. Use Appendix A and Appendix C to answer the
questions. Round your answers to the nearest dollar.
a. How much will be in the account when the individual retires at the age of 65 if the savings program starts when the person is age 40?
$
b. How much additional money will be in the account if the saver defers retirement until age 70 and continues the contributions?
c. How much additional money will be in the account if the saver discontinues the contributions at age 65 but does not retire until age 70?
2$
arrow_forward
To help pay for an estimated $35000 in college expenses, parents make a deposit into a college fund at the beginning of each half-year over the course of 17 years. If this fund earns 6% interest, compounded semiannually, how large must these deposits be in order to pay for the estimated expenses? Round your answer to the nearest cent.
arrow_forward
A self-employed person deposits $4,000 annually in a retirement account (called a Keogh or H.R. 10 plan) that earns 7 percent. Use Appendix A and Appendix C to answer the questions. Round your answers to the nearest dollar.
How much will be in the account when the individual retires at the age of 65 if the savings program starts when the person is age 50?$
How much additional money will be in the account if the saver defers retirement until age 70 and continues the contributions?$
How much additional money will be in the account if the saver discontinues the contributions at age 65 but does not retire until age 70
arrow_forward
Your parents contribute $180 monthly to a college savings plan for you that earns 5.4% compounded monthly. The first deposit was exactly 18 years ago. Find the account balance immediately after today’s monthly deposit and crediting of interest.
a. $69,456
b. $65,975
c. $45,589
d. $59,689
e. $72,096
arrow_forward
The expenses and income of an individual
are given in table form to the right. Find the
net monthly cash flow (it could be positive
or negative). Assume salaries and wages
are after taxes. When you need to convert
between weeks and months, assume that
1 month = 4 weeks.
Income
Part-time job: $800/month
College fund from grandparents:
$350/month
Scholarship: $6600/year
The net monthly cash flow is $ (Round to the nearest dollar as needed.)
Expenses
Rent: $500/month
Groceries: $50/week
Tuition and fees: $3600 twice a
year
Incidentals: $90/week
arrow_forward
4. Gabriel Godwin purchases a tiny home for his elderly mother. After a large down payment, he finances $88,600 at 5% for 10 years.
Prepare a repayment schedule for the first two payments.
This should be in a table
Payment Number
Total Payment
Interest Payment
Principal Payment
Remaining Balance
arrow_forward
Please show answers using excel
arrow_forward
Answer/fill in the rest of the questions
arrow_forward
Please provide the given, required, and complete solution with units. Thank you.
At age 30, Angelica deposited $150 at the end of each month into SSS that pays 4% interest compounded monthly. At age 65, how much interest did she earn?
arrow_forward
When you begin your new job, your employer says they will match any 401k deposits
you make by 50% up to 5% of your overall salary annually. When you start your new
job as a college grad, you will make $50400 per year and you decide to take full
advantage of the matching by depositing 5% of your monthly salary every month.
a) How much will YOU be depositing in the 401k each month from your salary?
$
b) How much will YOUR EMPLOYER be depositingin the 401k each month?
c) How much TOTAL will be deposited into your 401k each month?
$
d) How much will you have in the account in 35 years if it pays 7.5% APR?
$
e) How much total money will you put into the account after 35 years?
$
f) How much total will the employer have put into the account after 35 years?
$
g) How much total interest will you earn?
$
h) If you choose NOT to take advantage of depositing money into the 401k because
you feel you need that money to pay bills now, how much money will you be losing
from your employer and interest…
arrow_forward
Urgent asap plz ..(hand written)
arrow_forward
Need help
arrow_forward
Self-employed persons can make contributions for their retirement into a special tax-deferred account called a Keogh account. Suppose you are able to contribute $20,000 into this account at the end of each year. How much will you have at the end of 25 years if the account pays 2% annual interest? (Round your answer to the nearest cent.)
___$
arrow_forward
Anna receives $150 a month for four years while she attends college to earn a bachelor's degree. At a 6.25 percent discount
rate compounded monthly, what are these payments worth to you on the day she enters college?
O $4,800.00
$6,355.98
O$4,608.87
O $4,201 20
O $6.789.92
arrow_forward
I need more assistance with this sub-part to the question please.
arrow_forward
Please help me.
Thankyou.
arrow_forward
.A self-employed person deposits $3,000 annually in a retirement account (called a Keogh or H.R. 10 plan) that earns 8 percent. How much additional money will be in the account if the saver defers retirement until age 70 and continues the contributions?
arrow_forward
Direction: Solve the following problems and show your complete solution.
1. Aina, who works in an accounting firm, earns a monthly salary of P35,000 per month and
also receives P3,500 for a monthly allowance. Her monthly contributions are as follows:
P1,466 for income tax, P300 for PhilHealth, P800 for SSS, and P100 for Pag-IBIG. Find
her gross and net income for this month.
salary of
basic salary of P3
2. Cathy, a police officer, gets a basic
P39,000 a month, monthly allowance of
P2,000 and a hazard pay of P2,500. Find her annual gross income.
arrow_forward
A man borrows $60,000 to help pay for his college expenses. He intends to pay off the loan with regular monthly payments over the next 20 years. Find the monthly payment if he is being charged 4.7% interest per year, compounded monthly.
Give the answer to 2 decimal places, and do not use the $ sign in the answer box.
The monthly payment is Blank 1. Calculate the answer by read surrounding text. dollars.
arrow_forward
Sarah had been contributing $300 pre-tax per month to a retirement account that pays 2.16% interest compounded monthly. After 10 years, she needs to withdraw 25% of the money from her account. If the early withdrawal penalty is 10% of the amount withdrawn, how much will she have to pay?
a. $1,003.59 b. $40,143.57 c. $4,014.36 d. $10,035.89
arrow_forward
You owe $32,000 to your parents for
funding some of your college fees. You
promise to make 5 annual payments of
$8,200 to settle your debt. Approximately
what interest rate are your parents
charging, if you make the 5 annual
payments beginning one year from now?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- A self-employed person deposits $2,000 annually in a retirement account (called a Keogh or H.R. 10 plan) that earns 8 percent. Use Appendix A and Appendix C to answer the questions. Round your answers to the nearest dollar. a. How much will be in the account when the individual retires at the age of 65 if the savings program starts when the person is age 40? $ b. How much additional money will be in the account if the saver defers retirement until age 70 and continues the contributions? c. How much additional money will be in the account if the saver discontinues the contributions at age 65 but does not retire until age 70? 2$arrow_forwardTo help pay for an estimated $35000 in college expenses, parents make a deposit into a college fund at the beginning of each half-year over the course of 17 years. If this fund earns 6% interest, compounded semiannually, how large must these deposits be in order to pay for the estimated expenses? Round your answer to the nearest cent.arrow_forwardA self-employed person deposits $4,000 annually in a retirement account (called a Keogh or H.R. 10 plan) that earns 7 percent. Use Appendix A and Appendix C to answer the questions. Round your answers to the nearest dollar. How much will be in the account when the individual retires at the age of 65 if the savings program starts when the person is age 50?$ How much additional money will be in the account if the saver defers retirement until age 70 and continues the contributions?$ How much additional money will be in the account if the saver discontinues the contributions at age 65 but does not retire until age 70arrow_forward
- Your parents contribute $180 monthly to a college savings plan for you that earns 5.4% compounded monthly. The first deposit was exactly 18 years ago. Find the account balance immediately after today’s monthly deposit and crediting of interest. a. $69,456 b. $65,975 c. $45,589 d. $59,689 e. $72,096arrow_forwardThe expenses and income of an individual are given in table form to the right. Find the net monthly cash flow (it could be positive or negative). Assume salaries and wages are after taxes. When you need to convert between weeks and months, assume that 1 month = 4 weeks. Income Part-time job: $800/month College fund from grandparents: $350/month Scholarship: $6600/year The net monthly cash flow is $ (Round to the nearest dollar as needed.) Expenses Rent: $500/month Groceries: $50/week Tuition and fees: $3600 twice a year Incidentals: $90/weekarrow_forward4. Gabriel Godwin purchases a tiny home for his elderly mother. After a large down payment, he finances $88,600 at 5% for 10 years. Prepare a repayment schedule for the first two payments. This should be in a table Payment Number Total Payment Interest Payment Principal Payment Remaining Balancearrow_forward
- Please show answers using excelarrow_forwardAnswer/fill in the rest of the questionsarrow_forwardPlease provide the given, required, and complete solution with units. Thank you. At age 30, Angelica deposited $150 at the end of each month into SSS that pays 4% interest compounded monthly. At age 65, how much interest did she earn?arrow_forward
- When you begin your new job, your employer says they will match any 401k deposits you make by 50% up to 5% of your overall salary annually. When you start your new job as a college grad, you will make $50400 per year and you decide to take full advantage of the matching by depositing 5% of your monthly salary every month. a) How much will YOU be depositing in the 401k each month from your salary? $ b) How much will YOUR EMPLOYER be depositingin the 401k each month? c) How much TOTAL will be deposited into your 401k each month? $ d) How much will you have in the account in 35 years if it pays 7.5% APR? $ e) How much total money will you put into the account after 35 years? $ f) How much total will the employer have put into the account after 35 years? $ g) How much total interest will you earn? $ h) If you choose NOT to take advantage of depositing money into the 401k because you feel you need that money to pay bills now, how much money will you be losing from your employer and interest…arrow_forwardUrgent asap plz ..(hand written)arrow_forwardNeed helparrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you