In: Finance
Geoffrey decides not to buy the car mentioned earlier. Instead, he is now considering a food delivery service "You, bars, meats" that his friend Gillian has recently started. Gillian has agreed that for a single payment of $62,000 today to help her launch her business, she will provide all the delivery services that Geoffrey needs for his business for the next 5 years. Geoffrey is considering borrowing the full amount from his business account. Suppose that Geoffrey makes level quarterly repayments over the coming 5 years, the first payment being exactly 3 months from today. Again, the interest rate on Geoffrey's account is 3.6% p.a. effective.
(a) Calculate the size of the level quarterly repayment.
(b) How much money does Geoffrey owe on this loan after 1 year?
(c) How much interest does Geoffrey pay in the first year?
(d) Geoffrey believes that the overall benefit from this agreement amounts to $308.71353406919 per week in arrears (this would include money he would have spent on alternative delivery services, estimated additional profits from using Gillian's services, etc). By considering only the initial cost of $62,000 and this weekly benefit of $308.71353406919, calculate the interest rate that represents the return on this investment, expressed as a nominal annual rate compounding weekly.
A.
Loan amount (P)= 62000
Number of quarterly payments in 5 years (n)= 5*4= 20
Interest rate on loan is 3.6% effective.
It means effective annual rate is 3.6%
Effective Annual rate formula = ((1+quarterly rate)^number of quarter in year))-1
3.6% = ((1+I)^4)-1
1+0.036=( 1+I)^4
(1.036)^(1/4)= 1+i
1.00888099-1= i
I or Quarterly rate =0.008880990008
Equal level Payment formula = P* i *((1+i)^n)/((1+i)^n-1)
=62000*0.008880990008*((1+0.008880990008)^20)/(((1+0.008880990008)^20)-1)
=3397.165841
So size of level equal Quarterly Payment is $3397.17
B.
Number of quarter left After 1 Year (n)= 4*4=16
Loan value Balance at n time Formula = Periodical Payment*(1-(1/(1+i)^n))/i
=3397.165841*(1-(1/(1+0.008880990008)^16))/0.008880990008
=50461.24132
So after 1 Year Amount owed on loan is $50461.24
C.
Principal repaid = loan balance at Beginning - loan balance at year end
=62000-50461.24
=11538.76
Interest paid formula = (number of payment in year * quarterly payment)- principal repaid
=(4*3397.17)-11538.75868
=2049.92132
So interest paid in first year is $2049.92
D.
Weekly income or receipt =308.71353406919
Investment = 62000
Rate of Return formula = weekly benefits or Income/Investment
=308.71353406919/62000
=0.00497925055
Annual rate of Return = weekly rate * Number of weeks in Year
=0.00497925055*52
=0.2589210286 or 25.89%
So Nominal Annual rate of return earned on investment is 25.89%