House Price Down payment Based on the down payment and mortgage information in TABLE 2, calculate the variables below: To calculate payment, you must use the "PMT function in excel Be sure to enter interest rate appropriately (monthly Loan Amount 2 points 15-year loan interest rate monthly perfods in 15-year loan 30-year loan interest rate monthly periods in 30 year loan monthly payment on a 30 y loans PMT function total interest and over the life of 30 y loan 2 points TABLE Tall Oaks Company is a mature firm that currently pays a smal dividend Tal Oaks just paid an annual dividend of $1.60 perware The dividend w grow at a rate of 3% per year. The required rate of retum on Tall Oaks stocks 10.3 per year Divendapat Use the information in TABLE 3 to calculate the values shown below Year dividend Today's Tulos Hequired turn on stock ock price