show working

Calculate a 30-Yr Mortgage Payment based on the interest rate and loan terms. Find a Down Payment necessary and use solver change payment to $3,500. $1,000,000.00 Market Value Down Payment Amount Borrowed Interest Rate Number of Payments Type $1,000,000.00 6.00% 360 0 Total Paid Interest Monthly Payment Calculate a 30-Yr Mortgage Payment based on the interest rate and loan terms. Find a Down Payment necessary and use solver change payment to $3,500. $1,000,000.00 Market Value Down Payment Amount Borrowed Interest Rate Number of Payments Type $1,000,000.00 6.00% 360 0 Total Paid Interest Monthly Payment