Please fill in the yellow boxes and Dividend and Cash Flow below. THanks

Please fill in the yellow boxes and Dividend and Cash Flow below. THanks *****READ DIRECTIONS THOROUGHLY BEFORE BEGINNING ASSIGNMENT !!!!! ****ENTER ALL ANSWERS IN THE YELLOW CELLS IN THIS BOX**** Use the financial statements in TABLE 1 below to calculate the three values shown below: Use the mortgage information in TABLE 2 to calculate monthly payment and total interest paid: To calculate payment, you must use the PMT function in excel. Be sure to enter interest rate appropriately Review section 5.4 in the book for help Use the information in TABLE 3 to calculate the two values shown below: Miller Company just paid a dividend of $1.55 per share. The required rate of return on Miller stock is 10.3% per year. Miller anticipates the following yearly growth rates in dividends. Starting in year 8, the dividend will grow at 3% per year indefinitely. HINT: you may find it helpful to calculate dividends and cash flows to help you solve this problem, but you are free to solve however you wish as long as you use Excel Please fill in the yellow boxes and Dividend and Cash Flow below. THanks *****READ DIRECTIONS THOROUGHLY BEFORE BEGINNING ASSIGNMENT !!!!! ****ENTER ALL ANSWERS IN THE YELLOW CELLS IN THIS BOX**** Use the financial statements in TABLE 1 below to calculate the three values shown below: Use the mortgage information in TABLE 2 to calculate monthly payment and total interest paid: To calculate payment, you must use the PMT function in excel. Be sure to enter interest rate appropriately Review section 5.4 in the book for help Use the information in TABLE 3 to calculate the two values shown below: Miller Company just paid a dividend of $1.55 per share. The required rate of return on Miller stock is 10.3% per year. Miller anticipates the following yearly growth rates in dividends. Starting in year 8, the dividend will grow at 3% per year indefinitely. HINT: you may find it helpful to calculate dividends and cash flows to help you solve this problem, but you are free to solve however you wish as long as you use Excel