·
Using an Excel spreadsheet, complete
all portions of questions 1–3.
·
You need to create a new Excel file
for this assignment.
·
Use formulas to calculate each
question. You may use separate tabs for
each question.
·
Submit the Excel file when complete.
1. You have received $100,000 from your grandparents to be used for your graduate studies. You plan to start a program in 5 years. You can invest the money at 6% interest, compounded annually. How much will you have in 5 years?
2. Mobile Health needs to replace its mobile medical unit to continue providing diagnostic services and preventative medicine to city residents. The van costs $120,000, and a bank is willing to lend the nonprofit the money at a 6% interest rate for 5 years. Payments are due at the end of each month, and interest is compounded monthly. How much should you budget for the monthly payment?
3. The Department of Corrections (DOC) needs to replace two of its prison transport buses. There are two companies that have a track record of making reliable vehicles, and both make a bus that meets the needs of the department. The DOC pays an 8% interest rate on money it borrows. The bus from Company A has a purchase price of $105,000 and a 10-year service life expectancy, and it averages $2,000 per year in maintenance costs. The bus from Company B has a purchase price of $110,000 and a 10-year service life expectancy, and it averages $1,500 per year in maintenance costs. Which bus should the Department of Corrections select?