Homework Help is Here – Start Your Trial Now!
Business
Finance
#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= IYR = N = PV = FVI(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 IYR = N = FVA = PMT (((1+i)^N-1))/i] %3D Portfolio Future Value Total:

#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= IYR = N = PV = FVI(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 IYR = N = FVA = PMT (((1+i)^N-1))/i] %3D Portfolio Future Value Total:

Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
See similar textbooks
icon
Related questions
Question
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 VYR = 4% N = 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 VYR = 4% N = 5 Formula: FV = PV(1+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-If Analysis, Data Table. In the dialog box, for Row input cell enter the time period or I/Yrs. (D23 in this example). For Column input cell, enter the time period, N (cell D24 for this example). Years: Interest Rate $364,995.87 4% 3% O $300,000.00 1 $309,000.00 5%| $300,000.00 $315,000.00 $330,750.00 $300,000.00 $312,000.00 2 $318,270.00 3 $327,818.10 4 $337,652.64 5 $347,782.22 $324,480.00 $337,459.20 $347,287.50 $364,651.88 $382,884.47 $350,957.57 $364,995.87 #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 = VYR = 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= VYR = N = PV = FV/(1+1)^N =
Transcribed Image Text: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 VYR = 4% N = 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 VYR = 4% N = 5 Formula: FV = PV(1+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-If Analysis, Data Table. In the dialog box, for Row input cell enter the time period or I/Yrs. (D23 in this example). For Column input cell, enter the time period, N (cell D24 for this example). Years: Interest Rate $364,995.87 4% 3% O $300,000.00 1 $309,000.00 5%| $300,000.00 $315,000.00 $330,750.00 $300,000.00 $312,000.00 2 $318,270.00 3 $327,818.10 4 $337,652.64 5 $347,782.22 $324,480.00 $337,459.20 $347,287.50 $364,651.88 $382,884.47 $350,957.57 $364,995.87 #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 = VYR = 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= VYR = N = PV = FV/(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 = $250,000.00 I/YR = 6% N = 10 FV = PV(1+1)^N = Years: Interest Rate 3% 6% 7% 1 3 6. 7 8 9 10 Interest Paid:
Transcribed Image Text:# 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 = $250,000.00 I/YR = 6% N = 10 FV = PV(1+1)^N = Years: Interest Rate 3% 6% 7% 1 3 6. 7 8 9 10 Interest Paid:
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Effective Annual Rate Of Return
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS