Can you expalin these three questions using Excel?

Part a)

Suppose you graduate with a student loan of $30,000. The loan will repaid over 20 years. The bank charges you 6% compounded semi-annually, csa. You make annual payments. The payments are made at the end of the period. What is the amount of the payment?

Part b) Now, suppose that instead of making annual payments you make monthly payments what will be the amount of the monthly payment?

Part a)

Suppose you wish to qcauire a new car. The car costs $30,000. You can finance the car 8% csa. Financing will be for 4 years. Payments will be made monthly. If you borrow the money and buy the car payments will be made at the end of the month. Whar is the amount of payment?

Part b)

Suppose you lease the car. The car still costs $30,000 and your lease will be for 4 years. The lease rate 8% csa. The lease payments will be made at the beginning of the month. Whar is the amount of the payment?

Part c)

Suppose you lease the car. The car still costs $30,000 and your lease will be for 4 years. The lease rate 8% csa. If you wish to the car at the end of your lease you need to make a lump sum payment of $14,000. The monthly lease payments will be made at the beginning of the month. What is the amount of the monthly payment?

You will retire in 30 years. You wish to receive an income of $4,000 per month during retirement. The income will be paid at the beginning of the month. You expect to live for 20 years during retirement. You will earn 6% compounded semi-annually during retirement. How much do you need when you retire?

You have $5,000 in a retiement account. The account earns 8% compounded annually. How much will be in the account when you retire?

How much must you set aside at the end of each week in order to meet your retirement goals? The money you set aside each week will earn 7% compounded monthly.