please answer all the questions and please do it fast

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 TVM, solve each of the problems Example A: You have $300,000 that you want to invest in a one year Certificate of Deposit (CD) with a 4% annual interest rate. What will be the value of that CD in a year? PV = $300,000.00 I/YR = 4% N = 1 Formula: FV = PV(1+1)^N = $312,000.00 Wizard (FV): $312,000.00 Excel Function: $312,000.00 Example B: What if the investment made above were held in a CD for 5 years, with the same principle and interest rate? PV = $300,000.00 I/YR = 4% N = 5 Formula: FV = PV(4+1)^N = $364,995.87 Wizard (FV): $364,995.87 Excel Function: $364,995.87 Example C: For this scenario, lets assume that CDs are being offered for 5 years at a rate of 3%, 4% and 5%. Using the table function of Excel, create a table that shows the FV at 3%, 4% and 5% for 0, 1, 2, 3, 4, and 5 years. How to use the table function in Excel: Set up the table below. For the dollar amount under the Column Years, use the Future value of your investment at the end of the time period. For this example, that is the amount calculated above for $300,000 at 4% for 5 years, Cell E25. Highlight the information for Cells B39 through E45. On the tool bar, click on data, What-lf Analysis, Data Table. In the dialog box, for Row input cell enter the time period or 1/Yrs. (D23 in this example). For Column input cell, enter the time period, N (cell D24 for this example). Years: $364,995.87 3% 0 $300,000.00 1 $309,000.00 2 $318,270.00 3 $327,818.10 4 $337,652.64 5 $347.782.22 Interest Rate 4% $300,000.00 $312,000.00 $324,480.00 $337,459.20 $350,957.57 $364,995.87 5% $300,000.00 $315,000.00 $330,750.00 $347,287.50 $364,651.88 $382,884.47 #1 - You plan to invest $100,000 in a 3 year Certificate of Deposit that has a 5% compound interest rate. What is its future value? PV = I/YR = N = FV = PV(1+1)^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= I/YR = N = PV = FV/(1+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 #1 Investment #2 Payment I/YR = N = FVA = PMT*[((1+i)^N-1))/i] 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 = 1 $250,000.00 I/YR = 6% N = 10 FV = PV(1+1)^N = Years: Interest Rate 6% 3% 7% 2 von AWNO 4 5 6 8 9 10 Interest Paid