Business
Engineering
Math
Science
Social ScienceYou borrowed $700 at 5% compounded quarterly. Yourpayments are $150 at the end of each year. How many years will you make payments on the loan?(Hint: compounding frequency is different from payment frequency; we know that r and t should be matched; compounding effect? Effective interest rate?)
You borrowed $700 at 5% compounded quarterly. Your
payments are $150 at the end of each year. How many years will you make payments on the loan?
(Hint: compounding frequency is different from payment frequency; we know that r and t should be matched; compounding effect? Effective interest rate?)
Expert Answer
We will adopt the following approach:
- It's a typical time value of money case, where we have to find nper i.e. net period the loan will remain outstanding under annual payment.
- However, there is one small catch. he payment frequency is annual. Hence the period here is 1 year. However the interest is getting compounded quarterly. Henece, we need to calculate the interest rate per period i.e. interest rate per annuam i.e. the effective annual rate (EAR).
- EAR will match the interest rate and the frequency of payment to annual basis
- After that we will use the NPER function of excel to get the number of years the loan will remain outstanding.
Inputs of NPER function:
PV of loan = - Borrwed amount = - $ 700
Rate = EAR = (1 + 5% / 4)4 - 1 = 5.09%
PMT = Payment per period = $ 150
FV = Future value = 0
Please see the table on the white board for calculation of total period of loan using NPER function of excel.The last row highlighted in yel...
Image Transcriptionclose
V 157 Inputs 5.09% 158 Rate 150 700 159 PMT 160 PV 161 FV 0 162 Period 5.46 163 Formula Used =NPER(W158,W159,W160,W161) 164
Business
Finance
Related Finance Q&A
Q: Modern Artifacts can produce keepsakes that will be sold for $60 each. Nondepreciation fixed costs a...
A: Your answers to part (a), (b) and (c) are correct. Hence, I am not solving them again. Further you h...
Q: Until August 1971, industrialized countries around the world maintained a fixed exchange rate of the...
A: Answer 1:The correct answer is “Forward exchange rate”.Justification: A forward exchange rate is wh...
Q: A bank's loan rate for a machine is 9%. Determine the effective rate on the basis of the compounding...
A: The effective interest rate or the effective annual rate (EAR) is the actual rate paid or earned on ...
Q: You are considering a project with an initial cost of $7,800. What is the payback period for this pr...
A: Calculation of Payback Period:Using Excel Spreadsheet:
Q: R.S. Green has 250,000 shares of common stock outstanding at a market price of $28 a share. Next yea...
A: Cost of Equity:Cost of equity is the amount or rate which a company bears for the issue of share. In...
Q: A firm has the following total avenue and total cost schedules TR=$2Q TC=$4,000 +$1.5Q a. what is th...
A: TR=$2QTC=$4,000 +$1.5Qa. what is the break- even level of output? what is the level of profit at sal...
Q: An individual wishes to borrow $10,000 for a year and is offered the following alternatives: a. A 10...
A: Calculating the effective interest rate on borrowing option 10% loan discounted in advances. We have...
Q: Case Study #3: Chapter 6 Business Analysis A business can be valued by capitalizing its earnings st...
A: A business can be valued by capitalizing its earnings stream. In fact, the valuation of any asset or...
Q: Could you please give me a brief overview of what "cash flow for ROR analysis" is? Thanks.
A: ROR analysis is a short form for Rate of Return Analysis.Under ROR analysis, we need to find that Ra...
