Instructions: Use excerto calculate the principle and interest payment on the following loans. Amount of Loan 500,000 800,000 Annual interest rate 4% 6% Loan term in years 15 30 200,000 7.25% 40 Monthly Interest rate Loan term in months Monthly Payment Instructions: Use the time value of money charts and excel to calculate the present value of future payments Payment amount 2,500 40,000 Discount Rate 1% 12% 20 16 Number of Periods 500,000 20% 8 Muliplier on chart Present Value of future payments using the chart Present Value of future payments using excel