Question
The Stinsons Financial Information Note: missing data can be found using TVM calculations. See data in footnotes. Data provided as of 12/31/2018 Robin's Monthly Salary
The Stinsons Financial Information Note: missing data can be found using TVM calculations. See data in footnotes.
Data provided as of 12/31/2018
Robin's Monthly Salary 9,500 Jewelry 25,500 401(k) Account (His) 120,050 Dividend/Interest Income (monthly) 15 401(k) Account (Her) 85,000 Mortgage Payment (PITI) ????Boat 16,000 BMW 3 Series Payment (monthly) ????2017 Tesla 58,000 Tesla Payment (monthly) 888 Furniture 25,500 BB National Credit Card Payment (monthly) 400 BMW 3 Series Loani 55,200 Sears Credit Card Payment (monthly) 600 Brokerage Account (stocks only) 78,000 Satellite Bill (monthly) 300 Alarm System (monthly) 50 BB National CCii Balance 10,200 Life Insurance premium (monthly) 140 Health Insurance premium (monthly) 500 Internet bill (monthly) 100 Auto fuel costs (monthly) 370 Cellphone expense (monthly) 145 Barney 's Monthly Salary 7,500
Water and Trash (monthly) 110 Best Buy CCiii 12,800 Entertainment (monthly) 500 Auto Insurance Premiums (monthly) 130 Child Care (monthly) 1,000 Home Repairs (monthly) 200 BMW Automobile (estimated) 55,100 Groceries (monthly) 500 Checking Account (Joint) 5,000 Bank CD - 6-month maturity (Joint) 4,000 Dining Out (monthly) 600 Hobbies (monthly) 250 Savings Account 5,250 Roth IRA (His) 22,250 Dry Cleaning (monthly) 120 Primary Mortgage Balance iv 325,000 Landscaping (monthly) 300 Maid (monthly) 500 Parking and Tolls (monthly) 50 Dividend/ Interest Reinvestment (monthly) 15 Student Loan Payment (monthly) 773 Barney 's 401(k) contributions (monthly) 300 Student Loan Balance Hv ?????Robin's 401(k) contributions (monthly) 250 Cash Savings Contribution (monthly) 300 Tesla Auto Loan Balancevi 58,000 Barney 's Roth Contributions (monthly) 500 Income Tax Withheld (monthly) $1,500 FICA taxes paid (monthly) ????Primary Home (VALUE) 545,000
Please help create balance sheet with info provided if possible. Please do not worry about the ??? ones since I will need to figure out using TMV. I need help with sorting the info for balance sheet and income statement. I tried uploading the case study but was having trouble.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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