Finance calculations using excel

Reference no: EM1329506

1. You want to buy a car, and a local bank will lend you $ 20,000. The loan would be fully amortized over 5 years ( 60 months), and the nominal interest rate would be 12%, with interest paid monthly. What is the monthly loan payment? What is the loan's EFF%?

2. Your parents will retire in 15 years. They currently have $ 230,000, and they think they will need $ 1 million at retirement. What annual interest rate must they earn to reach their goal, assuming they don't save any additional funds?

3. If you deposit $ 12,000 in a bank account that pays 8% interest annually, how much will be in your account after 5 years?

4. What is the present value of a security that will pay $ 85,000 in 20 years if securities of equal risk pay 4% annually?

5. Assume that 1 year from now you plan to deposit $ 1,000 in a savings account that pays a nominal rate of 8%.

a. If the bank compounds interest annually, how much will you have in your account 4 years from now?

b. What would your balance be 4 years from now if the bank used quarterly com-pounding rather than annual compounding?

c. Suppose you deposited the $ 1,000 in 4 payments of $ 250 each at the end of Years 1, 2, 3, and 4. How much would you have in your account at the end of Year 4, based on 8% annual compounding?

d. Suppose you deposited 4 equal payments in your account at the end of Years 1, 2, 3, and 4. Assuming an 8% interest rate, how large would each of your pay-ments have to be for you to obtain the same ending balance as you calculated in part a?

Reference no: EM1329506

Questions Cloud

A researcher was interested in the emotional : A researcher was interested in the emotional effects of music on exam performance. Before their exam, a professor took one group of students into a room in which calming music was played.

Computing periodic amounts : Find out the amount of the specific payment needed to pay off the following purchases. Payments are made at the end of the period.

A contry currency depreciate if its inflation rate is less : A contry's currency will depreciate if its inflation rate is less than that of its trading partners.

Create an application that declares objects of each kind : make a Building class and two subclasses, House, and School. The Building class contains fields for square footage and stories. The House class contains additional fields for number of bedrooms and baths.

Finance calculations using excel : What is the present value of the security which will pay $ 85,000 in 20 years if securities of equal risk pay 4% annually?

A procedure which allows us to predict an individual''s score : A procedure which allows us to predict an individual's score on one variable based on knowing one or more other variables.

Central government with large power : Why were the formers of the Constitution concerned about the central government having to much power? How did they address that issue?

Importance of self-awareness and emotional intelligence : Explain the importance of self-awareness and emotional intelligence and the role they play in enabling you as a leader to model the capacities of characteristics of servant leadership.

Explain newly industrialized countries product marketing : Explain Newly Industrialized Countries Product Marketing and what effect might the economic and socioeconomic forces within that country have on the product's potential

User Account

All Pages