Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show the formulas for excel You have just received a windfal from an investment you made in a friend's business. He will be paying
Please show the formulas for excel
You have just received a windfal from an investment you made in a friend's business. He will be paying you S10,000 at the end of this year, S20,000 at the end of the following year, and $30,000 at the end of the year after that (three years from today. The interest rate is 3.5% per year. a. What is the present value of your windfall? b. What is the future value of your windfall in three years (on the date of the last payment)? Interest rate 3.50% Year Cash flow $10,000 $20,000 S30,000 a. What is the present value of your windfall? Present value b. What is the future value of your windfall in three years (on the date of the last payment)? Future value ements . Stat Excel - completed. 2. of cash flows (1 pt.). 3. value found on cell D15 (1 pt.). In cell D15, by using the function NPV and cell references, calculate the present value of the stream In cell D19, by using the function FV and cell reference, calculate the future value of the present Note: The output of the function in cell D19 is expected as a positive value. Use cell reference to theStep 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