Answered step by step
Verified Expert Solution
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%
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
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