Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have just purchased a new warehouse. To finance the purchase, you ve arranged for a 3 2 - year mortgage loan for 8 0

You have just purchased a new warehouse. To finance the purchase, youve arranged for a 32-year mortgage loan for 80 percent of the $3,320,000 purchase price. The monthly payment on this loan will be $16,500. Hint: Please remember the Excel formula which is=RATE(nper,-pmt,-pv,fv,1); however, for this question we must adjust this formula. You know that your payments are cash outflows (negative), but you have to determinewhether that loan is a cash inflow (positive) or outflow (negative) and whether it is a FV or PV. Also, you need to adjust this formula for whether the payment is at the beginning (1) or end (0) of the period.
What is the APR on this loan?
Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g.,32.16.
What is the EAR on this loan?
Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g.,32.16.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations of Financial Management

Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen

15th edition

77861612, 1259194078, 978-0077861612, 978-1259194078

More Books

Students also viewed these Finance questions