Finals

profiledanevia
bethell_NEW_FinalExam_2020_21_FIT1040.xlsx

AnnualExp

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

JuneTotals

June Transactions
Date Payee Category Method of Payment Amount
6/1/19 Zachary Kaye Rent Check ($800.00)
6/2/19 Publix Super Market Groceries Credit Card ($114.62)
6/3/19 Sam's Stop Gas Debit Card ($61.13)
6/4/19 Visa Credit Card Payment Check ($300.00)
6/5/19 South & Main ATM Withdrawal Debit Card ($202.00)
6/6/19 Income Salary Check $2,034.78
6/7/19 [Savings Account] Transfer to Savings Transfer ($300.00)
6/8/19 Publix Super Market Groceries Credit Card ($136.52)
6/9/19 Gas-N-Wash Gas Debit Card ($57.49)
6/10/19 FPL Electric Bill Check ($217.56)
6/11/19 Springfield Savings & Loans Student Loan Check ($175.32)
6/12/19 Publix Super Market Groceries Credit Card ($173.06)
6/13/19 Gas-N-Wash Gas Credit Card ($65.32)

HomeLoan

Mortgage Options
Cost of Home $ 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