Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Today is 1 January 2020. Jake just used $400,000 ($200,000 is from Jakes own investment and $200,000 is raised by taking a 5-year loan) to

Today is 1 January 2020. Jake just used $400,000 ($200,000 is from Jakes own investment and $200,000 is raised by taking a 5-year loan) to purchase a cafe franchise. To operate this business, Jake needs to pay rent, maintenance costs, labour costs and loan repayments.

Jake took a 5-year $200,000 loan from MQ bank. Jake needs to make 60 monthly repayment with an amount of $3,800. The loan repayment will be paid by the end of each month. This package has an annual fee of $200. The package fee is paid on 30 June of each year during the following five-year period. The first one will be paid on 30 June 2020. This loan will be fully repaid by the end of 5 years.

Rent will be paid by the end of each quarter with an amount of $12,000. Labour cost will be paid by the end of each month with an amount of $10,000.

Maintenance cost will be paid by the end of each half year with an amount of $15,000.

Jake predicts that this cafe franchise initially can have monthly revenue of $24,000. Assume that Jake can obtain this amount by the end of each month. Jake forecasts that this revenue amount will increase at the rate of y% p.a. The revenue increase will only happen at the beginning of each year. For example, this cafe franchise initially has monthly revenue of $24,000 in 2020. Then the revenue amount will become $24,000(1+y%) per month in 2021 and $24, 000(1 + y%)2 per month in 2021 2022. Jake assumes the value of y is the same as the Australian CPI rate for 2019. You need to use FactSet to find the Australian CPI rate for 2019.

The franchise has a term of 5 years. If Jake chooses not to renew the franchise, he needs to terminate this business by 31 December 2024.

Question: If Jake chooses not to renew the franchise, use the given information regarding costs and revenue to calculate Jakes effective yearly return rate (j1) over this five-year investment period.

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

Forecasting And Predictive Analytics With Forecast X

Authors: Barry Keating, J. Holton Wilson, John Solutions Inc.

7th International Edition

1260085236, 9781260085235

More Books

Students also viewed these Finance questions

Question

What software can be used for AHP?

Answered: 1 week ago

Question

Explain limitations on confidentiality inherent in group therapy.

Answered: 1 week ago

Question

Discuss the five steps that can be used to conduct a task analysis

Answered: 1 week ago

Question

Discuss the purpose and advantages of conducting a needs assessment

Answered: 1 week ago