How much do you need to deposit in bank today

Assignment Help Financial Management

Reference no: EM132024727

All compounding/discounting should be done using PV/FV functions in Excel.

1. You are planning to deposit $100,000 into a bank account and to leave the funds on deposit for 12 years. Bank A pays interest at a rate of 3%, compounded annually. Bank B pays interest at a rate of 2.5%, compounded semiannually. Bank C pays interest at a rate of 2.2% compounded daily.

If you put your money into Bank A, how much will you have in the account after the 12 years?

If you put your money into Bank B, how much will you have in the account after the 12 years?

If you put your money into Bank C, how much will you have in the account after the 12 years?

What factors contribute to the difference in the amounts in a, b and c? Explain.

2. You need to have $3,000 in order to make a down payment on a car in 3 years. In order to achieve that goal, how much do you need to deposit in a bank today if the bank pays 3% interest compounded semiannually?

Reference no: EM132024727

Questions Cloud

Find the schedule and cost variances for project : Find the schedule and cost variances for a project that has as actual cost at month 16 of $540,000, a scheduled cost of $523,000,

What is the centerline of an s chart : What is the centerline of an S chart if the sum of the 25 sample standard deviations is 50?

Discuss main factors affecting the cost of producing corn : Discuss the main factors affecting the cost of producing corn, technology employed, and productivity at the level of an individual farmer.

Relation to the other students in the distribution : Which student scored better with relation to the other students in the distribution?

How much do you need to deposit in bank today : how much do you need to deposit in a bank today if the bank pays 3% interest compounded semiannually?

What height represents the 95th ?percentile : In a survey of women in a certain country? (ages 20minus?29), the mean height was 66.4 inches with a standard deviation of 2.68 inches.

Dip donuts with rainbow sprinkles in a week : Let XX be the number of people that order vanilla dip donuts with rainbow sprinkles in a week.

Analyze specific business products and practices : Analyze specific business products and practices as they relate to eco-efficiency. Analyze specific business products and practices as they relate to product.

What are the cost and schedule variances : What are the Cost and Schedule variances? Calculate CPI, SPI, ETC & EAC. Interpret the results (what does it all mean).

User Account

All Pages