COULD YOU SHOW ME IN EXCEL PLEASE

Gillian has entered the agreement with Geoffrey described above. She estimates that the costs of the delivery services she has promised to Geoffrey (petrol, insurance, wear and tear, etc) amount to $1239.8292380674 per month in advance for the coming 5 years.

(a) If Gillian can borrow/invest money at a rate of 3.1% p.a. effective, what is the equivalent amount today of her future liabilities? Note that this calculation should not involve the payment she receives from Geoffrey today.

(b) The money she receives from Geoffrey can be considered a loan, with repayments being the value of the services she provides in return. What is the interest rate, expressed as an effective annual rate, she is being charged on this "loan"?

COULD YOU PLEASE SHOW ME IN EXCEL