Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Submit to the Dropbox on or before me que date. 1. Create a table in excel that shows the FV at 0%, 5%, and 20%

image text in transcribed
image text in transcribed
Submit to the Dropbox on or before me que date. 1. Create a table in excel that shows the FV at 0%, 5%, and 20% for 0, 1, 2, 3, 4 and 5 years assuming an initial investment of $1000. Sample layout: Years Interest Rate 0% o $1,000.00 $1,000.00 20% $1,000.00 2. Using the table you created in (1), now create a graph with years on the horizontal axis and FV on the vertical axis. Label axes and other relevant chart items. Sample layout: FUTURE VALOR S FUNCTION OF TIME AND R $3.000 DO $2.500 DO $2.000.00 3. Create a table that shows how payments are divided between interest and principal repayment over time. Assume a loan of $15,000, term to maturity 4 years, annual end of year payments and interest rate of 8%. Set up an amortization schedule that shows the annual payments, interest payment portion, principal payment portion and ending balances. Sample layout lley 4. Using the data in (3), create a graph that shows how payments are divided between interest and principal over time. Sample layout Breakdown of payments

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

The Evolution Of Finance

Authors: Barbara Guth

1st Edition

1633377261, 978-1633377264

More Books

Students also viewed these Finance questions

Question

What is a buy-back of corporate shares?

Answered: 1 week ago

Question

1. List your top 10 film heroes.

Answered: 1 week ago

Question

Draw a schematic diagram of I.C. engines and name the parts.

Answered: 1 week ago

Question

4. How has e-commerce affected business-to-business transactions?

Answered: 1 week ago