Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer the following problems in an Excel file. Please upload only one Excel file with all of your answers, including #3 (which requires an explanation

Answer the following problems in an Excel file. Please upload only one Excel file with all of your answers, including #3 (which requires an explanation rather than a calculation). All problems must be solved using the PV and FV functions in Excel.

  1. If I deposit $8,000 in a bank account that pays interest of 1.5%, compounded annually, how much will I have in the account after 10 years?

  1. If I deposit $8,000 in a bank account that pays simple interest of 1.5%, how much will I have in the account after 10 years?

  1. How would you explain the difference in the answers to the foregoing two problems, given that both banks pay interest at the same rate? Be specific.

  1. You graduate from college and obtain a job paying an annual salary of $35,000. You estimate that you will receive a 10% salary increase each year. If you receive those salary increases, how much will you be earning after 4 years?

  1. You deposit $5,000 in a bank account today that pays 2% interest, compound annually. You make no withdrawals from the account until 4 years have passed and then you withdraw all of the money that has accumulated in that account and deposit it into another bank that pays 3% interest compounded annually. You leave your money in the second bank for an additional 3 years. How much money will you have after the 7 years?

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_2

Step: 3

blur-text-image_3

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

A Treatise On The Law Pertaining To Corporate Finance

Authors: William A. Reid

1st Edition

111793568X, 9781117935683

More Books

Students also viewed these Finance questions

Question

How would you rate your leaders against these criteria?

Answered: 1 week ago

Question

1 . Television News channels importantance of our Life pattern ?

Answered: 1 week ago