Question

In: Finance

3. a) Consider an annuity of 6 cash flows of $5,000 payable annually. If the interest...

3. a) Consider an annuity of 6 cash flows of $5,000 payable annually. If the interest rate is 7 per cent per annum, what is the value of this annuity today if the first cash flow is to be paid immediately? [8 marks]

3.  b) You are considering the purchase of a home for $700,000. You have available a deposit of $100,000. The bank will lend you money at 7 per cent per annum compounded monthly over a period up to 20 years. If you borrow the required funds over 20 years, what are the monthly repayments? After two years, how much do you still ow the bank? What is the interest component of the 25th repayment? [7 marks]

Solutions

Expert Solution

Sol:

a) Present value of Annuity =

here,

C = cash flow per periods, = $5000

i = interest rate =7% or 0.07

n= number of payments =1 year

so, Present value of Annuity(after 1st year) = $5000 * [1-(1+0.07)-1 ] / 0.07

= $5000 * [1-(1/1.07)] /0.07

= $5000 * [1- 0.9345] / 0.07

= $5000 * 0.0655/0.07

= $4678.57

b) Full amount required to purchase home = $700000

Amount available as deposit = $100000

Required fund from Bank as loan(P) =($700000 - $100000) = $600000

Interest rate(i) = 7% or 0.07

Period(n) = 20 years

Calculation of Monthly Payment:

Monthly payment formula

A = P * [ i (1+i)n  / (1+i)n  - 1]

Monthly Payments(A)= $600000 * [0.07 (1+0.07)20 / (1+0.07)20 -1]

A = $4651.79

Calculation of interest component of the 25th repayment:

the interest component of the 25th repayment = $3,327.45

Periods Beginning Balance Interest Principal Ending Balance
1 $600,000.00 $3,500.00 $1,151.79 $598,848.21
2 $598,848.21 $3,493.28 $1,158.51 $597,689.69
3 $597,689.69 $3,486.52 $1,165.27 $596,524.42
4 $596,524.42 $3,479.73 $1,172.07 $595,352.36
5 $595,352.36 $3,472.89 $1,178.90 $594,173.45
6 $594,173.45 $3,466.01 $1,185.78 $592,987.67
7 $592,987.67 $3,459.09 $1,192.70 $591,794.97
8 $591,794.97 $3,452.14 $1,199.66 $590,595.31
9 $590,595.31 $3,445.14 $1,206.65 $589,388.66
10 $589,388.66 $3,438.10 $1,213.69 $588,174.97
11 $588,174.97 $3,431.02 $1,220.77 $586,954.19
12 $586,954.19 $3,423.90 $1,227.89 $585,726.30
Year #1 End
13 $585,726.30 $3,416.74 $1,235.06 $584,491.24
14 $584,491.24 $3,409.53 $1,242.26 $583,248.98
15 $583,248.98 $3,402.29 $1,249.51 $581,999.47
16 $581,999.47 $3,395.00 $1,256.80 $580,742.68
17 $580,742.68 $3,387.67 $1,264.13 $579,478.55
18 $579,478.55 $3,380.29 $1,271.50 $578,207.05
19 $578,207.05 $3,372.87 $1,278.92 $576,928.13
20 $576,928.13 $3,365.41 $1,286.38 $575,641.75
21 $575,641.75 $3,357.91 $1,293.88 $574,347.86
22 $574,347.86 $3,350.36 $1,301.43 $573,046.43
23 $573,046.43 $3,342.77 $1,309.02 $571,737.41
24 $571,737.41 $3,335.13 $1,316.66 $570,420.75
Year #2 End
25 $570,420.75 $3,327.45 $1,324.34 $569,096.41

Calculation of Balance Owe to the bank after 2nd year:

Periods Beginning Balance Interest Principal Ending Balance
1 $600000 $41547.82 $14273.66 $585726.30
2 $585726.30 $40515.97 $15305.51 $570420.75

Related Solutions

Consider an annuity consisting of three cash flows of $8,000 each. If the interest rate is 6%, what is the present value (today) of the annuity if the first cash flow occurs
Consider an annuity consisting of three cash flows of $8,000 each. If the interest rate is 6%, what is the present value (today) of the annuity if the first cash flow occurs:a) Todayb) One year from todayc) Two years from todayd) Five years from today
A loan is to be repaid by annuity payable annually in arrears. The annuity starts at...
A loan is to be repaid by annuity payable annually in arrears. The annuity starts at rate of Kshs. 300 per annum and increases each year by Kshs. 30 per annum. The annuity is repaid for 20 years and repayments are calculated using a rate of interest of 7% per annum effective. Calculate i) The original amount of the loan [1Mk] ii) The capital outstanding immediately after 5th payment has been made [2Mks] iii) The capital and interest components of...
Consider an annuity consisting of three cash flows of $8,000 each.
Consider an annuity consisting of three cash flows of $8,000 each. If the interest rate is 6%, what is the present value (today) of the annuity if the first cash flow occurs:a) Todayb) One year from todayc) Two years from todayd) Five years from today
Consider an ordinary annuity with growing cash flows. The annuity’s first cash flow is given by...
Consider an ordinary annuity with growing cash flows. The annuity’s first cash flow is given by C1>0, the periodic rate of growth of the cash flows is fixed at g, and the periodic discount rate equals r, where 0<g<r<∞. Please, use the equation for the PV of growing perpetuity (i.e. PV=C1/(r-g)) to derive the equation for the present value of a growing ordinary annuity with t payments, where t is an integer greater than 2. Simplify your answer as much...
A.Calculate the present value of an annuity of $5,000 received annually that begins today and continues...
A.Calculate the present value of an annuity of $5,000 received annually that begins today and continues for 10 years, assuming a discount rate of 9%. B. Joan invested $5,000 in an interest-bearing account earning an 8% annual rate of interest compounded monthly. How much will the account be worth at the end of 5 years, assuming all interest is reinvested at the 8% rate? C. Calculate the present value of an ordinary annuity of $5,000 received annually for 10 years,...
A company borrows $10,000 and issues a 5-year, 6% installment note with interest payable annually. The...
A company borrows $10,000 and issues a 5-year, 6% installment note with interest payable annually. The factor for the present value of an annuity at 6% for 5 years is 4.2124. The factor for the present value of a single sum at 6% for 5 years is 0.7473. The present value of the interest payments is $2,527.44.
6. Calculate the value of the cash flows at time 6. The interest rate is 9.9%....
6. Calculate the value of the cash flows at time 6. The interest rate is 9.9%. 0 1 2 $1,120 $2,163 $3,290 7. In 1998, the average price of a gallon of gas was $1.01. Today, the average price of a gallon of gas is $2.87. At what annual rate has a gallon of gas increased over the last 20 years? (Answer as a percent. Enter only numbers and decimals in your response. Round to 2 decimal places.) 8. You...
1. Using Table 1---Find the Future Value of $5,000 at 6% interest compounded semi-annually for 2...
1. Using Table 1---Find the Future Value of $5,000 at 6% interest compounded semi-annually for 2 years. $5,627.55 $5.835.64 $5,527.55 $5,735.64 2.Using Table 2---Find the Compound Interest on $2,500 at .75% interest compounded daily by Leader Financial Bank for 20 days. $1.02 $10.30 $1.03 $6.31 3.Using Table 3---Find the amount of money that needs to be invested in order to have $1,500 in 3 years if you would receive 2.5% interest compounded annually.    $1,376.45 $1,403.56 $1,259.35 $1,392.90 4.Using Table 1---Find...
Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000...
Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000 $2,200 $3,300 $2,500 $2,500 $2,300 $2,100 A. Payback The company requires all projects to payback within 3 years. Calculate the payback period. Should it be accepted or rejected? B. Discounted Payback Calculate the discounted payback using a discount rate of 10%. Should it be accepted or rejected? C. IRR Calculate the IRR for this project. Should it be accepted or rejected? D. NPV Calculate...
16. Uneven cash flows A series of cash flows may not always necessarily be an annuity....
16. Uneven cash flows A series of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the concept of the time value of money will continue to apply. Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next five years: Annual Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 $250,000 $37,500 $180,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT