Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Had to be put into excel Part 1: Present Value verse Future Value Show your work for partial credit. 1. Calculate the Future Value of
Had to be put into excel
Part 1: Present Value verse Future Value Show your work for partial credit. 1. Calculate the Future Value of $1,000 in 10 years with a 1% interest rate compounded yearly. (3 points) 2. Calculate the Present Value of $1,000 in 5 years with a 5% discount rate compounded yearly. (3 points) Part 2: Investment Analysis For Part 2, open the "Chapter 17 Assignment Excel Template". Use the given Net Cash Revenues for each of the $500,000 investments (there is no Terminal Value) to find the following: 1. Find the Gross Revenue, Net Revenue and Average Net Revenue for each investment using the Net Cash flows given on the on the Chapter 17 Assignment Excel Template (9 points) 2. Find the Simple Rate of Return (SRR) for each investment. (6 points) 3. Find the Payback Period for each investment. (6 points) 4. Find the Net Present Value (NPV) for each investment using a 6% discount rate. You will need to create a discounted cashflow for each investment. (15 points) 5. Find the Internal Rate of Return (IRR) for each investment using the function available in Excel. (6 points) 1 Answer the following questions: 6. Rank the best investment using: (4 points) 2. Simple Rate of Return b. Payback Period c. Net Present Value d. Internal Rate of Retum 7. What does the value calculated for NPV mean? How should we interpret it? (4 points) 8. What does the value calculated for IRR mean? How should we interpret it? (4 points) A help video will be released towards the end of the week, but if you have questions before that please let me know. 60 Points AGEC 271 Chapter 17 Assignment Excel Template Due 10/31/2021 Part 1 1. Calculate the Future Value of $1,000 in 10 years with a 1% interest rate compounded yearly. (3 points) 2. Calculate the Present Value of $1,000 in 5 years with a 5% discount rate compounded yearly. (3 points Part 2 & 3 Inititial Investment Year Initial Investment (0) $ A $ 1 $ 2 s 31 $ 4 $ 5 $ 500,000.00 B (500,000) 120,000 $ 120,000 S 120,000 $ 120,000 S 120,000 $ (500,000) $ 50,000 $ 75,000 $ 100,000 $ 125,000 $ 250,000 $ (500,000) 150,000 100,000 100,000 100,000 150,000 1. Gross Revenue (S) 1. Net Revenue ($) 1. Average Net Revenue(S/Year) 2. Simple Rate of Return (%) 3. Payback Period (years) S Inititial Investment Discount Rate (%) 500,000.00 6% Year 0 1 2 3 4 5 $ $ $ $ $ S A (500,000 $ 120,000 120,000 $ 120,000 120,000 120,000 s B (500,000 $ 50,000 $ 75,000 $ 100,000 $ 125,000 $ 250,000 $ (500,000) 150,000 100,000 100,000 100,000 150,000 5. IRR Years 4. NPV Initial Investment Investment A B c Rank 1 2 3 Question 6 . b Simple Rate of Return Payback Period Net Present Value Internal Rate of Retum d Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started