TVM formulas-What is the interest rate on John loan

Assignment Help Financial Management

Reference no: EM131875214

This assignment in Excel using TVM formulas.

A. John just bought a $30,000 car. He put $5,000 down and financed the rest. He got a 5 year loan and his payments are $550 at the end of each month. What is the interest rate on John's loan?

B. Leticia wants to know how much her tuition will be next year if the inflation rate for tuition is 8% and it tuition currently costs $14,000. What would we estimate Leticia's tuition would cost next year?

C. Leticia wants to know how much she will have to put away in the bank today to have enough money to pay her tuition next year. How much would she need to set aside if her bank would pay her 1.2% interest on her money?

D. What would Leticia's tuition cost in 2 years?

E. Barry inherited $40,000 from an Uncle recently. He wants to invest it for his retirement. He estimates he could earn about 7% on his money after fees. He wants to keep the money invested for at least 30 years. What amount will his money grow to in 30 years?

F. What if Barry could reduces his fees by 1% how much would he earn over 30 years then?

Reference no: EM131875214

Questions Cloud

Firm aftertax cash outflows for first year for each bond : How many of the coupon bonds would you need to issue to raise the $45 million? Calculate the firm’s aftertax cash outflows for the first year for each bond.

The return on the return on the firm bonds : Stockholders require a risk premium of 5 percent above the return on the return on the firm's bonds.

What is the estimate of DEFs expected return : Using the historical approach, what is the estimate of DEF’s expected return.

Estimated value per share of your firm stock : If the last dividend paid was $3.40, what is the estimated value per share of your firm’s stock?

TVM formulas-What is the interest rate on John loan : John just bought a $30,000 car. He put $5,000 down and financed the rest. What is the interest rate on John's loan? What would Leticia's tuition cost in 2 years

Calculate that your dollar-weighted rate of return for year : Calculate that your dollar-weighted rate of return for the year was 30.6 percent. What was your time-weighted rate of return for the year?

Default risk premium on the corporate bond in percent : what is the default risk premium on the corporate bond in percent?

What is your value for the current share price now : Most corporations pay quarterly dividends on their common stock rather than annual dividends. What is your value for the current share price now?

Creighton had not made payment to the customer : Creighton settled a lawsuit and agreed to pay $78,000 to a customer for faulty goods. As of year-end, Creighton had not made payment to the customer.

User Account

All Pages