Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show equations used in excel. Look at second photo for excel directions. Part 2: Today's Value Construct a table and a graph showing the

Please show equations used in excel. Look at second photo for excel directions.
image text in transcribed
image text in transcribed
Part 2: Today's Value Construct a table and a graph showing the relationship between interest rates, time, and present value by showing how $10,000 pushed a year further into the future over a 25-year period would be discounted at different interest rates. Use $10,000 for your future value and calculate the present value of this $10,000 each year over the 25-year period at 0%, 2%, 4%, 6%, 8%, 10%, 15%, and 20% compounded annually. Present Value should be the y-axis for your graph and years (or time) should be your X-axis and you should end up with a line for each interest rate on your graph. Please insert your graph (chart) under your table of present values. General Excel Guidelines for Fin 221 Group Excel Projects These guidelines will keep your TA in a good mood when grading your group projects. General Instructions: DO: Use Excel cell formulas, either algebraic or time value of money excel functions, to compute and show your any work or calculations that you do. This is how you show your work to receive credit. DO: Work down a worksheet page instead of across the page, avoid having to scroll across the page to see the work you are presenting. Imagine how your page would look if you printed it out, move your information down if the information would be more than one page wide. Multiple worksheets (tabs) within your workbook (Excel file) are fine, and your TA won't mind scrolling down pages. DON'T: Do the computations on a calculator and simply type them into your spreadsheet. DON'T: Create cell formulas where you simply type in numbers that are already contained in other cells in your workbook. Reference these cells in your workbook and use them to do the calculation. This actually will save you time and effort and is helpful when you have to do repetitive calculations

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

Step: 3

blur-text-image

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

Money, Banking, Financial Markets & Institutions

Authors: Michael Brandl

2nd Edition

1337904821, 9781337904827

More Books

Students also viewed these Finance questions

Question

13.6 Explain how to set up aflexible benefits program.

Answered: 1 week ago

Question

13.2 Describe five government-mandated benefits.

Answered: 1 week ago