Question: NEED TO KNOW HOW TO DO THEM IN EXCEL PLEASE 1. A loan is offered with monthly payments and a 13 percent APR. What's the

NEED TO KNOW HOW TO DO THEM IN EXCEL PLEASE 1.

NEED TO KNOW HOW TO DO THEM IN EXCEL PLEASE

1. A loan is offered with monthly payments and a 13 percent APR. What's the loan's effective annual rate (EAR)? 2. A perpetuity pays $50 per year and interest rates are 9 percent. How much would its value change if interest rates decreased to 7.5 percent? Did the value increase or decrease? 3. If the present value of an ordinary, 6-year annuity is $8,500 and interest rates are 9.5 percent, what's the present value of the same annuity due? 4. If the future value of an ordinary, 7 -year annuity is $6,500 and interest rates are 8.5 percent, what is the future value of the same annuity due? 5. If you start making $75 monthly contributions today and continue them for four years, what is their future value if the compounding rate is 12 percent APR? What is the present value of this annuity? 6. Create the amortization schedule for a loan of $15,000, paid monthly over three years using a 9 percent APR

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Alpha Classic Car Restorations John Wallace is an automotive... Alpha Classic Car Restorations John Wallace is an automotive enthusiast. He has over 25 years of experience as a mechanic for the...

Question 2 Not yet saved Marked out of 1.00 VFlag question You invested $5,000 in a savings deposit 6 quarters ago and it has grown to $5964 today. What nominal rate of annual interest (compounding...

You are a student majoring in Business Administration at BHSU and are currently enrolled in the Business Finance course for the fall semester of 2 0 2 4 . Unfortunately, your car recently broke down,...

Alpha Classic Car Restorations John Wallace is an automotive enthusiast. He has over 25 years of experience as a mechanic for the dealership of a large car manufacturer in Oakville. John also gained...

1). The difference between an ordinary annuity and an annuity due is the: number of annuity payments. timing of the annuity payments. frequency of the annuity payments. amount of each annuity...

Match each of the definitions in #1-3 with one of the following rates: Effective Annual Rate (EAR) Annual Percentage Rate (APR) Stated Interest Rate The most important interest rate to use when...

Which of the following statement is INCORRECT, assuming positive interest rates and holding other things constant? An investment that has an annual percentage rate ( APR ) of 6 percent, compounded...

Match each of the definitions in #1-3 with one of the following rates: Effective Annual Rate (EAR) Annual Percentage Rate (APR) Stated Interest Rate 1. The most important interest rate to use when...

You want to buy a new sports coupe for $80,000, and the finance office at the dealership has quoted you a loan with an APR of 7.0 percent for 30 months to buy the car. 1. (5 points) What will your...

As a loan officer for FIFO, Alan's job is to sell loans that generate revenues for the company. Alan has been charged with increasing the total amount of mortgages sold by FIFO. One of the loans FIFO...

A statistics professor wanted to find out the average GPA (grade point average) for all students at her university. She used all students enrolled in her statistics class as a sample and collected...

When the market settles at its equilibrium, all the funded projects must have a rate of return that is _ _ _ _ _ _ . Group of answer choices equal to 6 % at most 6 % at least 8 % at least 6 %

Which project management tool uses the analogy "skateboard - bicycle - motorcycle - car"? Group of answer choices Scrum Waterfall Fate - Gate Star - gate

Suggest changes to an organizations culture and its implementation in an uncertain and turbulent environment.

What role could the HRM department play to help La Vie en Rose become more eco-responsible?

Imagine that La Vie en Rose decides to implement multi-skilled teams. What impact would this decision have on recruiting new employees and training and compensating the workers in these teams?