Can you please show me how to do this in ms Excel. Find the payment you would need to make per year at a discount rate (interest rate that the bank charges you) from 0% to 50% (51 answers), if you borrow $5,000,000 ($5 million) today (PV) and pay it back in equal amounts over the next 30 years. Make a table and graph of your answers.