Question

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 $70,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.3% p.a. effective.

1. Calculate the size of the level quarterly repayment.
2. How much money does Geoffrey owe on this loan after 1 year?
3. How much interest does Geoffrey pay in the first year?
4. Geoffrey believes that the overall benefit from this agreement amounts to $355.82922901913 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 $70,000 and this weekly benefit of $355.82922901913, calculate the interest rate that represents the return on this investment, expressed as a nominal annual rate compounding weekly.

note: only Q1, 3 and 4 thankyou

Answer 1

Questions are not numbered, hence I am not able to figure out which one is 1, which one is 3 and which one is 4. I will therefore answer all of them.

Calculate the size of the level quarterly repayment.

Rate per quarter = (1 + 3.3%)^1/4 - 1 = 0.8150%

The size of the level quarterly repayment

= PMT (Rate, Nper, PV, FV, Type)

= PMT (0.8150%, 4 x 5, -70000, 0, 0)

= $ 3,807.20

How much money does Geoffrey owe on this loan after 1 year?

After 1 year, only 4 years will be remaining.

Amount outstanding after 1 year = -PV (Rate, Nper, PMT, FV) = - PV (0.8150%, 4 x 4, 3807.20, 0) = 56,894.01

How much interest does Geoffrey pay in the first year?

Interest paid in the first year = interest paid in first 4 payments = -CUMIPMT(Rate, Nper, PV, Start, End, Type) = -CUMIPMT(0.8150%, 4*5, 70000,1,4,0) = 2,122.82

Calculate the interest rate that represents the return on this investment, expressed as a nominal annual rate compounding weekly.

Hence, weekly interest rate = Rate (Nper, PMT, PV, FV) = Rate (5 x 52, 355.82922901913, -70000, 0) = 0.2248%

Hence, the interest rate that represents the return on this investment, expressed as a nominal annual rate compounding weekly = 0.2248% x 52 = 11.6900%