Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started