{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Assignment 4-Data Tables

Assignment 4-Data Tables - Assignment#4 Data Tables and...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment #4: Data Tables and Charts Part 1 Instructions: Investment Data Table 1. Construct a data table for the following problem: Part 2 Instructions: Loan Payment Data Table 1. Construct a data table for the following problem: Ms. Mable has $100,000 to invest for retirement. She needs to know what the future value of her investment will be over the years at various interest rates. The years she is interested in evaluating are 5, 10, 15, 20, and 25. What are the different investment values if the rates for consideration are 4%, 8%, 12%, and 15%. No additional payments are to be made to the account . Please position the interest rates across the top row and the years down the side column. Robert has plans to purchase a new vehicle. He must borrow the money to pay for the vehicle, since the family funds are tied up in investments. The vehicle costs $38,000 fully loaded and taxed. The months he is evaluating are 24, 30, 36, 42, 48, 60, and 72. What are his monthly payment options if the annual interest rates vary from 5%, 10%, 15%, and 21%? Please place the interest rates across the top row of the data table and the months down the column. Show the payments as a positive number. Hint: Use the absolute value function for the payments to make loan payments positive "=ABS(PMT(data,data,data,etc))" or you can enter the PV as a
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}