In the Accumulation column calculate the balance of the investment each month assuming it grew at an interest rate of 12% per year (Cell- G6) over 40 years for both sheets. Cells- H11:down for 40 years
Mortgage Analysis Part I (10 points) Type your name in the title and fill in the terms for each scenario in sheet 1 and 2. Cells- A6:D6 (10 points)Calculate the monthly payment using the equation for both terms. Cell- E6 (10 points)Use the built in PMT function in Excel to verify the payment is correct. […]