i need it in excel formulas.

U - ${A} $4,030 {B} Years 25 ${C} $47,941 {D}% 3.39% Problem: DG has decided to retire at age of 65. He would like to have monthly pension of $ 4030. His IRF earns 3.00% per annum compounded semi-annually for 25 years after retirement A. How much money DG need in his account when he retires? B. How much money DG need in account now at the age of 25 years. a C. When He retires, he intend to buy his dream car and will contribute a down payment of $10000. If the vehicle costs $47941 and can be financed for 3.39% compounded annually, what is his monthly payment on vehicle if he finance for 96 months