This is from the Excel document.

These are the questions, it's just one problem (all of them are part of the same problem).

Please show the process of how you got the answers for the numbers. Thank you!

Choose the correct graph of future value as a function of time and rate. Note: blue line is for 0%, orange line is for 4%, and grey line is for 25%. The correct graph is c. Find the PV of $1,000 due in 4 years if the discount rate is 12%. Round your answer to the nearest cent. $ d. A security has a cost of $1,000 and will return $2,000 after 4 years. What rate of return does the security provide? Round your answer to two decimal places. % nearest whole number. years PV of ordinary annuity: \$ FV of ordinary annuity: \$ g. How will the PV and FV of the annuity in part f change if it is an annuity due rather than an ordinary annuity? Round your answers to the nearest cent. PV of annuity due: \$ FV of annuity due: \$ FV with semiannual compounding: \$ PV with semiannual compounding: \$ Annual payment for ordinary annuity: $ Annual payment for annuity due: $ j. Find the PV and the FV of an investment that makes the following end-of-year payments. The interest rate is 11%. Round your answers to the nearest cent. PV of investment: $ FV of investment: \$ decimal places. A. B. 2) Calculating the nominal rates that will cause all of the banks to provide the same effective annual rate as Bank A C. D. h. Recalculating the PV and the FV for parts a and c if the interest rate is semiannually compounded Future value (FV) Present value (PV) i. Finding the annual payments for an ordinary annuity and an annuity due Present value (PV) Discount rate (I) Number of years (N) Annual payment for ordinary annuity (PMT1) Annual payment for annuity due (PMT2) j. Finding the PV and the FV of an investment that makes the following end-of-year payments \begin{tabular}{|c|c|} \hline Year & Payment \\ \hline 1 & $100 \\ \hline 2 & $200 \\ \hline 3 & $300 \\ \hline \end{tabular} Interest rate (I) Present value of investment (PV) Future value of investment (FV) k. Five banks offer the same nominal rate on deposits, but A pays interest annually, B pays semiannually, C pays quarterly, D pays monthly, and E pays daily. (1) Calculating the effective annual rate for each bank and the future values of the deposit at the end of 1 year and 2 years Nominal rate (INOM) Deposit (PV) Number of days per year $1,000 11% \#N/D \#N/D 11% \#N/D \#N/D EAR FV after 1 year FV after 2 years \begin{tabular}{|l|l|} \hline & \\ \hline & \\ \hline Formulas & A \\ \hline EAR & \#N/D \\ \hline FV after 1 year & \#N/D \\ \hline FV after 2 years & \#N/D \\ \hline \end{tabular} A. Repayment of Principal (\$) Interest (\$) C. B. Repayment of Principal (\$) Interest (\$) D