acctounting homework

profileanfrne
copy_of_personal_finances.xlsx
Home>Business & Finance homework help>Accounting homework help>acctounting homework

JuneTotals

June Transactions
Date Payee Category Method of Payment Amount
6/1/12 Zachary Kaye Rent Check $ (800.00)
6/2/12 George's SuperMart Groceries Credit Card $ (114.62)
6/3/12 Sam's Stop Gas Debit Card $ (61.13)
6/4/12 Visa Credit Card Payment Check $ (300.00)
6/8/12 South & Main ATM Withdrawal Debit Card $ (202.00)
6/8/12 Income Salary Check $ 2,034.78
6/8/12 [Savings Account] Transfer to Savings Transfer $ (300.00)
6/9/12 George's SuperMart Groceries Credit Card $ (136.52)
6/12/12 Gas-N-Wash Gas Debit Card $ (57.49)
6/15/12 SEC Electric Bill Check $ (217.61)
6/15/12 Springfield Savings & Loans Student Loan Check $ (175.00)
6/16/12 George's SuperMart Groceries Debit Card $ (173.06)
6/18/12 Gas-N-Wash Gas Credit Card $ (65.33)

June2012

Search Results
Position: 8 Amount:
Date Payee Category Method of Payment Amount Groceries
6/1/12 Zachary Kaye Rent Check $ (800.00) Total Cost:
6/4/12 Visa Credit Card Payment Check $ (300.00) Average Cost:
6/8/12 South & Main ATM Withdrawal Debit Card $ (202.00) Occurrences:
6/8/12 Income Salary Check $ 2,034.78 Groceries - Credit Card
6/8/12 [Savings Account] Transfer to Savings Transfer $ (300.00) Total Cost:
6/15/12 SEC Electric Bill Check $ (217.61) Average Cost:
6/15/12 Springfield Savings & Loans Student Loan Check $ (175.00) Occurrences:
6/18/12 Gas-N-Wash Gas Credit Card $ (65.33)
6/18/12 SGW Water Bill Check $ (43.59)
6/22/12 South & Main ATM Withdrawal Debit Card $ (262.00) Average Credit Card Purchase:
6/22/12 Income Salary Check $ 2,034.78
6/22/12 [Savings Account] Transfer to Savings Transfer $ (300.00)
6/23/12 George's SuperMart Groceries Credit Card $ (109.64) Total Remaining:
6/25/12 CIV Solutions Cable/Internet Check $ (102.83)
6/25/12 Springfield Savings & Loans Car Loan Check $ (233.00) Payment Options: Check
6/28/12 AMP Insurance Car Insurance Check $ (96.47) Credit Card
6/29/12 Sam's Stop Gas Debit Card $ (60.08) Debit Card
6/30/12 George's SuperMart Groceries Debit Card $ (149.68) Transfer

AnnualExp

Year Category Expense Amount
2009 Variable ATM Withdrawal $ 3,995.00
2009 Fixed Cable/Internet $ 1,188.06
2009 Fixed Car Insurance $ 1,112.16
2009 Fixed Car Loan $ 2,796.00
2009 Variable Credit Card Payment $ 2,460.00
2009 Variable Water Bill $ 493.27
2010 Variable ATM Withdrawal $ 4,240.00
2010 Fixed Cable/Internet $ 1,215.96
2010 Fixed Car Insurance $ 1,157.64
2010 Fixed Car Loan $ 2,796.00
2010 Variable Credit Card Payment $ 3,290.00
2011 Variable ATM Withdrawal $ 4,465.00
2011 Fixed Cable/Internet $ 1,233.96
2011 Fixed Car Insurance $ 1,157.64
2011 Fixed Car Loan $ 2,796.00
2011 Variable Credit Card Payment $ 3,924.00

HomeLoan

Mortgage Options
Retail Cost $265,500
Down Payment $24,000
Amount to Finance $241,500
Interest Rate 6.75%
Term (months) 180
Monthly Payment $2,137.06
6.00% 6.25% 6.50% 6.75% 7.00% 7.25% 7.50%
6.00% 6.25% 6.50% 6.75% 7.00% 7.25% 7.50%
120
180
240
360

CarLoan

Car Loan
Payment Details Loan Details
Payment $ 233.00 Loan $12,124.83
APR 5.75% Periodic Rate 0.479%
Years 5 # of Payments 60
Pmts per Year 12
Payment Number Beginning Balance Payment Amount Interest Paid Principal Repayment Cumulative Interest Cumulative Principal
1 $12,124.83 $ 233.00 $ 58.10 $ 174.90 $ 58.10
2 $11,949.93 $ 233.00 $ 57.26 $ 175.74 $ 115.36
3 $11,774.19 $ 233.00 $ 56.42 $ 176.58 $ 171.78
4 $11,597.60 $ 233.00 $ 55.57 $ 177.43 $ 227.35
5 $11,420.18 $ 233.00 $ 54.72 $ 178.28 $ 282.07
6 $11,241.90 $ 233.00 $ 53.87 $ 179.13 $ 335.94
7 $11,062.76 $ 233.00 $ 53.01 $ 179.99 $ 388.95
8 $10,882.77 $ 233.00 $ 52.15 $ 180.85 $ 441.09
9 $10,701.92 $ 233.00 $ 51.28 $ 181.72 $ 492.37
10 $10,520.20 $ 233.00 $ 50.41 $ 182.59 $ 542.78
Totals $ 2,330.00 $ 542.78 $ 1,787.22