FINA 2770 - Project Part 2 Fall 2023
docx
School
University of Texas, El Paso *
*We aren’t endorsed by this school
Course
2770
Subject
Finance
Date
Jan 9, 2024
Type
docx
Pages
3
Uploaded by BaronWillpower16513
Family Financial Plan Project – Part 2 – Buying a Car and a House
You have just been hired as a Level 1 Financial Coach at UNT Financial Services. Now your first clients, Latoya and Sam Kroger, have asked for your assistance putting together a simple family financial plan. They are both 27 years old and Latoya is pregnant with their first child. They plan to have at least 2 more
children over the next 5 years for a total of 3 children. They want to make sure they are taking the right steps financially. You will assist them and make recommendations to help them improve their situation in a video presentation.
Latoya and Sam have the financial goals of buying a house and buying another car. They want your help and recommendations. Remember you will enter your numbers into Canvas to check them and you will
deliver your recommendations for all parts in your video presentation at the end of the semester
.
Purchasing a Car:
Latoya wants to buy a new car, so they do not have to share the truck. Latoya has narrowed her choice to a new BMW 230i from BMW of Plano. She wants your recommendations on buying new or used. In your presentation you need to present options available in DFW between new and used models no older
than 2019 and fewer than 40,000 miles. Latoya and Sam have the following options for buying new:
2024 BMW 230i Sport Final price (including taxes and fees): $54,231
BMW Financing Options
Term in Months
48
60
72
Down Payment
10%
10%
10%
Interest Rate
2.99%
3.99%
6.49%
Monthly Payment
Total Interest Paid
Total Cost
Or she can take a $4,000 Cash Allowance and use the Credit Union
Texas Federal Credit Union Financing Options
Term in Months
48
60
72
Cash Allowance
$4,000
$4,000
$4,000
Down Payment
5%*
5%*
5%*
Interest Rate
6.04%
6.54%
7.14%
Monthly Payment
Total Interest Paid
Total Cost
* after Cash Allowance
Auto Questions: Which option is the least costly? Most costly? If they pay off the F150, how much could they swing in car
payments? Which option would you recommend based on your answer? What options does Latoya have
in the used car market? Should Latoya finance at Texas Fed or at the Dealership with BMW Financing? What other costs might change with a new vehicle?
Purchasing a House (questions on next page):
Latoya and Sam are ready to purchase their first home in Lewisville. They contracted with a seller where the final price on the home is $335,000. Calculate the following and make your recommendations:
New Home purchases: $335,000 (final cost)
New Home Financing - Conventional 7% down
Term in Years
15
30
Down Payment
7%
7%
APR (including fees)
6.125%
7.25%
Monthly Payment (without PMI)
Monthly Payment (with PMI)
Total Interest Paid
Monthly PMI (0.75% paid for 1/3 of the loan)
Total PMI Paid
Total Interest and PMI paid
Total Payments
Total Cost
New Home Financing - Conventional 20% down
Term in Years
15
30
Down Payment
20%
20%
APR (including fees)
5.825%
7.125%
Monthly Payment (without PMI)
Monthly Payment (with PMI)
Total Interest Paid
Monthly PMI Total PMI Paid
Total Interest and PMI paid
Total Payments
Total Cost
New Home Financing - FHA 3.5% down
Term in Years
15
30
Down Payment
3.5%
3.5%
APR (including fees)
6.625%
7.5%
Monthly Payment (without MIP)
Monthly Payment (with MIP)
Total Interest Paid
Monthly MIP (1% paid for all of the loan)
Total MIP Paid
Total Interest and MIP paid
Total Payments
Total Cost
Questions on next page!!
House Questions:
Given their house savings balance and their current house savings rate assuming 2% interest rate compounded monthly, how many months (round up) will it take the Kroger’s to save for the 20% down payment?
Which loan costs the most? Which is the least costly?
Which loan has the lowest payment? Which do you recommend?
Is there anything else they might want to save cash for that goes along with buying a new house?
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
Vinay
arrow_forward
Need help with this accounting question
arrow_forward
11. Can I afford this home? - Part 1
Can Valerie and Shen afford this home using the monthly income loan criterion?
Next week, your friends Valerie and Shen want to apply to the Tenth National Bank for a mortgage loan. They are considering the purchase of a home
that is expected to cost $155,000. Given your knowledge of personal finance, they've asked for your help in completing the Home Affordability
Worksheet that follows.
To assist in the preparation of the worksheet, Valerie and Shen also collected the following information:
• Their financial records report a combined gross before-tax annual income of $85,000 and current (premortgage) installment loan,
credit card, and car loan debt of $1,240 per month.
• Their property taxes and homeowner's insurance policy are expected to cost $3,488 per year.
• Their best estimate of the interest rate on their mortgage is 7.5%, and they are interested in obtaining a 15-year loan.
They have accumulated savings of $38,500 that can be used to…
arrow_forward
Please help with practice problem
arrow_forward
Home and Automobile Insurance
Newlyweds Joanne and James have had several milestones in the past year. They are newlyweds, recently purchased their first home and now have twins on the way! Joanne and James have to seriously consider their insurance needs. A family, a home and now babies on the way, they need to develop a risk management plan to help them should an unexpected event arise.
Current Financial Situation:
Assets (Joanne and James combined):
Checking account
$4,300
Savings Account
$22,200
Emergency Fund savings account
$20,500
Retirement Account balance
$26,000
Car
$10,000(JOANNE)
$18,000(JAMES)
Liabilities (Joanne and James combined):
Student loan balance
$0
Credit Card Balance
$2,000
Car Loans
$6,000
Income:
· JOANNE : $50,000 gross income ($37,500 net income after taxes)
· JAMES:$75,000 gross income ($64,000 net income after taxes)
Monthly Expenses (Joanne and James combined):…
arrow_forward
4. Loan Repayment Strategy: You took out a loan of $15,000 for a home improvement project, and the loan has an annual interest rate of 7%. If you want to pay off the loan in 3 years, what will be your monthly payments?
5. Financial Planning problem: Steve and Dixie are a young couple with 2 small children ages 4 and 2. They have struggled to build an emergency savings account and the money always seems to get spent. They feel like they are living paycheck to paycheck. Steve makes about 77k a year and Heidi has chosen to be home with the kids.
What would you recommend that they do to start building an emergency fund?
What should be the target goal for how much they save in their emergency fund? I would like you to explain step by step
arrow_forward
answer using TVM calculations and formulas
Today Dante and Sharon had their first child. All of the grandparents gave them money to help out, which added up to $23,000, and they are going to put this money into an education fund for their child's future. They are nervous about the stock market so they've decided to put their money in a GIC which earns an interest rate of 3.2%, compounded monthly.
How much money will they have in the account by their child's 18th birthday?
How much interest will be earned?
arrow_forward
Need both questions. ....attempt if you will solve both questions. ...thanks
please provide excel functions as well rhank you
arrow_forward
please solve this preactice problem
arrow_forward
Your friend Sue has asked you to help her out as she is developing her financial plan. Help her come up with a plan for her finances and how she can set herself up for financial success!
She has an after tax income of $48,000 and budgets $30,000 for required expenses. This leaves $18,000 to spend on debt and savings annually. (Assume all annuity payments are in the form of ordinary annuities.)
Part A: Debt
Sue has a current balance of $18,000 on her credit card. She has a minimum monthly payment of $500 and an APR of 18.0% (divide by 12 to get the monthly rate). How many months will it take Sue to pay off her credit card debt?
Suppose Sue needs to purchase a car. She believes she can spend $550 a month on a car. She has been approved for a 6.0% loan (divide by 12 for monthly rate) for 48 months. What is the maximum amount she can spend on a car so as not to exceed her $550 a month budget?
Part B: Savings
Sue would like to save up for a down payment on a home she hopes to purchase in…
arrow_forward
Suppose that a young couple has just had their first baby and they wish to insure that enough money
will be available to pay for their child's college education. They decide to make deposits into an
educational savings account on each of their daughter's birthdays, starting with her first birthday.
Assume that the educational savings account will return a constant 4% per year. The parents deposit $
10,000 on their daughter's first birthday and plan to increase the size of their deposits by 2% each year.
Assuming that the parents have already made the deposit for their daughter's 18th birthday, then the
amount available for the daughter's college expenses on her 18th birthday is closest to: $1,012,908 $
147,489 $500,000 $298,785
arrow_forward
Suppose that a young couple has just had their first baby and they wish to ensure that enough
money will be available to pay for their child's college education. They decide to make deposits
into an educational savings account on each of their daughter's birthdays, starting with her first
birthday. Assume that the educational savings account will return a constant 7%. The parents
deposit $2000 on their daughter's first birthday and plan to increase the size of their deposits
by 5% each year. Assuming that the parents have already made the deposit for their daughter's
18th birthday, then what is the amount available for the daughter's college expenses on her
18th birthday?
arrow_forward
5 you dont need to include timeline
arrow_forward
time value of money calculations
Today Dante and Sharon had their first child. All of the grandparents gave them money to help out, which added up to $23,000, and they are going to put this money into an education fund for their child’s future. They are nervous about the stock market so they’ve decided to put their money in a GIC which earns an interest rate of 2.6%, compounded monthly.
How much money will they have in the account by their child’s 18th birthday?
How much interest will be earned?
Specified Answer for: 1
[36,707.75]
Specified Answer for: 2
[13,707.75]
Question 13
Sharon convinces Dante that because school is both very expensive and very important, they should consider an investment account with a higher rate of return. They explored their options and have selected a very conservative index mutual fund that has a performed with a return of 4.7%, compounded monthly.
How much will they have saved by their child’s 18th…
arrow_forward
solve this practice problem
arrow_forward
Solve this practice problem
arrow_forward
Practice 1
Your friend is celebrating her 35th birthday today and wants to start saving for her anticipated retirement at age 65 (she will retire on her 65th birthday). She would like to be able to withdraw $80,000 from her savings account on each birthday for 20 years following her retirement (the first withdrawal will be on her 66th birthday). Your friend intends to invest her money in the local savings bank which offers 4% p.a. compound semi-annually. She wants to make equal annual deposits on each birthday in a new savings account she will establish for her retirement fund. If she starts making these deposits TODAY and continues to make deposits until she is 65 (the last deposit will be on her 65th birthday), what amount must she deposit annually to be able to make the desired withdrawals upon retirement?
Any intermediate steps should be rounded to 4 or more decimal places.
arrow_forward
Done with Case A. Need help the rest.
arrow_forward
Heer
Don't upload any image please
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Related Questions
- Vinayarrow_forwardNeed help with this accounting questionarrow_forward11. Can I afford this home? - Part 1 Can Valerie and Shen afford this home using the monthly income loan criterion? Next week, your friends Valerie and Shen want to apply to the Tenth National Bank for a mortgage loan. They are considering the purchase of a home that is expected to cost $155,000. Given your knowledge of personal finance, they've asked for your help in completing the Home Affordability Worksheet that follows. To assist in the preparation of the worksheet, Valerie and Shen also collected the following information: • Their financial records report a combined gross before-tax annual income of $85,000 and current (premortgage) installment loan, credit card, and car loan debt of $1,240 per month. • Their property taxes and homeowner's insurance policy are expected to cost $3,488 per year. • Their best estimate of the interest rate on their mortgage is 7.5%, and they are interested in obtaining a 15-year loan. They have accumulated savings of $38,500 that can be used to…arrow_forward
- Please help with practice problemarrow_forwardHome and Automobile Insurance Newlyweds Joanne and James have had several milestones in the past year. They are newlyweds, recently purchased their first home and now have twins on the way! Joanne and James have to seriously consider their insurance needs. A family, a home and now babies on the way, they need to develop a risk management plan to help them should an unexpected event arise. Current Financial Situation: Assets (Joanne and James combined): Checking account $4,300 Savings Account $22,200 Emergency Fund savings account $20,500 Retirement Account balance $26,000 Car $10,000(JOANNE) $18,000(JAMES) Liabilities (Joanne and James combined): Student loan balance $0 Credit Card Balance $2,000 Car Loans $6,000 Income: · JOANNE : $50,000 gross income ($37,500 net income after taxes) · JAMES:$75,000 gross income ($64,000 net income after taxes) Monthly Expenses (Joanne and James combined):…arrow_forward4. Loan Repayment Strategy: You took out a loan of $15,000 for a home improvement project, and the loan has an annual interest rate of 7%. If you want to pay off the loan in 3 years, what will be your monthly payments? 5. Financial Planning problem: Steve and Dixie are a young couple with 2 small children ages 4 and 2. They have struggled to build an emergency savings account and the money always seems to get spent. They feel like they are living paycheck to paycheck. Steve makes about 77k a year and Heidi has chosen to be home with the kids. What would you recommend that they do to start building an emergency fund? What should be the target goal for how much they save in their emergency fund? I would like you to explain step by steparrow_forward
- answer using TVM calculations and formulas Today Dante and Sharon had their first child. All of the grandparents gave them money to help out, which added up to $23,000, and they are going to put this money into an education fund for their child's future. They are nervous about the stock market so they've decided to put their money in a GIC which earns an interest rate of 3.2%, compounded monthly. How much money will they have in the account by their child's 18th birthday? How much interest will be earned?arrow_forwardNeed both questions. ....attempt if you will solve both questions. ...thanks please provide excel functions as well rhank youarrow_forwardplease solve this preactice problemarrow_forward
- Your friend Sue has asked you to help her out as she is developing her financial plan. Help her come up with a plan for her finances and how she can set herself up for financial success! She has an after tax income of $48,000 and budgets $30,000 for required expenses. This leaves $18,000 to spend on debt and savings annually. (Assume all annuity payments are in the form of ordinary annuities.) Part A: Debt Sue has a current balance of $18,000 on her credit card. She has a minimum monthly payment of $500 and an APR of 18.0% (divide by 12 to get the monthly rate). How many months will it take Sue to pay off her credit card debt? Suppose Sue needs to purchase a car. She believes she can spend $550 a month on a car. She has been approved for a 6.0% loan (divide by 12 for monthly rate) for 48 months. What is the maximum amount she can spend on a car so as not to exceed her $550 a month budget? Part B: Savings Sue would like to save up for a down payment on a home she hopes to purchase in…arrow_forwardSuppose that a young couple has just had their first baby and they wish to insure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 4% per year. The parents deposit $ 10,000 on their daughter's first birthday and plan to increase the size of their deposits by 2% each year. Assuming that the parents have already made the deposit for their daughter's 18th birthday, then the amount available for the daughter's college expenses on her 18th birthday is closest to: $1,012,908 $ 147,489 $500,000 $298,785arrow_forwardSuppose that a young couple has just had their first baby and they wish to ensure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 7%. The parents deposit $2000 on their daughter's first birthday and plan to increase the size of their deposits by 5% each year. Assuming that the parents have already made the deposit for their daughter's 18th birthday, then what is the amount available for the daughter's college expenses on her 18th birthday?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- PFIN (with PFIN Online, 1 term (6 months) Printed...FinanceISBN:9781337117005Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning

PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning