please answer the questions in excel spreadsheet and answer clearly, last time few answers are wrong. please check tge question twuce and answer carefully

Global Financial Management Rivier University Module 2 Problem Set TVM Directions. Using the financial functions of Excel, the Excel wizard and or the formulas for Tsolve each of the problems Example A. You have $300.000 that you want to invest in a one year Certificate of Depok with annual interest rate. What will be the value of that CD in a year? PV - $300,000.00 WYR N- 1 Formula PVPV[Tel N 5312,000.00 Wizard (FV): $312.000.00 Excel Function $312.000.00 Example 8: What if the investment made above were held in a CD for years, with the same principle and interest rate? PV - $300,000.00 IYR 4 NE FV-PV/1-l'N- Formula: Wizard (FVC Excel Function: $36.995.BY 5364.995.87 5364.995.87 Example C: For this scenario, lets assume that CDs are being offered for 5 years at a rate of and 5%. Using the table function of Excel.create a table that shows the Fats and stor 2.1.2.14 and 5 years How to use the table function in Excel: Set up the table below. For the solar amount under the Column Yours use the Future value of your investment at the end of the time period. For this example is the amount coated above for $300,000 a 4% for 5 years, Coll E25 Highlight the information for Cells 839 rough 545. On the toolbar, click on data, What It Analysis Data Table in the dialog box for Row input conter the time period or VYrs. (023 in this example For Column inpul collenter the time period. Nel 24 for this ample) Interest Rate Years 3364,995.87 31 0 $300,000.00 1 $309,000.00 2 $318,270.00 3 $327.818.10 4 $337,652.64 5 $347.782.22 3300,000.00 $312.000.00 $324,480.00 $33T 459 20 $350,957.57 $364.995.87 5% 5300.000,00 $315.000.00 $330,750.00 $347.287 50 $364, 651.88 $382.854.47 #1 - You plan to invest $100,000 in a 3 year Certificate of Deposit that has a 5compound interest rate What is its future value? PV WYR - N. FV=PV/4+IN 02 - You expect to receive a payment of $1 million in a year. That interest rate is 9%. What is the present value of the future payment? FV LYR NE PV-FV1+) N #2 - You expect to receive a payment of $1 million in a year. That annual interest rate is 5%. What is the present value of the future payment? FV- WYR = N= PV = FVI(1+N #3 - You purchase two annuities. The first is for three years and pays $1500 annually. The second is for four years and pays $2000 annually. The interest rate for both is 4%. What is the Future Value of this portfolio? Investment 81 Investment 2 Payment I/YR - N= FVA - PMT"[4/1*0)%N-1))) Portfolio Future Value Total: #4 - Pencil Corp is looking to issue a bond to raise capital for expanding their product line to include mechanical pencils. The company needs to raise $250,000 which will be paid back over a 10 year time frame. Bond rates can be issued at 3%, 6% or 7%, with a higher assurance of investors with the higher rate. If a high enough rate is not offered, Pencil Corp runs the risk of not raising the necessary capital However, the CFO does not want to spend more in bond interest than necessary, and wants repayment amounts to fit within budget for the expansion project. Create an amortization table for the expense. How much would be paid in interest for each interest rate scenario? What rate would you choose and why? (Hint: Determine future value first) PV. I/YR N = FV = PV(1+1)AN $250,000.00 6% 10 Years: Interest Rate 6% 3% 7% 0 1 2 3 4 5 6 7 8 10 Interest Paid: Global Financial Management Rivier University Module 2 Problem Set TVM Directions. Using the financial functions of Excel, the Excel wizard and or the formulas for Tsolve each of the problems Example A. You have $300.000 that you want to invest in a one year Certificate of Depok with annual interest rate. What will be the value of that CD in a year? PV - $300,000.00 WYR N- 1 Formula PVPV[Tel N 5312,000.00 Wizard (FV): $312.000.00 Excel Function $312.000.00 Example 8: What if the investment made above were held in a CD for years, with the same principle and interest rate? PV - $300,000.00 IYR 4 NE FV-PV/1-l'N- Formula: Wizard (FVC Excel Function: $36.995.BY 5364.995.87 5364.995.87 Example C: For this scenario, lets assume that CDs are being offered for 5 years at a rate of and 5%. Using the table function of Excel.create a table that shows the Fats and stor 2.1.2.14 and 5 years How to use the table function in Excel: Set up the table below. For the solar amount under the Column Yours use the Future value of your investment at the end of the time period. For this example is the amount coated above for $300,000 a 4% for 5 years, Coll E25 Highlight the information for Cells 839 rough 545. On the toolbar, click on data, What It Analysis Data Table in the dialog box for Row input conter the time period or VYrs. (023 in this example For Column inpul collenter the time period. Nel 24 for this ample) Interest Rate Years 3364,995.87 31 0 $300,000.00 1 $309,000.00 2 $318,270.00 3 $327.818.10 4 $337,652.64 5 $347.782.22 3300,000.00 $312.000.00 $324,480.00 $33T 459 20 $350,957.57 $364.995.87 5% 5300.000,00 $315.000.00 $330,750.00 $347.287 50 $364, 651.88 $382.854.47 #1 - You plan to invest $100,000 in a 3 year Certificate of Deposit that has a 5compound interest rate What is its future value? PV WYR - N. FV=PV/4+IN 02 - You expect to receive a payment of $1 million in a year. That interest rate is 9%. What is the present value of the future payment? FV LYR NE PV-FV1+) N #2 - You expect to receive a payment of $1 million in a year. That annual interest rate is 5%. What is the present value of the future payment? FV- WYR = N= PV = FVI(1+N #3 - You purchase two annuities. The first is for three years and pays $1500 annually. The second is for four years and pays $2000 annually. The interest rate for both is 4%. What is the Future Value of this portfolio? Investment 81 Investment 2 Payment I/YR - N= FVA - PMT"[4/1*0)%N-1))) Portfolio Future Value Total: #4 - Pencil Corp is looking to issue a bond to raise capital for expanding their product line to include mechanical pencils. The company needs to raise $250,000 which will be paid back over a 10 year time frame. Bond rates can be issued at 3%, 6% or 7%, with a higher assurance of investors with the higher rate. If a high enough rate is not offered, Pencil Corp runs the risk of not raising the necessary capital However, the CFO does not want to spend more in bond interest than necessary, and wants repayment amounts to fit within budget for the expansion project. Create an amortization table for the expense. How much would be paid in interest for each interest rate scenario? What rate would you choose and why? (Hint: Determine future value first) PV. I/YR N = FV = PV(1+1)AN $250,000.00 6% 10 Years: Interest Rate 6% 3% 7% 0 1 2 3 4 5 6 7 8 10 Interest Paid