jennifer-hutson-attempt2

xlsx

School

Texas A&M University, Commerce *

*We aren’t endorsed by this school

Course

225

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

11

Uploaded by ChiefGoatMaster977

Report
Course Project This Course Project is required and you must score 80% or higher. Your project grade will be weighted 35% o Sheet 1 lists the number that you will use to complete Sheet 2 for the Balance and Sheet 3 for the Monthly Sheet 4 you will analyze a Mortgage Loan. Sheet 5 you will calculate an investment annuity. Use below for Sheet 3-Budget Recurring Monthly Income and Expenses Actual Full Time Day Job 4150 Income from side hustle (selling items on ebay, FB Marketplace e 3150 Other income (driving Uber, Lyft etc) 1000 Rent amount 0 Mortgage payment 1500 Monthly allowance for home maintenance 200 Home insurance 250 Other home expenses 0 Car payments 750 Car insurance 250 Monthly gasoline expense 600 Monthly allowance for car maintenance 200 Other car expense 0 Telephone expense (includes cell phones) 200 Electric bill 350 Water bill 100 Natural gas bill 25 TV streaming services 175 Trash pickup 25 Other utilities expense 0 Monthly grocery expense 600 Eating out expense 400 Clothing, Amazon and other online expense 200 Other food and clothing expense 0 Medication and prescriptions 50 Doctor bills 100 Health insurance 500 Life insurance 150 Childcare 800 Contributions 0 Savings 400 Other health and personal expenses 0 Credit card payments 200 Student loan payments 0 Please download the Course Project Excel file to your computer, saving it with your name as the filename. F To submit your finished project, please click the Activities tab on top of our course homepage, click Assignm and Submit Assignment to upload your completed Course Project Excel file.
Other personal loan payments 250
of your final course grade. y Budget. Use below for sheet 2-Balance Sheet Balance Sheet Items Investment account 30000 Credit cards balance owed 7500 Honda loan 8000 Retirement account 250000 2018 Honda Accord value 13000 2015 Ford 150 Pickup value 8000 House value 250000 Boat value 10000 House loan 175000 Savings account balance 2500 Ford pickup loan 6000 Checking account balance 2000 Boat loan 2000 For example: David-Kent-CID346-Final Project ment , then Course Project
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
Total question worth 20 points Blance Sheet January 31, 2023 Assets Amount Liabilities 1 Investment Account 30000 1 Credit card balance owed 2 2018 Honda Accord 13000 2 Honda loan 3 2015 Ford F150 Pickup 8000 3 House loan 4 House 250000 4 Ford pickup loan 5 Boat 10000 5 Boat loan 6 Savings Account 2500 6 7 Checking Account 2000 7 8 Retirement Account 250000 8 Total Assets 565500 (5 points) Total Liabilities Net Worth Total Liabilities and Net worth
Amount 7500 8000 ` 175000 6000 2000 198500 (5 points) 367000 (5 points) 565500 (5 points)
Total question worth 20 points Questions As Of August 31, 2021 Please prepare a monthly budget using the template below and the numbers in sheet 1. Then, answer the following questions: 1. What is the Total Monthly Expense? 7675 2. What is the ratio (percentage) of expenses to income? 92.40% 3. In your opiniion, should any adjustments be made (or can be made) with actual expenses? You could s Actual Net Income 8300 Recurring Expenses Total Housing expense 1950 Total transportaion expense 1800 Total utilities expense 875 Total food and clothing expense 1000 Total health and personal expense 1600 Total other monthly debt expense 450 Total Monthly Expenses 7675 Net Income Less Expenses 625
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
(5 points) (5 points) spend less (5 points) (5 points)
Total question worth 20 points Analyzing a Mortgage Assume you are looking to buy a new home for $325,000 and you were shopping for a mortgage. You are prepared to pay 1 you a 30 year fixed rate mortgage at 5%. Mortgage company B offers you a 20 year fixed rate mortgage at 4%. Use a mortga approximate mortgage payments. Answer the following questions: What is the dollar amount of the down payment? What is the dollar amount of the mortgage (amount borrowed)? What is the monthly mortage payment (principal and interest and PMI) on the 30 year mortgage? To determine if Mortgage B is /is not affordable : If you choose Mortgage A and assuming you keep the loan to maturity, how much interest will you pay throughout the life of t If you choose Mortgage B and assuming you keep the loan to maturity, how much interest will you pay throughout the life of t Using $5,000 as gross income and using the 33/38 PITI rule for determining qualification, do you qualify for: What is the mortage payment ( principal and interest only ) on the 30 year mortgage at a fixed rate of 5%? In most cases a lender would require a mortage insurance (about 0.5% - 1.5% of loan value) if the down payment is less than 2 value. Since you are making only 17% down payment, what would be your mortage insurance (PMI portion only) for the amou borrowing per year if the PMI is 0.5% of loan value ? What is the PMI portion of your monthly mortage payment per month ? What is the mortgage payment (principal and interest only) on the 20 year mortgage? What is the monthly mortage payment (principal and interest and PMI) on the 20 year mortgage where PMI is 0.5% of the loa
ge Company A offers ator to calculate the $55,250.00 (1 point) $269,750.00 (1 point) $1,448.00 (1 point) $1,348.75 (1 point) $112.40 (1 point) $1,560.40 (1 point) $1,635.00 (1 point) $1,747.03 (1 point) $404,625.00 (1 point) $215,800.00 (1 point) Mortgage A? Yes (5 points) Mortgage B? No (5 points)
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
Total question worth 40 points Saving for the Future If you could save $12,000 per year ($1,000 per month) for 20 years towards your retirement and you could e what would the balance be in your retirement account at the end of 20 years for each of the senarios describ Senario 1: If the intial deposit is $0 and you choose to make $1000 deposit at the end of every month f Answer $366,775 Senario 2: If the initial deposit is $1000 and are making periodic deposits at the beginning of every mon Answer 368,997 Senario 3: If you are making only an annual deposit of $12000 at the beginning of each year (say 2nd Ja Answer 386,770 Senario 4: if you are making only an annual deposit of $12000 at the end of each year (eg: 31st of Dec w Answer 360,099
earn an APR of 4%, and compounded monthly bed below? for 20yrs ( 10 points) nth for 20yrs ( 10 points) an which is the first business day of the year) for 20yrs ( 10 points) which is the last business day of the year) for 20yrs ( 10 points)