jennifer-hutson-attempt2
xlsx
keyboard_arrow_up
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
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)
Related Documents
Related Questions
Capital One is advertising a 60-month,
5.99%
APR motorcycle loan. If you need to borrow
$8,000
to purchase your dream Harley Davidson, what will your monthly payment be?
Question content area bottom
Part 1
Your monthly payment will be
$enter your response here.
(Round to the nearest cent.)
arrow_forward
+
You are looking at buying your first car. Based on your budget you can afford up to $400 per month
payments. You go to the DATCU branch in the Union Building and they give you 3 options for
preapproved loans. Fill in the table below. Check your answers in Canvas to make sure you got them
right before the due date! Unlimited attempts to check your math for the tables!
DATCU Options
Term in Months (N)
Down Payment Required
48
60
72
10%
10%
10%
Interest Rate (I/Y)
5.49%
6.49%
6.99%
Hint: Convert to monthly on calculator
$ 400
$ 400
$ 400
Monthly Payment (PMT)
Hint: make it negative on calculator
Maximum Amount Financed (PV)
Down Payment Required in $$
Maximum Price willing to pay for Car
including Tax, Title, and License
If you paid the maximum price on the car calculate the following:
Total Interest paid on the Car
Total Amount paid for car
Hint: It is all the payments and down payment
arrow_forward
Calculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using the APR table, Table 13-1. (Round your answers to the nearest cent.)
arrow_forward
Please help and not handwritten, concept also pls
arrow_forward
A student borrows
$68,300
at
7.2%
compounded monthly. Find the monthly payment and total interest paid over a
15-year
payment plan.
Question content area bottom
Part 1
The payment size is
$enter your response here.
(Round to the nearest cent.)
arrow_forward
Subject: algebra
arrow_forward
If you lend $3000 to a friend for 15 months at 8% annual simple interest, find the future value of the loan.
$
Need Help?
Read It
Master It
4
arrow_forward
Pls do fast and i will rate instantly for sure
Solution must be in typed form
arrow_forward
do assignments using excel and manually if possibly
A student plans to open a business with the courage to borrow $1740,11 and will return the same amount every year for 5 years. If the loan interest from (Small Business Credit) is 6%/year. How much is the student's installment/year?
arrow_forward
You can afford a $200 per month car payment. You've found a 5 year loan at 7% interest. How big of a loan
can you afford?
S
Submit Question
Q Search
hp
O
arrow_forward
Goal
To use recursive sequence to determine the amount money owed on a loan after months
Role
You are a loan officer at a mortgage company.
Audience
Jim and Joan Miller are customers applying for a mortgage.
Situation
Jim and Joan Miller are borrowing $120,000 at 6.5% per annum compounded monthly for 30 years (360 months) to purchase a home. Their monthly
payment is determined to be $758.48.
Performance Task
You need to present Jim and Joan with a report detailing the following:
• Arecursive formula for their balance after each monthly payment has been made.
• To do this, use the formula: a, = an-1 (1+r) – 758.48
A determination of Jim and Joan's balance after the first payment. Don't forget the interest affecting their payment!
• Use a spreadsheet or graphing utility to create a table showing their balance after each monthly payment.
• Determine when the balance will be below $75,000.
• Determine when the balance will be paid off.
• Determine the interest expense when the loan is…
arrow_forward
Save & Exit
Submit
Donny borrows $37,000 to purchase a high-performing computer. The loan will be paid in monthly installments over one year at 12% interest annually
The first payment is due one month from today. What is the amount of each monthly payment? (FV of $1. PV of $1. FVA of $t. PVA of St. EVAD of $t and
PVAD of $1) (Use appropriate factor(s) from the tables provided.)
5-50
Multiple Choice
None of these answer choices are correct.
$3.083
$3.287
$3.039
< Pre
of
MC
Graw
MacBook Air
arrow_forward
4 Math Applications
MyOpenMath
You can afford a $200 per month car payment. You've found a 5 year loan at 7% interest. How big of a loan
can you afford?
Submit Question
Search
1
04
arrow_forward
You can afford a $350 per month car payment. You've found a 5 year loan at 6% interest. How big of a loan
can you afford?
Submit Question
Search
hp
arrow_forward
Module 4 Activity Sheet: Savings Calculator
Name:
Directions: Use the savings calculator from Nerd Wallet to fill in the chart.
Scenario: You earn $100 per month and want to save 10% in a savings account.
1. How much will your monthly contribution be? Enter your response in the chart.
2. Use the savings calculator to find out how much your total savings would be in 1 year if
your account has an annual interest rate of 1%. What would your total savings be in 5
years?
3. You decide to increase your savings to 20%. Fill in the 2nd column.
Save 10%
Save 20%
Monthly contribution
1 year total
5 year total
4. Based on what
you know about saving and investing, would the totals be the same if you
had invested the money, instead of saving it? Why or why not?
arrow_forward
How much would you need to deposit in an account each month in order to have $20,000 in the account in
9 years? Assume the account earns 6% interest.
Submit Question
.com/course/showcalendar.php?cid=179278
Q Search
arrow_forward
Learning Activity No. 2 – Abstraction (Critical Thinking)
Instructions: Fill in the blanks and calculate the monthly payments for a car loan having the details as
provided below.
Item
Computation
Sticker price of a car
Excise tax
Licensing Fee
Down Payment
Annual interest rate "r"
Number of payments a year
Number of years
Periodic rate of interest i
Php 1,700,000.00
20%
Php 20,000.00
35%
6.0%
12
3
Answer:
Loan PV
Answer:
PMT
Answer:
arrow_forward
In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.
arrow_forward
Find the amount (in $) of interest on the loan.
Principal
$90,000
Rate (%)
Need Help?
Submit Answer
53³3
Read It
Time
9 months
S
Interest
arrow_forward
How much will Mollys monthly payment be? Remember to divide the amount borrowing by the number of months
arrow_forward
PV AND LOAN ELIGIBILITY You have saved $5,000 for a down payment on a
new car. The largest monthly payment you can afford is $400. The loan will have
a 12% APR based on end-of-month payments. What is the most expensive car
you can afford if you finance it for 48 months? Round to TWO decimal places.
arrow_forward
K
Suppose you have a student loan of $35,000 with an APR of 6% for 40 years. Complete
parts (a) through (c) below.
a. What are your required monthly payments?
The required monthly payment is $
(Do not round until the final answer. Then round to the nearest cent as needed.)
arrow_forward
Problem #2. Your financed a $30,500 kitchen renovation project with 4.75% add-on interest installment loan for 24 month. The loan required 15% down payment. Show your work for all parts of the problem.
(a) What is the finance charge on the loan?
(b) What are the monthly payments?
(c) What annual percentage rate is being charged on the loan?
arrow_forward
To pay for your education, you've taken out
$24 comma 00024,000
in student loans. If you make monthly payments over
1212
years at
66
percent compounded monthly, how much are your monthly student loan payments?
Question content area bottom
Part 1
Your monthly student loan payments are
$enter your response here.
(Round to the nearest cent.)
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
Calculate the amount financed, the finance charge, and the monthly payments (in $) for the add-on interest loan. (Round your answers to the nearest cent.)
Purchase
(Cash)
Price
$6,000
Down
Payment
15%
Need Help? Read It
LA
Amount
Financed
Add-on Number of
Interest Payments
13-1%
2
30
LA
Finance
Charge
LA
Monthly
Payment
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- Capital One is advertising a 60-month, 5.99% APR motorcycle loan. If you need to borrow $8,000 to purchase your dream Harley Davidson, what will your monthly payment be? Question content area bottom Part 1 Your monthly payment will be $enter your response here. (Round to the nearest cent.)arrow_forward+ You are looking at buying your first car. Based on your budget you can afford up to $400 per month payments. You go to the DATCU branch in the Union Building and they give you 3 options for preapproved loans. Fill in the table below. Check your answers in Canvas to make sure you got them right before the due date! Unlimited attempts to check your math for the tables! DATCU Options Term in Months (N) Down Payment Required 48 60 72 10% 10% 10% Interest Rate (I/Y) 5.49% 6.49% 6.99% Hint: Convert to monthly on calculator $ 400 $ 400 $ 400 Monthly Payment (PMT) Hint: make it negative on calculator Maximum Amount Financed (PV) Down Payment Required in $$ Maximum Price willing to pay for Car including Tax, Title, and License If you paid the maximum price on the car calculate the following: Total Interest paid on the Car Total Amount paid for car Hint: It is all the payments and down paymentarrow_forwardCalculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using the APR table, Table 13-1. (Round your answers to the nearest cent.)arrow_forward
- Please help and not handwritten, concept also plsarrow_forwardA student borrows $68,300 at 7.2% compounded monthly. Find the monthly payment and total interest paid over a 15-year payment plan. Question content area bottom Part 1 The payment size is $enter your response here. (Round to the nearest cent.)arrow_forwardSubject: algebraarrow_forward
- If you lend $3000 to a friend for 15 months at 8% annual simple interest, find the future value of the loan. $ Need Help? Read It Master It 4arrow_forwardPls do fast and i will rate instantly for sure Solution must be in typed formarrow_forwarddo assignments using excel and manually if possibly A student plans to open a business with the courage to borrow $1740,11 and will return the same amount every year for 5 years. If the loan interest from (Small Business Credit) is 6%/year. How much is the student's installment/year?arrow_forward
- You can afford a $200 per month car payment. You've found a 5 year loan at 7% interest. How big of a loan can you afford? S Submit Question Q Search hp Oarrow_forwardGoal To use recursive sequence to determine the amount money owed on a loan after months Role You are a loan officer at a mortgage company. Audience Jim and Joan Miller are customers applying for a mortgage. Situation Jim and Joan Miller are borrowing $120,000 at 6.5% per annum compounded monthly for 30 years (360 months) to purchase a home. Their monthly payment is determined to be $758.48. Performance Task You need to present Jim and Joan with a report detailing the following: • Arecursive formula for their balance after each monthly payment has been made. • To do this, use the formula: a, = an-1 (1+r) – 758.48 A determination of Jim and Joan's balance after the first payment. Don't forget the interest affecting their payment! • Use a spreadsheet or graphing utility to create a table showing their balance after each monthly payment. • Determine when the balance will be below $75,000. • Determine when the balance will be paid off. • Determine the interest expense when the loan is…arrow_forwardSave & Exit Submit Donny borrows $37,000 to purchase a high-performing computer. The loan will be paid in monthly installments over one year at 12% interest annually The first payment is due one month from today. What is the amount of each monthly payment? (FV of $1. PV of $1. FVA of $t. PVA of St. EVAD of $t and PVAD of $1) (Use appropriate factor(s) from the tables provided.) 5-50 Multiple Choice None of these answer choices are correct. $3.083 $3.287 $3.039 < Pre of MC Graw MacBook Airarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning