Question

In: Finance

7.        Calculate the annual purchasing power over the term of a 5-year loan of provided...

7.        Calculate the annual purchasing power over the term of a 5-year loan of provided to Shane Kavanagh, a 37-year old bricklayer. The interest-only loan of $80,000 requiring annual repayments in arrears was made by the Beneficial Finance Agency on a variable interest rate basis. The variable interest rate over the loan term was as follows:

            Details             Year 1              Year 2              Year 3              Year 4              Year 5

            Interest rate       7%                    8%                 8.5%               9.2%                  9%

            Other details over this period are shown below:

            Details             Year 1              Year 2              Year 3              Year 4              Year 5

            Inflows:

            Salary              $65,000           $75,000           $82,000           $88,000           $90,000

            Investments     $5,000              $10,000           $12,000           $11,000           $78,000

            Outflows:

            Taxation          $ 8,000           $10,000           $14,000           $16,000           $15,000

Solutions

Expert Solution

For the Interest only loan, only interest is to be paid periodically. Principal needs to be repaid at the end of the term of the loan. In the instant case, interest is to be paid annually, in arrears. This means interest is to be paid at the end of each year. Principal is to be repaid at the end of year 5.

Purchasing power is the net surplus of each year, after meeting all the loan obligations. Purchasing power of each year is as follows:

Year 1: $56,400

Year 2:$68,600

Year 3: $73,200

Year 4: $75,640

Year 5: $65,800

Computation as follows:


Related Solutions

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year...
calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year for 10 years, starting on 1/1/2010. All calculations must be shown, i.e., do not use a “package” to complete this question.   Loan period starts from 1/1/2010. I mean the first payment is to be made on 1/1/2010.
QUESTION 1 A $150,000 loan is to be amortized over 7 years, with annual end-of-year payments....
QUESTION 1 A $150,000 loan is to be amortized over 7 years, with annual end-of-year payments. Which of these statements is CORRECT? a. The proportion of interest versus principal repayment would be the same for each of the 7 payments. b. The proportion of each payment that represents interest versus repayment of principal would be higher if the interest rate were higher. c. The proportion of each payment that represents interest as opposed to repayment of principal would be higher...
You borrow $400,000 over a 20​ year term. The loan is structured as an amortized loan...
You borrow $400,000 over a 20​ year term. The loan is structured as an amortized loan with annual payments and an interest rate of 8​%. Complete the cells in the amortization schedule below. Year Payment​ ($) Interest in Payment​ ($) Principal Repaid​ ($) Principal Owing at End of Year​ ($) 1 2
You borrow ​$400,000 over a 20​ year term. The loan is structured as an amortized loan...
You borrow ​$400,000 over a 20​ year term. The loan is structured as an amortized loan with annual payments and an interest rate of 8​%. Complete the cells in the amortization schedule below. Year Payment​ ($) Interest in Payment​ ($) Principal Repaid​ ($) Principal Owing at End of Year​ ($) 1 2
$100,000 Amortizing Loan 9% stated rate 20-year amortization 5-year balloon Annual Payments a) Calculate annual payment...
$100,000 Amortizing Loan 9% stated rate 20-year amortization 5-year balloon Annual Payments a) Calculate annual payment b) Calculate balloon payment c) Value at 12% yield d) Prepare an amortization table
What is the annual payment on a $10,000 loan, 7% interest for 5 years?
What is the annual payment on a $10,000 loan, 7% interest for 5 years?
Suppose that an investor with a 5 year investment horizon is considering purchasing a 7 year,...
Suppose that an investor with a 5 year investment horizon is considering purchasing a 7 year, 9% coupon bond selling at par. The investor expects that he can reinvest the coupon at an annual interest rate of 9.4% and that at the end of the investment horizon 5 year bond will be selling to offer a yield to maturity of 11.2%. What is the total return for this bond?
Determine the annual payment on a $19,500 loan that is to be amortized over a four-year...
Determine the annual payment on a $19,500 loan that is to be amortized over a four-year period and carries a 10 percent interest rate. Also prepare a loan amortization schedule for this loan.
Determine the annual payment on a $17,000 loan that is to be amortized over a four-year...
Determine the annual payment on a $17,000 loan that is to be amortized over a four-year period and carries a 10 percent interest rate. Also prepare a loan amortization schedule for this loan.
Build a short-term loan model, allowing terms out to 5 years. Take the term, annual interest...
Build a short-term loan model, allowing terms out to 5 years. Take the term, annual interest rate, and principal balance as inputs. Either calculate the required payment or use a payment input cell. Use your model to answer the following questions: - with a term of 5 years and a rate of 5%, what should payments be for a $10,000 loan - how many months will it take to pay off the loan if payments are $1,000 - if all...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT