Create an amortization schedule/sinking fund schedule for the following:

c. A $500,000 loan with level payments made at the end of each year for 30-years. Assume an annual effective interest rate on the loan of 4% and that the loan is repaid with the sinking fund method. Assume the sinking fund earns an annual effective rate of 3%.

In excel and with equations listed please