Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using Excel, answer the following questions. You should submit 1 excel sheet. Place each question on its own tab. Calculate the present value of $100
Using Excel, answer the following questions. You should submit 1 excel sheet. Place each question on its own tab.
- Calculate the present value of $100 that you will receive 3 years from now. Produce answers for discount rates which range from 0% - 30% in 2% increments. Graph the present value (y) vs discount rate (x) for all discount rates.
- Your parents began saving money for college on your 10th birthday. They make deposits of $4,000 every year, with the final deposit being on your 17th birthday. For four years, starting on your 18th birthday, they will withdraw $20,000 for tuition. If they earn 8%, will you have enough to cover all four years of tuition? Detail the balance for each year.
- You are 30 years old today and are considering an MBA. You have just received your annual salary of $50,000 and expect it to grow by 3% per year. If you get an MBA, your salary is estimated to start at $80,000 per year and grow by 4%. The MBA program is a 2 year program at a cost of $30,000 per year (youll need to quit your job to enter the program). If the interest rate is 8%, and you plan to retire at 65, is the MBA worth it? Detail the cash flows for each year, in both scenarios.
(Assume all future cash flows come at the end of their respective years)
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