Asked Mar 2, 2019

I need a detailed explanation of solving this problem:

You have purchased a new warehouse. To finance the purchase, you obtained a 25-year mortgage for 75% of $3,000,000 purchase price. The monthly payment will be $17,100.

a) What is the APR?

b) What is the EAR


Expert Answer

Step 1

APR: It is abbreviated as Annual Percentage Rate, is a method for estimating the total cost a loan providers charges every year for the funds.

EAR: It is abbreviated as Effective Annual Rate is the interest cost that is balanced for compounding in a given period of time.

Step 2

a) Calculation of APR:

The APR can be calculated using a excel function =RATE, which denotes the interest rate of any investment. The need of using a excel function here is to get accurate final answers without any rounding error. In other words, for approximation the excel function is used here. The final answers are rounded to 2 decimal points. For example 11.5697% is rounded as 11.57%.

The amount of financing is $2,250,000 which is nothing but 75% of $3,000,000. Because 75% from the purchase price of $3,000,000 is financed under the mortgage. Hence, the periodic monthly payments are $17,100, and the number of years is 25 years. Since the mortgage is compounded monthly, the total number of periods of the mortgage is 300 months (which is nothing but 30 years * 12 months). The monthly payments of $17,100 are applied as “PMT”, the number of months of 300 is applied as “NPER” and the financing amount of $2,250,000 is applied as “PV”. There is no future value hence it is mentioned as 0. By using the excel function =RATE, the result obtained is 7.82% (0.65% per month). The excel spreadsheet is shown below:

Step 3

The excel workings for calculating APR is shown below...


Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in



Investment Management

Related Finance Q&A

Find answers to questions asked by student like you

Show more Q&A add

Q: Bill Clinton reportedly was paid $10 million to write his book My Life. Suppose the book took three ...

A: All financials below are in $ mn.Part (a)Speaking fees, F = 8 per year for N = 3 yearscost of capita...


Q: Please help do this calculation step by step I have problems getting the final answer.

A: Calculating the value of weighted-average cost of capital (WACC). We have,WACC = (Weight of Equity x...


Q: Assume​ Evco, Inc., has a current stock price of $39 and will pay a $1.80 dividend in one​ year; its...

A: Calculation of Expected Price:


Q: Fiduciary responsibilities are critical part of which relationship---customer or client? Why?

A: Fiduciary responsibility is the harmonious relationship of trust between a fiduciary agent and a cus...


Q: Roundtree Software is going public using an auction IPO. The firm has received the following bids: N...

A: First lets; understand what the winning auction offer price is. It is this price at and above which,...


Q: I already ask this but I whant know how you do the calculation, please could you show me all the ste...

A: Calculating the price of bond if interest rate on the bond is 10%. We have,Price of bond = C [1- (1 ...


Q: Bethesda Water has an issue of preferred stock outstanding with a coupon rate of 3.80 percent that s...

A: Calculation of cost of preferred stock:


Q: Below is part of the response you provided to a question I previously asked.  I was wondering if you...

A: Since yoiu have asked further explanation on cash flow at the time of expiration, I assume that you ...


Q: if you are 18 years old, deposit $5000 each year into a traditional IRA for 52 years, at 6% interest...

A: Annuity, A = $ 5,000Interest rate per year, R = 6%Period, N = 52 years