GBS132_Lesson_2_Financial_Statement_Template-Final (1)
xlsx
keyboard_arrow_up
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
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
Related Documents
Related Questions
pra.9
arrow_forward
Using the stylized balance sheet below, please 1) finish the balance sheet, and 2)
use that information to answer the following question, entering your answer in the
place provided.
Avg.
Avg.
Amount
Amount
Interest
Interest
Demand
Vault Cash
$1,573
$1,123
Deposits
US Treas.
Savings
3.43%
2,212
3.02%
8,497
Securities
Deposits
Consumer/Bus.
8.23%
15,315
CD's
3.54%
????
Loans
Mortgage
6.82%
8,719
Borrowings
3.10%
2,747
Loans
Property
2,032
Equity
3,423
Equipment
Total Liab.&
Total Assets
????
????
Equity
What is the net interest income the this bank? (Please enter the answer to the nearest
penny!)
ed
39,211.64
ver
1,091.41 margin of error +/- 1
arrow_forward
Bank Statement
Responsible Bank
210 2nd Street
3. If Andre deposits
$100 in this
account after
$
Checking Account Statement
Page: 1 of 1
Anytown, MH 06930
buying the music
player, will he still
be in debt? How do
Andre Person
1729 Euclid Ave
Anytown, MH 06930
Statement Pernd
2017-10-01 to 2017-11.01
Accourt No.
1120635978
you know?
Date
Description
Withdrawals Deposits
Balance
Your answer here
2017-10-03 Previous Balance
2017-10-05 Check Number 256
2017-10-06 ATM Deposit- Cash
2017-10-10 Wire Transfer
2017.10.17 Point of Sale Grocery Store
2017-10-25 Funds Transfer from Savings
2017.10-28 Check Number 257
2017-10-29 Online Payment Phone Services
39.87
11.37
56.37
18.46
203
52 03
10.03
6247
28.50
45.00
37.91
16.43
50.00
42 00
7250
%24
arrow_forward
Question
arrow_forward
Refer to the information provided in Table below to answer the question(s) that
follow.
Table
First Charter Bank
Assets
Select one:
O
Reserves
$800
Loans
$400
Total
$1,200
Refer to Table First Charter Bank's total assets are
Liabilities
a. $800.
b. $400.
C. $2,400
d. $1,200.
Deposits
Net Worth
Total
arrow_forward
Cy Walker invests $20,000 of his personal savings into Mookie the Beagle Concierge. MTB Concierge needs to record the deposit
using QBO.
Required:
1. Record the Deposit.
a. Select (+) New icon > Bank Deposit
b. Select Account: 1001 Checking
c. Select Payment Date: 01/01/2023
d. In the Add Funds to This Deposit section, select Account: 3003 Owner's Investment
e. Select Payment Method: Check
f. Enter Reference Number: 5001
g. Enter Amount: 20000.00
h. What type of account is Owner's Investment?
i. Select Save and close
h. Type of account
arrow_forward
Using the stylized balance sheet below, please 1) finish the balance sheet, and 2)
use that information to answer the following question, entering your answer in
the place provided.
Avg.
Interest
Avg.
Amount
Amount
Interest
Demand
Vault Cash
$577
$5,650
Deposits
US Treas.
Savings
4.85%
2,139
1.99%
6,622
Securities
Deposits
W
Consumer/Bus.
6.94%
15,835
CD's
4.76%
????
Loans
Mortgage
7.54%
10,410
Borrowings
4.34%
2,766
Loans
Property
Equipment
Total Assets
740
Equity
Total Liab.&
????
Equity
2,741
????
What is the net interest margin the this bank? (Please enter the answer without the
% sign - so for instance is the answer is 5.67%, then enter just 5.67)
arrow_forward
Exhibit 12-4
Balance SheetBANK XYZ($ millions)
Assets
Liabilities
Required Reserves
$ 30
Checkable Deposits
$ 250
Excess Reserves
0
Nontransaction Deps
350
Loans
700
Borrowings
25
Securities
140
Bank Capital
(A)
Refer to Exhibit 12-4. How much bank capital does Bank XYZ have (i.e. what dollar amount belongs in blank (A)?
Refer to Exhibit 12-4. What is the required reserve ratio?
arrow_forward
Lesson 2
Posting the Journal Entries to the Ledger
EXTEND
Name:
Time:
John Karlo Dalangin, a dentist, established Dalagan Clinic.
transactions occurred during June of this year:
The following
a. Dalangin deposited P280,000 in a bank account in the name of the
business.
b. Bought a 3-in-1 office equipment from Pitular Equipment for P4,950
paying P1,000 in cash and the balance on account.
C. Bought waiting room chairs and a table, paying cash, P12,300.
d. Bought office intercom on account from NE office Supply, P2,750.
e. Received and paid the telephone bill, P1,080.
f. Performed professional services on account, P12,940.
g. Received and paid the electric bill, P1,850.
h. Received and paid the bill for the Regional Dental Convention, P3,500.
i. Performed professional services for cash, P17,650.
j. Partially settled accounts with NE Office Supply, Pl,000.
k. Paid rent for the month, P8,400.
1. Paid salaries of the part-time receptionist, P3,500.
m. Dalangin withdrew cash for personal use,…
arrow_forward
BANK STATEMENT
Date
Checks
Deposits
Other
Balance
$ 48,000
40, 380
67,830
53,930
৪9,938
৪৪, 978
88,470
88,520
88,370
Dec. 1
$ 7,620
550 $28, 0e
13,900
11
17
23
36, e00
26
960
30
19,200
19, e00
NSF*
$300
Interest earned
Service charge
31
50
31
150
NSF check from J. Left, a customer.
Cash (A)
Dec. 1 Balance
48, 000
Deposits
Checks written during December:
7,620
550
28, e00
36, 000
19,000
13,e00
Dec. 11
23
13,900
960
30
31
150
19, 200
4,500
Dec. 31 Balance
97,128
There were no deposits in transit or outstanding checks at November 30.
4. Prepare any journal entries that the company should make as a resuit of the bank reconciliatio
transaction/event, select "No Journal Entry Required" In the first account fleld.)
View transaction list
Journal entry worksheet
B C D E
A
Record the interest of $50 received from the bank.
Note: Enter debits before credits.
Transaction
General Journal
Debit
Credit
1
Record entry
Clear entry
View general journal
arrow_forward
Assets
Right after After the
the loan is check
Liabilities
and Net
Right after After the
the loan is check
made
clears
Worth
made
clears
Checkable
Reserves $22,000
A
D
$100,000 G
H
Deposits
Securities $38,000
B
E
Loans
$40,000
C
EL
F
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
48. Help me selecting the right answer. Thank you
arrow_forward
Thanks in advance
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Mi Tierra Bank
Assets
Liabilities
Required reserves
Excess reserves
$10,000 Demand deposits
$5,000
S85,000 Owner's equity
$100,000
Loans
(d) Assume that Luis withdraws $5,000 in cash from his checking
account at Mi Tierra Bank.
(iii) What is the maximum change in the amount of money supply
as a result of this withdrawal?
arrow_forward
Hello-
Is there a way to get Times inteset earned using the attached data.
Please advise.
Thanks,
Ityla Lungu
773.780.7930
arrow_forward
Beginning Balance
A.
D.
Total
Ending Balance
Deposits
$7,500
350
7,850
Bank Statement.
Checks
101
102
103
106
Bank service charges
C. Initiated a petty cash fund $250 check #102.
D. Received $350 cash for services rendered.
Bank Statement balance
$ 600
250
125
242
1,307
Lavender Company started its business on April 1, 2019. The following are the transactions that happened during the month of April.
A. The owners invested $7,500 from their personal account to the business account.
B. Paid rent $600 with check #101.
$0
E. Purchased office supplies for $125 with check #103.
F. Purchased computer equipment $1,500, paid $500 with check #104, and will pay the remainder in 30 days.
G. Received $750 cash for services rendered.
H. Paid wages $375, check #105.
1. Petty cash reimbursement Office Supplies $50, Maintenance Expense $80, Miscellaneous Expense $60. Cash on hand $8. Check #106.
J. Increased Petty Cash by $70, check #107.
Assume no bank errors.
Lavender Company
Bank Reconciliation…
arrow_forward
Please explain step by step
arrow_forward
Time:
Black Diamond Pawnshop
Trial Balance
June 30, 2020
Cash in Bank
210,000.45
Petty Cash Fund
999.55
Loan Pledge Receivable
218,000.00
Furniture and Fixtures
85,000.00
Vaults and Other Equipment
110,000.00
Accounts Payable
20,000.00
SSS Premium Payable
1,888.00
Philhealth Premium Payable
550.00
B. Pozon, Capital
518,639.80
B. Pozon, Withdrawals
10,000.00
Interest Income
79,113.00
Service Fee
1,056.00
Interest Past Due
32,015.65
Liquidated Damage
28,074.35
Miscellaneous Income
2,000.00
Gain on Auction Sale
15,000.00
Taxes and Licenses
4,576.00
Postage and Communication
2,325.00
Salaries Expense
22,000.00
Rent Expense
29,000.00
Utilities Expense
5,000.00
Sss Contribution Expense
Philhealth Contributions Expense
1,154.80
275.00
Required: Prepare a trial balance
arrow_forward
ezto.mheducation.com
kes Learning | Home
mination II
Saved
Help
Save & Exit
Submit
Before reconciling its bank statement, Rollin Corporation's general ledger had a month-end balance in the cash account of $8,250.
The bank reconciliation for the month contained the following items:
15
Deposits in transit
Outstanding checks
$870
645
56
Interest earned
20
ints
NSF check returned to bank
Bank service charge
220
70
A 01:39:45
Given the above information, what up-to-date ending cash balance should Rollin report at month-end?
Multiple Choice
$7,980.
$8,530.
Mc
Graw
MacBook
DII
DD
80
F10
FB
F9
F7
F5
F2
F3
23
2$
%
&
@
3
4
6.
7
8
W
R
T.
Y
G
H.
J
K
S
D
* 00
arrow_forward
nta 22
Coronado has the following assets at December 31, 2019.
Cash in bank-savings account 134,000
Certificates of deposit (270-day) 226,000
sponder
a como
Cash on hand 1,600
Postdated checks 6,000
Cash refund due from State Taxing Authority 32,100
Checking account balance 12,000
What amount should be reported as cash?
arcar
nta
O a. 135,600
O b. 134,000
O c. 179,700
O d. 147,600
pe here to search
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- pra.9arrow_forwardUsing the stylized balance sheet below, please 1) finish the balance sheet, and 2) use that information to answer the following question, entering your answer in the place provided. Avg. Avg. Amount Amount Interest Interest Demand Vault Cash $1,573 $1,123 Deposits US Treas. Savings 3.43% 2,212 3.02% 8,497 Securities Deposits Consumer/Bus. 8.23% 15,315 CD's 3.54% ???? Loans Mortgage 6.82% 8,719 Borrowings 3.10% 2,747 Loans Property 2,032 Equity 3,423 Equipment Total Liab.& Total Assets ???? ???? Equity What is the net interest income the this bank? (Please enter the answer to the nearest penny!) ed 39,211.64 ver 1,091.41 margin of error +/- 1arrow_forwardBank Statement Responsible Bank 210 2nd Street 3. If Andre deposits $100 in this account after $ Checking Account Statement Page: 1 of 1 Anytown, MH 06930 buying the music player, will he still be in debt? How do Andre Person 1729 Euclid Ave Anytown, MH 06930 Statement Pernd 2017-10-01 to 2017-11.01 Accourt No. 1120635978 you know? Date Description Withdrawals Deposits Balance Your answer here 2017-10-03 Previous Balance 2017-10-05 Check Number 256 2017-10-06 ATM Deposit- Cash 2017-10-10 Wire Transfer 2017.10.17 Point of Sale Grocery Store 2017-10-25 Funds Transfer from Savings 2017.10-28 Check Number 257 2017-10-29 Online Payment Phone Services 39.87 11.37 56.37 18.46 203 52 03 10.03 6247 28.50 45.00 37.91 16.43 50.00 42 00 7250 %24arrow_forward
- Questionarrow_forwardRefer to the information provided in Table below to answer the question(s) that follow. Table First Charter Bank Assets Select one: O Reserves $800 Loans $400 Total $1,200 Refer to Table First Charter Bank's total assets are Liabilities a. $800. b. $400. C. $2,400 d. $1,200. Deposits Net Worth Totalarrow_forwardCy Walker invests $20,000 of his personal savings into Mookie the Beagle Concierge. MTB Concierge needs to record the deposit using QBO. Required: 1. Record the Deposit. a. Select (+) New icon > Bank Deposit b. Select Account: 1001 Checking c. Select Payment Date: 01/01/2023 d. In the Add Funds to This Deposit section, select Account: 3003 Owner's Investment e. Select Payment Method: Check f. Enter Reference Number: 5001 g. Enter Amount: 20000.00 h. What type of account is Owner's Investment? i. Select Save and close h. Type of accountarrow_forward
- Using the stylized balance sheet below, please 1) finish the balance sheet, and 2) use that information to answer the following question, entering your answer in the place provided. Avg. Interest Avg. Amount Amount Interest Demand Vault Cash $577 $5,650 Deposits US Treas. Savings 4.85% 2,139 1.99% 6,622 Securities Deposits W Consumer/Bus. 6.94% 15,835 CD's 4.76% ???? Loans Mortgage 7.54% 10,410 Borrowings 4.34% 2,766 Loans Property Equipment Total Assets 740 Equity Total Liab.& ???? Equity 2,741 ???? What is the net interest margin the this bank? (Please enter the answer without the % sign - so for instance is the answer is 5.67%, then enter just 5.67)arrow_forwardExhibit 12-4 Balance SheetBANK XYZ($ millions) Assets Liabilities Required Reserves $ 30 Checkable Deposits $ 250 Excess Reserves 0 Nontransaction Deps 350 Loans 700 Borrowings 25 Securities 140 Bank Capital (A) Refer to Exhibit 12-4. How much bank capital does Bank XYZ have (i.e. what dollar amount belongs in blank (A)? Refer to Exhibit 12-4. What is the required reserve ratio?arrow_forwardLesson 2 Posting the Journal Entries to the Ledger EXTEND Name: Time: John Karlo Dalangin, a dentist, established Dalagan Clinic. transactions occurred during June of this year: The following a. Dalangin deposited P280,000 in a bank account in the name of the business. b. Bought a 3-in-1 office equipment from Pitular Equipment for P4,950 paying P1,000 in cash and the balance on account. C. Bought waiting room chairs and a table, paying cash, P12,300. d. Bought office intercom on account from NE office Supply, P2,750. e. Received and paid the telephone bill, P1,080. f. Performed professional services on account, P12,940. g. Received and paid the electric bill, P1,850. h. Received and paid the bill for the Regional Dental Convention, P3,500. i. Performed professional services for cash, P17,650. j. Partially settled accounts with NE Office Supply, Pl,000. k. Paid rent for the month, P8,400. 1. Paid salaries of the part-time receptionist, P3,500. m. Dalangin withdrew cash for personal use,…arrow_forward
- BANK STATEMENT Date Checks Deposits Other Balance $ 48,000 40, 380 67,830 53,930 ৪9,938 ৪৪, 978 88,470 88,520 88,370 Dec. 1 $ 7,620 550 $28, 0e 13,900 11 17 23 36, e00 26 960 30 19,200 19, e00 NSF* $300 Interest earned Service charge 31 50 31 150 NSF check from J. Left, a customer. Cash (A) Dec. 1 Balance 48, 000 Deposits Checks written during December: 7,620 550 28, e00 36, 000 19,000 13,e00 Dec. 11 23 13,900 960 30 31 150 19, 200 4,500 Dec. 31 Balance 97,128 There were no deposits in transit or outstanding checks at November 30. 4. Prepare any journal entries that the company should make as a resuit of the bank reconciliatio transaction/event, select "No Journal Entry Required" In the first account fleld.) View transaction list Journal entry worksheet B C D E A Record the interest of $50 received from the bank. Note: Enter debits before credits. Transaction General Journal Debit Credit 1 Record entry Clear entry View general journalarrow_forwardAssets Right after After the the loan is check Liabilities and Net Right after After the the loan is check made clears Worth made clears Checkable Reserves $22,000 A D $100,000 G H Deposits Securities $38,000 B E Loans $40,000 C EL Farrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you