You have just been hired as a Level 1 Financial Coach at UNT Financial Services. Now your
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date: