Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you please help me to fill these in Excel. thank you! Salary Annual Salary $ 118,656 Monthly Salary $ 9,888.00 1% of Salary $

Can you please help me to fill these in Excel. thank you!

Salary
Annual Salary $ 118,656
Monthly Salary $ 9,888.00
1% of Salary $ 1,186
28% of Monthly Income $ 2,769
36% of Monthly Income $ 3,560
Mortgage for 15 years at 5.975%
Max Mortgage for 15 years at 5.975%
Max House Budget
Chosen House Price $ 104,700
Down Payment - 20% $ 20,940.00
Total Mortgage $ 83,760.00
Loan Period (in months) 180
APR - Annual Percentage Rate 5.975%
Monthly Mortgage Payment: PMT()
Total Mortgage Repayment
Total Interest
Final House Cost (Including Down Payment)

30 years at 7.092%
Max Mortgage for 30 years at 7.092%
Max House Budget
Chosen House Price $ 395,000
Down Payment - 20% $ 79,000.00
Total Mortgage $ 316,000.00
Loan Period 360
APR - Annual Percentage Rate 7.092%
Monthly Mortgage Payment: PMT()
Total Mortgage Repayment
Total Interest
Final House Cost (Including Down Payment)

For the following calculations, choose the mortgage you will work with:
I have chosen the mortgage with a length in years of 15
PITI ([Principal, Interest], Taxes and Insurance)
Monthly Mortgage Payment
Monthly Insurance
Monthly Property Taxes
PITI
Monthly House Debt
HOA Dues
PITI
Monthly House Debt Value
Total Monthly Debt
PITI
HOA Fees
Monthly Car Payment
Mininum Credit Card Payment
Total Monthly Debt

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance A Practical Approach

Authors: Jane King, Mary Carey

1st Edition

0199668833, 9780199668830

More Books

Students also viewed these Finance questions