Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

use excel for following calculations. 1) Geoffrey decides not to buy the car mentioned earlier. Instead, he is now considering a food delivery service You,

image text in transcribed

use excel for following calculations.

1) 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 $58,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 rst payment being exactly 3 months from today. Again, the interest rate on Geoffrey's account is 4.5% p.a. effective. A) Geoffrey believes that the overall benefit from this agreement amounts to $297.23726367238 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 $58,000 and this weekly benefit of $297.23726367238, calculate the interest rate that represents the return on this investment, expressed as a nominal annual rate compounding weekly 2) Gillian has entered the agreement with Geoffrey described above. She estimates that the costs of the delivery services she has promised to Geoff rex (petrol, insurance, wear and tear, etc) amount to $1188.5532354973 per month in advance for the coming 5 years. (a) The money she receives from Geoffrey ($58000) can be considered a loan, with repayments being the value of the services she provides in return. What is the interest rate, expressed as an effective annual rate, she is being charged on this "loan

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Healthcare Finance An Introduction To Accounting And Financial Management

Authors: Louis Gapenski PhD

3rd Edition

1567932320, 978-1567932324

More Books

Students also viewed these Finance questions

Question

In Problem evaluate each expression. 10!/9!

Answered: 1 week ago

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago

Question

Define Management by exception

Answered: 1 week ago