{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Assignment 4-Data Tables

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

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

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

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

View Full Document

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}