Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Solve using Excel (with screenshots of calculations). For dollar amounts, give your answer to the nearest cent and do not include any currency signs. For

Solve using Excel (with screenshots of calculations). For dollar amounts, give your answer to the nearest cent and do not include any currency signs. For interest rates, give our answer as a percentage rounded to 2 decimal places. For each question, some parts of the question may use values from earlier parts. In these cases, use the exact values from the earlier parts, not the rounded values.

Steven is considering a food delivery service "You, bars, meats" that his friend Julia has recently started. Julia 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 Steven needs for his business for the next 5 years. Steven is considering borrowing the full amount from his business account.

Suppose that Steven makes level quarterly repayments over the coming 5 years, the first payment being exactly 3 months from today. The interest rate on Steven's account is 4.5% p.a. effective.

  1. Calculate the size of the level quarterly repayment.
  2. How much money does Steven owe on this loan after 1 year?
  3. How much interest does Steven pay in the first year?
  4. Steven believes that the overall benefit from this agreement amounts to $248.30333868814 per week in arrears (this would include money he would have spent on alternative delivery services, estimated additional profits from using Julias services, etc.) By considering only the initial cost of $52,000 and this weekly benefit of $248.30333868814, calculate the interest rate that represents the return on this investment, expressed as a nominal annual rate compounding weekly.

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_2

Step: 3

blur-text-image_3

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

Personal Finance Turning Money Into Wealth

Authors: Arthur J. Keown

6th Edition

0132719169, 978-0132719162

More Books

Students also viewed these Finance questions

Question

Give examples of the impact of the Internet on small businesses.

Answered: 1 week ago

Question

Avoid evasiveness. Be direct with your answers when possible.

Answered: 1 week ago

Question

=+ Where would most corporations like the balance to fall?

Answered: 1 week ago