If you can explain it with excel formulas will be really helpful, thank you.

3. You are planning to buy a car worth $30,000. Which of the two 5-year deals described below would you choose: the dealer offers to take 10% off the price, and lend you the balance at the regular financing rate (which is an annual percentage rate of 9%) the dealer offers to lend you $30,000 (with no discount) at a special financing rate of 3% 4. A company is planning to set aside money to repay $100 million in bonds that will be coming due in 10 years. If the appropriate discount rate is 9%, a. how much money would the company need to set aside at the end of each year for the next 10 years to be able to repay the bonds when they come due? b. how would your answer change if the money were set aside at the beginning of each year?