90.2K

Verified Solution

Link Copied!

Hello, please help me complete this data table for question 2!

Create a data table using a what-if-analysis showing how mortgage payment amount change with interest rates (1%-30%) and loan term (1yr-10yr).

Mortgage Information 4 Loan amount $300,000 5 Loan term 30 years 6 Interest rate 6.00% given no other information, assume APR 7 Payments made 50 8 9 Q1: Please use Excel mortgage functions to find the answer of the following questions: 10 Mortgage payment amount: 11 $1,798.65 (3 points) 12 Interest amount of last payment: 13 $1,417.32 (3 points) 14 Cumulative interest paid: 15 $73,015.41 (3 points) 16 Cumulative Principal paid: 1 17 $16,917.17 (3 points) 18 19 Q2: Data Table (8 points) 20 Create a data table (What-if Analysis) showing how Mortgage payment amount change with interest rate (1% - 30%) and loan term(1 yr - 10 21 1 2 3 5 6 7 8 9 10 22 1% 23 2% 24 3% 25 4% 26 5% 27 6% 28 7% 29 8% 30 9% 31 10% 32 11% 33 12% 34 13% 35 14% 36 15% 37 16% 38 17% 39 18% 40 19% 41 42 21% 43 22% 44 23% 45 24% 46 25% 47 26% 48 27% 49 28% 50 29% 51 30% 52 20% Mortgage Information 4 Loan amount $300,000 5 Loan term 30 years 6 Interest rate 6.00% given no other information, assume APR 7 Payments made 50 8 9 Q1: Please use Excel mortgage functions to find the answer of the following questions: 10 Mortgage payment amount: 11 $1,798.65 (3 points) 12 Interest amount of last payment: 13 $1,417.32 (3 points) 14 Cumulative interest paid: 15 $73,015.41 (3 points) 16 Cumulative Principal paid: 1 17 $16,917.17 (3 points) 18 19 Q2: Data Table (8 points) 20 Create a data table (What-if Analysis) showing how Mortgage payment amount change with interest rate (1% - 30%) and loan term(1 yr - 10 21 1 2 3 5 6 7 8 9 10 22 1% 23 2% 24 3% 25 4% 26 5% 27 6% 28 7% 29 8% 30 9% 31 10% 32 11% 33 12% 34 13% 35 14% 36 15% 37 16% 38 17% 39 18% 40 19% 41 42 21% 43 22% 44 23% 45 24% 46 25% 47 26% 48 27% 49 28% 50 29% 51 30% 52 20%

Answer & Explanation Solved by verified expert

See Answer