Can you please just at least explain to me what I am supposed to do with the interest rate? Can I use it as it is or am I meant to change it to a nominal value?

c. Jack plans to use an online promotion service to boost his business from 1 January 2021 to 31 March 2021. The cost of this service is listed in the following table. Service price list Weekday (Monday to Friday except public holidays) $100 Saturday $150 Sunday and Public holidays $180 Calculate the present value of this promotion cost on 1 January 2021 by using an effective daily interest rate of 0.01%. Hint : You can use this link (https://www.industrialrelations.nsw.gov.au/public- holidays/public-holidays-in-nsw/) to find the NSW public holidays for the promotion period. You can use the Weekday formula in Excel to returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default. d. Jake is considering to take out a loan of $10,000 to fund this promotion service. The bank has offered three loan options. Option 1: Jake needs to make daily payment of $67 from 1 January 2021 to 31 May 2021 (inclusive). Option 2: Jake needs to make monthly payment of $2,028 by end of each month from January 2021 to May 2021 (inclusive) Option 3: Jake needs to make five payments by end of each month from January 2021 to May 2021 (inclusive). Jake needs to pay $1,910 for January 2021, $1,950 for February 2021 and March 2021, and $2,170 for April 2021 and May 2021. Use Goal Seek to find the implied effective annual rate (i.e., ji) charged by bank for these two three loan options (Assume that there are 365 days in a year.). Which one is better? Use a bar or column chart to compare the loan c. Jack plans to use an online promotion service to boost his business from 1 January 2021 to 31 March 2021. The cost of this service is listed in the following table. Service price list Weekday (Monday to Friday except public holidays) $100 Saturday $150 Sunday and Public holidays $180 Calculate the present value of this promotion cost on 1 January 2021 by using an effective daily interest rate of 0.01%. Hint : You can use this link (https://www.industrialrelations.nsw.gov.au/public- holidays/public-holidays-in-nsw/) to find the NSW public holidays for the promotion period. You can use the Weekday formula in Excel to returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default. d. Jake is considering to take out a loan of $10,000 to fund this promotion service. The bank has offered three loan options. Option 1: Jake needs to make daily payment of $67 from 1 January 2021 to 31 May 2021 (inclusive). Option 2: Jake needs to make monthly payment of $2,028 by end of each month from January 2021 to May 2021 (inclusive) Option 3: Jake needs to make five payments by end of each month from January 2021 to May 2021 (inclusive). Jake needs to pay $1,910 for January 2021, $1,950 for February 2021 and March 2021, and $2,170 for April 2021 and May 2021. Use Goal Seek to find the implied effective annual rate (i.e., ji) charged by bank for these two three loan options (Assume that there are 365 days in a year.). Which one is better? Use a bar or column chart to compare the loan