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