Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
Use the following information to construct basic financial statements. Develop a future budget and recommendations to improve their financial ratios. You will present these in your video to the clients.
(Side Note: If you were creating your own budget or balance sheet, you’d do the same using your bank statements.)
Balances as of December 31, 20XX, some expenses are monthly, quarterly, or annually.
Latoya’s Net (After-Tax) Salary (Real Estate Manager) $ 75,000
Sam’s Net (After-Tax) Salary (Videographer) $ 48,000
401k annual contribution rate (for both, from net Salary) 3%
401k balances $ 8,000
Sam’s Annual Income from Winnings (Axe Throwing Pro) $ 16,000
Current Monthly Rent $ 1,600
2018 Ford F150 Trade-in Value $ 24,000
Jewelry Value (Engagement Ring, Earrings, Custom Axe Necklace) $ 26,500
Checking Account Balance $ 2,500
Savings Account Balance $ 4,000
Car Fund Money Market Account Balance $ 2,500
Sam’s Custom Axe Set $ 3,600
Roth IRA Account $ 2,500
Schwab Brokerage Account $ 16,352
F150 Loan Balance, Ford Motor Credit $ 15,068
Current BOA Credit Card Balance (usually paid-in-full each month) $ 2,890
Groceries – HEB, Krogers, Whole Foods (Monthly) $ 1,700
Dining out (monthly) $ 1,600
Renter’s Insurance (Annual) $ 360
Auto Insurance (Monthly) $ 290
Gasoline (Monthly) $ 300
Auto Maintenance (Annual) $ 600
Entertainment (Netflix, Axe Throwing, monthly) $ 700
New Home Savings Fund Balance $ 9,000
New Home monthly savings $ 1,000
Annual Vacations $ 6,000
Average Water/city utilities and Electricity – varies, monthly $ 295
Monthly Cell Phones, Internet, and TV $ 515
Annual charitable $ 13,500
Student loan balance $ 13,475
Monthly Student loan payment $ 385
Monthly Auto loan Payment $ 362
Car Savings (monthly) $ 300
Miscellaneous (just-in-case) Expenses (monthly) $ 500
please find total living expenses and unidentified cashflow
Use the following information to construct basic financial statements. Develop a future budget and recommendations to improve their financial ratios. You will present these in your video to the clients.
(Side Note: If you were creating your own budget or balance sheet, you’d do the same using your bank statements.)
Balances as of December 31, 20XX, some expenses are monthly, quarterly, or annually.
Latoya’s Net (After-Tax) Salary (Real Estate Manager) $ 75,000
Sam’s Net (After-Tax) Salary (Videographer) $ 48,000
401k annual contribution rate (for both, from net Salary) 3%
401k balances $ 8,000
Sam’s Annual Income from Winnings (Axe Throwing Pro) $ 16,000
Current Monthly Rent $ 1,600
2018 Ford F150 Trade-in Value $ 24,000
Jewelry Value (Engagement Ring, Earrings, Custom Axe Necklace) $ 26,500
Checking Account Balance $ 2,500
Savings Account Balance $ 4,000
Car Fund Money Market Account Balance $ 2,500
Sam’s Custom Axe Set $ 3,600
Roth IRA Account $ 2,500
Schwab Brokerage Account $ 16,352
F150 Loan Balance, Ford Motor Credit $ 15,068
Current BOA Credit Card Balance (usually paid-in-full each month) $ 2,890
Groceries – HEB, Krogers, Whole Foods (Monthly) $ 1,700
Dining out (monthly) $ 1,600
Renter’s Insurance (Annual) $ 360
Auto Insurance (Monthly) $ 290
Gasoline (Monthly) $ 300
Auto Maintenance (Annual) $ 600
Entertainment (Netflix, Axe Throwing, monthly) $ 700
New Home Savings Fund Balance $ 9,000
New Home monthly savings $ 1,000
Annual Vacations $ 6,000
Average Water/city utilities and Electricity – varies, monthly $ 295
Monthly Cell Phones, Internet, and TV $ 515
Annual charitable $ 13,500
Student loan balance $ 13,475
Monthly Student loan payment $ 385
Monthly Auto loan Payment $ 362
Car Savings (monthly) $ 300
Miscellaneous (just-in-case) Expenses (monthly) $ 500
please find total living expenses and unidentified cashflow
Step by Step Solution
★★★★★
3.37 Rating (156 Votes )
There are 3 Steps involved in it
Step: 1
To calculate the total living expenses we can add up all of the expenses that are listed as monthly ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started