please use Excel for all the problems.

Part a) If you deposited $1,000 today planning to deposit $300 per month for 5 years in a savings account that offers 1% APR compounded monthly, how much can you withdraw at the end of the 5th year? Part b) Fill in the following table on Excel by adding formulas. Show the results as percentages and use 3 decimal points. Nominal Periodic Effective Annual Compounded basis daily weekly monthly quarterly semi-annually Interest Rate Interest Rate Interest Rate 6.75% 2.10% 1.15% 4.08% 8.72% annual 3.06% Part c) Fill in the cells with a question mark in the following table. X indicates to ignore that cell Future Value Regular Present Value Term Interest RateCompounding Payment ($) ($) ($) (years) ? 10000 monthly 0 5% APR 10 ? 10000 daily 0 5% APR 10 15% effective annual 300000 annual 10 20% effective ? annual 300000 annual 30 Part a) If you deposited $1,000 today planning to deposit $300 per month for 5 years in a savings account that offers 1% APR compounded monthly, how much can you withdraw at the end of the 5th year? Part b) Fill in the following table on Excel by adding formulas. Show the results as percentages and use 3 decimal points. Nominal Periodic Effective Annual Compounded basis daily weekly monthly quarterly semi-annually Interest Rate Interest Rate Interest Rate 6.75% 2.10% 1.15% 4.08% 8.72% annual 3.06% Part c) Fill in the cells with a question mark in the following table. X indicates to ignore that cell Future Value Regular Present Value Term Interest RateCompounding Payment ($) ($) ($) (years) ? 10000 monthly 0 5% APR 10 ? 10000 daily 0 5% APR 10 15% effective annual 300000 annual 10 20% effective ? annual 300000 annual 30