Question

Bonus Problem 2 (30 marks) Helena has $12000 at time 0 and is interested in buying an 5-year annuity-immediate which is curre
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Bacsically IRR concept says that, it is the rate at which the Present Value of Cash Inflows will be equal to the Present value of cashout flows. So to know the Cash Inflows and Cash Outflows please go through the following schedules

Points to be noted:

1.The loan taken by the Helena will be get repaid in 9 months. It is shown in the loan repayment schedule

2.For CashFlow Schedule:

Cashinflow(A) is Cash getting from the Anuuity fund

Cashinflow(B) is interest getting from the investment

Cashoutflow(A) is amount invested in investment (Note:This is the same amount which she got from annuity)

Cashoutflow(B) is amount repaid as a part of loan

3. Method we choose for getting IRR is Trail and Error

Solution: IRR is  23.25%.

Assumption:

1. There is an assumption considered that the Interest getting on the Investment is not getting accumulated

Add a comment
Know the answer?
Add Answer to:
Bonus Problem 2 (30 marks) Helena has $12000 at time 0 and is interested in buying...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Problem 2 (Required, 25 marks) Tina borrows an amount $500000 from the bank and agrees to repay the loan by 4n leve...

    Problem 2 (Required, 25 marks) Tina borrows an amount $500000 from the bank and agrees to repay the loan by 4n level monthly payments (with amount X) made at the end of every month. The first repayment will be made 1 month after today. You are given that • The loan charges interest at an annual nominal interest rate 5.9% convertible continuously. • The outstanding balance at 25th repayment date is OLBs = 397021.93. (a) Calculate the interest due and...

  • Problem 3 (Required, 25 marks) Recently, Mr. A has 2 outstanding loans: • Loan A -...

    Problem 3 (Required, 25 marks) Recently, Mr. A has 2 outstanding loans: • Loan A - He needs to repay $1720 at the end of every month and there are 36 repayments remaining. The loan charges interest at an annual nominal interest rate 12% compounded monthly Loan B - He needs to repay an amount X at the end of every month and there are 36 repayments remaining. The loan charges interest at an annual nominal interest rate 18% compounded...

  • Problem 4 (Required, 25 marks) Recently, a company has borrowed an amount of $300,000 from the...

    Problem 4 (Required, 25 marks) Recently, a company has borrowed an amount of $300,000 from the bank. The company will pay the interest payment interest due) to the bank at the end of every month until the loan principal is repaid. The bank charges interest rate at an annual nominal interest rate 10% compounded continuously. At the same time, the company makes a monthly deposit $600 into a sinking fund at the end of every month. The sinking fund earns...

  • Problem 1 (Required, 25 marks) A borrower has borrowed $2000000 from the bank. It is given...

    Problem 1 (Required, 25 marks) A borrower has borrowed $2000000 from the bank. It is given that the loan charges interest at an annual effective interest rate 16.0755% and compound interest is assumed. (a) Suppose that the borrower decides to repay the loan by 180 monthly payments made at the end of every month, (i) Using retrospective method, calculate the outstanding balance at 60th repayment date. (ii) Calculate the interest due and principal repaid in 120th repayment. (b) Suppose that...

  • Please answer a-bneeds to show workings no excel (10+5+15-30 narks) Question 2: Application of Time Value...

    Please answer a-bneeds to show workings no excel (10+5+15-30 narks) Question 2: Application of Time Value of Money (Mortgages) (30 marks) Suppose your parents wish to buy a house whose current market value is $1 50,000. They have approached a loan officer at the Bank of Nova Scotia who offers them 25-year mortgage financing for 75% of the purchase price at a rate of 6.75%, Payments are to be made on a monthly basis even though the bank is required...

  • I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value...

    I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...

  • An investor can invest money with a particular bank and eam a stated interest rate of...

    An investor can invest money with a particular bank and eam a stated interest rate of 15.40%; however, interest w be compounded quarterly. What are the nominal, periodic, and effective interest rates for this investment opportunity? Interest Rates Nominal rate Periodic rate Effective annual rate Rahul needs a loan and is speaking to several lending agencies about the interest rates they would charge and the terms they offer. He particularly likes his local bank because he is being offered a...

  • Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question...

    Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...

  • SHORT ANSWERS please USE THE FORMAT a - b - c - d 5-Which type of...

    SHORT ANSWERS please USE THE FORMAT a - b - c - d 5-Which type of annuity best describes the insurance premium that you have to pay at the beginning of each period? a. Annuity due b. Deferred annuity c. Ordinary annuity d. Annuity in arrears 6-Richard takes the opinion of his investment advisor to invest any excess savings that he has. His advisor told him about a new issue of AAA rated bonds. Richard decided to buy a total...

  • a.   Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer...

    a.   Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the Excel function wizard. Inputs: PV = 1000 I/YR = 10% N = 5 Formula: FV = PV(1+I)^N = Wizard (FV): $1,610.51 Note: When you use the wizard and fill in the menu items, the result is the formula you see on the formula line if you click on cell E12. Put the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT