GBS132_Lesson_2_Financial_Statement_Template-Final (1)

xlsx

School

Pima Community College *

*We aren’t endorsed by this school

Course

BUS-125

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

8

Uploaded by MegaParrot4092

Report
GB132-Lesson 2 Part 1: Balanc Name: Balance Sh Jack & Lilly Taylor ASSETS Liquid Assets Cash on hand Checking Accounts $ 640 Savings Accounts $ 32,220 Certificates of Deposit $ 15,000 Total Liquid Assets $ 47,860 Investments Stocks $ 30,900 Bonds REITS $ 3,500 Mutual Funds Life Insurance Cash Value $ 43,650 529 College Savings $ 16,640 IRA's Roth IRA's $ 84,652 Employer Retirement Accts. $ 111,917 Rental Real estate $ 355,000 Other $ 100,035 Total Investments $ 746,294 Real Property Primary Residence $ 783,000 Vacation Home Other $ 355,000 Total Real Property $ 1,138,000 Personal Property Auto(s): $ 24,500 Auto(s): Recreational Vehicles Household Furnishing $ 30,000 Jewelry and Artwork $ 25,000 Other Other Money Market Accounts funds and deposits
Total Personal Property $ 79,500 (I)Total Assets $ 2,011,654 1. Solvency: What is Jack & Lilly's solvency ratio? Be sure to show your wo 1479085/2011654=.73 73% 2. Liquidity: What is Jack & Lilly's liquidity ratio? Be sure to show your w 47860/532569=8.9%
2 Template ce Sheet heet December 24, 2023 LIABILITIES Current Liabilities Utilities Insurance premiums $ 300 Taxes $ 400 $ 12,000 Dept. Store Credit Card $ 169 Medical Bills Total Current Liabilities $ 12,869 Long-Term Liabilites Rental Property Loan Education Loans $ 16,700 Home improvement loans Rental Property Loan Margin Loan Primary Residence Mortgage $ 486,000 Vacation Home Mortgage Other Real Estate Loan Auto Loans $ 17,000 Appliance/furniture loans Revolving Credit Card Balances Other long-term loans Total Long-Term Liabilities $ 519,700 (II) Total Liabilities $ 532,569 Gas and other credit card balances Home Equity Line of Credit balances
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
Net Worth [(I) - (II)] $ 1,479,085 Total Liabilities and Net Worth $ 2,011,654 ork. work.
GB132-Lesson 2 Template Part 2: Income and Expense Statement Name:Denise Johnson INCOME AND EXPENSE STATEMENT Name(s) Jack and Lily Taylor For the Year Ended Income Wages and salaries Name: Jack Name: Lilly Name: Self-employment income Bonuses and commissions Investment income Interest received Dividends received Rents received Sale of securities Other Pensions and annuities Other income (I) Total Income $ Expenses Housing $ Repairs, maintenance, improvements Utilities Gas, electric, water Phone Cable TV and other Food Groceries Dining out Transportation Auto loan payments License plates, fees, etc. Gas, oil, repairs, tires, maintenance Medical Doctor, dentist, hospital, medicines Clothing Clothes, shoes, and accessories Insurance Homeowner’s (if not covered by mortgage paym Life (not provided by employer) Auto Taxes Income and social security Property (if not included in mortgage) Loan Payments Student Loan payments Rent/mortgage payment (include insurance and taxes, if applicable) Health, major medical, disability insurance (payroll deductions or not provided by employer)
Loan Payments Personal care Laundry, cosmetics, hair care Recreation and entertainment Vacations Other recreation and entertainment Other items savings (II) Total Expenses $ CASH SURPLUS (OR DEFICIT) [(I)-(II)] $ 49192/176722-32527=.34 34% 5258/14727=.35 35% 1. Savings Ratio: What is Jack & Lilly's savings Ratio? Show your work. 2. Debt Service Ratio: What is Jack & Lilly's Debt Service Ratio? Show your work.
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
2019 $ 90,000 $ 78,377 $ 493 $ 172 $ 7,680 176,722.00 35,400.00 2,400.00 4,512.00 1,440.00 1,056.00 13,029.00 3,840.00 2,428.00 490.00 370.00 5,268.00 480.00 1,364.00 2,400.00 1,332.00 2,400.00 32,527.00 3,410.00
2,200.00 3,700.00 3,844.00 3,640.00 127,530.00 49,192.00