Explore BrainMass

Effective Annual Rates (APR resulting EAR)

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

2 parts- question

Create a table using Excel that shows for Annual Percentage Rates (APRs) for 15% to 1%, the corresponding rates per period (period rate = APR/ number of periods per year), and the resulting Effective Annual Rates. The Periods per year, Period Rates and EARs should automatically change when the length of the period is changed.

This should be accomplished using the two cells above the table shown below. The first one (manually entered) is the length of the period in months (period length). The second, below this, is the number of periods per year which should be calculated by dividing 12 by the period length. For instance if the period length is 2 months, the number of periods per year is calculated as 12/2=6. The equations inserted in the table cells should use this "periods per year" so that the table is updated automatically when the "periods per year" is changed.

Therefore, a manual change in the Period length in the box above the table should cause 1) the Periods per year, and 2) the other cells in the table to automatically changed for all of the APRs of 15% to 1%.

Part 2:

Create a second table using Excel that shows the Periods per Year, Period Rate and EAR for six period lengths (1,2,3,4,6,and 12 months). These should be dependent on an APR in the box at the top of the table. This format is shown below. A change in the APR in the box above the table should automatically change the values in the table.

Therefore, using the APR and equations, calculate the Periods per year (=12/Period length), Period Rate (using APR and Periods per year), and the EAR .

© BrainMass Inc. brainmass.com October 25, 2018, 6:21 am ad1c9bdddf


Solution Summary

An effective annual rate for APR resulting in EAR are given.

See Also This Related BrainMass Solution

Corporate Finance : Present and Future Values, Annuity Future Values, EAR vs APR, Amortization with Equal Payments, Break-Even EBIT and Leverage

The Problem is for a Corporate Finance Course. The author is Ross-Westerfield-Jordan: Essentials of Corporate Finance. Fourth Edition.

I have circled the questions that I need help answering. If you would, please show all work and or fomulas. (this is what always throws me off)

I need the following questions answered:
CH 4: 2, 3, 4, 6, 7
CH 5: 3, 4, 7, 19, 20, 24, 55
CH 13: 4, 6

Please see the attached file for the fully formatted problems.

Calculating interest 'Rates. Assume the total cost of a college education will be $300,000 when your child enters college in 18years. You presently have $40,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child's college education?

Calculating the Number of Periods. At 9 percent. interest, how long does it take to double your money? To quadruple it?

Future Value and Multiple Cash Flows. ? . Qffiçer, me., has identified an investment project with the following cash flows. If the discount rate is 8. pc$teflt,

Calculating Annuitty Present Value. An investment offers $6,000 per year for
15 years, with the first payment occurring 1 year from now. If the required return is
8 percent, what is the value of the investment? What would the value be if the
payments occurred for 40 years? For 75 years? Forever?
Calculating Annuity Values. If you deposit $2,000 at the end of each of the next 20 years into an account paying 7.5 percent ñterest how much money will y&i have in the account in 20 years? How much will you have if you make deposits for 40years?

EAR versus APR. RickyRipovs Pawn Shop chargesa.interest rate of 20 percent
per month on loans to its customers. Like all lenders, Ricky rnust report an APR to consumers. What rate should the shop report? What is the effective annual rate?

Calculating Loan Payments. You want to buy a new sports coupe for $52,350, and the finance office at the dealership has quoted you an 86 percent APR loan for 60 months to buy the car. What will your monthly payments be? What is the effective annual. rate on this loan?

Calculating Annuity Future Values, You are to make monthly deposits of $200 into a retirement account that pays 1.1 percent interest compounded monthly. If your first deposit will be made one month from now, how large will your retirement
Account be in 30 years?

Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $60,000. The interest rate is 11 percent per year, and the loan calls for equal annual payments. How much Interest is paid in the third year? How much total interest is paid over the life of the loan?

Break-Even EBIT. Duval Corporation is comparing two different capital structures, an all-equity plan (Plan I) and a levered plan Plan II). Under Plan I, Duval would have 600,000 sharesof stock outstanding; Under Plan 11,there would be 300,000 shares of stock outstanding and $10 million in debt outstanding. The interest rate on the debt is 10 percent, and there are taxes.
a. If EBIT is $1 .5 million, which plan will result in the higher EPS?
b. If EBIT is $11 million, which plan will result in the higher EPS?
c. What is the break-even EBIT?
Break-Even EBIT and Leverage. Hoobastank Co. is comparing two different capital structures. Plan I would result in.1.,000 shares of stock and $30,000 in debt. Plan II would result in 2,000 shares of stock and $15,000 in debt. The interest rate on the debt is 10 percent. .

View Full Posting Details