FINA 2770 - Project Part 2 Fall 2023
docx
keyboard_arrow_up
School
University of North Texas *
*We aren’t endorsed by this school
Course
2770
Subject
Finance
Date
Jan 9, 2024
Type
docx
Pages
3
Uploaded by HighnessArtTapir33
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
1080.11
898.65
820.22
Total Interest Paid
3,037.59
5,111.19
10,248.30
Total Cost
57,268.59
59,342.19
64,479.30
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
$1,121.57
$934.58
$816.78
Total Interest Paid
$6,115.81
$8,355.36
$11,088.78
Total Cost
$56,346.81
$58,586.36
$61,319.78
* 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)
2,650.97
2,125.32
Monthly Payment (with PMI)
2,845.69
2,320.04
Total Interest Paid
165,624.15
453,565.27
Monthly PMI (0.75% paid for 1/3 of the loan)
194.72
194.72
Total PMI Paid
11,683.13
23,366.25
Total Interest and PMI paid
177,307.28
476,931.52
Total Payments
488,857.28
788,481.52
Total Cost
512,307.28
811,931.52
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)
2,236.28
1,805.57
Monthly Payment (with PMI)
2,403.78
1,973.07
Total Interest Paid
134,529.77
382,003.63
Monthly PMI
167.50
167.50
Total PMI Paid
10,050.00
20,100.00
Total Interest and PMI paid
144,579.77
402,103.63
Total Payments
412,579.77
670,103.63
Total Cost
479,579.77
737,103.63
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)
2,838.33
2,260.39
Monthly Payment (with MIP)
3,107.73
2,529.78
Total Interest Paid
187,625.18
490,463.85
Monthly MIP (1% paid for all of the loan)
269.40
269.40
Total MIP Paid
48,491.25
96,982.50
Total Interest and MIP paid
236,116.43
587,446.35
Total Payments
559,391.43
910,721.35
Total Cost
571,116.43
922,446.35
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 Documents
Related Questions
Need help with this accounting question
arrow_forward
Please help with practice problem
arrow_forward
PART 1
Today Tyrone and Alesha had their first child. All of the grandparents gave them money to help out, which added up to $27,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
PART 2
Alesha convinces Tyrone 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 relatively conservative index mutual fund that has a performed with a return of 6.5%, compounded monthly.
How much will they have saved by their child's 18th birthday with this higher rate of return?
How much interest will be earned?
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
Need answers and Solutions ASAP...
Bob and Mary Johnson are expecting their first child. They have decided to deposit $1000 into a savings account that pays 6% interest compounded annually on the day the child is born. They will then deposit $1000 on each birthday through the child’s 18th birthday. How much money will be in the account on the child’s 19th birthday to finance a college education
(Answer: $35,786)
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
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
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
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
- Need help with this accounting questionarrow_forwardPlease help with practice problemarrow_forwardPART 1 Today Tyrone and Alesha had their first child. All of the grandparents gave them money to help out, which added up to $27,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 PART 2 Alesha convinces Tyrone 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 relatively conservative index mutual fund that has a performed with a return of 6.5%, compounded monthly. How much will they have saved by their child's 18th birthday with this higher rate of return? How much interest will be earned?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_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_forwardanswer 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 youarrow_forwardplease solve this preactice problemarrow_forwardYour 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
- Need answers and Solutions ASAP... Bob and Mary Johnson are expecting their first child. They have decided to deposit $1000 into a savings account that pays 6% interest compounded annually on the day the child is born. They will then deposit $1000 on each birthday through the child’s 18th birthday. How much money will be in the account on the child’s 19th birthday to finance a college education (Answer: $35,786)arrow_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_forwardtime 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
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