Question: Please show working out and answer in excel formula, for each question leave the answer at 2 dp but use the exact amount for continuing

Please show working out and answer in excel formula, for each question leave the answer at 2 dp but use the exact amount for continuing question

Please show working out and answer in excel formula, for each questionleave the answer at 2 dp but use the exact amount for

Question 5 Not yet saved Marked out of 1.00 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 $52,000 today to help her launch her business, she will provide all the delivery services that Geoffdrey needs for his business for the next 5 years. Geoffrey is considering borrowing the full amount from his business account. Suppose that GeoffOrey makes level quarterly repayments over the coming 5 years, the fiarst payment being exactly 3 months from today. Again, the interest rate on Geoffrey's account is 4.1% p.a. effective. (a) Calculate the size of the level quarterly repayment. P Flag question Answer: Question 6 Not yet save (b) How much money does Geoffrey owe on this loan after 1 year? Marked out of 1.00 Answer: P Flag question Question 7 Not yet saved (C) How much interest does Geoffrey pay in the first year? Marked out of 1.00 Answer: P Flag question Question 8 Not yet saved (d) Geoffdrey believes that the overall benefit from this agreement amounts to $260.40044439178 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 $52,000 and this weekly benefit of $260.40044439178, calculate the interest rate that represents the return on this investment, expressed as a nominal annual rate compounding weekly. Marked out of 2.00 P Flag

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!