06-05_task22
xlsx
keyboard_arrow_up
School
Dallas County Community College *
*We aren’t endorsed by this school
Course
2316
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
4
Uploaded by MagistrateKomodoDragon3769
Name:
Monkeria Alexander
School:
Southside High Sc
Date:
1/25/2024
Facilitator:
H. jones
6.05 NET WORTH
Total Points: 50
Directions:
Fill in the net worth calculator based on the newlywed couple Jacob and Peyton Co
Fill in only the gray boxes.
Assets
Cash
Checking accounts
$8,000
Savings accounts
$14,000
Other cash
$0
Total Cash
$22,000
Investments
Securities (stocks, bonds, mutual funds)
$11,000
Treasury Bills
$98,000
Other investments
$27,000
Total Investments
$136,000
Property
Real Estate (market value)
$150,000
Automobile (present value)
$0
Other property
$0
Total Property
$150,000
Retirement
Retirements accounts (IRA, 401k)
$65,000
Other assets
$35,000
Total Retirement
$100,000
Total Assets
$408,000
Liabilities
Accounts Payable
$0
Auto Loan
$20,000
Credit Card Debt
$26,000
Consumer Loans or Installments
$0
Loan on Life Insurance
$0
Real Estate Mortgages
$145,000
Student Loans
$36,000
Unpaid Taxes
$0
Money Owed to Others
$0
Other liabilities
$0
Total Liabilities
$227,000
Net Worth
$181,000
Reflection Questions
1 .What was the couple's total assets? Were you surprised by what you saw?
22,000 and no I was not.
2. What did you think about the total amount of liabilities? Were you surprised by the a
Its ight and no I was not.
3. What was the total net worth? Were you surprised by what you saw?
201,000 was the total net worth and no I was not.
4. What did you learn about net worth from this activity? The net worth was a lot.
chool
ook. Some may be zero. Jacob and Payton Cook
Satement of Net Worth
12/31/2021
Assets
Liabilities
Checking Account
$8,000
Mortgage
$145,000
Savings Account
$14,000
Car #1
$16,000
Investments
Car #2
$12,000
Securities
$11,000
Credit Card #1
$5,000
Treasury Bills
$98,000
Credit Card #2
$7,000
Other Investments
$27,000
Credit Card #3
$14,500
Real Estate
Student Loans
$36,000
Real Estate
$150,000
Other Assets
Automobiles
$35,000
Retirement Accounts
$65,000
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
amount of liabilities they had? Why?
Related Questions
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
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
Given the information here, what should Jason's adjusted checkbook balance be?
Bank balance:
$ 600
$ 260
$
Outstanding checks:
Deposit in transit:
ATM fees:
Interest earned:
Checkbook balance:
Select one:
a. $300 X
b. $171
c. $113
d. $242
e. $440
100
$50
$ 10
$ 480
arrow_forward
prado
chnical
University,
/ Unit 3: Financial Mathematics / Learn: Cash and Bank Reconciliation
nand Bank Reconciliation
Questions
+
Question 5
Which of the following is an example of a book item, an item that is found on the bank
statement that you have not recorded in the books yet?
Bank service charge
Cash deposits made at the bank last month
Interest earned last year
Taxable income
I don't know
One attempt
You answered 3 out of 4 correctly. Asking up to 8.
Submit answer
Exit
arrow_forward
Cy loans Mookie The Beagle Concierge $1,000 at 6% annual interest. Record the transaction as a loan payable as follows.
Required:
1. Complete a Deposit.
a. Select (+) New icon > Bank Deposit
b. Select Account: 1001 Checking
c. Select Date: 01/12/2023
d. In Add Funds to This Deposit section, select Account: + Add New > Account Type: Other Current Liabilities > Detail Type: Loan Payable > Name: Loan Payable > Number: 2300 > Save and Close
e. Select Payment Method: Check
f. Enter Reference Number: 5002
g. Enter Amount: 1000.00
h. Select Save and close
i. What is the Amount of the Loan Payable?
Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount.
Amount of the loan payable ()
View the Transaction Journal for the Deposit.
a. From the Navigation Bar, select Accounting
b. From the Chart of Accounts, select 2300 Loan Payable > View Register
c. From the Register, select the transaction just recorded > Edit
d. From the…
arrow_forward
Cy loans Mookie The Beagle Concierge $1,000 at 6% annual interest. Record the transaction as a loan payable as follows.
Required:
1. Complete a Deposit.
a. Select (+) New icon > Bank Deposit
b. Select Account: 1001 Checking
c. Select Date: 01/12/2023
d. In Add Funds to This Deposit section, select Account: + Add New > Account Type: Other Current Liabilities > Detail Type: Loan
Payable > Name: Loan Payable> Number: 2300 > Save and Close
e. Select Payment Method: Check
f. Enter Reference Number: 5002
g. Enter Amount: 1000.00
h. Select Save and close
i. What is the Amount of the Loan Payable?
Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount.
i. Amount of the loan payable
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
Prepare The General Jorunal
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
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
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
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
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
Cy loans Mookie The Beagle™ Concierge $2,000 at 6% annual interest. Record the transaction as a loan payable as follows.
Complete a Deposit.
Select Create (+) icon > Bank Deposit
Select Account: Checking
Select Date: 01/12/2022
In Add Funds to This Deposit section, select Account: + Add New > Loan Payable > Account Type: Other Current Liabilities > Detail Type: Loan Payable > Name: Loan Payable, then select Save and close
Select Payment Method: Check
Enter Ref No.: 5002
Enter Amount: 2000.00
Select Save and close
What is the Amount of the Loan Payable? (Answer this question in the table shown below. Round your answer 2 decimal places.)
View the Transaction Journal for the Deposit.
From the Navigation Bar, select Accounting
From the Chart of Accounts, select Loan Payable > View Register
From the Register, select the transaction just recorded > Edit
From the bottom of the Loan Payable transaction, select More > Transaction Journal
What are the…
arrow_forward
TYPEWRITTEN ONLY PLEASE FOR UPVOTE. DOWNVOTE FOR HANDWRITTEN. DO NOT ANSWER IF YOU ALREADY ANSWERED THIS. I'LL DOWNVOTE.
arrow_forward
Help please
arrow_forward
CHAPTER : BANK RECONCILIATION
arrow_forward
Please answer the number 3.
Thanks tutor
arrow_forward
CPPREP4005 Prepare to work with real estate trust accounts - ACT
Fill in each blank space with the missing answer
Your agency, Entry Real Estate, sold Guiseppe Butler's property at 143 Violet Place, Jacksonville for $800,000 to
Sue Smith on the 1st November 2022.
There was the usual, initial cash deposit of 0.25% on exchange of contracts.
Four days later Sue paid the remaining balance of the 10% via bank transfer.
Settlement funds were disbursed on the 8th December 2022 along with the agents 2% commission.
Complete the following ledger with the correct information (ensure monetary values are written as follows:
$0,000.00)
BUTLER to SMITH
Property:
Date
01/11/2022
05/11/2022
Balance
G Butler-
Entry
04
Jacksonville
Description
% deposit
%
Receipt #
Chq/Eft
101
107
funds 332
333
Method
Cash
Transfer
EFT
EFT
$
Amount
CPPREP4004-L....pdf
Update:
?
Show all
X
arrow_forward
Give typing answer otherwise I'll give you downward
arrow_forward
Questions:
The following is a summary of Jane’s bank account for the year ended 31 December 2021:
$ $
Balance 1.January .2002 4,100 Payments to creditors for goods 67,360
Receipts from debtors 91,190 Rent 3,950
Balance 31Dec.2002 6,300 Insurance 1,470
Sundry expenses 610
Drawings 28,200
101,590 101,590
All of the…
arrow_forward
answer must be in proper format or i will give down vote
arrow_forward
View Policies
Show Attempt History
Current Attempt in Progress
Sheridan Inc. owns these assets at the statement of financial position date:
Cash in bank (savings account)
$20,240
Cash on hand
1,540
Prepaid insurance
1.840
Cash in bank (chequing account)
12,880
Postdated cheques received from customers
920
(a)
Your answer is correct.
What amount should be reported as cash and cash equivalents in the statement of financial position?
Cash
34660
eTextbook and Media
Attempts: 1 of 3 used
arrow_forward
The following pertain to French Quarter Gifts & T-Shirts, Inc.
March 31, 2020
Cash Balance Per Bank Statement $5,230.80
Balance Per Books $5,477.40
Bank Statement Checks Paid
1102 $57.00
1103 84.29
1104 47.89
1105 87.40
1106 202.78
1107 890.09
1108 87.39
1109 12.35
1110 192.04
Cash Disbursements Journal (Check payments journal)
1101 12.30
1102 $57.00
1103 84.29
1104 47.89
1105 87.40
1106 202.78
1107 890.09
1108 87.39
1109 12.35
1110 192.04
1111 150.11
1112 119.41
Interest Earned $283.95
Bank Service Charge $44.00
A deposit of $1,029.37 was made on March 31, at 3:58 pm. It was properly recorded on the books, but it did not appear on the bank statement.
A check for $261.00 from a customer was deposited on March 27 but the accountants’ failed to record it in the cash receipts journal or in the cash account.
Reconcile the bank statement for the month of March 31, 2020
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- 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_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_forwardGiven the information here, what should Jason's adjusted checkbook balance be? Bank balance: $ 600 $ 260 $ Outstanding checks: Deposit in transit: ATM fees: Interest earned: Checkbook balance: Select one: a. $300 X b. $171 c. $113 d. $242 e. $440 100 $50 $ 10 $ 480arrow_forward
- prado chnical University, / Unit 3: Financial Mathematics / Learn: Cash and Bank Reconciliation nand Bank Reconciliation Questions + Question 5 Which of the following is an example of a book item, an item that is found on the bank statement that you have not recorded in the books yet? Bank service charge Cash deposits made at the bank last month Interest earned last year Taxable income I don't know One attempt You answered 3 out of 4 correctly. Asking up to 8. Submit answer Exitarrow_forwardCy loans Mookie The Beagle Concierge $1,000 at 6% annual interest. Record the transaction as a loan payable as follows. Required: 1. Complete a Deposit. a. Select (+) New icon > Bank Deposit b. Select Account: 1001 Checking c. Select Date: 01/12/2023 d. In Add Funds to This Deposit section, select Account: + Add New > Account Type: Other Current Liabilities > Detail Type: Loan Payable > Name: Loan Payable > Number: 2300 > Save and Close e. Select Payment Method: Check f. Enter Reference Number: 5002 g. Enter Amount: 1000.00 h. Select Save and close i. What is the Amount of the Loan Payable? Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount. Amount of the loan payable () View the Transaction Journal for the Deposit. a. From the Navigation Bar, select Accounting b. From the Chart of Accounts, select 2300 Loan Payable > View Register c. From the Register, select the transaction just recorded > Edit d. From the…arrow_forwardCy loans Mookie The Beagle Concierge $1,000 at 6% annual interest. Record the transaction as a loan payable as follows. Required: 1. Complete a Deposit. a. Select (+) New icon > Bank Deposit b. Select Account: 1001 Checking c. Select Date: 01/12/2023 d. In Add Funds to This Deposit section, select Account: + Add New > Account Type: Other Current Liabilities > Detail Type: Loan Payable > Name: Loan Payable> Number: 2300 > Save and Close e. Select Payment Method: Check f. Enter Reference Number: 5002 g. Enter Amount: 1000.00 h. Select Save and close i. What is the Amount of the Loan Payable? Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount. i. Amount of the loan payablearrow_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 balancearrow_forwardPrepare The General Jorunalarrow_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_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_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_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. 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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you