Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE HELP WITH THE CHART FOR ALL 360 DAY WITH EXCEL FORMULA FOR ALL AREAS. THANK YOU!!! A J K L L B D E
PLEASE HELP WITH THE CHART FOR ALL 360 DAY WITH EXCEL FORMULA FOR ALL AREAS. THANK YOU!!!
A J K L L B D E F G H Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360 months and answer the following questions (The details about the loan are shown below): 3 Correct Answers 4 1. What is your monthly payment? 2. What is the total $ amount of payments made over the life of the loan Enter Answers Here. 3. How many months will it take to pay off the loan if you pay an extra $190.84 per month? 7 Note: Enter the month when the whole principal is paid off. Also, remember to show the amortization table for the original payment before you submit. Payment Payment Beginning Balance Interest Paid 8 8 No. Amount Principle Paid Ending Balance 9 Loan Input Data Amount 1 10 Principal Amount $510,000.00 2 11 Annual Interest Rate 3.50% 3 12 Periods Per Year 12 A 4 13 Total Number of Payments 360 s 5 14 Percentage Rate Per Period 6 15 Extra Payment per month $190.84 7 16 8 17 Grade Mortgage 9 18 10 10 19 Mortgage Score 11 20 Total Score 0.00 12 21 13 22 14 23 15 24 16 25 17 26 FEEDBACK: 18 10 27 19 17 28 20 2u 29 21 30 22 22 31 23 32 24 33 25Step 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