Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Intro It is the end of 2022. You plan to complete a Ph.D. in 5 years. Your favorite uncle has promised to help you with

image text in transcribedimage text in transcribed

Intro It is the end of 2022. You plan to complete a Ph.D. in 5 years. Your favorite uncle has promised to help you with your school expenses by giving you the following amounts for Christmas: Year 2023 2024 2025 2026 2027 Cash flow 1,100 1,600 1,800 2,000 2,200 Your uncle is fairly wealthy and very reliable. You currently have $10,000 in a savings account paying an annual interest rate of 8%. Part 1 IB Attempt 1/10 for 10 pts. Create an Excel spreadsheet showing the years and cash flows as in the table above, then add a row that shows the number of years from now and another row that shows the present value of each cash flow. What is the sum of present values? Hint: do not hardcode the discount rate into your formulas. Instead, keep it in a separate cell and refer back to it. You'll be asked to change in discount rate in parts 4 to 7. 6787 Correct It is considered best practice to keep the discount rate in a separate cell (B1 in this example), so that it is easy to see and easy to change. B D E F 1 Disc. rate 0.08 2 3 Year 2023 2024 2025 2026 2027 Sum 4 From now 1 2 3 4 5 5 Cash flow 1,100 1,600 1,800 2,000 2,200 6 PV2022 1,018.52 1,371.74 1,428.9 1,470.06 1,497.286,787 14A Part 4 IB Attempt 1/10 for 10 pts. Now assume that the interest rate is 6%. What is the present value of all the gifts? 0+ decimals e Submit BrAttempt 1/10 for 10 pts. Part 5 Still assume that the interest rate is 6%. What is the future value of all the gifts? 0+ decimals Submit Part 6 IB Attempt 1/10 for 10 pts. Now assume that the interest rate is 12%. What is the present value of all the gifts? 0+ decimals Submit Part 7 18 Attempt 1/10 for 10 pts. Still assume that the interest rate is 12%. What is the future value of all the gifts? 0+ decimals

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Capitalism And Commerce Conceptual Foundations Of Free Enterprise

Authors: Edward W. Younkins

1st Edition

0739103814, 0739152807, 9780739152805

More Books

Students also viewed these Finance questions

Question

(a) Determine the firms revenue function.

Answered: 1 week ago