URGENT PLEASE ANSWER THE QUESTION BELOW AND PASTE A COPY OF AN EXCEL LINK TO UNDERSTAND THE ASSIGNMENT BETTER. THIS IS AN INTRODUCTION TO CIVIL ENGINEERING AND WE ARE LEARNING SPREADSHEET AMORTIZATION SCHEDULE SO IT HAS TO DO SPECIFICALLY WITH THAT. I AM ATTACHING THE PROBLEM STATMENT BENEATH SO IF YOU HAVE ANY QUESTIONS PLEASE REACH OUT. BUT I REALLY DO NEED THE HELP THANK YOU

THE NUMBERS THAT ARE SUPPOSED TO BE USED ARE THE FOLLOWING. ONLY USE THESE NUMBERS PLEASE

P	153,975.00
i	9.80 %
n	15.00
A	?

I WOULD STILL HAVE TO FIND A AND FILL OUT THE CHARTS. PLEASE PLEASE HELP ME if you're specialized in EXCEL

Problem Statement For a given loan amount to be paid back over a period of time at a xed interest rate, the assignment is to calculate and create a table that includes: 1. The amount of each periodic payment; 2. The amount of principal included in each payment; and 3. The amount of interest included in each payment. The formula to calculate the total amount of each periodic payment (which is the same) is: A _ P r(l + r)" _ (1 + r)" 1 Where: n = number of payments or periods r = interest rate per period P = the principal amount of the loan A = the periodic payment amount Loans are typically described by the principal amount (in dollars), the term (in years), and the annual interest rate (as a percentage). For example, a $100,000 loan for 15 years at 3.5%. The first step is to calculate the periodic (usually monthly) payment amount. Note that units for n and r must be consistent. If you are going to make monthly payments, then 11 is the number of months, and r is the interest rate per month. Aer calculating the monthly payment amount, the next steps are to determine the amounts of principal and interest, which vary om month to month, included in each monthly payment. The interest due in any periodic payment is determined by calculating the interest on the remaining principal at the start of that period. The amount of principal that is reduced by that l periodic payment is the difference between the periodic payment amount and the calculated interest payment. This step is repeated for each monthly payment until the end of the term of the loan. Here is a sample calculation for a $400,000 loan at 6% per year for 15 years with monthly payments: P = $400,000 r = (.06/year) / (12 months/year) = 0.005/month n = (15 year) x (12 months/year) = 180 months Using the above formula, A = $3,375.43/month Note: Since (1+r)\" appears twice in the formula, do this calculation in an intermediate cell, and use that cell value in your calculation of A. (1+1)11 = (1+0.005)"180 = 2.454 Note: It's a good idea to occasionally check a calculation on your calculator to make sure your syntax is correct in the spreadsheet. For the rst payment, the outstanding principal is the full amount of the loan. 'I'herefor the interest included in the rst payment is: i1 = $400,000 x 0.005 = $2,000.00 The amount of principal paid is: Pl = $3,375.43 $2,000.00 = $1,375.43 For the second payment, the outstanding principal is: P2 = $400,000 - $1,375.43 = $398,624.57 and I: = $398,624.57 x 0.005 = $1,993.12 p1 = $3,375.43 - $1,993.12 = $1,382.30 Note: You will see that the amount attributable to principal increases, and the amount attributable to interest decreases with each payment. As we are working vn'th money, the values can be shown to two decimal places. There will be circumstances when you will show less than two decimal places (but never one decimal place). You can leave out the dollar signs. I prefer including commas between thousands. Your nal table should look something like this: P 400,000.00 i 0.060 /yr n 15.00 yr (1+r)"n 2.454 A 3,375.43 Principal Principal Balance Balance Payment 8 Before I P After 1 400,000.00 2,000.00 1375.43 398,624.57 2 398,624.57 1,993.12 1382.30 397,242.27 3 397,242.27 1,986.21 1389.22 395,853.05 MO 178 x.xx x.xx x.xx x.xx 179 6,700.56 33.50 3341.92 3,358.63 180 3,358.63 16.79 3358.63 0.00 Total Interest 207,576.92 Total Principal 400,000.00 Ifyour calculations are correct, the sum of all principal payments should equal the original principal. Pay attention to formatting! Your Submission The terms of your loan are: The principal of your loan is the rst six digits of your N# in dollars. The annual interest rate is the last two digits of your N# as a single decimal. If your interest rate is less than 1%, add 2%. e.g., N12345678 P = $123,456 i = 7.8% N21745604 P = $217,456 i = 2.4% The duration of the loan is 15 years. Submit separately (i) a screenshot of the top and bottom of your table, and (ii) the Excel le with your full calculations