gbs132lesson2ba
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
Money Market Accounts
funds and deposits
Other
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 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
(II) Total Liabilities $ 532,569 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
Rent/mortgage payment
(include insurance and taxes, if applicable)
Health, major medical, disability insurance
(payroll deductions or not provided by employer)
Property (if not included in mortgage)
Loan Payments
Student 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
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
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
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
Assets
1. A $100 bill
2. The funds in a savings account
3. A painting you own
4. A bond issued by a publicly traded company
Select the assets in order of their liquidity, from most liquid to least liquid.
Most Liquid
Second-Most Liquid
Third-Most Liquid
Least Liquid
Asset
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
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
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
Banking Question 2
Please use the balance sheet for Bank Alpha to answer the questions. Assume Bank Alpha loans all of its
excess reserves, and the assets and liabilities balance on the balance sheet. Show all work.
Bank Alpha
Assets
Liabilities
Required Reserves
Checking Deposits
$5,000.00
X
Loans
$27,000.00
Saving Deposits
$25,000.00
a.
How much is X, the dollar amount of reserves?
b. How much is the required reserve ratio? How much is the M ?
Assume Bank Alpha loans its excess reserves to Bank Beta. Next Bank Beta loans their excess reserves
to Bank Gamma. Please create balance sheets for Banks Beta and Gamma. Assume there are no excess
reserves in this banking system.
C.
d.
How much total money stock created in this banking system?
е.
What is the total of M1 for Bank Alpha? M2?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- 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 +/- 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_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_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 accountarrow_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_forwardAssets 1. A $100 bill 2. The funds in a savings account 3. A painting you own 4. A bond issued by a publicly traded company Select the assets in order of their liquidity, from most liquid to least liquid. Most Liquid Second-Most Liquid Third-Most Liquid Least Liquid Assetarrow_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_forwardBANK 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_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 workingarrow_forward48. Help me selecting the right answer. Thank youarrow_forwardThanks in advancearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education